simple-rag / app /models /message.py
vara201's picture
agentic rag
e8e1f78
Raw History Blame Contribute Delete
1.26 kB
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"
)