Omission of joining tables

External Data Source
1

Hi,

I am trying to use NocoDB as a simple CRUD-UI for my database. The problem I am currently facing: I have “joining tables” modelling many-to-many relationships, but with additional attributes. Classical example: “person” ↔ “organization”, with “role” as an additional attribute in the joining table (i.e., the joining table has columns “person_id” (PK), “organization_id” (PK) and “role”).

When linking the database to NocoDB, the many-to-many relationship is modelled correctly, but the joining table itself is not shown anywhere and I don’t see a possibility to access the additional attribute (“role”, in the example above).

Is this a bug or intended behaviour, or am i just missing something?

2

Junction/Many-to-many tables are hidden by default as they are just Keys (primary key and foreign key).

These can be made visible by doing the following under base settings.

1 Like