From dbscript Online Help
wikibot
| Table
|
OE.PRODUCT_INFORMATION
|
| Description
|
Non-industry-specific data in various categories.
|
Columns
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
| PRODUCT_ID
|
NUMBER(6, 0)
|
not null
|
|
Primary key column.
|
| PRODUCT_NAME
|
VARCHAR2(50)
|
null
|
|
|
| PRODUCT_DESCRIPTION
|
VARCHAR2(2000)
|
null
|
|
Primary language description corresponding to translated_description in
oe.product_descriptions, added to provide non-NLS text columns for OC views
to accss.
|
| CATEGORY_ID
|
NUMBER(2, 0)
|
null
|
|
Low cardinality column, can be used for bitmap index.
Schema SH uses it as foreign key
|
| WEIGHT_CLASS
|
NUMBER(1, 0)
|
null
|
|
Low cardinality column, can be used for bitmap index.
|
| WARRANTY_PERIOD
|
INTERVAL YEAR(2) TO MONTH
|
null
|
|
INTERVAL YEAER TO MONTH column, low cardinality, can be used for bitmap
index.
|
| SUPPLIER_ID
|
NUMBER(6, 0)
|
null
|
|
Offers possibility of extensions outside Common Schema.
|
| PRODUCT_STATUS
|
VARCHAR2(20)
|
null
|
|
Check constraint. Appropriate for complex rules, such as "All products in
status PRODUCTION must have at least one inventory entry." Also appropriate
for a trigger auditing status change.
|
| LIST_PRICE
|
NUMBER(8, 2)
|
null
|
|
|
| MIN_PRICE
|
NUMBER(8, 2)
|
null
|
|
|
| CATALOG_URL
|
VARCHAR2(50)
|
null
|
|
|
Primary Key
| Primary Key
|
Columns
|
| PRODUCT_INFORMATION_PK
|
PRODUCT_ID
|
Indexes
| Index
|
Type
|
Columns
|
| PROD_SUPPLIER_IX
|
|
SUPPLIER_ID
|
Check Constraints
| Check Constraint
|
Expression
|
Description
|
| PRODUCT_STATUS_LOV
|
product_status in ('orderable'
,'planned'
,'under development'
,'obsolete')
|
|
Detail Tables
Dependencies
