text: DROP TABLE IF EXISTS weathers;
  DROP TABLE IF EXISTS locations;
  
  CREATE TABLE locations ( 
      id SERIAL PRIMARY KEY, 
      search_query VARCHAR(255), 
      formatted_query VARCHAR(255), 
      latitude NUMERIC(8, 6), 
      longitude NUMERIC(9, 6) 
    );
  
  CREATE TABLE weathers ( 
      id SERIAL PRIMARY KEY, 
      forecast VARCHAR(255), 
      time VARCHAR(255), 
      location_id INTEGER NOT NULL,
      FOREIGN KEY (location_id) REFERENCES locations (id)
    );
  
  CREATE TABLE IF NOT EXISTS yelps (
    id SERIAL PRIMARY KEY, 
    name VARCHAR(255), 
    image_url VARCHAR(255), 
    price CHAR(5), 
    rating NUMERIC(2,1), 
    url VARCHAR(255), 
    location_id INTEGER NOT NULL REFERENCES locations(id) 
  );
  
  CREATE TABLE IF NOT EXISTS movies ( 
    id SERIAL PRIMARY KEY, 
    title VARCHAR(255), 
    overview VARCHAR(1000), 
    average_votes NUMERIC(4,2), 
    total_votes INTEGER, 
    image_url VARCHAR(255), 
    popularity NUMERIC(6,4), 
    released_on CHAR(10), 
    location_id INTEGER NOT NULL REFERENCES locations(id) 
  );