7806
Table: DOLPHIN_HISTORY
DOLPHIN_HISTORY
Entity
Published / External
7802
Biscayne Bay Dolphin Photo ID System
Data Set
Completed
Data table listing history of the sightings of a dolphin
Loaded by batch 2223, 08-11-2008 14:27
Theme
dolphin sightings
Data Table
Yes
DOLPHINPHOTO
Data table listing history of the sightings of a dolphin
1
ID
NUMBER
22
Yes
Yes
38
Active
Sequential Key
NUMBER
2
DOLPHIN_ID
VARCHAR2
20
No
No
Active
Foreign Key To Dolphin ID Table
VARCHAR2
3
SIGHTING_ID
NUMBER
22
Yes
No
38
Active
Link To SIghting Table
NUMBER
4
PRELIMINARY_LETTER_ID
VARCHAR2
3
Yes
No
Active
Preliminary Letter ID
VARCHAR2
5
DOLPHIN_INFO_ID
NUMBER
22
Yes
No
38
Active
Link to Dolphin Photo Record
NUMBER
6
DORSAL_RATIO
VARCHAR2
5
No
No
Active
Dorsal Ratio
VARCHAR2
7
FIN_CATEGORY_CODE
VARCHAR2
3
No
No
Active
Category Code to Describing Fin
VARCHAR2
8
HAS_SCARS
VARCHAR2
1
No
No
Active
Are there scars on the dolphin
VARCHAR2
9
SCAR_DESCRIPTION
VARCHAR2
4000
No
No
Active
Description of scars
VARCHAR2
10
HAS_LESIONS
VARCHAR2
1
No
No
Active
Are The lesions on the dolphin
VARCHAR2
11
LESION_DESCRIPTION
VARCHAR2
4000
No
No
Active
Description Of The Lesions
VARCHAR2
12
FIN_TYPE_CODE
NUMBER
22
No
No
38
Active
Type Of Fin Code
NUMBER
13
CREATED_BY_USER_ID
NUMBER
22
Yes
No
38
Active
Oracle Userid of the creator of this record
NUMBER
14
CREATED_DATE
DATE
7
No
No
Active
Control Column Indicating When This Record Was Created
DATE
15
MODIFIED_BY_USER_ID
NUMBER
22
No
No
38
Active
Oracle Userid of the person who last modified
NUMBER
16
MODIFIED_DATE
DATE
7
No
No
Active
Control Column Indicating When This Record Was Last Modified
DATE
gov.noaa.nmfs.inport:7806
Lee Weinberger
2008-08-11T14:27:37
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