Before we can get to the fun part of creating the backend in Wappler we are first going to have to create some database tables for Wappler to use and reference back to. Luckily it is fairly simple as we have already designed the entire database in MindNode so we just have to follow that.
This is the fourth video in the Wappler v1.2.3 "Fruit Juice International" training set, in it I am going to only create the first 3 tables needed for a website I already created, in great detail; as usual.
In this tutorial we will make use of phpMyAdmin however please feel free to use the concepts within and relate them through to any database client you prefer. If you need a better understanding of the Foreign Key to Primary Key MySQL concepts i would take a look here "How to Use MySQL Foreign Keys for Quicker Database Development".
The concepts used in this tutorial are as follows:
• MySQL > Database Design, InnoDB, Database Tables, Primary and Foreign Key relationships, and Views
• Field Types > Int, VarChar, datetime, timestamp, decimal, enum.
• Possible Automation > Auto Increment, On Update Current Timestamp, On Delete Cascade, and On Update Cascade.