Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

A table of Gear types used on a Fishing Trip. A one-to-many => TRIP to TRIP_GEAR_TYPE.

Description

A table of Gear types used on a Fishing Trip. A one-to-many => TRIP to TRIP_GEAR_TYPE.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TRIP_GEAR_TYPE_ID
NUMBER
Primary key for this table.
TRIP_ID
NUMBER
FK to TRIP. Identifies the Trip which used these Trip Gears.
GEAR_TYPE_CD
VARCHAR2
FK to GEAR_TYPE_LIST. The type of gear used on the fishing trip, such as Net or Trap. Both catch reports record the type of gear used on a fishing trip, in addition to the specific gear within the type. However, multiple gears can be identified so they are stored in a seperate table. Example: Net - Seine and Gill.
HOURS_FISHED
NUMBER
The amount of hours the Fisher fished on a Trip OR how long the Traps soaked between hauls recorded in hours.
DEPTH
NUMBER
Fishing gear depth
LU_DT
DATE
Last update date.
LU_USER_ID
NUMBER
Last update user.
GEAR_QTY_SIZE
NUMBER
Stores a number which represents the gear size or quantity. The value is understood depending on the gear used. (the paper for has no unit of measure)
DEPTH_UOM
VARCHAR2
Unit of Measure for Depth Choices Fathoms and Feet
SPECIES_CLASS_CD
VARCHAR2
Species class is used here to identify the user chosen species class when filling out the logbook/catch report forms. When OTHER species are recorded, the user interface stores the species class chosen by the user (whether it is correct or not). This value will also allow the UI to redraw the values where they were entered when editing a logbook/catch report.
CREATED_DT
DATE
Control column giving timestamp of records creation
CREATED_BY_USER_ID
NUMBER
Control column giving oracle usercode of records creater

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

A table of Gear types used on a Fishing Trip. A one-to-many => TRIP to TRIP_GEAR_TYPE.

Notes:

Loaded by batch 7533, 11-05-2015 16:10

Entity Information

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

A table of Gear types used on a Fishing Trip. A one-to-many => TRIP to TRIP_GEAR_TYPE.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key TRIP_GEAR_TYPE_ID NUMBER Primary key for this table.
100
TRIP_ID NUMBER FK to TRIP. Identifies the Trip which used these Trip Gears.
100
GEAR_TYPE_CD VARCHAR2 FK to GEAR_TYPE_LIST. The type of gear used on the fishing trip, such as Net or Trap. Both catch reports record the type of gear used on a fishing trip, in addition to the specific gear within the type. However, multiple gears can be identified so they are stored in a seperate table. Example: Net - Seine and Gill.
100
HOURS_FISHED NUMBER The amount of hours the Fisher fished on a Trip OR how long the Traps soaked between hauls recorded in hours.
100
DEPTH NUMBER Fishing gear depth
100
LU_DT DATE Last update date.
100
LU_USER_ID NUMBER Last update user.
100
GEAR_QTY_SIZE NUMBER Stores a number which represents the gear size or quantity. The value is understood depending on the gear used. (the paper for has no unit of measure)
100
DEPTH_UOM VARCHAR2 Unit of Measure for Depth Choices Fathoms and Feet
100
SPECIES_CLASS_CD VARCHAR2 Species class is used here to identify the user chosen species class when filling out the logbook/catch report forms. When OTHER species are recorded, the user interface stores the species class chosen by the user (whether it is correct or not). This value will also allow the UI to redraw the values where they were entered when editing a logbook/catch report.
100
CREATED_DT DATE Control column giving timestamp of records creation
100
CREATED_BY_USER_ID NUMBER Control column giving oracle usercode of records creater

Attribute Details

TRIP_GEAR_TYPE_ID

CC ID: 247158
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Status: Active
Description:

Primary key for this table.

General Data Type: NUMBER

TRIP_ID

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

FK to TRIP. Identifies the Trip which used these Trip Gears.

General Data Type: NUMBER
Foreign Key Relations:

CCL.TRIP

GEAR_TYPE_CD

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

FK to GEAR_TYPE_LIST. The type of gear used on the fishing trip, such as Net or Trap. Both catch reports record the type of gear used on a fishing trip, in addition to the specific gear within the type. However, multiple gears can be identified so they are stored in a seperate table. Example: Net - Seine and Gill.

General Data Type: VARCHAR2
Foreign Key Relations:

CCL.GEAR_TYPE_LIST

HOURS_FISHED

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

The amount of hours the Fisher fished on a Trip OR how long the Traps soaked between hauls recorded in hours.

General Data Type: NUMBER

DEPTH

CC ID: 247162
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 2
Status: Active
Description:

Fishing gear depth

General Data Type: NUMBER

LU_DT

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

Last update date.

General Data Type: DATE

LU_USER_ID

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

Last update user.

General Data Type: NUMBER

GEAR_QTY_SIZE

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

Stores a number which represents the gear size or quantity. The value is understood depending on the gear used. (the paper for has no unit of measure)

General Data Type: NUMBER

DEPTH_UOM

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

Unit of Measure for Depth Choices Fathoms and Feet

General Data Type: VARCHAR2

SPECIES_CLASS_CD

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

Species class is used here to identify the user chosen species class when filling out the logbook/catch report forms. When OTHER species are recorded, the user interface stores the species class chosen by the user (whether it is correct or not). This value will also allow the UI to redraw the values where they were entered when editing a logbook/catch report.

General Data Type: VARCHAR2
Foreign Key Relations:

CCL.SPECIES_CLASS_LIST

CREATED_DT

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

Control column giving timestamp of records creation

General Data Type: DATE

CREATED_BY_USER_ID

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

Control column giving oracle usercode of records creater

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 28566
GUID: gov.noaa.nmfs.inport:28566
Metadata Record Created By: Joshua Bennett
Metadata Record Created: 2015-11-05 16:10+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-06