부서관리
테이블 (3)
departments (Untitled2)
- department_code (Key) — VARCHAR(10) — 기본 키 — NOT NULL
- department_name (Field) — VARCHAR(50)
member_departments (Untitled3)
- member_id (Key) — VARCHAR(10) — 외래 키 → members.member_id — NOT NULL
- department_code (Key2) — VARCHAR(10) — 외래 키 → departments.department_code — NOT NULL
members (Untitled)
- member_id (Key) — VARCHAR(10) — 기본 키 — NOT NULL
- name (Field) — VARCHAR(50)