2 ms·
I just name it users and accept the minor inconsistency that every table is singular except for the users table (it has the lowest cognitive overhead IMO)
by SPBS 3y ago
I just name it users and accept the minor inconsistency that every table is singular except for the users table (it has the lowest cognitive overhead IMO)
- reportgunner 3y agoNo, I mean the word USER in a statement like below CREATE USER user_name [ { FOR | FROM } LOGIN login_name ] [ WITH <limited_options_list> [ ,... ] ] [ ; ]
- yencabulator 3y agoIt's a shame that the classic style separation of lexing and parsing means to support the command CREATE USER FOR LOGIN WITH means all of those are now magic keywords, instead of only behaving so in the context of a CREATE command. As for how to name the "user" table, I've used "account". User is a human not a piece of data, Account is the data I have about their association with my service.