PRD

Tables (7)

body_photos

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id
  • s3_key — VARCHAR(255)
  • status — VARCHAR(20)
  • uploaded_at — DATETIME
  • expire_at — DATETIME
  • deleted_at — DATETIME

checkins

  • id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → club_sessions.id
  • user_id — BIGINT — Foreign key → users.id
  • method — VARCHAR(10)
  • checked_in_at — DATETIME

club_memberships

  • id — BIGINT — Primary key — NOT NULL
  • club_id — BIGINT — Foreign key → clubs.id
  • user_id — BIGINT — Foreign key → users.id
  • status — VARCHAR(20)
  • joined_at — DATETIME

club_sessions

  • id — BIGINT — Primary key — NOT NULL
  • club_id — BIGINT — Foreign key → clubs.id
  • scheduled_at — DATETIME
  • qr_token — VARCHAR(100)

clubs

  • id — BIGINT — Primary key — NOT NULL
  • gym_id — BIGINT
  • category — VARCHAR(30)
  • capacity — INT
  • schedule — VARCHAR(100)
  • location — VARCHAR(255)

generation_results

  • id — BIGINT — Primary key — NOT NULL
  • photo_id — BIGINT — Foreign key → body_photos.id
  • model_version — VARCHAR(50)
  • goal_type — VARCHAR(20)
  • goal_period_months — INT
  • status — VARCHAR(20)
  • result_s3_key — VARCHAR(255)
  • error_code — VARCHAR(50)
  • created_at — DATETIME

users

  • id — BIGINT — Primary key — NOT NULL
  • birth_year — INT
  • gender — VARCHAR(10)
  • goal_type — VARCHAR(20)
  • goal_period_months — INT
  • gym_id — BIGINT
  • created_at — DATETIME