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_HISTORY

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

Summary

Abstract

Data table listing history of the sightings of a dolphin

Description

Data table listing history of the sightings of a dolphin

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ID
NUMBER 		Sequential Key
DOLPHIN_ID
VARCHAR2 		Foreign Key To Dolphin ID Table
SIGHTING_ID
NUMBER 		Link To SIghting Table
PRELIMINARY_LETTER_ID
VARCHAR2 		Preliminary Letter ID
DOLPHIN_INFO_ID
NUMBER 		Link to Dolphin Photo Record
DORSAL_RATIO
VARCHAR2 		Dorsal Ratio
FIN_CATEGORY_CODE
VARCHAR2 		Category Code to Describing Fin
HAS_SCARS
VARCHAR2 		Are there scars on the dolphin
SCAR_DESCRIPTION
VARCHAR2 		Description of scars
HAS_LESIONS
VARCHAR2 		Are The lesions on the dolphin
LESION_DESCRIPTION
VARCHAR2 		Description Of The Lesions
FIN_TYPE_CODE
NUMBER 		Type Of Fin Code
CREATED_BY_USER_ID
NUMBER 		Oracle Userid of the creator of this record
CREATED_DATE
DATE 		Control Column Indicating When This Record Was Created
MODIFIED_BY_USER_ID
NUMBER 		Oracle Userid of the person who last modified
MODIFIED_DATE
DATE 		Control Column Indicating When 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_HISTORY
Short Name: DOLPHIN_HISTORY
Status: Completed
Abstract:

Data table listing history of the sightings of a dolphin
Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None dolphin sightings

Entity Information

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

Data table listing history of the sightings of a dolphin

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key ID NUMBER Sequential Key
100
 DOLPHIN_ID VARCHAR2 Foreign Key To Dolphin ID Table
100
 SIGHTING_ID NUMBER Link To SIghting Table
100
 PRELIMINARY_LETTER_ID VARCHAR2 Preliminary Letter ID
100
 DOLPHIN_INFO_ID NUMBER Link to Dolphin Photo Record
100
 DORSAL_RATIO VARCHAR2 Dorsal Ratio
100
 FIN_CATEGORY_CODE VARCHAR2 Category Code to Describing Fin
100
 HAS_SCARS VARCHAR2 Are there scars on the dolphin
100
 SCAR_DESCRIPTION VARCHAR2 Description of scars
100
 HAS_LESIONS VARCHAR2 Are The lesions on the dolphin
100
 LESION_DESCRIPTION VARCHAR2 Description Of The Lesions
100
 FIN_TYPE_CODE NUMBER Type Of Fin Code
100
 CREATED_BY_USER_ID NUMBER Oracle Userid of the creator of this record
100
 CREATED_DATE DATE Control Column Indicating When This Record Was Created
100
 MODIFIED_BY_USER_ID NUMBER Oracle Userid of the person who last modified
100
 MODIFIED_DATE DATE Control Column Indicating When This Record Was Last Modified

Attribute Details

ID

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

DOLPHIN_ID

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

Foreign Key To Dolphin ID Table
General Data Type: VARCHAR2

SIGHTING_ID

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

Link To SIghting Table
General Data Type: NUMBER

PRELIMINARY_LETTER_ID

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

Preliminary Letter ID
General Data Type: VARCHAR2

DOLPHIN_INFO_ID

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

Link to Dolphin Photo Record
General Data Type: NUMBER

DORSAL_RATIO

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

Dorsal Ratio
General Data Type: VARCHAR2

FIN_CATEGORY_CODE

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

Category Code to Describing Fin
General Data Type: VARCHAR2

HAS_SCARS

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

Are there scars on the dolphin
General Data Type: VARCHAR2

SCAR_DESCRIPTION

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

Description of scars
General Data Type: VARCHAR2

HAS_LESIONS

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

Are The lesions on the dolphin
General Data Type: VARCHAR2

LESION_DESCRIPTION

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

Description Of The Lesions
General Data Type: VARCHAR2

FIN_TYPE_CODE

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

Type Of Fin Code
General Data Type: NUMBER

CREATED_BY_USER_ID

CC ID: 30821
Seq. Order: 13
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: 30820
Seq. Order: 14
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Control Column Indicating When This Record Was Created
General Data Type: DATE

MODIFIED_BY_USER_ID

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

Oracle Userid of the person who last modified
General Data Type: NUMBER

MODIFIED_DATE

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

Control Column Indicating When This Record Was Last Modified
General Data Type: DATE

Catalog Details

Catalog Item ID: 7806
GUID: gov.noaa.nmfs.inport:7806
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