| 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.
|
| EMAIL
| 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
|
