=== CHECKING COLUMN EXISTENCE ===

ROOMS TABLE COLUMNS:
  - id
  - property_id
  - room_number
  - title
  - description
  - room_type
  - price
  - security_deposit
  - room_size
  - max_occupants
  - furnishing
  - bathroom_type
  - kitchen_type
  - amenities
  - floor
  - available_from
  - min_stay
  - status
  - is_featured
  - for_sale
  - sale_price
  - views
  - created_at
  - updated_at
  - land_size
  - boundary_type
  - zoning
  - legal_status

❌ rooms.images DOES NOT EXIST
Available image-related columns: 

USERS TABLE COLUMNS:
  - id
  - email
  - password
  - full_name
  - phone
  - user_type
  - profile_image
  - status
  - email_verified
  - phone_verified
  - created_at
  - updated_at
  - last_login

✅ users.phone EXISTS

=== TESTING QUERY COLUMNS ===

TEST 1: Minimal query (just b.*, r.title)
✅ SUCCESS - 0 rows

TEST 2: Add r.price
✅ SUCCESS - 0 rows

TEST 3: Add r.room_type
✅ SUCCESS - 0 rows

TEST 4: Add r.images
❌ FAILED - r.images doesn't exist!

TEST 5: Add property columns
✅ SUCCESS - 0 rows

TEST 6: Add u.full_name
✅ SUCCESS - 0 rows

TEST 7: Add u.phone
✅ SUCCESS - 0 rows

=== END OF TESTS ===