LOGOS MySQL schema — complete reference

Live introspection of winbusiness · Generated 2026-07-15 23:39 UTC · Manifests · Data model · MCP core · Matrix

Live report. Introspected from MySQL at request time. JSON: LOGOS_MYSQL_SCHEMA_REPORT.json.

Summary

Regenerate: python3 Logos/Platform/Admin/Reports/generate_mysql_schema_report.py

Usage index

How each table and view fits into LOGOS. Row counts are live COUNT(*). * = candidate to merge, retire, or rotate — see Cleanup index.

Object*RowsDomainKindHow it is used
asset_process_executions211OtherTABLE—
cortex_config134Platform config (misnamed cortex_config)TABLEKey/value Cortex runtime configuration (feature flags, thresholds). Read by cortex_engine and /logos/config/ surfaces.
cortex_conversation_insights*193Analytics — admin/reporting viewsVIEWVIEW: aggregated insight snippets derived from Matrix conversation analysis.
cortex_directives412Cognition — thoughts & prompt assemblyVIEWVIEW: filter cortex_thoughts_current where thought_type='directive'. Behavioral rules injected into AI system prompts.
cortex_entities283Entity graph — registry & relationshipsTABLEMaster entity registry — humans, AIs, projects, apps. Writers: onboarding, entity_register, MCP identity tools. All Matrix/Cortex traffic resolves entity_name → id here.
cortex_matrix_reflection*—Analytics — admin/reporting viewsVIEWVIEW: crosswalk between Matrix messages and related cognition rows.
cortex_memories252Cognition — thoughts & prompt assemblyVIEWVIEW: filter cortex_thoughts_current where thought_type='memory'. Experience recall for prompt assembly.
cortex_personalities*283Entity graph — registry & relationshipsVIEWVIEW: personality metadata joined from entities + thoughts.
cortex_projects125Entity graph — registry & relationshipsVIEWVIEW: projects as entities joined via works_on relationships — not stored as cognition rows.
cortex_relationships_unified323Entity graph — registry & relationshipsTABLEPolymorphic relationship graph (entity↔entity, entity↔thought, etc.). Writers: pairing, works_on, skill subscriptions, graph APIs.
cortex_responsibility_roles8Governance — responsibility rolesTABLEMaps entities to responsibility roles (operator, steward, etc.) for governance and routing hints.
cortex_sessions*0Matrix — messaging & lifecycleTABLEActive Cortex processing sessions (validation rounds, bounce state). Writers: validation engines during message elevation.
cortex_skill_hierarchy13Capabilities — skill hierarchyTABLESkill tree metadata for Cortex capabilities (parent/child skills, ranks). Read by skill pickers and agent capability grants.
cortex_tasks144Cognition — thoughts & prompt assemblyVIEWVIEW: filter cortex_thoughts_current where thought_type='task'. Open action items per entity.
cortex_thought_categories*75Compatibility view — migrate readers, retireVIEWVIEW: legacy shape over cortex_types (category=thought_category). Semantic buckets for classifying thoughts (75 categories).
cortex_thought_evolution5,720Cognition — thoughts & prompt assemblyVIEWVIEW: history chain showing how a thought slot changed over time.
cortex_thought_types*23Compatibility view — migrate readers, retireVIEWVIEW: legacy shape over cortex_types (category=thought_type). Icons/rankings in metadata JSON. Read by forms and Assay scripts.
cortex_thoughts5,720Cognition — thoughts & prompt assemblyTABLEAppend-only cognition store (Casey spec). One row per thought revision; current value = latest row per (entity_id, domain, thought_type). Writers: thought_store, agent.add_thought(), Cortex engines.
cortex_thoughts_current2,772Cognition — thoughts & prompt assemblyVIEWVIEW: latest thought per (entity, domain, type) from append-only cortex_thoughts. Primary read path for worldview/directives/tasks.
cortex_types154Controlled vocabulary (types taxonomy)TABLECanonical controlled vocabulary — entity/meeting/message/thought types, statuses, roles, relationship types. Seed + Types.propose/approve. Single source of truth for type validation.
cortex_worldview65Cognition — thoughts & prompt assemblyVIEWVIEW: ranked slice of an entity's active thoughts for worldview displays.
current_logos_agent_connection_assignments85Identity — users, OAuth, connectionsVIEWVIEW: current effective assignment per connection.
current_logos_agent_connection_state55Identity — users, OAuth, connectionsVIEWVIEW: latest state row per connection (active session metadata).
logos_agent_connection_assignments129Identity — users, OAuth, connectionsTABLEAppend-only claims linking a connection to entity/user/project context.
logos_agent_connections55Identity — users, OAuth, connectionsTABLEMCP/agent connection registry (OAuth session, bearer token, service identity).
logos_api_tokens91Identity — users, OAuth, connectionsTABLELong-lived API tokens for programmatic LOGOS access.
logos_asset_relationships31Asset registry — graph layer (skills, tables, links)TABLEPlatform identity, connector, registry, jobs, or operations object.
logos_asset_types39Asset registry — graph layer (skills, tables, links)TABLEPlatform identity, connector, registry, jobs, or operations object.
logos_assets181,265Asset registry — graph layer (skills, tables, links)TABLEAppend-only asset catalog (skills, tables, views, pages, jobs, …). Writers: skill_create, view_create, page_create, registry_register_asset, write_primary paths.
logos_assets_menu_link_active_backup_20260615_2156335,294Identity — users, OAuth, connectionsTABLEPlatform identity, connector, registry, jobs, or operations object.
logos_attributes1,423,182Asset registry — graph layer (skills, tables, links)TABLEAppend-only key/value metadata on assets (visibility, trigger_phrases, …). Writers: registry_set_attribute.
logos_events285,192Asset registry — graph layer (skills, tables, links)TABLETelemetry ledger — invocations, registry audit events, queue drain progress. Writers: registry_log_event, job runs. (Historical rows may include event_type='dual_write' from pre-cutover migration.)
logos_execution_log3,225Identity — users, OAuth, connectionsTABLEPlatform identity, connector, registry, jobs, or operations object.
logos_job_runs10,515Jobs — scheduled work queueTABLEAppend-only execution history per logos_jobs row (status, lease, output).
logos_jobs50Jobs — scheduled work queueTABLEScheduled job definitions (cron, handler, owner, approval). Writers: job_create, Platform/Jobs scheduler.
logos_links1,556Asset registry — graph layer (skills, tables, links)TABLEAppend-only graph edges between assets/thoughts (reads, composes, cites, …). Writers: registry_link_assets, skill_create related_* backfill.
logos_oauth_clients83Identity — users, OAuth, connectionsTABLERegistered OAuth clients (Cursor MCP, PhoneMate, etc.).
logos_oauth_codes*86Identity — users, OAuth, connectionsTABLEShort-lived OAuth authorization codes during MCP/human login flow.
logos_platform_logs*1,289Ops audit — logs & SMS trailTABLEPlatform-wide structured log sink (errors, boot events, subsystem traces).
logos_project_queue_limits0Identity — users, OAuth, connectionsTABLEPlatform identity, connector, registry, jobs, or operations object.
logos_provider_api_calls2,253Usage ledger — provider API calls, tokens, costTABLEPlatform provider API ledger — LLM tokens, model, cost per call. Writers: Logos.Utilities.services.log_provider_call(). Future: STT/TTS and app-scoped rebilling.
logos_queue_row_history12,680Identity — users, OAuth, connectionsTABLEPlatform identity, connector, registry, jobs, or operations object.
logos_semantic_index3,823Identity — users, OAuth, connectionsTABLEPlatform identity, connector, registry, jobs, or operations object.
logos_semantic_index_meta1Identity — users, OAuth, connectionsTABLEPlatform identity, connector, registry, jobs, or operations object.
logos_sync_assets_staging228,891Identity — users, OAuth, connectionsTABLEPlatform identity, connector, registry, jobs, or operations object.
logos_web_requests_log*261Ops audit — logs & SMS trailTABLEHTTP request audit (path, latency, status) for operator diagnostics.
matrix_communications*6,114Compatibility view — migrate readers, retireVIEWVIEW: flat legacy message shape (v2 messages + sidecars joined). Primary read path for Codex, lifecycle, MCP inbox, developer thread.
matrix_conversations*3,000Compatibility view — migrate readers, retireVIEWVIEW: legacy conversation header shape from matrix_meeting_conversations. Readers: Conversation service, Matrix UIs, round/bounce settings.
matrix_meeting_attendance6,975Matrix — messaging & lifecycleTABLEEntity ↔ meeting time windows (enter/exit/re-enter = new row). Scopes message visibility in meeting_history_sql().
matrix_meeting_conversations3,000Matrix — messaging & lifecycleTABLEconversation_id ↔ meeting_id map plus chat config (Cortex prompts, bounce limits, summaries). Writers: meeting_store, Conversation class.
matrix_meetings3,198Matrix — messaging & lifecycleTABLECasey three-table core: one structured group activity (chat thread, dev thread, ticket thread). Writers: meeting_store.ensure_meeting.
matrix_message_deliveries2,239Matrix — messaging & lifecycleTABLEPer-recipient inbox state (delivered_at, read_at, archived_at). Writers: lifecycle fanout on directed messages; readers: inbox APIs.
matrix_message_lifecycle6,114Matrix — messaging & lifecycleTABLELifecycle processor sidecar: status, effective_at, response_code, parent/root linkage. Writers: lifecycle processor, append_communication.
matrix_message_meta6,114Matrix — messaging & lifecycleTABLEQC/inbox sidecar: validation_status, processing_status, prompts, direct_recipient JSON. Writers: append_communication, validation engines.
matrix_message_type_actions*0Matrix — messaging & lifecycleTABLELifecycle fan-out rules (message_type → spawn children). 0 rows in prod — processor no-ops when empty; drop candidate if fan-out stays unused.
matrix_messages6,114Matrix — messaging & lifecycleTABLEImmutable message content + routing (sender, recipients, parent_message_id). Writers: meeting_store.append_message / append_communication.
matrix_participant_config624Matrix — messaging & lifecycleTABLEPer-AI per-conversation prompts, bounce limits, participation_mode. Replaces dropped matrix_ai_participation. Writers: upsert_ai_participation.
matrix_response_codes11Matrix — messaging & lifecycleTABLEReference table mapping response_code → parent lifecycle status (fixed, needs_info, blocked, etc.). Seeded; read by lifecycle processor.
matrix_terminal_response_messages92Matrix — messaging & lifecycleVIEWVIEW: correctness check — terminal lifecycle responses that should have closed their parent request.
sms_log12Ops audit — logs & SMS trailTABLEOutbound SMS audit trail (recipient, carrier, dry_run, Twilio responses). Writers: Matrix sms.py dispatch.
users91Identity — users, OAuth, connectionsTABLEHuman user accounts (login, profile, sms_number for outbound SMS). Writers: Identity OAuth, admin onboarding.
v_asset_process_executions211OtherVIEW—
vw_logos_asset_relationships_current31Asset registry — graph layer (skills, tables, links)VIEWAsset registry view — latest row per asset/link/attribute.
vw_logos_assets_current4,332Asset registry — graph layer (skills, tables, links)VIEWVIEW: latest revision per asset_id from append-only logos_assets.
vw_logos_attributes_current36,615Asset registry — graph layer (skills, tables, links)VIEWVIEW: latest value per (asset_id, name) from logos_attributes.
vw_logos_links_current1,216Asset registry — graph layer (skills, tables, links)VIEWVIEW: latest active link per (source, target, type) from logos_links.
vw_logos_platform_assets_current661Asset registry — graph layer (skills, tables, links)VIEWAsset registry view — latest row per asset/link/attribute.
vw_logos_skills_details—Asset registry — graph layer (skills, tables, links)VIEWVIEW: skill asset body + metadata for skill detail pages.
vw_logos_skills_list—Asset registry — graph layer (skills, tables, links)VIEWVIEW: skill assets joined with current attributes for /reports/workspace/skills/.
vw_logos_world_assets_current3,671Asset registry — graph layer (skills, tables, links)VIEWAsset registry view — latest row per asset/link/attribute.
workspace_project_members87Entity graph — registry & relationshipsVIEWVIEW: project membership for workspace registry.
workspace_projects87Entity graph — registry & relationshipsVIEWVIEW: MySQL registry mirror of promoted workspace projects (slug, owner). Actual project data lives in Workspaces/ SQLite.

Naming review

Historical cortex_* prefix covers entity graph, config, usage ledger, and Matrix analytics — not just cognition. Folder ownership (Cortex / Codex / Matrix / Admin) should align with domain, not prefix. Renames require architect proposal — compatibility views first.

Current nameRowsTrue domainSuggested nameCode home
cortex_config134Platform config (misnamed cortex_config)logos_configPlatform/DataLayer (config.py)
cortex_conversation_insights193Analytics — admin/reporting viewsmatrix_conversation_insightsPlatform/Admin or Matrix
cortex_entities283Entity graph — registry & relationshipslogos_entitiesPlatform/Cortex (entity_model.py)
cortex_matrix_reflection—Analytics — admin/reporting viewsmatrix_reflectionPlatform/Admin or Matrix
cortex_relationships_unified323Entity graph — registry & relationshipslogos_relationshipsPlatform/Cortex (entity_model.py)
cortex_responsibility_roles8Governance — responsibility roleslogos_responsibility_rolesPlatform/Cortex (entity_model)
cortex_sessions0Matrix — messaging & lifecyclematrix_validation_sessionsPlatform/Matrix
cortex_skill_hierarchy13Capabilities — skill hierarchylogos_skill_hierarchyPlatform/Cortex or Codex
cortex_types154Controlled vocabulary (types taxonomy)logos_typesPlatform/Cortex (types)
logos_provider_api_calls2,253Usage ledger — provider API calls, tokens, costlogos_provider_api_callsPlatform/DataLayer or new Platform/Ledger

Not misnamed: cortex_thoughts and filtered views, matrix_* sidecars, logos_* identity/ops tables.

Cleanup candidates *

Human review only — not an auto-drop list. Compatibility views should be retired after reader migration; audit logs need rotation, not deletion of the table.

ObjectRowsKindWhy flagged
cortex_conversation_insights193VIEWAnalytics VIEW (admin_api) — fold into reporting or drop if unused
cortex_matrix_reflection—VIEWAnalytics VIEW (admin_api) — fold into reporting or drop if unused
cortex_personalities283VIEWVIEW on entities.metadata — overlap with entity_get; consolidate read paths
cortex_sessions0TABLE0 rows — validation-session table; wire up or drop if sessions model retired
cortex_thought_categories75VIEWCompatibility VIEW over cortex_types — migrate readers, then drop
cortex_thought_types23VIEWCompatibility VIEW over cortex_types — migrate readers (Assay, agents.py), then drop
logos_oauth_codes86TABLEEphemeral auth codes — add retention purge; do not drop table
logos_platform_logs1,289TABLEPlatform log sink — add rotation/archival; table stays
logos_web_requests_log261TABLEHTTP audit log — add rotation/archival; table stays
matrix_communications6,114VIEWCompatibility VIEW (messages + sidecars) — large migration; target v2 tables
matrix_conversations3,000VIEWCompatibility VIEW — migrate Conversation readers to matrix_meeting_conversations
matrix_message_type_actions0TABLE0 rows — fan-out config unused; lifecycle no-ops; drop if spawn rules never ship

Entity-associated base tables

Core model: cortex_entities + cortex_thoughts + cortex_relationships_unified. Filtered slices are in the Views section.

Table*RowsRole
cortex_entities283Master entity registry — humans, AIs, projects, apps.
cortex_relationships_unified323Polymorphic relationship graph (entity↔entity, entity↔thought, etc.
cortex_skill_hierarchy13Skill tree metadata for Cortex capabilities (parent/child skills, ranks).
cortex_thought_categories*75VIEW: legacy shape over cortex_types (category=thought_category).
cortex_thought_types*23VIEW: legacy shape over cortex_types (category=thought_type).
cortex_thoughts5,720Append-only cognition store (Casey spec).
cortex_types154Canonical controlled vocabulary — entity/meeting/message/thought types, statuses, roles, relationship types.
logos_agent_connection_assignments129Append-only claims linking a connection to entity/user/project context.
logos_agent_connections55MCP/agent connection registry (OAuth session, bearer token, service identity).
logos_provider_api_calls2,253Platform provider API ledger — LLM tokens, model, cost per call.
logos_web_requests_log*261HTTP request audit (path, latency, status) for operator diagnostics.
matrix_meeting_conversations3,000conversation_id ↔ meeting_id map plus chat config (Cortex prompts, bounce limits, summaries).

All base tables A–Z (44)

Table*RowsUsage
asset_process_executions211—
cortex_config134Key/value Cortex runtime configuration (feature flags, thresholds).
cortex_entities283Master entity registry — humans, AIs, projects, apps.
cortex_relationships_unified323Polymorphic relationship graph (entity↔entity, entity↔thought, etc.
cortex_responsibility_roles8Maps entities to responsibility roles (operator, steward, etc.
cortex_sessions*0Active Cortex processing sessions (validation rounds, bounce state).
cortex_skill_hierarchy13Skill tree metadata for Cortex capabilities (parent/child skills, ranks).
cortex_thoughts5,720Append-only cognition store (Casey spec).
cortex_types154Canonical controlled vocabulary — entity/meeting/message/thought types, statuses, roles, relationship types.
logos_agent_connection_assignments129Append-only claims linking a connection to entity/user/project context.
logos_agent_connections55MCP/agent connection registry (OAuth session, bearer token, service identity).
logos_api_tokens91Long-lived API tokens for programmatic LOGOS access.
logos_asset_relationships31Platform identity or ops object.
logos_asset_types39Platform identity or ops object.
logos_assets181,265Append-only asset catalog (skills, tables, views, pages, jobs, …).
logos_assets_menu_link_active_backup_20260615_2156335,294Platform identity or ops object.
logos_attributes1,423,182Append-only key/value metadata on assets (visibility, trigger_phrases, …).
logos_events285,192Telemetry ledger — invocations, registry audit events, queue drain progress.
logos_execution_log3,225Platform identity or ops object.
logos_job_runs10,515Append-only execution history per logos_jobs row (status, lease, output).
logos_jobs50Scheduled job definitions (cron, handler, owner, approval).
logos_links1,556Append-only graph edges between assets/thoughts (reads, composes, cites, …).
logos_oauth_clients83Registered OAuth clients (Cursor MCP, PhoneMate, etc.
logos_oauth_codes*86Short-lived OAuth authorization codes during MCP/human login flow.
logos_platform_logs*1,289Platform-wide structured log sink (errors, boot events, subsystem traces).
logos_project_queue_limits0Platform identity or ops object.
logos_provider_api_calls2,253Platform provider API ledger — LLM tokens, model, cost per call.
logos_queue_row_history12,680Platform identity or ops object.
logos_semantic_index3,823Platform identity or ops object.
logos_semantic_index_meta1Platform identity or ops object.
logos_sync_assets_staging228,891Platform identity or ops object.
logos_web_requests_log*261HTTP request audit (path, latency, status) for operator diagnostics.
matrix_meeting_attendance6,975Entity ↔ meeting time windows (enter/exit/re-enter = new row).
matrix_meeting_conversations3,000conversation_id ↔ meeting_id map plus chat config (Cortex prompts, bounce limits, summaries).
matrix_meetings3,198Casey three-table core: one structured group activity (chat thread, dev thread, ticket thread).
matrix_message_deliveries2,239Per-recipient inbox state (delivered_at, read_at, archived_at).
matrix_message_lifecycle6,114Lifecycle processor sidecar: status, effective_at, response_code, parent/root linkage.
matrix_message_meta6,114QC/inbox sidecar: validation_status, processing_status, prompts, direct_recipient JSON.
matrix_message_type_actions*0Lifecycle fan-out rules (message_type → spawn children).
matrix_messages6,114Immutable message content + routing (sender, recipients, parent_message_id).
matrix_participant_config624Per-AI per-conversation prompts, bounce limits, participation_mode.
matrix_response_codes11Reference table mapping response_code → parent lifecycle status (fixed, needs_info, blocked, etc.
sms_log12Outbound SMS audit trail (recipient, carrier, dry_run, Twilio responses).
users91Human user accounts (login, profile, sms_number for outbound SMS).

All views A–Z (28)

View*RowsUsage
cortex_conversation_insights*193VIEW: aggregated insight snippets derived from Matrix conversation analysis.
cortex_directives412VIEW: filter cortex_thoughts_current where thought_type='directive'.
cortex_matrix_reflection*—VIEW: crosswalk between Matrix messages and related cognition rows.
cortex_memories252VIEW: filter cortex_thoughts_current where thought_type='memory'.
cortex_personalities*283VIEW: personality metadata joined from entities + thoughts.
cortex_projects125VIEW: projects as entities joined via works_on relationships — not stored as cognition rows.
cortex_tasks144VIEW: filter cortex_thoughts_current where thought_type='task'.
cortex_thought_categories*75VIEW: legacy shape over cortex_types (category=thought_category).
cortex_thought_evolution5,720VIEW: history chain showing how a thought slot changed over time.
cortex_thought_types*23VIEW: legacy shape over cortex_types (category=thought_type).
cortex_thoughts_current2,772VIEW: latest thought per (entity, domain, type) from append-only cortex_thoughts.
cortex_worldview65VIEW: ranked slice of an entity's active thoughts for worldview displays.
current_logos_agent_connection_assignments85VIEW: current effective assignment per connection.
current_logos_agent_connection_state55VIEW: latest state row per connection (active session metadata).
matrix_communications*6,114VIEW: flat legacy message shape (v2 messages + sidecars joined).
matrix_conversations*3,000VIEW: legacy conversation header shape from matrix_meeting_conversations.
matrix_terminal_response_messages92VIEW: correctness check — terminal lifecycle responses that should have closed their parent request.
v_asset_process_executions211—
vw_logos_asset_relationships_current31Registry current-state view.
vw_logos_assets_current4,332VIEW: latest revision per asset_id from append-only logos_assets.
vw_logos_attributes_current36,615VIEW: latest value per (asset_id, name) from logos_attributes.
vw_logos_links_current1,216VIEW: latest active link per (source, target, type) from logos_links.
vw_logos_platform_assets_current661Registry current-state view.
vw_logos_skills_details—VIEW: skill asset body + metadata for skill detail pages.
vw_logos_skills_list—VIEW: skill assets joined with current attributes for /reports/workspace/skills/.
vw_logos_world_assets_current3,671Registry current-state view.
workspace_project_members87VIEW: project membership for workspace registry.
workspace_projects87VIEW: MySQL registry mirror of promoted workspace projects (slug, owner).

Base tables (44)

Physical tables only. Views are listed in the next section.

Cortex — core entity model (3)

cortex_entities TABLE entity-related

Type: BASE TABLE · Engine: InnoDB · Rows: 283 · Master registry of all entities that can have thoughts or relationships

Master entity registry — humans, AIs, projects, apps. Writers: onboarding, entity_register, MCP identity tools. All Matrix/Cortex traffic resolves entity_name → id here.

Domain: Entity graph — registry & relationships · Rename candidate: logos_entities

#ColumnTypeNullKeyDefaultExtraComment
1 id b'int' NO PRI auto_increment b'Unique identifier for each entity'
2 entity_name b'varchar(255)' NO UNI b'Unique name identifier for the entity (e.g., "Elon", "Tesla", "Mars_Mission")'
3 entity_type b"enum('ai','human','system','organization','concept','objective','html_locked','html_unlocked','special_agent','avatar','project','application','group')" YES MUL b'ai' b''
4 metadata b'json' YES b'Flexible storage for entity-specific data (personality prompts, configurations, etc.)'
5 active_status b"enum('active','passive','standby','inactive')" YES MUL b'active' b'Current operational state of the entity'
6 created b'datetime' YES b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b'When this entity was first created'
7 wakeup_bootstrap b'text' YES b''
8 default_bounce_limit b'int' NO b'1' b'Quality iterations: 1=single pass, 2+=Judge AI evaluates and can request regeneration'
9 linked_user_id b'int' YES MUL b'LOGOS users.id when entity_type is human'

Indexes:

  • PRIMARY (unique id)
  • idx_active_status (active_status)
  • idx_ce_linked_user (linked_user_id)
  • idx_entity_name (entity_name)
  • idx_entity_type (entity_type)

cortex_relationships_unified TABLE entity-related

Type: BASE TABLE · Engine: InnoDB · Rows: 323 · Universal relationship graph - connects entities to entities, thoughts to thoughts, and entities to thoughts

Polymorphic relationship graph (entity↔entity, entity↔thought, etc.). Writers: pairing, works_on, skill subscriptions, graph APIs.

Domain: Entity graph — registry & relationships · Rename candidate: logos_relationships

#ColumnTypeNullKeyDefaultExtraComment
1 id b'int' NO PRI auto_increment b'Unique identifier for each relationship'
2 source_type b"enum('entity','thought')" NO MUL b'Type of the source (entity from cortex_entities or thought from cortex_thoughts_unified)'
3 source_id b'varchar(255)' NO b'ID or name of the source (entity_name if entity, thought_id if thought)'
4 target_type b"enum('entity','thought')" NO MUL b'Type of the target (entity from cortex_entities or thought from cortex_thoughts_unified)'
5 target_id b'varchar(255)' NO b'ID or name of the target (entity_name if entity, thought_id if thought)'
6 relationship_type b'varchar(100)' NO MUL b'Nature of relationship (agrees_with, contradicts, elaborates, owns, believes, collaborates_with, etc.)'
7 role b'varchar(64)' YES MUL b'Duty/responsibility (owner, editor, member, \xe2\x80\xa6)'
8 strength b'decimal(5,4)' YES MUL b'0.5000' b'Strength/confidence of this relationship (starts at 0.5, typically 0-1 range)'
9 metadata b'json' YES b'Additional relationship data (context, conditions, temporal validity, etc.)'
10 created b'datetime' YES MUL b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b'When this relationship was established'

Indexes:

  • PRIMARY (unique id)
  • idx_created (created)
  • idx_cru_role (role)
  • idx_relationship_type (relationship_type)
  • idx_source (source_type, source_id)
  • idx_strength (strength)
  • idx_target (target_type, target_id)

cortex_thoughts TABLE entity-related

Type: BASE TABLE · Engine: InnoDB · Rows: 5,720

Append-only cognition store (Casey spec). One row per thought revision; current value = latest row per (entity_id, domain, thought_type). Writers: thought_store, agent.add_thought(), Cortex engines.

Domain: Cognition — thoughts & prompt assembly

#ColumnTypeNullKeyDefaultExtraComment
1 id b'bigint' NO PRI auto_increment b''
2 entity_id b'int' NO MUL b'FK cortex_entities.id'
3 thought_type b'varchar(64)' NO b''
4 domain b'varchar(191)' NO b''
5 content b'text' NO b''
6 parent_id b'bigint' YES MUL b''
7 created_at b'datetime' NO b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''

Indexes:

  • PRIMARY (unique id)
  • idx_parent (parent_id)
  • idx_slot (entity_id, domain, thought_type, id)

Cortex — other (5)

cortex_config TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 134

Key/value Cortex runtime configuration (feature flags, thresholds). Read by cortex_engine and /logos/config/ surfaces.

Domain: Platform config (misnamed cortex_config) · Rename candidate: logos_config

#ColumnTypeNullKeyDefaultExtraComment
1 id b'int' NO PRI auto_increment b''
2 config_name b'varchar(100)' NO UNI b''
3 config_value b'text' NO b''
4 category b'varchar(50)' YES b'general' b''
5 description b'varchar(500)' YES b''
6 updated_at b'timestamp' YES on update CURRENT_TIMESTAMP b''
7 date_added b'timestamp' YES b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''

Indexes:

  • PRIMARY (unique id)
  • uq_config_name (config_name)

cortex_responsibility_roles TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 8

Maps entities to responsibility roles (operator, steward, etc.) for governance and routing hints.

Domain: Governance — responsibility roles · Rename candidate: logos_responsibility_roles

#ColumnTypeNullKeyDefaultExtraComment
1 code b'varchar(64)' NO PRI b''
2 label b'varchar(128)' NO b'' b''
3 description b'text' YES b''
4 active b'tinyint(1)' NO b'1' b''
5 created_at b'datetime(6)' NO b'CURRENT_TIMESTAMP(6)' DEFAULT_GENERATED b''

Indexes:

  • PRIMARY (unique code)

cortex_sessions * TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 0

Active Cortex processing sessions (validation rounds, bounce state). Writers: validation engines during message elevation.

Domain: Matrix — messaging & lifecycle · Rename candidate: matrix_validation_sessions

* Cleanup candidate: 0 rows — validation-session table; wire up or drop if sessions model retired

#ColumnTypeNullKeyDefaultExtraComment
1 id b'int' NO PRI auto_increment b''
2 session_id b'varchar(255)' NO UNI b''
3 user_data b'text' YES b''
4 created_at b'timestamp' NO b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''
5 updated_at b'timestamp' NO b'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP b''

Indexes:

  • PRIMARY (unique id)
  • session_id (session_id)

cortex_skill_hierarchy TABLE entity-related

Type: BASE TABLE · Engine: InnoDB · Rows: 13 · Parent-child hierarchy for skillsets. A workflow/skillset includes child skills. Resolver expands recursively.

Skill tree metadata for Cortex capabilities (parent/child skills, ranks). Read by skill pickers and agent capability grants.

Domain: Capabilities — skill hierarchy · Rename candidate: logos_skill_hierarchy

#ColumnTypeNullKeyDefaultExtraComment
1 id b'int' NO PRI auto_increment b''
2 parent_name b'varchar(100)' NO MUL b'Parent skill/skillset/workflow config_name'
3 child_name b'varchar(100)' NO MUL b'Child skill config_name'
4 priority b'int' NO b'50' b'Order within parent (lower = first)'

Indexes:

  • PRIMARY (unique id)
  • idx_child (child_name)
  • idx_parent (parent_name, priority)
  • uq_parent_child (parent_name, child_name)

cortex_types TABLE entity-related

Type: BASE TABLE · Engine: InnoDB · Rows: 154

Canonical controlled vocabulary — entity/meeting/message/thought types, statuses, roles, relationship types. Seed + Types.propose/approve. Single source of truth for type validation.

Domain: Controlled vocabulary (types taxonomy) · Rename candidate: logos_types

#ColumnTypeNullKeyDefaultExtraComment
1 category b'varchar(64)' NO PRI b''
2 type_key b'varchar(64)' NO PRI b''
3 display_name b'varchar(128)' NO b''
4 description b'varchar(500)' YES b''
5 metadata b'json' YES b'Optional display metadata (icon, type_ranking, etc.)'
6 status b'varchar(32)' NO b'active' b''
7 created_at b'datetime' NO b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''
8 created_by_entity_id b'bigint' YES b''

Indexes:

  • PRIMARY (unique category, type_key)
  • idx_category_status (category, status)

Matrix — messaging & lifecycle (10)

matrix_meeting_attendance TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 6,975

Entity ↔ meeting time windows (enter/exit/re-enter = new row). Scopes message visibility in meeting_history_sql().

Domain: Matrix — messaging & lifecycle

#ColumnTypeNullKeyDefaultExtraComment
1 id b'bigint' NO PRI auto_increment b''
2 meeting_id b'bigint' NO MUL b''
3 entity_id b'bigint' NO MUL b''
4 role b'varchar(64)' NO b'participant' b''
5 objective b'varchar(255)' YES b''
6 entered_at b'datetime' NO b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''
7 exited_at b'datetime' YES b''

Indexes:

  • PRIMARY (unique id)
  • idx_entity (entity_id, entered_at)
  • idx_meeting_entity (meeting_id, entity_id, entered_at)
  • idx_meeting_role (meeting_id, role)

matrix_meeting_conversations TABLE entity-related

Type: BASE TABLE · Engine: InnoDB · Rows: 3,000

conversation_id ↔ meeting_id map plus chat config (Cortex prompts, bounce limits, summaries). Writers: meeting_store, Conversation class.

Domain: Matrix — messaging & lifecycle

#ColumnTypeNullKeyDefaultExtraComment
1 conversation_id b'varchar(255)' NO PRI b''
2 meeting_id b'bigint' NO UNI b''
3 title b'varchar(500)' YES b''
4 participants b'text' YES b''
5 created b'datetime' NO b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''
6 last_activity b'datetime' YES MUL b''
7 max_bounces b'int' YES b'10' b''
8 max_auto_rounds b'int' YES b'0' b''
9 current_auto_round b'int' YES b'0' b''
10 conversation_mode b'varchar(50)' YES b'standard' b''
11 cortex_active b'tinyint(1)' YES b'1' b''
12 quality_threshold b'decimal(5,4)' YES b'7.0000' b''
13 cortex_system_prompt b'text' YES b''
14 cortex_active_level b'tinyint' NO b'1' b''
15 cortex_mode b'int' YES b'1' b''
16 summary b'text' YES b''
17 summary_updated_at b'datetime' YES b''

Indexes:

  • PRIMARY (unique conversation_id)
  • idx_last_activity (last_activity)
  • idx_meeting (meeting_id)
  • uq_meeting (meeting_id)

matrix_meetings TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 3,198

Casey three-table core: one structured group activity (chat thread, dev thread, ticket thread). Writers: meeting_store.ensure_meeting.

Domain: Matrix — messaging & lifecycle

#ColumnTypeNullKeyDefaultExtraComment
1 id b'bigint' NO PRI auto_increment b''
2 started_by_entity_id b'bigint' NO MUL b''
3 meeting_type b'varchar(64)' NO b'meeting' b''
4 objective b'varchar(255)' YES b''
5 status b'varchar(32)' NO MUL b'active' b''
6 created_at b'datetime' NO b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''

Indexes:

  • PRIMARY (unique id)
  • idx_starter (started_by_entity_id, created_at)
  • idx_status (status)

matrix_message_deliveries TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 2,239

Per-recipient inbox state (delivered_at, read_at, archived_at). Writers: lifecycle fanout on directed messages; readers: inbox APIs.

Domain: Matrix — messaging & lifecycle

#ColumnTypeNullKeyDefaultExtraComment
1 id b'bigint' NO PRI auto_increment b''
2 message_id b'int' NO MUL b''
3 recipient_entity b'varchar(128)' NO MUL b''
4 sender_entity b'varchar(128)' NO b'' b''
5 conversation_id b'varchar(255)' NO b'' b''
6 message_type b'varchar(32)' NO b'message' b''
7 delivered_at b'datetime' NO b''
8 read_at b'datetime' YES b''
9 archived_at b'datetime' YES b''

Indexes:

  • PRIMARY (unique id)
  • idx_recipient_conv (recipient_entity, conversation_id, delivered_at)
  • idx_recipient_inbox (recipient_entity, archived_at, read_at, delivered_at)
  • idx_recipient_unread (recipient_entity, read_at, delivered_at)
  • uniq_message_recipient (message_id, recipient_entity)

matrix_message_lifecycle TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 6,114

Lifecycle processor sidecar: status, effective_at, response_code, parent/root linkage. Writers: lifecycle processor, append_communication.

Domain: Matrix — messaging & lifecycle

#ColumnTypeNullKeyDefaultExtraComment
1 message_id b'bigint' NO PRI b''
2 conversation_id b'varchar(255)' NO MUL b''
3 message_subtype b'varchar(64)' NO b'' b''
4 lifecycle_parent_id b'bigint' YES MUL b''
5 lifecycle_root_id b'bigint' YES MUL b''
6 lifecycle_status b'varchar(32)' NO MUL b'closed' b''
7 effective_at b'datetime' YES b''
8 response_code b'varchar(64)' NO b'' b''
9 lifecycle_processed_at b'datetime' YES MUL b''
10 message_type b'varchar(32)' YES MUL b'message' b''

Indexes:

  • PRIMARY (unique message_id)
  • idx_conversation (conversation_id)
  • idx_lifecycle_root (lifecycle_root_id)
  • idx_lifecycle_status (lifecycle_status, effective_at)
  • idx_lifecycle_unprocessed (lifecycle_processed_at, message_id)
  • idx_matrix_lifecycle_effective (lifecycle_status, effective_at)
  • idx_matrix_lifecycle_parent (lifecycle_parent_id)
  • idx_matrix_lifecycle_type_subtype_status (message_type, message_subtype, lifecycle_status)

matrix_message_meta TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 6,114

QC/inbox sidecar: validation_status, processing_status, prompts, direct_recipient JSON. Writers: append_communication, validation engines.

Domain: Matrix — messaging & lifecycle

#ColumnTypeNullKeyDefaultExtraComment
1 message_id b'bigint' NO PRI b''
2 entity_name b'varchar(255)' NO MUL b''
3 conversation_id b'varchar(255)' NO MUL b''
4 source_prompt b'mediumtext' YES b''
5 is_processed b'tinyint(1)' NO b'0' b''
6 is_ai_generated b'tinyint(1)' NO b'1' b''
7 parent_message_id b'varchar(36)' YES b''
8 action_tags_resolved b'tinyint(1)' YES b'0' b''
9 elevation_count b'int' YES b'0' b''
10 direct_recipient b'varchar(255)' YES b''
11 processing_status b"enum('pending','processing','resolved','finalized')" NO MUL b'pending' b''
12 response_round b'int' YES b''
13 raw_response b'mediumtext' YES b''
14 engine_processing_log b'json' YES b''
15 source_prompt_raw b'mediumtext' YES b''
16 output_message_raw b'mediumtext' YES b''
17 validation_status b"enum('none','pending','approved','force_approved','rejected')" NO MUL b'none' b''
18 message_context b'json' YES b''
19 entity_name_to b'varchar(100)' YES b''
20 evaluator_count b'tinyint' YES b''

Indexes:

  • PRIMARY (unique message_id)
  • idx_conversation (conversation_id)
  • idx_entity (entity_name)
  • idx_processing (processing_status)
  • idx_validation (validation_status, conversation_id)

matrix_message_type_actions * TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 0

Lifecycle fan-out rules (message_type → spawn children). 0 rows in prod — processor no-ops when empty; drop candidate if fan-out stays unused.

Domain: Matrix — messaging & lifecycle

* Cleanup candidate: 0 rows — fan-out config unused; lifecycle no-ops; drop if spawn rules never ship

#ColumnTypeNullKeyDefaultExtraComment
1 id b'int' NO PRI auto_increment b''
2 source_message_type b'varchar(32)' NO MUL b''
3 source_message_subtype b'varchar(64)' YES b'' b''
4 source_response_code b'varchar(64)' YES b'' b''
5 child_message_type b'varchar(32)' NO b''
6 child_message_subtype b'varchar(64)' YES b'' b''
7 child_status b'varchar(32)' YES b'open' b''
8 child_effective_delay_seconds b'int' YES b'0' b''
9 child_body_template b'text' YES b''
10 is_active b'tinyint(1)' NO b'1' b''
11 sort_order b'int' YES b'0' b''

Indexes:

  • PRIMARY (unique id)
  • idx_mta_match (source_message_type, source_message_subtype, source_response_code, is_active)

matrix_messages TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 6,114

Immutable message content + routing (sender, recipients, parent_message_id). Writers: meeting_store.append_message / append_communication.

Domain: Matrix — messaging & lifecycle

#ColumnTypeNullKeyDefaultExtraComment
1 id b'bigint' NO PRI auto_increment b''
2 meeting_id b'bigint' NO MUL b''
3 sender_entity_id b'bigint' NO MUL b''
4 message_type b'varchar(64)' NO b'message' b''
5 recipient_list b'text' YES b''
6 content b'text' NO b''
7 parent_message_id b'bigint' YES MUL b''
8 created_at b'datetime' NO b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''

Indexes:

  • PRIMARY (unique id)
  • idx_meeting (meeting_id, id)
  • idx_parent (parent_message_id)
  • idx_sender (sender_entity_id, id)

matrix_participant_config TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 624

Per-AI per-conversation prompts, bounce limits, participation_mode. Replaces dropped matrix_ai_participation. Writers: upsert_ai_participation.

Domain: Matrix — messaging & lifecycle

#ColumnTypeNullKeyDefaultExtraComment
1 id b'int' NO PRI auto_increment b''
2 conversation_id b'varchar(255)' NO MUL b''
3 entity_name b'varchar(255)' NO MUL b''
4 participation_mode b"enum('always_active','on_demand','away','evaluator')" NO b'on_demand' b''
5 ai_system_prompt b'text' YES b''
6 response_metadata b'json' YES b''
7 bounce_limit b'int' YES b''
8 last_updated b'timestamp' YES b'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP b''
9 created b'timestamp' NO b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''

Indexes:

  • PRIMARY (unique id)
  • idx_conversation (conversation_id)
  • idx_entity (entity_name)
  • unique_conversation_entity (conversation_id, entity_name)

matrix_response_codes TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 11

Reference table mapping response_code → parent lifecycle status (fixed, needs_info, blocked, etc.). Seeded; read by lifecycle processor.

Domain: Matrix — messaging & lifecycle

#ColumnTypeNullKeyDefaultExtraComment
1 response_code b'varchar(64)' NO PRI b''
2 parent_status b'varchar(32)' NO b'' b''
3 is_terminal b'tinyint(1)' NO b'0' b''
4 description b'text' YES b''

Indexes:

  • PRIMARY (unique response_code)

Identity — MCP connectors (2)

logos_agent_connection_assignments TABLE entity-related

Type: BASE TABLE · Engine: InnoDB · Rows: 129

Append-only claims linking a connection to entity/user/project context.

Domain: Identity — users, OAuth, connections

#ColumnTypeNullKeyDefaultExtraComment
1 agent_connector_key b'varchar(512)' NO PRI b''
2 effective_at b'datetime(6)' NO PRI b''
3 entity_id b'bigint' NO MUL b'0' b''
4 user_id b'bigint' NO MUL b'0' b''
5 project_id b'bigint' NO MUL b'0' b''
6 assignment_kind b'varchar(32)' NO b''
7 role b'varchar(32)' YES b''
8 responsibility b'varchar(64)' YES b''
9 status b'varchar(32)' NO MUL b'active' b''
10 change_reason b'varchar(64)' YES b''
11 changed_by_connector b'varchar(512)' YES b''
12 details_json b'json' YES b''

Indexes:

  • PRIMARY (unique agent_connector_key, effective_at)
  • idx_assignment_kind (agent_connector_key, assignment_kind, effective_at)
  • idx_entity (entity_id, effective_at)
  • idx_project (project_id, effective_at)
  • idx_status (status)
  • idx_user (user_id, effective_at)

logos_agent_connections TABLE entity-related

Type: BASE TABLE · Engine: InnoDB · Rows: 55

MCP/agent connection registry (OAuth session, bearer token, service identity).

Domain: Identity — users, OAuth, connections

#ColumnTypeNullKeyDefaultExtraComment
1 agent_connector_key b'varchar(512)' NO PRI b''
2 connector_kind b'varchar(32)' NO MUL b''
3 issuer b'varchar(255)' YES b''
4 oauth_subject b'varchar(255)' YES b''
5 oauth_client_id b'varchar(255)' YES MUL b''
6 base_ai_user_id b'bigint' YES MUL b''
7 primary_human_user_id b'bigint' YES MUL b''
8 client_label b'varchar(255)' YES b''
9 user_agent b'text' YES b''
10 details_json b'json' YES b''
11 first_seen_at b'datetime(6)' NO MUL b''
12 last_metadata_at b'datetime(6)' YES b''

Indexes:

  • PRIMARY (unique agent_connector_key)
  • idx_base_ai_user (base_ai_user_id)
  • idx_connector_kind (connector_kind)
  • idx_first_seen (first_seen_at)
  • idx_oauth_client (oauth_client_id)
  • idx_primary_human (primary_human_user_id)

Identity — users & OAuth (4)

logos_api_tokens TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 91

Long-lived API tokens for programmatic LOGOS access.

Domain: Identity — users, OAuth, connections

#ColumnTypeNullKeyDefaultExtraComment
1 id b'int' NO PRI auto_increment b''
2 user_id b'int' NO MUL b''
3 token_hash b'varchar(128)' NO UNI b''
4 token_prefix b'varchar(16)' NO b''
5 label b'varchar(120)' NO b'' b''
6 created_at b'timestamp' NO b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''
7 last_used_at b'timestamp' YES b''
8 revoked_at b'timestamp' YES MUL b''

Indexes:

  • PRIMARY (unique id)
  • idx_logos_api_tokens_revoked (revoked_at)
  • idx_logos_api_tokens_user (user_id)
  • token_hash (token_hash)

logos_oauth_clients TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 83

Registered OAuth clients (Cursor MCP, PhoneMate, etc.).

Domain: Identity — users, OAuth, connections

#ColumnTypeNullKeyDefaultExtraComment
1 client_id b'varchar(80)' NO PRI b''
2 client_secret_hash b'varchar(255)' YES b''
3 name b'varchar(120)' NO b''
4 redirect_uris b'text' NO b''
5 allowed_user_id b'int' YES MUL b''
6 scopes b'varchar(255)' NO b'' b''
7 pkce_required b'tinyint(1)' NO b'1' b''
8 created_at b'datetime' NO b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''
9 revoked_at b'datetime' YES b''
10 dynamic_registration b'tinyint(1)' NO b'0' b''
11 bound_human_user_id b'int' YES MUL b''

Indexes:

  • PRIMARY (unique client_id)
  • idx_bound_human (bound_human_user_id)
  • idx_user (allowed_user_id)

logos_oauth_codes * TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 86

Short-lived OAuth authorization codes during MCP/human login flow.

Domain: Identity — users, OAuth, connections

* Cleanup candidate: Ephemeral auth codes — add retention purge; do not drop table

#ColumnTypeNullKeyDefaultExtraComment
1 code b'varchar(128)' NO PRI b''
2 client_id b'varchar(80)' NO MUL b''
3 user_id b'int' NO b''
4 redirect_uri b'varchar(512)' NO b''
5 code_challenge b'varchar(256)' YES b''
6 code_challenge_method b'varchar(16)' YES b''
7 scope b'varchar(255)' NO b'' b''
8 state b'varchar(256)' YES b''
9 expires_at b'datetime' NO MUL b''
10 used_at b'datetime' YES b''
11 created_at b'datetime' NO b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''

Indexes:

  • PRIMARY (unique code)
  • idx_client (client_id)
  • idx_expires (expires_at)

users TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 91

Human user accounts (login, profile, sms_number for outbound SMS). Writers: Identity OAuth, admin onboarding.

Domain: Identity — users, OAuth, connections

#ColumnTypeNullKeyDefaultExtraComment
1 id b'int' NO PRI auto_increment b''
2 username b'varchar(255)' NO b''
3 password b'varchar(255)' NO b''
4 date_added b'datetime' YES b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''
5 about_me b'text' YES b''
6 logos_entity b'varchar(255)' YES b''
7 display_name b'varchar(255)' YES b''
8 email b'varchar(255)' YES b''
9 is_ai b'tinyint(1)' NO b'0' b''
10 sms_number b'varchar(24)' YES MUL b''
11 sms_carrier b'varchar(24)' YES b''
12 sms_opt_in b'tinyint(1)' NO b'0' b''
13 cortex_entity_id b'int' YES MUL b'FK to cortex_entities.id for this human'
14 workspace_provisioned_at b'datetime(6)' YES b'When dedicated Users/<name>/ workspace was created'

Indexes:

  • PRIMARY (unique id)
  • idx_users_cortex_entity (cortex_entity_id)
  • idx_users_sms_number (sms_number)

Platform — ops, usage, errors (3)

logos_platform_logs * TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 1,289

Platform-wide structured log sink (errors, boot events, subsystem traces).

Domain: Ops audit — logs & SMS trail

* Cleanup candidate: Platform log sink — add rotation/archival; table stays

#ColumnTypeNullKeyDefaultExtraComment
1 id b'bigint unsigned' NO PRI auto_increment b''
2 created_at b'datetime(6)' NO MUL b'CURRENT_TIMESTAMP(6)' DEFAULT_GENERATED b''
3 severity b'varchar(16)' NO b'error' b''
4 subsystem b'varchar(32)' NO MUL b'' b''
5 event_type b'varchar(64)' NO b'' b''
6 message b'text' NO b''
7 detail_json b'json' YES b''
8 correlation_id b'varchar(64)' NO MUL b'' b''
9 session_id b'varchar(128)' NO MUL b'' b''
10 session_started_at b'datetime(6)' YES b''
11 human_user_id b'int' YES MUL b''
12 human_username b'varchar(128)' YES b''
13 ai_user_id b'bigint' YES MUL b''
14 ai_username b'varchar(128)' YES b''
15 ai_entity b'varchar(128)' YES b''
16 oauth_client_id b'varchar(80)' YES b''
17 project_slug b'varchar(128)' YES b''
18 tool_name b'varchar(128)' YES b''
19 http_method b'varchar(16)' YES b''
20 http_path b'varchar(512)' YES b''
21 stack_trace b'text' YES b''

Indexes:

  • PRIMARY (unique id)
  • idx_lpe_ai (ai_user_id, created_at)
  • idx_lpe_corr (correlation_id)
  • idx_lpe_created (created_at)
  • idx_lpe_human (human_user_id, created_at)
  • idx_lpe_session (session_id, created_at)
  • idx_lpe_subsystem (subsystem, created_at)

logos_web_requests_log * TABLE entity-related

Type: BASE TABLE · Engine: InnoDB · Rows: 261

HTTP request audit (path, latency, status) for operator diagnostics.

Domain: Ops audit — logs & SMS trail

* Cleanup candidate: HTTP audit log — add rotation/archival; table stays

#ColumnTypeNullKeyDefaultExtraComment
1 id b'int' NO PRI auto_increment b''
2 entity_name b'varchar(255)' NO MUL b''
3 url b'varchar(2048)' NO MUL b''
4 success b'tinyint(1)' NO b'0' b''
5 content_chars b'int' YES b'0' b''
6 call_context b'varchar(50)' YES b'conversation' b''
7 error_message b'varchar(500)' YES b''
8 created_at b'datetime' YES MUL b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''

Indexes:

  • PRIMARY (unique id)
  • idx_created (created_at)
  • idx_entity (entity_name)
  • idx_url (url)

sms_log TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 12

Outbound SMS audit trail (recipient, carrier, dry_run, Twilio responses). Writers: Matrix sms.py dispatch.

Domain: Ops audit — logs & SMS trail

#ColumnTypeNullKeyDefaultExtraComment
1 id b'bigint unsigned' NO PRI auto_increment b''
2 sent_at b'datetime' NO MUL b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''
3 sender_user_id b'int' YES MUL b''
4 sender_username b'varchar(120)' YES b''
5 sender_ai_entity b'varchar(120)' YES b''
6 recipient_user_id b'int' YES MUL b''
7 recipient_label b'varchar(120)' YES b''
8 to_number b'varchar(24)' NO b''
9 body b'text' NO b''
10 provider b'varchar(24)' NO b''
11 provider_message_id b'varchar(160)' YES b''
12 status b'varchar(24)' NO b''
13 error_message b'text' YES b''

Indexes:

  • PRIMARY (unique id)
  • idx_sms_log_recipient (recipient_user_id)
  • idx_sms_log_sender (sender_user_id)
  • idx_sms_log_sent_at (sent_at)

Other (17)

asset_process_executions TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 211

#ColumnTypeNullKeyDefaultExtraComment
1 execution_id b'bigint unsigned' NO PRI auto_increment b''
2 asset_id b'int unsigned' NO MUL b''
3 version_group_id b'varchar(128)' NO b''
4 job_key b'varchar(128)' NO MUL b''
5 window_name b'varchar(64)' NO b'on_demand' b''
6 run_trigger b'varchar(32)' NO b'scheduled' b''
7 params_json b'json' YES b''
8 requested_by b'varchar(128)' NO b'scheduler' b''
9 started_at b'datetime(6)' NO b''
10 ended_at b'datetime(6)' YES b''
11 duration_ms b'int unsigned' YES b''
12 status b'varchar(32)' NO MUL b'running' b''
13 steps_total b'int unsigned' NO b'0' b''
14 steps_completed b'int unsigned' NO b'0' b''
15 step_results_json b'json' YES b''
16 error_class b'varchar(64)' YES b''
17 error_message b'text' YES b''
18 error_step b'varchar(128)' YES b''
19 error_detail b'text' YES b''
20 retry_count b'int unsigned' NO b'0' b''
21 max_retries b'int unsigned' NO b'2' b''
22 failure_message_asset_id b'int unsigned' YES b''
23 run_as_user_id b'int' NO b'0' b''
24 executed_by b'varchar(128)' NO b'' b''

Indexes:

  • PRIMARY (unique execution_id)
  • idx_ape_asset_started (asset_id, started_at)
  • idx_ape_job_key (job_key)
  • idx_ape_status (status)

logos_asset_relationships TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 31

Platform identity, connector, registry, jobs, or operations object.

Domain: Asset registry — graph layer (skills, tables, links)

#ColumnTypeNullKeyDefaultExtraComment
1 relationship_id b'bigint unsigned' NO PRI auto_increment b''
2 source_asset_id b'int unsigned' NO MUL b''
3 related_asset_id b'int unsigned' NO MUL b''
4 relationship_type b'varchar(64)' NO MUL b''
5 description b'text' YES b''
6 sort_order b'varchar(32)' YES b''
7 record_status b'varchar(32)' NO b'active' b''
8 human_user_id b'int' NO MUL b'0' b''
9 added_by_entity b'varchar(128)' NO b''
10 added_at b'datetime(6)' NO b''

Indexes:

  • PRIMARY (unique relationship_id)
  • idx_logos_asset_rel_human (human_user_id)
  • idx_logos_asset_rel_src (source_asset_id, relationship_type)
  • idx_logos_asset_rel_tgt (related_asset_id, relationship_type)
  • idx_logos_asset_rel_type (relationship_type)

logos_asset_types TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 39

Platform identity, connector, registry, jobs, or operations object.

Domain: Asset registry — graph layer (skills, tables, links)

#ColumnTypeNullKeyDefaultExtraComment
1 asset_type b'varchar(64)' NO PRI b''
2 display_label b'varchar(128)' NO b''
3 description b'text' YES b''
4 default_asset_layer b'varchar(32)' NO MUL b'platform' b''
5 default_asset_domain b'varchar(64)' NO MUL b'logos.Platform' b'Default logos asset_domain for this asset type'
6 authority_store b'varchar(32)' NO b'registry' b''
7 scope_modes b'json' NO b''
8 key_field b'varchar(64)' NO b'asset_key' b''
9 body_format b'varchar(32)' YES b''
10 router_type b'varchar(64)' YES b''
11 supports_links b'tinyint(1)' NO b'1' b''
12 supports_events b'tinyint(1)' NO b'1' b''
13 soft_delete b'tinyint(1)' NO b'1' b''
14 is_registry_type b'tinyint(1)' NO b'1' b''
15 record_status b'varchar(32)' NO MUL b'active' b''
16 sort_order b'int' NO b'0' b''
17 default_display_priority b'int' NO b'500' b''
18 default_creating_entity_logic b'varchar(64)' NO b'active_entity' b'Default creating_entity_id rule'
19 default_owning_entity_logic b'varchar(64)' NO b'creating_entity' b'Default owning_entity_id rule'
20 default_responsible_entity_logic b'varchar(64)' NO b'owning_entity' b'Default responsible_entity_id rule'
21 tags_json b'json' YES b''
22 maintenance_def_json b'json' YES b'{"allowed":bool,"calls":["sql","asset","tool","agent"]}'
23 added_at b'datetime(6)' NO b''
24 added_by_entity b'varchar(128)' NO b'system' b''

Indexes:

  • PRIMARY (unique asset_type)
  • idx_logos_asset_types_domain (default_asset_domain)
  • idx_logos_asset_types_layer (default_asset_layer)
  • idx_logos_asset_types_status (record_status)

logos_assets TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 181,265

Append-only asset catalog (skills, tables, views, pages, jobs, …). Writers: skill_create, view_create, page_create, registry_register_asset, write_primary paths.

Domain: Asset registry — graph layer (skills, tables, links)

#ColumnTypeNullKeyDefaultExtraComment
1 id b'bigint unsigned' NO PRI auto_increment b''
2 asset_id b'int unsigned' NO MUL b''
3 version_group_id b'varchar(128)' YES MUL b'Stable logical id; default vg_<asset_id>'
4 asset_key b'varchar(128)' YES MUL b''
5 asset_type b'varchar(64)' NO MUL b''
6 asset_name b'varchar(255)' NO MUL b''
7 asset_description b'text' YES b''
8 asset_body b'mediumtext' YES b''
9 asset_body_format b'varchar(32)' YES b''
10 body_json b'json' YES b'Four-organ body: payload/configuration/interface/relationships'
11 internal_path b'varchar(512)' YES MUL b'Physical SQL object path for table/view'
12 size_estimate b'bigint' YES b''
13 active_key b'varchar(512)' YES UNI b'Unique key for the one active version row'
14 conversation_id b'varchar(160)' YES MUL b'Provider-qualified conversation provenance'
15 scope b'varchar(128)' NO MUL b''
16 asset_scope b'varchar(32)' YES MUL b'Scope kind: global|user|project|platform|world'
17 project_id b'varchar(128)' YES b'Project slug when asset_scope=project'
18 asset_layer b'varchar(32)' NO b'platform' b''
19 asset_domain b'varchar(64)' NO MUL b'logos.Platform' b'Governance domain: logos.Platform|logos.World.Gallery|logos.World.Application|logos.World.Entity|logos.Applications'
20 parent_asset_id b'int unsigned' YES MUL b''
21 sort_order b'varchar(32)' YES b''
22 display_priority b'int' YES b''
23 human_user_id b'int' NO MUL b'0' b''
24 ai_user_id b'int' NO b'0' b''
25 added_by_entity b'varchar(128)' NO b''
26 entity_id b'varchar(128)' YES b'Author entity (canonical)'
27 creating_entity_id b'varchar(128)' YES b'Entity that created this asset version'
28 owning_entity_id b'varchar(128)' YES MUL b'Entity that owns stewardship of the asset'
29 responsible_entity_id b'varchar(128)' YES MUL b'Entity responsible for maintenance jobs'
30 record_status b'varchar(32)' NO MUL b'active' b''
31 archive_strategy b'json' YES b''
32 tags_json b'json' YES b''
33 asset_maintenance_script b'json' YES b'Maintenance playbook (steps; no top-level when)'
34 asset_schedule b'json' YES b'Array of cron windows {name,when,timezone,enabled,params,pre,post}'
35 added_at b'datetime(6)' NO b''
36 deleted_date b'datetime(6)' YES b'When this version was superseded/deleted'

Indexes:

  • PRIMARY (unique id)
  • idx_logos_assets_asset_id (asset_id)
  • idx_logos_assets_asset_scope (asset_scope, project_id, record_status)
  • idx_logos_assets_conversation (conversation_id)
  • idx_logos_assets_domain (asset_domain, record_status)
  • idx_logos_assets_human (human_user_id, ai_user_id)
  • idx_logos_assets_human_type_status (human_user_id, asset_type, record_status)
  • idx_logos_assets_internal_path (internal_path)
  • idx_logos_assets_key (asset_key)
  • idx_logos_assets_name (asset_name)
  • idx_logos_assets_natural_key (asset_type, asset_key, asset_layer, scope, human_user_id)
  • idx_logos_assets_nav_menu (asset_type, record_status, scope, human_user_id)
  • idx_logos_assets_owning_entity (owning_entity_id, record_status)
  • idx_logos_assets_parent (parent_asset_id, sort_order)
  • idx_logos_assets_record_status (record_status)
  • idx_logos_assets_responsible_entity (responsible_entity_id, record_status)
  • idx_logos_assets_scope (scope)
  • idx_logos_assets_type (asset_type)
  • idx_logos_assets_type_assetid (asset_type, asset_id)
  • idx_logos_assets_version_group (version_group_id)
  • uq_logos_assets_version (asset_id, added_at)
  • ux_logos_active_key (active_key)

logos_attributes TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 1,423,182

Append-only key/value metadata on assets (visibility, trigger_phrases, …). Writers: registry_set_attribute.

Domain: Asset registry — graph layer (skills, tables, links)

#ColumnTypeNullKeyDefaultExtraComment
1 attribute_id b'bigint unsigned' NO PRI auto_increment b''
2 asset_id b'int unsigned' NO MUL b''
3 name b'varchar(128)' NO MUL b''
4 value_text b'text' YES b''
5 value_number b'double' YES b''
6 value_json b'json' YES b''
7 human_user_id b'int' NO MUL b'0' b''
8 set_by_entity b'varchar(128)' NO b''
9 set_at b'datetime(6)' NO b''

Indexes:

  • PRIMARY (unique attribute_id)
  • idx_logos_attrs_asset_name (asset_id, name, set_at)
  • idx_logos_attrs_human (human_user_id)
  • idx_logos_attrs_name (name)

logos_events TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 285,192

Telemetry ledger — invocations, registry audit events, queue drain progress. Writers: registry_log_event, job runs. (Historical rows may include event_type='dual_write' from pre-cutover migration.)

Domain: Asset registry — graph layer (skills, tables, links)

#ColumnTypeNullKeyDefaultExtraComment
1 event_id b'bigint unsigned' NO PRI auto_increment b''
2 event_type b'varchar(64)' NO MUL b''
3 subject_id b'int unsigned' YES MUL b''
4 related_id b'int unsigned' YES b''
5 actor_entity b'varchar(128)' NO MUL b''
6 human_user_id b'int' NO MUL b'0' b''
7 outcome b'varchar(32)' YES b''
8 score b'double' YES b''
9 payload_json b'json' YES b''
10 notes b'text' YES b''
11 occurred_at b'datetime(6)' NO b''

Indexes:

  • PRIMARY (unique event_id)
  • idx_logos_events_actor (actor_entity)
  • idx_logos_events_human (human_user_id, occurred_at)
  • idx_logos_events_subject (subject_id, occurred_at)
  • idx_logos_events_type (event_type, occurred_at)

logos_execution_log TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 3,225

Platform identity, connector, registry, jobs, or operations object.

Domain: Identity — users, OAuth, connections

#ColumnTypeNullKeyDefaultExtraComment
1 id b'bigint unsigned' NO PRI auto_increment b''
2 started_at b'datetime' NO MUL b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''
3 finished_at b'datetime' YES b''
4 duration_ms b'int' YES b''
5 status b"enum('running','success','failed')" NO b'running' b''
6 execution_kind b"enum('job','mcp_sql','mcp_sql_script','mcp_ingest')" NO b'job' b''
7 trigger_mode b'varchar(32)' NO b'scheduled' b''
8 triggered_by b'varchar(64)' NO b'scheduler' b''
9 job_id b'bigint unsigned' YES b''
10 job_run_id b'bigint unsigned' YES MUL b''
11 job_key b'varchar(128)' YES b''
12 job_title b'varchar(255)' YES b''
13 tool_name b'varchar(64)' YES b''
14 run_mode b'varchar(32)' YES b''
15 owner_entity b'varchar(128)' YES b''
16 project_slug b'varchar(64)' YES b''
17 actor_entity b'varchar(128)' YES b''
18 ai_user_id b'int' YES b''
19 human_user_id b'int' NO MUL b'0' b''
20 human_username b'varchar(120)' YES b''
21 agent_connector_key b'varchar(512)' YES b''
22 conversation_key b'varchar(256)' YES MUL b''
23 source_platform b'varchar(64)' YES b''
24 rows_inserted b'int' NO b'0' b''
25 rows_updated b'int' NO b'0' b''
26 rows_deleted b'int' NO b'0' b''
27 rows_changed b'int' NO b'0' b''
28 queue_rows_ok b'int' NO b'0' b''
29 queue_rows_failed b'int' NO b'0' b''
30 summary b'text' YES b''
31 error_text b'text' YES b''
32 detail_json b'json' YES b''

Indexes:

  • PRIMARY (unique id)
  • idx_exec_log_conversation (conversation_key)
  • idx_exec_log_human (human_user_id, started_at)
  • idx_exec_log_job_run (job_run_id)
  • idx_exec_log_started (started_at)

logos_job_runs TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 10,515

Append-only execution history per logos_jobs row (status, lease, output).

Domain: Jobs — scheduled work queue

#ColumnTypeNullKeyDefaultExtraComment
1 id b'bigint unsigned' NO PRI auto_increment b''
2 job_id b'bigint unsigned' NO MUL b''
3 started_at b'datetime' NO MUL b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''
4 finished_at b'datetime' YES b''
5 status b"enum('running','success','failed','skipped')" NO b'running' b''
6 run_mode b"enum('core','mcp_tools','agentic','composite')" NO b''
7 summary b'text' YES b''
8 error_text b'text' YES b''
9 tool_calls_json b'json' YES b''
10 triggered_by b'varchar(64)' NO b'scheduler' b''

Indexes:

  • PRIMARY (unique id)
  • idx_logos_job_runs_job (job_id, started_at)
  • idx_logos_job_runs_started (started_at)

logos_jobs TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 50

Scheduled job definitions (cron, handler, owner, approval). Writers: job_create, Platform/Jobs scheduler.

Domain: Jobs — scheduled work queue

#ColumnTypeNullKeyDefaultExtraComment
1 id b'bigint unsigned' NO PRI auto_increment b''
2 job_key b'varchar(128)' NO b''
3 owner_entity b'varchar(128)' NO MUL b''
4 owner_ai_user_id b'int' YES b''
5 human_user_id b'int' NO MUL b'0' b''
6 human_username b'varchar(120)' YES b''
7 project_slug b'varchar(64)' YES b''
8 priority b'int' NO b'0' b''
9 title b'varchar(255)' NO b'' b''
10 description b'text' YES b''
11 run_mode b"enum('core','mcp_tools','agentic','composite')" NO b'mcp_tools' b''
12 schedule_kind b"enum('once','interval')" NO b'interval' b''
13 interval_seconds b'int' YES b''
14 cron_expr b'varchar(128)' YES b''
15 timezone b'varchar(64)' NO b'UTC' b''
16 next_run_at b'datetime' YES b''
17 last_run_at b'datetime' YES b''
18 status b"enum('pending_approval','active','paused','completed','failed','running')" NO MUL b'pending_approval' b''
19 payload_json b'json' YES b''
20 skill_name b'varchar(128)' YES b''
21 skill_version_pinned b'varchar(64)' YES b''
22 max_runs_per_day b'int' NO b'24' b''
23 min_interval_seconds b'int' NO b'300' b''
24 runs_today b'int' NO b'0' b''
25 runs_today_date b'date' YES b''
26 consecutive_failures b'int' NO b'0' b''
27 max_consecutive_failures b'int' NO b'3' b''
28 lease_expires_at b'datetime' YES b''
29 created_by_entity b'varchar(128)' NO b'' b''
30 approved_by b'varchar(120)' YES b''
31 approved_at b'datetime' YES b''
32 created_at b'datetime' NO b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''
33 updated_at b'datetime' NO b'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP b''

Indexes:

  • PRIMARY (unique id)
  • idx_logos_jobs_human (human_user_id, status)
  • idx_logos_jobs_next_run (status, next_run_at)
  • idx_logos_jobs_owner (owner_entity, human_user_id)
  • uq_logos_jobs_scope_key (owner_entity, human_user_id, job_key)

logos_project_queue_limits TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 0

Platform identity, connector, registry, jobs, or operations object.

Domain: Identity — users, OAuth, connections

#ColumnTypeNullKeyDefaultExtraComment
1 id b'bigint unsigned' NO PRI auto_increment b''
2 owner_entity b'varchar(128)' NO MUL b''
3 human_user_id b'int' NO b'0' b''
4 project_slug b'varchar(64)' NO b''
5 max_concurrent_runs b'int' NO b'3' b''
6 created_at b'datetime' NO b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''
7 updated_at b'datetime' NO b'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP b''

Indexes:

  • PRIMARY (unique id)
  • uq_project_queue_limit (owner_entity, human_user_id, project_slug)

logos_provider_api_calls TABLE entity-related

Type: BASE TABLE · Engine: InnoDB · Rows: 2,253

Platform provider API ledger — LLM tokens, model, cost per call. Writers: Logos.Utilities.services.log_provider_call(). Future: STT/TTS and app-scoped rebilling.

Domain: Usage ledger — provider API calls, tokens, cost · Rename candidate: logos_provider_api_calls

#ColumnTypeNullKeyDefaultExtraComment
1 id b'int' NO PRI auto_increment b''
2 conversation_id b'varchar(255)' YES MUL b''
3 message_id b'int' YES b''
4 entity_name b'varchar(255)' YES MUL b''
5 model b'varchar(100)' YES b''
6 provider b'varchar(50)' YES b''
7 prompt_tokens b'int' YES b'0' b''
8 completion_tokens b'int' YES b'0' b''
9 total_tokens b'int' YES b'0' b''
10 estimated_cost b'decimal(10,6)' YES b'0.000000' b''
11 duration_seconds b'decimal(8,3)' YES b''
12 call_type b"enum('response','judge','evaluator','consciousness','backend','thinking_round','thinking_round_followup')" YES MUL b'response' b''
13 created_at b'datetime' YES MUL b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''

Indexes:

  • PRIMARY (unique id)
  • idx_usage_conv (conversation_id)
  • idx_usage_created (created_at)
  • idx_usage_entity (entity_name)
  • idx_usage_type (call_type)

logos_queue_row_history TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 12,680

Platform identity, connector, registry, jobs, or operations object.

Domain: Identity — users, OAuth, connections

#ColumnTypeNullKeyDefaultExtraComment
1 id b'bigint unsigned' NO PRI auto_increment b''
2 queue_asset_id b'int unsigned' NO MUL b''
3 row_key b'varchar(255)' YES b''
4 checksum b'varchar(64)' YES b''
5 status b"enum('succeeded','failed','skipped')" NO b'succeeded' b''
6 artifact_id b'int' YES b''
7 retry_count b'int' NO b'0' b''
8 processed_at b'datetime' NO b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''
9 error_text b'text' YES b''

Indexes:

  • PRIMARY (unique id)
  • idx_queue_checksum (queue_asset_id, checksum)
  • idx_queue_processed (queue_asset_id, processed_at)
  • uq_queue_row_key (queue_asset_id, row_key)

logos_semantic_index TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 3,823

Platform identity, connector, registry, jobs, or operations object.

Domain: Identity — users, OAuth, connections

#ColumnTypeNullKeyDefaultExtraComment
1 asset_id b'int unsigned' NO PRI b''
2 human_user_id b'int' NO PRI b'0' b''
3 asset_type b'varchar(64)' NO b''
4 asset_key b'varchar(128)' YES b''
5 scope b'varchar(128)' NO MUL b''
6 asset_layer b'varchar(32)' NO b'platform' b''
7 search_text b'mediumtext' NO b''
8 summary_text b'text' YES b''
9 source_added_at b'datetime(6)' YES b''
10 indexed_at b'datetime(6)' NO MUL b''

Indexes:

  • PRIMARY (unique asset_id, human_user_id)
  • idx_semantic_indexed (indexed_at)
  • idx_semantic_scope (scope, asset_type)

logos_semantic_index_meta TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 1

Platform identity, connector, registry, jobs, or operations object.

Domain: Identity — users, OAuth, connections

#ColumnTypeNullKeyDefaultExtraComment
1 human_user_id b'int' NO PRI b''
2 last_index_duration_sec b'double' YES b''
3 last_index_started_at b'datetime(6)' YES b''
4 last_index_completed_at b'datetime(6)' YES b''
5 last_index_count b'int' YES b''
6 last_changed_index_count b'int' YES b''

Indexes:

  • PRIMARY (unique human_user_id)

logos_sync_assets_staging TABLE

Type: BASE TABLE · Engine: InnoDB · Rows: 228,891

Platform identity, connector, registry, jobs, or operations object.

Domain: Identity — users, OAuth, connections

#ColumnTypeNullKeyDefaultExtraComment
1 id b'bigint' NO PRI auto_increment b''
2 sync_run_id b'varchar(64)' NO MUL b''
3 asset_type b'varchar(32)' NO b''
4 asset_key b'varchar(255)' NO b''
5 scope b'varchar(255)' NO b''
6 human_user_id b'int' NO b'0' b''
7 ai_user_id b'int' NO b'0' b''
8 workspace_scope b'varchar(32)' NO b'' b''
9 project_slug b'varchar(255)' NO b'' b''
10 source b'varchar(64)' NO b'' b''
11 db_file b'text' YES b''
12 disk_path b'text' YES b''
13 payload_json b'json' YES b''
14 created_at b'datetime' NO b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''

Indexes:

  • PRIMARY (unique id)
  • idx_sync_run (sync_run_id)
  • uq_sync_natural (sync_run_id, asset_type, asset_key, scope, human_user_id, ai_user_id)

Views (28)

SQL views (filtered slices, inbox lenses, connector state).

Cortex — core entity model (1)

cortex_thoughts_current VIEW

Type: VIEW · Engine: — · Rows: 2,772 · VIEW

VIEW: latest thought per (entity, domain, type) from append-only cortex_thoughts. Primary read path for worldview/directives/tasks.

Domain: Cognition — thoughts & prompt assembly

#ColumnTypeNullKeyDefaultExtraComment
1 id b'bigint' NO b'0' b''
2 entity_id b'int' NO b'FK cortex_entities.id'
3 thought_type b'varchar(64)' NO b''
4 domain b'varchar(191)' NO b''
5 content b'text' NO b''
6 parent_id b'bigint' YES b''
7 created_at b'datetime' NO b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `cortex_thoughts_current` AS select `t`.`id` AS `id`,`t`.`entity_id` AS `entity_id`,`t`.`thought_type` AS `thought_type`,`t`.`domain` AS `domain`,`t`.`content` AS `content`,`t`.`parent_id` AS `parent_id`,`t`.`created_at` AS `created_at` from (`cortex_thoughts` `t` join (select `cortex_thoughts`.`entity_id` AS `entity_id`,`cortex_thoughts`.`domain` AS `domain`,`cortex_thoughts`.`thought_type` AS `thought_type`,max(`cortex_thoughts`.`id`) AS `mid` from `cortex_thoughts` group by `cortex_thoughts`.`entity_id`,`cortex_thoughts`.`domain`,`cortex_thoughts`.`thought_type`) `cur` on((`t`.`id` = `cur`.`mid`))) where (`t`.`content` not in ('','[deleted]'))

Cortex — views (filtered slices) (2)

current_logos_agent_connection_assignments VIEW

Type: VIEW · Engine: — · Rows: 85 · VIEW

VIEW: current effective assignment per connection.

Domain: Identity — users, OAuth, connections

#ColumnTypeNullKeyDefaultExtraComment
1 agent_connector_key b'varchar(512)' NO b''
2 effective_at b'datetime(6)' NO b''
3 entity_id b'bigint' NO b'0' b''
4 user_id b'bigint' NO b'0' b''
5 project_id b'bigint' NO b'0' b''
6 assignment_kind b'varchar(32)' NO b''
7 role b'varchar(32)' YES b''
8 responsibility b'varchar(64)' YES b''
9 status b'varchar(32)' NO b'active' b''
10 change_reason b'varchar(64)' YES b''
11 changed_by_connector b'varchar(512)' YES b''
12 details_json b'json' YES b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `current_logos_agent_connection_assignments` AS select `a`.`agent_connector_key` AS `agent_connector_key`,`a`.`effective_at` AS `effective_at`,`a`.`entity_id` AS `entity_id`,`a`.`user_id` AS `user_id`,`a`.`project_id` AS `project_id`,`a`.`assignment_kind` AS `assignment_kind`,`a`.`role` AS `role`,`a`.`responsibility` AS `responsibility`,`a`.`status` AS `status`,`a`.`change_reason` AS `change_reason`,`a`.`changed_by_connector` AS `changed_by_connector`,`a`.`details_json` AS `details_json` from (`logos_agent_connection_assignments` `a` join (select `logos_agent_connection_assignments`.`agent_connector_key` AS `agent_connector_key`,`logos_agent_connection_assignments`.`assignment_kind` AS `assignment_kind`,max(`logos_agent_connection_assignments`.`effective_at`) AS `max_effective_at` from `logos_agent_connection_assignments` where (`logos_agent_connection_assignments`.`status` <> 'revoked') group by `logos_agent_connection_assignments`.`agent_connector_key`,`logos_agent_connection_assignments`.`assignment_kind`) `latest` on(((`latest`.`agent_connector_key` = `a`.`agent_connector_key`) and (`latest`.`assignment_kind` = `a`.`assignment_kind`) and (`latest`.`max_effective_at` = `a`.`effective_at`))))

current_logos_agent_connection_state VIEW

Type: VIEW · Engine: — · Rows: 55 · VIEW

VIEW: latest state row per connection (active session metadata).

Domain: Identity — users, OAuth, connections

#ColumnTypeNullKeyDefaultExtraComment
1 agent_connector_key b'varchar(512)' NO b''
2 connector_kind b'varchar(32)' NO b''
3 oauth_client_id b'varchar(255)' YES b''
4 base_ai_user_id b'bigint' YES b''
5 primary_human_user_id b'bigint' YES b''
6 client_label b'varchar(255)' YES b''
7 first_seen_at b'datetime(6)' NO b''
8 entity_id b'bigint' NO b'0' b''
9 entity_claimed_at b'datetime(6)' YES b''
10 entity_role b'varchar(32)' YES b''
11 paired_human_user_id b'bigint' NO b'0' b''
12 human_paired_at b'datetime(6)' YES b''
13 human_role b'varchar(32)' YES b''
14 primary_project_id b'bigint' NO b'0' b''
15 project_focus_at b'datetime(6)' YES b''
16 impersonating_entity_id b'bigint' NO b'0' b''
17 impersonation_started_at b'datetime(6)' YES b''
18 impersonation_details b'json' YES b''
19 current_status b'varchar(11)' NO b'' b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `current_logos_agent_connection_state` AS select `c`.`agent_connector_key` AS `agent_connector_key`,`c`.`connector_kind` AS `connector_kind`,`c`.`oauth_client_id` AS `oauth_client_id`,`c`.`base_ai_user_id` AS `base_ai_user_id`,`c`.`primary_human_user_id` AS `primary_human_user_id`,`c`.`client_label` AS `client_label`,`c`.`first_seen_at` AS `first_seen_at`,coalesce(`ec`.`entity_id`,0) AS `entity_id`,`ec`.`effective_at` AS `entity_claimed_at`,`ec`.`role` AS `entity_role`,coalesce(`hp`.`user_id`,0) AS `paired_human_user_id`,`hp`.`effective_at` AS `human_paired_at`,`hp`.`role` AS `human_role`,coalesce(`pf`.`project_id`,0) AS `primary_project_id`,`pf`.`effective_at` AS `project_focus_at`,coalesce(`imp`.`entity_id`,0) AS `impersonating_entity_id`,`imp`.`effective_at` AS `impersonation_started_at`,`imp`.`details_json` AS `impersonation_details`,(case when (`rev`.`status` = 'revoked') then 'revoked' when (`hp`.`user_id` is not null) then 'paired' when (`ec`.`entity_id` is not null) then 'active' else 'provisional' end) AS `current_status` from (((((`logos_agent_connections` `c` left join `current_logos_agent_connection_assignments` `ec` on(((`ec`.`agent_connector_key` = `c`.`agent_connector_key`) and (`ec`.`assignment_kind` = 'entity_claimed')))) left join `current_logos_agent_connection_assignments` `hp` on(((`hp`.`agent_connector_key` = `c`.`agent_connector_key`) and (`hp`.`assignment_kind` = 'human_paired')))) left join `current_logos_agent_connection_assignments` `pf` on(((`pf`.`agent_connector_key` = `c`.`agent_connector_key`) and (`pf`.`assignment_kind` = 'project_focus')))) left join `current_logos_agent_connection_assignments` `imp` on(((`imp`.`agent_connector_key` = `c`.`agent_connector_key`) and (`imp`.`assignment_kind` = 'impersonation')))) left join (select `logos_agent_connection_assignments`.`agent_connector_key` AS `agent_connector_key`,`logos_agent_connection_assignments`.`status` AS `status` from `logos_agent_connection_assignments` where ((`logos_agent_connection_assignments`.`assignment_kind` = 'revoked') and (`logos_agent_connection_assignments`.`status` = 'revoked')) order by `logos_agent_connection_assignments`.`effective_at` desc limit 1) `rev` on((`rev`.`agent_connector_key` = `c`.`agent_connector_key`)))

Cortex — other (11)

cortex_conversation_insights * VIEW

Type: VIEW · Engine: — · Rows: 193 · VIEW

VIEW: aggregated insight snippets derived from Matrix conversation analysis.

Domain: Analytics — admin/reporting views · Rename candidate: matrix_conversation_insights

* Cleanup candidate: Analytics VIEW (admin_api) — fold into reporting or drop if unused

#ColumnTypeNullKeyDefaultExtraComment
1 entity_name b'varchar(255)' NO b'' b''
2 conversation_date b'date' YES b''
3 responses_given b'bigint' NO b'0' b''
4 avg_elevation b'decimal(14,4)' YES b''
5 rejected_responses b'bigint' NO b'0' b''
6 high_impact_responses b'bigint' NO b'0' b''
7 conversations_participated b'text' YES b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `cortex_conversation_insights` AS select `matrix_communications`.`entity_name` AS `entity_name`,cast(`matrix_communications`.`timestamp` as date) AS `conversation_date`,count(0) AS `responses_given`,avg(`matrix_communications`.`elevation_count`) AS `avg_elevation`,count((case when (`matrix_communications`.`validation_status` = 'rejected') then 1 end)) AS `rejected_responses`,count((case when (`matrix_communications`.`elevation_count` > 3) then 1 end)) AS `high_impact_responses`,group_concat(distinct `matrix_communications`.`conversation_id` order by `matrix_communications`.`timestamp` ASC separator ', ') AS `conversations_participated` from `matrix_communications` where (`matrix_communications`.`is_ai_generated` = 1) group by `matrix_communications`.`entity_name`,cast(`matrix_communications`.`timestamp` as date) having (`responses_given` > 5) order by `matrix_communications`.`entity_name`,`conversation_date` desc

cortex_directives VIEW

Type: VIEW · Engine: — · Rows: 412 · VIEW

VIEW: filter cortex_thoughts_current where thought_type='directive'. Behavioral rules injected into AI system prompts.

Domain: Cognition — thoughts & prompt assembly

#ColumnTypeNullKeyDefaultExtraComment
1 id b'bigint' NO b'0' b''
2 entity_name b'varchar(255)' NO b'Unique name identifier for the entity (e.g., "Elon", "Tesla", "Mars_Mission")'
3 directive b'text' NO b''
4 created b'datetime' NO b'0000-00-00 00:00:00' b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `cortex_directives` AS select `t`.`id` AS `id`,`e`.`entity_name` AS `entity_name`,`t`.`content` AS `directive`,`t`.`created_at` AS `created` from (`cortex_thoughts_current` `t` join `cortex_entities` `e` on((`e`.`id` = `t`.`entity_id`))) where (`t`.`thought_type` = 'directive')

cortex_matrix_reflection * VIEW

Type: VIEW · Engine: — · Rows: — · VIEW

VIEW: crosswalk between Matrix messages and related cognition rows.

Domain: Analytics — admin/reporting views · Rename candidate: matrix_reflection

* Cleanup candidate: Analytics VIEW (admin_api) — fold into reporting or drop if unused

#ColumnTypeNullKeyDefaultExtraComment
1 entity_name b'varchar(255)' NO b'' b''
2 conversation_id b'varchar(255)' NO b'' b''
3 conversation_topic b'varchar(500)' YES b''
4 prompt_received b'longtext' NO b''
5 my_response b'mediumtext' NO b''
6 when_said b'datetime' YES b'0000-00-00 00:00:00' b''
7 elevation_count b'int' YES b'0' b''
8 validation_status b'varchar(14)' NO b'' b''
9 reflection_prompt b'varchar(43)' NO b'' b''
10 other_participants b'text' YES b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `cortex_matrix_reflection` AS select `mc`.`entity_name` AS `entity_name`,`mc`.`conversation_id` AS `conversation_id`,`conv`.`title` AS `conversation_topic`,`mc`.`source_prompt` AS `prompt_received`,`mc`.`output_message` AS `my_response`,`mc`.`timestamp` AS `when_said`,`mc`.`elevation_count` AS `elevation_count`,`mc`.`validation_status` AS `validation_status`,(case when (`mc`.`elevation_count` > 5) then 'High impact - consider forming new thoughts' when (`mc`.`validation_status` = 'rejected') then 'Response rejected - reflect on why' when (length(`mc`.`output_message`) > 1000) then 'Long response - extract key beliefs' else 'Standard exchange' end) AS `reflection_prompt`,group_concat(distinct `other_mc`.`entity_name` order by `other_mc`.`entity_name` ASC separator ', ') AS `other_participants` from ((`matrix_communications` `mc` join `matrix_conversations` `conv` on((`mc`.`conversation_id` = `conv`.`conversation_id`))) left join `matrix_communications` `other_mc` on(((`mc`.`conversation_id` = `other_mc`.`conversation_id`) and (`mc`.`id` <> `other_mc`.`id`) and (`other_mc`.`is_ai_generated` = 1)))) where (`mc`.`is_ai_generated` = 1) group by `mc`.`id` order by `mc`.`entity_name`,`mc`.`timestamp` desc

cortex_memories VIEW

Type: VIEW · Engine: — · Rows: 252 · VIEW

VIEW: filter cortex_thoughts_current where thought_type='memory'. Experience recall for prompt assembly.

Domain: Cognition — thoughts & prompt assembly

#ColumnTypeNullKeyDefaultExtraComment
1 id b'bigint' NO b'0' b''
2 entity_name b'varchar(255)' NO b'Unique name identifier for the entity (e.g., "Elon", "Tesla", "Mars_Mission")'
3 memory_text b'text' NO b''
4 created b'datetime' NO b'0000-00-00 00:00:00' b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `cortex_memories` AS select `t`.`id` AS `id`,`e`.`entity_name` AS `entity_name`,`t`.`content` AS `memory_text`,`t`.`created_at` AS `created` from (`cortex_thoughts_current` `t` join `cortex_entities` `e` on((`e`.`id` = `t`.`entity_id`))) where (`t`.`thought_type` = 'memory')

cortex_personalities * VIEW

Type: VIEW · Engine: — · Rows: 283 · VIEW

VIEW: personality metadata joined from entities + thoughts.

Domain: Entity graph — registry & relationships

* Cleanup candidate: VIEW on entities.metadata — overlap with entity_get; consolidate read paths

#ColumnTypeNullKeyDefaultExtraComment
1 entity_name b'varchar(255)' NO b'Unique name identifier for the entity (e.g., "Elon", "Tesla", "Mars_Mission")'
2 personality_prompt b'longtext' YES b''
3 voice_gender b'longtext' YES b''
4 created b'datetime' YES b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b'When this entity was first created'
5 entity_type b"enum('ai','human','system','organization','concept','objective','html_locked','html_unlocked','special_agent','avatar','project','application','group')" YES b'ai' b''
6 display_name b'longtext' YES b''
7 core_mission b'longtext' YES b''
8 communication_style b'longtext' YES b''
9 expertise_domains b'json' YES b''
10 active_status b"enum('active','passive','standby','inactive')" YES b'active' b'Current operational state of the entity'
11 capability_level b'decimal(5,4)' YES b''
12 direct_messaging b'bigint unsigned' YES b''
13 additional_system_directives b'longtext' YES b''
14 response_metadata b'json' YES b''
15 default_bounce_limit b'int' NO b'1' b'Quality iterations: 1=single pass, 2+=Judge AI evaluates and can request regeneration'

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `cortex_personalities` AS select `cortex_entities`.`entity_name` AS `entity_name`,json_unquote(json_extract(`cortex_entities`.`metadata`,'$.personality_prompt')) AS `personality_prompt`,json_unquote(json_extract(`cortex_entities`.`metadata`,'$.voice_gender')) AS `voice_gender`,`cortex_entities`.`created` AS `created`,`cortex_entities`.`entity_type` AS `entity_type`,json_unquote(json_extract(`cortex_entities`.`metadata`,'$.display_name')) AS `display_name`,json_unquote(json_extract(`cortex_entities`.`metadata`,'$.core_mission')) AS `core_mission`,json_unquote(json_extract(`cortex_entities`.`metadata`,'$.communication_style')) AS `communication_style`,json_extract(`cortex_entities`.`metadata`,'$.expertise_domains') AS `expertise_domains`,`cortex_entities`.`active_status` AS `active_status`,cast(json_extract(`cortex_entities`.`metadata`,'$.capability_level') as decimal(5,4)) AS `capability_level`,cast(json_extract(`cortex_entities`.`metadata`,'$.direct_messaging') as unsigned) AS `direct_messaging`,json_unquote(json_extract(`cortex_entities`.`metadata`,'$.additional_system_directives')) AS `additional_system_directives`,json_extract(`cortex_entities`.`metadata`,'$.response_metadata') AS `response_metadata`,`cortex_entities`.`default_bounce_limit` AS `default_bounce_limit` from `cortex_entities`

cortex_projects VIEW

Type: VIEW · Engine: — · Rows: 125 · VIEW

VIEW: projects as entities joined via works_on relationships — not stored as cognition rows.

Domain: Entity graph — registry & relationships

#ColumnTypeNullKeyDefaultExtraComment
1 id b'int' NO b'0' b'Unique identifier for each entity'
2 entity_name b'varchar(255)' NO b'ID or name of the source (entity_name if entity, thought_id if thought)'
3 project_name b'longtext' YES b''
4 description b'longtext' NO b''
5 status b'longtext' NO b''
6 created b'datetime' YES b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b'When this entity was first created'

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `cortex_projects` AS select `e`.`id` AS `id`,`r`.`source_id` AS `entity_name`,coalesce(nullif(json_unquote(json_extract(`e`.`metadata`,'$.display_name')),''),substr(`e`.`entity_name`,9)) AS `project_name`,coalesce(nullif(json_unquote(json_extract(`e`.`metadata`,'$.description')),''),'') AS `description`,coalesce(nullif(json_unquote(json_extract(`e`.`metadata`,'$.workspace_status')),''),'active') AS `status`,`e`.`created` AS `created` from (`cortex_entities` `e` join `cortex_relationships_unified` `r` on(((`r`.`target_id` = `e`.`entity_name`) and (`r`.`target_type` = 'entity') and (`r`.`relationship_type` = 'works_on')))) where ((`e`.`entity_type` = 'project') and (`e`.`entity_name` like 'project:%') and (`r`.`source_type` = 'entity'))

cortex_tasks VIEW

Type: VIEW · Engine: — · Rows: 144 · VIEW

VIEW: filter cortex_thoughts_current where thought_type='task'. Open action items per entity.

Domain: Cognition — thoughts & prompt assembly

#ColumnTypeNullKeyDefaultExtraComment
1 id b'bigint' NO b'0' b''
2 entity_name b'varchar(255)' NO b'Unique name identifier for the entity (e.g., "Elon", "Tesla", "Mars_Mission")'
3 task_slot b'varchar(191)' NO b''
4 task_description b'text' NO b''
5 created b'datetime' NO b'0000-00-00 00:00:00' b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `cortex_tasks` AS select `t`.`id` AS `id`,`e`.`entity_name` AS `entity_name`,`t`.`domain` AS `task_slot`,`t`.`content` AS `task_description`,`t`.`created_at` AS `created` from (`cortex_thoughts_current` `t` join `cortex_entities` `e` on((`e`.`id` = `t`.`entity_id`))) where (`t`.`thought_type` = 'task')

cortex_thought_categories * VIEW entity-related

Type: VIEW · Engine: — · Rows: 75 · VIEW

VIEW: legacy shape over cortex_types (category=thought_category). Semantic buckets for classifying thoughts (75 categories).

Domain: Compatibility view — migrate readers, retire

* Cleanup candidate: Compatibility VIEW over cortex_types — migrate readers, then drop

#ColumnTypeNullKeyDefaultExtraComment
1 category_name b'varchar(64)' NO b''
2 description b'varchar(500)' YES b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `cortex_thought_categories` AS select `cortex_types`.`type_key` AS `category_name`,`cortex_types`.`description` AS `description` from `cortex_types` where ((`cortex_types`.`category` = 'thought_category') and (`cortex_types`.`status` = 'active'))

cortex_thought_evolution VIEW

Type: VIEW · Engine: — · Rows: 5,720 · VIEW

VIEW: history chain showing how a thought slot changed over time.

Domain: Cognition — thoughts & prompt assembly

#ColumnTypeNullKeyDefaultExtraComment
1 entity_name b'varchar(255)' NO b'Unique name identifier for the entity (e.g., "Elon", "Tesla", "Mars_Mission")'
2 category b'varchar(191)' NO b''
3 thought_type b'varchar(64)' NO b''
4 content b'text' NO b''
5 created b'datetime' NO b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''
6 previous_thought b'mediumtext' YES b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `cortex_thought_evolution` AS select `e`.`entity_name` AS `entity_name`,`t`.`domain` AS `category`,`t`.`thought_type` AS `thought_type`,`t`.`content` AS `content`,`t`.`created_at` AS `created`,lag(`t`.`content`) OVER (PARTITION BY `t`.`entity_id`,`t`.`domain`,`t`.`thought_type` ORDER BY `t`.`created_at` )  AS `previous_thought` from (`cortex_thoughts` `t` join `cortex_entities` `e` on((`e`.`id` = `t`.`entity_id`)))

cortex_thought_types * VIEW entity-related

Type: VIEW · Engine: — · Rows: 23 · VIEW

VIEW: legacy shape over cortex_types (category=thought_type). Icons/rankings in metadata JSON. Read by forms and Assay scripts.

Domain: Compatibility view — migrate readers, retire

* Cleanup candidate: Compatibility VIEW over cortex_types — migrate readers (Assay, agents.py), then drop

#ColumnTypeNullKeyDefaultExtraComment
1 thought_type b'varchar(64)' NO b''
2 display_name b'varchar(128)' NO b''
3 type_ranking b'decimal(10,4)' NO b'0.0000' b''
4 icon b'longtext' YES b''
5 description b'varchar(500)' YES b''
6 created b'datetime' NO b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `cortex_thought_types` AS select `cortex_types`.`type_key` AS `thought_type`,`cortex_types`.`display_name` AS `display_name`,coalesce(cast(json_unquote(json_extract(`cortex_types`.`metadata`,'$.type_ranking')) as decimal(10,4)),5.0000) AS `type_ranking`,nullif(json_unquote(json_extract(`cortex_types`.`metadata`,'$.icon')),'null') AS `icon`,`cortex_types`.`description` AS `description`,`cortex_types`.`created_at` AS `created` from `cortex_types` where ((`cortex_types`.`category` = 'thought_type') and (`cortex_types`.`status` = 'active'))

cortex_worldview VIEW

Type: VIEW · Engine: — · Rows: 65 · VIEW

VIEW: ranked slice of an entity's active thoughts for worldview displays.

Domain: Cognition — thoughts & prompt assembly

#ColumnTypeNullKeyDefaultExtraComment
1 entity_name b'varchar(255)' NO b'Unique name identifier for the entity (e.g., "Elon", "Tesla", "Mars_Mission")'
2 category b'varchar(191)' NO b''
3 thought_type b'varchar(64)' NO b''
4 content b'text' NO b''
5 created b'datetime' NO b'0000-00-00 00:00:00' b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `cortex_worldview` AS select `e`.`entity_name` AS `entity_name`,`t`.`domain` AS `category`,`t`.`thought_type` AS `thought_type`,`t`.`content` AS `content`,`t`.`created_at` AS `created` from (`cortex_thoughts_current` `t` join `cortex_entities` `e` on((`e`.`id` = `t`.`entity_id`))) where ((`t`.`domain` like 'worldview/%') or (`t`.`thought_type` in ('belief','worldview','worldview_shift'))) order by `e`.`entity_name`,`t`.`domain`,`t`.`created_at` desc

Matrix — messaging & lifecycle (3)

matrix_communications * VIEW entity-related

Type: VIEW · Engine: — · Rows: 6,114 · VIEW

VIEW: flat legacy message shape (v2 messages + sidecars joined). Primary read path for Codex, lifecycle, MCP inbox, developer thread.

Domain: Compatibility view — migrate readers, retire

* Cleanup candidate: Compatibility VIEW (messages + sidecars) — large migration; target v2 tables

#ColumnTypeNullKeyDefaultExtraComment
1 id b'bigint' YES b'0' b''
2 entity_name b'varchar(255)' NO b'' b''
3 conversation_id b'varchar(255)' NO b'' b''
4 source_prompt b'longtext' NO b''
5 output_message b'mediumtext' NO b''
6 timestamp b'datetime' YES b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b''
7 is_processed b'int' NO b'0' b''
8 is_ai_generated b'int' NO b'0' b''
9 parent_message_id b'varchar(36)' YES b''
10 action_tags_resolved b'tinyint(1)' YES b'0' b''
11 elevation_count b'int' YES b'0' b''
12 direct_recipient b'text' NO b''
13 processing_status b'varchar(10)' NO b'' b''
14 response_round b'int' YES b''
15 raw_response b'mediumtext' YES b''
16 engine_processing_log b'json' YES b''
17 source_prompt_raw b'mediumtext' YES b''
18 output_message_raw b'mediumtext' YES b''
19 validation_status b'varchar(14)' NO b'' b''
20 message_context b'json' YES b''
21 entity_name_to b'varchar(100)' YES b''
22 evaluator_count b'tinyint' YES b''
23 lifecycle_parent_id b'bigint' YES b''
24 lifecycle_root_id b'bigint' YES b''
25 message_type b'varchar(64)' YES b''
26 message_subtype b'varchar(64)' YES b''
27 lifecycle_status b'varchar(32)' YES b''
28 effective_at b'datetime' YES b''
29 response_code b'varchar(64)' YES b''
30 lifecycle_processed_at b'datetime' YES b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `matrix_communications` AS select `m`.`id` AS `id`,(convert(coalesce(`meta`.`entity_name`,`sender`.`entity_name`) using utf8mb4) collate utf8mb4_unicode_ci) AS `entity_name`,(convert(coalesce(`lc`.`conversation_id`,`conv`.`conversation_id`) using utf8mb4) collate utf8mb4_unicode_ci) AS `conversation_id`,(convert(coalesce(`meta`.`source_prompt`,'') using utf8mb4) collate utf8mb4_unicode_ci) AS `source_prompt`,(convert(`m`.`content` using utf8mb4) collate utf8mb4_unicode_ci) AS `output_message`,`m`.`created_at` AS `timestamp`,coalesce(`meta`.`is_processed`,0) AS `is_processed`,coalesce(`meta`.`is_ai_generated`,1) AS `is_ai_generated`,`meta`.`parent_message_id` AS `parent_message_id`,`meta`.`action_tags_resolved` AS `action_tags_resolved`,`meta`.`elevation_count` AS `elevation_count`,(convert((case when (`m`.`recipient_list` is null) then '["ALL"]' when (`m`.`recipient_list` = '') then coalesce(`meta`.`direct_recipient`,'[]') else concat('[',ifnull((select group_concat(json_quote(`rc`.`entity_name`) order by `rc`.`id` ASC separator ',') from `cortex_entities` `rc` where (find_in_set(`rc`.`id`,`m`.`recipient_list`) > 0)),''),']') end) using utf8mb4) collate utf8mb4_unicode_ci) AS `direct_recipient`,(convert(coalesce(`meta`.`processing_status`,'pending') using utf8mb4) collate utf8mb4_unicode_ci) AS `processing_status`,`meta`.`response_round` AS `response_round`,`meta`.`raw_response` AS `raw_response`,`meta`.`engine_processing_log` AS `engine_processing_log`,`meta`.`source_prompt_raw` AS `source_prompt_raw`,`meta`.`output_message_raw` AS `output_message_raw`,(convert(coalesce(`meta`.`validation_status`,'none') using utf8mb4) collate utf8mb4_unicode_ci) AS `validation_status`,`meta`.`message_context` AS `message_context`,(convert(`meta`.`entity_name_to` using utf8mb4) collate utf8mb4_unicode_ci) AS `entity_name_to`,`meta`.`evaluator_count` AS `evaluator_count`,coalesce(`lc`.`lifecycle_parent_id`,`m`.`parent_message_id`) AS `lifecycle_parent_id`,`lc`.`lifecycle_root_id` AS `lifecycle_root_id`,(convert(`m`.`message_type` using utf8mb4) collate utf8mb4_unicode_ci) AS `message_type`,(convert(`lc`.`message_subtype` using utf8mb4) collate utf8mb4_unicode_ci) AS `message_subtype`,(convert(`lc`.`lifecycle_status` using utf8mb4) collate utf8mb4_unicode_ci) AS `lifecycle_status`,`lc`.`effective_at` AS `effective_at`,(convert(`lc`.`response_code` using utf8mb4) collate utf8mb4_unicode_ci) AS `response_code`,`lc`.`lifecycle_processed_at` AS `lifecycle_processed_at` from ((((`matrix_messages` `m` join `matrix_meeting_conversations` `conv` on((`conv`.`meeting_id` = `m`.`meeting_id`))) join `cortex_entities` `sender` on((`sender`.`id` = `m`.`sender_entity_id`))) left join `matrix_message_lifecycle` `lc` on((`lc`.`message_id` = `m`.`id`))) left join `matrix_message_meta` `meta` on((`meta`.`message_id` = `m`.`id`)))

matrix_conversations * VIEW

Type: VIEW · Engine: — · Rows: 3,000 · VIEW

VIEW: legacy conversation header shape from matrix_meeting_conversations. Readers: Conversation service, Matrix UIs, round/bounce settings.

Domain: Compatibility view — migrate readers, retire

* Cleanup candidate: Compatibility VIEW — migrate Conversation readers to matrix_meeting_conversations

#ColumnTypeNullKeyDefaultExtraComment
1 conversation_id b'varchar(255)' YES b''
2 title b'varchar(500)' YES b''
3 participants b'mediumtext' YES b''
4 created b'datetime' NO b'0000-00-00 00:00:00' b''
5 last_activity b'datetime' YES b''
6 max_bounces b'bigint' NO b'0' b''
7 max_auto_rounds b'bigint' NO b'0' b''
8 current_auto_round b'bigint' NO b'0' b''
9 conversation_mode b'varchar(50)' YES b''
10 cortex_active b'tinyint(1)' YES b'1' b''
11 quality_threshold b'decimal(5,4)' YES b'7.0000' b''
12 cortex_system_prompt b'mediumtext' YES b''
13 cortex_active_level b'varchar(4)' YES b''
14 cortex_mode b'varchar(11)' YES b''
15 summary b'mediumtext' YES b''
16 summary_updated_at b'datetime' YES b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `matrix_conversations` AS select (convert(`conv`.`conversation_id` using utf8mb4) collate utf8mb4_unicode_ci) AS `conversation_id`,(convert(coalesce(`conv`.`title`,`mt`.`objective`) using utf8mb4) collate utf8mb4_unicode_ci) AS `title`,(convert(coalesce(`conv`.`participants`,(select group_concat(distinct `e`.`entity_name` order by `e`.`entity_name` ASC separator ',') from (`matrix_meeting_attendance` `a` join `cortex_entities` `e` on((`e`.`id` = `a`.`entity_id`))) where (`a`.`meeting_id` = `mt`.`id`))) using utf8mb4) collate utf8mb4_unicode_ci) AS `participants`,coalesce(`conv`.`created`,`mt`.`created_at`) AS `created`,`conv`.`last_activity` AS `last_activity`,coalesce(`conv`.`max_bounces`,0) AS `max_bounces`,coalesce(`conv`.`max_auto_rounds`,0) AS `max_auto_rounds`,coalesce(`conv`.`current_auto_round`,0) AS `current_auto_round`,(convert(`conv`.`conversation_mode` using utf8mb4) collate utf8mb4_unicode_ci) AS `conversation_mode`,`conv`.`cortex_active` AS `cortex_active`,`conv`.`quality_threshold` AS `quality_threshold`,(convert(`conv`.`cortex_system_prompt` using utf8mb4) collate utf8mb4_unicode_ci) AS `cortex_system_prompt`,(convert(`conv`.`cortex_active_level` using utf8mb4) collate utf8mb4_unicode_ci) AS `cortex_active_level`,(convert(`conv`.`cortex_mode` using utf8mb4) collate utf8mb4_unicode_ci) AS `cortex_mode`,(convert(`conv`.`summary` using utf8mb4) collate utf8mb4_unicode_ci) AS `summary`,`conv`.`summary_updated_at` AS `summary_updated_at` from (`matrix_meetings` `mt` join `matrix_meeting_conversations` `conv` on((`conv`.`meeting_id` = `mt`.`id`)))

matrix_terminal_response_messages VIEW

Type: VIEW · Engine: — · Rows: 92 · VIEW

VIEW: correctness check — terminal lifecycle responses that should have closed their parent request.

Domain: Matrix — messaging & lifecycle

#ColumnTypeNullKeyDefaultExtraComment
1 parent_message_id b'bigint' YES b''
2 terminal_response_id b'bigint' YES b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `matrix_terminal_response_messages` AS select `r`.`lifecycle_parent_id` AS `parent_message_id`,max(`r`.`id`) AS `terminal_response_id` from (`matrix_communications` `r` join `matrix_response_codes` `rc` on((`rc`.`response_code` = `r`.`response_code`))) where ((`r`.`message_type` = 'response') and (`rc`.`is_terminal` = 1) and (`r`.`lifecycle_parent_id` is not null)) group by `r`.`lifecycle_parent_id`

Workspace — project registry (MySQL metadata) (2)

workspace_project_members VIEW

Type: VIEW · Engine: — · Rows: 87 · VIEW

VIEW: project membership for workspace registry.

Domain: Entity graph — registry & relationships

#ColumnTypeNullKeyDefaultExtraComment
1 slug b'longtext' YES b''
2 human_user_id b'int' NO b'0' b''
3 role b'varchar(64)' NO b'' b''
4 added_at b'datetime' YES b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b'When this relationship was established'
5 added_by_human_id b'decimal(21,0)' NO b'0' b''
6 membership_status b'longtext' NO b''
7 account_kind b'varchar(8)' NO b'' b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `workspace_project_members` AS select coalesce(nullif(json_unquote(json_extract(`e`.`metadata`,'$.workspace_slug')),''),substr(`e`.`entity_name`,9)) AS `slug`,`u`.`id` AS `human_user_id`,coalesce(nullif(`r`.`role`,''),'viewer') AS `role`,`r`.`created` AS `added_at`,coalesce(cast(json_extract(`r`.`metadata`,'$.added_by_human_id') as unsigned),`u`.`id`) AS `added_by_human_id`,coalesce(nullif(json_unquote(json_extract(`r`.`metadata`,'$.membership_status')),''),'active') AS `membership_status`,(case when (coalesce(`u`.`is_ai`,0) = 1) then 'ai_oauth' else 'human' end) AS `account_kind` from ((`cortex_relationships_unified` `r` join `cortex_entities` `e` on(((`e`.`entity_name` = `r`.`target_id`) and (`e`.`entity_type` = 'project')))) join `users` `u` on((`u`.`username` = `r`.`source_id`))) where ((`r`.`source_type` = 'entity') and (`r`.`target_type` = 'entity') and (`r`.`relationship_type` = 'works_on'))

workspace_projects VIEW

Type: VIEW · Engine: — · Rows: 87 · VIEW

VIEW: MySQL registry mirror of promoted workspace projects (slug, owner). Actual project data lives in Workspaces/ SQLite.

Domain: Entity graph — registry & relationships

#ColumnTypeNullKeyDefaultExtraComment
1 slug b'longtext' YES b''
2 display_name b'longtext' YES b''
3 description b'longtext' YES b''
4 created_by_human_id b'bigint unsigned' YES b''
5 created_at b'datetime' YES b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b'When this entity was first created'
6 updated_at b'datetime' YES b'CURRENT_TIMESTAMP' DEFAULT_GENERATED b'When this entity was first created'
7 status b'longtext' NO b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `workspace_projects` AS select coalesce(nullif(json_unquote(json_extract(`e`.`metadata`,'$.workspace_slug')),''),substr(`e`.`entity_name`,9)) AS `slug`,coalesce(nullif(json_unquote(json_extract(`e`.`metadata`,'$.display_name')),''),substr(`e`.`entity_name`,9)) AS `display_name`,nullif(json_unquote(json_extract(`e`.`metadata`,'$.description')),'') AS `description`,cast(json_extract(`e`.`metadata`,'$.created_by_human_id') as unsigned) AS `created_by_human_id`,`e`.`created` AS `created_at`,`e`.`created` AS `updated_at`,coalesce(nullif(json_unquote(json_extract(`e`.`metadata`,'$.workspace_status')),''),'active') AS `status` from `cortex_entities` `e` where ((`e`.`entity_type` = 'project') and (`e`.`entity_name` like 'project:%'))

Other (9)

v_asset_process_executions VIEW

Type: VIEW · Engine: — · Rows: 211 · VIEW

#ColumnTypeNullKeyDefaultExtraComment
1 execution_id b'bigint unsigned' NO b'0' b''
2 asset_id b'int unsigned' NO b''
3 version_group_id b'varchar(128)' NO b''
4 job_key b'varchar(128)' NO b''
5 window_name b'varchar(64)' NO b'on_demand' b''
6 run_trigger b'varchar(32)' NO b'scheduled' b''
7 params_json b'json' YES b''
8 requested_by b'varchar(128)' NO b'scheduler' b''
9 started_at b'datetime(6)' NO b''
10 ended_at b'datetime(6)' YES b''
11 duration_ms b'int unsigned' YES b''
12 status b'varchar(32)' NO b'running' b''
13 steps_total b'int unsigned' NO b'0' b''
14 steps_completed b'int unsigned' NO b'0' b''
15 step_results_json b'json' YES b''
16 error_class b'varchar(64)' YES b''
17 error_message b'text' YES b''
18 error_step b'varchar(128)' YES b''
19 error_detail b'text' YES b''
20 retry_count b'int unsigned' NO b'0' b''
21 max_retries b'int unsigned' NO b'2' b''
22 failure_message_asset_id b'int unsigned' YES b''
23 run_as_user_id b'int' NO b'0' b''
24 executed_by b'varchar(128)' NO b'' b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `v_asset_process_executions` AS select `asset_process_executions`.`execution_id` AS `execution_id`,`asset_process_executions`.`asset_id` AS `asset_id`,`asset_process_executions`.`version_group_id` AS `version_group_id`,`asset_process_executions`.`job_key` AS `job_key`,`asset_process_executions`.`window_name` AS `window_name`,`asset_process_executions`.`run_trigger` AS `run_trigger`,`asset_process_executions`.`params_json` AS `params_json`,`asset_process_executions`.`requested_by` AS `requested_by`,`asset_process_executions`.`started_at` AS `started_at`,`asset_process_executions`.`ended_at` AS `ended_at`,`asset_process_executions`.`duration_ms` AS `duration_ms`,`asset_process_executions`.`status` AS `status`,`asset_process_executions`.`steps_total` AS `steps_total`,`asset_process_executions`.`steps_completed` AS `steps_completed`,`asset_process_executions`.`step_results_json` AS `step_results_json`,`asset_process_executions`.`error_class` AS `error_class`,`asset_process_executions`.`error_message` AS `error_message`,`asset_process_executions`.`error_step` AS `error_step`,`asset_process_executions`.`error_detail` AS `error_detail`,`asset_process_executions`.`retry_count` AS `retry_count`,`asset_process_executions`.`max_retries` AS `max_retries`,`asset_process_executions`.`failure_message_asset_id` AS `failure_message_asset_id`,`asset_process_executions`.`run_as_user_id` AS `run_as_user_id`,`asset_process_executions`.`executed_by` AS `executed_by` from `asset_process_executions`

vw_logos_asset_relationships_current VIEW

Type: VIEW · Engine: — · Rows: 31 · VIEW

Asset registry view — latest row per asset/link/attribute.

Domain: Asset registry — graph layer (skills, tables, links)

#ColumnTypeNullKeyDefaultExtraComment
1 relationship_id b'bigint unsigned' NO b'0' b''
2 source_asset_id b'int unsigned' NO b''
3 related_asset_id b'int unsigned' NO b''
4 relationship_type b'varchar(64)' NO b''
5 description b'text' YES b''
6 sort_order b'varchar(32)' YES b''
7 record_status b'varchar(32)' NO b'active' b''
8 human_user_id b'int' NO b'0' b''
9 added_by_entity b'varchar(128)' NO b''
10 added_at b'datetime(6)' NO b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `vw_logos_asset_relationships_current` AS select `r`.`relationship_id` AS `relationship_id`,`r`.`source_asset_id` AS `source_asset_id`,`r`.`related_asset_id` AS `related_asset_id`,`r`.`relationship_type` AS `relationship_type`,`r`.`description` AS `description`,`r`.`sort_order` AS `sort_order`,`r`.`record_status` AS `record_status`,`r`.`human_user_id` AS `human_user_id`,`r`.`added_by_entity` AS `added_by_entity`,`r`.`added_at` AS `added_at` from (`logos_asset_relationships` `r` join (select `logos_asset_relationships`.`source_asset_id` AS `source_asset_id`,`logos_asset_relationships`.`related_asset_id` AS `related_asset_id`,`logos_asset_relationships`.`relationship_type` AS `relationship_type`,max(`logos_asset_relationships`.`relationship_id`) AS `max_id` from `logos_asset_relationships` group by `logos_asset_relationships`.`source_asset_id`,`logos_asset_relationships`.`related_asset_id`,`logos_asset_relationships`.`relationship_type`) `latest` on((`r`.`relationship_id` = `latest`.`max_id`))) where (`r`.`record_status` = 'active')

vw_logos_assets_current VIEW

Type: VIEW · Engine: — · Rows: 4,332 · VIEW

VIEW: latest revision per asset_id from append-only logos_assets.

Domain: Asset registry — graph layer (skills, tables, links)

#ColumnTypeNullKeyDefaultExtraComment
1 id b'bigint unsigned' NO b'0' b''
2 asset_id b'int unsigned' NO b''
3 version_group_id b'varchar(128)' YES b'Stable logical id; default vg_<asset_id>'
4 asset_key b'varchar(128)' YES b''
5 asset_type b'varchar(64)' NO b''
6 asset_name b'varchar(255)' NO b''
7 asset_description b'text' YES b''
8 asset_body b'mediumtext' YES b''
9 asset_body_format b'varchar(32)' YES b''
10 body_json b'json' YES b'Four-organ body: payload/configuration/interface/relationships'
11 internal_path b'varchar(512)' YES b'Physical SQL object path for table/view'
12 size_estimate b'bigint' YES b''
13 active_key b'varchar(512)' YES b'Unique key for the one active version row'
14 conversation_id b'varchar(160)' YES b'Provider-qualified conversation provenance'
15 scope b'varchar(128)' NO b''
16 asset_scope b'varchar(32)' YES b'Scope kind: global|user|project|platform|world'
17 project_id b'varchar(128)' YES b'Project slug when asset_scope=project'
18 asset_layer b'varchar(32)' NO b'platform' b''
19 asset_domain b'varchar(64)' NO b'logos.Platform' b'Governance domain: logos.Platform|logos.World.Gallery|logos.World.Application|logos.World.Entity|logos.Applications'
20 parent_asset_id b'int unsigned' YES b''
21 sort_order b'varchar(32)' YES b''
22 display_priority b'int' YES b''
23 human_user_id b'int' NO b'0' b''
24 ai_user_id b'int' NO b'0' b''
25 added_by_entity b'varchar(128)' NO b''
26 entity_id b'varchar(128)' YES b'Author entity (canonical)'
27 creating_entity_id b'varchar(128)' YES b'Entity that created this asset version'
28 owning_entity_id b'varchar(128)' YES b'Entity that owns stewardship of the asset'
29 responsible_entity_id b'varchar(128)' YES b'Entity responsible for maintenance jobs'
30 record_status b'varchar(32)' NO b'active' b''
31 archive_strategy b'json' YES b''
32 tags_json b'json' YES b''
33 asset_maintenance_script b'json' YES b'Maintenance playbook (steps; no top-level when)'
34 asset_schedule b'json' YES b'Array of cron windows {name,when,timezone,enabled,params,pre,post}'
35 added_at b'datetime(6)' NO b''
36 deleted_date b'datetime(6)' YES b'When this version was superseded/deleted'
37 asset_origin b'varchar(6)' NO b'' b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `vw_logos_assets_current` AS select `a`.`id` AS `id`,`a`.`asset_id` AS `asset_id`,`a`.`version_group_id` AS `version_group_id`,`a`.`asset_key` AS `asset_key`,`a`.`asset_type` AS `asset_type`,`a`.`asset_name` AS `asset_name`,`a`.`asset_description` AS `asset_description`,`a`.`asset_body` AS `asset_body`,`a`.`asset_body_format` AS `asset_body_format`,`a`.`body_json` AS `body_json`,`a`.`internal_path` AS `internal_path`,`a`.`size_estimate` AS `size_estimate`,`a`.`active_key` AS `active_key`,`a`.`conversation_id` AS `conversation_id`,`a`.`scope` AS `scope`,`a`.`asset_scope` AS `asset_scope`,`a`.`project_id` AS `project_id`,`a`.`asset_layer` AS `asset_layer`,`a`.`asset_domain` AS `asset_domain`,`a`.`parent_asset_id` AS `parent_asset_id`,`a`.`sort_order` AS `sort_order`,`a`.`display_priority` AS `display_priority`,`a`.`human_user_id` AS `human_user_id`,`a`.`ai_user_id` AS `ai_user_id`,`a`.`added_by_entity` AS `added_by_entity`,`a`.`entity_id` AS `entity_id`,`a`.`creating_entity_id` AS `creating_entity_id`,`a`.`owning_entity_id` AS `owning_entity_id`,`a`.`responsible_entity_id` AS `responsible_entity_id`,`a`.`record_status` AS `record_status`,`a`.`archive_strategy` AS `archive_strategy`,`a`.`tags_json` AS `tags_json`,`a`.`asset_maintenance_script` AS `asset_maintenance_script`,`a`.`asset_schedule` AS `asset_schedule`,`a`.`added_at` AS `added_at`,`a`.`deleted_date` AS `deleted_date`,(case when (`a`.`ai_user_id` > 0) then 'agent' when (`a`.`added_by_entity` like 'LOGOS%') then 'system' when (`a`.`human_user_id` > 0) then 'human' else 'system' end) AS `asset_origin` from (`logos_assets` `a` join (select `logos_assets`.`asset_type` AS `asset_type`,coalesce(nullif(`logos_assets`.`asset_key`,''),concat('__id__:',`logos_assets`.`asset_id`)) AS `nk`,`logos_assets`.`asset_layer` AS `asset_layer`,`logos_assets`.`scope` AS `scope`,`logos_assets`.`human_user_id` AS `human_user_id`,max(`logos_assets`.`id`) AS `max_id` from `logos_assets` group by `logos_assets`.`asset_type`,`nk`,`logos_assets`.`asset_layer`,`logos_assets`.`scope`,`logos_assets`.`human_user_id`) `latest` on((`a`.`id` = `latest`.`max_id`)))

vw_logos_attributes_current VIEW

Type: VIEW · Engine: — · Rows: 36,615 · VIEW

VIEW: latest value per (asset_id, name) from logos_attributes.

Domain: Asset registry — graph layer (skills, tables, links)

#ColumnTypeNullKeyDefaultExtraComment
1 attribute_id b'bigint unsigned' NO b'0' b''
2 asset_id b'int unsigned' NO b''
3 name b'varchar(128)' NO b''
4 value_text b'text' YES b''
5 value_number b'double' YES b''
6 value_json b'json' YES b''
7 human_user_id b'int' NO b'0' b''
8 set_by_entity b'varchar(128)' NO b''
9 set_at b'datetime(6)' NO b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `vw_logos_attributes_current` AS select `att`.`attribute_id` AS `attribute_id`,`att`.`asset_id` AS `asset_id`,`att`.`name` AS `name`,`att`.`value_text` AS `value_text`,`att`.`value_number` AS `value_number`,`att`.`value_json` AS `value_json`,`att`.`human_user_id` AS `human_user_id`,`att`.`set_by_entity` AS `set_by_entity`,`att`.`set_at` AS `set_at` from (`logos_attributes` `att` join (select `logos_attributes`.`asset_id` AS `asset_id`,`logos_attributes`.`name` AS `name`,max(`logos_attributes`.`attribute_id`) AS `max_id` from `logos_attributes` group by `logos_attributes`.`asset_id`,`logos_attributes`.`name`) `latest` on((`att`.`attribute_id` = `latest`.`max_id`)))

vw_logos_platform_assets_current VIEW

Type: VIEW · Engine: — · Rows: 661 · VIEW

Asset registry view — latest row per asset/link/attribute.

Domain: Asset registry — graph layer (skills, tables, links)

#ColumnTypeNullKeyDefaultExtraComment
1 id b'bigint unsigned' NO b'0' b''
2 asset_id b'int unsigned' NO b''
3 version_group_id b'varchar(128)' YES b'Stable logical id; default vg_<asset_id>'
4 asset_key b'varchar(128)' YES b''
5 asset_type b'varchar(64)' NO b''
6 asset_name b'varchar(255)' NO b''
7 asset_description b'text' YES b''
8 asset_body b'mediumtext' YES b''
9 asset_body_format b'varchar(32)' YES b''
10 body_json b'json' YES b'Four-organ body: payload/configuration/interface/relationships'
11 internal_path b'varchar(512)' YES b'Physical SQL object path for table/view'
12 size_estimate b'bigint' YES b''
13 active_key b'varchar(512)' YES b'Unique key for the one active version row'
14 conversation_id b'varchar(160)' YES b'Provider-qualified conversation provenance'
15 scope b'varchar(128)' NO b''
16 asset_scope b'varchar(32)' YES b'Scope kind: global|user|project|platform|world'
17 project_id b'varchar(128)' YES b'Project slug when asset_scope=project'
18 asset_layer b'varchar(32)' NO b'platform' b''
19 asset_domain b'varchar(64)' NO b'logos.Platform' b'Governance domain: logos.Platform|logos.World.Gallery|logos.World.Application|logos.World.Entity|logos.Applications'
20 parent_asset_id b'int unsigned' YES b''
21 sort_order b'varchar(32)' YES b''
22 display_priority b'int' YES b''
23 human_user_id b'int' NO b'0' b''
24 ai_user_id b'int' NO b'0' b''
25 added_by_entity b'varchar(128)' NO b''
26 entity_id b'varchar(128)' YES b'Author entity (canonical)'
27 creating_entity_id b'varchar(128)' YES b'Entity that created this asset version'
28 owning_entity_id b'varchar(128)' YES b'Entity that owns stewardship of the asset'
29 responsible_entity_id b'varchar(128)' YES b'Entity responsible for maintenance jobs'
30 record_status b'varchar(32)' NO b'active' b''
31 archive_strategy b'json' YES b''
32 tags_json b'json' YES b''
33 asset_maintenance_script b'json' YES b'Maintenance playbook (steps; no top-level when)'
34 asset_schedule b'json' YES b'Array of cron windows {name,when,timezone,enabled,params,pre,post}'
35 added_at b'datetime(6)' NO b''
36 deleted_date b'datetime(6)' YES b'When this version was superseded/deleted'
37 asset_origin b'varchar(6)' NO b'' b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `vw_logos_platform_assets_current` AS select `vw_logos_assets_current`.`id` AS `id`,`vw_logos_assets_current`.`asset_id` AS `asset_id`,`vw_logos_assets_current`.`version_group_id` AS `version_group_id`,`vw_logos_assets_current`.`asset_key` AS `asset_key`,`vw_logos_assets_current`.`asset_type` AS `asset_type`,`vw_logos_assets_current`.`asset_name` AS `asset_name`,`vw_logos_assets_current`.`asset_description` AS `asset_description`,`vw_logos_assets_current`.`asset_body` AS `asset_body`,`vw_logos_assets_current`.`asset_body_format` AS `asset_body_format`,`vw_logos_assets_current`.`body_json` AS `body_json`,`vw_logos_assets_current`.`internal_path` AS `internal_path`,`vw_logos_assets_current`.`size_estimate` AS `size_estimate`,`vw_logos_assets_current`.`active_key` AS `active_key`,`vw_logos_assets_current`.`conversation_id` AS `conversation_id`,`vw_logos_assets_current`.`scope` AS `scope`,`vw_logos_assets_current`.`asset_scope` AS `asset_scope`,`vw_logos_assets_current`.`project_id` AS `project_id`,`vw_logos_assets_current`.`asset_layer` AS `asset_layer`,`vw_logos_assets_current`.`asset_domain` AS `asset_domain`,`vw_logos_assets_current`.`parent_asset_id` AS `parent_asset_id`,`vw_logos_assets_current`.`sort_order` AS `sort_order`,`vw_logos_assets_current`.`display_priority` AS `display_priority`,`vw_logos_assets_current`.`human_user_id` AS `human_user_id`,`vw_logos_assets_current`.`ai_user_id` AS `ai_user_id`,`vw_logos_assets_current`.`added_by_entity` AS `added_by_entity`,`vw_logos_assets_current`.`entity_id` AS `entity_id`,`vw_logos_assets_current`.`creating_entity_id` AS `creating_entity_id`,`vw_logos_assets_current`.`owning_entity_id` AS `owning_entity_id`,`vw_logos_assets_current`.`responsible_entity_id` AS `responsible_entity_id`,`vw_logos_assets_current`.`record_status` AS `record_status`,`vw_logos_assets_current`.`archive_strategy` AS `archive_strategy`,`vw_logos_assets_current`.`tags_json` AS `tags_json`,`vw_logos_assets_current`.`asset_maintenance_script` AS `asset_maintenance_script`,`vw_logos_assets_current`.`asset_schedule` AS `asset_schedule`,`vw_logos_assets_current`.`added_at` AS `added_at`,`vw_logos_assets_current`.`deleted_date` AS `deleted_date`,`vw_logos_assets_current`.`asset_origin` AS `asset_origin` from `vw_logos_assets_current` where (`vw_logos_assets_current`.`asset_layer` = 'platform')

vw_logos_skills_details VIEW

Type: VIEW · Engine: — · Rows: — · View 'winbusiness.vw_logos_skills_details' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

VIEW: skill asset body + metadata for skill detail pages.

Domain: Asset registry — graph layer (skills, tables, links)

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `vw_logos_skills_details` AS select `src`.`asset_id` AS `skill_asset_id`,`src`.`asset_key` AS `skill_name`,`src`.`scope` AS `skill_scope`,`src`.`human_user_id` AS `human_user_id`,`l`.`link_id` AS `link_id`,`l`.`link_type` AS `link_type`,`l`.`target_kind` AS `target_kind`,(case when (`l`.`target_kind` = 'asset') then `tgt`.`asset_id` else `l`.`target_id` end) AS `target_asset_id`,(case when (`l`.`target_kind` = 'asset') then `tgt`.`asset_type` else 'thought' end) AS `target_type`,(case when (`l`.`target_kind` = 'asset') then `tgt`.`asset_key` else cast(`l`.`target_id` as char charset utf8mb4) end) AS `target_key`,(case when (`l`.`target_kind` = 'asset') then `tgt`.`asset_name` else NULL end) AS `target_name`,`l`.`metadata_json` AS `metadata_json`,`l`.`notes` AS `link_notes`,`l`.`created_at` AS `linked_at` from ((`vw_logos_links_current` `l` join `vw_logos_assets_current` `src` on(((`src`.`asset_id` = `l`.`source_id`) and (`src`.`asset_type` = 'skill')))) left join `vw_logos_assets_current` `tgt` on(((`l`.`target_kind` = 'asset') and (`tgt`.`asset_id` = `l`.`target_id`)))) where (coalesce(`src`.`status`,'active') <> 'deleted')

vw_logos_skills_list VIEW

Type: VIEW · Engine: — · Rows: — · View 'winbusiness.vw_logos_skills_list' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

VIEW: skill assets joined with current attributes for /reports/workspace/skills/.

Domain: Asset registry — graph layer (skills, tables, links)

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `vw_logos_skills_list` AS select `a`.`asset_id` AS `asset_id`,`a`.`asset_key` AS `skill_name`,`a`.`asset_name` AS `title`,`a`.`asset_description` AS `summary`,`a`.`scope` AS `scope`,`a`.`human_user_id` AS `human_user_id`,`a`.`ai_user_id` AS `ai_user_id`,`a`.`status` AS `status`,`a`.`owner_entity` AS `author_entity`,`a`.`created_at` AS `created_at`,`fam`.`value_text` AS `skill_family`,`tier`.`value_text` AS `cognitive_tier`,`shape`.`value_text` AS `skill_shape`,left(`a`.`asset_body`,240) AS `instructions_preview` from (((`vw_logos_assets_current` `a` left join `vw_logos_attributes_current` `fam` on(((`fam`.`asset_id` = `a`.`asset_id`) and (`fam`.`name` = 'skill_family')))) left join `vw_logos_attributes_current` `tier` on(((`tier`.`asset_id` = `a`.`asset_id`) and (`tier`.`name` = 'cognitive_tier')))) left join `vw_logos_attributes_current` `shape` on(((`shape`.`asset_id` = `a`.`asset_id`) and (`shape`.`name` = 'skill_shape')))) where ((`a`.`asset_type` = 'skill') and (coalesce(`a`.`status`,'active') <> 'deleted'))

vw_logos_world_assets_current VIEW

Type: VIEW · Engine: — · Rows: 3,671 · VIEW

Asset registry view — latest row per asset/link/attribute.

Domain: Asset registry — graph layer (skills, tables, links)

#ColumnTypeNullKeyDefaultExtraComment
1 id b'bigint unsigned' NO b'0' b''
2 asset_id b'int unsigned' NO b''
3 version_group_id b'varchar(128)' YES b'Stable logical id; default vg_<asset_id>'
4 asset_key b'varchar(128)' YES b''
5 asset_type b'varchar(64)' NO b''
6 asset_name b'varchar(255)' NO b''
7 asset_description b'text' YES b''
8 asset_body b'mediumtext' YES b''
9 asset_body_format b'varchar(32)' YES b''
10 body_json b'json' YES b'Four-organ body: payload/configuration/interface/relationships'
11 internal_path b'varchar(512)' YES b'Physical SQL object path for table/view'
12 size_estimate b'bigint' YES b''
13 active_key b'varchar(512)' YES b'Unique key for the one active version row'
14 conversation_id b'varchar(160)' YES b'Provider-qualified conversation provenance'
15 scope b'varchar(128)' NO b''
16 asset_scope b'varchar(32)' YES b'Scope kind: global|user|project|platform|world'
17 project_id b'varchar(128)' YES b'Project slug when asset_scope=project'
18 asset_layer b'varchar(32)' NO b'platform' b''
19 asset_domain b'varchar(64)' NO b'logos.Platform' b'Governance domain: logos.Platform|logos.World.Gallery|logos.World.Application|logos.World.Entity|logos.Applications'
20 parent_asset_id b'int unsigned' YES b''
21 sort_order b'varchar(32)' YES b''
22 display_priority b'int' YES b''
23 human_user_id b'int' NO b'0' b''
24 ai_user_id b'int' NO b'0' b''
25 added_by_entity b'varchar(128)' NO b''
26 entity_id b'varchar(128)' YES b'Author entity (canonical)'
27 creating_entity_id b'varchar(128)' YES b'Entity that created this asset version'
28 owning_entity_id b'varchar(128)' YES b'Entity that owns stewardship of the asset'
29 responsible_entity_id b'varchar(128)' YES b'Entity responsible for maintenance jobs'
30 record_status b'varchar(32)' NO b'active' b''
31 archive_strategy b'json' YES b''
32 tags_json b'json' YES b''
33 asset_maintenance_script b'json' YES b'Maintenance playbook (steps; no top-level when)'
34 asset_schedule b'json' YES b'Array of cron windows {name,when,timezone,enabled,params,pre,post}'
35 added_at b'datetime(6)' NO b''
36 deleted_date b'datetime(6)' YES b'When this version was superseded/deleted'
37 asset_origin b'varchar(6)' NO b'' b''

View definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `vw_logos_world_assets_current` AS select `vw_logos_assets_current`.`id` AS `id`,`vw_logos_assets_current`.`asset_id` AS `asset_id`,`vw_logos_assets_current`.`version_group_id` AS `version_group_id`,`vw_logos_assets_current`.`asset_key` AS `asset_key`,`vw_logos_assets_current`.`asset_type` AS `asset_type`,`vw_logos_assets_current`.`asset_name` AS `asset_name`,`vw_logos_assets_current`.`asset_description` AS `asset_description`,`vw_logos_assets_current`.`asset_body` AS `asset_body`,`vw_logos_assets_current`.`asset_body_format` AS `asset_body_format`,`vw_logos_assets_current`.`body_json` AS `body_json`,`vw_logos_assets_current`.`internal_path` AS `internal_path`,`vw_logos_assets_current`.`size_estimate` AS `size_estimate`,`vw_logos_assets_current`.`active_key` AS `active_key`,`vw_logos_assets_current`.`conversation_id` AS `conversation_id`,`vw_logos_assets_current`.`scope` AS `scope`,`vw_logos_assets_current`.`asset_scope` AS `asset_scope`,`vw_logos_assets_current`.`project_id` AS `project_id`,`vw_logos_assets_current`.`asset_layer` AS `asset_layer`,`vw_logos_assets_current`.`asset_domain` AS `asset_domain`,`vw_logos_assets_current`.`parent_asset_id` AS `parent_asset_id`,`vw_logos_assets_current`.`sort_order` AS `sort_order`,`vw_logos_assets_current`.`display_priority` AS `display_priority`,`vw_logos_assets_current`.`human_user_id` AS `human_user_id`,`vw_logos_assets_current`.`ai_user_id` AS `ai_user_id`,`vw_logos_assets_current`.`added_by_entity` AS `added_by_entity`,`vw_logos_assets_current`.`entity_id` AS `entity_id`,`vw_logos_assets_current`.`creating_entity_id` AS `creating_entity_id`,`vw_logos_assets_current`.`owning_entity_id` AS `owning_entity_id`,`vw_logos_assets_current`.`responsible_entity_id` AS `responsible_entity_id`,`vw_logos_assets_current`.`record_status` AS `record_status`,`vw_logos_assets_current`.`archive_strategy` AS `archive_strategy`,`vw_logos_assets_current`.`tags_json` AS `tags_json`,`vw_logos_assets_current`.`asset_maintenance_script` AS `asset_maintenance_script`,`vw_logos_assets_current`.`asset_schedule` AS `asset_schedule`,`vw_logos_assets_current`.`added_at` AS `added_at`,`vw_logos_assets_current`.`deleted_date` AS `deleted_date`,`vw_logos_assets_current`.`asset_origin` AS `asset_origin` from `vw_logos_assets_current` where (`vw_logos_assets_current`.`asset_layer` = 'world')