Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: OTOLITH_VIALS
Abstract:

Otoliths vials collected by NPOP observers. This table has a implicit foreign key relationship with SCANNED_AGE table in NORPAC database.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
X_COLUMN NUMBER (2) Column number of a rack cell.
100
Y_ROW NUMBER (2) Row number of a rack cell.
100
BARCODE NUMBER Otolith vial barcode number, Primary key of the table.
100
RACK_SEQUENCE NUMBER Rack sequence number. Primary key of the rack table.
100
LAST_CHANGED_BY VARCHAR2 (100 Byte) Application user or database user who made the latest change of the record.

Attribute Details

X_COLUMN

CC ID: 1378128
Seq. Order: 1
Data Storage Type: NUMBER (2)
Required: No
Primary Key: No
Status: Active
Description:

Column number of a rack cell.

Y_ROW

CC ID: 1378129
Seq. Order: 2
Data Storage Type: NUMBER (2)
Required: No
Primary Key: No
Status: Active
Description:

Row number of a rack cell.

BARCODE

CC ID: 1378130
Seq. Order: 3
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Otolith vial barcode number, Primary key of the table.

RACK_SEQUENCE

CC ID: 1378131
Seq. Order: 4
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Rack sequence number. Primary key of the rack table.

LAST_CHANGED_BY

CC ID: 1378132
Seq. Order: 5
Data Storage Type: VARCHAR2 (100 Byte)
Required: No
Primary Key: No
Status: Active
Description:

Application user or database user who made the latest change of the record.

Catalog Details

Catalog Item ID: 75384
GUID: gov.noaa.nmfs.inport:75384
Metadata Record Created By: Martin Park
Metadata Record Created: 2025-03-25 22:11+0000
Metadata Record Last Modified By: Martin Park
Metadata Record Last Modified: 2025-03-25 23:14+0000
Metadata Record Published: 2025-03-25
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year