Variable: sessions
Makaio Framework / services-core/session/storage/schema / sessions
Variable: sessions
Section titled “Variable: sessions”
constsessions:SQLiteTableWithColumns<{columns: {adapterId: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:"adapter_id";notNull:false;tableName:"sessions"; }, { }, {length:number|undefined; }>;adapterName: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:"adapter_name";notNull:false;tableName:"sessions"; }, { }, {length:number|undefined; }>;adapterSessionId: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:"adapter_session_id";notNull:false;tableName:"sessions"; }, { }, {length:number|undefined; }>;approvalPolicyOverride:SQLiteColumn<{baseColumn:never;columnType:"SQLiteText";data:"always-ask"|"reject"|"full-access";dataType:"string";driverParam:string;enumValues: ["reject","always-ask","full-access"];generated:undefined;hasDefault:false;hasRuntimeDefault:false;identity:undefined;isAutoincrement:false;isPrimaryKey:false;name:"approval_policy_override";notNull:false;tableName:"sessions"; }, { }, {length:number|undefined; }>;branchKind:SQLiteColumn<{baseColumn:never;columnType:"SQLiteText";data:"fork"|"branch"|"aside"|"subagent"|"compress"|"rewrite"|"coordinator";dataType:"string";driverParam:string;enumValues: ["fork","branch","subagent","compress","rewrite","coordinator","aside"];generated:undefined;hasDefault:false;hasRuntimeDefault:false;identity:undefined;isAutoincrement:false;isPrimaryKey:false;name:"branch_kind";notNull:false;tableName:"sessions"; }, { }, {length:number|undefined; }>;clientAccountId: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:"client_account_id";notNull:false;tableName:"sessions"; }, { }, {length:number|undefined; }>;clientId: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:"client_id";notNull:false;tableName:"sessions"; }, { }, {length:number|undefined; }>;createdAt: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:"created_at";notNull:true;tableName:"sessions"; }, { }, { }>;executionTargetId: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:"execution_target_id";notNull:false;tableName:"sessions"; }, { }, {length:number|undefined; }>;forkPointMessageId: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:"fork_point_message_id";notNull:false;tableName:"sessions"; }, { }, {length:number|undefined; }>;forkTransforms: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:"fork_transforms";notNull:false;tableName:"sessions"; }, { }, {length:number|undefined; }>;isImported:SQLiteColumn<{baseColumn:never;columnType:"SQLiteBoolean";data:boolean;dataType:"boolean";driverParam:number;enumValues:undefined;generated:undefined;hasDefault:true;hasRuntimeDefault:false;identity:undefined;isAutoincrement:false;isPrimaryKey:false;name:"is_imported";notNull:false;tableName:"sessions"; }, { }, { }>;isOrchestrated:SQLiteColumn<{baseColumn:never;columnType:"SQLiteBoolean";data:boolean;dataType:"boolean";driverParam:number;enumValues:undefined;generated:undefined;hasDefault:true;hasRuntimeDefault:false;identity:undefined;isAutoincrement:false;isPrimaryKey:false;name:"is_orchestrated";notNull:false;tableName:"sessions"; }, { }, { }>;lastActivityAt: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:"last_activity_at";notNull:true;tableName:"sessions"; }, { }, { }>;lastClientIdentityObservation: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:"last_client_identity_observation";notNull:false;tableName:"sessions"; }, { }, {length:number|undefined; }>;leadAgentId: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:"lead_agent_id";notNull:false;tableName:"sessions"; }, { }, {length:number|undefined; }>;parentSessionId: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:"parent_session_id";notNull:false;tableName:"sessions"; }, { }, {length:number|undefined; }>;rootSessionId: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:"root_session_id";notNull:false;tableName:"sessions"; }, { }, {length:number|undefined; }>;sessionId: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:true;name:"session_id";notNull:true;tableName:"sessions"; }, { }, {length:number|undefined; }>;spawningToolCallId: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:"spawning_tool_call_id";notNull:false;tableName:"sessions"; }, { }, {length:number|undefined; }>;status:SQLiteColumn<{baseColumn:never;columnType:"SQLiteText";data:"active"|"closed"|"archived"|"discovered";dataType:"string";driverParam:string;enumValues: ["active","closed","archived","discovered"];generated:undefined;hasDefault:false;hasRuntimeDefault:false;identity:undefined;isAutoincrement:false;isPrimaryKey:false;name:"status";notNull:true;tableName:"sessions"; }, { }, {length:number|undefined; }>;summary: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:"summary";notNull:false;tableName:"sessions"; }, { }, {length:number|undefined; }>;summaryUpdatedAt: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:"summary_updated_at";notNull:false;tableName:"sessions"; }, { }, { }>;targetWorkingDirectory: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:"target_working_directory";notNull:false;tableName:"sessions"; }, { }, {length:number|undefined; }>;title: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:"title";notNull:false;tableName:"sessions"; }, { }, {length:number|undefined; }>; };dialect:"sqlite";name:"sessions";schema:undefined; }>
Defined in: ../../../packages/services/core/src/session/storage/schema.ts:12
Sessions table schema.
Stores makaio orchestration sessions. Each session represents a logical conversation context that may span multiple agents and adapters.
SEAM: The sessionId column is the primary key that extensions can
reference for their own decorator tables (e.g., extension_chat_messages).