The PC programme efa holds all data in 17 tables with a total of 491 data fields. total of 491 data fields.
Four tables in efa are "versioned", i.e. they contain objects with several data records, each with a validity period. have a validity period. In ten of the 17 tables, an object ID (UUID) serves as the key to the data record or - for the versioned tables - to the object.
Three tables are dependent on the boot table: Boot status - there there is exactly one data set per boat, boat damage and reservations, which, in addition to the counter, also have the object ID (UUID) of the boat as key, so that a reservation number can occur more than once, but this does not usually happen. usually does not happen.
| Content | Table | Version | Object ID | Data fields |
|---|---|---|---|---|
| Technical counters | efa2autoincrement | 8 | ||
| Boat damage | efa2boatdamages | 25 | ||
| Reservations | efa2boatreservations | 23 | ||
| boats | efa2boats | X | X | 46 |
| boatstatus | efa2boatstatus | 16 | ||
| clubwork book | efa2clubwork | X | 19 | |
| crews | efa2crews | X | 34 | |
| destinations | efa2destinations | X | X | 21 |
| driving badge (DRV) | efa2fahrtenabzeichen | 27 | ||
| groups | efa2groups | X | X | 14 |
| logbook | efa2logbook | 82 | ||
| messages | efa2messages | 17 | ||
| persons | efa2persons | X | X | 41 |
| session groups | efa2sessiongroups | X | 15 | |
| statistics templates | efa2statistics | X | 80 | |
| membership status types | efa2status | X | 13 | |
| waters | efa2waters | X | 10 |
In addition to the uniqueness of the keys, there are other Validity rules that are applied to records. If they are violated, efa cannot save the record. Therefore these rules must also be checked in efaCloud. If the check is not done in exactly the same way, the situation can occur that records between efa-PC and efaCloud server do not become synchronous.
Editing data in efaCloud is possible but not yet recommended. not yet recommended. The reason is the still incomplete implementation of the implementation of the validity check in efaCloud - synchronisation problems could synchronisation problems after editing.