Spaces:
Sleeping
Sleeping
File size: 1,401 Bytes
6ea020b | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 | # app/models/geography.py
# Province and Region models.
from typing import Optional
from datetime import datetime
from sqlmodel import SQLModel, Field, Relationship
class Province(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
province_name: str = Field(unique=True, index=True)
is_active: bool = Field(default=True)
created_by: Optional[int] = Field(default=None, foreign_key="user.id")
created_at: datetime = Field(default_factory=datetime.now)
edited_by: Optional[int] = Field(default=None, foreign_key="user.id")
edited_at: Optional[datetime] = None
deleted_by: Optional[int] = Field(default=None, foreign_key="user.id")
deleted_at: Optional[datetime] = None
class Region(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
region_name: str = Field(unique=True, index=True)
province_id: int = Field(foreign_key="province.id")
is_active: bool = Field(default=True)
created_by: Optional[int] = Field(default=None, foreign_key="user.id")
created_at: datetime = Field(default_factory=datetime.now)
edited_by: Optional[int] = Field(default=None, foreign_key="user.id")
edited_at: Optional[datetime] = None
deleted_by: Optional[int] = Field(default=None, foreign_key="user.id")
deleted_at: Optional[datetime] = None
province: Province = Relationship()
|