Foodcounts homepage | Email us

Database hierarchy

7-counts menu

 
FOODCOUNTS PRODUCT DATABASE (convenience foods) 

the database will consist of around 1200 packaged convenience food items. The core data will be drawn from Asda and Tesco product lists. This first level hierarchy [product classification system] is based on the ASDA tiers. 
 

 
LEVEL
[code range]
 
DATABASE HIERARCHY
 
 
EXAMPLES / COMMENTS
 1.        [0-9]
data base manager
Foodcounts [Consensus Software]
 2.        [0-9]
data source
Asda, Tesco, Heinz etc
 3.        [0-9]
food type
all foods with labels
 4.      [0-99]
food category
store aisles  e.g. frozen food
 5.      [0-99]
food set
store-sections e.g. frozen meat
 6.      [0-99]
food class
store-shelves e.g. burgers
 7.    [0-999]
brand
e.g. Kellogs, Asda etc
 8.     [ 0-99]
Product and size
= product barcode
 
 
PRODUCT LABEL INFO 
 
 9.  [0-9999]
Ingredients list on pack
Maps to FDA free database
10.   [grams]
Size of pack
Maps to all sizes of same product
11.     [0-99]
Packaging
Coded list of all packaging types
12.        days
Storage-from purchase
Maps to level 4
13.      hours
Storage-from opening pack
Assumes refrigeration
14.     [0-99]
Freezing instructions
Coded list of methods
15.     [0-99]
Defrosting instructions
Coded list of methods
16.     [mins]
Defrosting period
 
17.     [0-99]
Serving instructions
Coded list of methods
18.   [grams]
Serving portions
 
19.     [0-99]
Hob cooking instructions
Coded list of methods
20.     [mins]
Hob cooking period
 
21.     [0-99]
Oven cooking instructions
Coded list of methods +oven types
22.     [mins]
Oven cooking period
 
23.   [centg.]
Oven cooking temperatures
23a. Fahrenheit?
24.     [0-99]
Microwave instructions
Coded list of methods and types
25.     [mins]
Microwave period
 
26      [mins]
Microwave split period
Split time / maps to 25
27.
NUTRITION INFO
Connect to separate data base?
28.
MANUFACTURERS INO
Info panels
29
CONSUMER COMMENTS
Via email?
30-99
Add-in levels?