from datetime import datetime from sqlmodel import SQLModel, Field class Conversation(SQLModel, table=True): """Chat session container. One row per user conversation.""" id: int | None = Field(default=None, primary_key=True) user_id: str = Field(foreign_key="user.id", index=True) created_at: datetime = Field(default_factory=datetime.utcnow) updated_at: datetime = Field(default_factory=datetime.utcnow) class Message(SQLModel, table=True): """Single turn in a conversation. role is 'user' or 'assistant'.""" id: int | None = Field(default=None, primary_key=True) conversation_id: int = Field(foreign_key="conversation.id", index=True) user_id: str = Field(foreign_key="user.id", index=True) role: str = Field(default="user") # "user" | "assistant" content: str created_at: datetime = Field(default_factory=datetime.utcnow)