Editing HR.EMPLOYEES (table)
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 2: | Line 2: | ||
{| 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 | ||
Line 9: | Line 9: | ||
| employees table. Contains 107 rows. References with departments, | | employees table. Contains 107 rows. References with departments, | ||
jobs, job_history tables. Contains a self reference. | jobs, job_history tables. Contains a self reference. | ||
+ | |- | ||
|} | |} | ||
+ | |||
=== Columns === | === Columns === | ||
Line 19: | Line 21: | ||
| '''Default | | '''Default | ||
| '''Description | | '''Description | ||
− | + | ||
− | |- | + | |- |
| EMPLOYEE_ID | | EMPLOYEE_ID | ||
| NUMBER(6, 0) | | NUMBER(6, 0) | ||
Line 26: | Line 28: | ||
| | | | ||
| Primary key of employees table. | | Primary key of employees table. | ||
− | |- | + | |- |
| FIRST_NAME | | FIRST_NAME | ||
| VARCHAR2(20) | | VARCHAR2(20) | ||
Line 32: | Line 34: | ||
| | | | ||
| First name of the employee. A not null column. | | First name of the employee. A not null column. | ||
− | |- | + | |- |
| LAST_NAME | | LAST_NAME | ||
| VARCHAR2(25) | | VARCHAR2(25) | ||
Line 38: | Line 40: | ||
| | | | ||
| Last name of the employee. A not null column. | | Last name of the employee. A not null column. | ||
− | |- | + | |- |
| EMAIL | | EMAIL | ||
| VARCHAR2(25) | | VARCHAR2(25) | ||
Line 44: | Line 46: | ||
| | | | ||
| Email id of the employee | | Email id of the employee | ||
− | |- | + | |- |
| PHONE_NUMBER | | PHONE_NUMBER | ||
| VARCHAR2(20) | | VARCHAR2(20) | ||
Line 50: | Line 52: | ||
| | | | ||
| Phone number of the employee; includes country code and area code | | Phone number of the employee; includes country code and area code | ||
− | |- | + | |- |
| HIRE_DATE | | HIRE_DATE | ||
| DATE(7) | | DATE(7) | ||
Line 56: | Line 58: | ||
| | | | ||
| Date when the employee started on this job. A not null column. | | Date when the employee started on this job. A not null column. | ||
− | |- | + | |- |
| JOB_ID | | JOB_ID | ||
| VARCHAR2(10) | | VARCHAR2(10) | ||
Line 63: | Line 65: | ||
| Current job of the employee; foreign key to job_id column of the | | Current job of the employee; foreign key to job_id column of the | ||
jobs table. A not null column. | jobs table. A not null column. | ||
− | |- | + | |- |
| SALARY | | SALARY | ||
| NUMBER(8, 2) | | NUMBER(8, 2) | ||
Line 70: | Line 72: | ||
| Monthly salary of the employee. Must be greater | | Monthly salary of the employee. Must be greater | ||
than zero (enforced by constraint emp_salary_min) | than zero (enforced by constraint emp_salary_min) | ||
− | |- | + | |- |
| COMMISSION_PCT | | COMMISSION_PCT | ||
| NUMBER(2, 2) | | NUMBER(2, 2) | ||
Line 77: | Line 79: | ||
| Commission percentage of the employee; Only employees in sales | | Commission percentage of the employee; Only employees in sales | ||
department elgible for commission percentage | department elgible for commission percentage | ||
− | |- | + | |- |
| MANAGER_ID | | MANAGER_ID | ||
| NUMBER(6, 0) | | NUMBER(6, 0) | ||
Line 85: | Line 87: | ||
departments table. Foreign key to employee_id column of employees table. | departments table. Foreign key to employee_id column of employees table. | ||
(useful for reflexive joins and CONNECT BY query) | (useful for reflexive joins and CONNECT BY query) | ||
− | |- | + | |- |
| DEPARTMENT_ID | | DEPARTMENT_ID | ||
| NUMBER(4, 0) | | NUMBER(4, 0) | ||
Line 99: | Line 101: | ||
| '''Primary Key | | '''Primary Key | ||
| '''Columns | | '''Columns | ||
− | |- | + | |- |
| EMP_EMP_ID_PK | | EMP_EMP_ID_PK | ||
| EMPLOYEE_ID | | EMPLOYEE_ID | ||
Line 110: | Line 112: | ||
| '''Type | | '''Type | ||
| '''Columns | | '''Columns | ||
− | + | ||
− | |- | + | |- |
− | |||
− | |||
− | |||
− | |||
| EMP_EMAIL_UK | | EMP_EMAIL_UK | ||
+ | | Unique | ||
+ | | EMAIL | ||
+ | |- | ||
+ | | EMP_MANAGER_IX | ||
| | | | ||
− | | | + | | MANAGER_ID |
− | |- | + | |- |
| EMP_JOB_IX | | EMP_JOB_IX | ||
| | | | ||
| JOB_ID | | JOB_ID | ||
− | |- | + | |- |
− | | | + | | EMP_DEPARTMENT_IX |
| | | | ||
− | | | + | | DEPARTMENT_ID |
− | |- | + | |- |
| EMP_NAME_IX | | EMP_NAME_IX | ||
| | | | ||
Line 139: | Line 141: | ||
| '''Expression | | '''Expression | ||
| '''Description | | '''Description | ||
− | + | ||
− | |- | + | |- |
| EMP_EMAIL_NN | | EMP_EMAIL_NN | ||
| "EMAIL" IS NOT NULL | | "EMAIL" IS NOT NULL | ||
| | | | ||
− | |- | + | |- |
| EMP_HIRE_DATE_NN | | EMP_HIRE_DATE_NN | ||
| "HIRE_DATE" IS NOT NULL | | "HIRE_DATE" IS NOT NULL | ||
| | | | ||
− | |- | + | |- |
| EMP_JOB_NN | | EMP_JOB_NN | ||
| "JOB_ID" IS NOT NULL | | "JOB_ID" IS NOT NULL | ||
| | | | ||
− | |- | + | |- |
| EMP_LAST_NAME_NN | | EMP_LAST_NAME_NN | ||
| "LAST_NAME" IS NOT NULL | | "LAST_NAME" IS NOT NULL | ||
| | | | ||
− | |- | + | |- |
| EMP_SALARY_MIN | | EMP_SALARY_MIN | ||
| salary > 0 | | salary > 0 | ||
Line 168: | Line 170: | ||
| '''Column | | '''Column | ||
| '''Referenced Column | | '''Referenced Column | ||
− | + | ||
− | |- | + | |- |
| [[HR.DEPARTMENTS_(table)|HR.DEPARTMENTS]] | | [[HR.DEPARTMENTS_(table)|HR.DEPARTMENTS]] | ||
| DEPARTMENT_ID | | DEPARTMENT_ID | ||
| DEPARTMENT_ID | | DEPARTMENT_ID | ||
− | |- | + | |- |
| [[HR.JOBS_(table)|HR.JOBS]] | | [[HR.JOBS_(table)|HR.JOBS]] | ||
| JOB_ID | | JOB_ID | ||
| JOB_ID | | JOB_ID | ||
− | |- | + | |- |
| [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]] | | [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]] | ||
| MANAGER_ID | | MANAGER_ID | ||
Line 189: | Line 191: | ||
| '''Column | | '''Column | ||
| '''Referencing Column | | '''Referencing Column | ||
− | + | ||
− | |- | + | |- |
| [[OE.CUSTOMERS_(table)|OE.CUSTOMERS]] | | [[OE.CUSTOMERS_(table)|OE.CUSTOMERS]] | ||
| EMPLOYEE_ID | | EMPLOYEE_ID | ||
| ACCOUNT_MGR_ID | | ACCOUNT_MGR_ID | ||
− | |- | + | |- |
| [[HR.DEPARTMENTS_(table)|HR.DEPARTMENTS]] | | [[HR.DEPARTMENTS_(table)|HR.DEPARTMENTS]] | ||
| EMPLOYEE_ID | | EMPLOYEE_ID | ||
| MANAGER_ID | | MANAGER_ID | ||
− | |- | + | |- |
| [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]] | | [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]] | ||
| EMPLOYEE_ID | | EMPLOYEE_ID | ||
| MANAGER_ID | | MANAGER_ID | ||
− | |- | + | |- |
| [[HR.JOB_HISTORY_(table)|HR.JOB_HISTORY]] | | [[HR.JOB_HISTORY_(table)|HR.JOB_HISTORY]] | ||
| EMPLOYEE_ID | | EMPLOYEE_ID | ||
| EMPLOYEE_ID | | EMPLOYEE_ID | ||
− | |- | + | |- |
| [[OE.ORDERS_(table)|OE.ORDERS]] | | [[OE.ORDERS_(table)|OE.ORDERS]] | ||
| EMPLOYEE_ID | | EMPLOYEE_ID | ||
| SALES_REP_ID | | SALES_REP_ID | ||
+ | |} | ||
+ | |||
+ | === Dependencies === | ||
+ | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
+ | |- style="background:silver" | ||
+ | | '''Reference Type | ||
+ | | '''Object Type | ||
+ | | '''Referencing Object | ||
+ | |||
+ | |- | ||
+ | | Select | ||
+ | | View | ||
+ | | [[HR.EMP_DETAILS_VIEW_(view)|HR.EMP_DETAILS_VIEW]] | ||
+ | |||
+ | |- | ||
+ | | Select | ||
+ | | View | ||
+ | | [[OE.DEPTVIEW_(view)|OE.DEPTVIEW]] | ||
+ | |||
|} | |} |