Difference between revisions of "SH.FWEEK PSCAT SALES MV (table)"
| Line 55: | Line 55: | ||
| '''Columns | | '''Columns | ||
| + | |- valign="top" | ||
| + | | FW_PSC_S_MV_CHAN_BIX | ||
| + | | | ||
| + | | CHANNEL_ID | ||
| + | |- valign="top" | ||
| + | | FW_PSC_S_MV_PROMO_BIX | ||
| + | | | ||
| + | | PROMO_ID | ||
|- valign="top" | |- valign="top" | ||
| FW_PSC_S_MV_SUBCAT_BIX | | FW_PSC_S_MV_SUBCAT_BIX | ||
| Line 63: | Line 71: | ||
| | | | ||
| WEEK_ENDING_DAY | | WEEK_ENDING_DAY | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
Latest revision as of 10:36, 27 August 2011
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 |
