Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The many-to-many table is a table describing how two tables are linked with each other. You can find a typical example of such a linkage on the screenshot below:



FieldTypeDescription
NameStringRelationship name.
Source column
From tableReference
The
Reference to the table containing the column to bind with another one specified in the To column name field.
From column nameStringSpecify the column to bind with another one. Use the system name of the column taken from the column properties.
From column labelStringSpecify the column label (it may differ from the column title).
Target column
To tableReference
The
Reference to the table containing the column to bind with another one specified in the From column name field.
To column nameStringSpecify the column to bind with another one. Use the system name of the column taken from the column properties.
From column labelStringSpecify the column label (it may differ from the column title).



From column name and To column name это тип связей многие ко многим, например, у нас есть много пользователей, и есть много групп, пользователь может быть во многих группах, и группа может включать любых польхзователей. From column name and To column name - они будут содержать зачастую sys_id колонки тех таблиц, которые нам надо связать.

...