Table LS_DOMAIN_ATTRIBUTE

The domain attribute table. The domain attributes contain genric data and configuration properties associated with a particular domain. All attributes are identified by a name and contain text data values.

Column Summary
DATA MEDIUMTEXT NOT NULL
      The attribute text data.
DOMAIN VARCHAR(30) NOT NULL
      The name of the domain the attribute belongs to.
NAME VARCHAR(200) NOT NULL
      The domain attribute name.

Index Summary
PRIMARY KEY (DOMAIN, NAME)
      The domain attributes are uniquely indexed by the domain and attribute names.

Column Detail

DOMAIN

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

Reference To:

LS_DOMAIN.NAME

NAME

NAME VARCHAR(200) NOT NULL
The domain attribute name. The attribute name must be unique for the specific domain.

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 (DOMAIN, NAME)
The domain attributes are uniquely indexed by the domain and attribute names.