Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

View of photo with decodes

Description

View of photo with decodes

Entity Information

Entity Type
Data View

Data Attribute / Type Description
IMAGE_ID
NUMBER
Image Key
IMAGE_NAME
VARCHAR2
Name Of image
DOLPHIN_ID
VARCHAR2
Link to DolphinID Table
DOLPHIN_NAME
VARCHAR2
Name Of Dolphin
PARTNER_CODE
VARCHAR2
Link to Partner Table
PARTNER_NAME
VARCHAR2
Partner (Agency) Name
SURVEY_DATE
VARCHAR2
Date Of Survey
FIN_TYPE_CODE
NUMBER
Code to indicate type of Fin
FIN_TYPE_NAME
VARCHAR2
Type Of Fin
DORSAL_RATIO
VARCHAR2
Dorsal ratio
STANDARD_ID
VARCHAR2
Standard ID
DESCRIPTION
VARCHAR2
Description Of Standard ID
IS_PUBLISHABLE
NUMBER
Indicates If Image is publishable
PUBLIC_NOTES
VARCHAR2
Any public notes On this record
RANGEMAP_NAME
VARCHAR2
Name Of file associated with image

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Item Identification

Title: View: IMAGES_VW
Short Name: IMAGES_VW
Status: Completed
Abstract:

View of photo with decodes

Notes:

Loaded by batch 2223, 08-11-2008 14:27

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: DOLPHINPHOTO
Description:

View of photo with decodes

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
IMAGE_ID NUMBER Image Key
100
IMAGE_NAME VARCHAR2 Name Of image
100
DOLPHIN_ID VARCHAR2 Link to DolphinID Table
100
DOLPHIN_NAME VARCHAR2 Name Of Dolphin
100
PARTNER_CODE VARCHAR2 Link to Partner Table
100
PARTNER_NAME VARCHAR2 Partner (Agency) Name
100
SURVEY_DATE VARCHAR2 Date Of Survey
100
FIN_TYPE_CODE NUMBER Code to indicate type of Fin
100
FIN_TYPE_NAME VARCHAR2 Type Of Fin
100
DORSAL_RATIO VARCHAR2 Dorsal ratio
100
STANDARD_ID VARCHAR2 Standard ID
100
DESCRIPTION VARCHAR2 Description Of Standard ID
100
IS_PUBLISHABLE NUMBER Indicates If Image is publishable
100
PUBLIC_NOTES VARCHAR2 Any public notes On this record
100
RANGEMAP_NAME VARCHAR2 Name Of file associated with image

Attribute Details

IMAGE_ID

CC ID: 30898
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Image Key

General Data Type: NUMBER

IMAGE_NAME

CC ID: 30895
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 255
Required: Yes
Primary Key: No
Status: Active
Description:

Name Of image

General Data Type: VARCHAR2

DOLPHIN_ID

CC ID: 30891
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

Link to DolphinID Table

General Data Type: VARCHAR2

DOLPHIN_NAME

CC ID: 30900
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Name Of Dolphin

General Data Type: VARCHAR2

PARTNER_CODE

CC ID: 30886
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 5
Required: Yes
Primary Key: No
Status: Active
Description:

Link to Partner Table

General Data Type: VARCHAR2

PARTNER_NAME

CC ID: 30896
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Partner (Agency) Name

General Data Type: VARCHAR2

SURVEY_DATE

CC ID: 30892
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Date Of Survey

General Data Type: VARCHAR2

FIN_TYPE_CODE

CC ID: 30897
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Code to indicate type of Fin

General Data Type: NUMBER

FIN_TYPE_NAME

CC ID: 30890
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Type Of Fin

General Data Type: VARCHAR2

DORSAL_RATIO

CC ID: 30887
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Dorsal ratio

General Data Type: VARCHAR2

STANDARD_ID

CC ID: 30894
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Standard ID

General Data Type: VARCHAR2

DESCRIPTION

CC ID: 30889
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Description Of Standard ID

General Data Type: VARCHAR2

IS_PUBLISHABLE

CC ID: 30899
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Indicates If Image is publishable

General Data Type: NUMBER

PUBLIC_NOTES

CC ID: 30888
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Any public notes On this record

General Data Type: VARCHAR2

RANGEMAP_NAME

CC ID: 30893
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Name Of file associated with image

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7813
GUID: gov.noaa.nmfs.inport:7813
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-08-11 14:27+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-04-29
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-04-29
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-04-29