study1
Tables (6)
departments
- dept_no — char(4) — Primary key — NOT NULL
- dept_name — varchar(40) — NOT NULL
dept_emp
- emp_no — int(11) — Foreign key → employees.emp_no — NOT NULL
- dept_no — char(4) — Foreign key → departments.dept_no — NOT NULL
- from_date — date — NOT NULL
- to_date — date — NOT NULL
dept_manager
- emp_no — int(11) — Foreign key → employees.emp_no — NOT NULL
- dept_no — char(4) — Foreign key → departments.dept_no — NOT NULL
- from_date — date — NOT NULL
- to_date — date — NOT NULL
employees
- emp_no — int(11) — Primary key — NOT NULL
- birth_date — date — NOT NULL
- first_name — varchar(14) — NOT NULL
- last_name — varchar(16) — NOT NULL
- gender — enum('M','F') — NOT NULL
- hire_date — date — NOT NULL
salaries
- from_date — date — Primary key — NOT NULL
- emp_no — int(11) — Foreign key → employees.emp_no — NOT NULL
- salary — int(11) — NOT NULL
- to_date — date — NOT NULL
titles
- title — varchar(50) — Primary key — NOT NULL
- from_date — date — Primary key — NOT NULL
- emp_no — int(11) — Foreign key → employees.emp_no — NOT NULL
- to_date — date