Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: BOAT_INTERVIEW
Short Name: BOAT_INTERVIEW
Status: Completed
Abstract:

Table Listing Boat Interviews

Notes:

Loaded by batch 1863, 11-02-2007 09:24

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Interviews

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: RBS
Description:

Table Listing Boat Interviews

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
TOURNAMENT_CODE NUMBER Foreign Key to tournament table
100
FISHING_DATE DATE Fishing Date
100
BOAT_NAME VARCHAR2 Boat Name
100
START_TIME DATE Number Of Hours Fished
100
HOURS_FISHED NUMBER Number Of Hours Fished
100
Primary Key ID NUMBER Sequential Key

Attribute Details

TOURNAMENT_CODE

CC ID: 20515
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Foreign Key to tournament table

General Data Type: NUMBER

FISHING_DATE

CC ID: 20516
Seq. Order: 2
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Fishing Date

General Data Type: DATE

BOAT_NAME

CC ID: 20517
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

Boat Name

General Data Type: VARCHAR2

START_TIME

CC ID: 20518
Seq. Order: 4
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Number Of Hours Fished

General Data Type: DATE

HOURS_FISHED

CC ID: 20519
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Number Of Hours Fished

General Data Type: NUMBER

ID

CC ID: 20520
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 38
Status: Active
Description:

Sequential Key

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 6225
GUID: gov.noaa.nmfs.inport:6225
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-11-02 09:24+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-05
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-05
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-05