From cce1d920245f7ee128bde6d2e978138cbbdc6e46 Mon Sep 17 00:00:00 2001
From: Bobby <bobbyskhs@gmail.com>
Date: Tue, 3 May 2022 16:19:23 -0400
Subject: added models

---
 interface/models/district_master.model.js | 25 +++++++++++++++++++++++++
 1 file changed, 25 insertions(+)
 create mode 100644 interface/models/district_master.model.js

(limited to 'interface/models/district_master.model.js')

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;
+}
-- 
cgit v1.2.3