On Tue, Feb 4, 2025 at 12:05 PM Rob Sargent <robjsargent@xxxxxxxxx> wrote:
On 2/4/25 10:03, Ron Johnson wrote:
And there goes your unique index on phone number :)On Tue, Feb 4, 2025 at 11:31 AM Michał Kłeczek <michal@xxxxxxxxxxx> 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.
I don't think I'd ever do that, since phone numbers can get reassigned.
Capital-L Large and old businesses probably don't even have unique indices on SSN.
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
