Python ForeignKey示例

示例#1

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'))

示例#2

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'))

示例#3

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'))

示例#4

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'))

示例#5

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)

示例#6

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'))

示例#7

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'))

示例#8

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'))