AI 해커톤
테이블 (10)
check_ins
- id — uuid — 기본 키 — NOT NULL
- team_id — uuid — 외래 키 → quests.team_id — NOT NULL
- user_id — uuid — 외래 키 → quest_participants.user_id — NOT NULL
- quest_id — uuid — 외래 키 → quest_participants.quest_id
- request_id — uuid — NOT NULL
- payload_hash — char(64) — NOT NULL
- activity_date — date — NOT NULL
- exercise_type — varchar(16) — NOT NULL
- duration_minutes — smallint — NOT NULL
- image_keys — jsonb — NOT NULL
- review — varchar(500) — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
cheers
- check_in_id — uuid — 외래 키 → check_ins.id — NOT NULL
- user_id — uuid — 외래 키 → team_members.user_id — NOT NULL
- team_id — uuid — 외래 키 → team_members.team_id — NOT NULL
- sticker — varchar(12) — NOT NULL
- created_at — timestamptz — NOT NULL
comments
- id — uuid — 기본 키 — NOT NULL
- check_in_id — uuid — 외래 키 → check_ins.id — NOT NULL
- team_id — uuid — 외래 키 → team_members.team_id — NOT NULL
- user_id — uuid — 외래 키 → team_members.user_id — NOT NULL
- content — varchar(300) — NOT NULL
- created_at — timestamptz — NOT NULL
quest_participants
- quest_id — uuid — 외래 키 → quests.id — NOT NULL
- user_id — uuid — 외래 키 → team_members.user_id — NOT NULL
- team_id — uuid — 외래 키 → team_members.team_id — NOT NULL
- joined_at — timestamptz — NOT NULL
- completed_at — timestamptz
- awarded_points — smallint — NOT NULL
quests
- id — uuid — 기본 키 — NOT NULL
- team_id — uuid — 외래 키 → teams.id — NOT NULL
- owner_user_id — uuid — 외래 키 → team_members.user_id
- type — varchar(12) — NOT NULL
- metric — varchar(24) — NOT NULL
- title — varchar(100) — NOT NULL
- description — varchar(1000) — NOT NULL
- exercise_type — varchar(16)
- min_duration_minutes — smallint — NOT NULL
- target_count — integer — NOT NULL
- starts_at — timestamptz — NOT NULL
- ends_at — timestamptz — NOT NULL
- week_start — date
- base_points — smallint — NOT NULL
- multiplier — numeric(2,1) — NOT NULL
- generation_key — varchar(160) — NOT NULL
- generation_source — varchar(8) — NOT NULL
- recommendation_reason — varchar(1000) — NOT NULL
- recommendation_meta — jsonb — NOT NULL
- completed_at — timestamptz
- created_at — timestamptz — NOT NULL
season_results
- team_id — uuid — 외래 키 → teams.id — NOT NULL
- total_points — integer — NOT NULL
- rank — integer
- eligible — boolean — NOT NULL
- metrics — jsonb — NOT NULL
- goal_summary — jsonb — NOT NULL
- awards — jsonb — NOT NULL
- badges — jsonb — NOT NULL
- rewards — jsonb — NOT NULL
- policy_version — varchar(20) — NOT NULL
- finalized_at — timestamptz — NOT NULL
seasons
- id — uuid — 기본 키 — NOT NULL
- name — varchar(80) — NOT NULL
- starts_at — timestamptz — NOT NULL
- ends_at — timestamptz — NOT NULL
- status — varchar(12) — NOT NULL
- closed_at — timestamptz
- created_at — timestamptz — NOT NULL
team_members
- team_id — uuid — 외래 키 → teams.id — NOT NULL
- user_id — uuid — 외래 키 → users.id — NOT NULL
- season_id — uuid — 외래 키 → seasons.id — NOT NULL
- joined_at — timestamptz — NOT NULL
teams
- id — uuid — 기본 키 — NOT NULL
- season_id — uuid — 외래 키 → seasons.id — NOT NULL
- name — varchar(30) — NOT NULL
- invite_code — varchar(8) — NOT NULL
- leader_id — uuid — 외래 키 → users.id — NOT NULL
- status — varchar(12) — NOT NULL
- started_at — timestamptz
- created_at — timestamptz — NOT NULL
users
- id — uuid — 기본 키 — NOT NULL
- employee_no — varchar(30) — NOT NULL
- name — varchar(50) — NOT NULL
- interests — jsonb — NOT NULL
- other_exercise — varchar(50)
- weekly_frequency — smallint — NOT NULL
- preferred_time — varchar(16) — NOT NULL
- difficulty — varchar(10) — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL