id | typeName |
---|---|
1 | Red |
2 | White |
3 | Rosé |
countryId | countryName |
---|---|
1 | France |
2 | Italy |
3 | Spain |
regionId | regionName | countryId |
---|---|---|
(→ Countries.countryId) | ||
1 | Bordeaux | 1 |
2 | Tuscany | 2 |
3 | La Rioja | 3 |
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 |
wineId | name | variety |
---|---|---|
1 | Cabernet Sauvignon | Cabernet Sauvignon |
2 | Merlot | Merlot |
3 | Pinot Noir | Pinot Noir |
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 |