Getting - there is no unique constraint matching
So I have a table called rooms which looks like this <image-1>, and I'm trying to have another table for room messages <image-2>, and one column of that links to the room, through the room_id but as you can see it doesn't get linked (the icon is not white), and I get this error whenever I try to link it as a reference <image-3>
