7807
Table: DOLPHIN_ID
DOLPHIN_ID
Entity
Published / External
7802
Biscayne Bay Dolphin Photo ID System
Data Set
Completed
Data table containing descriptive information about a dolphin
Loaded by batch 2223, 08-11-2008 14:27
Data Table
Yes
DOLPHINPHOTO
Data table containing descriptive information about a dolphin
1
ID
VARCHAR2
20
Yes
Yes
Active
Sequential Key
VARCHAR2
2
SURVEY_ID
NUMBER
22
No
No
38
Active
Foreign Key To Survey Table
NUMBER
3
NAME
VARCHAR2
30
No
No
Active
Name Of Dolphin (If known)
VARCHAR2
4
PARTNER_CODE
VARCHAR2
5
Yes
No
Active
Foreign Key To Partner Table
VARCHAR2
5
SEX_CODE
VARCHAR2
1
No
No
Active
Code To Indicate Sex Of Dolphin
VARCHAR2
6
LIFE_STAGE_CODE
VARCHAR2
1
No
No
Active
Life Stage Code
VARCHAR2
7
COMMENTS
VARCHAR2
4000
No
No
Active
Any extra comments On Dolphin Photo
VARCHAR2
8
CREATED_BY_USER_ID
NUMBER
22
Yes
No
38
Active
Oracle Userid of the creator of this record
NUMBER
9
CREATED_DATE
DATE
7
No
No
Active
Date Record was created
DATE
10
MODIFIED_BY_USER_ID
NUMBER
22
No
No
38
Active
Oracle Userid of the one who last modifed this record
NUMBER
11
MODIFIED_DATE
DATE
7
No
No
Active
Date Record was last modified
DATE
12
HAS_BIOPSY_ATTEMPT
VARCHAR2
1
No
No
Active
Was A Biopsy Attempted
VARCHAR2
13
HAS_HIT
VARCHAR2
1
No
No
Active
Was Dolphin Hit
VARCHAR2
14
HAS_SAMPLE_TAKEN
VARCHAR2
1
No
No
Active
Has a Biopsy Sample Been Taken From The Dolphin
VARCHAR2
gov.noaa.nmfs.inport:7807
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