Prior Table Table JOBS Next Table

Comment for Table JOBS
Comment 
jobs table with job titles and salary ranges. Contains 19 rows.
References with employees and job_history table.

Columns of Table JOBS
Column ID Column Name Datatype Not Null Data Default Comments
1 JOB_ID VARCHAR2(10 BYTE) Y   Primary key of jobs table.
2 JOB_TITLE VARCHAR2(35 BYTE) Y   A not null column that shows job title, e.g. AD_VP, FI_ACCOUNTANT
3 MIN_SALARY NUMBER(6)     Minimum salary for a job title.
4 MAX_SALARY NUMBER(6)     Maximum salary for a job title

Indexes on Table JOBS
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
UNIQUE JOB_ID_PK NORMAL JOB_ID <none>        

PK, UK, & Check Constraints on Table JOBS
Constraint Name Type Condition Status Columns
JOB_TITLE_NN Check "JOB_TITLE" IS NOT NULL ENABLED JOB_TITLE
JOB_ID_PK Primary Key   ENABLED JOB_ID

Table JOBS does not have...
Partitions
Foreign Key Constraints
Redaction Policies