Wednesday, 9 September 2015

Module 1 - "Roles and Users" table design


So let's get started with our application, shall we?

In upcoming blogs i will be giving a lot of links from where you will need to download resources - for example you will need to download bootstrap soon. But before any of business logic or view design, its crucial to design database and the first few tables will be for user logins as in this diagram:




As the diagram is self-explanatory - There are going to be 2 primary tables.

Roles table will store roles privilege information.
Users table will store user information
Module table will be common to all Modules and users which will store module level privilege information for each user.

You can choose any database here. I changed my mind and i will be using postgres instead.

No comments:

Post a Comment