department-student

Tables (3)

department (부서)

  • department_id (id) — int — Primary key — NOT NULL
  • code — varchar(20) — Primary key — NOT NULL
  • name — varchar(20)

member (사원)

  • member_id (id) — int — Primary key — NOT NULL
  • name — varchar(20)

member_department (멤버부서관계)

  • member_id (id) — int — Foreign key → member.member_id — NOT NULL
  • code — varchar(20) — Foreign key → department.code — NOT NULL