Editing HR.JOB HISTORY (table)
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
| Latest revision | Your text | ||
| Line 2: | Line 2: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| − | |- | + | |- |
| '''Table | | '''Table | ||
| HR.JOB_HISTORY | | HR.JOB_HISTORY | ||
| Line 12: | Line 12: | ||
employee. Contains a complex primary key: employee_id+start_date. | employee. Contains a complex primary key: employee_id+start_date. | ||
Contains 25 rows. References with jobs, employees, and departments tables. | Contains 25 rows. References with jobs, employees, and departments tables. | ||
| + | |- | ||
|} | |} | ||
| + | |||
=== Columns === | === Columns === | ||
| Line 22: | Line 24: | ||
| '''Default | | '''Default | ||
| '''Description | | '''Description | ||
| − | + | ||
| − | |- | + | |- |
| EMPLOYEE_ID | | EMPLOYEE_ID | ||
| NUMBER(6, 0) | | NUMBER(6, 0) | ||
| Line 30: | Line 32: | ||
| A not null column in the complex primary key employee_id+start_date. | | A not null column in the complex primary key employee_id+start_date. | ||
Foreign key to employee_id column of the employee table | Foreign key to employee_id column of the employee table | ||
| − | |- | + | |- |
| START_DATE | | START_DATE | ||
| DATE(7) | | DATE(7) | ||
| Line 38: | Line 40: | ||
Must be less than the end_date of the job_history table. (enforced by | Must be less than the end_date of the job_history table. (enforced by | ||
constraint jhist_date_interval) | constraint jhist_date_interval) | ||
| − | |- | + | |- |
| END_DATE | | END_DATE | ||
| DATE(7) | | DATE(7) | ||
| Line 46: | Line 48: | ||
greater than the start_date of the job_history table. | greater than the start_date of the job_history table. | ||
(enforced by constraint jhist_date_interval) | (enforced by constraint jhist_date_interval) | ||
| − | |- | + | |- |
| JOB_ID | | JOB_ID | ||
| VARCHAR2(10) | | VARCHAR2(10) | ||
| Line 53: | Line 55: | ||
| Job role in which the employee worked in the past; foreign key to | | Job role in which the employee worked in the past; foreign key to | ||
job_id column in the jobs table. A not null column. | job_id column in the jobs table. A not null column. | ||
| − | |- | + | |- |
| DEPARTMENT_ID | | DEPARTMENT_ID | ||
| NUMBER(4, 0) | | NUMBER(4, 0) | ||
| Line 66: | Line 68: | ||
| '''Primary Key | | '''Primary Key | ||
| '''Columns | | '''Columns | ||
| − | |- | + | |- |
| JHIST_EMP_ID_ST_DATE_PK | | JHIST_EMP_ID_ST_DATE_PK | ||
| EMPLOYEE_ID, START_DATE | | EMPLOYEE_ID, START_DATE | ||
| Line 77: | Line 79: | ||
| '''Type | | '''Type | ||
| '''Columns | | '''Columns | ||
| − | + | ||
| − | |- | + | |- |
| JHIST_DEPARTMENT_IX | | JHIST_DEPARTMENT_IX | ||
| | | | ||
| DEPARTMENT_ID | | DEPARTMENT_ID | ||
| − | |- | + | |- |
| + | | JHIST_JOB_IX | ||
| + | | | ||
| + | | JOB_ID | ||
| + | |- | ||
| JHIST_EMPLOYEE_IX | | JHIST_EMPLOYEE_IX | ||
| | | | ||
| EMPLOYEE_ID | | EMPLOYEE_ID | ||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| Line 98: | Line 100: | ||
| '''Expression | | '''Expression | ||
| '''Description | | '''Description | ||
| − | + | ||
| − | |- | + | |- |
| JHIST_DATE_INTERVAL | | JHIST_DATE_INTERVAL | ||
| end_date > start_date | | end_date > start_date | ||
| | | | ||
| − | |- | + | |- |
| JHIST_EMPLOYEE_NN | | JHIST_EMPLOYEE_NN | ||
| "EMPLOYEE_ID" IS NOT NULL | | "EMPLOYEE_ID" IS NOT NULL | ||
| | | | ||
| − | |- | + | |- |
| JHIST_END_DATE_NN | | JHIST_END_DATE_NN | ||
| "END_DATE" IS NOT NULL | | "END_DATE" IS NOT NULL | ||
| | | | ||
| − | |- | + | |- |
| JHIST_JOB_NN | | JHIST_JOB_NN | ||
| "JOB_ID" IS NOT NULL | | "JOB_ID" IS NOT NULL | ||
| | | | ||
| − | |- | + | |- |
| JHIST_START_DATE_NN | | JHIST_START_DATE_NN | ||
| "START_DATE" IS NOT NULL | | "START_DATE" IS NOT NULL | ||
| Line 127: | Line 129: | ||
| '''Column | | '''Column | ||
| '''Referenced Column | | '''Referenced Column | ||
| − | + | ||
| − | |- | + | |- |
| [[HR.DEPARTMENTS_(table)|HR.DEPARTMENTS]] | | [[HR.DEPARTMENTS_(table)|HR.DEPARTMENTS]] | ||
| DEPARTMENT_ID | | DEPARTMENT_ID | ||
| DEPARTMENT_ID | | DEPARTMENT_ID | ||
| − | |- | + | |- |
| [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]] | | [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]] | ||
| EMPLOYEE_ID | | EMPLOYEE_ID | ||
| EMPLOYEE_ID | | EMPLOYEE_ID | ||
| − | |- | + | |- |
| [[HR.JOBS_(table)|HR.JOBS]] | | [[HR.JOBS_(table)|HR.JOBS]] | ||
| JOB_ID | | JOB_ID | ||
| JOB_ID | | JOB_ID | ||
| + | |} | ||
| + | |||
| + | === Dependencies === | ||
| + | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| + | |- style="background:silver" | ||
| + | | '''Reference Type | ||
| + | | '''Object Type | ||
| + | | '''Referencing Object | ||
| + | |||
| + | |- | ||
| + | | Insert | ||
| + | | Procedure | ||
| + | | [[HR.ADD_JOB_HISTORY_(procedure)|HR.ADD_JOB_HISTORY]] | ||
| + | |||
|} | |} | ||
