| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889 |
- 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"
- __ddl__ = """
- CREATE TABLE IF NOT EXISTS `vas_order` (
- `id` VARCHAR(128) NOT NULL,
- `user_id` VARCHAR(128) NOT NULL,
- `product_id` INT NOT NULL,
- `product_name` VARCHAR(100) NULL,
- `user_name` VARCHAR(100) NULL,
- `base_amount` INT NOT NULL,
- `adjustment_delta` INT NOT NULL DEFAULT 0,
- `final_amount` INT NOT NULL,
- `base_currency` VARCHAR(10) NOT NULL,
- `status` ENUM('pending', 'paid', 'completed', 'closed') NOT NULL DEFAULT 'pending',
- `channel_type` VARCHAR(32) NOT NULL DEFAULT 'direct' COMMENT 'direct:社交自收直客, agency:中介渠道, website:官网公海',
- `agency_id` VARCHAR(64) NULL COMMENT '中介机构ID',
- `handler_id` VARCHAR(128) NULL COMMENT '40%销售提成对接人ID',
- `developer_id` VARCHAR(128) NULL COMMENT '20%技术版权脚本开发者ID',
- `settlement_status` VARCHAR(32) NOT NULL DEFAULT 'unsettled' COMMENT '结算状态: unsettled, risk_period, eligible, settled',
- `completed_at` DATETIME NULL,
- `risk_cleared_at` DATETIME NULL,
- `settlement_period_id` VARCHAR(32) NULL,
- `user_inputs` JSON NULL,
- `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
- `updated_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- PRIMARY KEY (`id`),
- INDEX `idx_vas_order_user_id` (`user_id`),
- INDEX `idx_vas_order_product_id` (`product_id`),
- INDEX `idx_vas_order_status` (`status`),
- INDEX `idx_vas_order_handler_id` (`handler_id`),
- INDEX `idx_vas_order_settlement_status` (`settlement_status`),
- INDEX `idx_vas_order_completed_at` (`completed_at`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='主订单表';
- """
- 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
- )
- # 渠道来源: direct(社交自收直客), agency(中介渠道), website(官网公海)
- channel_type = Column(
- String(32),
- default='direct',
- nullable=False
- )
- # 中介机构ID (仅中介单时有值)
- agency_id = Column(String(64), nullable=True)
- # 40%销售提成对接人 (直客为录单对接人,中介单为该中介拓展人,公海单为NULL)
- handler_id = Column(String(128), nullable=True, index=True)
- # 20%技术版权脚本开发者ID
- developer_id = Column(String(128), nullable=True)
- # 结算状态: unsettled(未结算), risk_period(风险期冻结), eligible(待结算), settled(已结算)
- settlement_status = Column(
- String(32),
- default='unsettled',
- nullable=False,
- index=True
- )
- completed_at = Column(DateTime, nullable=True)
- risk_cleared_at = Column(DateTime, nullable=True)
- settlement_period_id = Column(String(32), nullable=True)
- user_inputs = Column(JSON)
- created_at = Column(DateTime, default=datetime.utcnow)
- updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
|