Why does notetaker_notes table also holds modid
Closed this issue · 1 comments
mudrd8mz commented
The notetaker_notes has a foreign key notetakerid that creates the 1:N relation between notetaker instance and notetaker_notes. But then the notetaker_notes also has another field that links to the same notetaker instance.
This violates the https://en.wikipedia.org/wiki/Third_normal_form and should be avoided - unless I am missing something?
jlb224 commented
Resolved. Code refactored to remove unnecessary modid column