HR.JOB HISTORY (table) - Revision history

Bot at 09:33, 27 August 2011

2011-08-27T09:33:53Z

Bot at 05:14, 24 June 2010

2010-06-24T05:14:25Z

Bot at 07:26, 11 February 2010

2010-02-11T07:26:54Z

Bot at 19:00, 24 August 2009

2009-08-24T19:00:22Z

Bot at 18:56, 24 August 2009

2009-08-24T18:56:44Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | HR.JOB_HISTORY |- |} {| border="1" cellpadding="5" cellspacing="0" style="bo...

2009-05-02T17:05:31Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | HR.JOB_HISTORY |- |} {| border="1" cellpadding="5" cellspacing="0" style="bo...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| HR.JOB_HISTORY
|-
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column
| '''Data Type
| '''Nullable
| '''Default
| '''PK
| '''Index

|-
| EMPLOYEE_ID
| NUMBER
| not null
|
| JHIST_EMP_ID_ST_DATE_PK
| JHIST_EMPLOYEE_IX
|-
| START_DATE
| DATE
| not null
|
| JHIST_EMP_ID_ST_DATE_PK
|
|-
| END_DATE
| DATE
| not null
|
|
|
|-
| JOB_ID
| VARCHAR2
| not null
|
|
| JHIST_JOB_IX
|-
| DEPARTMENT_ID
| NUMBER
| null
|
|
| JHIST_DEPARTMENT_IX
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation
| '''Column
| '''Referenced Column

|-
| [[HR.DEPARTMENTS_(table)|HR.DEPARTMENTS]]
| DEPARTMENT_ID
| DEPARTMENT_ID
|-
| [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]]
| EMPLOYEE_ID
| EMPLOYEE_ID
|-
| [[HR.JOBS_(table)|HR.JOBS]]
| JOB_ID
| JOB_ID
|}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | HR.JOB_HISTORY
@@ Line 12: / Line 12: @@
 employee. Contains a complex primary key: employee_id+start_date.
 Contains 25 rows. References with jobs, employees, and departments tables.
 |}
 === Columns ===
@@ Line 24: / Line 22: @@
 | '''Default
 | '''Description
-−
-|-
+|- valign="top"
 | EMPLOYEE_ID
 | NUMBER(6, 0)
@@ Line 32: / Line 30: @@
 | A not null column in the complex primary key employee_id+start_date.
 Foreign key to employee_id column of the employee table
-|-
+|- valign="top"
 | START_DATE
 | DATE(7)
@@ Line 40: / Line 38: @@
 Must be less than the end_date of the job_history table. (enforced by
 constraint jhist_date_interval)
-|-
+|- valign="top"
 | END_DATE
 | DATE(7)
@@ Line 48: / Line 46: @@
 greater than the start_date of the job_history table.
 (enforced by constraint jhist_date_interval)
-|-
+|- valign="top"
 | JOB_ID
 | VARCHAR2(10)
@@ Line 55: / Line 53: @@
 | Job role in which the employee worked in the past; foreign key to
 job_id column in the jobs table. A not null column.
-|-
+|- valign="top"
 | DEPARTMENT_ID
 | NUMBER(4, 0)
@@ Line 68: / Line 66: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | JHIST_EMP_ID_ST_DATE_PK
 | EMPLOYEE_ID, START_DATE
@@ Line 79: / Line 77: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | JHIST_DEPARTMENT_IX
+|
 | DEPARTMENT_ID
-|-
+|- valign="top"
 | JHIST_JOB_IX
+|
 | JOB_ID
-|-
+|- valign="top"
 | JHIST_EMPLOYEE_IX
+|
@@ Line 100: / Line 98: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | JHIST_DATE_INTERVAL
 | end_date > start_date
+|
-|-
+|- valign="top"
 | JHIST_EMPLOYEE_NN
 | "EMPLOYEE_ID" IS NOT NULL
+|
-|-
+|- valign="top"
 | JHIST_END_DATE_NN
 | "END_DATE" IS NOT NULL
+|
-|-
+|- valign="top"
 | JHIST_JOB_NN
 | "JOB_ID" IS NOT NULL
+|
-|-
+|- valign="top"
 | JHIST_START_DATE_NN
 | "START_DATE" IS NOT NULL
@@ Line 129: / Line 127: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[HR.DEPARTMENTS_(table)|HR.DEPARTMENTS]]
 | DEPARTMENT_ID
 | DEPARTMENT_ID
-|-
+|- valign="top"
 | [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]]
 | EMPLOYEE_ID
 | EMPLOYEE_ID
-|-
+|- valign="top"
 | [[HR.JOBS_(table)|HR.JOBS]]
 | JOB_ID
@@ Line 151: / Line 149: @@
 | '''Referencing Object
-|-
+|- valign="top"
 | Insert
 | Procedure