Tabelle

Display Name	Field	TYPE	NULL	KEY	Default	Extra
Experience	experienceName	varchar(n)	NO		NULL
Category	experienceCategory	table	NO		NULL
Start location street	startLocationStreet	varchar(128)	NO		NULL
Start location street number	startLocationStreetNumber	varchr(24)	NO		NULL
Start location ZIP	startLocationZip	varchr(24)	NO		NULL
Start location city	startLocationCity	varchar(128)	NO		NULL
Start location country	startLocationCountry	table	NO		NULL
Start location Altitude (meter)	startLocationAltitudeMeter	int(4)	YES		NULL
Start location Three Words	startLocationThreewords	varchar(40)	YES		NULL
Start location laltitude	startLocationLatitude	Decimal(8,6)	YES		NULL
Start location longitude	startLocationLongitude	Decimal(9,6)	YES		NULL
End location street	endLocationStreet	varchar(n)	NO		NULL
End location street number	endLocationStreetNumber	varchr(24)	NO		NULL
End location location zip	endLocationZip	varchr(24)	NO		NULL
End location location city	endLocationCity	varchr(128)	NO		NULL
End location location country	endLocationCountry	varchr(128)	YES		NULL
End location altitude meter	endLocationAltitudeMeter	int(4)	YES		NULL
End location three words	endLocationThreewords	varchar(40)	YES		NULL
End location latitude	endLocationLatitude	Decimal(8,6)	YES		NULL
End location longitude	endLocationLongitude	Decimal(9,6)	YES		NULL
Total duration	activityDuration	int()	NO		NULL
Wheelchair accesibility	wheelchair	bool	NO		NULL
Stroller accesibility	stroller	bool	YES		NULL
Groups welcome	groups	bool	NO		NULL
Minimum groupsize	minGroupSize	int(3)	NO		NULL
Maximum groupsize	maxGroupSize	int(4)	NO		NULL
Eatingarea for groups	eatingareaGroups	table	YES		NULL
Recommended for	targetGroup	table	NO		NULL
Open on Mondays	openMonday	bool	NO		NULL
Open on Tuesdays	openTuesday	bool	NO		NULL
Open on Wednesdays	openWednesday	bool	NO		NULL
Open on Thursdays	openThursday	bool	NO		NULL
Open on Fridays	openFriday	bool	NO		NULL
Open on Saturdays	openSaturday	bool	NO		NULL
Open on Sundays	openSunday	bool	NO		NULL
Day of the week	dayOfWeek	int(7)	NO		NULL
From	fromX		NO		NULL
To	toX		NO		NULL
Openinghour information	openingHoursNotes	varchar(500)	YES		NULL
Closed from	closedFromDate1		YES		NULL
Closed till	closedToDate1		YES		NULL
Closed from	closedFromDate2		YES		NULL
Closed till	closedToDate2		YES		NULL
Closed from	closedFromDate3		YES		NULL
Closed till	closedToDate3		YES		NULL
Holiday information	holidayClosedNotes	varchar(500)	YES		NULL
Openingtimes weblink	openingTimesWeblink	Hyperlink	YES		NULL
Open today	openToday	bool	YES		NULL
Maintaince in progress	maintaince	bool	YES		NULL
Maintaince from	maintainceFrom	DATETIME(fsp)	YES		NULL
Maintaince till	maintainceTill	DATETIME(fsp)	YES		NULL
Interruptions	interrupted	bool	YES		NULL
Interruptions from	interruptedFrom	DATETIME(fsp)	YES		NULL
Interruption till	interruptedTill	DATETIME(fsp)	YES		NULL
Openingtime important information	openingtimeAlert	varchar(500)	YES		NULL
Avaliable tickets	ticketStructure	table	NO		NULL
Groupdiscounts	groupDiscount	bool	NO		NULL
Minimum age	minAge	int(2)	NO		NULL
Min. size for groupdiscounts	groupDiscountMinSize	int(3)	YES		NULL
Ticket information weblink	ticketsWeblink	hyperlink	NO		NULL
Booking weblink	bookingWeblink	hyperlink	NO		NULL
Ticket information	ticketsNotes	varchar(500)	YES		NULL
Adult tickets from	adultPriceFrom	money	NO		NULL
Adult tickets to	adultPriceTo	money	NO		NULL
Accepted discount cards	discountCards	varchar(2000)	YES		NULL
Children free till (age)	childrenFree	age	NO		NULL
Seatreservation mandatory	seatReservationMandatory	bool	NO		NULL
Seatreservation possible	seatReservationPossible	bool	YES		NULL
Price seatreservation	seatReservationPrice	money	YES		NULL
Prices are dynamic (change over time)	dynamicPricing	bool	YES		NULL
Reservation is mandatory	reservationMandatory	bool	NO		NULL
Days in advance for reservation	reservationDaysAdvance	int(3)	YES		NULL
Ticketprice categorys	ticketpriceCategories	table	NO		NULL
VIP tickets avaliable	vipTickets	bool	YES		NULL
VIP tickets information	vipTicketsNotes	varchar(500)	YES		NULL
Location of the best seats	bestSeatsNotes	varchar(1000)	YES		NULL
Tickets for dog	dogTicket	bool	NO		NULL
Free cancelation	freeCancaelation	bool	NO		NULL
Fee cancelation before (days)	freeCancelationDays	int(3)	YES		NULL
Free cancelation before (hours)	freeCancelationHours	int(2)	YES		NULL
Terms and Condition weblink	termsWeblink	hyperlink	NO		NULL
Cancelationprocess	howCancelation	varchar(2000)	NO		NULL
Re-Entry (exmpl. after lunch)	reentry	bool	YES		NULL
Ticket availability	ticketValidity	table	NO		NULL
Free Wifi	freeWifi	bool	NO		NULL
Free Wifi Location	freeWifiLocation	varchar(2000)	YES		NULL
Dogs allowed	dogsAllowed	bool	NO		NULL
Information for dogs	dogsAllowedNotes	varchar(2000)	YES		NULL
Languages	languages	table	NO		NULL
Lockers avaliable	lockers	bool	NO		NULL
Stoller parking avaliable	stollerParking	bool	YES		NULL
Aircondition	aircondition	bool	NO		NULL
Toilets	toilets	bool	NO		NULL
Total walking distance of the experience (Meter)	totalWalkingDistanceMeter	int	NO		NULL
Pick nick allowed	picknickAllowed	bool	NO		NULL
Catering (breakfast, lunch…) provided	catering	bool	NO		NULL
Catering included	cateringIncluded	bool	YES		NULL
Catering reservation mandatory	cateringResMandatory	bool	YES		NULL
Information regarding catering	cateringNotes	varchar(5000)	YES		NULL
Menue weblink	menueWeblink	hyperlink	YES		NULL
Information regarding special diets	specialDietsNotes	varchar(5000)	YES		NULL
Vegan option	vegan	bool	YES		NULL
Vegetartion option	vegetarian	bool	YES		NULL
Halal option	halal	bool	YES		NULL
Kosher option	kosher	bool	YES		NULL
Glutenfree options	glutenfree	bool	YES		NULL
Contact for food intolerances	footIntolerancesContact	varchar(5000)	YES		NULL
CO2 footprint of the experience	co2Footprint	int	YES		NULL
Information regarding CO2 footprint	co2FootprintNote	varchar(5000)	NO		NULL
Sustainability information weblink	sustainabilityWeblink	hyperlink	YES		NULL
Images database weblink	imagesWeblink	hyperlink	YES		NULL
Videos database weblink	videosWeblink	hyperlink	YES		NULL
Map weblink	mapWeblink	hyperlink	YES		NULL
Official website	officialWebsiteWeblink	hyperlink	NO		NULL
Sales Folder weblink	salesFolderWeblink	hyperlink	YES		NULL
Incentives for agents	incentives	varchar(5000)	YES		NULL
Contract for travel trade	tradeContact	varchar(400)	NO		NULL
Carparking avalibale	carParking	bool	NO		NULL
Free carparking avaliable	freeParking	bool	NO		NULL
Shuttle service avaliable	shuttleService	bool	NO		NULL
Free shuttle service avabliable	freeShuttleService	bool	NO		NULL
Distance from parking	distanceParkingMeter	int(4)	YES		NULL
Busstation	busstation	bool	NO		NULL
Distance from busstation	distanceBusstationMeter	int(4)	YES		NULL
Name of the busstation	busstationName	varchar(128)	YES		NULL
Trainstation	trainstation	bool	NO		NULL
Name of the trainstation	trainstationName	varchar(128)	YES		NULL
Distance from the trainstation	distanceTrainstationMeter	int(4)	YES		NULL
Information on how to get there	getThereNotes	varchar(2000)	NO		NULL
Best season	bestSeason	table	NO		NULL
Best days	bestDays	table	NO		NULL
Best time	bestTime	TIME(fsp)	NO		NULL
Best side (train, bus…)	bestSide	table	YES		NULL
best position (train, bus..)	bestPosition	table	YES		NULL
Timetable weblink	timetableWeblink	hyperlink	YES		NULL

Generated by wpDataTables