Main database structure Clause Samples

Main database structure. The main database must be located in a static and shared IP location. This requirement is due to the necessity of a known connection endpoint by the application. The tables that conform this database will address all the users’ aspects that will be asked after the installation of the app, as well as the authentication information. Furthermore, in order to allow scalability, a specific table with pointers to specific municipality databases will be included. The functionality of this last table is explained in the following figure. Figure 5.1. - Database pointers table