Menu

Creating the db

I need at least to have a user table created in db, to start testing the app. This is a good time to stablish some rules on how i'll be working on my db.

Every table in db will have a name in plural representing the entity stored. It will be all lowercased. eg. users
For each table created i want to have a 3 letter id to use it as a prefix on every field used on the table. eg. user table will have usu prefix, and the user id will be usu_id
There will be some standar fields that every table should have (except some particular cases
* record id: xxx_id
* record name: xxx_name
* audit fields
* xxx_createdby
* xxx_createdon
* xxx_lastupdateby
* xxx_lastupdateon

tablas n:n

Posted by augusto wloch 2020-02-28 | Draft

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.