Logo
Logo
Reference Guide.en

Reference #

** Menu item properties: **

  • Field ** “Order” ** contains the order of the menu items when displayed to the user.

  • Field ** “Name” ** contains a unique name of the menu item in the database.

  • Field ** “Projection” ** name of the projection that opens when this menu item is selected.

  • Field ** “Title” ** contains the title of the menu item displayed to the user.

  • The field ** “Display template” ** contains the name of the form display template (see p. Values ​​of the field * “View template " *).

  • Field ** “Icon” ** contains the name of the image that will be displayed next to the title of the menu item. For example, from the site Font Awesome

  • Thefield ** “Style” ** contains the name of the CSS class added when this menu item is displayed on the main page.

  • Thefield ** “Role” ** contains the name of the database role for whichshould be this menu itemdisplayed. If not specified, it is displayed for all roles.

  • Field ** “Key” ** contains the record key. Used when binding a menu item to a detailed form.

<! - * Field ** “Parent” ** contains a menu item that is an ancestor of this item. -> ** Menu item links: **

  • Container ** “Menu Items” ** contains a list of menu items that are children for this item.

Schemas #

** Schema properties: **

  • Field ** “Schema name” ** contains the name of the schema in the database.

  • Thefield ** “Title” ** contains the title of the schema displayed to the user.

** Schema links: **

  • Container ** “Entities” ** contains tables and views included in this schema.

  • Container ** “Functions” ** contains user-defined functions belonging to this schema.

Entities #

** Entity properties: **

  • Field ** “Schema name” ** contains the name of the schema, which will own the entity.

  • Field ** “Table name” ** contains the name of the entity in the database.

  • Field ** “Title” ** contains the title of the entity displayed to the user.

  • Field ** “Primary key” ** contains the names of the fields that are part of the primary key.

  • Field ** “Entity type” ** contains the type of the created entity. Filled in automatically. Matter:

      • “Table” * - table;
      • “View” * - view;
      • “Partitioned table” * - partitioned (partitioned) table;
      • “Foreign table” * - external table.
  • Field ** “View Definition” ** contains an SQL query to retrieve data (for views).

** Entity relationships: **

  • Container ** “Projections” ** contains the projections defined for this entity.

  • Container ** “Dependencies” ** contains references to this entity from other entities.

  • Container ** “Columns” ** contains the columns of this entity.

  • Container ** “Triggers” ** contains triggers defined for this entity.

Properties/Columns #

** Column properties: **

  • Parameter ** “Order” ** contains the ordinal number of the column.

    • Immutable field *.
  • The parameter ** “Entity” ** contains the table or view with which this column is associated (for example, by a foreign key).

  • Parameter ** “Column name” ** contains a uniquename columnin the database.

  • The parameter ** “Is the primary key” ** indicates whether the column is part of the primary key or is it.

  • The parameter ** “Header” ** changes the header of the column when displayed in the table.

  • The parameter ** “Type in database” ** indicates the type of output data. The standard types are described in Data Types PostgreSQL. Extended types:

      • “meta.file” * - structured storage of files in the database;
      • “meta.file[]” * - an array of structured file storages in the database.
  • The parameter ** “Type on display” ** changes the appearance of the displayed data (see p. [Values ​​of the field * “Type on display” *](/ abris-lab/abris/-/wikis/tasks/types-of- display-fields-new)).

  • The parameter ** “Visibility” ** enables or disables the display of this column in the table by the user.

  • The parameter ** “Non-editable” ** enables or disables editing of the column data.

  • The parameter ** “Optional” ** enables or disables leaving the column value empty.

  • The parameter ** “Foreign key” ** indicates whether the column is a foreign key. The value “true” has additional fields:

    • The parameter ** “Associated (parent) entity” ** contains the name of the base entity.

    • The parameter ** “Related Entity Key” ** contains the primary key of the underlying entity.

    • Parameter ** “Name of constraint” ** name of the foreign key, if it exists in the database. Virtual keys are notin this field displayed. * Immutable field *.

  • The parameter ** “Default value” ** contains the value that will be displayed if the column value is not filled.

ProjectionsProjection #

**properties: **

  • Field ** “Projection name” ** contains the name of the projection in the database.

  • Field ** “Entity” ** contains the name of the table or view, on the basis of which it is created.

  • Field ** “Primary Key” ** contains the key from the entity in thefield “Transition”, which will be used as the main one.

  • Field ** “Title” ** indicates the title of the projection displayed to the user.

  • Field ** “Projection for transition” ** contains the entity to which thewill transitionbe made when opening the detailed form.

  • Field ** “Basicity” ** is checked if the projection needs to be made basic (by default, the basic projection is created automatically when creating an entity).

  • Field ** “Editing mode” ** indicates parameters ofediting projectionwhen opening a detailed form. The field has values:

      • “By default” * - when opening a detailed form, projection fields can be edited;
      • “On request” * - to switch to edit mode, you must press the button Image [Edit]; to exit edit mode, press the button image [Cancel];
      • “Switchable” * - works similarly to “on demand”, but in edit mode you can switch between records;
      • “Read only” * - non-editable form.

    See the instruction video for details:


  • Golf ** “Tip” ** when it is full, the info window displays when you hover over a column data.

  • Field ** “Additional parameters” ** contains (if necessary) parameters in JSON format that define additional processing for fields.

** Projection links: **

  • Container ** “Dependencies” ** contains a list of links to this projection from other projections.

  • Container ** “Properties” ** contains a list of columns of this projection.

  • Container ** “Buttons” ** contains a list of user-created buttons for this projection.

Projection properties #

** Properties of properties: **

  • Parameter ** “Order” ** contains the ordinal number of the column.

  • The parameter ** “Projection name” ** contains the name of the projection in the database to which the property belongs.

  • Parameter ** “Column name” ** contains a uniquename columnin the database.

  • The parameter ** “Title” ** indicates the column title displayed to the user.

  • The parameter ** “Type on display” ** changes the appearance of the displayed data (see p. [Field values ​​* “Type on display” *](/ abris-lab/abris/-/wikis/abris-lab/abris/-/wikis/tasks/types-of-display-fields-new)).

  • The parameter ** “Visibility” ** enables or disables the display of this column in the table by the user.

  • The parameter ** “Non-editable” ** enables or disables editing of the column data.

  • The parameter ** “Optional” ** enables or disables leaving the column value empty.

  • The parameter ** “Foreign key” ** indicates whether the column is a foreign key. The value “true” has additional fields:

    • The parameter ** “Associated entity” ** contains the name of the base entity. * Immutable field *.
    • The parameter ** “Associated projection” ** contains the name of the projection of the base entity.
    • The parameter ** “Reference Key” ** contains the primary key of the underlying entity.
  • The parameter ** “Virtual” ** contains a flag if the column is virtual:

    • The parameter ** “Initial projection” ** contains the name of the projection connected to the projection specified in the field * “name Projection” *.
    • The parameter ** “Initial name of the column” ** contains the name of the field containing data from the original projection. This data will be displayed in the created virtual columns.
  • The parameter ** “Show in links” ** enables the display of thevalue columnin drop-down lists.

  • The parameter ** “Attachment” ** when displayed, unites this column with the previous one in accordance with the meaning of the field * “Order” *.

  • The parameter ** “Default value” ** contains the value that will be displayed if the column value is not filled.

  • The parameter ** “Hint” **, when filled, displays awindow hintwhen hovering over the column data.

  • The parameter ** “Pattern to check” ** contains a regular expression for checking the value entered in the field. More details in [ValidationValidation Regular Expression](https://developer.mozilla.org/ru/docs/Learn/Forms/Form_validation#Regular Expression).

  • The parameter ** “Additional parameters” ** contains (if necessary) parameters in JSON format that define additional processing for the fields.

Relations/Constraints #

** Properties of constraints: **

  • Parameter ** “Title” ** contains the title of the constraint displayed to the user.

  • The parameter ** “Parent entity” ** contains the name of the base entity.

  • The parameter ** “Parent entity key” ** contains the primary key of the underlying entity.

  • The parameter ** “Child entity” ** contains the name of the dependent entity to which the foreign key belongs.

  • The parameter ** “Child entity key” ** contains the name of the field containing the foreign key.

  • The parameter ** “Virtual relation” ** indicates whether the foreign key is virtual.

Projection relationsDependency #

**properties: **

  • Parameter ** “Order” ** contains the serial number of the dependency.

  • The parameter ** “Title” ** indicates the title of the container (dependencies) displayed to the user.

  • The parameter ** “Parent entity” ** contains the entity whose projections contain the container.

  • The parameter ** “Projection of the parent entity” ** contains the name of the projection of the entity that contains the container (dependency). * One entity can have several projections *.

  • The parameter ** “Key of the parent entity” ** contains the primary key of the parent entity.

  • The parameter ** “Child entity” ** contains the entity, the projection of which is displayed in the container of the parent projection.

  • The parameter ** “Projection of child entity” ** contains the name of the projection of the entity displayed in the container.

  • The parameter ** “Key of child entity” ** contains the primary key of the child entity.

  • The parameter ** “Visibility” ** enables or disables the display of this container (dependencies) for the user.

  • The parameter ** “Non-editable” ** enables or disables editing of container fields (dependencies).

  • The parameter ** “Openness” ** in the value “true” willcontainer expand thewhen opening the detailed form.

  • The parameter ** “Display template” ** contains the name of the form display template (see p. [Field values ​​* “View template /template Display” *](/ abris-lab/abris/-/wikis/tasks/view-template -fields-new)).

  • The parameter ** “Hint” ** when it is filled, displays awindow hintwhen you hover over the header of the container.

  • The parameter ** “Additional parameters” ** contains (if necessary) parameters in JSON format that define additional processing for dependencies.

User definded functions


** Properties of a user-defined function: **

  • Field ** “Schema name” ** contains the name of the schema in which the function will be located.

  • Field ** “Function name” ** contains the name of the user-defined function in the database.

  • Field ** “Data type of return value” ** contains the data type of the value returned by the function in accordance with:

    • data types PostgreSQL;

      • “meta.file” * - structured storage of files in the database;
      • “meta.file[]” * - an array of structured storage of files in the database;
    • trigger, event\ _trigger - more details in 42.9.trigger procedures PostgreSQL;

    • string variable - an indication of the entity, the type of which will bevalue used as a return. More details in 42.3.4. types Tuple;

    • record - the type of a string variable without a specific structure. More details in 42.3.5.type Record.

  • Field ** “Function parameters” ** contains a list of input values ​​of the function with an indication of the data type in accordance with:

    • data types PostgreSQL;

      • “meta.file” * - structured storage of files in the database;
      • “meta.file[]” * - an array of structured storage of files in the database;
    • string variable - an indication of the entity, the type of which will bevalue used as a return. More details in 42.3.4. Types Tuple.

  • Field ** “Function definition” ** contains the program code of the function in PL/pgSQL.

** Custom function links: **

  • Container ** “Triggers” ** contains triggers that use this function.

Triggers #

** Trigger properties: **

  • Field ** “Entity” ** contains the entity that owns the trigger.

  • Field ** “Trigger Name” ** contains a uniquename triggerin the database.

  • Field ** “Function” ** contains the name of the function called when the trigger is fired.

  • Field ** “Active” ** contains the current state of the trigger: on/off.

  • Field ** “For each row” ** in the “set” state means that the trigger is called once for each row.

  • Field ** “Trigger type” ** contains the moment when the trigger is fired: before the operation (BEFORE), after the operation (AFTER), instead of the operation (INSTEAD OF).

  • Field ** “Events” ** contains operations that trigger the trigger: insert (INSERT), update (UPDATE), delete (DELETE), clear the table (TRUNCATE).

Buttons #

** Button properties: **

  • Field ** “Identifier” ** contains a unique name for the button.

  • Field ** “Projection name” ** contains the name of the projection in which the button is located.

  • Field ** “Title” ** contains the title of the button displayed to the user.

  • Field ** “Scheme name” ** contains the name of the circuit for which the function will work.

  • Field ** “Function” ** contains the name of the function that will be executed when the button is pressed.

  • The field ** “Use in the list” ** contains a sign for identifying the button as an element of the list (tabular form).

  • Field ** “Button Icon” ** contains the name of the image that will be displayed on the button along with the title.

Entity types #

** Entity type properties: **

  • Field ** “Type” ** contains entity type name.

  • Field ** “Name” ** contains a description (title) of thetype entity.

** Entity type relationships: **

  • Container ** “Entities” ** contains a list of entities that have the specified type.

Creation, editing and deleting of entity types is not available.

Function return value types


** Properties of the data type of functions: **

  • Field ** “Data type” ** contains the name of the data type.

** Function data type associations: **

  • Container ** “Type in functions” ** contains a list of functions that have the specified data type.

Creation, editing and deletion of data types of functions is not available.

Property data types #

** Type properties of these properties: **

  • Field ** “Data type” ** contains the name of the data type.

** Property data type links: **

  • Container ** “Type in columns” ** contains a list of columns having the specified data type.

Creating, editing and deleting property data types is not available.

System options #

** System settings properties: **

  • Field ** " Option name “** contains the name of the system parameter.

  • Field ** “Option value” ** contains the value of the system parameter.

Type matchingType matching #

**properties: **

  • Field ** " The type in the database “** contains the identifier of the data type.

  • Field ** “Display type” ** contains the name of the corresponding display type.

Users/Users #

** User properties: **

  • Field ** “Username” ** contains the login of the user account in the program.

  • Thefield ** “Password” ** contains the password for the user account. The password is not visible to the administrator.

  • Field ** “Password expiration” ** contains the date until which thecan userlog in using the specified password. If there is no value in this field, the validity period is unlimited. …

  • Field ** “User active” ** indicates whether theis locked for login user account. The account can be locked in the “User locked” field or when theexpires password(automatically). * Immutable field *.

  • Field ** “User blocked” ** allows you to forcibly block a user account. If the user is blocked, then the value “true” is indicated opposite the field, and thefield “User is active"automatically takes the value “false”.

  • The field ** “User rights” ** contains the user’s permissions on. The field has the following values:

      • “Role creation” * - the right to create user roles;
      • “Inheritance” * - the right to inherit the rights of the roles specified in the “Belongs to groups” container;
      • “Database creation” * - the right to create databases;
      • “Ignore RLS” * - the right to ignorepolicies securityat the row level.

    Detailed description in Creating roles.

Связи пользователя:

  • Контейнер “Владелец сущностей” содержит перечень сущностей, созданных пользователем.

  • Контейнер “Принадлежит группам” содержит перечень групп, в которые включен пользователь.

  • Контейнер “Права” содержит перечень сущностей и права, которые имеет пользователь на каждую сущность.

Groups/Группы #

Свойства группы:

  • Поле “Наименование группы” содержит наименование группы в базе данных. Подробнее в Роли базы данных.

Связи группы:

  • Контейнер “Дочерние группы” содержит перечень групп, имеющих членство в данной группе.

  • Контейнер “Родительские группы” содержит перечень групп, членство в которых имеет данная группа.

  • Контейнер “Дочерние пользователи” содержит перечень пользователей, использующих права данной группы.

  • Контейнер “Права” содержит перечень сущностей и права, которые имеет группа на каждую сущность.

  • Контейнер “Политики RLS” содержит перечень политик защиты строк, ограничивающих для пользователей наборы строк, которые могут быть возвращены обычными запросами или командами, изменяющими данные. Подробное описание в Политики защиты строк.

Значения поля “Type on display/Тип при отображении” #


Значение Описание


time Время Циферблат для ввода времени.

progress Горизонтальный индикатор Индикатор выполнения процесса.

invisible Скрытый Скрывает поле на интерфейсе.

code-sql SQl код Текстовое поле с подсветкой синтаксиса SQl

code-js JS код Текстовое поле с подсветкой синтаксиса JS

File on disk (single) Загрузка файла на диск сервера. Старый файл заменяется новым.

File on disk (multiply) Загрузка файла на диск сервера. Хранение нескольких файлов.

Image on disk (single) Загрузка изображения на диск сервера. Старое изображение заменяется новым. Поддерживается предпросмотр.

Image on disk (multiply) Загрузка изображения на диск сервера. Хранение нескольких изображений. Поддерживается предпросмотр.

File in database (single) Загрузка файла в базу данных. Старый файл заменяется новым.

File in database (multiply) Загрузка файла в базу данных. Хранение нескольких файлов.

Image on database (single) Загрузка изображения в базу данных. Старое изображение заменяется новым. Поддерживается предпросмотр.

Image on database (multiply) Загрузка изображения в базу данных. Хранение нескольких изображений. Поддерживается предпросмотр.

trackbar struckt Ползунок. Изменение значения в процентах или долях.

ref Список Раскрывающийся список. Требуется установленный внешний ключ.

bool Истина или ложь Кнопка с отметкой в значении “истина” или “ложь”.

plain Текст без форматирования Многострочный текст.

statictext Статический текст Неизменяемый текст.

date Дата Календарь для ввода числа, месяца и года.

integer Целочисленное Переключатель для ввода целых чисел.

monthyear Год-месяц Календарь для ввода месяца и года.

datetime Дата и время Календарь и циферблат для ввода даты и времени.

uint8h Номер пункта Элемент для ввода нумерованных многоуровневых списков.

string Строковые значения Стандартное поле ввода текстовых значений.

passwordinput Ввод пароля Вместо вводимых символов отображаются другие символы.

checkbox-group Кнопка с отметкой. Позволяет выбрать несколько вариантов из группы опций. При выборе в базу данных сохраняет текстовые значения.

checkbox-group-idx Кнопка с отметкой. Позволяет выбрать несколько вариантов из группы опций. При выборе в базу данных сохраняет индексы значений.

radiobutton Радиокнопка. Выбор одного из группы взаимоисключающих. При выборе в базу данных сохраняет текстовые значения.

radiobutton-idx Радиокнопка. Выбор одного из группы взаимоисключающих. При выборе в базу данных сохраняет индексы значений.

json Формат JSON Редактор JSON

text Форматированный текст Форматированный текст. Позволяет вводить текст и изменять размер, начертание, положение и другие параметры. #

Значения поля “View template/Шаблон отображения” #

Значение Описание


chart Диаграмма dashboard Приборная панель datamap Карта datamaplist Карта с табличной формой detail Детальная форма list Табличная форма treedetailed Дерево treecrossdetailed Дерево с классификаторами