Import existing MySQL app

🧩 Low-Code Development
#1

Hi,

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?

#2

Hi!

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:

image
image808×463 22.9 KB

Which the user sees as:

image
image751×208 12 KB

Hope this helps.

#3

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?