Table: Events
The second table in your SQLite file is named bewb_Events with fields according to following.
Regarding validation
Some fields are checked for syntax and must comply to that.
| Column Name | Description |
|---|---|
| InnerId | Reference to corresponding InnerId in table bewa_Overview.Syntax: <one letter trip domain abbreviation><a serial number> |
| Date | Your date in ISO format. Syntax: YYYY-MM-DD |
| Events | This is your fully description of what you did this day. Syntax (multi-line accepted): <string> |
| Accommodation | The name and the address of your accommodation. Syntax: <string> |
| AccommodationCountry | The name of the country you stayed in during the night. Syntax: <string> |
| AccommodationCoordinateAccuracy | Possibility to mark the accuracy of the coordinates. Syntax: <string> |
| AccommodationCoordinates | The gps coordinates of your accommodation, e.g. 59.329444, 18.068611. Syntax: lat_decimal,lng_decimal |
| TravelParticipants | The name of your travel buddies, separated by comma. N.B. Not exposured in web app. Syntax: <string> |
| AdditionalNotes | N.B. Additional notes not exposured in web app. Syntax (multi-line accepted): <string> |
| CountriesDuringDay | This field is for enhanced statistics. Enter all countries in cronologial order during that day, separated by comma. The country names need to conform to the country names defined in settings.yaml. In front of the country name prefix *, **, and + is allowed. Read more under Appendix.Syntax (prefix allowed): <country name without space>, <country name without space>, <country name without space> [...] |