employees
Tables (5)
DEPARTMENTS (departments)
- dept_no — CHAR(4) — Primary key — NOT NULL
- dept_name — VARCHAR(40) — NOT NULL
DEPT_EMP (dept_emp)
- emp_no — INT — Primary key — NOT NULL
- dept_no — CHAR(4) — Primary key — NOT NULL
- emp_no (emp_no2) — INT — Foreign key → EMPLOYEES.emp_no — NOT NULL
- dept_no (dept_no2) — CHAR(4) — Foreign key → DEPARTMENTS.dept_no — NOT NULL
- from_date — DATE — NOT NULL
- to_date — DATE — NOT NULL
DEPT_MANAGER (dept_manager)
- emp_no — INT — Primary key — NOT NULL
- dept_no — CHAR(4) — Primary key — NOT NULL
- emp_no (emp_no2) — INT — Foreign key → EMPLOYEES.emp_no — NOT NULL
- dept_no (dept_no2) — CHAR(4) — Foreign key → DEPARTMENTS.dept_no — NOT NULL
- from_date — DATE — NOT NULL
- to_date — DATE — NOT NULL
EMPLOYEES (employees)
- emp_no — INT — Primary key — NOT NULL
- birth_date — DATE — NOT NULL
- first_name — VARCHAR(14) — NOT NULL
- last_name — VARCHAR(16) — NOT NULL
- gender — ENUM — NOT NULL
- hire_date — DATE — NOT NULL
TITLES (titles)
- emp_no — INT — Primary key — NOT NULL
- title — VARCHAR(50) — Primary key — NOT NULL
- from_date — DATE — Primary key — NOT NULL
- emp_no (emp_no2) — INT — Foreign key → EMPLOYEES.emp_no — NOT NULL
- to_date — DATE