How to write a good username schema?
I am creating a users table with fields, id, username, email & password. Why do I need to use the id field? Why can't I just use username as the primary key? Would there be any drawbacks to that?
If I use
If I use
primaryKey() then do I need unique().notNull()?