Migrations

As migrations ficam em api/src/db/migrations/ numeradas sequencialmente.

Estrutura

001_extensions.sql      — uuid-ossp, vector, pg_trgm
002_enums.sql           — todos os tipos ENUM
003_plans_orgs.sql      — organizations, plans, subscriptions
004_workspaces.sql      — workspaces, users, workspace_members, teams
005_channels.sql        — channels, tags, custom_fields, bot_fields
006_contacts.sql        — contacts, contact_tags, contact_field_values
007_conversations.sql   — conversations, messages (particionada)
008_flows.sql           — flows, flow_versions, flow_executions
009_automations.sql     — automations, automation_executions
010_campaigns.sql       — campaigns, sequences, broadcasts
011_ai.sql              — ai_assistants, ai_sessions, knowledge_bases, knowledge_chunks
012_webhooks_api.sql    — outbound_webhooks, webhook_events, api_keys
013_lgpd.sql            — consent_records, data_subject_requests
014_misc.sql            — audit_logs, quick_replies, message_templates, csat_surveys
015_rls.sql             — todas as políticas RLS
016_indexes.sql         — índices de performance

Rodar migrations

docker compose exec funil-api node dist/db/migrate.js