Configuring tables and connecting them to other tables is possible with the table attributes described below.

Main Area


AttributeMandatoryDescription

Title

Y

A table title. A title is preferred to be sensible and human-readable. Like Incident, or Known Error. The allowed symbols are 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

A system table name. The table name should be unique and inform about the data stored. Allowed symbols are Latin letters, [0..9] numbers and the underscore symbol ( _ ); a 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.

Typically, developers create tables while working on applications and within these applications. In this case, a prefix is added automatically to the system table name. You can specify the default prefix to add in the application settings; this point is highlighted in the Applications article.

Table Naming Policy

The default table naming policy is configured as follows.

  1. For custom tables created within the Simple application, the "c_" prefix is added.
    1. Example: if you create a table and specify the title "table", then the name "c_table" is generated automatically.
  2. For custom tables created within another application, application prefix and client instance prefix are added.
    1. Example: consider that you are creating a table within the ITSM application (generally having the itsm prefix) on your instance. Vendor has provided the instance client prefix for you. The title of the newly created table is "Table". In this case, it will be named as itsm_instance_table.

In table names, elements are connected with the underscore symbol.

The maximum length of the table name is 63 symbols. If the name of the table in a .SOP file is more than 63 symbols, the name is cut during the VCS import to 63 symbols. 

Parent

NA 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

NSelect this checkbox so that the table could be a parent for another table. For more information about this, refer to the Table Extension article for more information.

Add Menu Item

NSelect this checkbox to create a new menu category in the Navigation menu if needed. If the checkbox is selected, the Menu Item tab will appear in the Related Lists area.

Controls Tab


AttributeMandatoryDescription

Number ID

N

This is the reference to the record previously created in the Number (sys_number) table. It defines the parameters of the system number for the records in the related table.

You can read more about the settings of this field in the Autoincrement article.

Is VCS Enabled

N

This attribute is responsible for the table versioning turning on and off. When this checkbox is selected, the changes in the affected table are stored as records in the VCS record (sys_vcs_record) table. Read more about this in the Configuration packs section.

It is impossible to change this attribute value after table creating, so it is necessary to get through this phase carefully.

The list of tables can be modified by setting up the vcs_ignore_tables property. This property specifies system tables that are not included to VCS by default. 

Is Audit

N

This attribute is responsible for the records changes logging to the History (sys_history) table. When this checkbox is selected, the changes in the affected table are logged in the mentioned table. Read more about this in the System History section.

Record Deletion Logging

NSelect this checkbox to enable logging record deletion. Records deleted from this table will be logged to the Record Deletion Log (sys_record_deletion_log) and can be restored.

You can also find a Show schema link in the Related Links area. The dependency map is a UI Action map showing all the tables related to a table which form you opened. Click any table name on the dependency map to open the form of that table.

Menu Item tab 


AttributeMandatoryDescritpion

Menu Category

YSpecify a menu category to which the menu item should be related.

Menu Item

NThe name of the new menu item.

New

N

Select this checkbox if you want to create a new category item. Then the following fields will appear:

Field

Mandatory

Description

New CategoryYDisplayed category title.
OrderYCategory order in the interface (categories are arranged in ascending order).
Menu ItemNThe name of the new menu item.

See the Navigation article to learn more about menu items and categories.

  • No labels