Init project

1 files changed, 16 insertions, 0 deletions

diff --git a/models/payment.py b/models/payment.py
new file mode 100644
index 0000000..2b1cb90
--- /dev/null
+++ b/models/payment.py
@@ -0,0 +1,16 @@
+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]