Relationships
countries 
cities: belongs to country
club: belongs to city
club_nights

table data

club: id city_id name website description

club_nights: id club_id drink_id discount_drink_id name description normal_entry_prices guest_entry_prices student_entry_prices

drink_prices: id (drink names)

drinks: id name

discounts: id name description rough_discount_percentage

guestlist_requests: id guest_id club_id day_id number_of_guests

guests: id name email_address

days: id name

Tasks

Import drinks tables for each day this includes importing the correct drinks data and club data