Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: OE PRODUCT_INFORMATION (table)

Compare Page Revisions



« Older Revision - Back to Page History - Current Revision


Page Revision: 2010/06/24 07:59


wikibot

TableOE.PRODUCT_INFORMATION
DescriptionNon-industry-specific data in various categories.

Columns

ColumnData TypeNullableDefaultDescription
PRODUCT_IDNUMBER(6, 0)not null Primary key column.
PRODUCT_NAMEVARCHAR2(50)null  
PRODUCT_DESCRIPTIONVARCHAR2(2000)null Primary language description corresponding to translated_description in
CATEGORY_IDNUMBER(2, 0)null Low cardinality column, can be used for bitmap index.
WEIGHT_CLASSNUMBER(1, 0)null Low cardinality column, can be used for bitmap index.
WARRANTY_PERIODINTERVAL YEAR(2) TO MONTHnull INTERVAL YEAER TO MONTH column, low cardinality, can be used for bitmap
SUPPLIER_IDNUMBER(6, 0)null Offers possibility of extensions outside Common Schema.
PRODUCT_STATUSVARCHAR2(20)null Check constraint. Appropriate for complex rules, such as "All products in
LIST_PRICENUMBER(8, 2)null  
MIN_PRICENUMBER(8, 2)null  
CATALOG_URLVARCHAR2(50)null  

Primary Key

Primary KeyColumns
PRODUCT_INFORMATION_PKPRODUCT_ID

Indexes

IndexTypeColumns
PROD_SUPPLIER_IX SUPPLIER_ID

Check Constraints

Check ConstraintExpressionDescription
PRODUCT_STATUS_LOVproduct_status in ('orderable' 

Detail Tables

Detail TableColumnReferencing Column
OE.INVENTORIESPRODUCT_IDPRODUCT_ID
PM.ONLINE_MEDIAPRODUCT_IDPRODUCT_ID
OE.ORDER_ITEMSPRODUCT_IDPRODUCT_ID
OE.PRODUCT_DESCRIPTIONSPRODUCT_IDPRODUCT_ID
PM.PRINT_MEDIAPRODUCT_IDPRODUCT_ID

Dependencies

Reference TypeObject TypeReferencing Object
SelectViewOE.OC_PRODUCT_INFORMATION
SelectViewOE.PRODUCT_PRICES
SelectViewOE.PRODUCTS

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.