challenge

Tables (7)

category (카테고리)

  • 건강 (Field)
  • 자기개발 (Field2)
  • 경제 (Field3)
  • 커리어 (Field4)
  • 기타 (Field5)

challenge (도전과제)

  • id (challenge_id) — Primary key — NOT NULL
  • id (team_id) — Foreign key → team.id — NOT NULL
  • start_date (Field)
  • end_date (Field2)

challenge_log (진행 기록)

  • Key — Primary key — NOT NULL
  • id (list_id) — Foreign key → challenge_task.id — NOT NULL
  • isChacked (Field)

challenge_task (과제 목록)

  • id (list_id) — Primary key — NOT NULL
  • id (member_id) — Foreign key → team_member.Key — NOT NULL
  • id (challenge_id) — Foreign key → challenge.id — NOT NULL
  • category (Field)
  • task_name (Field2)

team (팀)

  • id (team_id) — Primary key — NOT NULL
  • id (leader_id) — Foreign key → user.id — NOT NULL
  • name (Field)

team_member (팀원)

  • Key — Primary key — NOT NULL
  • id (user_id) — Foreign key → user.id — NOT NULL
  • id (team_id) — Foreign key → team.id — NOT NULL

user (회원)

  • id (user_id) — Primary key — NOT NULL
  • email (이메일)
  • password (비번)
  • username (닉네임)