Creating an HSQL Table

If phase 4 is activated, you already have the option of automatically creating a database node with fields in the destination structure of Lobster_data for existing database tables (via the context menu of the destination 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 destination structure and then automatically create a table in an integrated Lobster_data HSQL database (with fields that match the fields in your destination 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 data structures within Lobster_data 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 destination structure.

Select the database alias hsql in the attributes of destination node Node. This alias is already available in Lobster_data 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).