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