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)