MySQL Forums
Forum List  »  MySQL Workbench

Adding a Foreign Key without Constraints
Posted by: george gallen
Date: November 07, 2012 04:03PM

For documentation purposes, I'd like to define a foreign key relationship between two entities, BUT I don't want any constraints put on the data. Yes, I realize this could "corrupt" my data, but my problem is I have an already designed schema with data already in place with some existing broken links. I do NOT want to delete that data (with the broken links) - it's history. But I would like to setup a visual model that shows the FK relationships for documentation purposes.

So essentially, I'd love to be able to say: ON UPDATE: IGNORE, ON DELETE: IGNORE

I considered adding the missing data, adding the FK's, then deleting the missing data again, but doing so may endanger the entire row of data in the referencing table, or is that only if the it's set to CASCADING?

Options: ReplyQuote


Subject
Views
Written By
Posted
Adding a Foreign Key without Constraints
1249
November 07, 2012 04:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.