OwlCyberSecurity - MANAGER
Edit File: room.model.js
import { DataTypes } from 'sequelize'; import sequelize from '../sequelize.js'; import Floor from './floor.model.js'; const Room = sequelize.define('Room', { id: { type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true, }, room_no: { type: DataTypes.INTEGER, allowNull: true, }, floorId: { type: DataTypes.INTEGER, allowNull: true, references: { model: 'floors', key: 'id', }, }, }, { tableName: 'rooms', timestamps: false, }); Floor.hasMany(Room, { foreignKey: 'floorId' }); Room.belongsTo(Floor, { foreignKey: 'floorId' }); export default Room;