sppt.py

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


class SpptMixin:
    @declared_attr
    def __tablename__(self):
        return 'sppt'

    @declared_attr
    def kd_propinsi(self):
        return Column(String(2), primary_key=True)

    @declared_attr
    def kd_dati2(self):
        return Column(String(2), primary_key=True)

    @declared_attr
    def kd_kecamatan(self):
        return Column(String(3), primary_key=True)

    @declared_attr
    def kd_kelurahan(self):
        return Column(String(3), primary_key=True)

    @declared_attr
    def kd_blok(self):
        return Column(String(3), primary_key=True)

    @declared_attr
    def no_urut(self):
        return Column(String(4), primary_key=True)

    @declared_attr
    def kd_jns_op(self):
        return Column(String(1), primary_key=True)

    @declared_attr
    def thn_pajak_sppt(self):
        return Column(String(4), primary_key=True)

    @declared_attr
    def siklus_sppt(self):
        return Column(Integer)

    @declared_attr
    def kd_kanwil_bank(self):
        return Column(String(2))

    @declared_attr
    def kd_kppbb_bank(self):
        return Column(String(2))

    @declared_attr
    def kd_bank_tunggal(self):
        return Column(String(2))

    @declared_attr
    def kd_bank_persepsi(self):
        return Column(String(2))

    @declared_attr
    def kd_tp(self):
        return Column(String(2))

    @declared_attr
    def nm_wp_sppt(self):
        return Column(String(30))

    @declared_attr
    def jln_wp_sppt(self):
        return Column(String(30))

    @declared_attr
    def blok_kav_no_wp_sppt(self):
        return Column(String(15))

    @declared_attr
    def rw_wp_sppt(self):
        return Column(String(2))

    @declared_attr
    def rt_wp_sppt(self):
        return Column(String(3))

    @declared_attr
    def kelurahan_wp_sppt(self):
        return Column(String(30))

    @declared_attr
    def kota_wp_sppt(self):
        return Column(String(30))

    @declared_attr
    def kd_pos_wp_sppt(self):
        return Column(String(5))

    @declared_attr
    def npwp_sppt(self):
        return Column(String(15))

    @declared_attr
    def no_persil_sppt(self):
        return Column(String(5))

    @declared_attr
    def kd_kls_tanah(self):
        return Column(String(3))

    @declared_attr
    def thn_awal_kls_tanah(self):
        return Column(String(4))

    @declared_attr
    def kd_kls_bng(self):
        return Column(String(3))

    @declared_attr
    def thn_awal_kls_bng(self):
        return Column(String(4))

    @declared_attr
    def tgl_jatuh_tempo_sppt(self):
        return Column(Date)

    @declared_attr
    def luas_bumi_sppt(self):
        return Column(Float)

    @declared_attr
    def luas_bng_sppt(self):
        return Column(Float)

    @declared_attr
    def njop_bumi_sppt(self):
        return Column(Float)

    @declared_attr
    def njop_bng_sppt(self):
        return Column(Float)

    @declared_attr
    def njop_sppt(self):
        return Column(Float)

    @declared_attr
    def njoptkp_sppt(self):
        return Column(Integer)

    @declared_attr
    def njkp_sppt(self):
        return Column(Integer)

    @declared_attr
    def pbb_terhutang_sppt(self):
        return Column(Float)

    @declared_attr
    def faktor_pengurang_sppt(self):
        return Column(Float)

    @declared_attr
    def pbb_yg_harus_dibayar_sppt(self):
        return Column(Float)

    @declared_attr
    def status_pembayaran_sppt(self):
        return Column(String(1))

    @declared_attr
    def status_tagihan_sppt(self):
        return Column(String(1))

    @declared_attr
    def status_cetak_sppt(self):
        return Column(String(1))

    @declared_attr
    def tgl_terbit_sppt(self):
        return Column(Date)

    @declared_attr
    def tgl_cetak_sppt(self):
        return Column(DateTime)

    @declared_attr
    def nip_pencetak_sppt(self):
        return Column(String(18))

    @declared_attr
    def kd_kanwil(self):
        return Column(String(2))

    @declared_attr
    def kd_kantor(self):
        return Column(String(2))