from sqlalchemy import Column, DateTime, Float, ForeignKey, Integer, String
from sqlalchemy.orm import relationship

from app.model.base import BaseModel
from app.engine.postgresdb import Base

class Transaction(Base, BaseModel):
    __tablename__ = "transactions"
    transaction_date = Column(DateTime)
    category = Column(String)
    name_description = Column(String)
    amount = Column(Float)
    type = Column(String)

    user_id = Column(Integer, ForeignKey("users.id"))
    user = relationship("User", back_populates="transactions")