tangerang_kota.py

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


Base = declarative_base()


class Kecamatan(Base):
    __tablename__ = 'pad_kecamatan'
    id = Column(Integer, primary_key=True)
    kode = Column(String(3), nullable=False, unique=True)
    nama = Column(String(50))
    tmt = Column(DateTime)
    enabled = Column(Integer)
    created = Column(DateTime)
    create_uid = Column(Integer)
    updated = Column(DateTime)
    update_uid = Column(Integer)
    zona_id = Column(Integer, nullable=False)
    kode_kemendagri = Column(Integer)
    __table_args__ = dict(schema='pad')


class Kelurahan(Base):
    __tablename__ = 'pad_kelurahan'
    id = Column(Integer, primary_key=True)
    kecamatan_id = Column(Integer, ForeignKey(Kecamatan.id), nullable=False)
    kode = Column(String(3), nullable=False)
    nama = Column(String(25))
    tmt = Column(DateTime)
    enabled = Column(Integer)
    created = Column(DateTime)
    create_uid = Column(Integer)
    updated = Column(DateTime)
    update_uid = Column(Integer)
    kualitas_air = Column(String(20))
    sumber_alternatif = Column(String(20))
    __table_args__ = (
        UniqueConstraint('kecamatan_id', 'kode'),
        dict(schema='pad'))


class Rekening(Base):
    __tablename__ = 'pad_rekening'
    id = Column(Integer, primary_key=True)
    kode = Column(String(15), nullable=False, unique=True)
    nama = Column(String(150))
    levelid = Column(Integer)
    issummary = Column(Integer, nullable=False)
    defsign = Column(Integer)
    isppkd = Column(Integer, nullable=False)
    tmt = Column(DateTime)
    enabled = Column(Integer)
    created = Column(DateTime)
    create_uid = Column(Integer)
    updated = Column(DateTime)
    update_uid = Column(Integer)
    insidentil = Column(Integer)
    usaha_id = Column(Integer)
    __table_args__ = dict(schema='pad')


class Usaha(Base):
    __tablename__ = 'pad_usaha'
    id = Column(Integer, primary_key=True)
    nama = Column(String(50), nullable=False)
    so = Column(String(1))
    tmt = Column(DateTime)
    enabled = Column(Integer)
    created = Column(DateTime)
    create_uid = Column(Integer)
    updated = Column(DateTime)
    update_uid = Column(Integer)
    __table_args__ = dict(schema='pad')


class Pajak(Base):
    __tablename__ = 'pad_jenis_pajak'
    id = Column(Integer, primary_key=True)
    usaha_id = Column(Integer, ForeignKey(Usaha.id), nullable=False)
    nama = Column(String(100))
    rekening_id = Column(Integer, ForeignKey(Rekening.id), nullable=False)
    rekening_kd_sub = Column(String(5))
    rekdenda_id = Column(Integer)
    masapajak = Column(Integer, nullable=False)
    jatuhtempo = Column(Integer)
    multiple = Column(Integer)
    jalan_kelas_id = Column(Integer)
    tmt = Column(DateTime)
    enabled = Column(Integer)
    created = Column(DateTime)
    create_uid = Column(Integer)
    updated = Column(DateTime)
    update_uid = Column(Integer)
    __table_args__ = (
        UniqueConstraint('rekening_id', 'rekening_kd_sub'),
        dict(schema='pad'))


class Customer(Base):
    __tablename__ = 'pad_customer'
    id = Column(Integer, primary_key=True)
    parent = Column(Integer)
    npwpd = Column(String(25))
    rp = Column(String(1))
    pb = Column(Integer)
    formno = Column(Integer, nullable=False)
    reg_date = Column(DateTime)
    nama = Column(String(255))
    kecamatan_id = Column(Integer, ForeignKey(Kecamatan.id))
    kelurahan_id = Column(Integer, ForeignKey(Kelurahan.id))
    kabupaten = Column(String(25))
    alamat = Column(String(255))
    kodepos = Column(String(5))
    telphone = Column(String(50))
    wpnama = Column(String(255))
    wpalamat = Column(String(255))
    wpkelurahan = Column(String(25))
    wpkecamatan = Column(String(25))
    wpkabupaten = Column(String(25))
    wptelp = Column(String(50))
    wpkodepos = Column(String(5))
    pnama = Column(String(255))
    palamat = Column(String(255))
    pkelurahan = Column(String(25))
    pkecamatan = Column(String(25))
    pkabupaten = Column(String(25))
    ptelp = Column(String(50))
    pkodepos = Column(String(5))
    ijin1 = Column(String(100))
    ijin1no = Column(String(100))
    ijin1tgl = Column(DateTime)
    ijin1tglakhir = Column(DateTime)
    ijin2 = Column(String(100))
    ijin2no = Column(String(100))
    ijin2tgl = Column(DateTime)
    ijin2tglakhir = Column(DateTime)
    ijin3 = Column(String(100))
    ijin3no = Column(String(100))
    ijin3tgl = Column(DateTime)
    ijin3tglakhir = Column(DateTime)
    ijin4 = Column(String(100))
    ijin4no = Column(String(100))
    ijin4tgl = Column(DateTime)
    ijin4tglakhir = Column(DateTime)
    kukuhno = Column(String(30))
    kukuhnip = Column(Integer)
    kukuhtgl = Column(DateTime)
    kukuh_jabat_id = Column(Integer)
    kukuhprinted = Column(Integer)
    enabled = Column(Integer)
    create_uid = Column(Integer)
    tmt = Column(DateTime)
    customer_status_id = Column(Integer)
    kembalitgl = Column(DateTime)
    kembalioleh = Column(String(30))
    kartuprinted = Column(Integer)
    kembalinip = Column(Integer)
    penerimanm = Column(String(50))
    penerimaalamat = Column(String(50))
    penerimatgl = Column(DateTime)
    catatnip = Column(Integer)
    kirimtgl = Column(DateTime)
    batastgl = Column(DateTime)
    petugas_jabat_id = Column(Integer)
    pencatat_jabat_id = Column(Integer)
    created = Column(DateTime)
    updated = Column(DateTime)
    update_uid = Column(Integer)
    npwpd_old = Column(String(50))
    id_old = Column(Integer)
    posted = Column(Integer, nullable=False)
    id_reg_customer = Column(Integer)
    id_reg_email_wp = Column(Integer)
    filename1 = Column(String(200))
    filename2 = Column(String(200))
    filename3 = Column(String(200))
    filename4 = Column(String(200))
    email_wp = Column(String(50))
    wpemail = Column(String(100))
    pemail = Column(String(100))
    jenis_usaha_nib = Column(String(250))
    __table_args__ = (
        UniqueConstraint(
            'rp', 'pb', 'formno', 'kecamatan_id', 'kelurahan_id', 'kukuhtgl'),
        dict(schema='pad'))


class CustomerUsaha(Base):
    __tablename__ = 'pad_customer_usaha'
    id = Column(Integer, primary_key=True)
    konterid = Column(Integer, nullable=False)
    reg_date = Column(DateTime)
    customer_id = Column(Integer, ForeignKey(Customer.id), nullable=False)
    usaha_id = Column(Integer, ForeignKey(Usaha.id), nullable=False)
    so = Column(String(1))
    kecamatan_id = Column(Integer, ForeignKey(Kecamatan.id))
    kelurahan_id = Column(Integer, ForeignKey(Kelurahan.id))
    notes = Column(String(250))
    enabled = Column(Integer)
    create_uid = Column(Integer)
    customer_status_id = Column(Integer)
    aktifnotes = Column(String(500))
    tmt = Column(DateTime)
    air_zona_id = Column(Integer)
    air_manfaat_id = Column(Integer)
    def_pajak_id = Column(Integer)
    opnm = Column(String(255))
    opalamat = Column(String(255))
    latitude = Column(Float)
    longitude = Column(Float)
    created = Column(DateTime)
    updated = Column(DateTime)
    update_uid = Column(Integer)
    kd_restojmlmeja = Column(Integer)
    kd_restojmlkursi = Column(Integer)
    kd_restojmltamu = Column(Integer)
    kd_filmkursi = Column(Integer)
    kd_filmpertunjukan = Column(Integer)
    kd_filmtarif = Column(Float)
    kd_bilyarmeja = Column(Integer)
    kd_bilyartarif = Column(Float)
    kd_bilyarkegiatan = Column(Integer)
    kd_diskopengunjung = Column(Integer)
    kd_diskotarif = Column(Float)
    mall_id = Column(Integer)
    cash_register = Column(Integer)
    pelaporan = Column(Integer)
    pembukuan = Column(Integer)
    bandara = Column(Integer)
    wajib_pajak = Column(Integer)
    jumlah_karyawan = Column(Integer)
    tanggal_tutup = Column(DateTime)
    parkir_luas = Column(Integer)
    parkir_masuk = Column(Integer)
    parkir_tarif_mobil = Column(Float)
    parkir_tambahan = Column(Float)
    parkir_kapasitas_mobil = Column(Integer)
    parkir_mobil_hari = Column(Integer)
    parkir_keluar = Column(Integer)
    parkir_motor_luas = Column(Integer)
    parkir_motor_masuk = Column(Integer)
    parkir_motor_keluar = Column(Integer)
    parkir_tarif_motor = Column(Float)
    parkir_motor_tambahan = Column(Float)
    parkir_kapasitas_motor = Column(Integer)
    parkir_motor_hari = Column(Integer)
    kelompok_usaha_id = Column(Integer)
    zona_id = Column(Integer)
    manfaat_id = Column(Integer)
    golongan_id = Column(Integer)
    id_old = Column(Integer)
    id_reg_customer_usaha = Column(Integer)
    pengukuhan = Column(String(10))
    key_unik = Column(String(200))
    filepengukuhanpdf = Column(String(150))
    ijin1 = Column(String(100))
    ijin1no = Column(String(100))
    ijin1tgl = Column(DateTime)
    ijin1tglakhir = Column(DateTime)
    ijin2 = Column(String(100))
    ijin2no = Column(String(100))
    ijin2tgl = Column(DateTime)
    ijin2tglakhir = Column(DateTime)
    ijin3 = Column(String(100))
    ijin3no = Column(String(100))
    ijin3tgl = Column(DateTime)
    ijin3tglakhir = Column(DateTime)
    ijin4 = Column(String(100))
    ijin4no = Column(String(100))
    ijin4tgl = Column(DateTime)
    ijin4tglakhir = Column(DateTime)
    filename1 = Column(String(300))
    filename2 = Column(String(300))
    filename3 = Column(String(300))
    filename4 = Column(String(300))
    tappingbox = Column(Integer)
    jumlahalat = Column(Integer)
    rpnama = Column(String(150))
    rpalamat = Column(String(300))
    rpkecamatan = Column(String(25))
    rpkelurahan = Column(String(35))
    rpkota = Column(String(20))
    rpkodepos = Column(String(6))
    rptelp = Column(String(15))
    kelompok_usaha_id_new = Column(Integer)
    air_tanah_factor_id = Column(Integer)
    rstrmedia = Column(Integer)
    __table_args__ = (
        UniqueConstraint('konterid', 'customer_id', 'usaha_id'),
        dict(schema='pad'))


class Invoice(Base):
    __tablename__ = 'pad_invoice'
    id = Column(Integer, primary_key=True)
    source_id = Column(Integer)
    source_nama = Column(String(100))
    tahun = Column(Integer)
    usaha_id = Column(Integer)
    invoice_no = Column(Integer)
    jenis_usaha = Column(String(100))
    jenis_pajak = Column(String(100))
    npwpd = Column(String(100))
    nama_wp = Column(String(150))
    alamat_wp = Column(String(500))
    nama_op = Column(String(150))
    alamat_op = Column(String(500))
    nomor_tagihan = Column(String(15))
    pokok = Column(Float)
    denda = Column(Float)
    bunga = Column(Float)
    total = Column(Float)
    status_bayar = Column(Integer)
    jatuh_tempo = Column(DateTime)
    periode = Column(String(15))
    rekening_pokok = Column(String(15))
    rekening_denda = Column(String(15))
    nama_pokok = Column(String(150))
    nama_denda = Column(String(150))
    create_uid = Column(Integer)
    update_uid = Column(Integer)
    nopd = Column(String(200))
    tanggal_invoice = Column(DateTime)
    doc_type_id = Column(Integer)
    no_virtual_account = Column(String(15))
    no_virtual_account_pemohon = Column(String(18))
    expired_virtual_account = Column(DateTime)
    pembayaran_melalui = Column(String(20))
    status_pembayaran = Column(Integer)
    bjb_response = Column(Text)
    bjb_token = Column(String(200))
    bjb_inquiry = Column(Text)
    bjb_inquiry_response_code = Column(String(10))
    bjb_callback = Column(Text)
    client_refnum = Column(String(50))
    id_pembayaran = Column(String(30))
    execution_time = Column(String(150))
    va_bunga_amount = Column(Float)
    va_total_amount = Column(Float)
    string_qr = Column(Text)
    reference_qr = Column(Text)
    invoice_qr = Column(Text)
    file_qr = Column(Text)
    amount_qr = Column(Integer)
    expired_qr = Column(DateTime)
    jsoncallback_qr = Column(Text)
    update_at_qr = Column(DateTime)
    merchantname = Column(String(100))
    transactionreference = Column(String(255))
    paymentreference = Column(String(255))
    merchantmsisdn = Column(String(20))
    merchantemail = Column(String(100))
    merchantmpan = Column(String(100))
    rrn = Column(String(100))
    json_body = Column(Text)
    customername = Column(String(200))
    denda_qr = Column(Integer)
    transactiondate = Column(DateTime)
    merchantbalance = Column(Integer)
    transactionamount = Column(Integer)


class Kohir(Base):
    __tablename__ = 'pad_kohir'
    id = Column(Integer, primary_key=True)
    tahun = Column(Integer, nullable=False)
    usaha_id = Column(Integer)
    kohirno = Column(Integer, nullable=False)
    kohirtgl = Column(DateTime, nullable=False)
    spt_id = Column(Integer, primary_key=True)
    enabled = Column(Integer)
    created = Column(DateTime)
    create_uid = Column(Integer)
    updated = Column(DateTime)
    update_uid = Column(Integer)
    petugas_id = Column(Integer)
    pejabat_id = Column(Integer)
    type_id = Column(Integer)
    pejabat_penetap_id = Column(Integer)
    kohir_count = Column(Integer)
    kohir_status = Column(Integer)
    kohir_type = Column(Integer)
    __table_args__ = (
        UniqueConstraint(tahun, usaha_id, type_id, kohirno, spt_id),)


class Payment(Base):
    __tablename__ = 'pad_sspd'
    id = Column(Integer, primary_key=True)
    tahun = Column(Integer, nullable=False)
    sspdno = Column(Integer, nullable=False)
    sspdtgl = Column(DateTime, nullable=False)
    invoice_id = Column(Integer, ForeignKey(Invoice.id), nullable=False)
    keterangan = Column(String(255))
    bulan_telat = Column(Integer)
    hitung_bunga = Column(Integer)
    denda = Column(Float)
    bunga = Column(Float)
    jml_bayar = Column(Integer)
    sisa = Column(Float)
    jenis_bayar = Column(Integer)
    is_valid = Column(Integer)
    enabled = Column(Integer)
    created_at = Column(DateTime)
    petugas_id = Column(Integer)
    pejabat_id = Column(Integer)
    __table_args__ = (
        UniqueConstraint(tahun, sspdno),
        dict(schema='pad'))


class SptType(Base):
    __tablename__ = 'pad_spt_type'
    id = Column(Integer, primary_key=True)
    nama = Column(String(20), nullable=False)
    enabled = Column(Integer)
    __table_args__ = (
        dict(schema='pad'),)