from core.database import Base
from sqlalchemy import Column, String, BigInteger, Numeric, Date, ForeignKey

class OmieContaReceberBoleto(Base):
    """Modelo para tabela omie_contaReceber_boleto no MySQL (DataLake)"""
    __tablename__ = "omie_contaReceber_boleto"
    
    codigo_lancamento_omie = Column(BigInteger, ForeignKey('omie_contaReceber.codigo_lancamento_omie', ondelete='CASCADE'), primary_key=True)
    cGerado = Column(String(1), nullable=True)
    cLinkBoleto = Column(String(500), nullable=True)
    cCodStatus = Column(String(50), nullable=True)
    cDesStatus = Column(String(200), nullable=True)
    dDtEmBol = Column(Date, nullable=True)
    cNumBoleto = Column(String(50), nullable=True, index=True)
    cCodBarras = Column(String(100), nullable=True, index=True)
    cNumBancario = Column(String(50), nullable=True)
    nPerJuros = Column(Numeric(5, 2), default=0)
    nPerMulta = Column(Numeric(5, 2), default=0)
    dDescontoCond1 = Column(Date, nullable=True)
    vDescontoCond1 = Column(Numeric(15, 2), default=0)
    dDescontoCond2 = Column(Date, nullable=True)
    vDescontoCond2 = Column(Numeric(15, 2), default=0)
    dDescontoCond3 = Column(Date, nullable=True)
    vDescontoCond3 = Column(Numeric(15, 2), default=0)