The "xwikiobjects" Table

The xwikiobjects table corresponds to the com.xpn.xwiki.objects.BaseObject class and it stores the list of XWiki Objects attached to wiki pages. The actual data from the object properties is stored in the dedicated table, depending on the data type.

The mapping information is available in the xwiki.hbm.xml file:

<class name="com.xpn.xwiki.objects.BaseObject" table="xwikiobjects">
 <id name="id" type="long" unsaved-value="undefined">
   <column name="XWO_ID" not-null="true" />
   <generator class="assigned" />
 </id>
 <property name="number" type="integer" column="XWO_NUMBER" index="OBJ_NUMBER" not-null="false" />
 <property name="name" type="string" column="XWO_NAME" index="OBJ_NAME" not-null="true" length="255" />
 <property name="className" type="string" column="XWO_CLASSNAME" index="OBJ_CLASSNAME" not-null="true" length="255" />
 <property name="guid" type="string" column="XWO_GUID" not-null="false" length="255" />
</class>

The columns of the xwikiobjects table are:

ColumnData typeClass propertyDefault valuenot-nullIndex
XWO_ID (primary key)bigint(20)-0true-
XWO_NUMBERint(11)number0falseOBJ_NUMBER
XWO_NAMEvarchar(255)name-trueOBJ_NAME
XWO_CLASSNAMEvarchar(255)className-trueOBJ_CLASSNAME
XWO_GUIDvarchar(255)guid-false-

 

Search this space