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 structure 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 with option "Create table".

Another dialogue opens. Click (1) "Set field name as SQL column name in fields" and (2) "Create SQL" there. After that, the field "SQL statements" below (3) is filled automatically. Use (4) "Execute SQL" 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).