exam

Tables (3)

Department (department)

  • id (부서코드) — varchar(255) — Primary key — NOT NULL
  • name (부서이름) — varchar(255)

Member (member)

  • id (사번) — bigint — Primary key — NOT NULL
  • name (이름) — varchar(255)

member_department

  • id (사번) — bigint — Foreign key → Member.id — NOT NULL
  • id (부서코드) — varchar(255) — Foreign key → Department.id — NOT NULL