Consult AS Technology
0546f35d2a
- api-gateway: servicio Monday (retry 429/complejidad, paginacion cursor, column IDs por titulo), endpoints unidades/cotizaciones/clientes/planes, webhook con handshake challenge, Prisma SQLite dev, 55 tests - cotizador: inventario desde /api/unidades con fallback a seed - alta-clientes: POST /api/clientes + upload multipart de documentos - cobranza: persistencia via API con respaldo offline en localStorage - .env.example con board IDs del workspace Frasa-CAS
122 lines
3.6 KiB
SQL
122 lines
3.6 KiB
SQL
-- CreateTable
|
|
CREATE TABLE "Cotizacion" (
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
|
"unidadCodigo" TEXT NOT NULL,
|
|
"clienteNombre" TEXT NOT NULL,
|
|
"clienteEmail" TEXT,
|
|
"clienteTelefono" TEXT,
|
|
"tipoPropuesta" TEXT NOT NULL,
|
|
"acabados" BOOLEAN NOT NULL,
|
|
"apartado" REAL NOT NULL,
|
|
"descuento" REAL NOT NULL,
|
|
"precioLista" REAL NOT NULL,
|
|
"precioFinal" REAL NOT NULL,
|
|
"enganche" REAL NOT NULL,
|
|
"numMensualidades" INTEGER NOT NULL,
|
|
"mensualidad" REAL,
|
|
"pagoFinal" REAL NOT NULL,
|
|
"mondayItemId" TEXT,
|
|
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "Cliente" (
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
|
"nombreCompleto" TEXT NOT NULL,
|
|
"curp" TEXT NOT NULL,
|
|
"rfc" TEXT NOT NULL,
|
|
"email" TEXT,
|
|
"celular" TEXT,
|
|
"proyecto" TEXT NOT NULL,
|
|
"unidadCodigo" TEXT,
|
|
"payloadJson" TEXT NOT NULL,
|
|
"firmaPng" TEXT,
|
|
"mondayContactoId" TEXT,
|
|
"mondayApartadoId" TEXT,
|
|
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "Documento" (
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
|
"clienteId" TEXT NOT NULL,
|
|
"tipo" TEXT NOT NULL,
|
|
"nombreArchivo" TEXT NOT NULL,
|
|
"ruta" TEXT NOT NULL,
|
|
"mime" TEXT NOT NULL,
|
|
"tamano" INTEGER NOT NULL,
|
|
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
CONSTRAINT "Documento_clienteId_fkey" FOREIGN KEY ("clienteId") REFERENCES "Cliente" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "PlanPago" (
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
|
"ventaRef" TEXT,
|
|
"clienteNombre" TEXT NOT NULL,
|
|
"clienteTelefono" TEXT,
|
|
"unidadCodigo" TEXT NOT NULL,
|
|
"proyecto" TEXT NOT NULL,
|
|
"fechaInicio" DATETIME NOT NULL,
|
|
"engancheTotal" REAL NOT NULL,
|
|
"numPagos" INTEGER NOT NULL,
|
|
"mensualidad" REAL NOT NULL,
|
|
"tasaMoraMensual" REAL NOT NULL DEFAULT 0,
|
|
"status" TEXT NOT NULL DEFAULT 'ACTIVO',
|
|
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "Pago" (
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
|
"planId" TEXT NOT NULL,
|
|
"numPago" INTEGER NOT NULL,
|
|
"fechaVencimiento" DATETIME NOT NULL,
|
|
"monto" REAL NOT NULL,
|
|
"montoPagado" REAL NOT NULL DEFAULT 0,
|
|
CONSTRAINT "Pago_planId_fkey" FOREIGN KEY ("planId") REFERENCES "PlanPago" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "AplicacionPago" (
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
|
"pagoId" TEXT NOT NULL,
|
|
"fechaPago" DATETIME NOT NULL,
|
|
"monto" REAL NOT NULL,
|
|
"referencia" TEXT NOT NULL,
|
|
CONSTRAINT "AplicacionPago_pagoId_fkey" FOREIGN KEY ("pagoId") REFERENCES "Pago" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "NotaPlan" (
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
|
"planId" TEXT NOT NULL,
|
|
"fecha" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"texto" TEXT NOT NULL,
|
|
CONSTRAINT "NotaPlan_planId_fkey" FOREIGN KEY ("planId") REFERENCES "PlanPago" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Cotizacion_unidadCodigo_idx" ON "Cotizacion"("unidadCodigo");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Cliente_curp_idx" ON "Cliente"("curp");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Documento_clienteId_idx" ON "Documento"("clienteId");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "PlanPago_unidadCodigo_idx" ON "PlanPago"("unidadCodigo");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Pago_planId_idx" ON "Pago"("planId");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Pago_fechaVencimiento_idx" ON "Pago"("fechaVencimiento");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "AplicacionPago_pagoId_idx" ON "AplicacionPago"("pagoId");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "NotaPlan_planId_idx" ON "NotaPlan"("planId");
|