import uuid from datetime import datetime from sqlalchemy import ( String, Text, DateTime, ForeignKey ) from sqlalchemy.orm import ( Mapped, mapped_column, relationship ) from app.models.base import Base class Message(Base): __tablename__ = "messages" id: Mapped[str] = mapped_column( String, primary_key=True, default=lambda: str( uuid.uuid4() ) ) chat_id: Mapped[str] = mapped_column( String, ForeignKey( "chats.id", ondelete="CASCADE" ) ) role: Mapped[str] = mapped_column( String(20) ) content: Mapped[str] = mapped_column( Text ) citations: Mapped[str | None] = mapped_column( Text, nullable=True ) trace_id: Mapped[str | None] = mapped_column( String, nullable=True ) steps_data: Mapped[str | None] = mapped_column( Text, nullable=True ) created_at: Mapped[datetime] = mapped_column( DateTime, default=datetime.now ) chat = relationship( "Chat", back_populates="messages" )