SH.FWEEK PSCAT SALES MV (table)

From dbscript Online Help
Jump to: navigation, search

wikibot

Table SH.FWEEK_PSCAT_SALES_MV

Columns

Column Data Type Nullable Default Description
WEEK_ENDING_DAY DATE(7) not null
PROD_SUBCATEGORY VARCHAR2(50) not null
DOLLARS NUMBER null
CHANNEL_ID NUMBER not null
PROMO_ID NUMBER not null

Indexes

Index Type Columns
FW_PSC_S_MV_CHAN_BIX CHANNEL_ID
FW_PSC_S_MV_PROMO_BIX PROMO_ID
FW_PSC_S_MV_SUBCAT_BIX PROD_SUBCATEGORY
FW_PSC_S_MV_WD_BIX WEEK_ENDING_DAY

Check Constraints

Check Constraint Expression Description
SYS_C005198 "WEEK_ENDING_DAY" IS NOT NULL
SYS_C005199 "PROD_SUBCATEGORY" IS NOT NULL
SYS_C005200 "CHANNEL_ID" IS NOT NULL
SYS_C005201 "PROMO_ID" IS NOT NULL