Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Table That is used to suggest limits for the various gear parameters by gear

Notes:

Loaded by batch 2006, 12-03-2007 10:40

Entity Information

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

Table That is used to suggest limits for the various gear parameters by gear

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key ID NUMBER Standard Gear Id/Code
100
CREATED_DATE DATE Date/Time stamp of record creation
100
CREATED_BY_USER_ID VARCHAR2 User creating Record
100
MIN_TOTAL_LINE_LENGTH NUMBER Minimum Total Line Length
100
MAX_TOTAL_LINE_LENGTH NUMBER Maximum Total Line Length
100
MIN_FREQ NUMBER Minimum Frequencey
100
MAX_FREQ NUMBER Maximum Frequency
100
MIN_AVG_GEAR_INFO NUMBER Minimum Aveage Gear Information
100
MAX_AVG_GEAR_INFO NUMBER Maximum Average Gear Information
100
MIN_QTY NUMBER Minimum Quantity
100
MAX_QTY NUMBER Maximum Quantity
100
MIN_GEAR_AVG_MILES NUMBER Minimum Average Number Of Gear Per Mile
100
MAX_GEAR_AVG_MILES NUMBER Maximum Average Number Of Gear Per Mile
100
MIN_GEAR_NUM_SET NUMBER Minimum Nuber of Gear Set
100
MAX_GEAR_NUM_SET NUMBER Maximum Gear Number Set
100
MODIFIED_BY_USER_ID VARCHAR2 User modifying record
100
MODIFIED_DATE DATE Date/Time stamp of when record was modifed
100
MIN_SIZE NUMBER Minimum Size
100
MAX_SIZE NUMBER Maximumu Size
100
NAME VARCHAR2 Gear Name

Attribute Details

ID

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

Standard Gear Id/Code

General Data Type: NUMBER

CREATED_DATE

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

Date/Time stamp of record creation

General Data Type: DATE

CREATED_BY_USER_ID

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

User creating Record

General Data Type: VARCHAR2

MIN_TOTAL_LINE_LENGTH

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

Minimum Total Line Length

General Data Type: NUMBER

MAX_TOTAL_LINE_LENGTH

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

Maximum Total Line Length

General Data Type: NUMBER

MIN_FREQ

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

Minimum Frequencey

General Data Type: NUMBER

MAX_FREQ

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

Maximum Frequency

General Data Type: NUMBER

MIN_AVG_GEAR_INFO

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

Minimum Aveage Gear Information

General Data Type: NUMBER

MAX_AVG_GEAR_INFO

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

Maximum Average Gear Information

General Data Type: NUMBER

MIN_QTY

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

Minimum Quantity

General Data Type: NUMBER

MAX_QTY

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

Maximum Quantity

General Data Type: NUMBER

MIN_GEAR_AVG_MILES

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

Minimum Average Number Of Gear Per Mile

General Data Type: NUMBER

MAX_GEAR_AVG_MILES

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

Maximum Average Number Of Gear Per Mile

General Data Type: NUMBER

MIN_GEAR_NUM_SET

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

Minimum Nuber of Gear Set

General Data Type: NUMBER

MAX_GEAR_NUM_SET

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

Maximum Gear Number Set

General Data Type: NUMBER

MODIFIED_BY_USER_ID

CC ID: 22958
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

User modifying record

General Data Type: VARCHAR2

MODIFIED_DATE

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

Date/Time stamp of when record was modifed

General Data Type: DATE

MIN_SIZE

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

Minimum Size

General Data Type: NUMBER

MAX_SIZE

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

Maximumu Size

General Data Type: NUMBER

NAME

CC ID: 22962
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Gear Name

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 6627
GUID: gov.noaa.nmfs.inport:6627
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-03 10:40+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