I want to build a model for many-to-many relationships and its not working. I don't get an error but theres no linked data either

[toxypiks]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

class App_PersonInstitution(SQLModel, table=True):
     __tablename__ = 'app_personadress'
     __table_args__ = {'schema': 'isis'}
     personobjectid: int = Field(default=None, foreign_key='isis.app_person.objectid', primary_key=True)
     institutobjectid: int = Field(default=None, foreign_key='isis.app_institution.objectid', primary_key=True)
     
class App_Person(SQLModel, table=True):
    __tablename__ = 'app_person'
    __table_args__ = {'schema': 'isis'}
    objectid: Optional[int] = Field(default=None, primary_key=True)
    personid: int = Field(sa_column=Column("personid", Integer, unique=True))
    surname: str
    institutions: List[App_Institution] = Relationship(back_populates="persons", link_model=App_PersonAdress)

class App_Institution(SQLModel, table=True):
    __tablename__ = 'app_institution'
    __table_args__ = {'schema': 'isis'}
    objectid: Optional[int] = Field(default=None, primary_key=True)
    institutid: int = Field(sa_column=Column("institutid", Integer, unique=True))
    topinstitutid: int
    itype: int = Field(foreign_key='isis_dd.dd_app_sitetype.code')
    isubtype: int = Field(foreign_key='isis_dd.dd_app_sitesubtype.code')
    persons: List[App_Person] = Relationship(back_populates="institutions", link_model=App_PersonAdress)

Description

What am I doing wrong here? Is there another way to link tables as many-to-many?

Operating System

Linux

Operating System Details

No response

SQLModel Version

0.0.16

Python Version

3.11.7

Additional Context

No response