ObjectStore database structure. The database structure in ObjectStore is extremely small and supports storing and searching for object here called items.

***This functionality is not documented and probably not supported by EPiServer***

tblItem

Table to store items.

pkID – Identifier stored in the object ID property
fkSchemaId – identity of the schema used for this object
name – the name in the path for this item
ItenData – Serialized object

tblSchema

The schema (ObjectStore type) for the serialized item.

An item has one schema, a schema has several items.
pkID – Database identifier of the schema
schemaId – Public identity of the schema
idType – the type of the field “Id” on the class

tblRelation

Relations between items.

One item can have several children.
One item can have several parents (not implemented but the database supports it).
fromId – the identity of the relation from object.
fromId – the identity of the relation to object.
toName – a column to cache the name of the “to” object so the object don’t have to be realized in listings.

tblSchemaItem

Table to store fields types of a schema.

pkId- database identifier
fkSchemaId – schema identity of the field
fieldname – the field name of the item
fieldType – the type of the field
indexed – if the field is searchable or not.

tblIndex<type>

Table used for searching in ObjectStore. It has all the items field values.

fkSchemaId – the identity of the schema the field belongs to.
fkItemId – the identity of the item the field belongs to.
filedValue – the value of the field.

Version author:
Mattias Lövström

EPiServer version

All