| 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 |
| SALARY | NUMBER(8, 2) | null | | Monthly salary of the employee. Must be greater |
| COMMISSION_PCT | NUMBER(2, 2) | null | | Commission percentage of the employee; Only employees in sales |
| MANAGER_ID | NUMBER(6, 0) | null | | Manager id of the employee; has same domain as manager_id in |
| DEPARTMENT_ID | NUMBER(4, 0) | null | | Department id where employee works; foreign key to department_id |