[SPRINT 1] Création table contracts #34

New Issue

2025-08-11T14:16:55Z

vdorge commented

2025-08-11 14:16:55 +00:00

Description

Contrat issu d’un dossier (1:1).
Colonnes : id (PK), dossier_id (FK unique), schedule (jsonb), hourly_rate (decimal), meals_indemnity (decimal), start_date (date), status (default 'draft'), signed_by_parent (bool), signed_by_am (bool), finalized_at, created_at, updated_at.
Contrainte : unique(dossier_id).

Critères d’acceptation

Respect 1:1 dossier→contrat.
Insert/Update signatures OK.
DBML & Draw.io à jour.

## Description - Contrat issu d’un dossier (1:1). - Colonnes : id (PK), dossier_id (FK unique), schedule (jsonb), hourly_rate (decimal), meals_indemnity (decimal), start_date (date), status (default 'draft'), signed_by_parent (bool), signed_by_am (bool), finalized_at, created_at, updated_at. - Contrainte : unique(dossier_id). ## Critères d’acceptation - Respect 1:1 dossier→contrat. - Insert/Update signatures OK. - DBML & Draw.io à jour.

vdorge added this to the Sprint 1 – Mise en place BDD milestone 2025-08-11 14:16:55 +00:00

vdorge added the Implémentation BBD labels 2025-08-11 14:16:55 +00:00

vdorge added this to the P'titsPas-Ynov project 2025-08-11 14:16:55 +00:00

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: Ynov/ptitspas-ynov#34