CREATE TABLE geographic
(
    city   TEXT not null
        primary key,
    county TEXT null,
    region TEXT null
);
geographic
CREATE TABLE generalinfo
(
    id_restaurant INTEGER         not null
        primary key,
    label         TEXT  null,
    food_type     TEXT  null,
    city          TEXT  null,
    review        REAL null,
    foreign key (city) references geographic(city)
            on update cascade on delete cascade
);
generalinfo
CREATE TABLE location
(
    id_restaurant INTEGER        not null
        primary key,
    street_num    INTEGER          null,
    street_name   TEXT null,
    city          TEXT null,
    foreign key (city) references geographic (city)
            on update cascade on delete cascade,
    foreign key (id_restaurant) references generalinfo (id_restaurant)
            on update cascade on delete cascade
);
location
original_column_name,column_name,column_description,data_format,value_description,Unnamed: 5,Unnamed: 6
id_restaurant,id restaurant,the unique id for the restaurant,integer,,,
street_num,street number,the street number of the restaurant,integer,,,
street_name,street name,the street name of the restaurant,text,,,
city,,the city where the restaurant is located in,text,,,
,,,,,,
,,,,,,
,,,,,,
,,,,,,
,,,,,,
location
original_column_name,column_name,column_description,data_format,value_description
id_restaurant,id restaurant,the unique id for the restaurant,integer,
label,,the label of the restaurant,text,
food_type,food type,the food type,text,
city,,the city where the restaurant is located in,text,
review,,the review of the restaurant,real,"commonsense evidence:
the review rating is from 0.0 to 5.0
The high review rating is positively correlated with the overall level of the restaurant. The restaurant with higher review rating is usually more popular among diners. "
generalinfo
original_column_name,column_name,column_description,data_format,value_description
city,,the city,text,
county,country,the country the city belongs to,text,
region,,corresponding regions,text,
geographic