Overview Table Reference Diagram Index
Database Documentation

Table LS_CONTENT

The content object table. The content objects are all sites, pages, aliases, articles, events, and similar in the system. In short, all objects with associated permissions and revision handling are content objects. The content data is stored as named attributes in the LS_ATTRIBUTE table. Binary data is normally not stored directly in the database, but as files in the file system (with the filename stored as an attribute).

Column Summary
AUTHOR VARCHAR(30) NOT NULL
      The content modification user name.
CATEGORY SMALLINT NOT NULL
      The content category (or class).
COMMENT VARCHAR(200) NOT NULL
      The content revision comment.
DOMAIN VARCHAR(30) NOT NULL
      The name of the domain the content object belongs to.
ID INTEGER NOT NULL
      The content object identifier.
MODIFIED DATETIME NOT NULL
      The content modification date.
NAME VARCHAR(200) NOT NULL
      The content object name.
OFFLINE DATETIME NOT NULL
      The publishing offline date.
ONLINE DATETIME NOT NULL
      The publishing online date.
PARENT INTEGER NOT NULL
      The parent content object.
REVISION SMALLINT NOT NULL
      The content object revision.
STATUS SMALLINT NOT NULL
      The content object revision status.

Index Summary
PRIMARY KEY (ID, REVISION)
      The content is uniquely indexed by the object identifier and the revision number.
INDEX CONTEXT_IDX_1 (ID)
      The content is commonly searched by identifier.
INDEX CONTEXT_IDX_2 (PARENT)
      The content is commonly searched by parent identifier.

Column Detail

DOMAIN

DOMAIN VARCHAR(30) NOT NULL
The name of the domain the content object belongs to.

Reference To:

LS_DOMAIN.NAME

Referenced By:

LS_ATTRIBUTE.DOMAIN
LS_PERMISSION.DOMAIN
LS_LOCK.DOMAIN

ID

ID INTEGER NOT NULL
The content object identifier. Each object may exist in several revisions, making it possible to revert to old versions if needed. The content identifier SHOULD NOT be modified after creation, unless all referencing tables also are updated. If a content object is removed, care must be taken to also remove all rows in referencing tables.

Referenced By:

LS_CONTENT.PARENT
LS_ATTRIBUTE.CONTENT
LS_PERMISSION.CONTENT
LS_LOCK.CONTENT

REVISION

REVISION SMALLINT NOT NULL
The content object revision. Each published version of an object is given a revision number, starting at one (1). The revision number zero (0) is used for working revisions, i.e. content versions that have not yet been published. When editing a published object, a new work revision is created. When a work revision is published a new revision number is incrementally assigned.

Referenced By:

LS_ATTRIBUTE.REVISION

CATEGORY

CATEGORY SMALLINT NOT NULL
The content category (or class). All content objects belongs to a single class of objects, each having a minimum set of attributes with a well-defined meaning. Examples of such categories are site, directory, page, article, etc. The category number controls how the content object is interpreted by the system. The list of defined category numbers are present in the Content class.

NAME

NAME VARCHAR(200) NOT NULL
The content object name. The object name may not be left blank and must comply with the specific naming rules for its content category.

PARENT

PARENT INTEGER NOT NULL
The parent content object. Depending on the category, the parent object has a different meaning. Some categories implies that the objects in the category has no parents, such as sites. Other object categories imply that the parent object has another category, such as pages having site or folder objects as parents. If the parent value is set to zero (0), this content object has no parent.

Reference To:

LS_CONTENT.ID

ONLINE

ONLINE DATETIME NOT NULL
The publishing online date. If this date is set to a date in the future, the content object is not yet visible on the site. If the date is set to all zeros (0), no online date has been set.

OFFLINE

OFFLINE DATETIME NOT NULL
The publishing offline date. If this date is set to a date in the past, the content object is no longer visible on the site. If the date is set to all zeros (0), no offline date has been set and the object may thus be visible forever (if an online date has been set).

MODIFIED

MODIFIED DATETIME NOT NULL
The content modification date. This is the date of the last modification to this content object revision. When publishing a working revision, this date will be updated to the current date and time.

AUTHOR

AUTHOR VARCHAR(30) NOT NULL
The content modification user name. This is the name of the user making the last modification to this content object revision. When publishing a working revision, this date will be updated to the current user.

Reference To:

LS_USER.NAME

COMMENT

COMMENT VARCHAR(200) NOT NULL
The content revision comment. The comment is used to add additional information about a content revision.

STATUS

STATUS SMALLINT NOT NULL
The content object revision status. This is a bit flag that is used to flag the latest work and published revisions. These flags are needed when searching for multiple matching content objects, as hits from older revisions must be filtered out already in the query for performance reasons. This flag is be modified when adding new revisions, or when removing old revisions. The modification of this flag doesn't affect any other column, such as the last modification date or similar.

Index Detail

PRIMARY KEY

PRIMARY KEY (ID, REVISION)
The content is uniquely indexed by the object identifier and the revision number.

INDEX CONTEXT_IDX_1

INDEX CONTEXT_IDX_1 (ID)
The content is commonly searched by identifier. This is used to find all revisions of an object.

INDEX CONTEXT_IDX_2

INDEX CONTEXT_IDX_2 (PARENT)
The content is commonly searched by parent identifier. This is used to find all objects in a directory or topic.
Overview Table Reference Diagram Index
Database Documentation