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

class OmieContratoServico(Base):
    """Modelo para tabela omie_contrato_servico no MySQL (DataLake)"""
    __tablename__ = "omie_contrato_servico"
    
    id = Column(Integer, primary_key=True, autoincrement=True)
    nCodCtr = Column(BigInteger, ForeignKey('omie_contrato.nCodCtr', ondelete='CASCADE'), nullable=False, index=True)
    codItem = Column(String(50), nullable=True, index=True)
    descrCompleta = Column(Text, nullable=True)
    quant = Column(Numeric(15, 4), default=0)
    valorUnit = Column(Numeric(15, 2), default=0)
    valorTotal = Column(Numeric(15, 2), default=0)