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 (닉네임)