baro

Tables (12)

email_otps

  • id — BIGSERIAL
  • email — VARCHAR(255) — NOT NULL
  • otp_code — VARCHAR(10) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • verified_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

posture_daily_stats

  • id — BIGSERIAL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • target_date — DATE — NOT NULL
  • good_posture_sec — INT — NOT NULL
  • bad_posture_sec — INT — NOT NULL
  • total_monitored_sec — INT — NOT NULL
  • avg_neck_angle — DOUBLE
  • warning_count — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

posture_logs

  • id — BIGSERIAL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • neck_angle — DOUBLE — NOT NULL
  • shoulder_angle — DOUBLE — NOT NULL
  • is_warning — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

posture_warning_events

  • id — BIGSERIAL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • event_type — VARCHAR(50) — NOT NULL — TURTLE_NECK
  • angle_value — DOUBLE — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

refresh_tokens

  • id — BIGSERIAL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • token — TEXT — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • revoked_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

signup_tokens

  • id — BIGSERIAL
  • email — VARCHAR(255) — NOT NULL
  • token — TEXT — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • used_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

stretching_contents

  • id — BIGSERIAL
  • content_name — VARCHAR(100) — NOT NULL
  • duration_sec — INT — NOT NULL
  • reward_xp — INT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

stretching_logs

  • id — BIGSERIAL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • content_id — BIGINT — Foreign key → stretching_contents.id
  • content_name — VARCHAR(100) — NOT NULL
  • earned_xp — INT — NOT NULL
  • completed_at — TIMESTAMP — NOT NULL

user_plants

  • user_id — UUID — Foreign key → users.id
  • plant_name — VARCHAR(50) — NOT NULL
  • level — INT — NOT NULL
  • current_xp — INT — NOT NULL
  • max_xp — INT — NOT NULL
  • streak_days — INT — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user_settings

  • user_id — UUID — Foreign key → users.id
  • is_push_enabled — BOOLEAN — NOT NULL
  • is_sound_enabled — BOOLEAN — NOT NULL
  • camera_angle_offset — DOUBLE — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • id — UUID — DEFAULT
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

weekly_ai_reports

  • id — UUID — DEFAULT
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • week_label — VARCHAR(50) — NOT NULL
  • week_start_date — DATE — NOT NULL
  • week_end_date — DATE — NOT NULL
  • total_score — INT — NOT NULL — 0~100
  • grade — VARCHAR(20) — NOT NULL — EXCELLENT
  • delta — INT — NOT NULL
  • neck_score — INT — NOT NULL
  • shoulder_score — INT — NOT NULL
  • total_analysis_time_sec — INT — NOT NULL
  • good_posture_ratio — INT — NOT NULL
  • warning_count — INT — NOT NULL
  • ai_feedback — TEXT — NOT NULL
  • positives — JSONB — NOT NULL
  • warnings — JSONB — NOT NULL
  • generated_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL