Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
Primary Key TRIPNUM TEXT
67
Primary Key BEGINDATE DATE/TIME
67
Primary Key STATION NUMBER
67
Primary Key PAGENUM NUMBER
67
OBSERVERNUM TEXT
67
BEGINSEARCH DATE/TIME
67
ENDSEARCH DATE/TIME
67
STATIONTYPE TEXT
67
ENDDATE DATE/TIME
67
BEAUFORT TEXT
67
PROTSPEC YES/NO
67
TARGETSPECIES TEXT
67
NUMLINES NUMBER
67
LINEMATERIAL TEXT
67
LINETEST NUMBER
67
LEADERMATERIAL TEXT
67
LEADERTEST NUMBER
67
HOOKSMAX NUMBER
67
HOOKSMIN NUMBER
67
HOOKTYPE TEXT
67
SIZE TEXT
67
WEIGHTSIZE NUMBER
67
BAITTYPE TEXT
67
CHUMTYPE TEXT
67
SHARKLINE YES/NO
67
BEGINTIME DATE/TIME
67
ENDTIME DATE/TIME
67
BEGINDEPTH NUMBER
67
ENDDEPTH NUMBER
67
BEGINLATDEG NUMBER
67
BEGINLATMIN NUMBER
67
BEGINLATN TEXT
67
ENDLATDEG NUMBER
67
ENDLATMIN NUMBER
67
ENDLATN TEXT
67
BEGINLONGDEG NUMBER
67
BEGINLONGMIN NUMBER
67
BEGINLONGW TEXT
67
ENDLONGDEG NUMBER
67
ENDLONGMIN NUMBER
67
ENDLONGW TEXT
67
COMMENTS MEMO
67
LOGBOOKPAGENUM TEXT
67
BFID AUTONUMBER

Attribute Details

TRIPNUM

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

BEGINDATE

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

STATION

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

PAGENUM

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

OBSERVERNUM

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

BEGINSEARCH

CC ID: 179159
Seq. Order: 6
Data Storage Type: DATE/TIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

ENDSEARCH

CC ID: 179160
Seq. Order: 7
Data Storage Type: DATE/TIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

STATIONTYPE

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

ENDDATE

CC ID: 179162
Seq. Order: 9
Data Storage Type: DATE/TIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

BEAUFORT

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

PROTSPEC

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

TARGETSPECIES

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

NUMLINES

CC ID: 179166
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active

LINEMATERIAL

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

LINETEST

CC ID: 179168
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active

LEADERMATERIAL

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

LEADERTEST

CC ID: 179170
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active

HOOKSMAX

CC ID: 179171
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active

HOOKSMIN

CC ID: 179172
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active

HOOKTYPE

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

SIZE

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

WEIGHTSIZE

CC ID: 179175
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active

BAITTYPE

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

CHUMTYPE

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

SHARKLINE

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

BEGINTIME

CC ID: 179179
Seq. Order: 26
Data Storage Type: DATE/TIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

ENDTIME

CC ID: 179180
Seq. Order: 27
Data Storage Type: DATE/TIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

BEGINDEPTH

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

ENDDEPTH

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

BEGINLATDEG

CC ID: 179183
Seq. Order: 30
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active

BEGINLATMIN

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

BEGINLATN

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

ENDLATDEG

CC ID: 179186
Seq. Order: 33
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active

ENDLATMIN

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

ENDLATN

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

BEGINLONGDEG

CC ID: 179189
Seq. Order: 36
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active

BEGINLONGMIN

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

BEGINLONGW

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

ENDLONGDEG

CC ID: 179192
Seq. Order: 39
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active

ENDLONGMIN

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

ENDLONGW

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

COMMENTS

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

LOGBOOKPAGENUM

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

BFID

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

Catalog Details

Catalog Item ID: 21928
GUID: gov.noaa.nmfs.inport:21928
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