Slide Menu
System Maintenance Notice, Sunday, January 23, 2022 @ 8am-2pm Eastern. The Operations Team will be performing system maintenance on all server environments. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

Item Identification

Title: Table: IMAGE
Short Name: IMAGE
Status: Completed
Abstract:

This is a test

Notes:

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

Entity Information

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

This is a test

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key ID NUMBER Sequential Key
100
IMAGE BLOB Actual image file
100
FILE_NAME VARCHAR2 Actual name of image file
100
PARTNER_CODE VARCHAR2 Partner Code
100
SURVEY_DATE DATE Date Of Survey
100
FIN_CATEGORY_CODE VARCHAR2 Fin category code
100
DESCRIPTION VARCHAR2 Description of photo
100
DOLPHIN_ID VARCHAR2 Key to dolphin table
100
DORSAL_RATIO NUMBER Dorsal ratio
100
PUBLIC_NOTES VARCHAR2 Any public notes on the image
100
IS_PUBLISHABLE NUMBER Indicates if the photo is publishable
100
UPLOADED_DATE DATE Uploaded date
100
HAS_SCARS VARCHAR2 Indicates if there are scars in the image
100
HAS_LESIONS VARCHAR2 Indicates if there are lesions in the image
100
FIN_TYPE_CODE NUMBER Fin type code
100
CREATED_BY_USER_ID NUMBER Oracle User Code Of Person Who Created This Record
100
CREATED_DATE DATE Date record was created
100
MODIFIED_BY_USER_ID NUMBER Oracle User Code Of Person Who LAST MODIFIED This Record
100
MODIFIED_DATE DATE time that record was last modified
100
STANDARD_ID VARCHAR2 Standard Id for linking

Attribute Details

ID

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

Sequential Key

General Data Type: NUMBER

IMAGE

CC ID: 30884
Seq. Order: 2
Data Storage Type: BLOB
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Actual image file

General Data Type: BLOB

FILE_NAME

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

Actual name of image file

General Data Type: VARCHAR2

PARTNER_CODE

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

Partner Code

General Data Type: VARCHAR2

SURVEY_DATE

CC ID: 30881
Seq. Order: 5
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date Of Survey

General Data Type: DATE

FIN_CATEGORY_CODE

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

Fin category code

General Data Type: VARCHAR2

DESCRIPTION

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

Description of photo

General Data Type: VARCHAR2

DOLPHIN_ID

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

Key to dolphin table

General Data Type: VARCHAR2

DORSAL_RATIO

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

Dorsal ratio

General Data Type: NUMBER

PUBLIC_NOTES

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

Any public notes on the image

General Data Type: VARCHAR2

IS_PUBLISHABLE

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

Indicates if the photo is publishable

General Data Type: NUMBER

UPLOADED_DATE

CC ID: 30874
Seq. Order: 12
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Uploaded date

General Data Type: DATE

HAS_SCARS

CC ID: 30873
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicates if there are scars in the image

General Data Type: VARCHAR2

HAS_LESIONS

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

Indicates if there are lesions in the image

General Data Type: VARCHAR2

FIN_TYPE_CODE

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

Fin type code

General Data Type: NUMBER

CREATED_BY_USER_ID

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

Oracle User Code Of Person Who Created This Record

General Data Type: NUMBER

CREATED_DATE

CC ID: 30869
Seq. Order: 17
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date record was created

General Data Type: DATE

MODIFIED_BY_USER_ID

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

Oracle User Code Of Person Who LAST MODIFIED This Record

General Data Type: NUMBER

MODIFIED_DATE

CC ID: 30867
Seq. Order: 19
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

time that record was last modified

General Data Type: DATE

STANDARD_ID

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

Standard Id for linking

General Data Type: VARCHAR2

Catalog Details

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