Merge pull request #5 from luciferreeves/main

Working Models

1 files changed, 25 insertions, 0 deletions

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;
+}