🗂️ Esquema de Base de Datos

model Company {
  id        Int            @id @default(autoincrement())
  publicId  String         @unique @default(uuid())
  createdAt DateTime       @default(now())
  updatedAt DateTime       @updatedAt
  name      String         @unique
  logo      String
  credits   Int            @default(0) // deprecado
  brands    Brand[]
  users     User[]
  folders   ProjectFolder[]
  models    Model[]
}

model Brand {
  id         Int           @id @default(autoincrement())
  publicId   String        @unique @default(uuid())
  createdAt  DateTime      @default(now())
  updatedAt  DateTime      @updatedAt
  name       String
  logo       String
  companyId  Int
  company    Company       @relation(fields: [companyId], references: [id])
  garments   Garment[]
  projects   Project[]
  users      User[]        // N:M con User
  models     Model[]       // N:M con Model
  settings   BrandSettings @relation(fields: [settingsId], references: [id])
  settingsId Int           @unique
}
 
// Índice único: (name, companyId)
 
model BrandSettings {
  id               Int            @id @default(autoincrement())
  publicId         String         @unique @default(uuid())
  brand            Brand?
  outputPoses      PoseSetting[]  @relation("OutputPoses")
  inputPoses       PoseSetting[]  @relation("InputPoses")
  imageValidations Json?
  aliases          String[]
  createdAt        DateTime       @default(now())
  updatedAt        DateTime       @updatedAt
}
 
model PoseSetting {
  id                    Int            @id @default(autoincrement())
  publicId              String         @unique @default(uuid())
  pose                  Pose?
  garmentView           GarmentView?
  suffix                String?
  suffixRule            SuffixRule?
  projectType           ProjectType
  inputBrandSettingsId  Int?
  outputBrandSettingsId Int?
  inputBrandSettings    BrandSettings? @relation("InputPoses", fields: [inputBrandSettingsId], references: [id])
  outputBrandSettings   BrandSettings? @relation("OutputPoses", fields: [outputBrandSettingsId], references: [id])
  createdAt             DateTime       @default(now())
  updatedAt             DateTime       @updatedAt
}
 
enum SuffixRule {
  HIGHEST  // Toma el sufijo más alto disponible
  LOWEST   // Toma el sufijo más bajo disponible
}

{
  "aliases": ["lacroix", "c. lacroix"],
  "imageValidations": {
    "minWidth": 800,
    "minHeight": 800,
    "allowedExtensions": ["jpg", "jpeg", "png"]
  },
  "inputPoses": [
    { "garmentView": "BACK", "suffix": "_back", "projectType": "BATCH" },
    { "garmentView": "ZOOM", "suffix": "_zoom", "projectType": "BATCH" }
  ],
  "outputPoses": [
    { "pose": "AMERICAN_FRONT", "suffix": "001", "projectType": "BATCH" },
    { "pose": "FULLBODY_FRONT", "suffix": "002", "projectType": "BATCH" },
    { "pose": "AMERICAN_FRONT", "suffix": "001", "projectType": "PRODUCT" }
  ]
}

model User {
  id                    Int                      @id @default(autoincrement())
  publicId              String                   @unique @default(uuid())
  createdAt             DateTime                 @default(now())
  updatedAt             DateTime                 @updatedAt
  nickname              String                   @default("")
  email                 String                   @unique
  phoneNumber           String?
  notificationsEnabled  NotificationTemplateType[]
  role                  UserRole                 @default(COMPANY_ADMIN)
  companyId             Int?
  sessionId             String                   @unique
  transactions          CreditTransaction[]
  company               Company?                @relation(fields: [companyId], references: [id])
  approvals             GeneratedImage[]
  apiKey                ApiKey?
  brands                Brand[]
  permissions           RolePermission[]
  allowedModelSexes     Gender[]
  job                   Job[]            @relation("UserJob")
  chatMessages          ChatMessage[]
}
 
enum UserRole {
  ADMIN
  COMPANY_ADMIN
  BRAND_ADMIN
}
 
enum RolePermission { // Permisos del usuario
  PROJECT_CREATOR     // Puede crear proyectos
  REVIEWER            // Puede revisar imágenes
  DOWNLOADER          // Puede descargar imágenes
  PERMISSION_ADMIN    // Puede manejar permisos de otros usuarios
  VIEWER              // Puede ver el detalle de las imágenes
}

model ApiKey {
  id         Int       @id @default(autoincrement())
  publicId   String    @unique
  name       String
  prefix     String    @unique   // Primeros caracteres visibles para identificación
  hash       String    // Hash de la clave (nunca se almacena en claro)
  ownerId    Int       @unique
  owner      User      @relation(fields: [ownerId], references: [id])
  isDisabled Boolean   @default(false)
  lastUsedAt DateTime?
  createdAt  DateTime  @default(now())
  updatedAt  DateTime  @updatedAt
}

model Garment {
  id        Int              @id @default(autoincrement())
  publicId  String           @unique @default(uuid())
  name      String
  createdAt DateTime         @default(now())
  updatedAt DateTime         @updatedAt
  season    String?
  type      GarmentType
  brandId   Int?
  brand     Brand?           @relation(fields: [brandId], references: [id])
  images    GarmentImage[]
  projects  ProjectImage[]   // N:M: prendas usadas en una entrada de proyecto
  result    GeneratedImage[] // N:M: imágenes generadas que incluyen esta prenda
}
 
enum GarmentType {
  FOOTWEAR    // Zapatos, botas, sandalias
  UPPER_TRUNK // Camisetas, blusas, chaquetas
  LOWER_TRUNK // Pantalones, faldas, shorts
  FULL_BODY   // Conjuntos completos
  FACESWAP    // Imágenes para proyectos de tipo faceswap
  BYPASS      // Imagen en proyecto FACESWAP que no necesita generación
  PRODUCT     // Imágenes de producto para proyectos PRODUCT
}

model GarmentImage {
  id        Int          @id @default(autoincrement())
  publicId  String       @unique @default(uuid())
  createdAt DateTime     @default(now())
  updatedAt DateTime     @updatedAt
  name      String
  url       String
  garmentId Int
  garment   Garment      @relation(fields: [garmentId], references: [id])
  viewType  GarmentView?
}
 
enum GarmentView {
  FRONT
  BACK
  ZOOM
  OTHER
}

model ProjectFolder {
  id           Int           @id @default(autoincrement())
  publicId     String        @unique @default(uuid())
  createdAt    DateTime      @default(now())
  updatedAt    DateTime      @updatedAt
  name         String
  projectType  ProjectType
  season       String?
  description  String?
  adminStatus  AdminStatus   @default(CREATING)
  clientStatus ClientStatus  @default(CREATING)
  companyId    Int
  company      Company       @relation(fields: [companyId], references: [id])
  projects     Project[]
  notifications Notification[]
}
 
// Índice único: (companyId, name)
 
enum ProjectType {
  BATCH
  FACESWAP
  PRODUCT
}
 
enum AdminStatus {
  CREATING
  IN_PROGRESS
  WAITING_APPROVAL
  REJECTED
  COMPLETED
  CANCELLED
  UNPUBLISHED
}
 
enum ClientStatus {
  CREATING
  IN_PROGRESS
  PENDING_APPROVAL
  IN_REVIEW
  PENDING_DOWNLOAD
  COMPLETED
  CANCELLED
}

model Project {
  id             Int              @id @default(autoincrement())
  publicId       String           @unique @default(uuid())
  createdAt      DateTime         @default(now())
  updatedAt      DateTime         @updatedAt
  adminStatus    AdminStatus      @default(CREATING)
  clientStatus   ClientStatus     @default(CREATING)
  statusRank     Int              @default(99)  // Deprecado
  statusRankAdmin Int             @default(99)  // Deprecado
  brandId        Int
  options        Json
  folderId       Int
  brand          Brand            @relation(fields: [brandId], references: [id])
  folder         ProjectFolder    @relation(fields: [folderId], references: [id])
  images         GeneratedImage[]
  uploads        ProjectImage[]
  models         Model[]
  chats          Chat[]
}
 
// Índice único: (options, brandId, folderId)

type ProjectOptions =
  | FaceswapProjectOptions
  | BatchProjectOptions
  | ProductProjectOptions;

enum ProjectGender {
  MALE    // Hombre
  FEMALE  // Mujer
  UNISEX  // Unisex
  OTHER   // Otro
}

enum Pose {
  AMERICAN_FRONT  // Plano americano, frente
  AMERICAN_BACK   // Plano americano, espalda
  AMERICAN_SIDE   // Plano americano, lateral
  FULLBODY_FRONT  // Cuerpo completo, frente
  FULLBODY_BACK   // Cuerpo completo, espalda
  FULLBODY_SIDE   // Cuerpo completo, lateral
  ZOOM            // Zoom / detalle
}
 
enum MediaType {
  IMAGE  // Imagen estática
  VIDEO  // Video
}

model ProjectImage {
  id           Int          @id @default(autoincrement())
  publicId     String       @unique @default(uuid())
  createdAt    DateTime     @default(now())
  updatedAt    DateTime     @updatedAt
  settings     Json
  projectId    Int
  project      Project      @relation(fields: [projectId], references: [id])
  images       GeneratedImage[]
  garments     Garment[]    // N:M: prendas usadas en esta entrada
  SKU          String
  adminStatus  AdminStatus  @default(IN_PROGRESS)
  clientStatus ClientStatus @default(IN_PROGRESS)
  chats        Chat[]
}

type ProjectImageSettings =
  | BatchProjectImageSettings
  | ProductProjectImageSettings;

model GeneratedImage {
  id                  Int             @id @default(autoincrement())
  publicId            String          @unique @default(uuid())
  name                String
  url                 String?
  status              ImageStatus     @default(PENDING)
  reason              String?
  uploadId            Int
  projectId           Int
  project             Project         @relation(fields: [projectId], references: [id])
  upload              ProjectImage    @relation(fields: [uploadId], references: [id])
  previous            GeneratedImage? @relation("PreviousImages", fields: [previousId], references: [id])
  previousId          Int?            @unique
  next                GeneratedImage? @relation("PreviousImages")
  isFinal             Boolean         @default(true)
  version             Int             @default(1)
  garments            Garment[]       // N:M: prendas que aparecen en esta imagen
  approvedBy          User?           @relation("Approvals", fields: [approvedById], references: [id])
  approvedById        Int?
  approvedAt          DateTime?
  generatedAt         DateTime?
  createdAt           DateTime        @default(now())
  updatedAt           DateTime        @updatedAt
  pipelineStatus      PipelineStatus  @default(PENDING)
  pipelineInformation Json?
  revisionInformation Json?
  revisionStatus      RevisionStatus  @default(PENDING)
  pose                Pose?
}
 
enum ImageStatus {
  BYPASS
  PENDING
  INCOMPLETE
  UNPUBLISHED
  PENDING_APPROVAL
  APPROVED
  REJECTED
  PENDING_REGENERATION
  CANCELLED
}
 
enum RevisionStatus {
  PENDING
  GENERATING
  PENDING_APPROVAL
  EDITING
  FIXING
  PRE_APPROVED
  APPROVED
  ERROR
}
 
enum PipelineStatus {
  PENDING
  QUEUED
  PROCESSING
  FINISHED
  COMPLETED
  ERROR
}

model Model {
  id         Int          @id @default(autoincrement())
  publicId   String       @unique @default(uuid())
  createdAt  DateTime     @default(now())
  updatedAt  DateTime     @updatedAt
  name       String
  gender     Gender
  age        Int
  image      String
  companyId  Int?
  company    Company?     @relation(fields: [companyId], references: [id])
  brands     Brand[]      // N:M con Brand
  projects   Project[]    // N:M con Project
  baseImages ModelImage[]
  status     ModelStatus  @default(ACTIVE)
}
 
model ModelImage {
  id        Int      @id @default(autoincrement())
  publicId  String   @unique @default(uuid())
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  url       String
  pose      Pose?
  isPreview Boolean  @default(false)
  modelId   Int
  model     Model    @relation(fields: [modelId], references: [id])
}
 
enum ModelStatus {
  ACTIVE
  DEPRECATED
}
 
enum Gender {
  MALE
  FEMALE
  OTHER
}

model Notification {
  id         Int                   @id @default(autoincrement())
  publicId   String                @unique @default(uuid())
  title      String
  description String
  link       String
  folderId   Int?
  folder     ProjectFolder?        @relation(fields: [folderId], references: [id])
  isRead     Boolean               @default(false)
  templateId Int
  template   NotificationTemplate  @relation(fields: [templateId], references: [id])
  createdAt  DateTime              @default(now())
  updatedAt  DateTime              @updatedAt
}

model NotificationTemplate {
  id                 Int                      @id @default(autoincrement())
  publicId           NotificationTemplateType @unique
  title              String
  body               String
  variables          String[]
  twilioTemplateSid  String
  role               UserRole
  createdAt          DateTime                 @default(now())
  updatedAt          DateTime                 @updatedAt
  notifications      Notification[]
}
 
enum NotificationTemplateType {
  ADMIN_PROJECT_CREATED               // Notificación para administrador cuando se crea un proyecto/caso nuevo
  ADMIN_NEW_REJECTIONS                // Notificación para administrador cuando se rechazan imágenes
  COMPANY_PROJECT_CREATED             // Notificación para cliente cuando se termina de crear un proyecto nuevo
  COMPANY_PROJECT_PENDING_APPROVAL    // Notificación para cliente cuando se generan nuevas imágenes
  COMPANY_PROJECT_READY_FOR_DOWNLOAD  // Notificación para cliente cuando se completa/aprueba un caso/proyecto
}

model Chat {
  id             Int           @id @default(autoincrement())
  publicId       String        @unique @default(uuid())
  createdAt      DateTime      @default(now())
  updatedAt      DateTime      @updatedAt
  isResolved     Boolean       @default(false)
  resolvedAt     DateTime?
  projectId      Int
  projectImageId Int?
  project        Project       @relation(fields: [projectId], references: [id])
  projectImage   ProjectImage? @relation(fields: [projectImageId], references: [id])
  messages       ChatMessage[]
}

model ChatMessage {
  id        Int      @id @default(autoincrement())
  publicId  String   @unique @default(uuid())
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  content   String
  chatId    Int
  userId    Int
  chat      Chat     @relation(fields: [chatId], references: [id], onDelete: Cascade)
  user      User     @relation(fields: [userId], references: [id])
}

model Job {
  id           Int        @id @default(autoincrement())
  publicId     String     @unique @default(uuid())
  status       JobStatus  @default(PENDING)
  errorMessage String?
  userId       Int
  user         User       @relation("UserJob", fields: [userId], references: [id])
  createdAt    DateTime   @default(now())
  startedAt    DateTime?
  finishedAt   DateTime?
  type         JobType
  payload      Json       // Filtros y parámetros de entrada del job
  result       Json?      // Resultado final (ej: signed URLs de descarga)
  progress     Int        @default(0)
  totalBatches Int?
  currentBatch Int        @default(0)
  batches      JobBatch[]
}
 
enum JobStatus {
  PENDING    // Creado, esperando worker
  RUNNING    // Worker procesando
  COMPLETED  // Finalizado exitosamente
  FAILED     // Error irrecuperable
  RETRYING   // Reintentando tras fallo parcial
  CANCELLED  // Cancelado manualmente
}
 
enum JobType {
  IMAGE_DOWNLOAD          // Descarga de imágenes (ZIP con signed URLs de GCS)
  REPORT_GENERATION       // Generación de reporte Excel de imágenes
  METRICS_CALCULATION     // Cálculo de métricas de admin
  FACESWAP_RECOGNITION    // Reconocimiento facial para proyectos FACESWAP
}

model JobBatch {
  id           Int            @id @default(autoincrement())
  jobId        Int
  job          Job            @relation(fields: [jobId], references: [id], onDelete: Cascade)
  batchNumber  Int
  status       JobBatchStatus @default(PENDING)
  result       Json?
  errorMessage String?
  startedAt    DateTime?
  finishedAt   DateTime?
  createdAt    DateTime       @default(now())
}
 
enum JobBatchStatus {
  PENDING  // Esperando procesamiento
  RUNNING  // Procesando
  DONE     // Completado exitosamente
  FAILED   // Error en este lote
}

model Post {
  id              Int       @id @default(autoincrement())
  publicId        String    @unique @default(uuid())
  title           String
  description     String
  publicationDate DateTime?
  image           String
  file            String
  tags            String[]
  type            PostType
  isPublished     Boolean   @default(false)
  authorName      String
  createdAt       DateTime  @default(now())
  updatedAt       DateTime  @updatedAt
}
 
enum PostType {
  PUBLICATION
  PRESS
}