class Tab(db.Model):
__tablename__ = 'tab'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100), nullable=False)
srn = db.Column(db.String(100), nullable=False)
dsgn = db.Column(db.String(100), nullable=False)
dpt = db.Column(db.String(100), nullable=False)
inst = db.Column(db.String(100), nullable=False)
bp = db.Column(db.Integer, nullable=True)
ipac = db.Column(db.Integer, nullable=False)
poj = db.Column(db.String(100), nullable=False)
enc = db.Column(db.Integer, nullable=False)
date = db.Column(db.String(100), nullable=False)
#amt44 = db.Column(db.Integer, nullable=False)
#amt55 = db.Column(db.Integer, nullable=False)
#AB = db.Column(db.Integer, nullable=False)
advdrawn = db.Column(db.Integer, nullable=False)
#netclaimed = db.Column(db.Integer, nullable=False)
excesspaid = db.Column(db.Integer, nullable=False)
excessrecovered = db.Column(db.Integer, nullable=False)
bankname = db.Column(db.String(100), nullable=False)
accno = db.Column(db.String(100), nullable=False)
ifsc = db.Column(db.String(100), nullable=False)
pets1 = db.relationship('Tab_a')
pets2 = db.relationship('Tab_b')
class Reim(db.Model):
__tablename__ = 'reim'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100), nullable=False)
dpt = db.Column(db.String(100), nullable=False)
net_claimed = db.Column(db.String(100), nullable=False)
#amt2 = db.Column(db.Integer, nullable=False)
bank = db.Column(db.String(100), nullable=False)
acc_no = db.Column(db.String(100), nullable=False)
ifsc = db.Column(db.String(100), nullable=False)
pets = db.relationship('Reim_det')
class Opt_cert(db.Model):
__tablename__ = 'opt_cert'
id = db.Column(db.Integer, primary_key=True)
name_emp = db.Column(db.String(100), nullable=False)
dsg_emp = db.Column(db.String(100), nullable=False)
emp_id = db.Column(db.String(100), nullable=False)
pt_nm = db.Column(db.String(100), nullable=False)
age = db.Column(db.String(100), nullable=False)
relationship = db.Column(db.String(100), nullable=False)
nm_address_doc = db.Column(db.String(100), nullable=False)
disease = db.Column(db.String(100), nullable=False)
#duration = db.Column(db.String(100), nullable=False)
from_date = db.Column(db.String(100), nullable=False)
to_date = db.Column(db.String(100), nullable=False)
referred_doc = db.Column(db.String(100), nullable=False)
place = db.Column(db.String(100), nullable=False)
date = db.Column(db.String(100), nullable=False)
pets1 = db.relationship('Opt_cert_A')
pets2 = db.relationship('Opt_cert_B')
pets3 = db.relationship('Opt_cert_C')
class Contingent(db.Model):
__tablename__ = 'contingent'
id = db.Column(db.Integer, primary_key=True)
curr_date = db.Column(db.String(100), nullable=False)
station = db.Column(db.String(100), nullable=False)
name = db.Column(db.String(100), nullable=False)
address = db.Column(db.String(100), nullable=False)
bankbranch = db.Column(db.String(100), nullable=False)
acc_num = db.Column(db.String(100), nullable=False)
ifsc = db.Column(db.String(100), nullable=False)
pets = db.relationship('Contingent_a')
def __repr__(self):
return '<Contigent %r>' % (self.name)
class Telephone(db.Model):
__tablename__ = 'telephone'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100), nullable=False)
designation = db.Column(db.String(100), nullable=False)
department = db.Column(db.String(100), nullable=False)
emp_id = db.Column(db.String, nullable=False)
#bill = db.Column(db.Integer, nullable=False)
date = db.Column(db.String(100), nullable=False)
month = db.Column(db.String(100), nullable=False)
bank = db.Column(db.String(100), nullable=False)
account = db.Column(db.Integer, nullable=False)
ifsc = db.Column(db.String(100), nullable=False)
pets = db.relationship('Transaction')
#user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return '<Telephone %r>' % (self.name)
