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... > Hawaii Bottomfish Observer Program > Bottomfish Observer Database - Legacy >

Table: tblBottomfishEffortLog

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

Item Identification

Title: Table: tblBottomfishEffortLog
Short Name: Bottomfish Effort Log
Status: In Work

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 Primary Key TRIPNUM TEXT
67
 Primary Key EFFORTDATE DATE/TIME
67
 Primary Key PAGENUM NUMBER
67
 OBSERVERNUM TEXT
67
 LOGBOOKPAGENUM TEXT
67
 COMMENTS MEMO
67
 BFID AUTONUMBER

Attribute Details

TRIPNUM

CC ID: 179147
Seq. Order: 1
Data Storage Type: TEXT
Max Length: 6
Required: Yes
Primary Key: Yes
Status: Active

EFFORTDATE

CC ID: 179148
Seq. Order: 2
Data Storage Type: DATE/TIME
Max Length: 8
Required: Yes
Primary Key: Yes
Status: Active

PAGENUM

CC ID: 179149
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 4
Required: Yes
Primary Key: Yes
Status: Active

OBSERVERNUM

CC ID: 179150
Seq. Order: 4
Data Storage Type: TEXT
Max Length: 4
Required: No
Primary Key: No
Status: Active

LOGBOOKPAGENUM

CC ID: 179151
Seq. Order: 5
Data Storage Type: TEXT
Max Length: 10
Required: No
Primary Key: No
Status: Active

COMMENTS

CC ID: 179152
Seq. Order: 6
Data Storage Type: MEMO
Max Length: 63999
Required: No
Primary Key: No
Status: Active

BFID

CC ID: 179153
Seq. Order: 7
Data Storage Type: AUTONUMBER
Max Length: 4
Required: No
Primary Key: No
Status: Active

Catalog Details

Catalog Item ID: 21927
GUID: gov.noaa.nmfs.inport:21927
Metadata Record Created By: Eric Forney
Metadata Record Created: 2014-07-14 19:53+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