Checking property_entries table...

Property entries table structure:
- id (bigint(20) unsigned)
- title (varchar(191))
- surname (varchar(191))
- firstname (varchar(191))
- mobile (varchar(191))
- residential_address (text)
- suburb (varchar(191))
- landmark (varchar(191))
- valuable_no (varchar(191))
- location_mobile (varchar(191))
- email (varchar(191))
- street_name (varchar(191))
- landline (varchar(191))
- longitude (varchar(191))
- latitude (varchar(191))
- property_type (varchar(191))
- occupier (varchar(191))
- valuation_number (varchar(191))
- rate_code (varchar(191))
- rate (decimal(15,2))
- rateable_value (decimal(15,2))
- previous_arrears (decimal(15,2))
- collector_full_name (varchar(191))
- collector_phone (varchar(191))
- collector_id_type (varchar(191))
- collector_id_number (varchar(191))
- guarantor_name (varchar(191))
- guarantor_phone (varchar(191))
- guarantor_address (text)
- clearing_status (enum('cleared','uncleared'))
- created_by (bigint(20) unsigned)
- status (tinyint(1))
- deleted (tinyint(1))
- created_at (timestamp)
- updated_at (timestamp)

Property entries with rate combinations:

Total property entries: 0
Property entries with rate codes: 0
Property entries with both type and rate code: 0