Where can I find the columns of each forum-related table in the Moodle database?

627 views Asked by At

I have seen all the 9 tables related to a forum in this diagram. A screenshot of the relevant part of the diagram is as follows.

The question is that how can I find out what columns are there in each of these tables? I tried to google it, but could not find a list of columns in the tables.

enter image description here

2

There are 2 answers

0
Russell England On BEST ANSWER

Download and install MySql Workbench

https://dev.mysql.com/downloads/workbench/

Then download the latest database schema from here

https://docs.moodle.org/dev/Database_Schema

0
Solace On