[openstreetmap/openstreetmap-website] Adds version to notes table and creates note_versions table (PR #5815)

[Tom Hughes]

tomhughes left a comment (openstreetmap/openstreetmap-website#5815)

I mean we still haven't finished implementing the previously agreed schema changes for notes have we? and now we want to start altering it again..

I understand the logic of matching how the geodata is versions, but notes are not the same and this seems to create quite a confusing schema to me. I can see each note version has a comment reference, so is a new version created every time there is a comment? So there is a one-one relationship between comments and versions? or maybe many-one because you can can have a version without a new comment?

Maybe this is the right solution but right now it just seems that it sets up a very confusing triangular relationship between notes, note_versions and note_comments.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/pull/5815#issuecomment-2807064086
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/openstreetmap-website/pull/5815/c2807064086 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20250415/64afac01/attachment-0001.htm>