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