Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
50%
3 / 6
View Report
PIRO Metadata Library > Pacific Islands Regional Office Observer Progra... > Pacific Islands Region Observer Program System >

Table: Sets

Entity (ENT)  |  Pacific Islands Regional Office (PIRO)
GUID: gov.noaa.nmfs.inport:21897  |  Updated: August 9, 2022  |  Published / External 

Item Identification

Title: Table: Sets
Short Name: Sets
Status: In Work

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 Primary Key ID INT
67
 TRIPID INT
67
 SETNUM INT
67
 SETDATE DATE
67
 LOGBOOKPAGE VARCHAR
67
 LASTUPDATE DATETIME
67
 LASTUPDATEBY INT

Attribute Details

ID

CC ID: 178920
Seq. Order: 1
Data Storage Type: INT
Max Length: 4
Required: Yes
Primary Key: Yes
Precision: 10
Status: Active

TRIPID

CC ID: 178921
Seq. Order: 2
Data Storage Type: INT
Max Length: 4
Required: No
Primary Key: No
Precision: 10
Status: Active

SETNUM

CC ID: 178922
Seq. Order: 3
Data Storage Type: INT
Max Length: 4
Required: No
Primary Key: No
Precision: 10
Status: Active

SETDATE

CC ID: 178923
Seq. Order: 4
Data Storage Type: DATE
Max Length: 3
Required: No
Primary Key: No
Status: Active

LOGBOOKPAGE

CC ID: 178924
Seq. Order: 5
Data Storage Type: VARCHAR
Max Length: 7
Required: No
Primary Key: No
Status: Active

LASTUPDATE

CC ID: 178925
Seq. Order: 6
Data Storage Type: DATETIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

LASTUPDATEBY

CC ID: 178926
Seq. Order: 7
Data Storage Type: INT
Max Length: 4
Required: No
Primary Key: No
Precision: 10
Status: Active

Catalog Details

Catalog Item ID: 21897
GUID: gov.noaa.nmfs.inport:21897
Metadata Record Created By: Eric Forney
Metadata Record Created: 2014-07-11 18:02+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2015-12-03
Owner Org: PIRO
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2015-12-03
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2016-12-03