MySQL Engine you are using to create tables is InnoDB so you can create relationship but I guess having unique on the field will do it for you