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