|
SH |
||||||||||||
|
|
|||||||||||||
| Description Columns Primary key Check constraints Foreign keys Unique keys Indexes Options Referenced by Triggers |
Description
snapshot table for snapshot SH.CAL_MONTH_SALES_MV
Columns
| Column | Datatype | Nullable | Default value | Comment |
| CALENDAR_MONTH_DESC | VARCHAR2(8) | N | ||
| DOLLARS | NUMBER(,) | Y |
| Check constraint | Check condition |
| SYS_C002537 | "CALENDAR_MONTH_DESC" IS NOT NULL |
| Index | Type | Uniqueness | Columns |
| I_SNAP$_CAL_MONTH_SALES_MV | FUNCTION-BASED NORMAL | UNIQUE |
| Option | Setting |
| Clustered | N |
| Generated by Oracle | N |
| Index Organized | N |
| Logging | Y |
| Partitioned | N |
| Temporary | N |
| Nested | N |