Database Schema

Current version: v27

Tables

Column	Type	Indexed	Optional
`message_id`	number
`conversation_id`	string	✓
`role`	string	✓
`content`	string
`model`	string		✓
`image_model`	string		✓
`files`	string		✓
`file_ids`	string		✓
`created_at`	number	✓
`updated_at`	number
`vector`	string		✓
`embedding_model`	string		✓
`chunks`	string		✓
`usage`	string		✓
`sources`	string		✓
`response_duration`	number		✓
`was_stopped`	boolean		✓
`error`	string		✓
`thought_process`	string		✓
`thinking`	string		✓
`parent_message_id`	string		✓
`feedback`	string		✓
`tool_call_events`	string		✓

Column	Type	Indexed	Optional
`conversation_id`	string	✓
`title`	string
`project_id`	string	✓	✓
`created_at`	number
`updated_at`	number
`is_deleted`	boolean	✓

Column	Type	Indexed
`project_id`	string	✓
`name`	string
`created_at`	number
`updated_at`	number
`is_deleted`	boolean	✓

Column	Type	Indexed	Optional
`wallet_address`	string	✓
`models`	string		✓

Column	Type	Indexed	Optional
`wallet_address`	string	✓
`nickname`	string		✓
`occupation`	string		✓
`description`	string		✓
`models`	string		✓
`personality`	string		✓
`created_at`	number
`updated_at`	number

Column	Type	Indexed	Optional
`content`	string
`scope`	string	✓
`folder_id`	string	✓	✓
`created_at`	number	✓
`updated_at`	number	✓
`is_deleted`	boolean	✓
`user_id`	string	✓	✓
`embedding`	string		✓

Column	Type	Indexed	Optional
`name`	string
`scope`	string
`created_at`	number	✓
`updated_at`	number
`is_deleted`	boolean	✓
`is_system`	boolean		✓
`context`	string		✓

Column	Type	Indexed
`conversation_id`	string	✓
`summary`	string
`summarized_up_to`	string
`token_count`	number
`created_at`	number
`updated_at`	number

Column	Type	Indexed	Optional
`media_id`	string	✓
`wallet_address`	string	✓
`message_id`	string	✓	✓
`conversation_id`	string	✓	✓
`name`	string
`mime_type`	string	✓
`media_type`	string	✓
`size`	number
`role`	string	✓
`model`	string	✓	✓
`source_url`	string		✓
`dimensions`	string		✓
`duration`	number		✓
`metadata`	string		✓
`created_at`	number	✓
`updated_at`	number
`is_deleted`	boolean	✓

Column	Type	Indexed
`conversation_id`	string	✓
`path`	string
`content`	string
`created_at`	number	✓
`updated_at`	number

Column	Type	Indexed	Optional
`name`	string
`display_name`	string
`description`	string
`parameters`	string
`html`	string
`conversation_id`	string		✓
`created_at`	number	✓
`updated_at`	number
`is_deleted`	boolean	✓

Version	Changes
v27	Added `tool_call_events` to `history`
v26	Added `app_files` table
v25	Added `saved_tools` table
v24	Added `context` to `vault_folders`
v23	Added `conversation_summaries` table
v22	Added `is_system` to `vault_folders`
v21	Added `embedding` to `memory_vault`
v20	`CREATE INDEX IF NOT EXISTS memory_vault_updated_at ON memory_vault (updated_at);`
v19	Added `user_id` to `memory_vault`
v18	Added `vault_folders` table; Added `folder_id` to `memory_vault`
v17	Added `image_model` to `history`
v16	Added `scope` to `memory_vault`; `UPDATE memory_vault SET scope = 'private' WHERE scope IS NULL OR scope = '';`
v15	`DROP TABLE IF EXISTS memories;`; Added `memory_vault` table
v14	Added `feedback` to `history`
v13	Added `parent_message_id` to `history`
v12	Added `chunks` to `history`
v11	Added `media` table; Added `file_ids` to `history`
v10	Added `projects` table; Added `project_id` to `conversations`
v9	Added `thinking` to `history`
v8	`DELETE FROM history;`; `DELETE FROM conversations;`; `DELETE FROM memories;`
v7	Added `userPreferences` table
v6	Added `thought_process` to `history`
v5	Added `error` to `history`
v4	Added `modelPreferences` table
v3	Added `was_stopped` to `history`
v2	Baseline — `history`, `conversations`, and `memories` tables