CREATE TABLE IF NOT EXISTS hbcc_master (
  id SERIAL PRIMARY KEY,
  provider_code VARCHAR(50) ,
  name VARCHAR(255) ,
  type VARCHAR(100) ,
  hours_of_operation VARCHAR(255) ,
  response_time VARCHAR(100) ,
  county VARCHAR(100) ,
  sub_county VARCHAR(100) ,
  specific_area VARCHAR(255) ,
  nearest_landmark VARCHAR(255) ,
  gps_coordinates VARCHAR(100) ,
  service_names TEXT ,
  category VARCHAR(100) ,
  fee VARCHAR(100) ,
  gender VARCHAR(50) ,
  age_group VARCHAR(100) ,
  description TEXT ,
  full_name VARCHAR(300) ,
  first_name VARCHAR(100) ,
  middle_name VARCHAR(100) ,
  surname VARCHAR(100) ,
  email VARCHAR(255) ,
  phone_number VARCHAR(100) ,
  website VARCHAR(255) ,
  status VARCHAR(20) DEFAULT 'approved',
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
 );