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