Noob foreign keys q – table of venues and table of reviews, how best to link?

Hi, I have a table of

restaurants

restaurants

with metadata (name, address etc) and a table called

reviews

reviews

– I'd like when I query the

restaurants

restaurants

table to pull in relevant

reviews

reviews

. In which table should I add a foreign key column? Both? Should the

reviews

reviews

table have a foreign key column with the restaurant ID in it? Bit confused on the best approach, thanks! Note – I only plan one review/row per restaurant if that helps

Noob foreign keys q – table of venues and table of reviews, how best to link?

Similar Threads

Noob foreign keys q – table of venues and table of reviews, how best to link?

Similar Threads

Similar Threads

Similar Threads