...
For example, the User and the Group tables may contain many records about users and groups accordingly. A user may be in more than in one group and a group may include any users, So, in this case case .,,,,,,,,
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 |
|---|---|---|
| Source column | ||
| From table | Reference | 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 | 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. |
| 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 колонки тех таблиц, которые нам надо связать.
...