Difference between revisions of "HR.DEPARTMENTS (table)"

Revision as of 20:56, 24 August 2009

table

HR.DEPARTMENTS

@@ Line 3: / Line 3: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |-
-| '''Table
+| '''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
 |}