⟵ hearthere ⟶
  • Quick start
  • Install MIT
  • Install PRO
  • Updating
  • Optimization
  • Update v4-v6
  • Backups
  • Console utility bin/totum
  • Basics for users
  • Interface and Layout
  • Tables and their parameters
  • Prefilter
  • Fields and their parameters
  • Syntax
  • Code, actions, formatting
  • Relational relationships
  • Calculation order and calculation units
  • Auto-complete calculations and timing
  • Duplicate rows and cycles
  • Comparisons
  • Functions
  • Debugging
  • Print and CSV
  • API
  • Roles and users
  • Notifications
  • Scheduled Actions
  • System tables
  • General structure
  • System Tables Section
  • Basic tables
  • List of Tables
  • Table Composition
  • Tree
  • Calculation Table Versions
  • Table Versions in Cycles
  • Settings
  • User Settings
  • Trees
  • Anonymous tables
  • External Forms
  • Exporting and importing tables
  • [PRO] MeiliSearch
  • [PRO] Databases
  • [PRO] Custom CSS
  • [PRO] Custom docs
  • [PRO] LDAP AD
  • [PRO] File versions
  • [PRO] List-unsubscribe
  • [PRO] Dynamic fields
  • [PRO] Only Office
  • [PRO] Auth Tokens
  • [PRO] 2FA
  • [PRO] Superlang
  • [PRO] Daemons
  • [PRO] Profiler
  • Connecting functions
  • [SRV] Installation and Connection
  • [SRV] Export, PDF, Upload, and Preview
  • [SRV] XLSX/DOCX Generators
  • System tables

    General structure

    System Tables Section

    Main

    —— Tables and Fields

    ——— ☆ List of Tables

    ——— ★ Table Composition

    ——— 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

    ——— Notification Codes

    ——— Adding Notification (arbitrary text notification)

    —— API

    ——— Remotes

    —— Charts

    ——— Charts

    —— Settings and Cron

    ——— Settings

    ——— Crons

    —— PRO Forms

    ——— TTM Forms

    PRO Import/Export

    —— Import/Export

    Access

    —— Users

    —— Roles

    —— Authorizations (time-login-ip-status)

    —— Users online (by last activity)

    —— User Log (user actions in the system)

    Basic tables

    List of Tables

    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 ⟶

    Table Composition

    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 ⟶

    Tree

    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.

      • If you specify a parent folder for the Label similar to the location
    • 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.

    • Linkurl for the link type.

    • Order — the order of sorting sections (left-to-right) and folders (top-to-bottom).

    Calculation Table Versions

    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.

    Table Versions in Cycles

    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.

    Settings

    • 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_csscustom CSS for the PRO version.

    • h_held_fieldsfield 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.

    User Settings

    • 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.