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

class OmieContratoVencimento(Base):
    """Modelo para tabela omie_contrato_vencimentoTexto no MySQL (DataLake)"""
    __tablename__ = "omie_contrato_vencimentoTexto"
    
    nCodCtr = Column(BigInteger, ForeignKey('omie_contrato.nCodCtr', ondelete='CASCADE'), primary_key=True)
    cTpVenc = Column(String(50), nullable=True)
    nDias = Column(Integer, nullable=True)
    nDiaFixo = Column(Integer, nullable=True)
    cProxMes = Column(String(1), nullable=True)
    cAntecipar = Column(String(1), nullable=True)
    cPostergar = Column(String(1), nullable=True)
    cAdPeriodo = Column(String(1), nullable=True)
    cAdContrato = Column(String(1), nullable=True)
    cAdVenc = Column(String(1), nullable=True)
    cCodPerRef = Column(String(50), nullable=True)
    cDiaIni = Column(String(10), nullable=True)
    cDiaFim = Column(String(10), nullable=True)