Table LS_ATTRIBUTE

The content attribute table. The content attributes are the data and attributes associated with a particular content object revision. All attributes are identified by a name, and contain text data values. Binary data is not stored directly in this table, but rather in files in the filesystem. The file names are stored in attributes in this table, however.

Column Detail

DOMAIN

DOMAIN VARCHAR(30) NOT NULL

The name of the domain the content object belongs to.

Reference To:

LS_DOMAIN.NAME
LS_CONTENT.DOMAIN

CONTENT

CONTENT INTEGER NOT NULL

The content object identifier.

Reference To:

LS_CONTENT.ID

REVISION

REVISION SMALLINT NOT NULL

The content object revision.

Reference To:

LS_CONTENT.REVISION

NAME

NAME VARCHAR(200) NOT NULL

The content attribute name. The attribute name must be unique for the specific content object revision.

DATA

DATA MEDIUMTEXT NOT NULL

The attribute text data. This may be set to blank if the attribute has no data.

Index Detail

PRIMARY KEY

PRIMARY KEY (CONTENT, REVISION, NAME)

The content attribute is uniquely indexed by the object identifier, revision number, and attribute name.

INDEX ATTRIBUTE_IDX_1

INDEX ATTRIBUTE_IDX_1 (CONTENT)

The attribute data is commonly searched by the content identifier.