Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: tblsubfrmBottomfishCatchLog
Short Name: Bottomfish 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 CATCHDATE 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
SHARKLINE YES/NO
67
PHOTOS YES/NO
67
SPECIMEN YES/NO
67
NOTES MEMO

Attribute Details

BOTTOMFISHID

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

TRIPNUM

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

CATCHDATE

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

STATION

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

PAGENUM

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

LINENUM

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

SPECIESNAME

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

SPECIESCODE

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

FORKLENGTH

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

DISPOSITION

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

DAMAGE

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

SHARKLINE

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

PHOTOS

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

SPECIMEN

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

NOTES

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

Catalog Details

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