3.1 Data Modelling

I created my data model online at dbdesigner.net . It took less than 5 min to make a snapshot of data model using this online tool.

Link to app idea

Link to prototype of the webapp

Schema Diagram

In user_info table the primary key is id which is of auto increment integer type and the result table has primary key as id which has a foreign key to id of user_info table. Also there is a relationship from result to user_info table to fetch names while we query some data from result table.

Next: Hasura Data API and Postman collection