Schema Statistics
Total Tables
127 custom tables
Public Schema
111 product tables
System Schema
14 infrastructure tables
Multi-Tenant
42 with tenant_id
Tables by Domain
| Domain | Tables | Description |
|---|---|---|
| System Infrastructure | 10 | Circuit breakers, checkpoints, AI usage tracking |
| Events | 1 | Transactional outbox, audit logs |
| Content Engine | 12 | Content sources, analysis, generation pipeline |
| Distribution | 4 | Voice profiles, templates, distribution metrics |
| Audience Intelligence | 4 | Profiles, events, micro-segments, WTP scoring |
| AI Visibility | 10 | Bot activity tracking, citation discovery |
| Publisher | 5 | Blog network, verticals, IG sources, posts |
| Platform (UCI) | 4 | Creator profiles, licenses, verification |
| Agency | 4 | Clients, projects, retainers |
| Store | 4 | Shopify products, orders, sync |
Schema Security
| Schema | Access Level | RLS |
|---|---|---|
public | authenticated, anon, service_role | Required on every table |
system | service_role ONLY | None (no user access) |
events | service_role ONLY | None (append-only) |
Naming Conventions
| Prefix | Domain | Example |
|---|---|---|
aiv_ | AI Visibility | aiv_bot_activity, aiv_citations |
publisher_ | Publisher | publisher_posts, publisher_verticals |
creator_ | Platform | creator_profiles, creator_licenses |
agency_ | Agency | agency_clients, agency_projects |
shopify_ | Store | shopify_products, shopify_orders |
jarvis_ | Jarvis | jarvis_conversations, jarvis_messages |
system. | Infrastructure | system.circuit_breakers, system.ai_usage |
Auto-generated from
agents/schema/SCHEMA.md. Run pnpm docs:sync-schema to update.