How to constrain a table linking two tables in many-to-many relationship
- by Gromul
Say I have the following tables and columns:
comp: id, model
dvd: id, model
comp2dvd: id, id_comp, id_dvd
A computer can have multiple dvd drives, even of the same model, and a dvd drive can appear in multiple computers. How do I make it so that comp2dvd table can have only existing comp and dvd ids?
Thanks