Overview of II-Agent Database Schema
mainThe II-Agent database is built on PostgreSQL 15+ and consists of approximately 30 models and 38 tables. The schema is organized into several functional domains including Users & Auth, Sessions, Tasks & Agent Runs, Chat, Files, Billing, Projects, Content, and Settings.
Key architectural patterns include:
- Soft Deletes: Used in the
sessionstable viais_deleted. - Optimistic Locking: Implemented via
versioncolumns in tables likesessions,run_tasks,agent_run_messages,chat_provider_vector_stores, andcredit_balances. - Self-Referencing Trees: Used for message hierarchies (
chat_messages), versioning (slide_versions,storybooks), and summaries (chat_summaries). - Event Logging: The
application_eventstable is designed without foreign keys to ensure event logs do not block the deletion of parent entities.