HR
| Table Name: | JOBS |
| Description: | jobs table with job titles and salary ranges. Contains 19 rows. References with employees and job_history table. |
| Primary Keys: | JOB_ID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| JOB_ID | VARCHAR2 (10) | None | No | Primary key of jobs table. |
| JOB_TITLE | VARCHAR2 (35) | None | No | A not null column that shows job title, e.g. AD_VP, FI_ACCOUNTANT |
| MIN_SALARY | NUMBER (6) | None | Yes | Minimum salary for a job title. |
| MAX_SALARY | NUMBER (6) | None | Yes | Maximum salary for a job title |
| Index | Type | Unique? | Fields |
|---|---|---|---|
| JOB_ID_PK | NORMAL | Yes | JOB_ID |
| Primary Key as Foreign Key Constraint | Affected Schema | Affected Table | Affected Field |
|---|---|---|---|
| EMP_JOB_FK | HR | EMPLOYEES | JOB_ID |
| JHIST_JOB_FK | HR | JOB_HISTORY | JOB_ID |