Merge pull request #3 from luciferreeves/main

added bank_master model

1 files changed, 31 insertions, 0 deletions

diff --git a/interface/models/bank_master.model.js b/interface/models/bank_master.model.js
new file mode 100644
index 0000000..d474d38
--- /dev/null
+++ b/interface/models/bank_master.model.js
@@ -0,0 +1,31 @@
+module.exports = (Sequelize, sequelize) => {
+    const BankMaster = sequelize.define("bank_master", {
+        bank_account: {
+            type: Sequelize.INTEGER,
+            allowNull: false,
+            primaryKey: true,
+        },
+        ifsc_code: {
+            type: Sequelize.STRING(12),
+            allowNull: false
+        },
+        bank_name : {
+            type: Sequelize.STRING(100),
+            allowNull: false
+        },
+        branch_name : {
+            type: Sequelize.STRING(50),
+            allowNull: false
+        },
+        citizen_id : {
+            type: Sequelize.STRING(12),
+            allowNull: false,
+            references : {
+                model : "citizens",
+                key : "citizen_id",
+                onDelete : "CASCADE"
+            }
+        }
+    });
+    return BankMaster;
+};