Welcome Guest, you are in: <root> • Login

Page History: SH FWEEK_PSCAT_SALES_MV (table)

Compare Page Revisions

1 0 Current 1 0

« Older Revision - Back to Page History - Current Revision

Page Revision: 2010/06/24 08:00

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_SUBCAT_BIX		PROD_SUBCATEGORY
FW_PSC_S_MV_WD_BIX		WEEK_ENDING_DAY
FW_PSC_S_MV_CHAN_BIX		CHANNEL_ID
FW_PSC_S_MV_PROMO_BIX		PROMO_ID

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