Difference between revisions of "OE.PRODUCT INFORMATION (table)"
| Line 160: | Line 160: | ||
| PRODUCT_ID | | PRODUCT_ID | ||
| PRODUCT_ID | | PRODUCT_ID | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
Latest revision as of 10:35, 27 August 2011
wikibot[edit]
| Table | OE.PRODUCT_INFORMATION |
| Description | Non-industry-specific data in various categories. |
Columns[edit]
| 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[edit]
| Primary Key | Columns |
| PRODUCT_INFORMATION_PK | PRODUCT_ID |
Indexes[edit]
| Index | Type | Columns |
| PROD_SUPPLIER_IX | SUPPLIER_ID |
Check Constraints[edit]
| Check Constraint | Expression | Description |
| PRODUCT_STATUS_LOV | product_status in ('orderable'
,'planned'
,'under development'
,'obsolete')
|
Detail Tables[edit]
| Detail Table | Column | Referencing Column |
| OE.INVENTORIES | PRODUCT_ID | PRODUCT_ID |
| PM.ONLINE_MEDIA | PRODUCT_ID | PRODUCT_ID |
| OE.ORDER_ITEMS | PRODUCT_ID | PRODUCT_ID |
| OE.PRODUCT_DESCRIPTIONS | PRODUCT_ID | PRODUCT_ID |
| PM.PRINT_MEDIA | PRODUCT_ID | PRODUCT_ID |
