beer.db database schema (tables, views, etc.) scripts (in SQL) and documentation
The beer.db includes the following tables:
- beers (belongs to brewery n brand) e.g. Guiness Extra Stout
- brands (has many beers; belongs to brewery) e.g. Guiness
- breweries (has many brands n beers) e.g. St. James's Gate Brewery / Guinness Brewery
- tags e.g. irish_dry_stout, stout
- taggings (join table)
For more see the beer.db.sql script.
Send them along to the Open Beer, Breweryn n Brewpub Data Forum/Mailing List. Thanks!