Menu

First table. Users

I think that every table will have a document, reflecting each field, its function, etc.
But because this is the first one, it deserves a blog post.

The first table will be users, and because it belongs to the security tables layer, it will named security_users and its prefix will be sus

What fields this should have? well.. i was thinking about:
id - an autoincremental (AI), not null (NN) integer field (unsigned, because whats the point of an negative id?)
name - this name is not the real user name, but its nickname. the name field on each entity is supoused to referesent it and to be used as a title or a label when used as a reference in UI, so that, this will be its nickname. I think a 50 char length will be enough.
hash - the password hash. not sure the amount of characters needed (i guess that will arise when implementing the first security routines). By now, a varchar(60) will be ok
audit fields: the four fields detalied at Creating The Db Post

There will be a lot more of fields here (avatar, first name, last name, email, but so far, this is enough)

ps: I cannot find a good way to document every table here at sourceforge, so i think the best will be to link to a shared excel file

Posted by augusto wloch 2020-03-06 Labels: database

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.