Slide Menu
InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.2.3. Downtime Schedule Tuesday, November 29, 2022 12:00pm - 1:30pm Eastern / 10:00am - 11:30pm Pacific / 7:00am - 8:30pm Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheries.noaa.gov/inportserve/waf What's...
View All
Search Help Show/Hide Menu

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