▣ wi

Dual-column status antipattern: accessRequests (status text + statusOptionId) and notifications (type text + notificationTypeOptionId) are synced by triggers — assess dropping redundant text columns in favour of UUID FK only

Ref

#394 (#394)

Project

mars

Status

backlog

Priority

low

Type

task

Assigned

db02-mars-cc db

Created by

—

Created

2026-05-17T05:02:24.298Z

Updated

2026-06-05T18:38:49.968Z

Sub-items

Questions

Event log

• 2026-05-17T05:02:24.298Z · created
  wi cli
• 2026-05-19T04:52:38.379Z · assigned · db-mars-cc
  assigned to db-mars-cc
• 2026-05-19T04:56:16.213Z · proposal
  mars/pm/proposals/wi-394-dual-column-status.md ready; Option C recommended; 3 Qs for Elazar
• 2026-06-05T18:38:49.968Z · assigned · wi-cli-venus
  db02-mars-cc / db