...
- Client (written in C/C++) - does not have to work on the machine on which the API and UI work. Allows user to add new data to the Catalog dataset.
- UI (written in PHP/javascript) - server part. It allows you to present the collected data. For now, it is not communicating remotely with the API. Both must be on the same machine.
- API (written in PHP) - server part. Handles client and UI SOAP requests. The middleman between them and MySQL.
- MySQL - serves as a source of the data.
MySQL database schemas
At the moment there are two, separate schemas for MySLQ based databases. First one, responsible for storing summary IDS data
Second one, responsible for storing information related to multiple databases
Main problems of the existing solution
...