2019-12-10 03:50:54 |
Rebecca Blundell |
description |
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) |
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 listed in the comment below. |
|