from datetime import datetime

from sqlalchemy import ForeignKey
from sqlalchemy.orm import Mapped, mapped_column

from models import BaseTable, Invoice, User


class Payment(BaseTable):
    __tablename__ = "payment"

    id: Mapped[int] = mapped_column(primary_key=True, autoincrement=True)
    user_id: Mapped[int] = mapped_column(ForeignKey(User.id))
    invoice_id: Mapped[int] = mapped_column(ForeignKey(Invoice.id))
    receipt_file_id: Mapped[str]
    datetime: Mapped[datetime]