HR.JOBS (table)
From dbscript Online Help
Contents |
wikibot
| Table | HR.JOBS |
| Description | jobs table with job titles and salary ranges. Contains 19 rows.
References with employees and job_history table. |
Columns
| Column | Data Type | Nullable | Default | Description |
| JOB_ID | VARCHAR2(10) | not null | Primary key of jobs table. | |
| JOB_TITLE | VARCHAR2(35) | not null | A not null column that shows job title, e.g. AD_VP, FI_ACCOUNTANT | |
| MIN_SALARY | NUMBER(6, 0) | null | Minimum salary for a job title. | |
| MAX_SALARY | NUMBER(6, 0) | null | Maximum salary for a job title |
Primary Key
| Primary Key | Columns |
| JOB_ID_PK | JOB_ID |
Check Constraints
| Check Constraint | Expression | Description |
| JOB_TITLE_NN | "JOB_TITLE" IS NOT NULL |
Detail Tables
| Detail Table | Column | Referencing Column |
| HR.EMPLOYEES | JOB_ID | JOB_ID |
| HR.JOB_HISTORY | JOB_ID | JOB_ID |
