CheckTeamMate ERD

테이블 (4)

과제 (Assignment)

  • Assignment Key (assignment_key) — NOT NULL — 기본 키 — NOT NULL
  • Assignment Title (assignment_title) — NOT NULL
  • Team Key (team_key) — NOT NULL — 외래 키 → 팀.Team Key — NOT NULL

사용자 (User)

  • User Email (user_email) — NOT NULL — 기본 키 — NOT NULL
  • Password (password) — NOT NULL
  • Name (name) — NULL
  • Phone Number (phone_number) — NULL

체크 리스트 (Check)

  • Assignment Key (assignment_key) — NOT NULL — 외래 키 → 과제.Assignment Key — NOT NULL
  • User Email (user_email) — NOT NULL — 외래 키 → 사용자.User Email — NOT NULL

팀 (Team)

  • Team Key (team_key) — NOT NULL — 기본 키 — NOT NULL
  • Title (title)
  • FileImage (fileImage)
  • Reg (timestamp)
  • Leader ID (leader_id)
  • Member ID (member_id)
  • Field