Slide Menu
Search Help Show/Hide Menu

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: 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 Next Review Date: 2022-04-30