The Tables

Tables are a set of values positioned within a grid where columns are fields and rows are data.

The number of columns is always known, while the number of rows (data records) varies according to the data entered by users.

The table cannot have two columns with the same name and there cannot be two tables with the same denomination within the same database. Furthermore, Nios4 limits available choice to avoid creating tables that would conflict with the correct functioning of the system.

The tables are the basis of the program; indeed, user data and program settings are all saved within them.

The role and possible hierarchy of data are decided by the user based on his / her needs. For example: the client table will be visible within a section to make it accessible, while any additional tables will only be visible by opening a specific data sheet.

The management of the tables is found in the Options section on the Tables page.

Within the grid it is possible to quickly view and modify the permissions and labels of the tables. To confirm these changes, you must remember to save using the appropriate button located at the top right.

Table name

Indicates the unique name of the table.

Displayable

Modifies whether a user can see the data in the table or not.

Editable

Modifies whether a user can change the data in the table or not.

Synchronize

Synchronization is used to inform the server that it must receive and send the table to all devices.

Display based on user

View by user informs the program that data will be synchronized with the server, but users will only be able to see data that have been explicitly associated with them via the list for this purpose within the data sheet.

Label

The label of the table.

New label

The table label used when creating a new data sheet.

By changing the viewing and editing permissions, all fields in the table will inherit the new settings. To set the permissions of a single field, it has to be acted on individually through the designated management page.

Adding a table

To add a new table, press the Add button and enter the name you want to give it. The program will check that it is valid and that another table with the same name does not already exist.

After creation, the program will automatically open the screen for entering the fields. Remember that the table can exist even without defined fields, although it is of no use.

Deleting a table

To delete a table: select it from the grid and press the Delete button.

Before proceeding, the program will check if this table is not being used in other contexts. If it is used by other tables or other fields, it cannot be deleted. First you need to check that the table is not referenced within other management objects.

Duplicating a table

To duplicate the table, and therefore all its fields, press the Duplicate Table button.

The program will ask you to enter the new name and, if this is deemed valid, will proceed to perform the duplication. If there is a table with the same name as the original plus the suffix "_rows", Nios4 will ask if you want to create a copy of this too.

Export a table

Exporting the table allows you to create a package that can be installed in another database.

Upon selecting Export, the program will ask where to save the package and what type of export to perform. Together with the chosen table, it is possible to export all the objects connected to it, so as to ensure correct operation within the destination database.

Once the package has been created it will only be possible to install it on other databases if the seeds of the two are equal.

Diagrams

You can also view the tables and the relationships between them in the form of a diagram.

The blue box shows the currently selected table. The green boxes are the additional tables, while the red ones are the tables linked through the Sub-table field (the wording in square brackets).

By clicking on the various elements it will be possible to recall their operating parameters.