The "xwikifloats" Table

The xwikifloats table stores data from XWiki object properties of type "Float" and it corresponds to the com.xpn.xwiki.objects.FloatProperty class which is a sub-class of com.xpn.xwiki.objects.BaseProperty.

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

<class name="com.xpn.xwiki.objects.BaseProperty" table="xwikiproperties">
 <composite-id unsaved-value="undefined">
   <key-property name="id" column="XWP_ID" type="long" />
   <key-property name="name" type="string">
     <column name="XWP_NAME" index="PROP_NAME" />
 <property name="classType" type="string" column="XWP_CLASSTYPE" length="255" />
 <joined-subclass name="com.xpn.xwiki.objects.FloatProperty" table="xwikifloats">
     <column name="XWF_ID" />
     <column name="XWF_NAME" index="XWFLOAT_NAME" />
   <property name="value" type="float" column="XWF_VALUE" index="XWFLOAT_VALUE" />

The columns of the xwikifloats table are:

ColumnData typeClass propertyDefault valuenot-nullIndex
XWF_ID (primary key)bigint(20)-0true-
XWF_NAME (primary key)varchar(255)--trueXWFLOAT_NAME


Related Pages

Trying to decide between Cloud and On Premise? See the comparison on the XWiki Help Center.

Search this space