from core.database import Base
from sqlalchemy import Column, String, Integer, Boolean, PrimaryKeyConstraint

class OmieControleRequisicao(Base):
    """Modelo para tabela omie_controleRequisicao no MySQL (DataLake)"""
    __tablename__ = "omie_controleRequisicao"
    __table_args__ = (
        PrimaryKeyConstraint('id', 'cnpj', 'tipoRequisicao'),
    )
    
    id = Column(Integer, nullable=False)
    cnpj = Column(String(18), nullable=False, index=True)
    tipoRequisicao = Column(String(50), nullable=False, index=True)
    pagina = Column(Integer, default=1)
    concluido = Column(Boolean, default=False, index=True)