Table LS_PREFERENCE

The user preference table. This table contains the user preferences in the form of name-value pairs. Each user may have multiple preference attributes, each having a unique name (for that user).

Column Detail

DOMAIN

DOMAIN VARCHAR(30) NOT NULL

The name of the domain that the user belongs to.

Reference To:

LS_DOMAIN.NAME
LS_USER.DOMAIN

USER

USER VARCHAR(30) NOT NULL

The user name.

Reference To:

LS_USER.NAME

NAME

NAME VARCHAR(200) NOT NULL

The preference attribute name. The attribute name must be unique for each user name.

VALUE

VALUE VARCHAR(200) NOT NULL

The preference attribute value. This may be set to blank if the attribute has no value.

Index Detail

PRIMARY KEY

PRIMARY KEY (DOMAIN, USER, NAME)

The preference is uniquely indexed by domain, user and preference attribute name.

INDEX PREFERENCE_IDX1

INDEX PREFERENCE_IDX1 (DOMAIN, USER)

This index facilitates searches for the user preferences.