Software: Apache. PHP/8.1.30 

uname -a: Linux server1.tuhinhossain.com 5.15.0-163-generic #173-Ubuntu SMP Tue Oct 14 17:51:00 UTC
2025 x86_64 

uid=1002(picotech) gid=1003(picotech) groups=1003(picotech),0(root)  

Safe-mode: OFF (not secure)

/home/picotech/domains/rentals.picotech.app/public_html/server/models/   drwxr-xr-x
Free 23.59 GB of 117.98 GB (19.99%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Self remove    Logout    

Viewing file:     Room.js (2.11 KB)      -rw-r--r--

import { DataTypes } from 'sequelize';
import sequelize from '../config/database.js';

const Room = sequelize.define('Room', {
  id: {
    type: DataTypes.UUID,
    defaultValue: DataTypes.UUIDV4,
    primaryKey: true
  },
  building_id: {
    type: DataTypes.UUID,
    allowNull: false,
    references: {
      model: 'buildings',
      key: 'id'
    }
  },
  floor_id: {
    type: DataTypes.UUID,
    allowNull: false,
    references: {
      model: 'floors',
      key: 'id'
    }
  },
  room_number: {
    type: DataTypes.STRING,
    allowNull: false
  },
  total_beds: {
    type: DataTypes.INTEGER,
    allowNull: true,
    validate: {
      min: 1
    }
  },
  status: {
    type: DataTypes.ENUM('available', 'occupied', 'maintenance', 'booked'),
    defaultValue: 'available'
  },
  renter_id: {
    type: DataTypes.STRING,
    allowNull: true,
  },
  occupied_beds: {
    type: DataTypes.INTEGER,
    defaultValue: 0,
    validate: {
      min: 0
    }
  },
  rent_per_bed: {
    type: DataTypes.DECIMAL(10, 2),
    allowNull: false,
    validate: {
      min: 0
    }
  },
  facilities: {
    type: DataTypes.JSON,
    defaultValue: []
  },
  room_type: {
    type: DataTypes.ENUM('single', 'shared', 'family', 'studio'),
    defaultValue: 'shared'
  },
  area: {
    type: DataTypes.DECIMAL(8, 2),
    allowNull: true
  },
  has_balcony: {
    type: DataTypes.BOOLEAN,
    defaultValue: false
  },
  has_attached_bathroom: {
    type: DataTypes.BOOLEAN,
    defaultValue: false
  },
  furnishing_status: {
    type: DataTypes.ENUM('furnished', 'semi_furnished', 'unfurnished'),
    defaultValue: 'furnished'
  },
  condition: {
    type: DataTypes.ENUM('excellent', 'good', 'fair', 'needs_repair'),
    defaultValue: 'good'
  },
  last_cleaned: {
    type: DataTypes.DATE,
    allowNull: true
  },
  security_deposit: {
    type: DataTypes.DECIMAL(10, 2),
    defaultValue: 0
  },
  available_from: {
    type: DataTypes.DATE,
    allowNull: true
  },
  reservation_note: {
    type: DataTypes.TEXT,
    allowNull: true,
  },
}, {
  tableName: 'rooms', // ✅ ensure consistent foreign key resolution
  timestamps: true ,
});

export default Room;