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

Summary

Abstract

Used to lookup Hook Type Based on Brand and Model

Description

Used to lookup Hook Type Based on Brand and Model

Entity Information

Entity Type
Data Table

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

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: 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: 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