account_topup_order.py

# -*- 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:已删除')