The schema module allows the user to define new tables and change existing ones. Foreign keys may be defined too.
There are two main types of forms: List forms and detail forms.
A list form has two sections: A search panel, and a result section. In the search section, the user
may enter search parameters. When the user presses the search button, the result will be presented below
the search panel. The search result might be editable. At the bottom of the result section, there are a
row for adding new data.
To create a new form, the user first define which table the form should be based upon. Next the
user define which columns that might be used as parameters in the search panel. If a given column has a
foreign key, the user might pick a column in the related table for presentation.
After the parameter section, the user define which columns that should be presented in the result
section. Related columns (by foreign keys) might be presented here too. The user also define if the
column should be editable, editable only at insert, read only or hidden (advanced use only).
It is also possible to define links. A link is a way for the user to navigate from one row in the list
form to another form. To be able to do this, it need to foreign keys defined, referencing
to the form table. There also need to be an existing form in the related table with the foreign key
columns in the parameter list.
Finally, it is possible for the user to define a detail form corresponding to this list form. If
a detail form is defined, the user might click one row in the list form and get to another form showing
this form in detail.
Using the settings made, a select, update, insert and delete statement will be generated. For advanced
use, it is possible to edit these generated SQL statements.
A detail form is a form showing details about one single row. It is defined in a very similar way as
a list form, but the select query is assumed to only return one single row. This means that the parameter
list need to contain identifying columns.
Two types of charts are currently supported, pie charts and bar charts. Both types of charts needs two
columns of data. For example one row for every single task status containing the status text and
the number of tasks having that status.
The first step when defining a chart is to select a table. Next a number of parameters might be
defined, in the same way as list forms. Next a single column will be selected. This column will be
the grouping criteria for counting the rows in the table.
Similar to list forms, the generated select statement might be edited for advanced use.