7819
Table: SURVEY
SURVEY
Entity
Published / External
7802
Biscayne Bay Dolphin Photo ID System
Data Set
Completed
Master Survey Data Table
Loaded by batch 2223, 08-11-2008 14:27
Data Table
Yes
DOLPHINPHOTO
Master Survey Data Table
1
ID
NUMBER
22
Yes
Yes
38
Active
Sequential Key
NUMBER
2
PARTNER_CODE
VARCHAR2
5
Yes
No
Active
Link to Partner Table
VARCHAR2
3
ZONE_CODE
VARCHAR2
5
No
No
Active
Lnk To Zone Table
VARCHAR2
4
SURVEY_DATE
DATE
7
Yes
No
Active
Date of Survey
DATE
5
IS_COMPLETE
VARCHAR2
1
No
No
Active
Is The Survey Complete
VARCHAR2
6
START_TIME
VARCHAR2
4
No
No
Active
Local Time Of Day That The Survey Started
VARCHAR2
7
END_TIME
VARCHAR2
4
No
No
Active
Local Time Of Day That The Survey Ended
VARCHAR2
8
TOTAL_TIME
VARCHAR2
4
No
No
Active
Total Time In Survey Where Hundred and Yhousands Place Indicates Hours and Ten and Ones place indicates minutes
VARCHAR2
9
TOTAL_HOUR
NUMBER
22
No
No
38
Active
Total Number Of Hours In Survey
NUMBER
10
TOTAL_MINUTES
NUMBER
22
No
No
38
Active
Total Number Of mInutes In The Survey. THis is a number between 0 and 59
NUMBER
11
WEATHER_CODE
NUMBER
22
No
No
38
Active
Code Indicating Weather Coditions At Time Of Survey
NUMBER
12
BEAUFORT_STATE_CODE
NUMBER
22
No
No
38
Active
Beaufort State Code
NUMBER
13
MOON_PHASE_CODE
NUMBER
22
No
No
38
Active
Code To Indicate Phase Of The Moon
NUMBER
14
WATER_TEMPERATURE
NUMBER
22
No
No
38
Active
Code To Indicate Water Temperature
NUMBER
15
START_TIDE_CODE
NUMBER
22
No
No
38
Active
Code Indicating Tide Code At Start Of The Survey
NUMBER
16
END_TIDE_CODE
NUMBER
22
No
No
38
Active
Code Indicating Tide Code At Endt Of The Survey
NUMBER
17
COMMENTS
VARCHAR2
4000
No
No
Active
Any Other Pertinent Comments ABout This Record
VARCHAR2
18
CREATED_BY_USER_ID
NUMBER
22
Yes
No
38
Active
Oracle User Code Of Person Who Created This Record
NUMBER
19
CREATED_DATE
DATE
7
Yes
No
Active
Control Column Indicating When This Record Was Created
DATE
20
MODIFIED_BY_USER_ID
NUMBER
22
No
No
38
Active
Oracle User Code Of Person Who Last Modified This Record
NUMBER
21
MODIFIED_DATE
DATE
7
No
No
Active
Control Column Indicating When This Record Was Last Modified
DATE
gov.noaa.nmfs.inport:7819
Lee Weinberger
2008-08-11T14:27:40
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