Foreign Key sometimes not properly work

[waseemjaved755]

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 UserInterview(SQLModel, table=True):
    id: uuid.UUID = Field(default_factory=uuid.uuid4, primary_key=True, index=True)
    user_info: Dict[str, str] = Field(sa_column=Column(JSON))
    vapi_id: int
    video_link: str = Field(sa_column=Column(Text))
    thumbnail_url: Optional[AnyUrl] = Field(sa_column=Column(Text))
    processedTranscript: Optional[dict] = Field(sa_column=Column(JSON))
    transcript: str = Field(sa_column=Column(Text))
    interview_id: uuid.UUID = Field(foreign_key="interview.id")

Description

Creating a model and sometimes, foreign key doesn’t work

Operating System

macOS

Operating System Details

Mac 2020

SQLModel Version

current

Python Version

3.9

Additional Context

No response