# app/models/message.py

from app.core.database import Base
from sqlalchemy.orm import relationship
from sqlalchemy import Column, Integer, String, ForeignKey, TIMESTAMP, func, Text

class Message(Base):
    __tablename__ = "messages"

    id = Column(Integer, primary_key=True, index=True)
    client_id = Column(Integer, ForeignKey("clients.id"))
    visitor_id = Column(Integer, ForeignKey("visitors.id"))
    sender = Column(String(20))  # "visitor" or "agent"
    text = Column(Text)
    created_at = Column(TIMESTAMP, server_default=func.now())

    visitor = relationship("Visitor", back_populates="messages")