|
HR |
||||||||||||
|
|
|||||||||||||
| Description Columns Primary key Check constraints Foreign keys Unique keys Indexes Options Referenced by Triggers |
Description
jobs table with job titles and salary ranges. Contains 19 rows.
References with employees and job_history table.
Columns
| Primary key | Columns |
| JOB_ID_PK | JOB_ID |
| Check constraint | Check condition |
| JOB_TITLE_NN | "JOB_TITLE" IS NOT NULL |
| Index | Type | Uniqueness | Columns |
| JOB_ID_PK | NORMAL | UNIQUE | JOB_ID |
| Option | Setting |
| Clustered | N |
| Generated by Oracle | N |
| Index Organized | N |
| Logging | Y |
| Partitioned | N |
| Temporary | N |
| Nested | N |
| Referenced by | Constraint |
| EMPLOYEES | EMP_JOB_FK |
| JOB_HISTORY | JHIST_JOB_FK |