-
Notifications
You must be signed in to change notification settings - Fork 0
Database
This app stores your collection information into a MySQL database. MySQL is a relational database, which means that tables and fields can reference each other. Understanding how this database works, and how the tables relate to each other, is important if you want to assist with development.
Relationships between tables are not enforced with a foreign key relationship, as foreign keys often cause problems when performing tasks like restoring a backup of a database. Instead, these relationships are simply managed through code. So it is especially important to understand these relationships if you are going to be modifying any code relating to the database.
This diagram shows, visually, what information each table holds and how the tables relate to each other.
https://github.com/Fifteen15Studios/NumismatistHelper/blob/master/Numismatist%20Helper.pdf
A separate page has been created to explain the purpose of each table, what information the table holds, and how that table relates to other tables.