Scrum4Me/prisma
Madhura68 bfad2452ce db: M12 migration — ideas + idea_logs + check-constraints + pg_notify update (T-492)
- new tables ideas + idea_logs with FKs (User/Product/Pbi cascade rules per plan)
- claude_jobs.task_id nullable; new idea_id FK + kind enum + index
  + check-constraint: exactly_one(task_id, idea_id)
- claude_questions.story_id nullable; new idea_id FK + index
  + check-constraint: exactly_one(story_id, idea_id)
- notify_question_change trigger: handles null story_id; idea_id added to payload

Verified against dev DB: tables created, both check-constraints active
(neither-set insert correctly rejected with errcode 23514),
trigger replaced.

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
2026-05-04 19:35:28 +02:00
..
migrations db: M12 migration — ideas + idea_logs + check-constraints + pg_notify update (T-492) 2026-05-04 19:35:28 +02:00
seed-data M11: Claude vraagt, gebruiker antwoordt (ST-1101..ST-1108) (#13) 2026-04-29 11:38:23 +02:00
neon.md fix: lint errors en warnings opgelost voor CI 2026-04-24 14:09:03 +02:00
schema.prisma feat(codes): code NOT NULL voor PBI/Story + Task.code + product_id denorm 2026-05-04 08:36:19 +02:00
seed.ts feat(codes): server actions + seed/scripts gebruiken code overal 2026-05-04 08:36:41 +02:00