aboutsummaryrefslogtreecommitdiff
path: root/interface/models/district_master.model.js
diff options
context:
space:
mode:
Diffstat (limited to 'interface/models/district_master.model.js')
-rw-r--r--interface/models/district_master.model.js25
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;
+}