-- Rename columns to match frontend field names
ALTER TABLE hbcc_providers RENAME COLUMN assistant_caregivers TO has_assistant_caregivers;
ALTER TABLE hbcc_providers RENAME COLUMN fee_per_child_per_day TO fee_per_child;
ALTER TABLE hbcc_providers RENAME COLUMN payment_methods TO payment_method;
ALTER TABLE hbcc_providers RENAME COLUMN typical_daily_expense TO daily_expense;
ALTER TABLE hbcc_providers RENAME COLUMN expense_food TO food_expense;
ALTER TABLE hbcc_providers RENAME COLUMN expense_activities_supplies TO supplies_expense;
ALTER TABLE hbcc_providers RENAME COLUMN affordability_food TO food_affordability;
ALTER TABLE hbcc_providers RENAME COLUMN affordability_activities_supplies TO supplies_affordability;
ALTER TABLE hbcc_providers RENAME COLUMN affordability_utilities TO utilities_affordability;
ALTER TABLE hbcc_providers RENAME COLUMN affordability_rent TO rent_affordability;
ALTER TABLE hbcc_providers RENAME COLUMN familiar_with_health_resources TO familiar_with_resources;
ALTER TABLE hbcc_providers RENAME COLUMN community_health_promoter TO is_chp;
ALTER TABLE hbcc_providers RENAME COLUMN chp_visit TO chp_visit_frequency;
ALTER TABLE hbcc_providers RENAME COLUMN aware_of_health_services TO awareness_level;
ALTER TABLE hbcc_providers RENAME COLUMN health_services_awareness TO services_awareness;
ALTER TABLE hbcc_providers RENAME COLUMN other_health_services TO other_services;
ALTER TABLE hbcc_providers RENAME COLUMN none_health_services TO none_services;
ALTER TABLE hbcc_providers RENAME COLUMN access_to_health_services TO access_level;
ALTER TABLE hbcc_providers RENAME COLUMN specify_other_health_services TO other_health_services;
ALTER TABLE hbcc_providers RENAME COLUMN specify_accessed_health_services TO accessed_services;
ALTER TABLE hbcc_providers RENAME COLUMN up_to_date_health_services TO health_services_status;
ALTER TABLE hbcc_providers RENAME COLUMN up_to_date_vaccinations TO vaccinations_status;
ALTER TABLE hbcc_providers RENAME COLUMN up_to_date_growth_monitoring TO growth_monitoring_status;
ALTER TABLE hbcc_providers RENAME COLUMN up_to_date_deworming TO deworming_status;
ALTER TABLE hbcc_providers RENAME COLUMN up_to_date_vas TO vas_status;
ALTER TABLE hbcc_providers RENAME COLUMN up_to_date_other_health_services TO other_health_services_status;
