Variable: messageRouting

Makaio Framework / services-core / messageRouting

Variable: messageRouting

const messageRouting: SQLiteTableWithColumns<{ columns: { agentId: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "agent_id"; notNull: true; tableName: "message_routing"; }, { }, { length: number | undefined; }>; error: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "error"; notNull: false; tableName: "message_routing"; }, { }, { length: number | undefined; }>; messageId: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "message_id"; notNull: true; tableName: "message_routing"; }, { }, { length: number | undefined; }>; status: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: "completed" | "acknowledged" | "sent"; dataType: "string"; driverParam: string; enumValues: ["sent", "acknowledged", "completed"]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "status"; notNull: true; tableName: "message_routing"; }, { }, { length: number | undefined; }>; timestamp: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteInteger"; data: number; dataType: "number"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "timestamp"; notNull: true; tableName: "message_routing"; }, { }, { }>; }; dialect: "sqlite"; name: "message_routing"; schema: undefined; }>

Defined in: ../../../packages/services/core/src/session/message-routing/schema.ts:17

Message routing table schema.

Tracks delivery status of messages to agents in multi-agent sessions. Each row represents a message-agent pair with status progression.

Status progression: sent -> acknowledged -> completed

Design rationale:

Composite primary key allows multiple status entries per message-agent pair
Enables tracking of delivery lifecycle for each target agent
Supports querying “which agents have completed for this message?”