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