— Main
—— Tables and Fields
——— ☆ List of Tables
——— Table Categories (table categories indicated in the List of Tables
)
——— Tree
——— Versions of Calculation Tables
——— Versions of Tables in Cycles
—— Templates
——— Print Templates
—— Notifications
——— Notifications
——— Adding Notification (arbitrary text notification)
—— API
——— Remotes
—— Charts
——— Charts
—— Settings and Cron
——— Settings
——— Crons
—— PRO Forms
——— TTM Forms
— PRO Import/Export
— Access
—— Users
—— Roles
—— Authorizations (time-login-ip-status)
—— Users online (by last activity)
—— User Log (user actions in the system)
Contains a complete list of tables available in the schema and all their settings.
Adding and editing a table uses the panel of this system table.
Adding a row — creates a table in the schema.
Deletion — leads to the deletion of the table along with all the data stored in it.
Row duplication — allows you to quickly create duplicates of tables with all the fields they contain at the time of duplication.
Settings are described in detail in the documentation section on tables ⟶
The table contains information about all fields in the schema.
Editing field parameters in this table is equivalent to editing directly from the table.
If the target table does not load due to an error in a field, access to the settings of this field can be obtained by calling the field settings
field of this system table for editing.
Field settings are described in the documentation section on fields ⟶
The table defines the structure of the tree schema.
Branch — the name of the section or folder in the section.
Type — type of entry:
Folder
— a folder in which tables can be located.
Link
— arbitrary url. The corresponding link
field must be filled. It is possible to specify roles
for which the links will be visible.
Label
— an additional label to the table. When navigating through it, the values of the specified filters
are substituted (if specified).
The table to which the transition will be made is selected in default_table
.
The filters
field can be filled, in which an array of the name of the prefilters and their values must be passed.
{
"fl_type": [4],
"fl_delay": "true"
}
The specified filters will be locked for changes when navigating through the label.
The used filters can be hidden from the user.
If the parent table is hidden from the tree, the labels will continue to be visible.
In parent_id
, other labels can be selected for labels, in which case a nested structure will be obtained.
It is possible to specify roles
for which the labels will be visible.
The visibility of the label will be determined for the user by the visibility of the parent table.
Hiding the parent table can be overridden if a specific role is selected in roles
.
Parent — parent section or folder.
Section — immutable information field showing the top section.
Default Table — the table that will open when the user navigates to the section.
Filters — transmitted prefilters for the label
type.
html — arbitrary html
for the section. Shown if the default table
is not selected.
Icon — icon. Must be specified from the fontawersome 4
catalog without fa-
— for example, github
.
Roles — roles for which the link or label will be visible.
Link — url
for the link
type.
Order — the order of sorting sections (left-to-right) and folders (top-to-bottom).
This table allows managing table versions within cycles.
The main way to create a new version is to duplicate an existing one, assign it a new name, and then modify the fields.
It is recommended to reflect the status in the version names —
current | development | obsolete
, etc., as the version name is displayed directly in the cycle. This simplifies understanding which version you are making changes to while being directly in the cycle.
Table — the name of the table within the cycle.
Cycle Table — the name of the cycle table that contains the table
.
Order — the sorting order of the table within the cycle, which determines the calculation order.
Version — the name of the table version within the cycle.
Base Version — the version from which the current row's version was duplicated (if it was duplicated).
Default — the version assigned when creating a cycle or when duplicating rows in the cycle table.
Eye Sets — the composition of eye sets for the version in the current row.
Display — the default value for the display order different from the calculation order.
Auto Recalculation — the default value for auto recalculation.
Field List — opens the table composition with the fields of the current table of the current version.
This table defines which calculation table versions are used in a specific cycle.
Table — the name of the calculation table in the cycle for which the version is determined.
Cycle Table — the table of cycles to which the calculation table
belongs.
Order — the sorting order of the calculation table affecting the calculation sequence.
Cycle — the cycle number (id
of the row in the cycle table) for which the version is determined.
Version — the choice of version for the calculation table from the options in Calculation Table Versions.
Automatic Recalculation — determines whether the automatic recalculation for the table in this cycle is enabled when values in related source tables within this cycle are changed.
Display Order — the display order different from the calculation order.
Schema title — the name of the schema.
Main icon — replaces the icon in the upper left corner. Upload a square .png
of moderate size.
favicon — upload a .png
with a square aspect ratio.
title and description — information for the browser.
og_title, og_description, and og_image — information for social systems.
Logging external requests and errors — enables recording in the database without considering transactions of external interactions. Table _bfl
.
Do not enable it just like that — it generates a huge amount of information.
Disable tech banner display for users — disables the display of the technical banner for users.
crypt_solt — encryption key for the string PRO anonymous tables. Assigned randomly during installation.
numbers_format — parameters for the number display format:
{
"decimalSeparator": ",",
"thousandthSeparator": " "
}
dates_format — date display format for the schema in a format similar to dateFormat.
default_email — replaces the sender address for emailSend and notificationSend.
custom_smtp_settings_for_schema — SMTP settings for the schema. Described in emailSend.
h_custom_css — custom CSS for the PRO version.
h_held_fields — field update blocking during update for the PRO version.
h_pro_only_office — connection settings to Only Office.
h_pro_profiling — enables profiling of performed actions in the system for the PRO version.
h_time — interval for tracking password guessing attempts and user lock interval.
error_count — number of incorrect password attempts to trigger the lock.
API users who connect to the system frequently clutter the authorization log table, which slows down subsequent authorizations as it increases the verification time. For such users, there is a mechanism to disable authorization logging in the DB and locking on incorrect password entry. Field
ttm__off_auth_log
in the users table.
with_pass_recover — ability to recover the password via email. Works only if SMTP is configured as described in emailSend.
periodicity — frequency of database queries for each user to check for notifications and table update information.
h_user_settings_buttons — in the Code-action section contains the codes of the system menu buttons when clicking on the user's name.
h_pro_langs — for Superlang the available system languages should be specified as a list ["en","ru"]
.
h_pro_auth_secret — secret generation code for PRO-2FA.
h_pro_auth_message — code for sending a message to the user. If sending via email, SMTP must be configured as described in emailSend.
h_pro_auth_resend_time — resend limit in seconds.
h_pro_auth_live_time — validity limit of the sent code in minutes.
h_pro_auth_on_off — enables PRO-2FA.