Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Used to lookup Hook Type Based on Brand and Model

Notes:

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

Entity Information

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

Used to lookup Hook Type Based on Brand and Model

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key HOOK_DEFINED_KEY NUMBER Primary Key
100
HOOK_BRAND VARCHAR2 The Brand Of Hooks Used.
100
HOOK_TYPE VARCHAR2 TheType Of Hooks Used.
100
HOOK_MODEL VARCHAR2 Model Of Hook
100
CREATED_BY_USER_ID VARCHAR2 Who created the record
100
CREATED_DATE DATE When was the record created
100
MODIFIED_BY_USER_ID VARCHAR2 Who last modified the record
100
MODIFIED_DATE DATE When was the record last modified

Attribute Details

HOOK_DEFINED_KEY

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

Primary Key

General Data Type: NUMBER

HOOK_BRAND

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

The Brand Of Hooks Used.

General Data Type: VARCHAR2

HOOK_TYPE

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

TheType Of Hooks Used.

General Data Type: VARCHAR2

HOOK_MODEL

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

Model Of Hook

General Data Type: VARCHAR2

CREATED_BY_USER_ID

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

Who created the record

General Data Type: VARCHAR2

CREATED_DATE

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

When was the record created

General Data Type: DATE

MODIFIED_BY_USER_ID

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

Who last modified the record

General Data Type: VARCHAR2

MODIFIED_DATE

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

When was the record last modified

General Data Type: DATE

Catalog Details

Catalog Item ID: 5351
GUID: gov.noaa.nmfs.inport:5351
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 Next Review Date: 2022-05-07