Base de datos

erDiagram
    USER ||--o| EMPLOYEE : "es"
    USER ||--o{ SESSION : "abre"
    USER ||--o{ NOTIFICATION : "recibe"
    USER ||--o{ AUDIT_LOG : "genera"

    CLIENT ||--o{ PROPERTY : "posee"
    PROPERTY ||--o{ PROPERTY_TASK_TEMPLATE : "define"
    PROPERTY ||--o{ SERVICE : "recibe"

    SERVICE ||--o{ SERVICE_ASSIGNMENT : "asigna"
    SERVICE ||--o{ SERVICE_TASK : "contiene"
    SERVICE ||--o{ WORK_SESSION : "registra"
    SERVICE ||--o{ EVIDENCE : "acumula"
    SERVICE ||--o{ INCIDENT : "reporta"
    SERVICE ||--o{ SERVICE_SUPPLY : "consume"

    EMPLOYEE ||--o{ SERVICE_ASSIGNMENT : "recibe"
    EMPLOYEE ||--o{ WORK_SESSION : "trabaja"
    EMPLOYEE ||--o{ INCIDENT : "reporta"
    EMPLOYEE ||--o{ PAYROLL_PAYMENT : "cobra"

    SERVICE_TASK ||--o{ EVIDENCE : "documenta"
    INCIDENT ||--o{ EVIDENCE : "adjunta"

    PAYROLL_PAYMENT ||--o{ PAYROLL_PAYMENT_ITEM : "desglosa"
    SERVICE ||--o{ PAYROLL_PAYMENT_ITEM : "liquida"

    USER {
        string id PK
        string username UK
        string email UK "nullable"
        string passwordHash
        enum role "ADMIN | EMPLOYEE"
        bool isActive
        bool mustChangePassword
        datetime archivedAt "nullable"
    }

    EMPLOYEE {
        string id PK
        string userId FK UK
        string firstName
        string lastName
        int hourlyRateOverride "céntimos, nullable"
        bool isActive
        datetime archivedAt "nullable"
    }

    CLIENT {
        string id PK
        string name
        string companyName "nullable"
        datetime archivedAt "nullable"
    }

    PROPERTY {
        string id PK
        string clientId FK
        string name
        string address
        string doorCode "sensible, nullable"
        string lockboxCode "sensible, nullable"
        int defaultServicePrice "céntimos, nullable"
        datetime archivedAt "nullable"
    }

    PROPERTY_TASK_TEMPLATE {
        string id PK
        string propertyId FK
        string title
        bool requiresAfterPhoto
        int sortOrder
        bool isActive
    }

    SERVICE {
        string id PK
        string propertyId FK
        date scheduledDate "día local CR"
        int scheduledStartMinutes "nullable"
        enum status
        int basePrice "céntimos, congelado"
        datetime completedAt "nullable"
        bool hasTimeWarning
        bool hasIncident
    }

    SERVICE_ASSIGNMENT {
        string id PK
        string serviceId FK
        string employeeId FK
        int hourlyRateSnapshot "céntimos, congelado"
        datetime releasedAt "nullable"
    }

    SERVICE_TASK {
        string id PK
        string serviceId FK
        string sourceTemplateId "nullable"
        string title "copia inmutable"
        bool requiresAfterEvidence
        enum status "PENDING | COMPLETED"
        string completedByEmployeeId FK "nullable"
    }

    WORK_SESSION {
        string id PK
        string serviceId FK
        string employeeId FK
        datetime startedAt
        datetime endedAt "nullable = en curso"
        string editReason "nullable"
    }

    EVIDENCE {
        string id PK
        enum kind "BEFORE | AFTER | INCIDENT | GENERAL"
        enum status "PENDING | CONFIRMED | DELETED | EXPIRED"
        string objectKey UK "clave en R2"
        string serviceTaskId FK "nullable"
        datetime expiresAt "retención"
    }

    INCIDENT {
        string id PK
        string serviceId FK
        enum category
        enum severity
        enum status "OPEN | RESOLVED"
    }

    SERVICE_SUPPLY {
        string id PK
        string serviceId FK
        decimal quantity
        int unitChargePrice "céntimos"
        int totalInternalCost "céntimos, nullable"
        enum status "PENDING_REVIEW | APPROVED | REJECTED"
    }

    PAYROLL_PAYMENT {
        string id PK
        string employeeId FK
        date periodStart
        date periodEnd
        int totalAmount "céntimos, congelado"
        enum status "PENDING | PAID"
    }

    PAYROLL_PAYMENT_ITEM {
        string id PK
        string paymentId FK
        string propertyNameSnapshot
        int minutes
        int hourlyRateSnapshot
        int amount "céntimos"
    }

CREATE UNIQUE INDEX "work_sessions_one_active_per_employee"
  ON "work_sessions" ("employeeId")
  WHERE "endedAt" IS NULL;

pnpm exec prisma migrate dev --name descripcion_del_cambio