[SPRINT 1] Création table events #36

New Issue

2025-08-11T14:20:25Z

vdorge commented

2025-08-11 14:20:25 +00:00

Description

Événements (absence, congés, arrêt, RPE).
Colonnes : id (PK), type (CHECK valeurs prévues), child_id (FK→children.id), am_id (FK→users.id), parent_id (FK→parents.user_id), created_by (FK→users.id), start_date, end_date, comments, status (default 'proposed'), grace_deadline, urgency (bool), created_at, updated_at.
Index : (child_id,start_date), (created_by,created_at).

Critères d’acceptation

Insertion événements OK.
Requêtes par enfant/date performantes.
DBML & Eraser à jour.

## Description - Événements (absence, congés, arrêt, RPE). - Colonnes : id (PK), type (CHECK valeurs prévues), child_id (FK→children.id), am_id (FK→users.id), parent_id (FK→parents.user_id), created_by (FK→users.id), start_date, end_date, comments, status (default 'proposed'), grace_deadline, urgency (bool), created_at, updated_at. - Index : (child_id,start_date), (created_by,created_at). ## Critères d’acceptation - Insertion événements OK. - Requêtes par enfant/date performantes. - DBML & Eraser à jour.

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

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

vdorge added this to the P'titsPas-Ynov project 2025-08-11 14:20:25 +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#36