SH.FWEEK PSCAT SALES MV (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Table SH.FWEEK_PSCAT_SALES_MV

Columns[edit]

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

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

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