=== Table: ulb_bodies === id (int(10) unsigned) code (varchar(50)) name_en (varchar(150)) name_mr (varchar(150)) ulb_type (varchar(50)) district (varchar(60)) division (varchar(60)) established_year (year(4)) address (text) commissioner_name (varchar(100)) email (varchar(100)) phone (varchar(30)) logo_url (varchar(255)) active (tinyint(1)) created_at (timestamp) updated_at (timestamp) === Table: wards === id (int(10) unsigned) ulb_id (int(10) unsigned) zone_id (int(10) unsigned) ward_no (varchar(20)) name_en (varchar(100)) name_mr (varchar(100)) prabhag_samiti (varchar(100)) population (int(10) unsigned) area_sqkm (decimal(8,2)) active (tinyint(1)) created_at (timestamp) === Table: zones === id (int(10) unsigned) ulb_id (int(10) unsigned) zone_no (int(11)) name_en (varchar(100)) name_mr (varchar(100)) office_address (text) ward_officer_name (varchar(100)) phone (varchar(30)) created_at (timestamp) === Table: buildings === id (int(10) unsigned) complex_id (int(10) unsigned) building_code (varchar(50)) name_en (varchar(100)) name_mr (varchar(100)) construction_type (enum('RCC','LOAD_BEARING','STEEL_FRAME','PRE_FABRICATED')) total_floors (int(11)) oc_number (varchar(80)) oc_date (date) built_up_area_sqm (decimal(10,2)) active (tinyint(1)) === Table: floors === id (int(10) unsigned) building_id (int(10) unsigned) floor_number (int(11)) floor_name_en (varchar(50)) floor_name_mr (varchar(50)) total_units (int(11)) floor_plan_url (varchar(255))