Welcome Guest, you are in: • Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

SH FWEEK_PSCAT_SALES_MV (table)

RSS
Modified on 2011/08/27 12:11 by wikibot Categorized as Uncategorized

wikibot

TableSH.FWEEK_PSCAT_SALES_MV

Columns

ColumnData TypeNullableDefaultDescription
WEEK_ENDING_DAYDATE(7)not null  
PROD_SUBCATEGORYVARCHAR2(50)not null  
DOLLARSNUMBERnull  
CHANNEL_IDNUMBERnot null  
PROMO_IDNUMBERnot null  

Indexes

IndexTypeColumns
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 ConstraintExpressionDescription
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 

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.