=== Table: complexes ===
  id (int(10) unsigned)
  ulb_id (int(10) unsigned)
  ward_id (int(10) unsigned)
  zone_id (int(10) unsigned)
  address (text)
  land_property_id (int(10) unsigned)
  property_id (int(10) unsigned)
  complex_code (varchar(50))
  name_en (varchar(150))
  complex_name (varchar(150))
  name_mr (varchar(150))
  complex_name_marathi (varchar(150))
  category (enum('COMMERCIAL_COMPLEX','HAWKER_PLAZA','VEG_FISH_MARKET','MULTIPURPOSE_HALL','SPORTS_COMPLEX','MUNICIPAL_MALL','OFFICE_BUILDING'))
  total_buildings (int(11))
  total_units (int(11))
  construction_year (year(4))
  ready_reckoner_rate_sqm (decimal(12,2))
  gis_latitude (decimal(10,8))
  latitude (decimal(10,8))
  gis_longitude (decimal(11,8))
  longitude (decimal(11,8))
  geojson_polygon (longtext)
  qr_code_uid (varchar(64))
  photo_url (varchar(255))
  active (tinyint(1))
  created_at (timestamp)
  survey_no (varchar(60))
  plot_no (varchar(60))
  built_up_area (decimal(12,2))
  carpet_area (decimal(12,2))
  number_of_buildings (int(11))
  number_of_floors (int(11))
  ownership_type (enum('MUNICIPAL_OWNED','GOVT_LEASED','ACQUIRED_RESERVATION','DONATED'))
  property_status (enum('OPERATIONAL','UNDER_CONSTRUCTION','UNDER_MAINTENANCE','REDEVELOPMENT'))
  estimated_property_value (decimal(14,2))
  book_value (decimal(14,2))
  construction_cost (decimal(14,2))
  property_tax_assessment_no (varchar(60))
  electricity_connection_no (varchar(60))
  water_connection_no (varchar(60))
  fire_noc_no (varchar(60))
  remarks (text)
  status (enum('ACTIVE','INACTIVE','SEALED','LITIGATION'))
=== Table: users ===
  id (int(10) unsigned)
  ulb_id (int(10) unsigned)
  department_id (int(10) unsigned)
  designation_id (int(10) unsigned)
  name (varchar(100))
  username (varchar(60))
  email (varchar(100))
  phone (varchar(30))
  password_hash (varchar(255))
  role (varchar(50))
  status (enum('ACTIVE','INACTIVE','SUSPENDED'))
  created_at (timestamp)
  updated_at (timestamp)
=== Table: units_galas ===
  id (int(10) unsigned)
  ulb_id (int(10) unsigned)
  ward_id (int(10) unsigned)
  complex_id (int(10) unsigned)
  building_id (int(10) unsigned)
  floor_id (int(10) unsigned)
  unit_code (varchar(60))
  unit_number (varchar(30))
  shop_no (varchar(30))
  unit_name (varchar(100))
  category (enum('SHOP','OFFICE','STALL','ATM','BANK','GODOWN','RESTAURANT','COMMUNITY_HALL','PLOT'))
  unit_type (enum('SHOP','OFFICE','STALL','HALL','ATM','PARKING','OPEN_AREA','GODOWN','RESTAURANT','OTHER'))
  length_ft (decimal(6,2))
  width_ft (decimal(6,2))
  carpet_area_sqft (decimal(10,2))
  builtup_area (decimal(10,2))
  built_up_area_sqft (decimal(10,2))
  carpet_area_sqm (decimal(10,2))
  shutter_size (varchar(40))
  frontage (varchar(40))
  front_facing (enum('MAIN_ROAD','INTERNAL_CORRIDOR','CORNER','BACKWARD'))
  electricity_meter_no (varchar(60))
  water_connection_no (varchar(60))
  base_ready_reckoner_rent (decimal(12,2))
  current_market_rent (decimal(12,2))
  qr_code_hash (varchar(64))
  status (enum('VACANT','OCCUPIED','UNDER_RENOVATION','UNDER_DISPUTE','SEALED','UNAUTHORIZED','RESERVED','ALLOTTED','TERMINATED'))
  created_at (timestamp)
  updated_at (timestamp)
  usage_type (enum('COMMERCIAL_RETAIL','WHOLESALE','COMMERCIAL_OFFICE','BANKING_FINANCE','HOSPITALITY_FOOD','COMMUNITY_SOCIAL','STORAGE_WAREHOUSE'))
  floor_position (enum('FRONT_FACING','CORRIDOR_INSIDE','CORNER_PRIME','REAR_BACK'))
  water_meter_no (varchar(60))
  current_status (enum('VACANT','OCCUPIED','UNDER_RENOVATION','UNDER_DISPUTE','SEALED','UNAUTHORIZED','RESERVED','ALLOTTED','TERMINATED'))
  occupancy_status (enum('FREE_FOR_ALLOTMENT','CURRENTLY_LEASED','SUBLET_UNAUTHORIZED','LEGAL_SUIT_STAY','RESERVED_QUOTA'))
  reservation_category (enum('GENERAL_OPEN','DIVYANG','WOMEN_SHG','SC_ST','OBC','EX_SERVICEMEN'))
  market_rate (decimal(12,2))
  base_rent (decimal(12,2))
  security_deposit (decimal(12,2))
  premium_amount (decimal(12,2))
  opening_date (date)
  closing_date (date)
  qr_code (varchar(100))
  latitude (decimal(10,8))
  longitude (decimal(11,8))
  remarks (text)
  previous_tenant_name (varchar(150))
  last_paid_rent (decimal(12,2))
  expected_rent (decimal(12,2))
  vacant_since_date (date)
  vacancy_reason (varchar(255))
  recommended_action (varchar(255))
=== Table: hall_booking_slots ===
  id (int(10) unsigned)
  unit_id (int(10) unsigned)
  booking_date (date)
  slot (varchar(20))
  booking_id (int(10) unsigned)
  status (enum('CONFIRMED','BLOCKED'))
  created_at (timestamp)
=== Table: hall_bookings ===
  id (int(10) unsigned)
  ulb_id (int(10) unsigned)
  unit_id (int(10) unsigned)
  booking_reference_no (varchar(60))
  applicant_name (varchar(150))
  applicant_mobile (varchar(20))
  applicant_aadhaar (varchar(20))
  purpose (enum('WEDDING','RECEPTION','CULTURAL_EVENT','PUBLIC_MEETING','EXHIBITION','BIRTHDAY'))
  start_date (date)
  end_date (date)
  slot (enum('FULL_DAY','DAY_SLOT','NIGHT_SLOT'))
  rent_amount (decimal(10,2))
  cleaning_charges (decimal(8,2))
  security_deposit (decimal(10,2))
  total_payable (decimal(10,2))
  payment_status (enum('CONFIRMED','CANCELLED','REFUNDED'))
  created_at (timestamp)
  booking_status (enum('REQUESTED','DOCS_VERIFIED','PAYMENT_PENDING','CONFIRMED','REJECTED','CANCELLED'))
  document_verification_status (enum('PENDING','VERIFIED','REJECTED'))
  verified_by (int(10) unsigned)
  verification_notes (text)
  payment_mode (varchar(50))
  transaction_ref (varchar(100))
  approval_order_no (varchar(100))
  approved_by (int(10) unsigned)
  approved_at (datetime)
  event_name (varchar(150))