webapp/app/models/order_event.py

from sqlalchemy import Column, BigInteger, String, Text, DateTime, func
from app.core.database import Base

class VasOrderEvent(Base):
    __tablename__ = "vas_order_events"

    id = Column(BigInteger, primary_key=True, autoincrement=True)
    order_no = Column(String(100), nullable=False)
    event_title = Column(String(255), nullable=False)
    event_message = Column(Text)
    email_uid = Column(BigInteger, nullable=False, unique=True)
    event_time = Column(DateTime)
    created_at = Column(DateTime, nullable=False, server_default=func.now())