HR.JOBS (table) - Revision history

Bot at 05:14, 24 June 2010

2010-06-24T05:14:26Z

Bot at 07:26, 11 February 2010

2010-02-11T07:26:56Z

Bot at 19:00, 24 August 2009

2009-08-24T19:00:21Z

Bot at 18:56, 24 August 2009

2009-08-24T18:56:43Z

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

2009-05-02T17:05:29Z

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

New page

== wikibot ==

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

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

|-
| JOB_ID
| VARCHAR2
| not null
|
| JOB_ID_PK
|
|-
| JOB_TITLE
| VARCHAR2
| not null
|
|
|
|-
| MIN_SALARY
| NUMBER
| null
|
|
|
|-
| MAX_SALARY
| NUMBER
| null
|
|
|
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Detail Table
| '''Column
| '''Referencing Column

|-
| [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]]
| JOB_ID
| JOB_ID
|-
| [[HR.JOB_HISTORY_(table)|HR.JOB_HISTORY]]
| JOB_ID
| JOB_ID
|}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | HR.JOBS
@@ Line 9: / Line 9: @@
 | jobs table with job titles and salary ranges. Contains 19 rows.
 References with employees and job_history table.
 |}
 === Columns ===
@@ Line 21: / Line 19: @@
 | '''Default
 | '''Description
-−
-|-
+|- valign="top"
 | JOB_ID
 | VARCHAR2(10)
@@ Line 28: / Line 26: @@
+|
 | Primary key of jobs table.
-|-
+|- valign="top"
 | JOB_TITLE
 | VARCHAR2(35)
@@ Line 34: / Line 32: @@
+|
 | A not null column that shows job title, e.g. AD_VP, FI_ACCOUNTANT
-|-
+|- valign="top"
 | MIN_SALARY
 | NUMBER(6, 0)
@@ Line 40: / Line 38: @@
+|
 | Minimum salary for a job title.
-|-
+|- valign="top"
 | MAX_SALARY
 | NUMBER(6, 0)
@@ Line 53: / Line 51: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | JOB_ID_PK
 | JOB_ID
@@ Line 64: / Line 62: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | JOB_TITLE_NN
 | "JOB_TITLE" IS NOT NULL
@@ Line 77: / Line 75: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]]
 | JOB_ID
 | JOB_ID
-|-
+|- valign="top"
 | [[HR.JOB_HISTORY_(table)|HR.JOB_HISTORY]]
 | JOB_ID
 | JOB_ID
 |}