OE.PRODUCT INFORMATION (table)

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