...

Introduction

In this tutorial we are going to see how to create an Entity from an external relational database table.

Steps

Create the Entity

From the Control Panel, navigate to the Development > My Entities menu.

...

From the different Entities that we will be able to create, we will select the "Creation from Relational Database" one:

...

Fill in the general information

This will open the Entity creation wizard, where you will have to enter some basic information:

...

Once the Entity's general information and options have been defined, click on the "Continue" button to access the Entity's schema definition.

...

Define the Entity's scheme

Depending on whether you have checked the option to create table or not, this window will be displayed differently.

Selecting a pre-existing table

In case you have chosen a table already existing in the database, this screen will display the table schema.

...

Once these options are configured, click on the "Create" button to finish creating the Entity.

...

Create table

If, on the other hand, the option to create table has been checked, this screen will then display a field creation wizard, similar to the one for the current Entities of the Platform, but which will correspond to the header of the table to be created in the database.

Adding fields

You can create as many fields as you need. The fields that we want our entity to contain will be added one by one using the available interface:

...

Adding constraints

Constraints are properties assigned to a column or set of columns in a table that prevent certain types of inconsistent data values from being assigned to that column.

They follow the database specifications, so you have to know the characteristics of the database constraints before adding them.

...

Generate the SQL code

Once the fields and constraints are configured, it is time to update the SQL code that will be executed in the table creation process. To do this, click on the "Update SQL" button.

...