Using email/username as a primary key

[machak]

Hi @pilcrowonpaper,

I haven't start using it yet, but I probably will, one question: looking at the database schema (https://lucia-sveltekit.vercel.app/adapters) it is not very clear if username/email can be used as a primary key.
& thanks a lot for the library ;-)
/m

[pilcrowonpaper]

You can use "username" as the auth id and the email the identifier token, and have a separate username and email column (unique) (these are represented as [user_id] columns in the docs). Lucia will throw an error if the username or email is already taken.

[spy16]

What is the main purpose of primary key?

[pilcrowonpaper]

It's to make sure the first auth method can't be deleted