Difference between revisions of "OE.PRODUCT INFORMATION (table)"

From dbscript Online Help
Jump to: navigation, search
 
(One intermediate revision by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''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 20: Line 18:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
−
+
 
−
|-
+
|- valign="top"
 
| PRODUCT_ID
 
| PRODUCT_ID
 
| NUMBER(6, 0)
 
| NUMBER(6, 0)
Line 27: Line 25:
 
|  
 
|  
 
| Primary key column.
 
| Primary key column.
−
|-
+
|- valign="top"
 
| PRODUCT_NAME
 
| PRODUCT_NAME
 
| VARCHAR2(50)
 
| VARCHAR2(50)
Line 33: Line 31:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| PRODUCT_DESCRIPTION
 
| PRODUCT_DESCRIPTION
 
| VARCHAR2(2000)
 
| VARCHAR2(2000)
Line 41: Line 39:
 
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.
−
|-
+
|- valign="top"
 
| CATEGORY_ID
 
| CATEGORY_ID
 
| NUMBER(2, 0)
 
| NUMBER(2, 0)
Line 48: Line 46:
 
| 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
−
|-
+
|- valign="top"
 
| WEIGHT_CLASS
 
| WEIGHT_CLASS
 
| NUMBER(1, 0)
 
| NUMBER(1, 0)
Line 54: Line 52:
 
|  
 
|  
 
| Low cardinality column, can be used for bitmap index.
 
| Low cardinality column, can be used for bitmap index.
−
|-
+
|- valign="top"
 
| WARRANTY_PERIOD
 
| WARRANTY_PERIOD
 
| INTERVAL YEAR(2) TO MONTH
 
| INTERVAL YEAR(2) TO MONTH
Line 61: Line 59:
 
| 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.
−
|-
+
|- valign="top"
 
| SUPPLIER_ID
 
| SUPPLIER_ID
 
| NUMBER(6, 0)
 
| NUMBER(6, 0)
Line 67: Line 65:
 
|  
 
|  
 
| Offers possibility of extensions outside Common Schema.
 
| Offers possibility of extensions outside Common Schema.
−
|-
+
|- valign="top"
 
| PRODUCT_STATUS
 
| PRODUCT_STATUS
 
| VARCHAR2(20)
 
| VARCHAR2(20)
Line 75: Line 73:
 
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.
−
|-
+
|- valign="top"
 
| LIST_PRICE
 
| LIST_PRICE
 
| NUMBER(8, 2)
 
| NUMBER(8, 2)
Line 81: Line 79:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| MIN_PRICE
 
| MIN_PRICE
 
| NUMBER(8, 2)
 
| NUMBER(8, 2)
Line 87: Line 85:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| CATALOG_URL
 
| CATALOG_URL
 
| VARCHAR2(50)
 
| VARCHAR2(50)
Line 100: Line 98:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
−
|-
+
|- valign="top"
 
| PRODUCT_INFORMATION_PK
 
| PRODUCT_INFORMATION_PK
 
| PRODUCT_ID
 
| PRODUCT_ID
Line 111: Line 109:
 
| '''Type
 
| '''Type
 
| '''Columns
 
| '''Columns
−
+
 
−
|-
+
|- valign="top"
 
| PROD_SUPPLIER_IX
 
| PROD_SUPPLIER_IX
 
|  
 
|  
Line 124: Line 122:
 
| '''Expression
 
| '''Expression
 
| '''Description
 
| '''Description
−
+
 
−
|-
+
|- valign="top"
 
| PRODUCT_STATUS_LOV
 
| PRODUCT_STATUS_LOV
 
| product_status in ('orderable'
 
| product_status in ('orderable'
Line 141: Line 139:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[OE.INVENTORIES_(table)|OE.INVENTORIES]]
 
| [[OE.INVENTORIES_(table)|OE.INVENTORIES]]
 
| PRODUCT_ID
 
| PRODUCT_ID
 
| PRODUCT_ID
 
| PRODUCT_ID
−
|-
+
|- valign="top"
 
| [[PM.ONLINE_MEDIA_(table)|PM.ONLINE_MEDIA]]
 
| [[PM.ONLINE_MEDIA_(table)|PM.ONLINE_MEDIA]]
 
| PRODUCT_ID
 
| PRODUCT_ID
 
| PRODUCT_ID
 
| PRODUCT_ID
−
|-
+
|- valign="top"
 
| [[OE.ORDER_ITEMS_(table)|OE.ORDER_ITEMS]]
 
| [[OE.ORDER_ITEMS_(table)|OE.ORDER_ITEMS]]
 
| PRODUCT_ID
 
| PRODUCT_ID
 
| PRODUCT_ID
 
| PRODUCT_ID
−
|-
+
|- valign="top"
 
| [[OE.PRODUCT_DESCRIPTIONS_(table)|OE.PRODUCT_DESCRIPTIONS]]
 
| [[OE.PRODUCT_DESCRIPTIONS_(table)|OE.PRODUCT_DESCRIPTIONS]]
 
| PRODUCT_ID
 
| PRODUCT_ID
 
| PRODUCT_ID
 
| PRODUCT_ID
−
|-
+
|- valign="top"
 
| [[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]]
 
−
 
 
|}
 
|}

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
Retrieved from "http://dbshelp.devio.at/index.php?title=OE.PRODUCT_INFORMATION_(table)&oldid=3081"