Editing OE.PRODUCT INFORMATION (table)
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
| Latest revision | Your text | ||
| Line 2: | Line 2: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| − | |- | + | |- |
| '''Table | | '''Table | ||
| OE.PRODUCT_INFORMATION | | OE.PRODUCT_INFORMATION | ||
| Line 8: | Line 8: | ||
| '''Description | | '''Description | ||
| Non-industry-specific data in various categories. | | Non-industry-specific data in various categories. | ||
| + | |- | ||
|} | |} | ||
| + | |||
=== Columns === | === Columns === | ||
| Line 18: | Line 20: | ||
| '''Default | | '''Default | ||
| '''Description | | '''Description | ||
| − | + | ||
| − | |- | + | |- |
| PRODUCT_ID | | PRODUCT_ID | ||
| NUMBER(6, 0) | | NUMBER(6, 0) | ||
| Line 25: | Line 27: | ||
| | | | ||
| Primary key column. | | Primary key column. | ||
| − | |- | + | |- |
| PRODUCT_NAME | | PRODUCT_NAME | ||
| VARCHAR2(50) | | VARCHAR2(50) | ||
| Line 31: | Line 33: | ||
| | | | ||
| | | | ||
| − | |- | + | |- |
| PRODUCT_DESCRIPTION | | PRODUCT_DESCRIPTION | ||
| VARCHAR2(2000) | | VARCHAR2(2000) | ||
| Line 39: | Line 41: | ||
oe.product_descriptions, added to provide non-NLS text columns for OC views | oe.product_descriptions, added to provide non-NLS text columns for OC views | ||
to accss. | to accss. | ||
| − | |- | + | |- |
| CATEGORY_ID | | CATEGORY_ID | ||
| NUMBER(2, 0) | | NUMBER(2, 0) | ||
| Line 46: | Line 48: | ||
| Low cardinality column, can be used for bitmap index. | | Low cardinality column, can be used for bitmap index. | ||
Schema SH uses it as foreign key | Schema SH uses it as foreign key | ||
| − | |- | + | |- |
| WEIGHT_CLASS | | WEIGHT_CLASS | ||
| NUMBER(1, 0) | | NUMBER(1, 0) | ||
| Line 52: | Line 54: | ||
| | | | ||
| Low cardinality column, can be used for bitmap index. | | Low cardinality column, can be used for bitmap index. | ||
| − | |- | + | |- |
| WARRANTY_PERIOD | | WARRANTY_PERIOD | ||
| INTERVAL YEAR(2) TO MONTH | | INTERVAL YEAR(2) TO MONTH | ||
| Line 59: | Line 61: | ||
| INTERVAL YEAER TO MONTH column, low cardinality, can be used for bitmap | | INTERVAL YEAER TO MONTH column, low cardinality, can be used for bitmap | ||
index. | index. | ||
| − | |- | + | |- |
| SUPPLIER_ID | | SUPPLIER_ID | ||
| NUMBER(6, 0) | | NUMBER(6, 0) | ||
| Line 65: | Line 67: | ||
| | | | ||
| Offers possibility of extensions outside Common Schema. | | Offers possibility of extensions outside Common Schema. | ||
| − | |- | + | |- |
| PRODUCT_STATUS | | PRODUCT_STATUS | ||
| VARCHAR2(20) | | VARCHAR2(20) | ||
| Line 73: | Line 75: | ||
status PRODUCTION must have at least one inventory entry." Also appropriate | status PRODUCTION must have at least one inventory entry." Also appropriate | ||
for a trigger auditing status change. | for a trigger auditing status change. | ||
| − | |- | + | |- |
| LIST_PRICE | | LIST_PRICE | ||
| NUMBER(8, 2) | | NUMBER(8, 2) | ||
| Line 79: | Line 81: | ||
| | | | ||
| | | | ||
| − | |- | + | |- |
| MIN_PRICE | | MIN_PRICE | ||
| NUMBER(8, 2) | | NUMBER(8, 2) | ||
| Line 85: | Line 87: | ||
| | | | ||
| | | | ||
| − | |- | + | |- |
| CATALOG_URL | | CATALOG_URL | ||
| VARCHAR2(50) | | VARCHAR2(50) | ||
| Line 98: | Line 100: | ||
| '''Primary Key | | '''Primary Key | ||
| '''Columns | | '''Columns | ||
| − | |- | + | |- |
| PRODUCT_INFORMATION_PK | | PRODUCT_INFORMATION_PK | ||
| PRODUCT_ID | | PRODUCT_ID | ||
| Line 109: | Line 111: | ||
| '''Type | | '''Type | ||
| '''Columns | | '''Columns | ||
| − | + | ||
| − | |- | + | |- |
| PROD_SUPPLIER_IX | | PROD_SUPPLIER_IX | ||
| | | | ||
| Line 122: | Line 124: | ||
| '''Expression | | '''Expression | ||
| '''Description | | '''Description | ||
| − | + | ||
| − | |- | + | |- |
| PRODUCT_STATUS_LOV | | PRODUCT_STATUS_LOV | ||
| product_status in ('orderable' | | product_status in ('orderable' | ||
| Line 139: | Line 141: | ||
| '''Column | | '''Column | ||
| '''Referencing Column | | '''Referencing Column | ||
| − | + | ||
| − | |- | + | |- |
| [[OE.INVENTORIES_(table)|OE.INVENTORIES]] | | [[OE.INVENTORIES_(table)|OE.INVENTORIES]] | ||
| PRODUCT_ID | | PRODUCT_ID | ||
| PRODUCT_ID | | PRODUCT_ID | ||
| − | |- | + | |- |
| [[PM.ONLINE_MEDIA_(table)|PM.ONLINE_MEDIA]] | | [[PM.ONLINE_MEDIA_(table)|PM.ONLINE_MEDIA]] | ||
| PRODUCT_ID | | PRODUCT_ID | ||
| PRODUCT_ID | | PRODUCT_ID | ||
| − | |- | + | |- |
| [[OE.ORDER_ITEMS_(table)|OE.ORDER_ITEMS]] | | [[OE.ORDER_ITEMS_(table)|OE.ORDER_ITEMS]] | ||
| PRODUCT_ID | | PRODUCT_ID | ||
| PRODUCT_ID | | PRODUCT_ID | ||
| − | |- | + | |- |
| [[OE.PRODUCT_DESCRIPTIONS_(table)|OE.PRODUCT_DESCRIPTIONS]] | | [[OE.PRODUCT_DESCRIPTIONS_(table)|OE.PRODUCT_DESCRIPTIONS]] | ||
| PRODUCT_ID | | PRODUCT_ID | ||
| PRODUCT_ID | | PRODUCT_ID | ||
| − | |- | + | |- |
| [[PM.PRINT_MEDIA_(table)|PM.PRINT_MEDIA]] | | [[PM.PRINT_MEDIA_(table)|PM.PRINT_MEDIA]] | ||
| PRODUCT_ID | | PRODUCT_ID | ||
| PRODUCT_ID | | PRODUCT_ID | ||
| + | |} | ||
| + | |||
| + | === Dependencies === | ||
| + | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| + | |- style="background:silver" | ||
| + | | '''Reference Type | ||
| + | | '''Object Type | ||
| + | | '''Referencing Object | ||
| + | |||
| + | |- | ||
| + | | Select | ||
| + | | View | ||
| + | | [[OE.OC_PRODUCT_INFORMATION_(view)|OE.OC_PRODUCT_INFORMATION]] | ||
| + | |||
| + | |- | ||
| + | | Select | ||
| + | | View | ||
| + | | [[OE.PRODUCT_PRICES_(view)|OE.PRODUCT_PRICES]] | ||
| + | |||
| + | |- | ||
| + | | Select | ||
| + | | View | ||
| + | | [[OE.PRODUCTS_(view)|OE.PRODUCTS]] | ||
| + | |||
|} | |} | ||
