Changes for page Database Schema

Last modified by Manuel Leduc on 2022/03/24

From version 180.1
edited by Thomas Mortagne
on 2018/12/17
Change comment: Upload new image "database-1008010.op.svg", version 1.1
To version 181.1
edited by Thomas Mortagne
on 2018/12/17
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -13,7 +13,7 @@
13 13  {{code language="sql"}}SELECT doc.title FROM XWikiDocument AS doc WHERE doc.fullName = 'Main.WebHome'{{/code}}
14 14  because ##XWD_TITLE## maps to ##getTitle()## which maps to ##title##.
15 15  
16 -{{image reference="database-1008010.svg"/}}
16 +{{image reference="database-1008010.op.svg"/}}
17 17  
18 18  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. Roughly, in order to support defining data types dynamically, the documents metadata are stored in a table, the objects are stored in another table and then the values of the properties of the objects are stored each in their own table, depending on the type of property.
19 19  
database-90000.mwb
Size
... ... @@ -1,1 +1,1 @@
1 -30.0 KB
1 +517.8 KB
Content

Get Connected