Screen section - Notebook - Drinks

The main section of the screen shows in the lower portion a notebook with details about your drinks.

When you work with your drinks you will see a notebook with 8 or 9 tabs.

Drink details

Shows information such as the drink name, supplier, type, origin etc

Vintages/Bottles

Shows information for a particular vintage and bottle size, this is currently sub-divided into another notebook with three tabs, one for Vintage details, one for Additional vintage details, and one for Bottle details with some commonly used functions accessible through the buttons on the right.

Purchases

Shows all the purchases for the particular drink/vintage/bottle size

Consumptions

Shows all the consumptions for the particular drink/vintage/bottle size

Tastings

Shows the details about the tastings you recorded for this drink

Ratings

Shows the details about ratings (tastings done by others, e.g. Robert Parker, RVF etc) you recorded for this drink

Images

Shows images (bottle label, vineyard etc) for this drink

Pairs with

Shows what ingredient, ingredient group or recipe this wine goes well with - see Wine Families - as defined by Larousse des Vins

Optional tab - depending on what you defined in the preferences.

Tags/Owners

This tab is optional, you need to activate bottle tags in preferences.

It shows tag numbers you have assigned to this drink and optionally you can enter additional owner details per tag.

Database organization

It might be helpful to explain a little bit on how your data is structured in “The Wine Cellar Book”.

Images always express things much better then words.

Click on the image to see an enlarged version, and use the browser’s back button to return to this page

The image above shows you a very very basic view of the database design.

Note

The database as of Version 3 for “The Wine Cellar Book” contains over 100 tables, about 10 views and over 270 indices.

CELLARBOOK table

This table contains the description of each drink, e.g. name, region, etc., it is represented on the Drink details tab.

CBVINTAGE table

This table contains the information per vintage, e.g. vintage, alcohol, etc., it is represented on the Vintage details sub-tab on Vintage/Bottle details tab.

WINEINFO table

This table contains additional vintage information for drinks, it is represented on the Additional Vintage details tab.

SPIRINFO table

This table contains additional vintage information for spirits, e.g. whiskies, it is represented on the Additional Vintage details tab.

CBBOTTLE table

This table contains the information per bottle size, e.g. bottle size, storage location, etc., it is represented on the Bottle details sub-tab on the Vintage/Bottle details tab.

PURCHASE table

This table contains the information per purchase, e.g. quantity, purchase price, price in your currency, etc., it is represented on the Purchases tab.

CONSUMPTION table

This table contains the information per consumption, e.g. quantity, reason, etc., it represented on the Consumptions tab.

This structure has many advantages, following are just a few:

• Data is NOT duplicated
• If later on you purchase another vintage you would use the Screen section - Tool Bar tool bar button. This ensures that this vintage is linked with the vintage you previously purchased and it also means that you do not need to enter the basic drink information (name, region etc.) again.
• If ever you made a mistake on the drink name you just change it ones.
• When you look for a particular drink, the system can immediately show you other vintages and/or bottle sizes of the same wine you have in the cellar.

It is a bit inconvenient to have to go to multiple tabs to enter information, that is why we provided the Dialog - Purchase a new drink tool bar button which allows you to enter all the data on one screen and the system will take care to store it in the appropriate tables.

Note

• Keep in mind that if you change something on the Drink details tab it should be valid for all the vintages/bottle sizes for that drink.
• If you purchase the same drink from a different suppliers then you should enter the principal supplier on the Drink details tab and other suppliers you enter on the Purchase detail tab for the purchase in question.
• Notes about a particular vintage you should enter on the Vintage details tab.