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

class OmieContaReceberInfo(Base):
    """Modelo para tabela omie_contaReceber_info no MySQL (DataLake)"""
    __tablename__ = "omie_contaReceber_info"
    
    codigo_lancamento_omie = Column(BigInteger, ForeignKey('omie_contaReceber.codigo_lancamento_omie', ondelete='CASCADE'), primary_key=True)
    dInc = Column(Date, nullable=True)
    hInc = Column(Time, nullable=True)
    uInc = Column(String(100), nullable=True)
    dAlt = Column(Date, nullable=True)
    hAlt = Column(Time, nullable=True)
    uAlt = Column(String(100), nullable=True)
    cImpAPI = Column(String(1), nullable=True)