I'm trying to understand all relationship types that can be created in SQL.
So far I only get the "belongs-to" one - Example: a table with "Blog post" records, which contains an
author_id column that references the
id column of another table called Authors.
But what about the other relationship types, like many-to-many, one-to-one, one-to-many.. ? How do they work exactly? Can anyone post some examples? Thanks