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)