| 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" |
| − | |- valign="top" | + | |- |
| − | | '''Table | + | | '''table |
| | | HR.EMPLOYEES | | | 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
| |
| | |} | | |} |
