Hi @ludwig,
This is issue is due to the fact that the Forest Admin agent does not handle well tables that have no primary keys defined on a table. If you had defined a composite primary key on this table it would display well.
create table "teamMemberships" (
"teamId" integer references teams on delete cascade,
"userId" integer references users on delete cascade,
"isOwner" boolean not null default false,
unique ("teamId", "userId")
);
-- versus
create table "teamMemberships" (
"teamId" integer references teams on delete cascade,
"userId" integer references users on delete cascade,
"isOwner" boolean not null default false,
primary key ("teamId", "userId")
);
We’ll try to find a patch to support join tables without primary keys.