| from sqlalchemy import ForeignKey, String
|
| from typing import TYPE_CHECKING
|
| from sqlalchemy.orm import Mapped, mapped_column, relationship
|
| from ..database.db import Base, TimestampMixin
|
|
|
|
|
| class Profile(Base, TimestampMixin):
|
| """SQLAlchemy model for user profile information."""
|
|
|
| __tablename__ = "profile"
|
|
|
| id: Mapped[int] = mapped_column(primary_key=True, autoincrement=True)
|
| user_id: Mapped[int] = mapped_column(
|
| ForeignKey("user.id"), nullable=False, index=True, unique=True
|
| )
|
| phone: Mapped[str | None] = mapped_column(String(13), nullable=True)
|
| avatar: Mapped[str | None] = mapped_column(String, nullable=True)
|
| bio: Mapped[str | None] = mapped_column(String(255), nullable=True)
|
| topic_preferences: Mapped[str | None] = mapped_column(String(1024), nullable=True)
|
|
|
| if TYPE_CHECKING:
|
| from .user import User
|
|
|
| user: Mapped["User"] = relationship("User", back_populates="profile")
|
|
|
| def __repr__(self) -> str:
|
| return f"Profile(id={self.id}, user_id={self.user_id}, avatar={self.avatar}, bio={self.bio})" |
