Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: STURGEON_SCUTES
Abstract:

Describes about sturgeon biological details

Entity Information

Entity Type: Data Table
Description:

Describes about sturgeon biological details

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key STURGEON_SCUTES_ID NUMBER The ID name for sturgeon that have been tagged with a SCUTES-issued tag.
100
STURGEON_ID VARCHAR2 The ID name for sturgeon issued by the researcher.
100
SPECIES 15 The individual sturgeon (i.e., shortnose sturgeon or Atlantic sturgeon)
100
SEX VARCHAR2 sex
100
CREATED_BY VARCHAR2 created by whom?
100
DATE_CREATED DATE created date
100
MODIFIED_BY VARCHAR2 modified by whom?
100
DATE_MODIFIED DATE modified date
100
ORIGINAL_STURGEON_SCUTES_ID NUMBER The ID name for sturgeon that have been tagged with a SCUTES-issued tag that were initially placed in or on a sturgeon.
100
DATE_RECORD_DELETED DATE The date the data has been omitted
100
SOURCE VARCHAR2 Originating source.

Attribute Details

STURGEON_SCUTES_ID

CC ID: 574131
Seq. Order: 1
Data Storage Type: NUMBER
Required: Yes
Primary Key: Yes
Status: Active
Description:

The ID name for sturgeon that have been tagged with a SCUTES-issued tag.

STURGEON_ID

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

The ID name for sturgeon issued by the researcher.

SPECIES

CC ID: 574129
Seq. Order: 3
Data Storage Type: 15
Required: No
Primary Key: No
Status: Active
Description:

The individual sturgeon (i.e., shortnose sturgeon or Atlantic sturgeon)

SEX

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

sex

CREATED_BY

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

created by whom?

DATE_CREATED

CC ID: 574122
Seq. Order: 6
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

created date

MODIFIED_BY

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

modified by whom?

DATE_MODIFIED

CC ID: 574123
Seq. Order: 8
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

modified date

ORIGINAL_STURGEON_SCUTES_ID

CC ID: 574126
Seq. Order: 9
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The ID name for sturgeon that have been tagged with a SCUTES-issued tag that were initially placed in or on a sturgeon.

DATE_RECORD_DELETED

CC ID: 574124
Seq. Order: 10
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

The date the data has been omitted

SOURCE

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

Originating source.

Catalog Details

Catalog Item ID: 46628
GUID: gov.noaa.nmfs.inport:46628
Metadata Record Created By: Sandeep Thumma
Metadata Record Created: 2017-07-26 10:49+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-09-26
Owner Org: GARFO
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-09-26
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-09-26