class User(db.Model, UserMixin): __tablename__ = 'users' id = db.Column(db.Integer, primary_key=True) email = db.Column(db.String(255), nullable=False, unique=True, index=True) password_hash = db.Column(db.String(255)) access = db.Column(db.String(5)) customer_id = db.Column(db.String(255)) plan = db.Column(db.String(255)) plan_id = db.Column(db.String(255)) def __init__(self, email, password, access=ACCESS['unpaid'], customer_id='', plan='', plan_id=''): self.email = email self.password_hash = generate_password_hash(password) self.access = access self.customer_id = customer_id self.plan = plan self.plan_id = plan_id def check_password(self, password): return check_password_hash(self.password_hash, password) def is_admin(self): return self.access == ACCESS['admin'] def allowed(self, access_level): return int(self.access) >= access_level
class ICD(db.Model): __tablename__ = 'icd' id = db.Column(db.Integer(), primary_key=True) manufacturer = db.Column(db.String(255), nullable=False) model_number = db.Column(db.String(255), nullable=True) name = db.Column(db.String(255), nullable=True) nbg_code = db.Column(db.String(255), nullable=True) x_ray = db.Column(db.String(255), nullable=True) serial = db.Column(db.String(255), nullable=True) ra = db.Column(db.String(255), nullable=True) rv = db.Column(db.String(255), nullable=True) hv = db.Column(db.String(255), nullable=True) detach = db.Column(db.String(255), nullable=True) wave = db.Column(db.String(255), nullable=True) replacement = db.Column(db.String(255), nullable=True)
class CRTP(db.Model): __tablename__ = 'crtp' id = db.Column(db.Integer(), primary_key=True) manufacturer = db.Column(db.String(255), nullable=False) model_number = db.Column(db.String(255), nullable=True) name = db.Column(db.String(255), nullable=True) nbg_code = db.Column(db.String(255), nullable=True) x_ray = db.Column(db.String(255), nullable=True) ra = db.Column(db.String(255), nullable=True) la = db.Column(db.String(255), nullable=True) rv = db.Column(db.String(255), nullable=True) lv = db.Column(db.String(255), nullable=True) detach = db.Column(db.String(255), nullable=True) n_bol = db.Column(db.String(255), nullable=True) n_eri = db.Column(db.String(255), nullable=True) m_bol = db.Column(db.String(255), nullable=True) m_eri = db.Column(db.String(255), nullable=True) eri_behaviour = db.Column(db.String(255), nullable=True) longevity = db.Column(db.String(255), nullable=True)
class IPG(db.Model): __tablename__ = 'ipg' id = db.Column(db.Integer(), primary_key=True) manufacturer = db.Column(db.String(255), nullable=False) model_number = db.Column(db.String(255), nullable=True) name = db.Column(db.String(255), nullable=True) nbg_code = db.Column(db.String(255), nullable=True) x_ray = db.Column(db.String(255), nullable=True) ra = db.Column(db.String(255), nullable=True) rv = db.Column(db.String(255), nullable=True) detach = db.Column(db.String(255), nullable=True) n_bos = db.Column(db.String(255), nullable=True) n_rrt = db.Column(db.String(255), nullable=True) m_bos = db.Column(db.String(255), nullable=True) m_rrt = db.Column(db.String(255), nullable=True) rrt_behaviour = db.Column(db.String(255), nullable=True) rrt_longevity = db.Column(db.String(255), nullable=True)
class HV(db.Model): __tablename__ = 'hv' id = db.Column(db.Integer(), primary_key=True) manufacturer = db.Column(db.String(255), nullable=False) model_number = db.Column(db.String(255), nullable=True) name = db.Column(db.String(255), nullable=True) serial = db.Column(db.String(255), nullable=True) sense = db.Column(db.String(255), nullable=True) high = db.Column(db.String(255), nullable=True) sensing = db.Column(db.String(255), nullable=True) lead = db.Column(db.String(255), nullable=True) placement = db.Column(db.String(255), nullable=True) fixation = db.Column(db.String(255), nullable=True) insulation = db.Column(db.String(255), nullable=True)