# Forums | Mahara Community

## Support / database structure

Deleted user
Posts: 4

10 February 2009, 2:58 PM

Hi Everybody!

I would like to know if there is a way to see the database structure (tables, fields, etc) of mahara, without having to install it.

Deleted user
Posts: 1643
##### Re: database structure

10 February 2009, 4:30 PM

Hi - so far I don't think anybody has bothered to generate a pretty picture of the schema. But the XML definition of the database that XMLDB uses to install it is available at htdocs/lib/db/install.xml. There are other tables in XML files in the various plugins too:

 [email protected]:~/mahara/htdocs\$ find | grep install.xml./artefact/blog/db/install.xml./artefact/file/db/install.xml./artefact/internal/db/install.xml./artefact/resume/db/install.xml./lib/db/install.xml./notification/emaildigest/db/install.xml./notification/internal/db/install.xml./blocktype/externalfeed/db/install.xml./blocktype/wall/db/install.xml./interaction/forum/db/install.xml

They might help - but the easiest way is probably to install Mahara and generate a picture from the result.

Deleted user
Posts: 4
##### Re: database structure

10 February 2009, 4:42 PM

Thanks for the quick response Nigel.
3 results