Prior Table Table EMPLOYEES Next Table

Comment for Table EMPLOYEES
Comment 
employees table. Contains 107 rows. References with departments,
jobs, job_history tables. Contains a self reference.

Columns of Table EMPLOYEES
Column ID Column Name Datatype Not Null Data Default Comments
1 EMPLOYEE_ID NUMBER(6) Y   Primary key of employees table.
2 FIRST_NAME VARCHAR2(20 BYTE)     First name of the employee. A not null column.
3 LAST_NAME VARCHAR2(25 BYTE) Y   Last name of the employee. A not null column.
4 EMAIL VARCHAR2(25 BYTE) Y   Email id of the employee
5 PHONE_NUMBER VARCHAR2(20 BYTE)     Phone number of the employee; includes country code and area code
6 HIRE_DATE DATE Y   Date when the employee started on this job. A not null column.
7 JOB_ID VARCHAR2(10 BYTE) Y   Current job of the employee; foreign key to job_id column of the jobs table. A not null column.
8 SALARY NUMBER(8,2)   50000 Monthly salary of the employee. Must be greater than zero (enforced by constraint emp_salary_min)
9 COMMISSION_PCT NUMBER(2,2)     Commission percentage of the employee; Only employees in sales department elgible for commission percentage
10 MANAGER_ID NUMBER(6)     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)
11 DEPARTMENT_ID NUMBER(4)     Department id where employee works; foreign key to department_id column of the departments table

Indexes on Table EMPLOYEES
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE EMP_DEPARTMENT_IX NORMAL DEPARTMENT_ID <none>        
UNIQUE EMP_EMAIL_UK NORMAL EMAIL <none>        
UNIQUE EMP_EMP_ID_PK NORMAL EMPLOYEE_ID <none>        
NON-UNIQUE EMP_JOB_IX NORMAL JOB_ID <none>        
NON-UNIQUE EMP_MANAGER_IX NORMAL MANAGER_ID <none>        
NON-UNIQUE EMP_NAME_IX NORMAL LAST_NAME, FIRST_NAME <none>        

Foreign Key Constraints on Table EMPLOYEES
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
EMP_DEPT_FK DEPARTMENT_ID HR DEPARTMENTS DEPARTMENT_ID NO ACTION ENABLED No No
EMP_JOB_FK JOB_ID HR JOBS JOB_ID NO ACTION ENABLED No No
EMP_MANAGER_FK MANAGER_ID HR EMPLOYEES EMPLOYEE_ID NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table EMPLOYEES
Constraint Name Type Condition Status Columns
EMP_EMAIL_NN Check "EMAIL" IS NOT NULL ENABLED EMAIL
EMP_HIRE_DATE_NN Check "HIRE_DATE" IS NOT NULL ENABLED HIRE_DATE
EMP_JOB_NN Check "JOB_ID" IS NOT NULL ENABLED JOB_ID
EMP_LAST_NAME_NN Check "LAST_NAME" IS NOT NULL ENABLED LAST_NAME
EMP_SALARY_MIN Check salary > 0 ENABLED SALARY
EMP_EMP_ID_PK Primary Key   ENABLED EMPLOYEE_ID
EMP_EMAIL_UK Unique   ENABLED EMAIL

Table EMPLOYEES does not have...
Partitions
Redaction Policies