CREATE TABLE breweries
(
    id    INTEGER          not null
        primary key,
    name  TEXT null,
    city  TEXT null,
    state TEXT null
);
breweries
CREATE TABLE "beers"
(
    id         INTEGER not null
        primary key,
    brewery_id INTEGER not null
        constraint beers_ibfk_1
            references breweries,
    abv        REAL,
    ibu        REAL,
    name       TEXT    not null,
    style      TEXT,
    ounces     REAL    not null
);
beers
original_column_name,column_name,column_description,data_format,value_description
id,id,unique ID of the breweries,integer,
name,name,name of the breweries,text,
city,,city,text,
state,,state,text,
Breweries
original_column_name,column_name,column_description,data_format,value_description
id,,unique id number of beers,integer,
brewery_id,brewery id,id number of the breweries,integer ,
abv,alcohol by volume,alcohol by volume,text,Alcohol by VolumeABV is the most common measurement of alcohol content in beer; it simply indicates how much of the total volume of liquid in a beer is made up of alcohol. 
ibu,International Bitterness Units,International Bitterness Units,real,"IBU stands for International Bitterness Units, a scale to gauge the level of a beer's bitterness. More specifically, IBUs measure the parts per million of is humulone from hops in a beer, which gives beer bitterness."
name,,name of beers,text,
style,,style / sorts of beers,text,
ounces,,ounces,real,
Beers