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