## VineyardTypes

id | typeName
--- | ---
1 | Red
2 | White
3 | Rosé

## Countries

countryId | countryName
--- | ---
1 | France
2 | Italy
3 | Spain

## Regions

regionId | regionName | countryId
--- | --- | ---
|  | (→ Countries.countryId)
1 | Bordeaux | 1
2 | Tuscany | 2
3 | La Rioja | 3

## Vineyards

vineyardId | name | areaSize | typeId | regionId
--- | --- | --- | --- | ---
|  |  | (→ VineyardTypes.id) | (→ Regions.regionId)
1 | Château Lafite Rothschild | 500.0 | 1 | 1
2 | Antinori Toscano | 400.0 | 2 | 2
3 | Marqués de Riscal | 600.0 | 1 | 3
4 | Domaine Leflaive | 100.0 | 3 | None
5 | Felsina | 150.0 | 2 | 2

## Wines

wineId | name | variety
--- | --- | ---
1 | Cabernet Sauvignon | Cabernet Sauvignon
2 | Merlot | Merlot
3 | Pinot Noir | Pinot Noir

## Vineyards_Wines

vineyardId | wineId | yearProduced
--- | --- | ---
(→ Vineyards.vineyardId) | (→ Wines.wineId) |
1 | 1 | 2018
1 | 1 | 2019
2 | 2 | 2020
2 | 2 | 2021
3 | 3 | 2017
4 | 3 | 2016
2 | 1 | 2020
3 | 1 | 2017
4 | 1 | 2016
5 | 1 | None