Schema management

PermeAgility provides for dynamic management and setup of tables and groups of tables. Click the Tables menu item to open it.

To create a new table, click the New table... link at the bottom of the page, it wii show up in the Ungrouped list until you assign it to a table group.

The schema page shows all the tables in the database organized by Table Group - which is a table in the database so if you want to organize tables differently, go ahead and edit the rows in the Table Group (tableGroup) table.

In the list of tables, you can also put the minus (-) sign in front of the table to hide it (if a table is hidden in any table group for the user, it will not show up in the ungrouped list)

A table can appear in multiple table groups.

For details on how to create tables, see Table management