OE.PRODUCT INFORMATION (table) - Revision history

Bot at 09:35, 27 August 2011

2011-08-27T09:35:13Z

Bot at 05:15, 24 June 2010

2010-06-24T05:15:45Z

Bot at 07:28, 11 February 2010

2010-02-11T07:28:29Z

Bot at 19:01, 24 August 2009

2009-08-24T19:01:04Z

Bot: Replacing page with '== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''table | OE.PRODUCT_INFORMATION |- |}'

2009-08-24T18:57:20Z

Replacing page with '== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''table | OE.PRODUCT_INFORMATION |- |}'

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | OE.PRODUCT_INFORMATION |- |} {| border="1" cellpadding="5" cellspacing="0" s...

2009-05-02T17:06:08Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | OE.PRODUCT_INFORMATION |- |} {| border="1" cellpadding="5" cellspacing="0" s...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| OE.PRODUCT_INFORMATION
|-
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column
| '''Data Type
| '''Nullable
| '''Default
| '''PK
| '''Index

|-
| PRODUCT_ID
| NUMBER
| not null
|
| PRODUCT_INFORMATION_PK
|
|-
| PRODUCT_NAME
| VARCHAR2
| null
|
|
|
|-
| PRODUCT_DESCRIPTION
| VARCHAR2
| null
|
|
|
|-
| CATEGORY_ID
| NUMBER
| null
|
|
|
|-
| WEIGHT_CLASS
| NUMBER
| null
|
|
|
|-
| WARRANTY_PERIOD
| INTERVAL YEAR(2) TO MONTH
| null
|
|
|
|-
| SUPPLIER_ID
| NUMBER
| null
|
|
| PROD_SUPPLIER_IX
|-
| PRODUCT_STATUS
| VARCHAR2
| null
|
|
|
|-
| LIST_PRICE
| NUMBER
| null
|
|
|
|-
| MIN_PRICE
| NUMBER
| null
|
|
|
|-
| CATALOG_URL
| VARCHAR2
| null
|
|
|
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Detail Table
| '''Column
| '''Referencing Column

|-
| [[OE.INVENTORIES_(table)|OE.INVENTORIES]]
| PRODUCT_ID
| PRODUCT_ID
|-
| [[PM.ONLINE_MEDIA_(table)|PM.ONLINE_MEDIA]]
| PRODUCT_ID
| PRODUCT_ID
|-
| [[OE.ORDER_ITEMS_(table)|OE.ORDER_ITEMS]]
| PRODUCT_ID
| PRODUCT_ID
|-
| [[OE.PRODUCT_DESCRIPTIONS_(table)|OE.PRODUCT_DESCRIPTIONS]]
| PRODUCT_ID
| PRODUCT_ID
|-
| [[PM.PRINT_MEDIA_(table)|PM.PRINT_MEDIA]]
| PRODUCT_ID
| PRODUCT_ID
|}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | OE.PRODUCT_INFORMATION
@@ Line 8: / Line 8: @@
 | '''Description
 | Non-industry-specific data in various categories.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
-|-
+|- valign="top"
 | PRODUCT_ID
 | NUMBER(6, 0)
@@ Line 27: / Line 25: @@
+|
 | Primary key column.
-|-
+|- valign="top"
 | PRODUCT_NAME
 | VARCHAR2(50)
@@ Line 33: / Line 31: @@
+|
+|
-|-
+|- valign="top"
 | PRODUCT_DESCRIPTION
 | VARCHAR2(2000)
@@ Line 41: / Line 39: @@
 oe.product_descriptions, added to provide non-NLS text columns for OC views
 to accss.
-|-
+|- valign="top"
 | CATEGORY_ID
 | NUMBER(2, 0)
@@ Line 48: / Line 46: @@
 | Low cardinality column, can be used for bitmap index.
 Schema SH uses it as foreign key
-|-
+|- valign="top"
 | WEIGHT_CLASS
 | NUMBER(1, 0)
@@ Line 54: / Line 52: @@
+|
 | Low cardinality column, can be used for bitmap index.
-|-
+|- valign="top"
 | WARRANTY_PERIOD
 | INTERVAL YEAR(2) TO MONTH
@@ Line 61: / Line 59: @@
 | INTERVAL YEAER TO MONTH column, low cardinality, can be used for bitmap
 index.
-|-
+|- valign="top"
 | SUPPLIER_ID
 | NUMBER(6, 0)
@@ Line 67: / Line 65: @@
+|
 | Offers possibility of extensions outside Common Schema.
-|-
+|- valign="top"
 | PRODUCT_STATUS
 | VARCHAR2(20)
@@ Line 75: / Line 73: @@
 status PRODUCTION must have at least one inventory entry." Also appropriate
 for a trigger auditing status change.
-|-
+|- valign="top"
 | LIST_PRICE
 | NUMBER(8, 2)
@@ Line 81: / Line 79: @@
+|
+|
-|-
+|- valign="top"
 | MIN_PRICE
 | NUMBER(8, 2)
@@ Line 87: / Line 85: @@
+|
+|
-|-
+|- valign="top"
 | CATALOG_URL
 | VARCHAR2(50)
@@ Line 100: / Line 98: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PRODUCT_INFORMATION_PK
 | PRODUCT_ID
@@ Line 111: / Line 109: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | PROD_SUPPLIER_IX
+|
@@ Line 124: / Line 122: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | PRODUCT_STATUS_LOV
 | product_status in ('orderable'
@@ Line 141: / Line 139: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[OE.INVENTORIES_(table)|OE.INVENTORIES]]
 | PRODUCT_ID
 | PRODUCT_ID
-|-
+|- valign="top"
 | [[PM.ONLINE_MEDIA_(table)|PM.ONLINE_MEDIA]]
 | PRODUCT_ID
 | PRODUCT_ID
-|-
+|- valign="top"
 | [[OE.ORDER_ITEMS_(table)|OE.ORDER_ITEMS]]
 | PRODUCT_ID
 | PRODUCT_ID
-|-
+|- valign="top"
 | [[OE.PRODUCT_DESCRIPTIONS_(table)|OE.PRODUCT_DESCRIPTIONS]]
 | PRODUCT_ID
 | PRODUCT_ID
-|-
+|- valign="top"
 | [[PM.PRINT_MEDIA_(table)|PM.PRINT_MEDIA]]
 | PRODUCT_ID
@@ Line 171: / Line 169: @@
 | '''Referencing Object
-|-
+|- valign="top"
 | Select
 | View
 | [[OE.OC_PRODUCT_INFORMATION_(view)|OE.OC_PRODUCT_INFORMATION]]
-|-
+|- valign="top"
 | Select
 | View
 | [[OE.PRODUCT_PRICES_(view)|OE.PRODUCT_PRICES]]
-|-
+|- valign="top"
 | Select
 | View