Page History: SH PRODUCTS (table)

Compare Page Revisions

wikibot ¶

Table	SH.PRODUCTS
Description	dimension table

Column	Data Type	Nullable	Default	Description
PROD_ID	NUMBER(6, 0)	not null		primary key
PROD_NAME	VARCHAR2(50)	not null		product name
PROD_DESC	VARCHAR2(4000)	not null		product description
PROD_SUBCATEGORY	VARCHAR2(50)	not null		product subcategory
PROD_SUBCATEGORY_ID	NUMBER	not null
PROD_SUBCATEGORY_DESC	VARCHAR2(2000)	not null		product subcategory description
PROD_CATEGORY	VARCHAR2(50)	not null		product category
PROD_CATEGORY_ID	NUMBER	not null
PROD_CATEGORY_DESC	VARCHAR2(2000)	not null		product category description
PROD_WEIGHT_CLASS	NUMBER(3, 0)	not null		product weight class
PROD_UNIT_OF_MEASURE	VARCHAR2(20)	null		product unit of measure
PROD_PACK_SIZE	VARCHAR2(30)	not null		product package size
SUPPLIER_ID	NUMBER(6, 0)	not null		this column
PROD_STATUS	VARCHAR2(20)	not null		product status
PROD_LIST_PRICE	NUMBER(8, 2)	not null		product list price
PROD_MIN_PRICE	NUMBER(8, 2)	not null		product minimum price
PROD_TOTAL	VARCHAR2(13)	not null
PROD_TOTAL_ID	NUMBER	not null
PROD_SRC_ID	NUMBER	null
PROD_EFF_FROM	DATE(7)	null
PROD_EFF_TO	DATE(7)	null
PROD_VALID	VARCHAR2(1)	null

Primary Key	Columns
PRODUCTS_PK	PROD_ID

Check Constraint	Expression	Description
SYS_C005127	"PROD_ID" IS NOT NULL
SYS_C005128	"PROD_NAME" IS NOT NULL
SYS_C005129	"PROD_DESC" IS NOT NULL
SYS_C005130	"PROD_SUBCATEGORY" IS NOT NULL
SYS_C005131	"PROD_SUBCATEGORY_ID" IS NOT NULL
SYS_C005132	"PROD_SUBCATEGORY_DESC" IS NOT NULL
SYS_C005133	"PROD_CATEGORY" IS NOT NULL
SYS_C005134	"PROD_CATEGORY_ID" IS NOT NULL
SYS_C005135	"PROD_CATEGORY_DESC" IS NOT NULL
SYS_C005136	"PROD_WEIGHT_CLASS" IS NOT NULL
SYS_C005137	"PROD_PACK_SIZE" IS NOT NULL
SYS_C005138	"SUPPLIER_ID" IS NOT NULL
SYS_C005139	"PROD_STATUS" IS NOT NULL
SYS_C005140	"PROD_LIST_PRICE" IS NOT NULL
SYS_C005141	"PROD_MIN_PRICE" IS NOT NULL
SYS_C005142	"PROD_TOTAL" IS NOT NULL
SYS_C005143	"PROD_TOTAL_ID" IS NOT NULL