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_ID

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

Summary

Abstract

Data table containing descriptive information about a dolphin

Description

Data table containing descriptive information about a dolphin

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ID
VARCHAR2 		Sequential Key
SURVEY_ID
NUMBER 		Foreign Key To Survey Table
NAME
VARCHAR2 		Name Of Dolphin (If known)
PARTNER_CODE
VARCHAR2 		Foreign Key To Partner Table
SEX_CODE
VARCHAR2 		Code To Indicate Sex Of Dolphin
LIFE_STAGE_CODE
VARCHAR2 		Life Stage Code
COMMENTS
VARCHAR2 		Any extra comments On Dolphin Photo
CREATED_BY_USER_ID
NUMBER 		Oracle Userid of the creator of this record
CREATED_DATE
DATE 		Date Record was created
MODIFIED_BY_USER_ID
NUMBER 		Oracle Userid of the one who last modifed this record
MODIFIED_DATE
DATE 		Date Record was last modified
HAS_BIOPSY_ATTEMPT
VARCHAR2 		Was A Biopsy Attempted
HAS_HIT
VARCHAR2 		Was Dolphin Hit
HAS_SAMPLE_TAKEN
VARCHAR2 		Has a Biopsy Sample Been Taken From The Dolphin

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_ID
Short Name: DOLPHIN_ID
Status: Completed
Abstract:

Data table containing descriptive information about a 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 containing descriptive information about a dolphin

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key ID VARCHAR2 Sequential Key
100
 SURVEY_ID NUMBER Foreign Key To Survey Table
100
 NAME VARCHAR2 Name Of Dolphin (If known)
100
 PARTNER_CODE VARCHAR2 Foreign Key To Partner Table
100
 SEX_CODE VARCHAR2 Code To Indicate Sex Of Dolphin
100
 LIFE_STAGE_CODE VARCHAR2 Life Stage Code
100
 COMMENTS VARCHAR2 Any extra comments On Dolphin Photo
100
 CREATED_BY_USER_ID NUMBER Oracle Userid of the creator of this record
100
 CREATED_DATE DATE Date Record was created
100
 MODIFIED_BY_USER_ID NUMBER Oracle Userid of the one who last modifed this record
100
 MODIFIED_DATE DATE Date Record was last modified
100
 HAS_BIOPSY_ATTEMPT VARCHAR2 Was A Biopsy Attempted
100
 HAS_HIT VARCHAR2 Was Dolphin Hit
100
 HAS_SAMPLE_TAKEN VARCHAR2 Has a Biopsy Sample Been Taken From The Dolphin

Attribute Details

ID

CC ID: 30847
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: Yes
Status: Active
Description:

Sequential Key
General Data Type: VARCHAR2

SURVEY_ID

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

Foreign Key To Survey Table
General Data Type: NUMBER

NAME

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

Name Of Dolphin (If known)
General Data Type: VARCHAR2

PARTNER_CODE

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

Foreign Key To Partner Table
General Data Type: VARCHAR2

SEX_CODE

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

Code To Indicate Sex Of Dolphin
General Data Type: VARCHAR2

LIFE_STAGE_CODE

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

Life Stage Code
General Data Type: VARCHAR2

COMMENTS

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

Any extra comments On Dolphin Photo
General Data Type: VARCHAR2

CREATED_BY_USER_ID

CC ID: 30840
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: 30839
Seq. Order: 9
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date Record was created
General Data Type: DATE

MODIFIED_BY_USER_ID

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

Oracle Userid of the one who last modifed this record
General Data Type: NUMBER

MODIFIED_DATE

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

Date Record was last modified
General Data Type: DATE

HAS_BIOPSY_ATTEMPT

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

Was A Biopsy Attempted
General Data Type: VARCHAR2

HAS_HIT

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

Was Dolphin Hit
General Data Type: VARCHAR2

HAS_SAMPLE_TAKEN

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

Has a Biopsy Sample Been Taken From The Dolphin
General Data Type: VARCHAR2

Catalog Details

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