Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > AMMOP > AMMOP Oracle database 1999 - 2013 >

MM_COLOR

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:75160  |  Updated: May 21, 2025  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Description

Provides pick list choices for any field where a list of colors is required

Entity Information

Data Attribute / Type Description
BEGIN_DATE
DATE 		Database useage start date
CODE
VARCHAR2(2 BYTE) 		AMMOP Code used on the Gear Characteristics form
NAME
VARCHAR2(32 BYTE) 		Name of the color
END_DATE
DATE 		Database useage end date
ID
NUMBER(6,0) 		Unique database identifier

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Item Identification

Title: MM_COLOR

Entity Information

Description:

Provides pick list choices for any field where a list of colors is required

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 BEGIN_DATE DATE Database useage start date
100
 CODE VARCHAR2(2 BYTE) AMMOP Code used on the Gear Characteristics form
100
 NAME VARCHAR2(32 BYTE) Name of the color
100
 END_DATE DATE Database useage end date
100
 ID NUMBER(6,0) Unique database identifier

Attribute Details

BEGIN_DATE

CC ID: 1374182
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Database useage start date

CODE

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

AMMOP Code used on the Gear Characteristics form

NAME

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

Name of the color

END_DATE

CC ID: 1374185
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Database useage end date

ID

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

Unique database identifier

Catalog Details

Catalog Item ID: 75160
GUID: gov.noaa.nmfs.inport:75160
Metadata Record Created By: Rachel Wuest
Metadata Record Created: 2025-03-06 17:37+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