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.EMPLOYEES_(table)
Print
RSS
Modified: 2009/08/29 21:04 by
wikibot
-
Uncategorized
»
Production.UnitMeasure_(table)
»
public.outages_(table)
»
HR.EMPLOYEES_(table)
[X]
»
Production.UnitMeasure_(table)
»
public.outages_(table)
»
HR.EMPLOYEES_(table)
Edit
wikibot
Table
HR.EMPLOYEES
Column
Data Type
Nullable
Default
PK
Index
EMPLOYEE_ID
NUMBER(6, 0)
not null
EMP_EMP_ID_PK
FIRST_NAME
VARCHAR2(20)
null
EMP_NAME_IX
LAST_NAME
VARCHAR2(25)
not null
EMP_NAME_IX
EMAIL
VARCHAR2(25)
not null
EMP_EMAIL_UK
PHONE_NUMBER
VARCHAR2(20)
null
HIRE_DATE
DATE(7)
not null
JOB_ID
VARCHAR2(10)
not null
EMP_JOB_IX
SALARY
NUMBER(8, 2)
null
COMMISSION_PCT
NUMBER(2, 2)
null
MANAGER_ID
NUMBER(6, 0)
null
EMP_MANAGER_IX
DEPARTMENT_ID
NUMBER(4, 0)
null
EMP_DEPARTMENT_IX
Relation
Column
Referenced Column
HR.DEPARTMENTS
DEPARTMENT_ID
DEPARTMENT_ID
HR.JOBS
JOB_ID
JOB_ID
HR.EMPLOYEES
MANAGER_ID
EMPLOYEE_ID
Detail Table
Column
Referencing Column
OE.CUSTOMERS
EMPLOYEE_ID
ACCOUNT_MGR_ID
HR.DEPARTMENTS
EMPLOYEE_ID
MANAGER_ID
HR.EMPLOYEES
EMPLOYEE_ID
MANAGER_ID
HR.JOB_HISTORY
EMPLOYEE_ID
EMPLOYEE_ID
OE.ORDERS
EMPLOYEE_ID
SALES_REP_ID
ScrewTurn Wiki
version 2.0.36. Some of the icons created by
FamFamFam
.