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

From dbscript Online Help
Jump to: navigation, search
(Replacing page with '== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''table | OE.PRODUCT_INFORMATION |- |}')
Line 3: Line 3:
 
{| 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
 
|-
 
|-
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''PK
 +
| '''Index
 +
 +
|-
 +
| PRODUCT_ID
 +
| NUMBER(6, 0)
 +
| not null
 +
|
 +
| PRODUCT_INFORMATION_PK
 +
|
 +
|-
 +
| PRODUCT_NAME
 +
| VARCHAR2(50)
 +
| null
 +
|
 +
|
 +
|
 +
|-
 +
| PRODUCT_DESCRIPTION
 +
| VARCHAR2(2000)
 +
| null
 +
|
 +
|
 +
|
 +
|-
 +
| CATEGORY_ID
 +
| NUMBER(2, 0)
 +
| null
 +
|
 +
|
 +
|
 +
|-
 +
| WEIGHT_CLASS
 +
| NUMBER(1, 0)
 +
| null
 +
|
 +
|
 +
|
 +
|-
 +
| WARRANTY_PERIOD
 +
| INTERVAL YEAR(2) TO MONTH
 +
| null
 +
|
 +
|
 +
|
 +
|-
 +
| SUPPLIER_ID
 +
| NUMBER(6, 0)
 +
| null
 +
|
 +
|
 +
| PROD_SUPPLIER_IX
 +
|-
 +
| PRODUCT_STATUS
 +
| VARCHAR2(20)
 +
| null
 +
|
 +
|
 +
|
 +
|-
 +
| LIST_PRICE
 +
| NUMBER(8, 2)
 +
| null
 +
|
 +
|
 +
|
 +
|-
 +
| MIN_PRICE
 +
| NUMBER(8, 2)
 +
| null
 +
|
 +
|
 +
|
 +
|-
 +
| CATALOG_URL
 +
| VARCHAR2(50)
 +
| 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
 
|}
 
|}

Revision as of 21:01, 24 August 2009

wikibot

Table OE.PRODUCT_INFORMATION


Column Data Type Nullable Default PK Index
PRODUCT_ID NUMBER(6, 0) not null PRODUCT_INFORMATION_PK
PRODUCT_NAME VARCHAR2(50) null
PRODUCT_DESCRIPTION VARCHAR2(2000) null
CATEGORY_ID NUMBER(2, 0) null
WEIGHT_CLASS NUMBER(1, 0) null
WARRANTY_PERIOD INTERVAL YEAR(2) TO MONTH null
SUPPLIER_ID NUMBER(6, 0) null PROD_SUPPLIER_IX
PRODUCT_STATUS VARCHAR2(20) null
LIST_PRICE NUMBER(8, 2) null
MIN_PRICE NUMBER(8, 2) null
CATALOG_URL VARCHAR2(50) null


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=876"