Imported SQL schema but foreign key relationships were not set up

Gravatar

I imported my MySQL schema. The schema includes foreign keys where a column in one column references a column in another column. I see that FlatLogic supports "Relation (one)" as a column type. However, my entities in FlatLogic do not have the relation set up. I tried to edit the column type to make it be "Relation (one)" but the option to modify the column type is grayed out without explanation. Why did my foreign keys not get imported and set up in my entities?

User profile image

Hi User-115697,

It seems you're having trouble with setting up foreign keys in your imported MySQL schema. This might be because the schema didn't explicitly define the foreign key relationships, or there could be constraints within the Flatlogic Schema Editor that prevent modifications.

We're constantly working on improving our functionality to better handle schema imports and relationships. If you still face issues, please provide more details so we can assist you further.

You could send it to [email protected]

Gravatar

The "Relation (one)" option being grayed out could indicate that the platform is not recognizing or supporting direct edits to those columns. You may need to manually recreate the relationships between entities after import, or check if there's an import setting affecting foreign key detection.