webapp/app/models/order.py

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


class VasOrder(Base):
    __tablename__ = "vas_order"

    id = Column(String(128), primary_key=True)
    user_id = Column(String(128), nullable=False)
    product_id = Column(Integer, nullable=False)
    
    product_name = Column(String(100))
    user_name = Column(String(100))
    base_amount = Column(Integer, nullable=False)
    adjustment_delta = Column(Integer, default=0)  
    # 负数 = 优惠，正数 = 加价

    # 订单最终价（冗余字段，方便查询）
    final_amount = Column(Integer, nullable=False)
    
    base_currency = Column(String(10), nullable=False)

    status = Column(
        Enum('pending','paid','completed','closed'),
        default='pending',
        nullable=False
    )

    user_inputs = Column(JSON)

    created_at = Column(DateTime, default=datetime.utcnow)
    updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)