Database Patterns

Padrões de Banco de Dados

Arquivo Único de Schema

Tudo fica em shared/schema.ts (~3900 linhas). Este arquivo define:

• Schemas PostgreSQL (namespaces)
• Tabelas com colunas
• Relations (Drizzle)
• Zod schemas para validação
• Types TypeScript exportados

Multi-Schema PostgreSQL

O banco usa 12+ schemas para organizar tabelas por domínio:

import { pgSchema } from "drizzle-orm/pg-core";

export const coreSchema = pgSchema("core");
export const campaignSchema = pgSchema("campaign");
export const creatorSchema = pgSchema("creator");
export const brandSchema = pgSchema("brand");
export const contentSchema = pgSchema("content");
export const messagingSchema = pgSchema("messaging");
export const gamificationSchema = pgSchema("gamification");
export const analyticsSchema = pgSchema("analytics");
export const billingSchema = pgSchema("billing");
export const academySchema = pgSchema("academy");
export const socialSchema = pgSchema("social");
export const systemSchema = pgSchema("system");