Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Table used to help determine gear parameters

Notes:

Loaded by batch 2005, 12-03-2007 10:12

Entity Information

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

Table used to help determine gear parameters

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
GEAR_NUM_TYPE NUMBER Sequential Key
100
GEAR_QTY VARCHAR2 What is measued for Gear Quantity Information
100
GEAR_USE_FREQ VARCHAR2 What is in use for The Gear Frequency Information
100
GEAR_SIZE VARCHAR2 Description And Units For Gear Size
100
GEAR_AVG_INFO VARCHAR2 Indicates What is measured for Gear Average Informations
100
GEAR_NUMBER_SET VARCHAR2 Indicates What Paremeterto count for Gear Number Set
100
GEAR_TOTAL_LINE_LENGTH VARCHAR2 Indicates description and units for Total Line Length
100
GEAR_AVG_MILES_PER_SET VARCHAR2 Indicates description and units for Average Miles Per Set

Attribute Details

GEAR_NUM_TYPE

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

Sequential Key

General Data Type: NUMBER

GEAR_QTY

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

What is measued for Gear Quantity Information

General Data Type: VARCHAR2

GEAR_USE_FREQ

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

What is in use for The Gear Frequency Information

General Data Type: VARCHAR2

GEAR_SIZE

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

Description And Units For Gear Size

General Data Type: VARCHAR2

GEAR_AVG_INFO

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

Indicates What is measured for Gear Average Informations

General Data Type: VARCHAR2

GEAR_NUMBER_SET

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

Indicates What Paremeterto count for Gear Number Set

General Data Type: VARCHAR2

GEAR_TOTAL_LINE_LENGTH

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

Indicates description and units for Total Line Length

General Data Type: VARCHAR2

GEAR_AVG_MILES_PER_SET

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

Indicates description and units for Average Miles Per Set

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 6586
GUID: gov.noaa.nmfs.inport:6586
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-03 10:12+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-11-04 13:14+0000
Metadata Record Published: 2021-11-04
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-11-05