| 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 |