HR.EMPLOYEES (table)

wikibot[edit]

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

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

Primary Key	Columns
EMP_EMP_ID_PK	EMPLOYEE_ID