VNEXT_V2
Tables (11)
check_ins
- id — uuid — Primary key — NOT NULL
- team_id — uuid — Foreign key → quests.team_id — NOT NULL
- user_id — uuid — Foreign key → quest_participants.user_id — NOT NULL
- quest_id — uuid — Foreign key → quest_participants.quest_id — NOT NULL
- checkin_mode — varchar(8) — Foreign key → quests.checkin_mode — NOT NULL
- 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
- image_hashes — jsonb — NOT NULL
- review — varchar(500) — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
cheers
- check_in_id — uuid — Foreign key → check_ins.id — NOT NULL
- user_id — uuid — Foreign key → team_members.user_id — NOT NULL
- team_id — uuid — Foreign key → team_members.team_id — NOT NULL
- quest_id — uuid — Foreign key → quest_participants.quest_id
- sticker — varchar(12) — NOT NULL
- created_at — timestamptz — NOT NULL
comments
- id — uuid — Primary key — NOT NULL
- check_in_id — uuid — Foreign key → check_ins.id — NOT NULL
- team_id — uuid — Foreign key → team_members.team_id — NOT NULL
- user_id — uuid — Foreign key → team_members.user_id — NOT NULL
- content — varchar(300) — NOT NULL
- created_at — timestamptz — NOT NULL
goals
- id — uuid — Primary key — NOT NULL
- team_id — uuid — Foreign key → teams.id — NOT NULL
- owner_user_id — uuid — Foreign key → team_members.user_id
- scope — varchar(8) — NOT NULL
- metric — varchar(32) — NOT NULL
- title — varchar(100) — NOT NULL
- description — varchar(1000) — NOT NULL
- target_value — integer — NOT NULL
- week_start — date — NOT NULL
- starts_at — timestamptz — NOT NULL
- ends_at — timestamptz — 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
quest_participants
- quest_id — uuid — Foreign key → quests.id — NOT NULL
- user_id — uuid — Foreign key → team_members.user_id — NOT NULL
- team_id — uuid — Foreign key → team_members.team_id — NOT NULL
- joined_at — timestamptz — NOT NULL
- completed_at — timestamptz
- awarded_points — smallint — NOT NULL
quests
- id — uuid — Primary key — NOT NULL
- team_id — uuid — Foreign key → teams.id — NOT NULL
- owner_user_id — uuid — Foreign key → team_members.user_id
- goal_id — uuid — Foreign key → goals.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
- checkin_mode — varchar(8)
- created_at — timestamptz — NOT NULL
season_results
- team_id — uuid — Foreign key → 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(40) — NOT NULL
- finalized_at — timestamptz — NOT NULL
seasons
- id — uuid — Primary key — 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 — Foreign key → teams.id — NOT NULL
- user_id — uuid — Foreign key → users.id — NOT NULL
- season_id — uuid — Foreign key → seasons.id — NOT NULL
- joined_at — timestamptz — NOT NULL
teams
- id — uuid — Primary key — NOT NULL
- season_id — uuid — Foreign key → seasons.id — NOT NULL
- name — varchar(30) — NOT NULL
- invite_code — varchar(8) — NOT NULL
- leader_id — uuid — Foreign key → users.id — NOT NULL
- status — varchar(12) — NOT NULL
- started_at — timestamptz
- created_at — timestamptz — NOT NULL
users
- id — uuid — Primary key — 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