|
HR |
||||||||||||
|
|
|||||||||||||
| Description Columns Primary key Check constraints Foreign keys Unique keys Indexes Options Referenced by Triggers |
| Column | Datatype | Nullable | Default value | Comment |
| REGION_ID | NUMBER(,) | N | ||
| REGION_NAME | VARCHAR2(25) | Y |
| Primary key | Columns |
| REG_ID_PK | REGION_ID |
| Check constraint | Check condition |
| REGION_ID_NN | "REGION_ID" IS NOT NULL |
| Index | Type | Uniqueness | Columns |
| REG_ID_PK | NORMAL | UNIQUE | REGION_ID |
| Option | Setting |
| Clustered | N |
| Generated by Oracle | N |
| Index Organized | N |
| Logging | Y |
| Partitioned | N |
| Temporary | N |
| Nested | N |
| Referenced by | Constraint |
| COUNTRIES | COUNTR_REG_FK |