MySQL Relationships

by

User – Device is a many-to-many relationship, so you’ll want to introduce an intermediary table to resolve that relationship. That table simply consists of two foreign keys, one referencing the User table and one referencing Device. Device – Location can be handled with a simple foreign key in the Device table pointing to a Location table.

enter image description here

More Related Contents:

  1. MySQL – Conditional Foreign Key Constraints
  2. Mysql error 1452 – Cannot add or update a child row: a foreign key constraint fails
  3. Required to join 2 tables with their FKs in a 3rd table
  4. Implementing Comments and Likes in database
  5. Error Code: 1005. Can’t create table ‘…’ (errno: 150)
  6. Basics of Foreign Keys in MySQL?
  7. Can a foreign key reference a non-unique index?
  8. Is it possible to query a tree structure table in MySQL in a single query, to any depth?
  9. MySql Error 150 – Foreign keys
  10. Storing SHA1 hash values in MySQL
  11. How to create relationships in MySQL
  12. MySQL ENUM type vs join tables
  13. MySQL InnoDB foreign key between different databases
  14. Relational database design multiple user types
  15. MySQL Removing Some Foreign keys
  16. Force InnoDB to recheck foreign keys on a table/tables?
  17. How to design a multi tenant mysql database
  18. DOs and DONTs for Indexes [closed]
  19. MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?
  20. Is it possible to reference one column as multiple foreign keys?
  21. How to insert values in table with foreign key using MySQL?
  22. MySQL – Supertype/Subtype design
  23. MySQL foreign key to allow NULL?
  24. Difference between two table structure
  25. Foreign key constraints: When to use ON UPDATE and ON DELETE
  26. When to use a left outer join?
  27. MySQL: how to do row-level security (like Oracle’s Virtual Private Database)?
  28. List of Constraints from MySQL Database
  29. Should I always prefer MySQL InnoDB over MyISAM?
  30. Database Historization

Leave a Comment