models.py

from sqlalchemy import (
    Column,
    String,
    Integer,
    Float,
    DateTime,
    Date,
    )
from sqlalchemy.ext.declarative import declarative_base


Base = declarative_base()


class Propinsi(Base):
    __tablename__ = 'ref_propinsi'
    kd_propinsi = Column(String(2), primary_key=True)
    nm_propinsi = Column(String(30))


class Kabupaten(Base):
    __tablename__ = 'ref_dati2'
    kd_propinsi = Column(String(2), primary_key=True)
    kd_dati2 = Column(String(2), primary_key=True)
    nm_dati2 = Column(String(30))


class Kecamatan(Base):
    __tablename__ = 'ref_kecamatan'
    kd_propinsi = Column(String(2), primary_key=True)
    kd_dati2 = Column(String(2), primary_key=True)
    kd_kecamatan = Column(String(3), primary_key=True)
    nm_kecamatan = Column(String(30))


class Kelurahan(Base):
    __tablename__ = 'ref_kelurahan'
    kd_propinsi = Column(String(2), primary_key=True)
    kd_dati2 = Column(String(2), primary_key=True)
    kd_kecamatan = Column(String(3), primary_key=True)
    kd_kelurahan = Column(String(3), primary_key=True)
    kd_sektor = Column(String(2))
    nm_kelurahan = Column(String(30))
    no_kelurahan = Column(Integer)
    kd_pos_kelurahan = Column(String(5))


class SubjekPajak(Base):
    __tablename__ = 'dat_subjek_pajak'
    subjek_pajak_id = Column(String(30), primary_key=True)
    nm_wp = Column(String(30))
    jalan_wp = Column(String(30))
    blok_kav_no_wp = Column(String(15))
    rw_wp = Column(String(2))
    rt_wp = Column(String(3))
    kelurahan_wp = Column(String(30))
    kota_wp = Column(String(30))
    kd_pos_wp = Column(String(5))
    telp_wp = Column(String(20))
    npwp = Column(String(15))
    status_pekerjaan_wp = Column(String(1))


class ObjekPajak(Base):
    __tablename__ = 'dat_objek_pajak'
    kd_propinsi = Column(String(2), primary_key=True)
    kd_dati2 = Column(String(2), primary_key=True)
    kd_kecamatan = Column(String(3), primary_key=True)
    kd_kelurahan = Column(String(3), primary_key=True)
    kd_blok = Column(String(3), primary_key=True)
    no_urut = Column(String(4), primary_key=True)
    kd_jns_op = Column(String(1), primary_key=True)
    subjek_pajak_id = Column(String(30))
    no_formulir_spop = Column(String(11))
    no_persil = Column(String(5))
    jalan_op = Column(String(30))
    blok_kav_no_op = Column(String(15))
    rw_op = Column(String(2))
    rt_op = Column(String(3))
    kd_status_cabang = Column(Integer)
    kd_status_wp = Column(String(1))
    total_luas_bumi = Column(Float)
    total_luas_bng = Column(Float)
    njop_bumi = Column(Float)
    njop_bng = Column(Float)
    status_peta_op = Column(Integer)
    jns_transaksi_op = Column(String(1))
    tgl_pendataan_op = Column(Date)
    nip_pendata = Column(String(18))
    tgl_pemeriksaan_op = Column(Date)
    nip_pemeriksa_op = Column(String(18))
    tgl_perekaman_op = Column(DateTime)
    nip_perekam_op = Column(String(18))


class Sppt(Base):
    __tablename__ = 'sppt'
    kd_propinsi = Column(String(2), primary_key=True)
    kd_dati2 = Column(String(2), primary_key=True)
    kd_kecamatan = Column(String(3), primary_key=True)
    kd_kelurahan = Column(String(3), primary_key=True)
    kd_blok = Column(String(3), primary_key=True)
    no_urut = Column(String(4), primary_key=True)
    kd_jns_op = Column(String(1), primary_key=True)
    thn_pajak_sppt = Column(String(4), primary_key=True)
    siklus_sppt = Column(Integer)
    kd_kanwil_bank = Column(String(2))
    kd_kppbb_bank = Column(String(2))
    kd_bank_tunggal = Column(String(2))
    kd_bank_persepsi = Column(String(2))
    kd_tp = Column(String(2))
    nm_wp_sppt = Column(String(30))
    jln_wp_sppt = Column(String(30))
    blok_kav_no_wp_sppt = Column(String(15))
    rw_wp_sppt = Column(String(2))
    rt_wp_sppt = Column(String(3))
    kelurahan_wp_sppt = Column(String(30))
    kota_wp_sppt = Column(String(30))
    kd_pos_wp_sppt = Column(String(5))
    npwp_sppt = Column(String(15))
    no_persil_sppt = Column(String(5))
    kd_kls_tanah = Column(String(3))
    thn_awal_kls_tanah = Column(String(4))
    kd_kls_bng = Column(String(3))
    thn_awal_kls_bng = Column(String(4))
    tgl_jatuh_tempo_sppt = Column(Date)
    luas_bumi_sppt = Column(Float)
    luas_bng_sppt = Column(Float)
    njop_bumi_sppt = Column(Float)
    njop_bng_sppt = Column(Float)
    njop_sppt = Column(Float)
    njoptkp_sppt = Column(Integer)
    njkp_sppt = Column(Integer)
    pbb_terhutang_sppt = Column(Float)
    faktor_pengurang_sppt = Column(Float)
    pbb_yg_harus_dibayar_sppt = Column(Float)
    status_pembayaran_sppt = Column(String(1))
    status_tagihan_sppt = Column(String(1))
    status_cetak_sppt = Column(String(1))
    tgl_terbit_sppt = Column(Date)
    tgl_cetak_sppt = Column(DateTime)
    nip_pencetak_sppt = Column(String(18))
    kd_kanwil = Column(String(2))
    kd_kantor = Column(String(2))


class PembayaranSppt(Base):
    __tablename__ = 'pembayaran_sppt'
    kd_propinsi = Column(String(2), primary_key=True)
    kd_dati2 = Column(String(2), primary_key=True)
    kd_kecamatan = Column(String(3), primary_key=True)
    kd_kelurahan = Column(String(3), primary_key=True)
    kd_blok = Column(String(3), primary_key=True)
    no_urut = Column(String(4), primary_key=True)
    kd_jns_op = Column(String(1), primary_key=True)
    thn_pajak_sppt = Column(String(4), primary_key=True)
    pembayaran_sppt_ke = Column(Integer, primary_key=True)
    kd_kanwil = Column(String(2), primary_key=True)
    kd_kantor = Column(String(2), primary_key=True)
    kd_tp = Column(String(2), primary_key=True)
    denda_sppt = Column(Integer)
    jml_sppt_yg_dibayar = Column(Integer)
    tgl_pembayaran_sppt = Column(DateTime)
    tgl_rekam_byr_sppt = Column(DateTime)
    nip_rekam_byr_sppt = Column(String(18))
    user_id = Column(Integer)
    jml_batal = Column(Integer)
    tgl_batal = Column(DateTime)
    user_id_batal = Column(Integer)
    biaya_admin = Column(Float)
    discount = Column(Integer)