Table: Overview
The first table in your SQLite file is named bewa_Overview with fields according to following.
Regarding validation
Some fields are checked for syntax and must comply to that.
| Column | Description |
|---|---|
| InnerId | The InnerId is used to connect each row to date notes in table bewb_Events. It consists of a letter and a number without any dashes or other characters. The letter specifies the Trip Domain, e.g. domestic (I), abroad (U), or attachment (D) (see separate definition). The number is a chronological number, where the first trip in each letter category is marked as 1. E.g. U23 for abroad trip number 23. Use X if you want to exclude the row from the web app.Syntax: <one letter trip domain abbreviation><a serial number> |
| ParticipantGroup | Could e.g. be Family, Private, or Work. Syntax: <string that must exist in table bewx_ParticipantGroups> |
| OuterId | The OuterID is exposed to end-user of the web app. It uses a letter and a index number separated by dash, where the letter is a abbreviation of the Trip Domain and a chronological index number. E.g. F-3 (family trip 3), P-12 (private trip 12), or W-4 (work trip 4). Syntax: <letters and dashes and serial numbers of your choice> |
| OverallDestination | Type in you trip primary destination. E.g. Finland, or Italia, Spain etc. Syntax: <string> |
| DepartureDate | Your departure date in ISO format. Syntax: YYYY-MM-DD |
| ReturnDate | Your return date in ISO format. Syntax: YYYY-MM-DD |
| MapPins | The main stops of your trip that you want to plot on the map. Syntax (multi-line accepted): { NAME_OF_MAP_PIN | LATITUDE, LONGITUDE } |
| TripDescription | A short description that explain the aim of the trip. E.g. My fantastic summer trip to France. Syntax: <string> |
| PhotoStarttime | For use with Immich. If you leave your home at let say 8 pm and don't want to include photos from earlier on departure day, then you can set a time here. If left empty, all photos from departure day will be included. Syntax: HH:MM |
| PhotoEndtime | For use with Immich. Same as above, but for return day. Syntax: HH:MM |