from db.base import Base
from sqlalchemy import Column, String, Integer, DateTime, func, ForeignKey
import uuid

class WalletTransaction(Base):
    __tablename__ = "wallet_transactions"
    id = Column(String(36), primary_key=True, default=lambda: str(uuid.uuid4()))
    user_id = Column(String(36), ForeignKey("users.id"), nullable=False)
    type = Column(String(20))
    amount_paise = Column(Integer, nullable=False)
    balance_after_paise = Column(Integer, nullable=False)
    reference_id = Column(String(100))
    description = Column(String(255))
    created_at = Column(DateTime, server_default=func.now())