Import existing MySQL app


Is there a way I can import a relational database into Corteza? I see that I can import each table from CSV but then I lose the foreign keys/entity relationships. Any way to work with an existing database?


Importing single tables and recreating the relationships is normally the fastest way. I would recommend doing it like this, because in the Record type fields in Corteza you need to select the field value you want to show to the end-user.

For example, in a Contact I want to show the Account name:

Which the user sees as:

Hope this helps.

Thanks. I will have a look at this method. Can you also tell me if it’s possible to change a column type after creation?