beer - Table definition

Privacy & Cookies
We request your permission to obtain statistical data of your navigation in this web.
If you continue browsing we consider that you accept the use of cookies.

Review Cookies Policy

table beer

General information

Table: beer

Description: beer

Type: Master

Rows: 3,075

columns: 12

Data: 16,342

columns

field	description	Type	Unit	foreign table
id	Unique identifier	Integer
name	name	Text
image	image	Text
id_Fermentation	Fermentation	foreign key		type of Fermentation
id_type	type	foreign key		type of beer
Alcohol_percentage	Alcohol percentage	Percentage	%
Bitterness_level	Bitterness level	Integer	EBU
date_Start	date start	Date
id_brewery	brewery	foreign key		brewery
id_Color	color	foreign key		color
id_place_of_origin	place of origin	foreign key		place
taste	taste	Text

Relations

description	related table	relationship table
beer/ingredient	food	beer_ingredient
beer/crop	type_crop	beer_crop
beer/hop	type_hop	beer_hop
beer/finishing	type_finishing	beer_finishing

Table in which FK is located

table	field
beer/ingredient	id_beer
beer/crop	id_beer
beer/finishing	id_beer
beer/hop	id_beer