HR.DEPARTMENTS (table)

From dbscript Online Help
Revision as of 19:05, 2 May 2009 by Bot (talk | contribs) (New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | HR.DEPARTMENTS |- |} {| border="1" cellpadding="5" cellspacing="0" style="bo...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

wikibot

Table HR.DEPARTMENTS


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


Relation Column Referenced Column
HR.LOCATIONS LOCATION_ID LOCATION_ID
HR.EMPLOYEES MANAGER_ID EMPLOYEE_ID


Detail Table Column Referencing Column
HR.EMPLOYEES DEPARTMENT_ID DEPARTMENT_ID
HR.JOB_HISTORY DEPARTMENT_ID DEPARTMENT_ID
Retrieved from "http://dbshelp.devio.at/index.php?title=HR.DEPARTMENTS_(table)&oldid=443"