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: tblsubfrmBottomfishGearCatchLog

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

Item Identification

Title: Table: tblsubfrmBottomfishGearCatchLog
Short Name: Bottomfish Gear Catch Log Subform
Status: In Work

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 BOTTOMFISHID AUTONUMBER
67
 Primary Key TRIPNUM TEXT
67
 Primary Key BEGINDATE DATE/TIME
67
 Primary Key STATION NUMBER
67
 Primary Key PAGENUM NUMBER
67
 Primary Key LINENUM NUMBER
67
 SPECIESNAME TEXT
67
 SPECIESCODE TEXT
67
 FORKLENGTH NUMBER
67
 DISPOSITION TEXT
67
 DAMAGE TEXT
67
 TAGS YES/NO
67
 PHOTOS YES/NO
67
 SPECIMENS YES/NO
67
 SKETCHES YES/NO
67
 SHARKLINE YES/NO
67
 NOTES MEMO

Attribute Details

BOTTOMFISHID

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

TRIPNUM

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

BEGINDATE

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

STATION

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

PAGENUM

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

LINENUM

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

SPECIESNAME

CC ID: 179409
Seq. Order: 7
Data Storage Type: TEXT
Max Length: 50
Required: No
Primary Key: No
Status: Active

SPECIESCODE

CC ID: 179410
Seq. Order: 8
Data Storage Type: TEXT
Max Length: 3
Required: No
Primary Key: No
Status: Active

FORKLENGTH

CC ID: 179411
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Status: Active

DISPOSITION

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

DAMAGE

CC ID: 179413
Seq. Order: 11
Data Storage Type: TEXT
Max Length: 2
Required: No
Primary Key: No
Status: Active

TAGS

CC ID: 179414
Seq. Order: 12
Data Storage Type: YES/NO
Max Length: 1
Required: No
Primary Key: No
Status: Active

PHOTOS

CC ID: 179415
Seq. Order: 13
Data Storage Type: YES/NO
Max Length: 1
Required: No
Primary Key: No
Status: Active

SPECIMENS

CC ID: 179416
Seq. Order: 14
Data Storage Type: YES/NO
Max Length: 1
Required: No
Primary Key: No
Status: Active

SKETCHES

CC ID: 179417
Seq. Order: 15
Data Storage Type: YES/NO
Max Length: 1
Required: No
Primary Key: No
Status: Active

SHARKLINE

CC ID: 179418
Seq. Order: 16
Data Storage Type: YES/NO
Max Length: 1
Required: No
Primary Key: No
Status: Active

NOTES

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

Catalog Details

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