Database schema structure

The postgres database has the schema structure outlined in the database below:

UML diagram of the retail schema in the postgres database

This structure can also be read in the schema.sql file that is used to initialise the database