models.py

from sqlalchemy import (
    Column,
    Integer,
    BigInteger,
    Date,
    Text,
    Float,
    String,
    Boolean,
    ForeignKey,
    )
from sqlalchemy.ext.declarative import declarative_base


Base = declarative_base()


class JenisTransaksi(Base):
    __tablename__ = 's_jenistransaksi'
    s_idjenistransaksi = Column(Integer, primary_key=True)
    s_namajenistransaksi = Column(String(200), unique=True)


class User(Base):
    __tablename__ = 's_users'
    s_iduser = Column(Integer, primary_key=True)
    s_idpejabat_idnotaris = Column(Text)


class Notaris(Base):
    __tablename__ = 's_notaris'
    s_idnotaris = Column(Integer, primary_key=True)
    s_namanotaris = Column(Text, nullable=False)
    s_alamatnotaris = Column(Text)
    s_kodenotaris = Column(Text)
    s_sknotaris = Column(String(50))
    s_tgl1notaris = Column(Date)
    s_tgl2notaris = Column(Date)
    s_statusnotaris = Column(Integer)


class Spt(Base):
    __tablename__ = 't_spt'
    t_idspt = Column(Integer, primary_key=True)
    t_kohirspt = Column(Integer)
    t_kohirketetapanspt = Column(Integer)
    t_tglprosesspt = Column(Date)
    t_periodespt = Column(Integer, nullable=False)
    t_idnotarisspt = Column(Integer)
    t_objekspt = Column(Integer)
    t_idtarifspt = Column(Integer)
    t_ketetapanspt = Column(Integer)
    t_tglketetapanspt = Column(Date)
    t_tgljatuhtempospt = Column(Date, nullable=False)
    t_nopbphtbsppt = Column(Text, nullable=False)
    t_kodebayarbanksppt = Column(Text)
    t_idjenistransaksi = Column(
        Integer, ForeignKey(JenisTransaksi.s_idjenistransaksi), nullable=False)
    t_idjenishaktanah = Column(Integer)
    t_idrefspt = Column(Integer)
    t_pejabatverifikasispt = Column(Integer)
    t_dasarspt = Column(Integer)
    t_totalspt = Column(BigInteger, nullable=False)
    t_nilaitransaksispt = Column(BigInteger)
    t_potonganspt = Column(Integer)
    t_thnsppt = Column(Text)
    t_persyaratan = Column(Text)
    t_idjenisdoktanah = Column(Integer)
    t_idsptsebelumnya = Column(Integer)
    t_pejabatpendaftaranspt = Column(Integer)
    t_idtarifbphtb = Column(Integer)
    t_input_sismiop = Column(Integer)
    t_iduser_sismiop = Column(Integer)
    t_tglproses_sismiop = Column(Date)
    t_tarif_pembagian_aphb_kali = Column(Integer)
    t_tarif_pembagian_aphb_bagi = Column(Integer)
    t_persenbphtb = Column(Float)
    fr_tervalidasidua = Column(Integer)
    t_potongan_waris_hibahwasiat = Column(Float)
    t_sisa_potongan_npoptkp = Column(Float)
    id_pendataan_old = Column(Integer)
    ntpd = Column(String(100))


class DetailSpt(Base):
    __tablename__ = 't_detailsptbphtb'
    t_iddetailsptbphtb = Column(Integer, primary_key=True)
    t_idspt = Column(Integer, ForeignKey(Spt.t_idspt), nullable=False)
    t_namawppembeli = Column(Text, nullable=False)
    t_nikwppembeli = Column(Text)
    t_alamatwppembeli = Column(Text, nullable=False)
    t_kecamatanwppembeli = Column(Text, nullable=False)
    t_kelurahanwppembeli = Column(Text, nullable=False)
    t_kabkotawppembeli = Column(Text, nullable=False)
    t_telponwppembeli = Column(Text)
    t_kodeposwppembeli = Column(Text)
    t_npwpwppembeli = Column(Text)
    t_namawppenjual = Column(Text)
    t_nikwppenjual = Column(Text)
    t_alamatwppenjual = Column(Text)
    t_kecamatanwppenjual = Column(Text)
    t_kelurahanwppenjual = Column(Text)
    t_kabkotawppenjual = Column(Text)
    t_telponwppenjual = Column(Text)
    t_kodeposwppenjual = Column(Text)
    t_npwpwppenjual = Column(Text)
    t_luastanah = Column(Float)
    t_njoptanah = Column(Integer)
    t_luasbangunan = Column(Float)
    t_njopbangunan = Column(Integer)
    t_totalnjoptanah = Column(Integer)
    t_totalnjopbangunan = Column(Integer)
    t_grandtotalnjop = Column(Integer)
    t_nosertifikathaktanah = Column(String(30))
    t_kelurahanop = Column(String(30))
    t_kecamatanop = Column(String(30))
    t_ketwaris = Column(String(200))
    t_terbukti = Column(String(10))
    t_rtwppembeli = Column(Text)
    t_rwwppembeli = Column(Text)
    t_alamatop = Column(Text)
    t_rtop = Column(String(3))
    t_rwop = Column(String(3))
    t_dokpersyaratan = Column(Text)
    t_namasppt = Column(Text)
    t_tglajb = Column(Date)
    t_luastanahbpn = Column(Float)
    t_luasbangunanbpn = Column(Float)
    t_tglajbbaru = Column(Date)
    t_noajbbaru = Column(Text)
    t_statuspelaporannotaris = Column(Boolean)
    t_tglpelaporannotaris = Column(Date)
    t_kabupatenop = Column(Text)
    t_rtwppenjual = Column(Text)
    t_rwwppenjual = Column(Text)
    t_nosertifikatbaru = Column(String(10))
    t_tglsertifikatbaru = Column(Date)
    t_inputbpn = Column(Boolean)
    t_statuskonfirmasinotaris = Column(Boolean)
    t_tglkonfirmasinotaris = Column(Date)
    t_luastanah_sismiop = Column(Float)
    t_luasbangunan_sismiop = Column(Float)
    t_njoptanah_sismiop = Column(Integer)
    t_njopbangunan_sismiop = Column(Integer)
    t_grandtotalnjop_aphb = Column(Integer)
    fr_luas_tanah_bpn = Column(Float)
    fr_luas_bangunan_bpn = Column(Float)
    fr_validasidua = Column(Integer)
    t_namaibuwppembeli = Column(Text)
    t_nosertifikattanah = Column(Text)


class Pembayaran(Base):
    __tablename__ = 't_pembayaranspt'
    t_idpembayaranspt = Column(Integer, primary_key=True)
    t_idspt = Column(
        Integer, ForeignKey(Spt.t_idspt), nullable=False)
    t_kohirpembayaran = Column(Integer)
    t_periodepembayaran = Column(Integer)
    t_tanggalpembayaran = Column(Date, nullable=False)
    t_objekspt = Column(Integer)
    t_idnotaris = Column(Integer)
    t_ketetapanspt = Column(Integer)
    t_nilaipembayaranspt = Column(Integer, nullable=False)
    t_idkorekspt = Column(Integer)
    t_kodebayarspt = Column(Text)
    t_verifikasispt = Column(Text)
    t_tglverifikasispt = Column(Date)
    t_pejabatverifikasispt = Column(Integer)
    t_statusbayarspt = Column(Boolean, nullable=False)
    t_kodebayarbanksppt = Column(Text, nullable=False)
    t_dendabulan = Column(Integer)
    t_pejabatpembayaranspt = Column(Integer)
    t_idds = Column(Integer)
    t_idpenerimasetoran = Column(Integer)


class Pemeriksaan(Base):
    __tablename__ = 't_pemeriksaan'
    p_idpemeriksaan = Column(Integer, primary_key=True)
    p_idpembayaranspt = Column(
        Integer, ForeignKey(Pembayaran.t_idpembayaranspt), nullable=False)
    p_luastanah = Column(Float)
    p_luasbangunan = Column(Float)
    p_njoptanah = Column(Integer)
    p_njopbangunan = Column(Integer)
    p_totalnjoptanah = Column(Integer)
    p_totalnjopbangunan = Column(Integer)
    p_grandtotalnjop = Column(Integer)
    p_nilaitransaksispt = Column(Integer)
    p_potonganspt = Column(Integer)
    p_ketwaris = Column(String(200))
    p_terbukti = Column(String(10))
    p_idjenistransaksi = Column(Integer)
    p_idjenishaktanah = Column(Integer)
    p_totalspt = Column(Integer)
    p_nilaipembayaranspt = Column(Integer)
    p_nilaikurangbayar = Column(Integer)
    p_kohirskpdkb = Column(Integer)
    p_pembayaranskpdkb = Column(Boolean)
    p_grandtotalnjop_aphb = Column(Integer)
    p_sisa_potongan_npoptkp = Column(Integer)