Skip to Content

XWiki Database Schema

Version 101.1 by Caleb James DeLisle on 2011/04/14
Warning: For security reasons, the document is displayed in restricted mode as it is not the current version. There may be differences and errors due to this.

This diagram shows the mappings of internal classes to database tables.
The tables are shown with the table name on the left top and the Java class name on the right top.
In the left column are the names of the columns in the table and in the right column are the get methods in the class for accessing those values.
In a hibernate query you can use the same name as the get method but without the get and with the first letter lowercase so the SQL query:
SELECT doc.XWD_TITLE FROM xwikidoc AS doc WHERE doc.XWD_FULLNAME = 'Main.WebHome'
is equivalent to the HQL query:
SELECT doc.title FROM XWikiDocument AS doc WHERE doc.fullName = 'Main.WebHome'
because XWD_TITLE maps to getTitle() which maps to title.

xwikischema.png

Information

The schema below is updated to version 2.0.3.

Following are all of the tables that make up the XWiki database schema. Just taking a brief look at the schema's tables can give you a clue to how the underlying system works.

Note that there may be minor variances for databases other than MySQL, but if so, they have not yet been documented.

Tables

In alphabetical order

Failed to execute the [velocity] macro. Cause: [The execution of the [velocity] script macro is not allowed in [xwiki:Documentation.DevGuide.DatabaseSchema.WebHome]. Check the rights of its last author or the parameters if it's rendered from another script.]. Click on this message for details.

About

About

Support

Platform

User Guide

Admin Guide

Developer Guide

Projects

XWiki

Extensions

Other

Contribute

Status

Practices

Under the Hood

Get Involved

Get Connected