New data model

We are currently (March 2021) working on a new data model for the members system. The work in progress can be seen here: https://dbdiagram.io/d/6025a40580d742080a3a375c

Comments on the new data model are added directly to the dbdiagram syntax.

High level description of data model

• Tables and field names are kept in lower case without plural endings
• Primary keys are named id

See Naming conventions for more information about the different types of data stored in the data model.