Column
|
Datatype
|
Nullable
|
Default value
|
Comment
|
EMPLOYEE_ID
|
NUMBER(6,0)
|
N
|
|
A not null column in the complex primary key employee_id+start_date.
Foreign key to employee_id column of the employee table
|
START_DATE
|
DATE
|
N
|
|
A not null column in the complex primary key employee_id+start_date.
Must be less than the end_date of the job_history table. (enforced by
constraint jhist_date_interval)
|
END_DATE
|
DATE
|
N
|
|
Last day of the employee in this job role. A not null column. Must be
greater than the start_date of the job_history table.
(enforced by constraint jhist_date_interval)
|
JOB_ID
|
VARCHAR2(10)
|
N
|
|
Job role in which the employee worked in the past; foreign key to
job_id column in the jobs table. A not null column.
|
DEPARTMENT_ID
|
NUMBER(4,0)
|
Y
|
|
Department id in which the employee worked in the past; foreign key to deparment_id column in the departments table
|