[SPRINT 1] Création table notifications #41

New Issue

2025-08-11T14:28:31Z

vdorge commented

2025-08-11 14:28:31 +00:00

Description

Notifications utilisateur.
Colonnes : id (PK), user_id (FK), type (varchar/CHECK), message (text), is_read (bool default false), created_at.
Index : (user_id,is_read,created_at).

Critères d’acceptation

Création/lecture (is_read) OK.
Requêtes par user efficaces.
DBML & Draw.io à jour.

## Description - Notifications utilisateur. - Colonnes : id (PK), user_id (FK), type (varchar/CHECK), message (text), is_read (bool default false), created_at. - Index : (user_id,is_read,created_at). ## Critères d’acceptation - Création/lecture (is_read) OK. - Requêtes par user efficaces. - DBML & Draw.io à jour.

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

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

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