from sqlalchemy import Column, String, Integer, Float, DateTime, ForeignKey, func
from sqlalchemy.orm import relationship
from app.models.base import BaseModel


class DanaItem(BaseModel):
    __tablename__ = "dana_items"

    pengajuan_dana_id = Column(
        String(36), ForeignKey("pengajuan_dana.id", ondelete="NO ACTION"), nullable=True
    )

    urutan = Column(Integer, nullable=False)
    nama = Column(String(255), nullable=False)
    tipe = Column(String(255), nullable=False)
    jumlah = Column(Integer, nullable=False)
    harga = Column(Float, nullable=False)
    total = Column(Float, nullable=False)
    dana = relationship("PengajuanDana", back_populates="list_barang")