SH.PRODUCTS (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Table SH.PRODUCTS
Description dimension table

Columns[edit]

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[edit]

Primary Key Columns
PRODUCTS_PK PROD_ID

Indexes[edit]

Index Type Columns
PRODUCTS_PROD_CAT_IX PROD_CATEGORY
PRODUCTS_PROD_STATUS_BIX PROD_STATUS
PRODUCTS_PROD_SUBCAT_IX PROD_SUBCATEGORY

Check Constraints[edit]

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

Detail Tables[edit]

Detail Table Column Referencing Column
SH.COSTS PROD_ID PROD_ID
SH.SALES PROD_ID PROD_ID