from sqlalchemy import Column, Integer, ForeignKey, Time, Float
from sqlalchemy.orm import relationship

from ..database import Base

class ServicoOrcamento(Base):
    __tablename__ = "servico_orcamento"

    orcamento_id = Column(Integer, ForeignKey("orcamento.orc_id"), primary_key=True, name="orc_id")
    servico_id = Column(Integer, ForeignKey("servico.serv_id"), primary_key=True, name="serv_id")
    tempo = Column(Time, name="serv_orc_tempo")
    preco_por_hora = Column(Float, name="serv_orc_preco_por_hora")

    servico = relationship("Servico", back_populates="orcamentos")
    orcamento = relationship("Orcamento", back_populates="servicos")