Python ForeignKey示例

示例#1

文件： siskeudes_penerimaan.py 项目： vickazy/sideka_app_server

class SiskeudesPenerimaan(BaseModel):
    __tablename__ = 'siskeudes_penerimaans'
    pid = db.Column(db.Integer, primary_key=True, autoincrement=True)
    year = db.Column(db.String)
    row_number = db.Column(db.Integer)
    no = db.Column(db.String)
    kode_desa = db.Column(db.String)
    tahun = db.Column(db.String)
    tanggal = db.Column(db.Date)
    uraian = db.Column(db.String)
    nama_penyetor = db.Column(db.String)
    alamat_penyetor = db.Column(db.String)
    ttd = db.Column(db.String)
    rekening_bank = db.Column(db.String)
    nama_bank = db.Column(db.String)
    jumlah = db.Column(db.DECIMAL)
    nama_bendahara = db.Column(db.String)
    jabatan_bendahara = db.Column(db.String)
    status = db.Column(db.String)
    kode_bayar = db.Column(db.Integer)
    ref_bayar = db.Column(db.String)

    fk_region_id = db.Column(db.String, db.ForeignKey('regions.id'))
    region = db.relationship('Region', lazy='select')

    __table_args__ = (db.Index('sp_ix_fk_region_id', 'fk_region_id'), )

示例#2

class BudgetRecapitulation(BaseModel):
    __tablename__ = 'budget_recapitulations'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    year = db.Column(db.String, nullable=False)
    budgeted = db.Column(db.DECIMAL)
    realized = db.Column(db.DECIMAL)

    fk_region_id = db.Column(db.String, db.ForeignKey('regions.id'))
    region = db.relationship('Region', lazy='select')

    fk_type_id = db.Column(db.Integer, db.ForeignKey('budget_types.id'))
    type = db.relationship('BudgetType', lazy='select')

    __table_args__ = (db.Index('sr_ix_fk_type_id', 'fk_type_id'),
                      db.Index('sr_ix_fk_region_id', 'fk_region_id'),
                      db.Index('sr_ix_fk_region_id_fk_type_id', 'fk_region_id',
                               'fk_type_id'))

示例#3

文件： budget_likelihood.py 项目： vickazy/sideka_app_server

class BudgetLikelihood(BaseModel):
    __tablename__ = 'budget_likelihoods'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    year = db.Column(db.String, nullable=False)
    euclidean_score = db.Column(db.Float)
    rank = db.Column(db.Integer)

    fk_region_id = db.Column(db.String, db.ForeignKey('regions.id'))
    region = db.relationship('Region',
                             foreign_keys=[fk_region_id],
                             lazy='joined')

    fk_region_likelihood_id = db.Column(db.String, db.ForeignKey('regions.id'))
    region_likelihood = db.relationship('Region',
                                        foreign_keys=[fk_region_likelihood_id],
                                        lazy='joined')

    __table_args__ = (db.Index('bl_ix_fk_region_id', 'fk_region_id'),
                      db.Index('bl_ix_fk_region_likelihood_id',
                               'fk_region_likelihood_id'))

示例#4

文件： progress_timeline.py 项目： vickazy/sideka_app_server

class ProgressTimeline(BaseModel):
    __tablename__ = 'progress_timelines'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    year = db.Column(db.String, nullable=False)
    month = db.Column(db.Integer)
    transferred_dds = db.Column(db.DECIMAL)
    transferred_add = db.Column(db.DECIMAL)
    transferred_pbh = db.Column(db.DECIMAL)
    realized_spending = db.Column(db.DECIMAL)

    fk_region_id = db.Column(db.String, db.ForeignKey('regions.id'))
    region = db.relationship('Region', lazy='select')

    __table_args__ = (db.Index('pt_ix_fk_region_id', 'fk_region_id'), )

示例#5

class ProgressRecapitulation(BaseModel):
    __tablename__ = 'progress_recapitulations'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    year = db.Column(db.String, nullable=False)
    budgeted_revenue = db.Column(db.DECIMAL)
    transferred_revenue = db.Column(db.DECIMAL)
    budgeted_spending = db.Column(db.DECIMAL)
    realized_spending = db.Column(db.DECIMAL)

    fk_region_id = db.Column(db.String, db.ForeignKey('regions.id'))
    region = db.relationship('Region', lazy='select')

    __table_args__ = (
        db.Index('pr_ix_fk_region_id', 'fk_region_id'),
    )

示例#6

文件： view_learn_kegiatan.py 项目： vickazy/sideka_app_server

class ViewLearnKegiatan(db.Model):
    __tablename__ = 'view_learn_kegiatan'
    __table_args__ = {'info': dict(is_view=True)}

    pid = db.Column(db.Integer, primary_key=True)
    year = db.Column(db.String, nullable=False)
    region_name = db.Column(db.String)
    kode_kegiatan = db.Column(db.String)
    kode_bidang = db.Column(db.String)
    uraian = db.Column(db.String)
    normalized_uraian = db.Column(db.String)
    anggaran = db.Column(db.DECIMAL)
    total_anggaran = db.Column(db.DECIMAL)
    percentage = db.Column(db.DECIMAL)

    fk_region_id = db.Column(db.String, db.ForeignKey('regions.id'))
    region = db.relationship('Region',
                             foreign_keys=[fk_region_id],
                             lazy='joined')

示例#7

文件： siskeudes_spp.py 项目： vickazy/sideka_app_server

class SiskeudesSpp(BaseModel):
    __tablename__ = 'siskeudes_spps'
    pid = db.Column(db.Integer, primary_key=True, autoincrement=True)
    year = db.Column(db.String)
    row_number = db.Column(db.Integer)
    no = db.Column(db.String)
    kode_desa = db.Column(db.String)
    tahun = db.Column(db.String)
    tanggal = db.Column(db.Date)
    jenis = db.Column(db.String)
    keterangan = db.Column(db.String)
    jumlah = db.Column(db.DECIMAL)
    potongan = db.Column(db.DECIMAL)

    fk_region_id = db.Column(db.String, db.ForeignKey('regions.id'))
    region = db.relationship('Region', lazy='select')

    __table_args__ = (
        db.Index('sspp_ix_fk_region_id', 'fk_region_id'),
    )

示例#8

文件： region.py 项目： vickazy/sideka_app_server

class Region(BaseModel):
    __tablename__ = 'regions'
    id = db.Column(db.String, primary_key=True)
    desa_id = db.Column(db.Integer)
    siskeudes_code = db.Column(db.String)
    name = db.Column(db.Text)
    type = db.Column(db.Integer, nullable=False, default=False)
    domain = db.Column(db.Text)
    is_kelurahan = db.Column(db.Boolean, nullable=False, default=False)
    is_in_scope = db.Column(db.Boolean, nullable=False, default=False)
    is_lokpri = db.Column(db.Boolean, nullable=False, default=False)

    fk_parent_id = db.Column(db.String, db.ForeignKey('regions.id'))
    parent = db.relationship('Region', remote_side=[id], lazy='select')

    __table_args__ = (
        db.Index('regions_ix_fk_parent_id', 'fk_parent_id'),
        db.Index('regions_ix_id_is_lokpri', 'id', 'is_lokpri'),
        db.Index('regions_ix_is_lokpri', 'is_lokpri'),
    )

示例#9

文件： siskeudes_kegiatan.py 项目： vickazy/sideka_app_server

class SiskeudesKegiatan(BaseModel):
    __tablename__ = 'siskeudes_kegiatans'
    pid = db.Column(db.Integer, primary_key=True, autoincrement=True)
    year = db.Column(db.String)
    row_number = db.Column(db.Integer)
    id = db.Column(db.String)
    kode_bidang = db.Column(db.String)
    nama_bidang = db.Column(db.String)
    kode_kegiatan = db.Column(db.String)
    nama_kegiatan = db.Column(db.String)
    lokasi = db.Column(db.String)
    waktu = db.Column(db.String)
    nama_pptkd = db.Column(db.String)
    keluaran = db.Column(db.String)
    pagu = db.Column(db.DECIMAL)
    pagu_pak = db.Column(db.DECIMAL)

    fk_region_id = db.Column(db.String, db.ForeignKey('regions.id'))
    region = db.relationship('Region', lazy='select')

    __table_args__ = (db.Index('sk_ix_fk_region_id', 'fk_region_id'), )

示例#10

class SiskeudesSppRinci(BaseModel):
    __tablename__ = 'siskeudes_spp_rincis'
    pid = db.Column(db.Integer, primary_key=True, autoincrement=True)
    year = db.Column(db.String)
    row_number = db.Column(db.Integer)
    kode = db.Column(db.String)
    no_spp = db.Column(db.String)
    kode_desa = db.Column(db.String)
    tahun = db.Column(db.String)
    kode_kegiatan = db.Column(db.String)
    sumber_dana = db.Column(db.String)
    nilai = db.Column(db.DECIMAL)

    fk_region_id = db.Column(db.String, db.ForeignKey('regions.id'))
    region = db.relationship('Region', lazy='select')

    spp = db.relationship('SiskeudesSpp', primaryjoin='SiskeudesSpp.no == SiskeudesSppRinci.no_spp', foreign_keys=[no_spp], lazy='joined')

    __table_args__ = (
        db.Index('ssppr_ix_fk_region_id', 'fk_region_id'),
    )

示例#11

文件： siskeudes_penganggaran.py 项目： vickazy/sideka_app_server

class SiskeudesPenganggaran(BaseModel):
    __tablename__ = 'siskeudes_penganggarans'
    pid = db.Column(db.Integer, primary_key=True, autoincrement=True)
    year = db.Column(db.String)
    row_number = db.Column(db.Integer)
    id = db.Column(db.String)
    kode_kegiatan = db.Column(db.String)
    kode_rekening = db.Column(db.String)
    uraian = db.Column(db.String)
    sumber_dana = db.Column(db.String)
    satuan = db.Column(db.String)
    jumlah_satuan = db.Column(db.Integer)
    harga_satuan = db.Column(db.DECIMAL)
    anggaran = db.Column(db.DECIMAL)
    jumlah_satuan_pak = db.Column(db.Integer)
    harga_satuan_pak = db.Column(db.DECIMAL)
    anggaran_pak = db.Column(db.DECIMAL)
    perubahan = db.Column(db.DECIMAL)

    fk_region_id = db.Column(db.String, db.ForeignKey('regions.id'))
    region = db.relationship('Region', lazy='select')

    __table_args__ = (db.Index('spg_ix_fk_region_id', 'fk_region_id'), )

示例#12

文件： siskeudes_spp_bukti.py 项目： vickazy/sideka_app_server

class SiskeudesSppBukti(BaseModel):
    __tablename__ = 'siskeudes_spp_buktis'
    pid = db.Column(db.Integer, primary_key=True, autoincrement=True)
    year = db.Column(db.String)
    row_number = db.Column(db.Integer)
    no = db.Column(db.String)
    kode_rincian = db.Column(db.String)
    no_spp = db.Column(db.String)
    kode_desa = db.Column(db.String)
    tahun = db.Column(db.String)
    kode_kegiatan = db.Column(db.String)
    sumber_dana = db.Column(db.String)
    tanggal = db.Column(db.Date)
    nama_penerima = db.Column(db.String)
    nilai = db.Column(db.DECIMAL)
    rekening_bank = db.Column(db.String)
    nama_bank = db.Column(db.String)
    npwp = db.Column(db.String)
    keterangan = db.Column(db.String)

    fk_region_id = db.Column(db.String, db.ForeignKey('regions.id'))
    region = db.relationship('Region', lazy='select')

    __table_args__ = (db.Index('ssppb_ix_fk_region_id', 'fk_region_id'), )