Station_ID |
Int |
Primary-Key of Station |
StationTitle |
String |
Title of Station |
Zone_ID |
Int |
Primary-Key of Zone |
Difficulty_ID |
Int |
Primary-Key of Difficulty |
StationDescription |
String |
Text, that describes the station |
DidYouKnowThat |
String |
Did you konw that, ... |
Gridsquare_ID |
Int |
Primary-Key of Gridsquare |
GridsquareOffsetX |
Int (NULL) |
Horizontal offset for the flag on the map |
GridsquareOffsetY |
Int (NULL) |
Vertical offset for the flag on the map |
Duration |
Int (NULL) |
Duration in minutes to solve all questions related with this station. |
MediaStorage_ID |
Int (NULL) |
Primary-Key of MediaStorage (main pictrue of this station) |
MediaSubTitle |
String |
Caption of the picture |
InternalKey |
String |
Internal key related to import files |
Questions |
List[Question] |
All questions from TMW related to this station |
SortKey |
Int (NULL) |
Sortorder of the Station in a PuzzleHunt |
Question_ID |
Int |
Primary-Key of Question |
CustomerAccount_ID |
Int |
Primary-Key of CustomerAccount |
QuestionType_ID |
Int |
Primary-Key of QuestionType |
InternalKey |
String |
Internal reference for import/export |
Station_ID |
Int |
Primary-Key of Station |
Difficulty_ID |
Int |
Primary-Key of Difficulty |
QuestionText |
String |
The question |
QuestionMediaStorage_ID |
Int (NULL) |
Main picture of the question |
QuestionPictureBoxSize_ID |
Int (NULL) |
Size of the main picture |
AnswerText |
String |
Answer, that is showed at answer book |
AnswerMediaStorage_ID |
Int (NULL) |
Picture belonging to the answer, that is showed at answer book |
AnswerBoxSize_ID |
Int (NULL) |
Size of the answer box |
Duration |
Int (NULL) |
Duration to answer the question |
ChoiceList |
List[Choice] (NULL) |
Choice list for some kinds of questions |
PuzzleHunt_ID |
Int |
Primary-Key of Puzzle-Hunt |
PuzzleHuntTitle |
String |
Title of the Puzzle-Hunt |
Difficulty_ID |
Int |
Primary-Key of Difficulty |
Language_ID |
Int |
Primary-Key of Language |
Status_ID |
Int |
Primary-Key of Status |
CustomerAccount_ID |
Int (NULL) |
Primary-Key of Customer-Account |
MeetingPointStart_ID |
Int (NULL) |
Primary-Key of Meetingpoint for start location |
MeetingPointStart |
MeetingPoint (NULL) |
Meetingpoint for start location |
MeetingPointEnd_ID |
Int (NULL) |
Primary-Key of Meetingpoint for end location |
MeetingPointEnd |
MeetingPoint (NULL) |
Meetingpoint for end location |
Stations |
List[Station] |
All Stations linked to the Puzzle-Hunt |
Zones |
List[Zone] |
All Zones linked to the Puzzle-Hunt |
Duration |
Int |
Duration in minutes of the Puzzle-Hunt |