Please be informed that the 'as-planned' version currently lacks the database relations.

Diagram