47 lines
1.9 KiB
Python
47 lines
1.9 KiB
Python
"""Модели карточки региона."""
|
|
from datetime import datetime
|
|
|
|
from sqlalchemy import DateTime, ForeignKey, Integer, String, func
|
|
from sqlalchemy.orm import Mapped, mapped_column
|
|
|
|
from app.db.session import Base
|
|
from app.models.enums import LinkType
|
|
from app.models.types import enum_col
|
|
|
|
|
|
class RegionCard(Base):
|
|
__tablename__ = "region_cards"
|
|
|
|
region_id: Mapped[int] = mapped_column(ForeignKey("regions.id", ondelete="CASCADE"), primary_key=True)
|
|
population: Mapped[int | None] = mapped_column(Integer)
|
|
head_user_id: Mapped[int | None] = mapped_column(ForeignKey("users.id"))
|
|
updated_at: Mapped[datetime] = mapped_column(
|
|
DateTime(timezone=True), server_default=func.now(), onupdate=func.now()
|
|
)
|
|
|
|
|
|
class RegionLink(Base):
|
|
__tablename__ = "region_links"
|
|
|
|
id: Mapped[int] = mapped_column(primary_key=True)
|
|
region_id: Mapped[int] = mapped_column(ForeignKey("regions.id", ondelete="CASCADE"))
|
|
type: Mapped[LinkType] = mapped_column(enum_col(LinkType))
|
|
title: Mapped[str | None] = mapped_column(String(200))
|
|
url: Mapped[str] = mapped_column(String(500))
|
|
created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), server_default=func.now())
|
|
updated_at: Mapped[datetime] = mapped_column(
|
|
DateTime(timezone=True), server_default=func.now(), onupdate=func.now()
|
|
)
|
|
|
|
|
|
class RegionCardHistory(Base):
|
|
__tablename__ = "region_card_history"
|
|
|
|
id: Mapped[int] = mapped_column(primary_key=True)
|
|
region_id: Mapped[int] = mapped_column(ForeignKey("regions.id", ondelete="CASCADE"))
|
|
field: Mapped[str] = mapped_column(String(100))
|
|
old_value: Mapped[str | None] = mapped_column(String(1000))
|
|
new_value: Mapped[str | None] = mapped_column(String(1000))
|
|
changed_by: Mapped[int | None] = mapped_column(ForeignKey("users.id"))
|
|
changed_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), server_default=func.now())
|