5 files changed, 106 insertions, 0 deletions
diff --git a/interface/models/civil_supplies.model.js b/interface/models/civil_supplies.model.js
new file mode 100644
index 0000000..a28f3ff
--- /dev/null
+++ b/interface/models/civil_supplies.model.js
@@ -0,0 +1,37 @@
+module.exports = (Sequelize, sequelize) => {
+    const CivilSupplies = sequelize.define("civil_supplies", {
+        civil_supply_id: {
+            type: Sequelize.INTEGER,
+            allowNull: false,
+            primaryKey: true,
+            autoIncrement: true,
+        },
+        annual_income_year: {
+            type: Sequelize.DECIMAL(10, 2),
+            allowNull: false,
+        },
+        job_type: {
+            type: Sequelize.STRING(20),
+            allowNull: false,
+        },
+        ration_shopno: {
+            type: Sequelize.STRING(10),
+            allowNull: false,
+        },
+        citizen_id: {
+            type: Sequelize.STRING(20),
+            allowNull: false,
+            // FOREIGN KEY (citizen_id) REFERENCES public.civil_supplies(citizen_id) ON DELETE CASCADE;
+            references: {
+                model: "civil_supplies",
+                key: "citizen_id",
+                onDelete: "CASCADE",
+            },
+        },
+        age: {
+            type: Sequelize.INTEGER,
+            allowNull: false,
+        },
+    });
+    return CivilSupplies;
+}
diff --git a/interface/models/district_master.model.js b/interface/models/district_master.model.js
new file mode 100644
index 0000000..375f22c
--- /dev/null
+++ b/interface/models/district_master.model.js
@@ -0,0 +1,25 @@
+module.exports = (Sequelize, sequelize) => {
+    const DistrictMaster = sequelize.define("district_master", {
+        district_id: {
+            type: Sequelize.INTEGER,
+            allowNull: false,
+            primaryKey: true,
+            autoIncrement: true,
+        },
+        district_name: {
+            type: Sequelize.STRING(155),
+            allowNull: false,
+        },
+        state_id: {
+            type: Sequelize.INTEGER,
+            allowNull: false,
+            // FOREIGN KEY (state_id) REFERENCES public.state_master(state_id) ON DELETE CASCADE;
+            references: {
+                model: "state_master",
+                key: "state_id",
+                onDelete: "CASCADE",
+            },
+        },
+    });
+    return DistrictMaster;
+}
diff --git a/interface/models/index.js b/interface/models/index.js
index e799e1e..8448d06 100644
--- a/interface/models/index.js
+++ b/interface/models/index.js
@@ -22,5 +22,9 @@ db.users = require('./users.model')(Sequelize, sequelize);
 db.citizens = require('./citizens.model.js')(Sequelize, sequelize);
 db.village_master = require('./village_master.model.js')(Sequelize, sequelize);
 db.bank_master = require('./bank_master.model.js')(Sequelize, sequelize);
+db.district_master = require('./district_master.model.js')(Sequelize, sequelize);
+db.mandal_master = require('./mandal_master.model.js')(Sequelize, sequelize);
+db.civil_supplies = require('./civil_supplies.model.js')(Sequelize, sequelize);
+db.state_master = require('./state_master.model.js')(Sequelize, sequelize);
 
 module.exports = db;
diff --git a/interface/models/mandal_master.model.js b/interface/models/mandal_master.model.js
new file mode 100644
index 0000000..7b7d16f
--- /dev/null
+++ b/interface/models/mandal_master.model.js
@@ -0,0 +1,25 @@
+module.exports = (Sequelize, sequelize) => {
+  const MandalMaster = sequelize.define("mandal_master", {
+    mandal_id: {
+      type: Sequelize.INTEGER,
+      allowNull: false,
+      primaryKey: true,
+      autoIncrement: true,
+    },
+    mandal_name: {
+      type: Sequelize.STRING(155),
+      allowNull: false,
+    },
+    district_id: {
+      type: Sequelize.INTEGER,
+      allowNull: false,
+      // FOREIGN KEY (district_id) REFERENCES public.district_master(district_id) ON DELETE CASCADE;
+      references: {
+        model: "district_master",
+        key: "district_id",
+        onDelete: "CASCADE",
+      },
+    },
+  });
+  return MandalMaster;
+};
diff --git a/interface/models/state_master.model.js b/interface/models/state_master.model.js
new file mode 100644
index 0000000..e3129dd
--- /dev/null
+++ b/interface/models/state_master.model.js
@@ -0,0 +1,15 @@
+module.exports = (Sequelize, sequelize) => {
+    const StateMaster = sequelize.define("state_master", {
+        state_id: {
+            type: Sequelize.INTEGER,
+            allowNull: false,
+            primaryKey: true,
+            autoIncrement: true,
+        },
+        state_name: {
+            type: Sequelize.STRING(155),
+            allowNull: false,
+        },
+    });
+    return StateMaster;
+}