A database architecture for SG Transport using pyQT for UI and SQLite for data management. We are using SQLite as being server-less it makes our app independent since it does not require any set-up to work, that is one can just install it and start working.
pip3 install PyQt5==5.14.2
The list below is in the order of decreasing priority therefore please focus on the first one for the time being.
-
Vehical-Repair-Management : A tool to track the repairing and maintenance cost of every vehical. This will help is calculating the cost effeciency of each vehical and help in making Important future decisions regarding the vehical. The back-end implementation of this can be done in 3 ways:
- Have different tables for every vehical.
- Have only one common table for every vehical.
- Have both 1 and 2. Currently it's decided to implement the 2nd approach but instead of having just one table we'll have separate table for each years logs. That is each table will contain data of all the repairing and maintenance that happened that particular year.
-
Job-Management : A tool to track the jobs and movement of all the vehicals. Implementation needs further discussions
-
Bill-Generation-Tool : This will automate the Entries to Job-Management.
-
Maintenance-Suggester : A tool which uses Machine-Learning to suggest when a vehical should next go for maintenance using the jobs/movement and repairing/maintenance history of the vehical.