Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: MM_GEAR

Entity Information

Description:

This table is the primary table for any gear observed by the AMMOP.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
COMMENTS VARCHAR2(2000 BYTE) The comments on this net
100
ID NUMBER(6,0) Unique database identifier
100
LEAD_USED_CODE VARCHAR2(1 BYTE) Was a lead used on this net?
100
NET_COMBINATION_CODE VARCHAR2(1 BYTE) Was a combination of panels used in this net?
100
NET_CONFIGURATIONS VARCHAR2(10 BYTE) The total number of net configurations on this trip
100
NET_ID_NUMBER VARCHAR2(20 BYTE) The net identifier assigned per trip
100
TRIP_CODE VARCHAR2(6 BYTE) Trip number assigned by observer
100
TRIP_ID NUMBER(6,0) Trip unique database identifer

Attribute Details

COMMENTS

CC ID: 1374355
Data Storage Type: VARCHAR2(2000 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The comments on this net

ID

CC ID: 1374356
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Unique database identifier

LEAD_USED_CODE

CC ID: 1374357
Data Storage Type: VARCHAR2(1 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Was a lead used on this net?

NET_COMBINATION_CODE

CC ID: 1374358
Data Storage Type: VARCHAR2(1 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Was a combination of panels used in this net?

NET_CONFIGURATIONS

CC ID: 1374359
Data Storage Type: VARCHAR2(10 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The total number of net configurations on this trip

NET_ID_NUMBER

CC ID: 1374360
Data Storage Type: VARCHAR2(20 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The net identifier assigned per trip

TRIP_CODE

CC ID: 1374361
Data Storage Type: VARCHAR2(6 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Trip number assigned by observer

TRIP_ID

CC ID: 1374362
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Trip unique database identifer

Catalog Details

Catalog Item ID: 75176
GUID: gov.noaa.nmfs.inport:75176
Metadata Record Created By: Rachel Wuest
Metadata Record Created: 2025-03-06 21:39+0000
Metadata Record Last Modified By: Daniel Woodrich
Metadata Record Last Modified: 2025-05-21 19:12+0000
Metadata Record Published: 2025-05-21
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year