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 »
Back
History
HR.EMPLOYEES_(table)
== 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 | | Primary key of employees table. |- valign="top" | FIRST_NAME | VARCHAR2(20) | null | | First name of the employee. A not null column. |- valign="top" | LAST_NAME | VARCHAR2(25) | not null | | Last name of the employee. A not null column. |- valign="top" | EMAIL | VARCHAR2(25) | not null | | Email id of the employee |- valign="top" | PHONE_NUMBER | VARCHAR2(20) | null | | Phone number of the employee; includes country code and area code |- valign="top" | HIRE_DATE | DATE(7) | not null | | Date when the employee started on this job. A not null column. |- valign="top" | JOB_ID | VARCHAR2(10) | not null | | 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 | | Monthly salary of the employee. Must be greater than zero (enforced by constraint emp_salary_min) |- valign="top" | COMMISSION_PCT | NUMBER(2, 2) | null | | Commission percentage of the employee; Only employees in sales department elgible for commission percentage |- valign="top" | MANAGER_ID | NUMBER(6, 0) | null | | 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 | | 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 | | DEPARTMENT_ID |- valign="top" | EMP_EMAIL_UK | | EMAIL |- valign="top" | EMP_JOB_IX | | JOB_ID |- valign="top" | EMP_MANAGER_IX | | MANAGER_ID |- valign="top" | EMP_NAME_IX | | 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 | |- valign="top" | EMP_HIRE_DATE_NN | "HIRE_DATE" IS NOT NULL | |- valign="top" | EMP_JOB_NN | "JOB_ID" IS NOT NULL | |- valign="top" | EMP_LAST_NAME_NN | "LAST_NAME" IS NOT NULL | |- valign="top" | EMP_SALARY_MIN | salary > 0 | |} === 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 |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.