Slide Menu
Search Help Show/Hide Menu

Item Identification

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

When the Gear used on a Fishing Trip is Spear or By Hand, this table stores addition details about the Gear such as number of Divers?

Notes:

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

Entity Information

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

When the Gear used on a Fishing Trip is Spear or By Hand, this table stores addition details about the Gear such as number of Divers?

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key TRIP_GEAR_TYPE_ID NUMBER Foreighn/Primary key for this table. This table stores addition information specific to the SPEAR or HAND gear used used on the Fishing Trip.
100
DIVERS_CNT NUMBER The count of divers (number of people diving) on this fishing trip.
100
DIVES_CNT NUMBER The count of dives which took place while fishing on this trip.
100
LU_DT DATE Last update date.
100
LU_USER_ID NUMBER Last update user.
100
IS_SCUBA NUMBER Check flag for scuba diving
100
CREATED_DT DATE Control column giving timestamp of records creation
100
CREATED_BY_USER_ID NUMBER Control column giving oracle usercode of the creater of the record

Attribute Details

TRIP_GEAR_TYPE_ID

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

Foreighn/Primary key for this table. This table stores addition information specific to the SPEAR or HAND gear used used on the Fishing Trip.

General Data Type: NUMBER
Foreign Key Relations:

CCL.TRIP_GEAR_TYPE

DIVERS_CNT

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

The count of divers (number of people diving) on this fishing trip.

General Data Type: NUMBER

DIVES_CNT

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

The count of dives which took place while fishing on this trip.

General Data Type: NUMBER

LU_DT

CC ID: 247140
Seq. Order: 4
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: 247141
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Last update user.

General Data Type: NUMBER

IS_SCUBA

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

Check flag for scuba diving

General Data Type: NUMBER

CREATED_DT

CC ID: 247143
Seq. Order: 7
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: 247144
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Control column giving oracle usercode of the creater of the record

General Data Type: NUMBER

Catalog Details

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