Base-99 Core AI OS™ · Persistent Truth Layer · Database Schema
Core Tables
Nothing executes without an Intent record. Every user input is classified and stored here before routing.
| Field | Type | Description |
|---|---|---|
| id | uuid | PK — auto |
| user_id | string | FK → User |
| org_key | string | ttucker | pickitup |
| raw_input | text | Original user input |
| classified_intent | string | CRM | FINANCIAL | LEGAL... |
| confidence | float | 0.0 – 1.0 |
| source | enum | command_shell | api | agent |
| resolved_module | string | Module ID assigned |
| status | enum | received → classified → executed |
| metadata | jsonb | Classifier context |
| created_at | timestamp | Auto |
If it is not in the INTENTS table, it does not exist in the system.
Every system action must create an execution record and an audit log entry.
Modules DO NOT store memory. Only the database stores memory.
Workspace only reads from executions, intents, and modules — never writes its own state.
[LSM] System initializing...
Auto-fallback in 10s if needed