next7

Tables (10)

checklist_items

  • id — bigint — NOT NULL
  • checklist_id — bigint — NOT NULL
  • title — varchar(255) — NOT NULL
  • points — int — NOT NULL
  • completed_at — timestamp
  • created_at — timestamp — NOT NULL

mandalart_cells

  • id — bigint — NOT NULL
  • plan_id — bigint — NOT NULL
  • parent_cell_id — bigint
  • slot — int — NOT NULL
  • label — varchar(255) — NOT NULL
  • caption — text
  • locked_by_user — boolean — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

mandalart_chat_sessions

  • id — bigint — NOT NULL
  • plan_id — bigint — NOT NULL
  • selected_cell_id — bigint — NOT NULL
  • external_session_id — varchar(255)
  • status — enum('ACTIVE', 'BLOCKED', 'CLOSED') — NOT NULL
  • last_safe_summary — text
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

mandalart_chat_turns

  • id — bigint — NOT NULL
  • session_id — bigint — NOT NULL
  • client_turn_id — varchar(255) — NOT NULL
  • external_turn_id — varchar(255)
  • safety_result — enum('SAFE', 'BLOCKED', 'FALLBACK') — NOT NULL
  • applied_patch_ids — json — NOT NULL
  • created_at — timestamp — NOT NULL

plans

  • id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • context_id — bigint — NOT NULL
  • catalog_version_id — bigint — NOT NULL
  • first_action_title — varchar(255) — NOT NULL
  • first_action_body — text — NOT NULL
  • trust_trace — json — NOT NULL
  • status — enum('ACTIVE', 'ARCHIVED') — NOT NULL
  • created_at — timestamp — NOT NULL

player_contexts

  • id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • position_code — varchar(50) — NOT NULL
  • goal_code — varchar(50) — NOT NULL
  • ability_codes — json — NOT NULL
  • known_records — json — NOT NULL
  • created_at — timestamp — NOT NULL

progress_events

  • id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • checklist_item_id — bigint — NOT NULL
  • event_type — enum('COMPLETED', 'UNCOMPLETED') — NOT NULL
  • idempotency_key — varchar(255) — NOT NULL
  • created_at — timestamp — NOT NULL

recommendation_catalog_versions

  • id — bigint — NOT NULL
  • version — varchar(100) — NOT NULL
  • status — enum('ACTIVE', 'DRAFT', 'RETIRED') — NOT NULL
  • content — json — NOT NULL
  • created_at — timestamp — NOT NULL

users

  • id — bigint — NOT NULL
  • email — varchar(255) — NOT NULL
  • password_hash — text — NOT NULL
  • display_name — varchar(100)
  • created_at — timestamp — NOT NULL
  • deleted_at — timestamp

weekly_checklists

  • id — bigint — NOT NULL
  • plan_id — bigint — NOT NULL
  • week_start — date — NOT NULL
  • created_at — timestamp — NOT NULL