|
SH |
||||||||||||
|
|
|||||||||||||
| Description Columns Primary key Check constraints Foreign keys Unique keys Indexes Options Referenced by Triggers |
Description
snapshot table for snapshot SH.FWEEK_PSCAT_SALES_MV
Columns
| Column | Datatype | Nullable | Default value | Comment |
| WEEK_ENDING_DAY | DATE | N | ||
| PROD_SUBCATEGORY | VARCHAR2(50) | N | ||
| DOLLARS | NUMBER(,) | Y | ||
| CHANNEL_ID | CHAR(1) | N | ||
| PROMO_ID | NUMBER(6,0) | N |
| Check constraint | Check condition |
| SYS_C002538 | "WEEK_ENDING_DAY" IS NOT NULL |
| SYS_C002539 | "PROD_SUBCATEGORY" IS NOT NULL |
| SYS_C002540 | "CHANNEL_ID" IS NOT NULL |
| SYS_C002541 | "PROMO_ID" IS NOT NULL |
| Index | Type | Uniqueness | Columns |
| FW_PSC_S_MV_CHAN_BIX | BITMAP | NONUNIQUE | CHANNEL_ID |
| FW_PSC_S_MV_PROMO_BIX | BITMAP | NONUNIQUE | PROMO_ID |
| FW_PSC_S_MV_SUBCAT_BIX | BITMAP | NONUNIQUE | PROD_SUBCATEGORY |
| FW_PSC_S_MV_WD_BIX | BITMAP | NONUNIQUE | WEEK_ENDING_DAY |
| I_SNAP$_FWEEK_PSCAT_SALES_ | FUNCTION-BASED NORMAL | UNIQUE |
| Option | Setting |
| Clustered | N |
| Generated by Oracle | N |
| Index Organized | N |
| Logging | Y |
| Partitioned | N |
| Temporary | N |
| Nested | N |