Difference between revisions of "HR.EMPLOYEES (table)"
| Line 111: | Line 111: | ||
| '''Columns | | '''Columns | ||
| + | |- valign="top" | ||
| + | | EMP_DEPARTMENT_IX | ||
| + | | | ||
| + | | DEPARTMENT_ID | ||
|- valign="top" | |- valign="top" | ||
| EMP_EMAIL_UK | | EMP_EMAIL_UK | ||
| − | | | + | | |
| EMAIL | | EMAIL | ||
| − | |||
| − | |||
| − | |||
| − | |||
|- valign="top" | |- valign="top" | ||
| EMP_JOB_IX | | EMP_JOB_IX | ||
| Line 124: | Line 124: | ||
| JOB_ID | | JOB_ID | ||
|- valign="top" | |- valign="top" | ||
| − | | | + | | EMP_MANAGER_IX |
| | | | ||
| − | | | + | | MANAGER_ID |
|- valign="top" | |- valign="top" | ||
| EMP_NAME_IX | | EMP_NAME_IX | ||
| Line 210: | Line 210: | ||
| EMPLOYEE_ID | | EMPLOYEE_ID | ||
| SALES_REP_ID | | SALES_REP_ID | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
Latest revision as of 10:33, 27 August 2011
Contents
wikibot[edit]
| Table | HR.EMPLOYEES |
| Description | employees table. Contains 107 rows. References with departments,
jobs, job_history tables. Contains a self reference. |
Columns[edit]
| Column | Data Type | Nullable | Default | Description |
| EMPLOYEE_ID | NUMBER(6, 0) | not null | Primary key of employees table. | |
| FIRST_NAME | VARCHAR2(20) | null | First name of the employee. A not null column. | |
| LAST_NAME | VARCHAR2(25) | not null | Last name of the employee. A not null column. | |
| VARCHAR2(25) | not null | Email id of the employee | ||
| PHONE_NUMBER | VARCHAR2(20) | null | Phone number of the employee; includes country code and area code | |
| HIRE_DATE | DATE(7) | not null | Date when the employee started on this job. A not null column. | |
| 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. | |
| SALARY | NUMBER(8, 2) | null | Monthly salary of the employee. Must be greater
than zero (enforced by constraint emp_salary_min) | |
| COMMISSION_PCT | NUMBER(2, 2) | null | Commission percentage of the employee; Only employees in sales
department elgible for commission percentage | |
| 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) | |
| DEPARTMENT_ID | NUMBER(4, 0) | null | Department id where employee works; foreign key to department_id
column of the departments table |
Primary Key[edit]
| Primary Key | Columns |
| EMP_EMP_ID_PK | EMPLOYEE_ID |
Indexes[edit]
| Index | Type | Columns |
| EMP_DEPARTMENT_IX | DEPARTMENT_ID | |
| EMP_EMAIL_UK | ||
| EMP_JOB_IX | JOB_ID | |
| EMP_MANAGER_IX | MANAGER_ID | |
| EMP_NAME_IX | LAST_NAME, FIRST_NAME |
Check Constraints[edit]
| Check Constraint | Expression | Description |
| EMP_EMAIL_NN | "EMAIL" IS NOT NULL | |
| EMP_HIRE_DATE_NN | "HIRE_DATE" IS NOT NULL | |
| EMP_JOB_NN | "JOB_ID" IS NOT NULL | |
| EMP_LAST_NAME_NN | "LAST_NAME" IS NOT NULL | |
| EMP_SALARY_MIN | salary > 0 |
Foreign Keys[edit]
| Relation | Column | Referenced Column |
| HR.DEPARTMENTS | DEPARTMENT_ID | DEPARTMENT_ID |
| HR.JOBS | JOB_ID | JOB_ID |
| HR.EMPLOYEES | MANAGER_ID | EMPLOYEE_ID |
Detail Tables[edit]
| 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 |
