from core.database import Base
from sqlalchemy import Column, String, BigInteger, DateTime, Boolean

class OmieCliente(Base):
    """Modelo para tabela omie_cliente no MySQL (DataLake)"""
    __tablename__ = "omie_cliente"
    
    codigoClienteOmie = Column(BigInteger, primary_key=True)
    codigoClienteIntegracao = Column(String(50), nullable=True)
    razaoSocial = Column(String(200), nullable=True, index=True)
    cnpjCpf = Column(String(18), nullable=True, index=True)
    nomeFantasia = Column(String(200), nullable=True)
    endereco = Column(String(200), nullable=True)
    enderecoNumero = Column(String(20), nullable=True)
    bairro = Column(String(100), nullable=True)
    complemento = Column(String(100), nullable=True)
    estado = Column(String(2), nullable=True)
    cidade = Column(String(100), nullable=True)
    cep = Column(String(10), nullable=True)
    email = Column(String(200), nullable=True)
    inscricaoEstadual = Column(String(50), nullable=True)
    inscricaoMunicipal = Column(String(50), nullable=True)
    inscricaoSuframa = Column(String(50), nullable=True)
    optanteSimplesNacional = Column(String(1), nullable=True)
    tipoAtividade = Column(String(50), nullable=True)
    cnae = Column(String(20), nullable=True)
    pessoaFisica = Column(String(1), nullable=True)
    cidadeIbge = Column(String(10), nullable=True)
    dataCadastro = Column(DateTime, nullable=True)
    dataAlteracao = Column(DateTime, nullable=True)
    inativo = Column(String(1), nullable=True, index=True)
    lixeira = Column(Boolean, default=False, index=True)