from sqlalchemy import Column, String, Integer, Date, ForeignKey, Text, Float,Boolean
from sqlalchemy.orm import relationship

from models.base import Base, TimestampMixin


class WalletHistory(Base, TimestampMixin):
    __tablename__ = 'wallet_history'
    id = Column(Integer, primary_key=True, autoincrement=True)
    payment_id = Column(Integer, ForeignKey('payments.id'), nullable=True)
    payment_details_id = Column(Integer, ForeignKey('payment_details.id'), nullable=True)
    event_payment_id = Column(Integer, ForeignKey('event_payments.id'), nullable=True)
    user_type=Column(String(255),nullable=False)
    refund_for_id = Column(Integer, nullable=False)
    refund_type=Column(String(255),default="individual")
    message = Column(Text)
    amount = Column(Float)
    note=Column(Text,nullable=True)
    transaction_id = Column(String(255),nullable=True)
    is_credit = Column(Boolean,nullable=False,default=True)
    payment_details=relationship("PaymentDetails")
    event_payment=relationship("EventPayment")
    payment = relationship("Payment")