exam-department

Tables (3)

Department (부서)

  • 부서ID (id) — varchar(50) — Primary key — NOT NULL
  • 이름 (name) — varchar(50)

DepartmentMember (부서-직원)

  • 부서ID (department_id) — bigint — Foreign key → Department.부서ID — NOT NULL
  • 직원ID (employee_id) — bigint — Foreign key → Employee.직원ID — NOT NULL

Employee (직원)

  • 직원ID (id) — varchar(50) — Primary key — NOT NULL
  • 이름 (name) — varchar(50) — NOT NULL
  • Field