Add fee payment to database

2 files changed, 14 insertions, 0 deletions

diff --git a/db/index.js b/db/index.js
index 57586954..5a10a01a 100644
--- a/db/index.js
+++ b/db/index.js
@@ -162,4 +162,9 @@ Referral.belongsTo(User, {
   foreignKey: "user_id",
 });
 
+Payment.belongsTo(Payment, {
+  as: "fee",
+  foreignKey: "fee_payment_id"
+});
+
 db.Order = Order;
diff --git a/db/models/payments.js b/db/models/payments.js
index c315a5a0..bbf7c436 100644
--- a/db/models/payments.js
+++ b/db/models/payments.js
@@ -189,6 +189,15 @@ const attributes = {
     autoIncrement: false,
     comment: null,
     field: "confirmed"
+  },
+  fee_payment_id: {
+    type: DataTypes.INTEGER(11),
+    allowNull: true,
+    defaultValue: null,
+    primaryKey: false,
+    autoIncrement: false,
+    comment: null,
+    field: "fee_payment_id"
   }
 };