VineyardTypes

idtypeName
1Red
2White
3Rosé

Countries

countryIdcountryName
1France
2Italy
3Spain

Regions

regionIdregionNamecountryId
(→ Countries.countryId)
1Bordeaux1
2Tuscany2
3La Rioja3

Vineyards

vineyardIdnameareaSizetypeIdregionId
(→ VineyardTypes.id)(→ Regions.regionId)
1Château Lafite Rothschild500.011
2Antinori Toscano400.022
3Marqués de Riscal600.013
4Domaine Leflaive100.03None
5Felsina150.022

Wines

wineIdnamevariety
1Cabernet SauvignonCabernet Sauvignon
2MerlotMerlot
3Pinot NoirPinot Noir

Vineyards_Wines

vineyardIdwineIdyearProduced
(→ Vineyards.vineyardId)(→ Wines.wineId)
112018
112019
222020
222021
332017
432016
212020
312017
412016
51None