How should the table relationship be?

[ystekno]

class ProductGroup(pc.Model, table=True):
    code: str = None
    name: str


class Product(pc.Model, table=True):
    code: str = None
    name: str
    price = float
    image: str = None
    description: str = None
    is_active: bool = True
    productgroup: ProductGroup

The Product table is related to the ProductGroup table with a foreign key.
The above definition doesn't work!

[Avein]

If you want to create a relationship in SQLmodel you need to specify a foreign key and optionally Relationship attributes. In you example it would be something like this

from sqlmodel import Relationship, Field


class ProductGroup(pc.Model, table=True):
    code: str = None
    name: str
    products: List['Product'] = Relationship(back_populates="product_group")



class Product(pc.Model, table=True):
    code: str = None
    name: str
    price = float
    image: str = None
    description: str = None
    is_active: bool = True
    product_group_id: Optional[int] = Field(default=None, foreign_key="productgroup.id"

    product_group: ["ProductGroup"] = Relationship(back_populates="products")