Get started for free
Features
Database and API-builderVisual developmentIntegrations
Why Directual
For developersFor product ownersFor freelancers and agenciesFor startups
Resources
PricingBlogAcademyDocumentationForum
Legal
Terms of servicePrivacy policy
Directual Academy
Learn the basics

Configuring database structure

← Back to the list of tutorials

Configuring database structure

The database is an essential part of any application. Let’s figure out how it can be configured.

You’ll find a navigation tree to the left. By clicking on data structure we see various objects — the elements of that structure.

Each object contains fields. These fields will be one of these types:

  • simple string;
  • integer number;
  • decimal number,;
  • date;
  • array;
  • JSON;
  • link or array of links to another structure;
  • boolean;
  • file;
  • etc.

Let’s use an example: here we have an object — a book with a few fields, including: title, year, genre and a link to another object, the author where we find a field which is an array of links to several more objects—his other books.

Now let’s create and configure a new data structure. We choose the folder in the tree and click the “New data structure” button, then we select the parent folder and enter the name. There it is—a new, empty structure. Now we have to configure its fields. Click the button and there’s only one field — ID. This obligatory field is the key to the object.

We can add as many fields as we like and organise them in groups. If we add a ‘type of link’ field, we should choose a data structure to connect it to. Fine. Now we’ve configured the fields, let’s add an object. Note that the value in the type of link field should be the ID of the object to be connected to. The ID often looks like a number. To make it more descriptive, we should go to the structure fields configuration and set up a visible name.

A data structure can contain thousands of objects. To find the one we need we have to use filtering. That’s where we can compose a logical expression using the data structure fields.

← Back to the list of tutorials

Have questions? Visit our community forum.