bar-crawl.txt

group: barcrawl
description[[
bar crawl planning database
]]


Bars = { bar:string, address:string, capacity:number, phone:string, owner:string
'Klimperkasten', 'Bodanstrasse 40', 50, '0753123408', 'Freddy'
'Heimat', 'Schreibergasse 2', 100, '0753123355', 'Freddy'
'Seehas', 'Wiesenstrasse 4', 28, '075319227520', 'Sung'
'DOM', 'Brueckengasse 1', 40, '075313611559', 'Alex'
'Shamrock', 'Bahnhofstrasse 4', 120, '0753124622', 'Pan'
}

Beverages = { beverage:string, producer:string
'Schimmele', 'Ruppaner'
'1414 Extra', 'Ruppaner'
'Edel Pils', 'Ruppaner'
'90 Minute IPA', 'Dogfish Head'
'Zwickel', 'Hirsch-Brauerei Hohner'
'Bitter Lemon', 'Schweppes'
'Guinness', 'Guinness'
'Fritz-Kola', 'fritz-kulturgueter'
}

Persons = { name:string, age:number, occupation:string, salary:number
'Freddy', 38, 'Accountant', 65058.13
'Karl-Friedrich', 21, 'Sales Manager', 86098.15
'Thorsten', 21, 'Real Estate Agent', 1202340.00
'Lena', 25, 'Programmer', 65058.13
'Reto', 18, 'Student', 12000.00
'Klara', 18, 'Student', 12500.80
'Cenk', 38, 'Teacher', 63024.15
}

Frequents = { person:string, bar:string, day:number
'Freddy', 'Heimat', 5
'Freddy', 'Klimperkasten', 5
'Freddy', 'Klimperkasten', 7
'Freddy', 'Klimperkasten', 2
'Karl-Friedrich', 'Klimperkasten', 5
'Karl-Friedrich', 'Klimperkasten', 7
'Reto', 'Klimperkasten', 5
'Thorsten', 'Heimat', 1
'Thorsten', 'Heimat', 4
'Klara', 'Heimat', 3
'Klara', 'Heimat', 5
'Klara', 'Klimperkasten', 6
'Cenk', 'Heimat', 1
'Cenk', 'Heimat', 4
'Lena', 'Shamrock', 5
}

Likes = { person:string, beverage:string, day:number
'Thorsten', 'Schimmele', 1
'Thorsten', 'Schimmele', 4
'Thorsten', 'Fritz-Kola', 4
'Thorsten', 'Fritz-Kola', 2
'Lena', 'Schimmele', 5
'Lena', 'Zwickel', 5
'Karl-Friedrich', 'Zwickel', 5
'Karl-Friedrich', 'Zwickel', 7
'Karl-Friedrich', 'Zwickel', 1
'Reto', 'Schimmele', 5
'Freddy', 'Bitter Lemon', 2
'Freddy', 'Schimmele', 5
'Freddy', 'Zwickel', 7
'Klara', 'Zwickel', 3
'Klara', 'Fritz-Kola', 5
'Klara', 'Guinness', 5
'Cenk', 'Schimmele', 1
'Cenk', 'Schimmele', 4
'Cenk', 'Fritz-Kola', 4
}

Serves = { bar:string, beverage:string, price:number
'Klimperkasten', 'Schimmele', 2.50
'Klimperkasten', '1414 Extra', 2.20
'Klimperkasten', 'Bitter Lemon', 2.00
'Klimperkasten', 'Zwickel', 3.00
'Seehas', 'Schimmele', 2.50
'Seehas', 'Guinness', 2.45
'Heimat', 'Schimmele', 2.45
'Heimat', 'Bitter Lemon', 2.10
'Heimat', 'Fritz-Kola', 2.00
'DOM', 'Schimmele', 3.00
'DOM', 'Zwickel', 2.95
'DOM', 'Fritz-Kola', 2.20
'Shamrock', 'Schimmele', 3.00
'Shamrock', 'Zwickel', 2.50
}