Slide Menu
Search Help Show/Hide Menu

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: Lee M Weinberger
Metadata Record Last Modified: 2021-04-29 15:30+0000
Metadata Record Published: 2021-04-29
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year