dama
Tables (10)
api_idempotency
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- operation — VARCHAR(50) — NOT NULL
- idempotency_key — VARCHAR(100) — NOT NULL
- request_hash — VARCHAR(128) — NOT NULL
- state — VARCHAR(20) — NOT NULL
- response_status — SMALLINT
- response_body — JSONB
- resource_type — VARCHAR(40)
- resource_id — UUID
- created_at — TIMESTAMPTZ — NOT NULL
- expires_at — TIMESTAMPTZ — NOT NULL
goals
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- goal_type — VARCHAR(40) — NOT NULL
- target_distance_m — INTEGER — NOT NULL
- starts_on — DATE — NOT NULL
- ends_on — DATE — NOT NULL
- baseline_pace_sec_per_km — INTEGER
- target_pace_sec_per_km — INTEGER
- roadmap — JSONB — NOT NULL
- rule_version — VARCHAR(40) — NOT NULL
- calibration_run_count — SMALLINT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
outbox_events
- event_id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.id
- aggregate_type — VARCHAR(40) — NOT NULL
- aggregate_id — UUID — NOT NULL
- event_type — VARCHAR(60) — NOT NULL
- schema_version — SMALLINT — NOT NULL
- payload — JSONB — NOT NULL
- occurred_at — TIMESTAMPTZ — NOT NULL
- published_at — TIMESTAMPTZ
- publish_attempts — SMALLINT — NOT NULL
- last_error — TEXT
pet_reward_ledger
- id — UUID — Primary key — NOT NULL
- pet_user_id — UUID — Foreign key → pets.user_id — NOT NULL
- asset_type — VARCHAR(20) — NOT NULL
- source_type — VARCHAR(40) — NOT NULL
- source_id — UUID — NOT NULL
- delta — INTEGER — NOT NULL
- balance_after — INTEGER — NOT NULL
- metadata — JSONB
- created_at — TIMESTAMPTZ — NOT NULL
pets
- user_id — UUID — Foreign key → users.id — NOT NULL
- character_code — VARCHAR(30) — NOT NULL
- growth_stage — SMALLINT — NOT NULL
- experience — INTEGER — NOT NULL
- condition — VARCHAR(20) — NOT NULL
- food_count — INTEGER — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
prescriptions
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- goal_id — UUID — Foreign key → goals.id
- plan_week_no — SMALLINT
- scheduled_on — DATE
- status — VARCHAR(20) — NOT NULL
- workout_type — VARCHAR(30)
- recommended_workout_type — VARCHAR(30)
- user_modified — BOOLEAN — NOT NULL
- target_distance_m — INTEGER
- target_pace_min_sec_per_km — INTEGER
- target_pace_max_sec_per_km — INTEGER
- segments — JSONB
- purpose — TEXT
- reason_code — VARCHAR(60) — NOT NULL
- reason_text — TEXT — NOT NULL
- decision_input — JSONB — NOT NULL
- rule_version — VARCHAR(40) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
run_sessions
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- prescription_id — UUID — Foreign key → prescriptions.id
- comparison_run_session_id — UUID — Foreign key → run_sessions.id
- status — VARCHAR(20) — NOT NULL
- sync_status — VARCHAR(20) — NOT NULL
- started_at — TIMESTAMPTZ
- ended_at — TIMESTAMPTZ
- elapsed_time_s — INTEGER
- moving_time_s — INTEGER
- distance_m — INTEGER
- avg_pace_sec_per_km — INTEGER
- avg_cadence_spm — NUMERIC(6,2)
- target_compliance_rate — NUMERIC(6,3)
- pace_variability — NUMERIC(10,4)
- late_pace_drop_rate — NUMERIC(8,4)
- pause_count — SMALLINT — NOT NULL
- usual_struggle_point_m — INTEGER
- prescription_completed — BOOLEAN
- anomaly_summary — JSONB
- perceived_difficulty — VARCHAR(20)
- pain_present — BOOLEAN
- feedback_note — TEXT
- feedback_submitted_at — TIMESTAMPTZ
- settings_snapshot — JSONB — NOT NULL
- app_version — VARCHAR(40)
- device_info — JSONB
- aggregation_version — VARCHAR(40)
- confirmed_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
run_splits
- id — UUID — Primary key — NOT NULL
- run_session_id — UUID — Foreign key → run_sessions.id — NOT NULL
- split_no — SMALLINT — NOT NULL
- start_distance_m — INTEGER — NOT NULL
- end_distance_m — INTEGER — NOT NULL
- distance_m — INTEGER — NOT NULL
- duration_s — INTEGER — NOT NULL
- pace_sec_per_km — INTEGER
- valid_data_rate — NUMERIC(6,3) — NOT NULL
user_running_features
- user_id — UUID — Foreign key → users.id — NOT NULL
- calculated_at — TIMESTAMPTZ — NOT NULL
- source_max_occurred_at — TIMESTAMPTZ — NOT NULL
- distance_7d_m — INTEGER — NOT NULL
- distance_28d_m — INTEGER — NOT NULL
- run_frequency_7d — SMALLINT — NOT NULL
- recent_max_distance_m — INTEGER
- avg_pace_sec_per_km — INTEGER
- pace_stability — NUMERIC(10,4)
- late_pace_drop_rate — NUMERIC(8,4)
- completion_rate — NUMERIC(6,3)
- recommendation_accept_rate — NUMERIC(6,3)
- recommendation_change_rate — NUMERIC(6,3)
- usual_struggle_point_m — INTEGER
- extra_features — JSONB — NOT NULL
- job_version — VARCHAR(40) — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
users
- id — UUID — Primary key — NOT NULL
- auth_provider — VARCHAR(30) — NOT NULL
- auth_subject — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255)
- status — VARCHAR(20) — NOT NULL
- timezone — VARCHAR(50) — NOT NULL
- running_goal — VARCHAR(40)
- recent_frequency_band — VARCHAR(30)
- comfortable_distance_band — VARCHAR(30)
- weekly_available_count — SMALLINT
- available_weekdays — JSONB
- pain_affecting_running — BOOLEAN — NOT NULL
- age_band — VARCHAR(20)
- optional_heart_rate_bpm — SMALLINT
- calibrated_at — TIMESTAMPTZ
- voice_level — SMALLINT — NOT NULL
- last_nonzero_voice_level — SMALLINT — NOT NULL
- tts_volume — NUMERIC(4,3) — NOT NULL
- metronome_enabled — BOOLEAN — NOT NULL
- metronome_bpm — SMALLINT
- metronome_volume — NUMERIC(4,3) — NOT NULL
- location_consent_at — TIMESTAMPTZ
- data_policy_version — VARCHAR(30)
- data_policy_consented_at — TIMESTAMPTZ
- onboarding_completed_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted_at — TIMESTAMPTZ