Right, one last column to add: "eventtypeoverride" to winenotes, in case I ever buy 2 bottles (eventtype=1) but decide to take notes having brought one bottle to a restaurant (event_type 3). And if more advanced analysis were ever required, it would be a simple matter to say that if eventtypeoverride=null, event_type=1.
Because if I ordered the wine in the restaurant (i.e. not BYOB), the wines table would have a record for it with event_type=3, with no need for an override.
This makes my head hurt just a touch. Good thing I had my afternoon coffee.