I have the attached image below of tables I have created in MySQL Workbench. The tables shows a one-to-one connection between a donor and its contact.
My challenge is that anytime I create the relationship, it creates another column as seen circled red in the image. This does not allow me to insert data into the contact table and it gives me an error of an unknown column in the execution of my insert syntax.
I want to know why I do have that column created and also is there a way I can work around it to allow me inset data to the table without any errors cos i have read that they are indexes and are thus good for speedy searches throughout the tables created. Or better still can i hide it and insert data with no errors thrown at me?
Thanks