# models.py

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

class VisitorPageView(Base):
    __tablename__ = "visitor_page_views"

    id = Column(Integer, primary_key=True, index=True)
    visitor_id = Column(String(50), index=True)
    client_widget_id = Column(String(50), index=True)
    page_url = Column(Text)
    page_title = Column(String(255))
    created_at = Column(DateTime, server_default=func.now())


class VisitorActivity(Base):
    __tablename__ = "visitor_activity"

    id = Column(Integer, primary_key=True, index=True)
    visitor_id = Column(String(50), unique=True, index=True)
    current_page = Column(Text)
    last_active = Column(DateTime, server_default=func.now(), onupdate=func.now())
    timestamp = Column(BigInteger)    # JS timestamp (ms)