Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Social Science Research Group Projects > Trip Cost Data > SSRG Socioeconomic Panel >

Table: FLS_GEARS_FISHED

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

Summary

Abstract

Contains Gear Information Per fishing Activity Record

Description

Contains Gear Information Per fishing Activity Record

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
FISHING_ACTIVITY_KEY
NUMBER 		A link to the FLS_FISHING_ACTIVITIES table. This key establishes the relationship between the gear that was used during the fishing trip and the fishing activity during which this gear was used. This key is used internally by the forms or screens and reports used to manipulate the data. It should not be necessary for the user to be familiar with this link.Validation:The foreign key enforces that the referenced record must be present in the Fishing Activities table before it can be used in the Gears Fished table. In other words, a Fishing Activity must have been described before it can be associated with Gear Fished information.
GEAR_FISHED_KEY
NUMBER 		A link to the Gear Fished table. This key establishes the relationship between the gear that was used during the fishing trip and the catch that was made using this gear. This key is used internally by the forms or screens and reports used to manipulate the data. It should not be necessary for the user to be familiar with this link.Validation:The foreign key enforces that the referenced record must be present in the gear table before it can be used in the catch record. In other words, a gear must have been described before it can be associated with catch informatin.
GEAR_CODE_NMFS
VARCHAR2 		A code that represents the gear fished.Validation:A foreign key on the GEAR_CODE_NMFS column ensures that only valid NMFS codes are entered and that when a new Snapper/Grouper-Gulf Reef codes is entered the gear already exists in the FLS_GEAR_CODES_NMFS table.This column is not optional and cannot be left empty.
GEAR_QUANTITY
NUMBER 		How many units of the specified gear were fished. Each of the gears is described in the table FLS_INT_GEAR_DESCRIPTIONS.Validation: Information in this column must be numeric and up to 4 digits long.
GEAR_QUALIFIER
VARCHAR2 		What The units are of the specified gear

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

Contains Gear Information Per fishing Activity Record
Notes:

Loaded by batch 2043, 12-20-2007 08:10

Physical Location

Organization: Southeast Fisheries Science Center
City: Miami
State/Province: FL
Country: USA

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: FLS
Description:

Contains Gear Information Per fishing Activity Record

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 FISHING_ACTIVITY_KEY NUMBER A link to the FLS_FISHING_ACTIVITIES table. This key establishes the relationship between the gear that was used during the fishing trip and the fishing activity during which this gear was used. This key is used internally by the forms or screens and reports used to manipulate the data. It should not be necessary for the user to be familiar with this link.Validation:The foreign key enforces that the referenced record must be present in the Fishing Activities table before it can be used in the Gears Fished table. In other words, a Fishing Activity must have been described before it can be associated with Gear Fished information.
100
 Primary Key GEAR_FISHED_KEY NUMBER A link to the Gear Fished table. This key establishes the relationship between the gear that was used during the fishing trip and the catch that was made using this gear. This key is used internally by the forms or screens and reports used to manipulate the data. It should not be necessary for the user to be familiar with this link.Validation:The foreign key enforces that the referenced record must be present in the gear table before it can be used in the catch record. In other words, a gear must have been described before it can be associated with catch informatin.
100
 GEAR_CODE_NMFS VARCHAR2 A code that represents the gear fished.Validation:A foreign key on the GEAR_CODE_NMFS column ensures that only valid NMFS codes are entered and that when a new Snapper/Grouper-Gulf Reef codes is entered the gear already exists in the FLS_GEAR_CODES_NMFS table.This column is not optional and cannot be left empty.
100
 GEAR_QUANTITY NUMBER How many units of the specified gear were fished. Each of the gears is described in the table FLS_INT_GEAR_DESCRIPTIONS.Validation: Information in this column must be numeric and up to 4 digits long.
100
 GEAR_QUALIFIER VARCHAR2 What The units are of the specified gear

Attribute Details

FISHING_ACTIVITY_KEY

CC ID: 24857
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

A link to the FLS_FISHING_ACTIVITIES table. This key establishes the relationship between the gear that was used during the fishing trip and the fishing activity during which this gear was used. This key is used internally by the forms or screens and reports used to manipulate the data. It should not be necessary for the user to be familiar with this link.Validation:The foreign key enforces that the referenced record must be present in the Fishing Activities table before it can be used in the Gears Fished table. In other words, a Fishing Activity must have been described before it can be associated with Gear Fished information.
General Data Type: NUMBER

GEAR_FISHED_KEY

CC ID: 24858
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 10
Scale: 0
Status: Active
Description:

A link to the Gear Fished table. This key establishes the relationship between the gear that was used during the fishing trip and the catch that was made using this gear. This key is used internally by the forms or screens and reports used to manipulate the data. It should not be necessary for the user to be familiar with this link.Validation:The foreign key enforces that the referenced record must be present in the gear table before it can be used in the catch record. In other words, a gear must have been described before it can be associated with catch informatin.
General Data Type: NUMBER

GEAR_CODE_NMFS

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

A code that represents the gear fished.Validation:A foreign key on the GEAR_CODE_NMFS column ensures that only valid NMFS codes are entered and that when a new Snapper/Grouper-Gulf Reef codes is entered the gear already exists in the FLS_GEAR_CODES_NMFS table.This column is not optional and cannot be left empty.
General Data Type: VARCHAR2

GEAR_QUANTITY

CC ID: 24860
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

How many units of the specified gear were fished. Each of the gears is described in the table FLS_INT_GEAR_DESCRIPTIONS.Validation: Information in this column must be numeric and up to 4 digits long.
General Data Type: NUMBER

GEAR_QUALIFIER

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

What The units are of the specified gear
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 6869
GUID: gov.noaa.nmfs.inport:6869
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-20 08:10+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:10+0000
Metadata Record Published: 2021-05-07
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-07
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-07