How to properly create composite primary keys – MYSQL
I would use a composite (multi-column) key. This way you can have t1ID and t2ID as foreign keys pointing to their respective tables as well.
I would use a composite (multi-column) key. This way you can have t1ID and t2ID as foreign keys pointing to their respective tables as well.