Something I’m quite new to and would like a little advice on when to use sub tables and multi relation tables for a common example lets look at Reddit or Facebook groups.
You have users > group / reddit > posts > comments
Which of these should be what the main thing that’s tripping me up is when we are querying the data or insert and update we can only directly access 1 level of nesting for example if users was a normal table and then the rest are multi relations or subtables in this example we can only select users or the group / reddit as a start point. So what if all I want to insert is just a comment etc or should the structure be more like:
users
group / reddit (with a relation to users)
posts (relation to users and group / reddit)
comments (multi-relation of posts to link the user)