Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Marine Mammal and Turtle Division > SEFSC Marine Mammal Projects > Marine Mammals Miami > Biscayne Bay Dolphin Photo ID System > Biscayne Bay Dolphin Photo ID System >

Table: DOLPHIN_INFO

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:7808  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Data table listing INFORMATION ABOUT THE DOLPHIN

Description

Data table listing INFORMATION ABOUT THE DOLPHIN

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ID
NUMBER 		Sequential Key
SIGHTING_ID
NUMBER 		Foreign Key to SIghtings Table
DOLPHIN_ID
VARCHAR2 		Foreign Key to Dlphin_ID Table
NUMBER_OF_EXTRAS
NUMBER 		Number Of Extras
PRELIMINARY_LETTER_ID
VARCHAR2 		Preliminary Letter ID
IS_NEW_SIGHTING
VARCHAR2 		Is This A New Sighting
COMMENTS
VARCHAR2 		Any Comments About Dolphin
CREATED_BY_USER_ID
NUMBER 		Oracle Userid of the creator of this record
CREATED_DATE
DATE 		Date Record was create
MODIFIED_BY_USER_ID
NUMBER 		Oracle Userid of the person who last changed this record
MODIFIED_DATE
DATE 		Date That this record was last modified

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Item Identification

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

Data table listing INFORMATION ABOUT THE DOLPHIN
Notes:

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

Entity Information

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

Data table listing INFORMATION ABOUT THE DOLPHIN

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key ID NUMBER Sequential Key
100
 SIGHTING_ID NUMBER Foreign Key to SIghtings Table
100
 DOLPHIN_ID VARCHAR2 Foreign Key to Dlphin_ID Table
100
 NUMBER_OF_EXTRAS NUMBER Number Of Extras
100
 PRELIMINARY_LETTER_ID VARCHAR2 Preliminary Letter ID
100
 IS_NEW_SIGHTING VARCHAR2 Is This A New Sighting
100
 COMMENTS VARCHAR2 Any Comments About Dolphin
100
 CREATED_BY_USER_ID NUMBER Oracle Userid of the creator of this record
100
 CREATED_DATE DATE Date Record was create
100
 MODIFIED_BY_USER_ID NUMBER Oracle Userid of the person who last changed this record
100
 MODIFIED_DATE DATE Date That this record was last modified

Attribute Details

ID

CC ID: 30858
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

SIGHTING_ID

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

Foreign Key to SIghtings Table
General Data Type: NUMBER

DOLPHIN_ID

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

Foreign Key to Dlphin_ID Table
General Data Type: VARCHAR2

NUMBER_OF_EXTRAS

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

Number Of Extras
General Data Type: NUMBER

PRELIMINARY_LETTER_ID

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

Preliminary Letter ID
General Data Type: VARCHAR2

IS_NEW_SIGHTING

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

Is This A New Sighting
General Data Type: VARCHAR2

COMMENTS

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

Any Comments About Dolphin
General Data Type: VARCHAR2

CREATED_BY_USER_ID

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

Oracle Userid of the creator of this record
General Data Type: NUMBER

CREATED_DATE

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

Date Record was create
General Data Type: DATE

MODIFIED_BY_USER_ID

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

Oracle Userid of the person who last changed this record
General Data Type: NUMBER

MODIFIED_DATE

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

Date That this record was last modified
General Data Type: DATE

Catalog Details

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