Table LS_DOMAIN

The domain table. Each domain contains it's own pool of resources, such as web sites, content, users, groups, etc. No data can be shared across domains, making it useful to provide hosting for several organizations with a single installation. If a domain is removed, care must be taken to also remove all referencing rows in other tables.

Column Detail

NAME

NAME VARCHAR(30) NOT NULL

The unique domain name. The domain name is the primary key, and is used to identify the domain in most other tables. The domain name SHOULD NOT be modified after creation, unless all referencing tables also are updated. If a domain is removed, care must be taken to also remove all rows in referencing tables.

Referenced By:

LS_DOMAIN_ATTRIBUTE.DOMAIN
LS_USER.DOMAIN
LS_GROUP.DOMAIN
LS_USER_GROUP.DOMAIN
LS_CONTENT.DOMAIN
LS_ATTRIBUTE.DOMAIN
LS_PERMISSION.DOMAIN
LS_LOCK.DOMAIN

DESCRIPTION

DESCRIPTION VARCHAR(100) NOT NULL

The domain description. The domain description normally contains the owner or organization name, complete with correct spacing and case. The domain description is used by users to identify the domain. It is normally the domain name with correct casing, spacing and punctuation.

CREATED

CREATED DATETIME NOT NULL

The domain creation date and time. This is the date when the domain was added.

MODIFIED

MODIFIED DATETIME NOT NULL

The domain modification date and time. This is the date of the last modification to this domain. Each time the domain or its attributes are modified, this value will be updated to the current date and time.

Index Detail

PRIMARY KEY

PRIMARY KEY (NAME)

The domains are indexed by the unique name.