Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
GARFO Metadata Library > _Protected Resources Division (PRD) Metadata Po... > Students Collaborating to Undertake Tracking Ef... >

BRIDGE_STURGEON_TAGS

Entity (ENT)  |  Greater Atlantic Regional Fisheries Office (GARFO)
GUID: gov.noaa.nmfs.inport:46627  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

describes about sturgeon tags and the events

Description

BRIDGE_STURGEON_TAGS table describes about sturgeon tags and the events

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
STURGEON_TAGS_ID
NUMBER 		Character sequence used to identify bio acoustic tags
STURGEON_SCUTES_EVENTS_ID
NUMBER 		Character sequence used to identify researchers' interaction with an individual sturgeon containing a SCUTES-issued tag
STURGEON_SCUTES_ID
NUMBER 		The ID name for sturgeon that have been tagged with a SCUTES-issued tag.
CREATED_BY
VARCHAR2 		created by whom?
DATE_CREATED
DATE 		Created date
MODIFIED_BY
VARCHAR2 		modified by whom?
DATE_MODIFIED
DATE 		Modified Date
ORIGINAL_STURGEON_TAGS_ID
NUMBER 		Character sequence used to identify bioacoustic tags that were initially placed in or on a sturgeon (i.e., first tag number)
ORIGINAL_STURGEON_EVENTS_ID
NUMBER 		Character sequence used to identify researchers' first interaction with an individual sturgeon
RECORD_IS_DELETED
NUMBER 		Data has been omitted
DATE_RECORD_DELETED
DATE 		Date at which the data has been omitted
SOURCE
VARCHAR2 		The original data source

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (GARFO) for inquiries on this record.

Item Identification

Title: BRIDGE_STURGEON_TAGS
Abstract:

describes about sturgeon tags and the events

Entity Information

Entity Type: Data Table
Description:

BRIDGE_STURGEON_TAGS table describes about sturgeon tags and the events

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key STURGEON_TAGS_ID NUMBER Character sequence used to identify bio acoustic tags
100
 Primary Key STURGEON_SCUTES_EVENTS_ID NUMBER Character sequence used to identify researchers' interaction with an individual sturgeon containing a SCUTES-issued tag
100
 STURGEON_SCUTES_ID NUMBER The ID name for sturgeon that have been tagged with a SCUTES-issued tag.
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_TAGS_ID NUMBER Character sequence used to identify bioacoustic tags that were initially placed in or on a sturgeon (i.e., first tag number)
100
 ORIGINAL_STURGEON_EVENTS_ID NUMBER Character sequence used to identify researchers' first interaction with an individual sturgeon
100
 RECORD_IS_DELETED NUMBER Data has been omitted
100
 DATE_RECORD_DELETED DATE Date at which the data has been omitted
100
 SOURCE VARCHAR2 The original data source

Attribute Details

STURGEON_TAGS_ID

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

Character sequence used to identify bio acoustic tags

STURGEON_SCUTES_EVENTS_ID

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

Character sequence used to identify researchers' interaction with an individual sturgeon containing a SCUTES-issued tag

STURGEON_SCUTES_ID

CC ID: 574119
Seq. Order: 3
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.

CREATED_BY

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

created by whom?

DATE_CREATED

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

Created date

MODIFIED_BY

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

modified by whom?

DATE_MODIFIED

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

Modified Date

ORIGINAL_STURGEON_TAGS_ID

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

Character sequence used to identify bioacoustic tags that were initially placed in or on a sturgeon (i.e., first tag number)

ORIGINAL_STURGEON_EVENTS_ID

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

Character sequence used to identify researchers' first interaction with an individual sturgeon

RECORD_IS_DELETED

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

Data has been omitted

DATE_RECORD_DELETED

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

Date at which the data has been omitted

SOURCE

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

The original data source

Catalog Details

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