From dbscript Online Help
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
|
|
