How to catalog or classify tea?
I'm thinking about writing a little tea database to keep track of what
I buy, where I buy it, and what I like and don't like.
I ran into a little snag. I am not sure how best to categorize the
various teas?
I think I more or less understand the basic "types" (red/black, green,
oolong, white, etc.).
I am not sure about specific teas or varieties. Many vendors sell
generic types like Earl Grey, Gunpowder, Irish Breakfast, etc. I
believe most of these are blends or more than one tea and most vendors
sell more than one type of Earl Grey.
My basic question is how to best categorize each tea so that I am
comparing apples to apples?
My current plan is to have a "Purchases" table. It would have one
entry for each tea I purchase. Some of the fields it would contain
include:
Name of the tea (from the vendor)
Vendor
Product number
Date
Amount
Cost
Type (black, green, etc.)
I would then have a a "Brews" table with one entry for each pot I
brew. It would have fields like:
Date
Tea (link to Purchases table)
Amount of tea
Amount of water
Temperature
Time
Rating
Comments
Is this a good start?
The next step would be to compare simlar teas. Or does it even make
any sense to compare an Earl Grey from different vendors?
|