[prmph]

So with all their billions they could not get a proper software engineer to architect their project?

Unless there is some deep technical reason why things have to be this way, which I very much doubt.

And now they can't change it? Where is Claude when you need him/her

[jaggederest]

The funny thing is that if you ask Claude if you should use email address as a primary key it will pretty adamantly warn you away from it:

> I'd recommend against using email as the primary key for a large LLM chat website. Here's why:

> Problems with email as primary key:

> 1. Emails change - Users often want to update their email addresses. With email as PK, you'd need to cascade updates across all related tables (chat sessions, messages, settings, etc.), which is expensive and error-prone

> [Edited for length]