ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
HR.DEPARTMENTS_(table)
Print
RSS
Modified: 2009/08/29 21:04 by
wikibot
-
Uncategorized
(7)
»
public.getmanagedoutagefornodeinwindow_(function)
»
public.categories_(table)
»
HR.DEPARTMENTS_(table)
[X]
»
Production.Document_(table)
»
public.statisticsreport_(table)
»
OE.SUBCATEGORY_REF_LIST_NESTEDTAB_(table)
»
Production.ProductDocument_(table)
»
public.getmanagedoutagefornodeinwindow_(function)
»
public.categories_(table)
»
HR.DEPARTMENTS_(table)
Edit
wikibot
Table
HR.DEPARTMENTS
Column
Data Type
Nullable
Default
PK
Index
DEPARTMENT_ID
NUMBER(4, 0)
not null
DEPT_ID_PK
DEPARTMENT_NAME
VARCHAR2(30)
not null
MANAGER_ID
NUMBER(6, 0)
null
LOCATION_ID
NUMBER(4, 0)
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
ScrewTurn Wiki
version 2.0.36. Some of the icons created by
FamFamFam
.