Database structure

If there will always be five columns then it is more correct to just add those on to the restaurants table. You could make another table for the ratings, but it would add overhead and serve no purpose other than reducing the number of columns in your main table.

You're talking about reviews though? If there will ever be more than one review, then you should make that a separate table.

Jason

Richard wrote: