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. -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster!
