Project

General

Profile

Actions

Story #149

open

Epic #126: Back end developement

Database Modelization

Added by Anas Boulbab about 1 month ago.

Status:
Open
Priority:
Normal
Assignee:
-
Target version:
Start date:
11/03/2025
Due date:
% Done:

0%

Estimated time:

Description

We need to model the db schema, taking in consideration all the parties that will be interacting with the web application.
The project is a fleet management system for copag.
We need to deliver a web application (mobile for driver and web for backoffice) that will track the company drivers performance.

  • We will track the number of mission they did, number of kilometers driven, number of traffic violations and their types (speeding, wrong line changing, ...)
  • Traffic violation will be communicated via an external API (a device inside each vehicle cabine will detect traffic violation and send them to the external API)
  • We will alos have a leaderboard for best drivers.
  • We need to implement a system of point to calculate the drivers point.
  • We need also to check shift start via dynamic generated QR codes (QR code scan will allow us to determin shift start time of driver, driver state, if he is loading or in route to the next agency)
  • We need to notify driver with the apropriat Loading dock so they can start loading goods.
  • We need also to communicate with an external API, traccar API to collect data related to their mission (traject A to B) average speed, max speed, time and so on.
  • We need also communicate with an external API of copag to get vehicles or driver alocation to loading dock.

No data to display

Actions

Also available in: Atom PDF