3.1 DATA MODELING FOR KEEPSAFE

Data modelling is often the first step in database design in which the analysis of data objects and their relationship with other data objects is carried out. It defines how data is connected to each other and how they are processed and stored inside the system.

In this blog I will share the Database schema for my application. You can read about my application idea and prototypes using the below links-

Various tools are available for creating the Database schema, One which I have used is DbDesigner.

Data Model for KeepSafe

Brief description about each of the tables-

  1. app_users table include the username and password of the registered users.
  2. pass_mgr table includes the passwords of user’s different accounts in encrypted format.

References-

  1. https://www.tutorialspoint.com/dbms/dbms_data_models.htm
  2. http://www.webopedia.com/TERM/D/data_modeling.html

Next blog : Hasura Data APIs