Exemplo n.º 1
0
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')
Exemplo n.º 2
0
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')
Exemplo n.º 3
0
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')
Exemplo n.º 4
0
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)
Exemplo n.º 5
0
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)