In SimpleOne, data is stored in two forms: tables and records. Tables consist of columns.
Role required: admin. |
To create a table, perform the following steps:
Table attributes allow users to configure tables and connect them to other tables.
Attribute | Mandatory | Description | ||
---|---|---|---|---|
Title | Y | Specify a table title. The title should be meaningful and human-readable like Incident or Known Error. You can use Latin or Cyrillic letters, [0..9] numbers, and the underscore symbol ( _ ). Unlike the Name field, the values from the Title field can be translated to other languages. When filling in the Title field, the Name field is populated automatically with a corresponding value and prefix. | ||
Name | Y | This field is populated automatically with a system table name. The table name should be unique and meaningful. You can use symbols are Latin letters, [0..9] numbers, and the underscore symbol ( _ ); the name should start with a letter. System table names are used in scripting. When filling in the Title field, the Name field is populated automatically with a corresponding value and prefix.
| ||
Parent | N | Specify a parent table for this table. All fields of the parent table except for the system fields will be inherited when creating the table. A table can be a parent for another table if its is_extendable attribute is equal to true. | ||
Is Extendable | N | Select the checkbox to make the table extendable (to be a parent for other tables.) For more information, refer to the Table Extension article. | ||
Add Menu Item | N | Select the checkbox to create a new menu category in the Navigation menu, or add the table as a new menu item for an existing menu category. If the checkbox is selected, the Menu Item tab will appear in the Related Lists area. |
Attribute | Mandatory | Description | |
---|---|---|---|
Prefix | N | Define a prefix that will be added at the beginning of every record number in this table. | |
Is VCS Enabled | N | This attribute is responsible for enabling and disabling the table versioning. When the checkbox is selected, changes in the affected table are stored as records in the VCS records (sys_vcs_record) table.
| |
Is Audit | N | When the checkbox is selected, the changes in the affected table are logged to the History (sys_history) table. For more information, refer to the System History section. | |
Record Deletion Logging | N | Select the checkbox so that records deleted from this table are logged to the Record Deletion Log (sys_record_deletion_log) and can be restored. |
The Menu Item tab appears when the Add Menu Item attribute is selected.
Attribute | Mandatory | Description | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Menu Category | Y | Specify a menu category to which the menu item should be related. | ||||||||||||
Menu Item | N | Specify a name of the new menu item. | ||||||||||||
Add Menu Category | N | Select the checkbox if you want to create a new menu category. When selected, the following fields appear:
See the Navigation article to learn more about menu items and categories. |
After a table is created, the following user interface actions appear on the table form: