Migration

1. To keep data consistent

We use Liquibase for migrations versioning. PostgreSQL documentation

The main difference decided was that unlike Flyway it is rather high-level solution so possible migration to Oracle/MySQL would be much easie in the future

2. Database scheme (ERD)

As shown in the diagram, 3NF was extracted to avoid memory leaks. With this in mind, also dynamic VARCHAR(45) data type was used, especially for fields like brand of a car (it will never really be larger as long as back-end data validation goes on)