Note: The database uses UUID as a data type for IDs, the tables contain integers as IDs to keep illustration simple.