Forums | Mahara Community

Developers /
ERD for Mahara Database


Zafor Iqbal's profile picture
Posts: 3

21 February 2018, 2:19 AM

Hello everyone,

I'm trying to produce the BI Reports from Mahara database and have no clue how the tables are joint or related to each other.

Therefore, just wondering, whether is there any link/guide to the entity relationship diagram of the Mahara database tables.

Regards,

Zafor.

Robert Lyon's profile picture
Posts: 444

21 February 2018, 9:12 AM

Hi Zafor Iqbal,

There is currently no graphical way to display the database table connections but you could install something like SchemaCrawler to crawl the database and create HTML of the schema.

Cheers

Robert

Zafor Iqbal's profile picture
Posts: 3

08 March 2018, 4:06 AM

Hi Robert,

Could you able to suggest which SchemaCrawler to use or install and also does the crawler would work on the MSSQL as I have already imported the tables from MySQL to MSSQL.

Regards,

Zafor.

Zafor Iqbal's profile picture
Posts: 3

09 March 2018, 11:54 PM

Hi Robert,

Marcus Green has the old ERD which is great to start on, just thought to share in the community who are looking for the same solution, many thanks...

From: marcus green, mahara.org/user/marcusgreen (for security reason cannot add the https)

This is a few years old but it might be of interest
examulator.com/er/mahara/mahara_erd.pdf (for security reason cannot add the http and www)

 

Regards,

Zafor.

4 results