Ynov/ptitspas-ynov-bdd

Sprint 1 – Mise en place BDD

New Issue

Création des tables, triggers, index, seed, DBML

No due date

100% Completed

[BDD-S1] Jeux de requêtes de vérification (diagnostic)

#10 by vdorge was closed 2025-09-09 12:32:11 +00:00 P'titsPas-Ynov

[BDD-S1] Cohérence enums & valeurs d’app (mapping)

#9 by vdorge was closed 2025-09-09 14:05:31 +00:00 P'titsPas-Ynov

[BDD-S1] Ajustement schéma « validations » (traçabilité complète)

Implémentation

#8 by vdorge was closed 2025-09-09 14:53:51 +00:00 P'titsPas-Ynov

[BDD-S1] Docker Postgres : .env, volumes & README

#7 by vdorge was closed 2025-09-04 09:51:56 +00:00 P'titsPas-Ynov

[BDD-S1] Synchroniser DBML/Draw.io avec le SQL réel

#6 by vdorge was closed 2025-08-28 10:03:48 +00:00 P'titsPas-Ynov

[BDD-S1] Données de test (seed) réalistes

#5 by vdorge was closed 2025-09-04 09:58:47 +00:00 P'titsPas-Ynov

[BDD-S1] Gérer la mise à jour automatique des timestamps (updated_at / modifie_le)

Implémentation

#4 by vdorge was closed 2025-09-04 12:46:34 +00:00 P'titsPas-Ynov

[BDD-S1] Définir les politiques ON DELETE / ON UPDATE (FK)

Implémentation

#3 by vdorge was closed 2025-09-05 14:42:48 +00:00 P'titsPas-Ynov

[BDD-S1] Ajout de CHECKs métiers & cohérence des données

Implémentation

#2 by vdorge was closed 2025-09-09 12:03:55 +00:00 P'titsPas-Ynov

[BDD-S1] Indexer toutes les clés étrangères & colonnes critiques

#1 by vdorge was closed 2025-09-04 14:23:08 +00:00 P'titsPas-Ynov