JOINs
to complete a query using multiple tables.
SELECT
the redundant table instead of doing a join on the original tables.List out each set of core objects you want to track data for, e.g. users, logs, etc. Make a table for each one.
Make unique columns in each table, for the data you want to track.
Model the relationships between your tables.
Implement the relationships.
For One-to-One relationships: Add one object as a column in the other object’s table.
Many
table, pointing to the primary key of the One
table. ![DBSchema.png](<https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1236bfce-7011-423d-ad27-238f19bb6c31/DBSchema.png>)
![DBSchemaMM.jpg](<https://s3-us-west-2.amazonaws.com/secure.notion-static.com/fd756d2a-d37a-4023-b39b-ff1c2b4aee69/DBSchemaMM.jpg>)
Walk through all the actions that’ll happen during a user’s operation of the app.