from sqlalchemy import Column, Integer, String, Text, DateTime
from datetime import datetime
from app.core.database import Base


class ChatHistory(Base):
    __tablename__ = "chat_history"

    id = Column(Integer, primary_key=True, index=True)
    session_id = Column(String(100), index=True, nullable=False)
    user_name = Column(String(150), nullable=False)
    employee_id = Column(String(100), nullable=True)
    department = Column(String(150), nullable=True)
    device_name = Column(String(150), nullable=True)
    user_message = Column(Text, nullable=False)
    bot_reply = Column(Text, nullable=False)
    issue_code = Column(String(100), nullable=True)
    issue_title = Column(String(255), nullable=True)
    detected_category = Column(String(100), nullable=True)
    resolution_status = Column(String(50), default="Pending")
    created_at = Column(DateTime, default=datetime.utcnow)