EMPLOYEE | ||
EMPLOYEE_ID | NUMBER | NOT NULL, Primary Key |
EMP_LNAME | VARCHAR2(25) | |
EMP_FNAME | VARCHAR2(25) | |
DEPT_ID | NUMBER | Foreign key to DEPT ID column of the DEPARTMENT table |
JOB_ID | NUMBER | Foreign key to JOB ID column of the JOB table |
MGR_ID | NUMBER | References EMPLOYEE ID column |
SALARY | NUMBER(9, 2) | |
HIRE_DATE | DATE | |
DOB | DATE | |