follow relationship, multiple fields point to the same model

[DerekDekker]

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

from typing import Optional
from datetime import datetime

from sqlalchemy import UniqueConstraint
from sqlmodel import Field, SQLModel


class FollowersBase(SQLModel):
    id: Optional[int] = Field(default=None, primary_key=True)
    following: Optional[int] = Field(nullable=False, foreign_key="user.id")
    followers: Optional[int] = Field(nullable=False, foreign_key="user.id", )


class Followers(FollowersBase, table=True):
    ...


class FollowersRead(FollowersBase):
    ...

Description

user: Optional[User] = Relationship(back_populates="")

How do I fill this in? I have two fields pointing to user.
Thank you for your help

Operating System

macOS

Operating System Details

No response

SQLModel Version

0.0.8

Python Version

Python 3.10.8

Additional Context

No response

[enchance]

Did you ever find the answer? Have the same problem.