Comment 0 for bug 1855798

While investigating how to map out Mahara and see what connects to what a discovered a db schema-mapping tool. (Details in the bug report: https://bugs.launchpad.net/mahara/+bug/1855630)

That highlighted some issues with our db schema:

'Anomalies'
We have 3 tables that contain a single column:
artefact_comment_deletedby
event_type
view_type

We have 1 table with incrementing column names, potentially indicating denormalization
usr_friend

We have a number of orphan tables that should probably be attached. (See attached file)