On 2/4/25 10:03, Ron Johnson wrote:
On Tue, Feb 4, 2025 at 11:31 AM Michał Kłeczek <mic...@kleczek.org> wrote: [snip] The query to register a visit is: insert into restaurant_visit select $user, current_date, restaurant_id, $rating from restaurant where name = $restaurant_name It is now completely unclear what it means to change the name of the restaurant for already registered visits. Is it still the same restaurant with a different name or a different restaurant? Or let say someone swaps names of two restaurants. That means a user that goes to the same restaurant every day would register visits to two different restaurants!Valid concerns, which means that you add a new restaurant record when the name changes.
And there goes your unique index on phone number :)
