Creating new models in your data model

Models can be added from the quick menu, the model schema view and the model list.

Creating new models

You can create new models from the:

  • Data model quick menu by clicking on the Add button (+)

  • Schema view or model records list or by clicking on the New model button.

We've also created a video about creating models:

The Create new model window is displayed as shown in the following example:

1. Enter the name you want to assign to the model in the Create new model window.

2. Specify the unique name for the model.

3. Click Create model. The model overview is opened. The unique name is assigned as the model name. The properties are automatically generated when you create a model and cannot be deleted from a model:

  • Created at – date-time stamp detailing when database records are created

  • ID – the identifier that unifies every individual data record within this model

  • Updated at – additional time stamp applied when database records are updated.

Using the models details pane

Once you have created a model, you can use the various tabs shown in the example below to apply details for a model:

A. The active tab, Properties, is underlined as shown in the above example. The table provides an overview of the properties that have been defined for this model. Individual table rows provide a summary of the property.

As shown in the example, there are currently 3 properties defined for this model. You can define additional properties by clicking on the:

  • Quick add properties button to add a series of properties to a model

  • New property to add properties individually to a model.

B. The Relations tab opens a list view of relations associated with the current model.

C. The Permissions tab opens a matrix that shows permissions and roles.

You can specify the create, read, export, update and delete (CRUD) permissions for each role.

D. The Validations tab provides an overview of what kind of validations have been assigned to which property within this model.

Note: These are server-side record create/update validations.

E. The Settings tab provides access for establishing the settings for the model, in this case, the ModelName model.