Table: TRIP_GEAR_SPEAR_DETAIL
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:28564 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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?
DescriptionWhen 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?
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
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. |
DIVERS_CNT
NUMBER |
The count of divers (number of people diving) on this fishing trip. |
DIVES_CNT
NUMBER |
The count of dives which took place while fishing on this trip. |
LU_DT
DATE |
Last update date. |
LU_USER_ID
NUMBER |
Last update user. |
IS_SCUBA
NUMBER |
Check flag for scuba diving |
CREATED_DT
DATE |
Control column giving timestamp of records creation |
CREATED_BY_USER_ID
NUMBER |
Control column giving oracle usercode of the creater of the record |
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_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
Name | Type | Description | ||
---|---|---|---|---|
100
|
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
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
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
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
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
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
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
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
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 |