# -*- encoding: utf-8 -*- # ----------------------------------------------------------------------------- # @File Name : account_topup_order.py # @Time : 2020/11/24 上午11:20 # @Author : X. Peng # @Email : acepengxiong@163.com # @Software : PyCharm # ----------------------------------------------------------------------------- from sqlalchemy import Column, BigInteger, Integer, String, DateTime, Float, text from sqlalchemy.sql import func from app.model.base import Base from app.model.base import BaseModel import time # class AccountTopupOrder(Base, BaseModel): # """账户探普币充值表""" # __tablename__ = 'account_topup_order' # # id = Column(String(64), primary_key=True) # order_no = Column(String(50), comment='订单号') # transaction_serial_no = Column(String(50), server_default='', comment='交易流水号') # user_id = Column(String(64), comment='用户ID') # amount = Column(BigInteger, comment='订单总额') # order_status = Column(Integer, server_default=text('0'), comment='订单状态:0:未支付,1:已支付,2:已退款') # pay_method = Column(Integer, server_default=text('1'), comment='支付方式:4:探普贝,5:app微信支付,6:支付宝支付,7:苹果支付') # create_time = Column(DateTime(timezone=True), server_default=func.now(), comment='创建时间') # pay_time = Column(DateTime(timezone=True), server_default=func.now(), comment='付款时间') # complete_time = Column(DateTime(timezone=True), server_default=func.now(), comment='完成时间') # del_flag = Column(Integer, server_default=text('0'), comment='是否删除,0:未删除,1:已删除')