CVTech — Sistema de Integração Municipal

model Municipality {
  id          String     @id @default(cuid())
  ibgeCode    String     @unique
  name        String
  state       String
  connectors  Connector[]
  createdAt   DateTime   @default(now())
}

model Connector {
  id              String         @id @default(cuid())
  municipalityId  String
  name            String
  type            ConnectorType
  config          Json
  enabled         Boolean        @default(true)
  mappings        DataMapping[]
  syncConfigs     SyncConfig[]
  municipality    Municipality   @relation(fields: [municipalityId], references: [id])
}

model DataMapping {
  id           String   @id @default(cuid())
  connectorId  String
  sourceField  String
  targetField  String
  transform    Json
  connector    Connector @relation(fields: [connectorId], references: [id])
}

model SyncConfig {
  id           String   @id @default(cuid())
  connectorId  String
  mode         SyncMode
  cron         String?
  strategy     ConflictStrategy
  connector    Connector @relation(fields: [connectorId], references: [id])
  jobs         SyncJob[]
}

model SyncJob {
  id             String   @id @default(cuid())
  syncConfigId   String
  status         JobStatus
  startedAt      DateTime
  finishedAt     DateTime?
  recordsRead    Int      @default(0)
  recordsWritten Int      @default(0)
  errors         Json?
  syncConfig     SyncConfig @relation(fields: [syncConfigId], references: [id])
}

model CitizenData {
  id             String   @id @default(cuid())
  cpfHash        String   @index
  domain         String
  payload        Json
  sourceConnector String
  updatedAt      DateTime @updatedAt
}

model AuditLog {
  id         String   @id @default(cuid())
  actor      String
  action     String
  resource   String
  payload    Json
  occurredAt DateTime @default(now())
}