Before I begin going to the trouble of adding a single table into MySQL, I first like to fully design my database in an application like MindNode, this allows me to add arrows and linkages between different fields, so I can get a visual representation of what I am going to need.
This is the second video in the Wappler v1.2.3 "Fruit Juice International" training set, in it I am going to explain the database design I already created, in great detail; as usual.
This tutorial will make use of MindNode and discuss topics intended for usage in MySQL, no matter if you write it manually or use any client to interact with your database, the concepts within will remain the same. 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.