|
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 |