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

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

Item Identification

Title: Table: tblsubfrmTrollLog
Short Name: Troll Log Subform
Status: In Work

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 TROLLID AUTONUMBER
67
 Primary Key TRIPNUM TEXT
67
 Primary Key BEGINDATE DATE/TIME
67
 Primary Key TROLLNUM 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
 NOTES MEMO

Attribute Details

TROLLID

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

TRIPNUM

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

BEGINDATE

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

TROLLNUM

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

PAGENUM

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

LINENUM

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

SPECIESNAME

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

SPECIESCODE

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

FORKLENGTH

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

DISPOSITION

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

DAMAGE

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

TAGS

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

PHOTOS

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

SPECIMENS

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

SKETCHES

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

NOTES

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

Catalog Details

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