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

From dbscript Online Help
Jump to: navigation, search
(Replacing page with '== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''table | HR.EMPLOYEES |- |}')
Line 3: Line 3:
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|-
 
|-
−
| '''table
+
| '''Table
 
| HR.EMPLOYEES
 
| HR.EMPLOYEES
 
|-
 
|-
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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
 +
|}
 +
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 +
|-
 +
| [[HR.DEPARTMENTS_(table)|HR.DEPARTMENTS]]
 +
| DEPARTMENT_ID
 +
| DEPARTMENT_ID
 +
|-
 +
| [[HR.JOBS_(table)|HR.JOBS]]
 +
| JOB_ID
 +
| JOB_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
 +
 +
|-
 +
| [[OE.CUSTOMERS_(table)|OE.CUSTOMERS]]
 +
| EMPLOYEE_ID
 +
| ACCOUNT_MGR_ID
 +
|-
 +
| [[HR.DEPARTMENTS_(table)|HR.DEPARTMENTS]]
 +
| EMPLOYEE_ID
 +
| MANAGER_ID
 +
|-
 +
| [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]]
 +
| EMPLOYEE_ID
 +
| MANAGER_ID
 +
|-
 +
| [[HR.JOB_HISTORY_(table)|HR.JOB_HISTORY]]
 +
| EMPLOYEE_ID
 +
| EMPLOYEE_ID
 +
|-
 +
| [[OE.ORDERS_(table)|OE.ORDERS]]
 +
| EMPLOYEE_ID
 +
| SALES_REP_ID
 
|}
 
|}

Revision as of 21:00, 24 August 2009

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
Retrieved from "http://dbshelp.devio.at/index.php?title=HR.EMPLOYEES_(table)&oldid=851"