[SPRINT 1] Création table users #27

New Issue

2025-08-11T14:04:39Z

vdorge commented

2025-08-11 14:04:39 +00:00

Description

Créer table users (PK UUID, snake_case).
Colonnes clés : email (unique, not null), password_hash (not null), first_name, last_name, role (CHECK), status (CHECK default 'pending'), phone, address, photo_url, consent_photo, consent_photo_at, must_change_password (default false), created_at, updated_at.
Index/contraintes : unique(email).
Timestamps par défaut.

Critères d’acceptation

Migration SQL appliquée sans erreur.
Insert/Select de test OK.
DBML & Draw.io à jour.

## Description - Créer table users (PK UUID, snake_case). - Colonnes clés : email (unique, not null), password_hash (not null), first_name, last_name, role (CHECK), status (CHECK default 'pending'), phone, address, photo_url, consent_photo, consent_photo_at, must_change_password (default false), created_at, updated_at. - Index/contraintes : unique(email). - Timestamps par défaut. ## Critères d’acceptation - Migration SQL appliquée sans erreur. - Insert/Select de test OK. - DBML & Draw.io à jour.

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

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

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