My SQLPhpMyAdmin How to properly create composite primary keys – MYSQL By Rahul Bhutani - May 17, 2021 0 999 Share Facebook Twitter Google+ Pinterest WhatsApp I would use a composite (multi-column) key. CREATE TABLE INFO ( t1ID INT, t2ID INT, PRIMARY KEY (t1ID, t2ID) ) This way you can have t1ID and t2ID as foreign keys pointing to their respective tables as well.