| Column
|
Datatype
|
Nullable
|
Default value
|
Comment
|
| PRODUCT_ID
|
NUMBER(6,0)
|
N
|
|
Primary key column.
|
| PRODUCT_NAME
|
VARCHAR2(50)
|
Y
|
|
|
| PRODUCT_DESCRIPTION
|
VARCHAR2(2000)
|
Y
|
|
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)
|
Y
|
|
Low cardinality column, can be used for bitmap index.
Schema SH uses it as foreign key
|
| WEIGHT_CLASS
|
NUMBER(1,0)
|
Y
|
|
Low cardinality column, can be used for bitmap index.
|
| WARRANTY_PERIOD
|
INTERVAL YEAR(2) TO MONTH(5)
|
Y
|
|
INTERVAL YEAER TO MONTH column, low cardinality, can be used for bitmap
index.
|
| SUPPLIER_ID
|
NUMBER(6,0)
|
Y
|
|
Offers possibility of extensions outside Common Schema.
|
| PRODUCT_STATUS
|
VARCHAR2(20)
|
Y
|
|
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)
|
Y
|
|
|
| MIN_PRICE
|
NUMBER(8,2)
|
Y
|
|
|
| CATALOG_URL
|
VARCHAR2(50)
|
Y
|
|
|