From 51e7b0e5912517eb8ee78f95029e948c73d69267 Mon Sep 17 00:00:00 2001 From: Bobby Date: Sat, 30 Apr 2022 15:56:52 -0400 Subject: added bank_master model --- interface/models/bank_master.model.js | 31 +++++++++++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100644 interface/models/bank_master.model.js 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; +}; -- cgit v1.2.3