7812
Table: IMAGE
IMAGE
Entity
Published / External
7802
Biscayne Bay Dolphin Photo ID System
Data Set
Completed
This is a test
Loaded by batch 2223, 08-11-2008 14:27
Data Table
Yes
DOLPHINPHOTO
This is a test
1
ID
NUMBER
22
Yes
Yes
38
Active
Sequential Key
NUMBER
2
IMAGE
BLOB
4000
No
No
Active
Actual image file
BLOB
3
FILE_NAME
VARCHAR2
255
Yes
No
Active
Actual name of image file
VARCHAR2
4
PARTNER_CODE
VARCHAR2
5
Yes
No
Active
Partner Code
VARCHAR2
5
SURVEY_DATE
DATE
7
No
No
Active
Date Of Survey
DATE
6
FIN_CATEGORY_CODE
VARCHAR2
5
No
No
Active
Fin category code
VARCHAR2
7
DESCRIPTION
VARCHAR2
4000
No
No
Active
Description of photo
VARCHAR2
8
DOLPHIN_ID
VARCHAR2
20
Yes
No
Active
Key to dolphin table
VARCHAR2
9
DORSAL_RATIO
NUMBER
22
No
No
38
Active
Dorsal ratio
NUMBER
10
PUBLIC_NOTES
VARCHAR2
4000
No
No
Active
Any public notes on the image
VARCHAR2
11
IS_PUBLISHABLE
NUMBER
22
No
No
38
Active
Indicates if the photo is publishable
NUMBER
12
UPLOADED_DATE
DATE
7
No
No
Active
Uploaded date
DATE
13
HAS_SCARS
VARCHAR2
1
No
No
Active
Indicates if there are scars in the image
VARCHAR2
14
HAS_LESIONS
VARCHAR2
1
No
No
Active
Indicates if there are lesions in the image
VARCHAR2
15
FIN_TYPE_CODE
NUMBER
22
No
No
38
Active
Fin type code
NUMBER
16
CREATED_BY_USER_ID
NUMBER
22
Yes
No
38
Active
Oracle User Code Of Person Who Created This Record
NUMBER
17
CREATED_DATE
DATE
7
No
No
Active
Date record was created
DATE
18
MODIFIED_BY_USER_ID
NUMBER
22
No
No
38
Active
Oracle User Code Of Person Who LAST MODIFIED This Record
NUMBER
19
MODIFIED_DATE
DATE
7
No
No
Active
time that record was last modified
DATE
20
STANDARD_ID
VARCHAR2
20
No
No
Active
Standard Id for linking
VARCHAR2
gov.noaa.nmfs.inport:7812
Lee Weinberger
2008-08-11T14:27:38
SysAdmin InPortAdmin
2022-08-09T17:11:01
2021-04-29
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-04-29
1 Year
2022-04-29