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

class OmieContrato(Base):
    """Modelo para tabela omie_contrato no MySQL (DataLake)"""
    __tablename__ = "omie_contrato"
    
    nCodCtr = Column(BigInteger, primary_key=True)
    cnpj = Column(String(18), nullable=False, index=True)
    cCodIntCtr = Column(String(50), nullable=True)
    nCodCli = Column(BigInteger, nullable=True, index=True)
    cNumCtr = Column(String(50), nullable=True)
    cCodSit = Column(String(50), nullable=True, index=True)
    dVigInicial = Column(Date, nullable=True, index=True)
    dVigFinal = Column(Date, nullable=True, index=True)
    nDiaFat = Column(Integer, nullable=True)
    nValTotMes = Column(Numeric(15, 2), default=0)
    cTipoFat = Column(String(50), nullable=True)
    lixeira = Column(Boolean, default=False, index=True)