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'))