class Opt_cert_C(db.Model):
id = db.Column(db.Integer, primary_key=True)
name_test = db.Column(db.String(100), nullable=False)
name_hos = db.Column(db.String(100), nullable=False)
date = db.Column(db.String(100), nullable=False)
amount = db.Column(db.Float, nullable=False)
owner_id = db.Column(db.Integer, db.ForeignKey('opt_cert.id'))
class Tab_b(db.Model):
__tablename__ = 'tab_b'
id = db.Column(db.Integer, primary_key=True)
exp = db.Column(db.String(100), nullable=False)
amt22 = db.Column(db.Integer, nullable=False)
bill = db.Column(db.String(100), nullable=False)
tab_id = db.Column(db.Integer, db.ForeignKey('tab.id'))
class Reim_det(db.Model):
id = db.Column(db.Integer, primary_key=True)
date = db.Column(db.String(100), nullable=False)
cash_no = db.Column(db.String(100), nullable=False)
firm = db.Column(db.String(100), nullable=False)
purpose = db.Column(db.String(100), nullable=False)
amt = db.Column(db.Integer, nullable=False)
reim_id = db.Column(db.Integer, db.ForeignKey('reim.id'))
class Opt_cert_B(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100), nullable=False)
quantity = db.Column(db.String(100), nullable=False)
price = db.Column(db.Float, nullable=False)
cashmemo = db.Column(db.String(100), nullable=False)
date = db.Column(db.String(100), nullable=False)
owner_id = db.Column(db.Integer, db.ForeignKey('opt_cert.id'))
class Transaction(db.Model):
__tablename__ = 'transaction'
id = db.Column(db.Integer, primary_key=True)
service = db.Column(db.String(100), nullable=False)
date = db.Column(db.String(100), nullable=False)
provider = db.Column(db.Text, nullable=False)
amount = db.Column(db.Integer, nullable=False)
#user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
tele_id = db.Column(db.Integer, db.ForeignKey('telephone.id'))
def __repr__(self):
return '<Transaction %r>' % (self.service)
class Tab_a(db.Model):
__tablename__ = 'tab_a'
id = db.Column(db.Integer, primary_key=True)
ds = db.Column(db.String(100), nullable=False)
dd = db.Column(db.String(100), nullable=False)
dtym = db.Column(db.String(100), nullable=False)
arst = db.Column(db.String(100), nullable=False)
ad = db.Column(db.String(100), nullable=False)
atym = db.Column(db.String(100), nullable=False)
moj = db.Column(db.String(100), nullable=False)
jc = db.Column(db.String(100), nullable=False)
road = db.Column(db.Integer, nullable=False)
tktno = db.Column(db.String(100), nullable=False)
fare = db.Column(db.Integer, nullable=False)
tab_id = db.Column(db.Integer, db.ForeignKey('tab.id'))
class Contingent_a(db.Model):
id = db.Column(db.Integer, primary_key=True)
dt1 = db.Column(db.String(100), nullable=False)
des1 = db.Column(db.String(100), nullable=False)
amt1 = db.Column(db.Integer, nullable=False)
contingent_id = db.Column(db.Integer, db.ForeignKey('contingent.id'))
class Opt_cert_A(db.Model):
id = db.Column(db.Integer, primary_key=True)
date = db.Column(db.String(100), nullable=False)
fee_consult = db.Column(db.Float, nullable=False)
fee_inj = db.Column(db.Float, nullable=False)
owner_id = db.Column(db.Integer, db.ForeignKey('opt_cert.id'))