tasklert-api / src /models /conversation.py
hashir-qt's picture
initial deploy
507973e
Raw History Blame Contribute Delete
881 Bytes
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)