|
SH |
||||||||||||
|
|
|||||||||||||
| Description Columns Primary key Check constraints Foreign keys Unique keys Indexes Options Referenced by Triggers |
Description
country dimension table (snowflake)
Columns
| Primary key | Columns |
| COUNTRY_PK | COUNTRY_ID |
| Check constraint | Check condition |
| COUNTRY_COUNTRY_NAME_NN | "COUNTRY_NAME" IS NOT NULL |
| Index | Type | Uniqueness | Columns |
| COUNTRY_PK | NORMAL | UNIQUE | COUNTRY_ID |
| Option | Setting |
| Clustered | N |
| Generated by Oracle | N |
| Index Organized | N |
| Logging | Y |
| Partitioned | N |
| Temporary | N |
| Nested | N |
| Referenced by | Constraint |
| CUSTOMERS | CUSTOMERS_COUNTRY_FK |