Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: tblTrollLog
Short Name: Troll 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 TROLLNUM NUMBER
67
Primary Key PAGENUM NUMBER
67
OBSERVERNUM TEXT
67
BEGINTIME DATE/TIME
67
ENDDATE DATE/TIME
67
PROTSPEC YES/NO
67
BEAUFORT TEXT
67
ENDTIME DATE/TIME
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
NUMLINES NUMBER
67
COMMENTS MEMO
67
LOGBOOKPAGENUM TEXT

Attribute Details

TRIPNUM

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

BEGINDATE

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

TROLLNUM

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

PAGENUM

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

OBSERVERNUM

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

BEGINTIME

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

ENDDATE

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

PROTSPEC

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

BEAUFORT

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

ENDTIME

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

BEGINLATDEG

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

BEGINLATMIN

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

BEGINLATN

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

ENDLATDEG

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

ENDLATMIN

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

ENDLATN

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

BEGINLONGDEG

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

BEGINLONGMIN

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

BEGINLONGW

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

ENDLONGDEG

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

ENDLONGMIN

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

ENDLONGW

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

NUMLINES

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

COMMENTS

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

LOGBOOKPAGENUM

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

Catalog Details

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