HR.DEPARTMENTS (table) - Revision history

Bot at 09:33, 27 August 2011

2011-08-27T09:33:46Z

Bot at 05:14, 24 June 2010

2010-06-24T05:14:18Z

Bot at 07:26, 11 February 2010

2010-02-11T07:26:46Z

Bot at 19:00, 24 August 2009

2009-08-24T19:00:18Z

Bot at 18:56, 24 August 2009

2009-08-24T18:56:40Z

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

2009-05-02T17:05:26Z

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

New page

== wikibot ==

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

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

|-
| DEPARTMENT_ID
| NUMBER
| not null
|
| DEPT_ID_PK
|
|-
| DEPARTMENT_NAME
| VARCHAR2
| not null
|
|
|
|-
| MANAGER_ID
| NUMBER
| null
|
|
|
|-
| LOCATION_ID
| NUMBER
| null
|
|
| DEPT_LOCATION_IX
|}

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

|-
| [[HR.LOCATIONS_(table)|HR.LOCATIONS]]
| LOCATION_ID
| LOCATION_ID
|-
| [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]]
| MANAGER_ID
| EMPLOYEE_ID
|}

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

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

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | HR.DEPARTMENTS
@@ Line 9: / Line 9: @@
 | Departments table that shows details of departments where employees
 work. Contains 27 rows; references with locations, employees, and job_history tables.
 |}
 === Columns ===
@@ Line 21: / Line 19: @@
 | '''Default
 | '''Description
-−
-|-
+|- valign="top"
 | DEPARTMENT_ID
 | NUMBER(4, 0)
@@ Line 28: / Line 26: @@
+|
 | Primary key column of departments table.
-|-
+|- valign="top"
 | DEPARTMENT_NAME
 | VARCHAR2(30)
@@ Line 36: / Line 34: @@
 Marketing, Purchasing, Human Resources, Shipping, IT, Executive, Public
 Relations, Sales, Finance, and Accounting.
-|-
+|- valign="top"
 | MANAGER_ID
 | NUMBER(6, 0)
@@ Line 42: / Line 40: @@
+|
 | Manager_id of a department. Foreign key to employee_id column of employees table. The manager_id column of the employee table references this column.
-|-
+|- valign="top"
 | LOCATION_ID
 | NUMBER(4, 0)
@@ Line 55: / Line 53: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | DEPT_ID_PK
 | DEPARTMENT_ID
@@ Line 66: / Line 64: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | DEPT_LOCATION_IX
+|
@@ Line 79: / Line 77: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | DEPT_NAME_NN
 | "DEPARTMENT_NAME" IS NOT NULL
@@ Line 92: / Line 90: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[HR.LOCATIONS_(table)|HR.LOCATIONS]]
 | LOCATION_ID
 | LOCATION_ID
-|-
+|- valign="top"
 | [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]]
 | MANAGER_ID
@@ Line 109: / Line 107: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]]
 | DEPARTMENT_ID
 | DEPARTMENT_ID
-|-
+|- valign="top"
 | [[HR.JOB_HISTORY_(table)|HR.JOB_HISTORY]]
 | DEPARTMENT_ID
@@ Line 127: / Line 125: @@
 | '''Referencing Object
-|-
+|- valign="top"
 | Select
 | View