Exam-department-student
Tables (3)
Departments (부서)
- department_id — VARCHAR(20) — Primary key — NOT NULL
- name — VARCHAR(100)
Employee_Departments (사원부서)
- employee_id — VARCHAR(20) — Foreign key → Employees.employee_id — NOT NULL
- department_id — VARCHAR(20) — Foreign key → Departments.department_id — NOT NULL
Employees (사원)
- employee_id — VARCHAR(20) — Primary key — NOT NULL
- name — VARCHAR(100)