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)