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

from ..database import Base

class LancamentoReceita(Base):
    __tablename__ = "lancamento_receita"

    id = Column(Integer, primary_key=True, name="lanc_rec_id")
    orcamento_id = Column(Integer, ForeignKey("orcamento.orc_id"), name="orc_id")
    data = Column(TIMESTAMP, name="lanc_rec_data")
    valor = Column(Float, name="lanc_rec_valor")

    orcamento = relationship("Orcamento", back_populates="lancamentos")