COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS |
---|---|---|---|---|---|
JOB_ID | VARCHAR2(10 BYTE) | No | null | 1 | Primary key of jobs table. |
JOB_TITLE | VARCHAR2(35 BYTE) | No | null | 2 | A not null column that shows job title, e.g. AD_VP, FI_ACCOUNTANT |
MIN_SALARY | NUMBER(6,0) | Yes | null | 3 | Minimum salary for a job title. |
MAX_SALARY | NUMBER(6,0) | Yes | null | 4 | Maximum salary for a job title |