...
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:
| Field | Type | Description |
|---|---|---|
| Name | String | Relationship name. |
| Source column | ||
| From table | Reference | |
| Reference to the table containing the column to bind with another one specified in the To column name field. | ||
| From column name | String | Specify the column to bind with another one. Use the system name of the column taken from the column properties. |
| From column label | String | Specify the column label (it may differ from the column title). |
| Target column | ||
|---|---|---|
| To table | Reference | |
| Reference to the table containing the column to bind with another one specified in the From column name field. | ||
| To column name | String | Specify the column to bind with another one. Use the system name of the column taken from the column properties. |
| From column label | String | Specify 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 колонки тех таблиц, которые нам надо связать.
...