|
SH |
||||||||||||
|
|
|||||||||||||
| Description Columns Primary key Check constraints Foreign keys Unique keys Indexes Options Referenced by Triggers |
Description
small dimension table
Columns
| Primary key | Columns |
| CHAN_PK | CHANNEL_ID |
| Check constraint | Check condition |
| CHAN_DESC_NN | "CHANNEL_DESC" IS NOT NULL |
| Index | Type | Uniqueness | Columns |
| CHAN_PK | NORMAL | UNIQUE | CHANNEL_ID |
| Option | Setting |
| Clustered | N |
| Generated by Oracle | N |
| Index Organized | N |
| Logging | Y |
| Partitioned | N |
| Temporary | N |
| Nested | N |
| Referenced by | Constraint |
| SALES | SALES_CHANNEL_FK |