Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Bait Used Section of Haul Log

Notes:

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

Entity Information

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

Bait Used Section of Haul Log

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key BAITS_USED_KEY NUMBER Primary Key
100
HAUL_LOG_KEY NUMBER Haul Log Key
100
BAIT_NUMBER_USED NUMBER Number Of Individual Baits Used
100
BAIT_WEIGHT NUMBER Units are in LBS
100
BAIT_KIND VARCHAR2 Code that indicates the kind of bait used.
100
BAIT_TYPE VARCHAR2 Code that indicates the type of bait used
100
BAIT_CONDITION VARCHAR2 Code for the condition of the bait used.
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

BAITS_USED_KEY

CC ID: 15664
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

HAUL_LOG_KEY

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

Haul Log Key

General Data Type: NUMBER

BAIT_NUMBER_USED

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

Number Of Individual Baits Used

General Data Type: NUMBER

BAIT_WEIGHT

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

Units are in LBS

General Data Type: NUMBER

BAIT_KIND

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

Code that indicates the kind of bait used.

General Data Type: VARCHAR2

BAIT_TYPE

CC ID: 15659
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Code that indicates the type of bait used

General Data Type: VARCHAR2

BAIT_CONDITION

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

Code for the condition of the bait used.

General Data Type: VARCHAR2

CREATED_BY_USER_ID

CC ID: 15657
Seq. Order: 8
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: 15656
Seq. Order: 9
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: 15655
Seq. Order: 10
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: 15654
Seq. Order: 11
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: 5328
GUID: gov.noaa.nmfs.inport:5328
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-12 05:01+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year