Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: FLS_GEAR_DESCRIPTIONS
Short Name: FLS_GEAR_DESCRIPTIONS
Status: Completed
Abstract:

It contains a description of the gear used. Each gear characteristic that can be described is identified by a parameter and an associated measure. This affords the system complete flexibility in describing gear. The foreign key, GEAR_FISHED_KEY, links to the FLS_Gears_Fished table ensuring that the gear has been defined in that table. A unique key on GEAR_FISHED_KEY and GEAR_PARAMETER_CODE ensures that a parameter is described only once for each gear in the FLS_GEAR_FISHED table. An additional foreign key on GEAR_PARAMETER_CODE and GEAR_CLASS ensures that only the appropriate parameters for a gear are allowed (e.g., the parameter mesh size is not appropriate for the gear long line.)

Notes:

Loaded by batch 2103, 02-28-2008 14:10

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Gear
None Gear Descriptions
None Gear Parameters

Entity Information

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

It contains a description of the gear used. Each gear characteristic that can be described is identified by a parameter and an associated measure. This affords the system complete flexibility in describing gear. The foreign key, GEAR_FISHED_KEY, links to the FLS_Gears_Fished table ensuring that the gear has been defined in that table. A unique key on GEAR_FISHED_KEY and GEAR_PARAMETER_CODE ensures that a parameter is described only once for each gear in the FLS_GEAR_FISHED table. An additional foreign key on GEAR_PARAMETER_CODE and GEAR_CLASS ensures that only the appropriate parameters for a gear are allowed (e.g., the parameter mesh size is not appropriate for the gear long line.)

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key GEAR_DESCRIPTION_KEY NUMBER Sequence number automatically generated by the system to uniquely identify each row in the table. Since these keys are not data dependent, if any element of data is changed, the link to the other tables in the system are not broken.Validation:Managed by the database. Each row in the table must have a unique value.y
100
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 the description of the 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.Having a separate table to manage the gear characteristics allows us to add gear parameters and even new gears to out logbook reports, without having to alter the tables that house the data.Validation:The foreign key enforces that the referenced record must be present in the Gear Fished table before it can be used in the Catch table. In other words, a gear must have been described before it can be associated with a description.
100
GEAR_PARAMETER_CODE VARCHAR2 Measurable characteristic of a gear such as line length, number of hooks, etc.Validation:The value must be a valid parameter code for a specified gear class. This is enforced through a foreign key link to the table FLS_GEAR_PARAMETER_CODES. Since this information is crucial (i.e., which characteristic of the gear are we describing) this column is mandatory and cannot be left empty.
100
GEAR_CLASS VARCHAR2 The code for the classification of the gear. This enables the program to check whether certain gear parameters are appropriate for that type of gear.The gear class is provided by the distribution programs when a particular gear is selected. The classes appear in the FLS_GEAR_CODES_NMFS table for each gear in the table.Validation:The domain called GEAR_CLASS ensures that only certain values are allowed in this field.
100
PARAMETER_VALUE VARCHAR2 Value of the parameter that is being measured.Validation:None. Information can be up to 15 characters in length.
100
PARAMETER_VALUE_MSU VARCHAR2 Identifies the measurement unit in which the parameter value was reported.Validation:The domain MEASUREMENT_UNIT ensures that only predefined codes are allowed into the system.(Note: If the PARAMETER_VALUE column is not empty, this column cannot be left blank.
100
GEARDESC_COMMENT VARCHAR2 A description of the gear that could not be coded, or additional effort information.Validation:None. Up to 200 characters can be entered into this column.

Attribute Details

GEAR_DESCRIPTION_KEY

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

Sequence number automatically generated by the system to uniquely identify each row in the table. Since these keys are not data dependent, if any element of data is changed, the link to the other tables in the system are not broken.Validation:Managed by the database. Each row in the table must have a unique value.y

General Data Type: NUMBER

GEAR_FISHED_KEY

CC ID: 27237
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
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 the description of the 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.Having a separate table to manage the gear characteristics allows us to add gear parameters and even new gears to out logbook reports, without having to alter the tables that house the data.Validation:The foreign key enforces that the referenced record must be present in the Gear Fished table before it can be used in the Catch table. In other words, a gear must have been described before it can be associated with a description.

General Data Type: NUMBER

GEAR_PARAMETER_CODE

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

Measurable characteristic of a gear such as line length, number of hooks, etc.Validation:The value must be a valid parameter code for a specified gear class. This is enforced through a foreign key link to the table FLS_GEAR_PARAMETER_CODES. Since this information is crucial (i.e., which characteristic of the gear are we describing) this column is mandatory and cannot be left empty.

General Data Type: VARCHAR2

GEAR_CLASS

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

The code for the classification of the gear. This enables the program to check whether certain gear parameters are appropriate for that type of gear.The gear class is provided by the distribution programs when a particular gear is selected. The classes appear in the FLS_GEAR_CODES_NMFS table for each gear in the table.Validation:The domain called GEAR_CLASS ensures that only certain values are allowed in this field.

General Data Type: VARCHAR2

PARAMETER_VALUE

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

Value of the parameter that is being measured.Validation:None. Information can be up to 15 characters in length.

General Data Type: VARCHAR2

PARAMETER_VALUE_MSU

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

Identifies the measurement unit in which the parameter value was reported.Validation:The domain MEASUREMENT_UNIT ensures that only predefined codes are allowed into the system.(Note: If the PARAMETER_VALUE column is not empty, this column cannot be left blank.

General Data Type: VARCHAR2

GEARDESC_COMMENT

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

A description of the gear that could not be coded, or additional effort information.Validation:None. Up to 200 characters can be entered into this column.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7158
GUID: gov.noaa.nmfs.inport:7158
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-28 14:10+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07