Re: Lookup tables

On Tue, Feb 4, 2025 at 11:31 AM Michał Kłeczek <michal(at)kleczek(dot)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!