{
  "id": 9001,
  "offre": { "id": 123, "titre": "Développeur Backend Java (H/F)" },
  "candidat": { "id": 42, "firstName": "Jean", "lastName": "Ngassa" },
  "cv": { "id": 17, "fileName": "cv-jean-ngassa.pdf", "downloadUrl": "/v1/api/files/cv/17" },
  "lettreMotivation": "Madame, Monsieur, je vous présente ma candidature...",
  "status": "IN_PROGRESS",
  "appliedAt": "2026-04-16T14:20:00Z",
  "lastStatusChange": "2026-04-17T09:00:00Z",
  "timeline": [
    { "type": "STATUS_CHANGE", "fromStatus": null, "toStatus": "NEW", "at": "2026-04-16T14:20:00Z" },
    { "type": "STATUS_CHANGE", "fromStatus": "NEW", "toStatus": "TO_MEET", "at": "2026-04-16T16:45:00Z" },
    { "type": "NOTE", "content": "Bon profil, à contacter", "authorId": 42, "at": "2026-04-17T09:00:00Z" },
    { "type": "STATUS_CHANGE", "fromStatus": "TO_MEET", "toStatus": "IN_PROGRESS", "at": "2026-04-17T09:00:00Z" }
  ]
}

CREATE UNIQUE INDEX uq_candidature_active
  ON candidatures(offre_id, candidat_id)
  WHERE status NOT IN ('REJECTED', 'WITHDRAWN');