Table: TRIP_GEAR_TYPE
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:28566 | Updated: August 9, 2022 | Published / External
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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 |