Noob foreign keys q – table of venues and table of reviews, how best to link?
Hi, I have a table of
restaurants with metadata (name, address etc) and a table called reviews – I'd like when I query the restaurants table to pull in relevant reviews. In which table should I add a foreign key column? Both? Should the 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