diff options
Diffstat (limited to 'interface/models/district_master.model.js')
| -rw-r--r-- | interface/models/district_master.model.js | 25 |
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; +} |
