240717 ERD
Tables (5)
Assistant (부조장)
- ID (id) — Primary key — NOT NULL
- 학생ID (std_id) — Foreign key → Student.ID — NOT NULL
- 조ID (group_id) — Foreign key → Student.조ID — NOT NULL
Group (조)
- ID (id) — Primary key — NOT NULL
- 이름 (name)
Leader (조장)
- ID (id) — Primary key — NOT NULL
- 학생ID (std_id) — Foreign key → Student.ID — NOT NULL
- 조ID (group_id) — Foreign key → Student.조ID — NOT NULL
Role (직책)
- ID (id) — Primary key — NOT NULL
- 이름 (name)
Student (학생)
- ID (id) — Primary key — NOT NULL
- 직책ID (role_id) — Foreign key → Role.ID — NOT NULL
- 조ID (group_id) — Foreign key → Group.ID — NOT NULL
- 이름 (name)
- 연락처 (phone_number)
- 이메일 (e-mail)