Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

A table to support a many-to-many relationship between TRIP and FISHER_PERMIT. The table stores all the Fishers who participated on a Fishing Trip and their Role on the Trip, such as primary/owner or partner.

Description

A table to support a many-to-many relationship between TRIP and FISHER_PERMIT. The table stores all the Fishers who participated on a Fishing Trip and their Role on the Trip, such as primary/owner or partner.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TRIP_FISHER_ID
NUMBER
Primary key for this table.
TRIP_ID
NUMBER
Foreign Key to Trip Table
FISHER_PERMIT_ID
NUMBER
FK to FISHER_PERMIT. Identifies the Fisher in the many-to-many relationship between Fishers (permits) and Trips.
FISHER_ROLE_CD
VARCHAR2
FK to FISHER_ROLE. Identifies the role of the Fisher on the Trip, such as primary or partner.
LU_DT
DATE
Last update date.
LU_USER_ID
NUMBER
Last update user.
CREATED_DT
DATE
Control column giving timestamp of records creation
CREATED_BY_USER_ID
NUMBER
Control column giving toracle usercode of creater of the record

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Item Identification

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

A table to support a many-to-many relationship between TRIP and FISHER_PERMIT. The table stores all the Fishers who participated on a Fishing Trip and their Role on the Trip, such as primary/owner or partner.

Notes:

Loaded by batch 7533, 11-05-2015 16:10

Entity Information

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

A table to support a many-to-many relationship between TRIP and FISHER_PERMIT. The table stores all the Fishers who participated on a Fishing Trip and their Role on the Trip, such as primary/owner or partner.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key TRIP_FISHER_ID NUMBER Primary key for this table.
100
TRIP_ID NUMBER Foreign Key to Trip Table
100
FISHER_PERMIT_ID NUMBER FK to FISHER_PERMIT. Identifies the Fisher in the many-to-many relationship between Fishers (permits) and Trips.
100
FISHER_ROLE_CD VARCHAR2 FK to FISHER_ROLE. Identifies the role of the Fisher on the Trip, such as primary or partner.
100
LU_DT DATE Last update date.
100
LU_USER_ID NUMBER Last update user.
100
CREATED_DT DATE Control column giving timestamp of records creation
100
CREATED_BY_USER_ID NUMBER Control column giving toracle usercode of creater of the record

Attribute Details

TRIP_FISHER_ID

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

Primary key for this table.

General Data Type: NUMBER

TRIP_ID

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

Foreign Key to Trip Table

General Data Type: NUMBER
Foreign Key Relations:

CCL.TRIP

FISHER_PERMIT_ID

CC ID: 247112
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
Description:

FK to FISHER_PERMIT. Identifies the Fisher in the many-to-many relationship between Fishers (permits) and Trips.

General Data Type: NUMBER
Foreign Key Relations:

CCL.FISHER_PERMIT

FISHER_ROLE_CD

CC ID: 247113
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

FK to FISHER_ROLE. Identifies the role of the Fisher on the Trip, such as primary or partner.

General Data Type: VARCHAR2
Foreign Key Relations:

CCL.FISHER_ROLE_LIST

LU_DT

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

Last update date.

General Data Type: DATE

LU_USER_ID

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

Last update user.

General Data Type: NUMBER

CREATED_DT

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

Control column giving timestamp of records creation

General Data Type: DATE

CREATED_BY_USER_ID

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

Control column giving toracle usercode of creater of the record

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 28561
GUID: gov.noaa.nmfs.inport:28561
Metadata Record Created By: Joshua Bennett
Metadata Record Created: 2015-11-05 16:10+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-06