| 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 |