#SQLite schema by domain

erDiagram account_directories { text account_instance PK integer revision text rooms_json integer updated_at text observe_only_room_ids_json } account_directory_profiles { text profile PK text account_instance FK } accounts { text profile PK text base_url text user_id text email text handle text install_id text issuer text client_id text first_name text last_name text auth_kind } room_directory_cache { text profile text account_instance PK text rooms_json integer updated_at } schema_migrations { text filename PK text checksum integer applied_at } settings { text key PK text value } accounts ||--o{ account_directory_profiles : "profile" account_directories ||--o{ account_directory_profiles : "account_instance"

erDiagram activity_log { integer id PK text peer_id text session text agent_session_id text room text kind a full integer at_epoch_ms } daily_rollups { text day PK text scope PK integer tasks_completed integer messages_in integer messages_out } stats { text profile PK text metric PK text resolution PK integer bucket_ts PK integer value }

erDiagram agent_teams { text profile PK text id PK text data } host_sessions { text profile PK text scope PK integer seq text id PK text room integer host_pid text provider text agent_session_id text agent_session_path text team_name text teammate_name text runtime_mode text runtime_transport text spawn_command text spawn_args_json text spawn_cwd text spawn_env_allowlist_json text runtime_auth_mode text runtime_version text thread_settings_json text spawn_sandbox_json text codex_options_json text runtime_template_id text runtime_session_id text managed_workspace_json text provider_session_id integer window_pid text claude_options_json integer desired_config_generation integer effective_config_generation text pending_change_json text runtime_template_uuid text runtime_host_placement text workspace_source_json text git_commit_policy_json text requested_network_profile text developer_network_destinations_json integer local_platform_bridge } peers { text profile PK text scope PK text handle text agent_id text agent_name text host text cwd integer started_at text operator_instructions_json text identity_class } provisional_sessions { text profile PK text scope PK text owner_kind text provider_identity PK text provider_session_id PK text room integer configuration_generation text creation_stage text child_ownership text cleanup_state integer turn_accepted integer created_at } room_teams { text profile PK text chat_id PK text data } session_ledger { text provider PK text agent_session_id PK text peer_id text peer_name text chat_id integer first_bound_at integer last_seen_at } session_liveness { text profile PK text scope PK text session_id PK integer last_seen_ms } session_presence { text provider PK text agent_session_id PK text agent_session_path text cwd integer host_pid integer first_seen_ms integer last_seen_ms } peers ||--o{ host_sessions : "profile, scope" peers ||--o{ session_liveness : "profile, scope"

erDiagram artifacts { text id PK text profile text chat_id text name text mime integer bytes text sha256 text rel_path integer has_thumb text created_by integer created_at text origin text remote_id } room_org { text profile PK text data } room_plans { text chat_id PK text data } room_titles { text chat_id PK text title }

erDiagram managed_workspaces { text id PK text runtime_session_id text state integer root_version integer created_at integer updated_at } runtime_host_cleanup_operation_events { text operation_id PK text runtime_host_id FK text agent_id integer sequence PK text stage integer occurred_at text result_class } runtime_host_cleanup_operations { text id PK text runtime_host_id FK text agent_id text sandbox_name integer planned_runtime_host_bytes integer removed_runtime_host_bytes integer retained_export_bytes integer affected_session_count text stage integer started_at integer updated_at integer completed_at text result_class } runtime_host_sessions { text runtime_host_id FK text runtime_session_id PK text state integer attached_at integer updated_at text workspace_kind } runtime_hosts { text id PK text agent_id text template_id text placement text state text sandbox_name text provider integer created_at integer updated_at text compatibility_fingerprint } runtime_session_room_bindings { text id PK text agent_id text room_id text runtime_session_id integer active text share_mode integer created_at integer updated_at } workspace_exports { text id PK text workspace_id FK text runtime_host_id FK text runtime_session_id text operation_id FK text provider_checkpoint_id FK text metadata_checksum integer file_count integer total_bytes integer created_at } workspace_operation_events { text operation_id PK text workspace_id FK text runtime_host_id FK text runtime_session_id integer sequence PK text state integer occurred_at text result_class } workspace_operations { text id PK text workspace_id FK text runtime_host_id FK text runtime_session_id p reviewed text state integer started_at integer completed_at text result_class } workspace_repository_inventories { text workspace_id PK text operation_id FK text inventory_json integer inspected_at } runtime_host_cleanup_operations ||--o{ runtime_host_cleanup_operation_events : "operation_id" runtime_hosts ||--o{ runtime_host_cleanup_operation_events : "runtime_host_id" runtime_hosts ||--o{ runtime_host_cleanup_operations : "runtime_host_id" runtime_hosts ||--o{ runtime_host_sessions : "runtime_host_id" managed_workspaces ||--o{ workspace_exports : "workspace_id" runtime_hosts ||--o{ workspace_exports : "runtime_host_id" workspace_operations ||--o{ workspace_exports : "operation_id" workspace_operations ||--o{ workspace_operation_events : "operation_id" managed_workspaces ||--o{ workspace_operation_events : "workspace_id" runtime_hosts ||--o{ workspace_operation_events : "runtime_host_id" managed_workspaces ||--o{ workspace_operations : "workspace_id" runtime_hosts ||--o{ workspace_operations : "runtime_host_id" managed_workspaces ||--o{ workspace_repository_inventories : "workspace_id" workspace_operations ||--o{ workspace_repository_inventories : "operation_id"

erDiagram message_events { integer ts text profile text scope text room text message_id text direction integer addressed_to_user } native_projection_outbox { text profile PK text scope PK text room PK integer generation text items_json } queue_messages { text profile PK text scope PK text session text message_id PK text chat_id text sender_id text sender_name text sender_handle text sender_type text content integer enqueued_at integer addressed_to_user text attachment_ids } room_message_cache_items { text account_instance PK text chat_id PK text message_id PK text inserted_at text message_json } room_message_cache_state { text profile text account_instance PK text chat_id PK text fully_reconciled_last_message_at text trusted_frontier_ids_json text staging_cursor text staging_last_message_at text staging_messages_json integer staging_pages integer last_mutation_sequence integer reconciled_at text history_next_cursor integer history_has_more text recovery_state text recovery_detail integer recovery_completed_rooms integer recovery_total_rooms } room_message_direct_lru { text account_instance PK text chat_id PK integer accessed_at } room_system_messages { text profile PK text chat_id PK text message_id PK text inserted_at text message_json } room_message_cache_state ||--o{ room_message_cache_items : "account_instance, chat_id" room_message_cache_state ||--o{ room_message_direct_lru : "account_instance, chat_id"

erDiagram provider_checkpoint_payload_deletions { text id PK text runtime_host_id FK text agent_id text checkpoint_id FK integer planned_payload_bytes integer removed_payload_bytes text stage integer started_at integer updated_at integer completed_at text result_class } provider_checkpoint_sessions { text checkpoint_id PK text runtime_session_id PK text provider_session_id } provider_checkpoints { text id PK text runtime_host_id FK text provider text provider_version integer schema_version text reason text metadata_checksum integer file_count integer total_bytes integer completed_at } provider_continuity_resets { text id PK text source_runtime_host_id FK text agent_id text source_checkpoint_id FK text failure text evidence_checksum text record_json integer requested_at } provider_resume_observations { text id PK text runtime_host_id FK text checkpoint_id FK text runtime_session_id text expected_provider_session_id text outcome text record_json integer observed_at } provider_checkpoints ||--o{ provider_checkpoint_payload_deletions : "checkpoint_id" provider_checkpoints ||--o{ provider_checkpoint_sessions : "checkpoint_id" provider_checkpoints ||--o{ provider_continuity_resets : "source_checkpoint_id" provider_checkpoints ||--o{ provider_resume_observations : "checkpoint_id"

erDiagram room_attention_items { text profile text account_instance PK text item_id PK text chat_id text sender_id text sender_name text sender_type text inserted_at text updated_at text excerpt integer mutation_sequence integer created_at } room_attention_mutation_outbox { integer id PK text profile text account_instance text chat_id integer mutation_sequence text action_json } room_attention_retention { text profile text account_instance PK integer truncated_count } room_attention_sequence_watermarks { text profile text account_instance PK text chat_id PK integer mutation_sequence } room_attention_spool { text profile text account_instance PK text item_id PK text chat_id text sender_id text sender_name text sender_type text inserted_at text updated_at text excerpt integer mutation_sequence integer created_at } room_attention_tombstones { text account_instance PK text item_id PK integer mutation_sequence text resolution integer resolved_at } room_inbox_accepted_question_replies { integer id PK text profile text account_instance text peer_key text room_id text question_instance text asking_agent_id text group_id integer group_revision text answer_code text message_id integer accepted_at integer projection_revision } room_inbox_accepted_question_reply_state { text account_instance PK text profile integer projection_revision } room_inbox_questions { text profile text account_instance PK text task_key PK text questions_json } room_inbox_state { text profile text account_instance PK text read_ids_json text done_ids_json } room_permission_attention_links { text profile text account_instance PK text peer_key PK text permission_id PK text agent_session_id PK text turn_id PK text item_id integer resolved_at }

erDiagram room_boards { text chat_id PK integer next_seq } room_task_assignments { text chat_id PK integer task_seq PK integer seq PK text agent text peer_id text status text linked_native_id integer updated_at integer status_changed_at text agent_id } room_task_operations { integer sequence PK text operation_id text profile text account_instance text room_id text actor_kind text actor_id text kind text payload_json text state text remote_uid text error_class text error_message integer created_at integer updated_at text actor_agent_id } room_tasks { text chat_id PK integer seq PK text uid text subject text detail text overall integer created_at integer updated_at integer started_at integer completed_at text created_by_kind text created_by_id text created_by_name text created_by_handle text component_node_ids_json text history_json } task_events { integer ts text profile text scope text room text item_id text from_status text to_status text field text from_value text to_value text actor_name text actor_handle } task_idempotency { text profile PK text scope PK text room PK text key PK text request_hash text task_ids_json integer result_generation integer created_at } task_lane_source { text profile PK text scope PK text room PK text source_json } work_items { text profile text scope text room integer seq text item_id text subject text status text active_form text owner text detail text room_uid integer updated_at integer first_seen_at integer status_changed_at integer started_at integer completed_at text blocks_json text blocked_by_json text metadata_json integer deleted_at text linked_chat_id text origin_chat_id text component_refs_json json a } work_lane_archive { text profile PK text scope PK text room PK integer archived_at text lane_json text runtime_session_id } work_snapshots { text profile PK text scope PK text room PK text provider integer recorded_at integer projection_generation text runtime_session_id } room_tasks ||--o{ room_task_assignments : "chat_id, task_seq" room_boards ||--o{ room_tasks : "chat_id"

erDiagram usage_capture_failures { text failure_id PK text provider text source text stage text error_class text state integer occurrences integer affected_items integer first_seen_at integer last_seen_at integer resolved_at text record_json } usage_cost_projections { text projection_id PK text report_id FK text provider text provider_session_id text runtime_session_id text runtime_host_id text agent_id text room_id text requested_model text resolved_model text cost_kind integer missing_pricing real amount_usd text currency text catalog text catalog_version text formula_version integer priced_at text record_json } usage_counter_mutations { text report_id PK text counter_id FK integer applied_revision text record_json } usage_counters { text counter_id PK text provider text provider_session_id integer updated_at text record_json } usage_daily_archive { text provider PK text date PK text model PK integer input_tokens integer output_tokens integer cache_creation_tokens integer cache_read_tokens real cost integer missing_pricing integer updated_at text pricing_json integer reasoning_tokens text extension_tokens_json } usage_exact_overlaps { text overlap_id PK text counter_id FK text provider text provider_session_id text canonical_report_id text record_json } usage_observations { text report_id PK text provider text provider_session_id text provider_turn_id text runtime_session_id text runtime_host_id text agent_id text room_id integer received_at text observation_json } usage_platform_deliveries { text report_id PK text agent_id text state integer attempts integer created_at integer updated_at text record_json } usage_reconciliation { text report_id PK text state integer attempts integer created_at integer updated_at text accepted_as text error_class text record_json } usage_session_archive { text provider PK text session_id PK text project_path integer input_tokens integer output_tokens integer cache_creation_tokens integer cache_read_tokens real total_cost text models text first_activity text last_activity integer updated_at integer reasoning_tokens text extension_tokens_json } usage_session_identity_bindings { text provider PK text agent_session_id PK text peer_id text peer_name text agent_id integer first_bound_at integer last_seen_at } usage_session_room_bindings { text provider PK text agent_session_id PK text chat_id PK integer first_bound_at integer last_seen_at } usage_observations ||--o{ usage_cost_projections : "report_id" usage_counters ||--o{ usage_counter_mutations : "counter_id" usage_counters ||--o{ usage_exact_overlaps : "counter_id" usage_session_identity_bindings ||--o{ usage_session_room_bindings : "provider, agent_session_id"