day8
Tables (6)
Day8_departments (Untitled)
- dept_no (PK) — char(4) — Primary key — NOT NULL
- dept_name (UNQ) — varchar(40) — Primary key — NOT NULL
Day8_dept_emp (Untitled2)
- emp_no (PK) — int — Primary key — NOT NULL
- dept_no (Key2) — char(4) — Primary key — NOT NULL
- dept_no (PK2) — char(4) — Foreign key → Day8_departments.dept_no — NOT NULL
- dept_name (UNQ) — varchar(40) — Foreign key → Day8_departments.dept_name — NOT NULL
- from_date (Field) — date
- to_date (Field2) — date
Day8_dept_manager (Untitled3)
- detp_no (Key) — char(4) — Primary key — NOT NULL
- emp_no (Key2) — int — Primary key — NOT NULL
- from_date (Field) — date
- to_date (Field2) — date
Day8_employees (Untitled4)
- emp_no (Key) — int — Primary key — NOT NULL
- birth_date (Field) — date
- fisrt_name (Field2) — varchar(14)
- last_name (Field3) — varchar(14)
- gender (Field4) — enum('M','F')
- hire_date (Field5) — date
Day8_salaries (Untitled5)
- emp_no (Key) — int — Primary key — NOT NULL
- from_date (Key2) — date — Primary key — NOT NULL
- Field3 — Primary key
- salary (Field) — int
- to_date (Field2) — date
titles (Untitled6)
- emp_no (Key) — int — Primary key — NOT NULL
- title (Key2) — varchar(50) — Primary key — NOT NULL
- from_date (Key3) — date — Primary key — NOT NULL
- Field2 — Primary key
- to_date (Field) — date