The Project

You are designing a system for a Road Freight Transportation company.$$ This company has a certain number of trucks and need to monitor the following attributes: brand, load, capacity, year, number of repairs.$$

The company has employees whose name, surname, and seniority are monitored. Some of the employees are drivers, for whom the category is additionally monitored, and part of them are mechanics, for whom the brand of vehicle they specialize in is additionally monitored.

When a truck breaks down, a record is kept of which mechanic

repairs it and the estimated time for repair $($in days$).$

The company operates by receiving shipments of certain weights and values from customers $($tracked by name, address and two phone numbers$)$ that need to be

transported from the place of origin to the destination, for which the name is

also tracked. In addition, the database should store each truck trip in terms of

route $($from$-$to$),$ participation of drivers $($up to two$)$ and shipments being

transferred $($one or more of them$).$

The Assignment

Your assignment submission will be a working project. In it you will:

Have a working database complete with all the tables and columns.

Implement CRUD functions to interact with every single table

Write unit tests that covers the CRUD operations

Write integration tests that covers the CRUD operations

Bonus $(3$pts$)$: create a migration so that there is at least $3$ rows of data in each table.

Include an Entity Relations diagram of your database design.

The Technical Requirements

The project will be a Typescript $($not JavaScript$)$ based project.

The project will use an ORM

The project needs to be usable in a containerized manner.