class BuyHistory(db.Model):
id_history = db.Column(db.Integer(), primary_key=True, autoincrement=True)
uuid = db.Column(db.String(32), nullable=False)
uid = db.Column(db.Integer(), db.ForeignKey('user.id'), index=True)
order_type = db.Column(db.String(10), default='buy')
currency = db.Column(db.String(10),default='',nullable=False, index=True)
currency2 = db.Column(db.String(10),default='',nullable=False, index=True)
amount_start_no_fee = db.Column(db.Numeric(14, 6), default=0)
amount_start = db.Column(db.Numeric(14, 6), default=0)
amount = db.Column(db.Numeric(14, 6), default=0)
diff = db.Column(db.Numeric(14, 6), default=0)
initial_fee = db.Column(db.Numeric(14, 6), default=0)
fee = db.Column(db.Numeric(14, 6), default=0)
fee_percentage = db.Column(db.Numeric(14, 6), default=0)
price_per_unit = db.Column(db.Numeric(14, 6), default=0)
total_order = db.Column(db.Numeric(14, 6), default=0)
total_order_no_fee = db.Column(db.Numeric(14, 6), default=0)
flag_completed = db.Column(db.Integer(), default=0)
# create and modifiy time
created_date = db.Column(db.DateTime, default=datetime.datetime.utcnow())
last_updated = db.Column(db.DateTime, default=datetime.datetime.utcnow(), onupdate=datetime.datetime.utcnow())
def __repr__(self):
return '<Buy %r>' % (self.uid)
class UserAuth(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer(),
db.ForeignKey('user.id', ondelete='CASCADE'))
# User authentication information (required for Flask-User)
username = db.Column(db.String(50), nullable=True)
password = db.Column(db.String(255), nullable=False, server_default='')
reset_password_token = db.Column(db.String(100),
nullable=False,
server_default='')
active = db.Column(db.Boolean(), nullable=False, server_default='0')
# Relationships
user = db.relationship('User', uselist=False)
class UserRoles(db.Model):
id = db.Column(db.Integer(), primary_key=True)
user_id = db.Column(db.Integer(),
db.ForeignKey('user.id', ondelete='CASCADE'))
role_id = db.Column(db.Integer(),
db.ForeignKey('role.id', ondelete='CASCADE'))