Importing referential integrity between tables across schemas in an ERD diagram

Clarifying the above.  The RI lines are only imported when the entry in the TABLE_NAME matches the REFERENCED_TABLE_SCHEMA.  If they don’t match the lines are imported.

Correction.  If they don’t match the lines aren’t imported.

Please ignore everything I wrote above.  That’s what I get when I try and multitask. So, I am going to start over to be clear.

Several of our My SQL database designs have referential integrity between tables across schemas. When trying to import an ERD from My SQL it seems that referential integrity between tables across schemas is ignored on import.    Meaning The RI lines are only imported when the entry in the TABLE_SCHEMA column matches the entry in the REFERENCED_TABLE_SCHEMA.  If they don’t match the lines are not imported.

I’d be happy to provide example files demonstrating this behavior.

Several of our My SQL database designs have referential integrity between tables across schemas. When trying to import an ERD from My SQL that referential integrity between tables across schemas is ignored on import.    Meaning: the RI lines are only imported when the entry in the TABLE_SCHEMA column matches the entry in the REFERENCED_TABLE_SCHEMA.  If they don’t match the lines are not imported.

I’d be happy to provide example files demonstrating this behavior.

 Hi ​@CCourim, thank you for posting in the community and apologies for our delayed reply! I noticed you create another topic for this question which I’ve gone ahead and merged into this same post. 

To help us take a closer look at the issue, would you mind sharing an example screenshot or snippet demonstrating this behaviour? (feel free to censor any important information). Alternatively, please let me know if you’d like me to move our conversation to a private support ticket! 

Thank you for your help and patience. Please let me know if you have any questions!

Leianne-

Thank you for your response.  I have created two samples source csv files demonstrating the issue.     Please let me know how you want me to attach the samples so you can reproduce.   

Here are two visuals that demonstrate the issue.

Here's what it looks like when we import from an ERD that has multiple schemas.  Note: The issue is that the relationship lines are not drawn when the tables cross multiple schemas.

Any update.  Could I be doing something wrong?

Hi ​@CCourim, thank you for sharing the screenshots and details about the issue you’re seeing. I would love to take a closer look at the samples so I am going to move our conversation over to a private support ticket. Please keep an eye out for an email from Lucid Support.Thanks! 

Any update on this issue?

Hi ​@CCourim, thanks for checking in! This issue was reported this to our development team for investigation. I apologize for any disruption this may cause, and I will update this thread with any new information about a fix. Please follow along on this thread for updates, and post any additional questions or concerns below.

Hi ​@CCourim - good news! A fix is in the works and should be released shortly. I’ll update this thread once it officially is live, but wanted to let you know that it’s imminent! Thanks for your patience.