ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
OE.PRODUCT_INFORMATION_(table)
Print
RSS
Modified: 2009/08/29 21:04 by
wikibot
-
Uncategorized
(8)
»
Production.ProductInventory_(table)
»
PM.PRINT_MEDIA_(table)
»
OE.PRODUCT_INFORMATION_(table)
[X]
»
public.stpinterface_(table)
»
Person.ContactType_(table)
»
SH.COUNTRIES_(table)
»
IX.AQ$ORDERS_QUEUETABLE_R_(view)
»
HumanResources.EmployeeDepartmentHistory_(table)
»
Production.ProductInventory_(table)
»
PM.PRINT_MEDIA_(table)
»
OE.PRODUCT_INFORMATION_(table)
Edit
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
ScrewTurn Wiki
version 2.0.36. Some of the icons created by
FamFamFam
.