database_w11
Tables (4)
Department (Untitled)
- dept_id (Field) — int — Primary key
- dept_name (Field2) — varchar
Employee (Untitled2)
- emp_id (Field) — int — Primary key
- dept_id (Field5) — int — Foreign key → Department.dept_id
- emp_name (Field2) — varchar
- position (Field3) — varchar
- dept_id (Field4) — int
Family (Untitled3)
- family_id (Field) — int — Primary key
- emp_id (Field5) — int — Foreign key → Employee.emp_id
- dept_id (Field52) — int — Foreign key → Employee.dept_id
- name (Field2) — varchar
- age (Field3) — int
- emp_id (Field4) — int
WorkHistory (Untitled4)
- wh_id (Field) — int — Primary key
- emp_id (Field6) — int — Foreign key → Employee.emp_id
- dept_id (Field52) — int — Foreign key → Employee.dept_id
- dept_id (Field7) — int — Foreign key → Department.dept_id
- emp_id (Field2) — int
- dept_id (Field3) — int
- period (Field4) — varchar
- position (Field5) — varchar