HR EMPLOYEES (table)

Modified on 2011/08/27 12:09 by wikibot Categorized as Uncategorized
== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table'''
| HR.EMPLOYEES
|- valign="top"
| '''Description'''
| employees table. Contains 107 rows. References with departments,
jobs, job_history tables. Contains a self reference.
|}

=== Columns ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column'''
| '''Data Type'''
| '''Nullable'''
| '''Default'''
| '''Description'''

|- valign="top"
| EMPLOYEE_ID
| NUMBER(6, 0)
| not null
| &nbsp;
| Primary key of employees table.
|- valign="top"
| FIRST_NAME
| VARCHAR2(20)
| null
| &nbsp;
| First name of the employee. A not null column.
|- valign="top"
| LAST_NAME
| VARCHAR2(25)
| not null
| &nbsp;
| Last name of the employee. A not null column.
|- valign="top"
| EMAIL
| VARCHAR2(25)
| not null
| &nbsp;
| Email id of the employee
|- valign="top"
| PHONE_NUMBER
| VARCHAR2(20)
| null
| &nbsp;
| Phone number of the employee; includes country code and area code
|- valign="top"
| HIRE_DATE
| DATE(7)
| not null
| &nbsp;
| Date when the employee started on this job. A not null column.
|- valign="top"
| JOB_ID
| VARCHAR2(10)
| not null
| &nbsp;
| Current job of the employee; foreign key to job_id column of the
jobs table. A not null column.
|- valign="top"
| SALARY
| NUMBER(8, 2)
| null
| &nbsp;
| Monthly salary of the employee. Must be greater
than zero (enforced by constraint emp_salary_min)
|- valign="top"
| COMMISSION_PCT
| NUMBER(2, 2)
| null
| &nbsp;
| Commission percentage of the employee; Only employees in sales
department elgible for commission percentage
|- valign="top"
| MANAGER_ID
| NUMBER(6, 0)
| null
| &nbsp;
| Manager id of the employee; has same domain as manager_id in
departments table. Foreign key to employee_id column of employees table.
(useful for reflexive joins and CONNECT BY query)
|- valign="top"
| DEPARTMENT_ID
| NUMBER(4, 0)
| null
| &nbsp;
| Department id where employee works; foreign key to department_id
column of the departments table
|}

=== Primary Key ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Primary Key'''
| '''Columns'''
|- valign="top"
| EMP_EMP_ID_PK
| EMPLOYEE_ID
|}

=== Indexes ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Index'''
| '''Type'''
| '''Columns'''

|- valign="top"
| EMP_DEPARTMENT_IX
| &nbsp;
| DEPARTMENT_ID
|- valign="top"
| EMP_EMAIL_UK
| &nbsp;
| EMAIL
|- valign="top"
| EMP_JOB_IX
| &nbsp;
| JOB_ID
|- valign="top"
| EMP_MANAGER_IX
| &nbsp;
| MANAGER_ID
|- valign="top"
| EMP_NAME_IX
| &nbsp;
| LAST_NAME, FIRST_NAME
|}

=== Check Constraints ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Check Constraint'''
| '''Expression'''
| '''Description'''

|- valign="top"
| EMP_EMAIL_NN
| "EMAIL" IS NOT NULL
| &nbsp;
|- valign="top"
| EMP_HIRE_DATE_NN
| "HIRE_DATE" IS NOT NULL
| &nbsp;
|- valign="top"
| EMP_JOB_NN
| "JOB_ID" IS NOT NULL
| &nbsp;
|- valign="top"
| EMP_LAST_NAME_NN
| "LAST_NAME" IS NOT NULL
| &nbsp;
|- valign="top"
| EMP_SALARY_MIN
| salary > 0
| &nbsp;
|}

=== Foreign Keys ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation'''
| '''Column'''
| '''Referenced Column'''

|- valign="top"
| [[HR DEPARTMENTS (table)|HR.DEPARTMENTS]]
| DEPARTMENT_ID
| DEPARTMENT_ID
|- valign="top"
| [[HR JOBS (table)|HR.JOBS]]
| JOB_ID
| JOB_ID
|- valign="top"
| [[HR EMPLOYEES (table)|HR.EMPLOYEES]]
| MANAGER_ID
| EMPLOYEE_ID
|}

=== Detail Tables ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Detail Table'''
| '''Column'''
| '''Referencing Column'''

|- valign="top"
| [[OE CUSTOMERS (table)|OE.CUSTOMERS]]
| EMPLOYEE_ID
| ACCOUNT_MGR_ID
|- valign="top"
| [[HR DEPARTMENTS (table)|HR.DEPARTMENTS]]
| EMPLOYEE_ID
| MANAGER_ID
|- valign="top"
| [[HR EMPLOYEES (table)|HR.EMPLOYEES]]
| EMPLOYEE_ID
| MANAGER_ID
|- valign="top"
| [[HR JOB_HISTORY (table)|HR.JOB_HISTORY]]
| EMPLOYEE_ID
| EMPLOYEE_ID
|- valign="top"
| [[OE ORDERS (table)|OE.ORDERS]]
| EMPLOYEE_ID
| SALES_REP_ID
|}
devio dbscript ScrewTurn Wiki

Navigation¶

HR EMPLOYEES (table)
