Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Drop Lines Section of the Gear Log Data.

Notes:

Loaded by batch 1683, 10-12-2007 05:01

Entity Information

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

Drop Lines Section of the Gear Log Data.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key DROPLINES_USED_KEY NUMBER Primary key
100
GEAR_LOG_KEY NUMBER Gear log key
100
DROPLINE_LENGTH NUMBER In Feet
100
DISTANCE_BETWEEN_DROPLINES NUMBER In Feet
100
CREATED_BY_USER_ID VARCHAR2 Created by whom
100
CREATED_DATE DATE Created when
100
MODIFIED_BY_USER_ID VARCHAR2 Modified by whom
100
MODIFIED_DATE DATE Modified when

Attribute Details

DROPLINES_USED_KEY

CC ID: 15710
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 10
Scale: 0
Status: Active
Description:

Primary key

General Data Type: NUMBER

GEAR_LOG_KEY

CC ID: 15709
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Gear log key

General Data Type: NUMBER

DROPLINE_LENGTH

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

In Feet

General Data Type: NUMBER

DISTANCE_BETWEEN_DROPLINES

CC ID: 15707
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

In Feet

General Data Type: NUMBER

CREATED_BY_USER_ID

CC ID: 15706
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

Created by whom

General Data Type: VARCHAR2

CREATED_DATE

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

Created when

General Data Type: DATE

MODIFIED_BY_USER_ID

CC ID: 15704
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Modified by whom

General Data Type: VARCHAR2

MODIFIED_DATE

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

Modified when

General Data Type: DATE

Catalog Details

Catalog Item ID: 5336
GUID: gov.noaa.nmfs.inport:5336
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-12 05:01+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