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 |
CATEGORY_ID | NUMBER(2, 0) | null | | Low cardinality column, can be used for bitmap index. |
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 |
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 |
LIST_PRICE | NUMBER(8, 2) | null | | |
MIN_PRICE | NUMBER(8, 2) | null | | |
CATALOG_URL | VARCHAR2(50) | null | | |