drinkers

group: drinkers 

DRINKER = { Did, NAME, ADDRESS, TYPE
1, 'John Smith', '123 fake st', 'Social'
2, 'Marc Antoine', '123 fake st', 'Social'
3, 'Tommy Hicks', '123 fake st', 'Social'
4, 'Paul weaver', '123 fake st', 'Social'
5, 'Courtney Shaw', '123 fake st', 'Social'
}

WINE = { Wid, Vineyard, Vintage, Variety, Percent
1, 'Martha', 2000, 'Cabernet', 11
2, 'Bob', 2002, 'Pinot Gris', 11
3, 'Chad', 2015, 'Pinot Noir', 11
4, 'Alice', 1980, 'Albarino', 15
5, 'Sam', 2020, 'Merlot', 13
}

DRINK = { Wid, Did, Date, Quantity
1, 1, '2022-01-01', 1
2, 1, '2022-01-01', 1
2, 2, '2022-02-01', 2
3, 3, '2022-03-01', 3
4, 4, '2022-04-01', 4
5, 5, '2022-05-01', 5
}

LIKES = { Did, Wid
1, 1
1, 2
1, 3
2, 2
3, 3
4, 4
5, 1
}