iso.py

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


Base = declarative_base()


class Payment(Base):
    __tablename__ = 'bphtb_payment'
    id = Column(Integer, primary_key=True)
    tgl = Column(DateTime(timezone=True), nullable=False)
    iso_request = Column(String(1024), nullable=False)
    transmission = Column(DateTime(timezone=True), nullable=False)
    settlement = Column(Date, nullable=False)
    stan = Column(Integer, nullable=False)
    invoice_no = Column(String(32), nullable=False)
    pembayaran_ke = Column(Integer, nullable=False)
    ntb = Column(String(32), nullable=False)
    ntp = Column(String(32), nullable=False, unique=True)
    bank_id = Column(Integer, nullable=False)
    channel_id = Column(Integer, nullable=False)
    bank_ip = Column(String(15), nullable=False)


class Reversal(Base):
    __tablename__ = 'bphtb_reversal'
    id = Column(Integer, ForeignKey(Payment.id), primary_key=True)
    tgl = Column(DateTime(timezone=True), nullable=False)
    iso_request = Column(String(1024), nullable=False)