The current db schema can be created as follows: