[SPRINT 1] Création table dossiers #32

New Issue

2025-08-11T14:13:23Z

vdorge commented

2025-08-11 14:13:23 +00:00

Description

Dossiers de demande.
Colonnes : id (PK), parent_id (FK→parents.user_id), child_id (FK→children.id), presentation (text), type_contract (varchar), meals (bool), budget (decimal), desired_schedule (jsonb), status (default 'sent'), created_at, updated_at.
Index : (parent_id,child_id), éventuellement sur status.

Critères d’acceptation

Insert/Select OK, FK valides.
DBML & Draw.io à jour.

## Description - Dossiers de demande. - Colonnes : id (PK), parent_id (FK→parents.user_id), child_id (FK→children.id), presentation (text), type_contract (varchar), meals (bool), budget (decimal), desired_schedule (jsonb), status (default 'sent'), created_at, updated_at. - Index : (parent_id,child_id), éventuellement sur status. ## Critères d’acceptation - Insert/Select OK, FK valides. - DBML & Draw.io à jour.

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

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

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

vdorge changed title from ~~Création table dossiers~~ to [SPRINT 1] Création table dossiers

2025-08-11 14:15:24 +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#32