Database Schemata

beer • world • support •

beer Tables

beers • brands • breweries •

world Tables

cities • continents • countries • country_codes • langs • names • places • regions • usages •

support Tables

logs • props • taggings • tags •

beer Tables

beers • brands • breweries •

Table beers

Name	Type		Default	Description
id	integer
key	varchar
title	varchar
synonyms	varchar	NOT NULL
web	varchar	NOT NULL
since	integer	NOT NULL
seasonal	boolean		f
limited	boolean		f
kcal	decimal	NOT NULL
abv	decimal	NOT NULL
og	decimal	NOT NULL
srm	integer	NOT NULL
ibu	integer	NOT NULL
brewery_id	integer	NOT NULL
brand_id	integer	NOT NULL
grade	integer		4
txt	varchar	NOT NULL
txt_auto	boolean		f
country_id	integer
region_id	integer	NOT NULL
city_id	integer	NOT NULL
created_at	datetime	NOT NULL
updated_at	datetime	NOT NULL

Table brands

Name	Type		Default	Description
id	integer
key	varchar
title	varchar
synonyms	varchar	NOT NULL
web	varchar	NOT NULL
wiki	varchar	NOT NULL
since	integer	NOT NULL
global	boolean		f
internl	boolean		f
national	boolean		f
regional	boolean		f
local	boolean		f
grade	integer		4
txt	varchar	NOT NULL
txt_auto	boolean		f
brewery_id	integer	NOT NULL
country_id	integer
region_id	integer	NOT NULL
city_id	integer	NOT NULL
created_at	datetime	NOT NULL
updated_at	datetime	NOT NULL

Table breweries

Name	Type		Default	Description
id	integer
key	varchar
title	varchar
synonyms	varchar	NOT NULL
address	varchar	NOT NULL
since	integer	NOT NULL
closed	integer	NOT NULL
brewpub	boolean		f
prod_m	boolean		f
prod_l	boolean		f
prod	integer	NOT NULL
prod_grade	integer	NOT NULL
grade	integer		4
txt	varchar	NOT NULL
txt_auto	boolean		f
web	varchar	NOT NULL
wikipedia	varchar	NOT NULL
indie	boolean	NOT NULL
abinbev	boolean	NOT NULL
sabmiller	boolean	NOT NULL
heineken	boolean	NOT NULL
carlsberg	boolean	NOT NULL
molsoncoors	boolean	NOT NULL
diageo	boolean	NOT NULL
country_id	integer
region_id	integer	NOT NULL
city_id	integer	NOT NULL
created_at	datetime	NOT NULL
updated_at	datetime	NOT NULL

world Tables

cities • continents • countries • country_codes • langs • names • places • regions • usages •

Table cities

Name	Type		Default	Description
id	integer
name	varchar
key	varchar
place_id	integer
code	varchar	NOT NULL
alt_names	varchar	NOT NULL
country_id	integer
region_id	integer	NOT NULL
city_id	integer	NOT NULL
pop	integer	NOT NULL
popm	integer	NOT NULL
area	integer	NOT NULL
m	boolean		f
c	boolean		f
d	boolean		f
created_at	datetime	NOT NULL
updated_at	datetime	NOT NULL

Table continents

Name	Type		Default	Description
id	integer
name	varchar
slug	varchar
key	varchar
place_id	integer
alt_names	varchar	NOT NULL
created_at	datetime	NOT NULL
updated_at	datetime	NOT NULL

Table countries

Name	Type		Default	Description
id	integer
name	varchar
slug	varchar
key	varchar
place_id	integer
code	varchar
alt_names	varchar	NOT NULL
hist_names	varchar	NOT NULL
pop	integer
area	integer
continent_id	integer	NOT NULL
country_id	integer	NOT NULL
s	boolean		f
c	boolean		f
d	boolean		f
m	boolean		f
motor	varchar	NOT NULL
alpha2	varchar	NOT NULL
alpha3	varchar	NOT NULL
num	varchar	NOT NULL
fifa	varchar	NOT NULL
ioc	varchar	NOT NULL
fips	varchar	NOT NULL
net	varchar	NOT NULL
wikipedia	varchar	NOT NULL
created_at	datetime	NOT NULL
updated_at	datetime	NOT NULL

Table country_codes

Name	Type		Default	Description
id	integer
name	varchar
kind	varchar
country_id	integer

Table langs

Name	Type		Default	Description
id	integer
key	varchar
name	varchar
created_at	datetime	NOT NULL
updated_at	datetime	NOT NULL

Table names

Name	Type		Default	Description
id	integer
name	varchar
place_id	integer
lang	varchar		en
created_at	datetime	NOT NULL
updated_at	datetime	NOT NULL

Table places

Name	Type		Default	Description
id	integer
name	varchar
kind	varchar
lat	float	NOT NULL
lng	float	NOT NULL
created_at	datetime	NOT NULL
updated_at	datetime	NOT NULL

Table regions

Name	Type		Default	Description
id	integer
name	varchar
key	varchar
place_id	integer
code	varchar	NOT NULL
abbr	varchar	NOT NULL
iso	varchar	NOT NULL
nuts	varchar	NOT NULL
alt_names	varchar	NOT NULL
country_id	integer
pop	integer	NOT NULL
area	integer	NOT NULL
created_at	datetime	NOT NULL
updated_at	datetime	NOT NULL

Table usages

Name	Type		Default	Description
id	integer
country_id	integer
lang_id	integer
official	boolean		t
minor	boolean		f
percent	float	NOT NULL
created_at	datetime	NOT NULL
updated_at	datetime	NOT NULL

support Tables

logs • props • taggings • tags •

Table logs

Name	Type		Default	Description
id	integer
msg	varchar
level	varchar
app	varchar	NOT NULL
tag	varchar	NOT NULL
pid	integer	NOT NULL
tid	integer	NOT NULL
ts	varchar	NOT NULL
created_at	datetime	NOT NULL
updated_at	datetime	NOT NULL

Table props

Name	Type		Default	Description
id	integer
key	varchar
value	varchar
kind	varchar	NOT NULL
created_at	datetime	NOT NULL
updated_at	datetime	NOT NULL

Table taggings

Name	Type		Default	Description
id	integer
tag_id	integer
taggable_id	integer
taggable_type	varchar
created_at	datetime	NOT NULL
updated_at	datetime	NOT NULL

Table tags

Name	Type		Default	Description
id	integer
key	varchar
slug	varchar
name	varchar	NOT NULL
grade	integer		1
parent_id	integer	NOT NULL
created_at	datetime	NOT NULL
updated_at	datetime	NOT NULL