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