search

mmmaly / chcemvediet

FOIA requests for the lazy
4 stars 6 forks source link

Unique ID for the user #1

Closed creepone closed 11 years ago

creepone commented 11 years ago

Currently, the email is set as a primary key for the user table, but to be able to safely reference the user while allowing him to change his email later it might be better to use a surrogate key instead.

I don't know what the postgres supports, but typically this would be either an auto-increment integer or a guid.

mmmaly commented 11 years ago

I think both auto-increment/guid are possible. For now, I am marking this as enhancement (aka "possibility to change e-mail address").