Fork me on GitHub

Table structure

Creating and changing the table is performed in the same dialog that contains parameters of the table and the list of its fields. Let’s take a look at table parameters first.

Name - table name.
Comment - table comments. You can put a longer description of the table here.
Alias - specify the real name of the table in the database. This may be needed if you wan to refer to this table from other scripts and if you want to work with the database directly. If you do not see this field, you should enable aliases at the Administrator - Settings page by turning on the Show alias option.
Hierarchical data - enable this option if you want hierarchical table structure. If on, each table element can contain other elements.

List of table fields

Then you can see a list of table fields. At any moment you can add new fields and remove those you don’t need anymore. You can also change field order used to display columns in the list or to display fields in the record cards. The order of fields can be changed with simple drag-n-drop of the corresponding lines in the list.

Now let’s review field parameters of a table. You can create as many fields are you need. You can also change parameters including the data type of the existing fields. Note that if the data type is changed, values of the existing records will be converted automatically. For example, if you had a string type 128-symbol long field, and you changed the string length to 64, all existing strings in that field will be cut to 64 symbols. The information beyond that limit is lost and cannot be recovered with backwards conversion.

Name - field name. This name entitles the corresponding column in the list and is used as the name of a parameter in the card.
Comment - comments to the field. You can supply a more thorough description of this field purpose.
Type - this is a main parameter, it defines the data typo of this field. Then, additional parameters follow, they are different for different data types. You can read description of all data types and their parameters on the Data types page.
Visible column - enable this option if you want to make this column visible when you review the table. Otherwise, this field will only be available in the card during adding or editing.
Alignment - if the previous option is on, you can specify alignment for the value displayed in the column.
Alias - you can specify a real name of the table column. This is useful if you want to refer to this column from other scripts and to directly work with the database. If you do not see this parameter, you should enable aliases on the Administrator - Settings page by turning on the Show alias option.