If phase 4 is activated, you already know about the option of automatically creating a database node with fields in the target structure for existing database tables (via the context menu of the target structure).

If phase 4 is activated, you also have the option to proceed the other way. That is, you can create a node with fields in the target structure and then automatically create a table in an integrated HSQL database (with fields that match the fields in your target node). This is a convenient and intuitive way to build a database structure for your profile in the background. In addition, you do not have to worry about access rights or asking your database administrator for resources. The administrator simply does not need to get involved, since you only use internal data structures for which you already have all the necessary access rights (if you have them).

The following section describes the procedure for creating an HSQL node (and thus an HSQL table).

Create a new node with any number of fields in the target structure.

Select the database alias hsql in the attributes of target node Node. This alias is already available by default.

Then you can use the context menu of the node Node to generate an HSQL table.

Another dialogue opens. Click (1) and (2) there. After that, (3) is filled automatically. Use (4) to complete the process.

You have now created a functional HSQL table and your node Node with its fields is connected to it (via the node and field attributes as you know it from 'normal' database nodes).