17 lines
743 B
Python
17 lines
743 B
Python
|
from sqlalchemy import Column, Integer, String, ForeignKey, Numeric, Date
|
||
|
|
from sqlalchemy.orm import relationship
|
||
|
|
|
||
|
|
from models.entities.base import Base
|
||
|
|
|
||
|
|
class MaterialVendido(Base):
|
||
|
|
__tablename__ = 'materiais_vendidos'
|
||
|
|
|
||
|
|
id = Column(Integer, primary_key=True, autoincrement=True)
|
||
|
|
militante_id = Column(Integer, ForeignKey('militantes.id'))
|
||
|
|
tipo_material_id = Column(Integer, ForeignKey('tipos_materiais.id'))
|
||
|
|
descricao = Column(String(255), nullable=False)
|
||
|
|
valor = Column(Numeric(10, 2), nullable=False)
|
||
|
|
data_venda = Column(Date, nullable=False)
|
||
|
|
|
||
|
|
militante = relationship("Militante", back_populates="materiais_vendidos")
|
||
|
|
tipo_material = relationship("TipoMaterial", back_populates="materiais_vendidos")
|