🗄️ Stack + Modelagem do Banco

🗺️ Diagrama de Entidades

import { defineSchema, defineTable } from "convex/server";
import { v } from "convex/values";

export default defineSchema({
  organizations: defineTable({
    name: v.string(),
    plan: v.union(v.literal("free"), v.literal("pro"), v.literal("enterprise")),
    createdAt: v.number(),
  }),

  users: defineTable({
    orgId: v.id("organizations"),
    clerkId: v.string(),
    email: v.string(),
    name: v.string(),
    role: v.union(v.literal("owner"), v.literal("admin"), v.literal("agent")),
  }).index("by_org", ["orgId"]).index("by_clerk", ["clerkId"]),

  contacts: defineTable({
    orgId: v.id("organizations"),
    phone: v.string(),
    name: v.optional(v.string()),
    email: v.optional(v.string()),
    tags: v.array(v.string()),
    lastSeenAt: v.number(),
  }).index("by_org_phone", ["orgId", "phone"])
    .index("by_org_lastSeen", ["orgId", "lastSeenAt"]),

  conversations: defineTable({
    orgId: v.id("organizations"),
    contactId: v.id("contacts"),
    status: v.union(v.literal("open"), v.literal("snoozed"), v.literal("closed")),
    assignedTo: v.optional(v.id("users")),
    aiEnabled: v.boolean(),
    lastMessageAt: v.number(),
  }).index("by_org_status", ["orgId", "status"])
    .index("by_contact", ["contactId"]),

  messages: defineTable({
    orgId: v.id("organizations"),
    conversationId: v.id("conversations"),
    direction: v.union(v.literal("inbound"), v.literal("outbound")),
    sender: v.union(v.literal("contact"), v.literal("agent"), v.literal("ai")),
    body: v.string(),
    mediaUrl: v.optional(v.string()),
    mediaType: v.optional(v.string()),
    sentAt: v.number(),
  }).index("by_conversation", ["conversationId", "sentAt"]),

  deals: defineTable({
    orgId: v.id("organizations"),
    contactId: v.id("contacts"),
    title: v.string(),
    stage: v.union(v.literal("qualified"), v.literal("proposal"),
                   v.literal("won"), v.literal("lost")),
    value: v.number(),
    ownerId: v.id("users"),
  }).index("by_org_stage", ["orgId", "stage"])
    .index("by_owner", ["ownerId"]),
});

📊 Índices que importam no InboxAI

🔄 Fluxo Expand-then-Contract

import { internalMutation } from "./_generated/server";

const NOMES_BR = ["Ana Silva","João Santos","Maria Oliveira","Carlos Pereira",
                  "Beatriz Costa","Rafael Souza","Juliana Lima","Pedro Rocha"];
const TAGS = ["lead-quente","cliente","follow-up","perdido","vip"];
const FRASES = [
  "Oi, tenho interesse no plano Pro.",
  "Bom dia, qual o valor?",
  "Você consegue passar a apresentação?",
  "Vou falar com meu sócio e retorno.",
  "Fechado, manda o boleto."
];

const rand = <T>(arr: T[]) => arr[Math.floor(Math.random() * arr.length)];
const phone = () => "55119" + Math.floor(10000000 + Math.random() * 89999999);

export const seed = internalMutation({
  args: {},
  handler: async (ctx) => {
    const orgId = await ctx.db.insert("organizations", {
      name: "Clínica Demo", plan: "pro", createdAt: Date.now(),
    });

    const ownerId = await ctx.db.insert("users", {
      orgId, clerkId: "demo_owner", email: "demo@inbox.ai",
      name: "Demo Owner", role: "owner",
    });

    const contactIds = [];
    for (let i = 0; i < 50; i++) {
      const id = await ctx.db.insert("contacts", {
        orgId, phone: phone(), name: rand(NOMES_BR),
        tags: [rand(TAGS)], lastSeenAt: Date.now() - i * 3600_000,
      });
      contactIds.push(id);
    }

    for (const contactId of contactIds.slice(0, 40)) {
      const convId = await ctx.db.insert("conversations", {
        orgId, contactId, status: "open", aiEnabled: true,
        lastMessageAt: Date.now(),
      });
      for (let j = 0; j < 5; j++) {
        await ctx.db.insert("messages", {
          orgId, conversationId: convId,
          direction: j % 2 === 0 ? "inbound" : "outbound",
          sender: j % 2 === 0 ? "contact" : "ai",
          body: rand(FRASES), sentAt: Date.now() - (5 - j) * 60_000,
        });
      }
    }

    for (let i = 0; i < 10; i++) {
      await ctx.db.insert("deals", {
        orgId, contactId: rand(contactIds), title: "Deal #" + (i + 1),
        stage: rand(["qualified","proposal","won","lost"] as const),
        value: 1000 + Math.random() * 9000, ownerId,
      });
    }

    return { contacts: 50, conversations: 40, deals: 10 };
  },
});

🚀 Rodar o seed

# dev local
npx convex run seed:seed

# limpar e re-seedar
npx convex run reset:wipe && npx convex run seed:seed

📋 Checklist antes de cada deploy de migration