Clsdef Table: Class Definition Metadata

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

A class defines a set of logically related data. Classes model user objects. The clsdef table contains metadata that defines user classes. The OLE DB provider for Commerce Server uses metadata from the clsdef table and other metadata to store instances of user classes in the database.

For an overview of the logical grouping of these classes into primary business categories, see Primary Data Warehouse Business Classes.

For information about how to create a new class, see Creating a New Class.

The following table describes the columns in the clsdef table. There is a row in the clsdef table for each user class that is defined.

Column name

Type

Allow null

Requirement

Description

ClassDefID

Int

no

Leave blank

Stores the internal identifier for the class.

BaseClassName

nvarchar (128)

yes

Optional

Stores the name of the base class. Used for aggregations.

CatalogID

int

yes

Leave blank

Stores the identifier for the schema catalog.

CatalogName

nvarchar (128)

yes

Leave blank

Stores the name of the schema catalog, "DWSchema".

ClassDefName

nvarchar (57)

yes

Required

Stores the name of the class.

ClassGUID

varbinary (16)

yes

Leave blank

Stores the GUID for the class.

ClassType

smallint

yes

Optional

Stores the class type. Valid types are as follows:

0 = None

1 = Dimension

2 = Fact

3 = Aggregation

CreatedTime

datetime

yes

Reserved

Stores the time that the class was created.

DefaultParentURL

nvarchar (128)

yes

Leave blank

Stores the default parent URL for the class.

DefaultTableName

nvarchar (57)

yes

Leave blank

Stores the default table name associated with the class.

Description

nvarchar (128)

yes

Optional

Stores the description of the object.

DisplayName

nvarchar (128)

yes

Optional

Stores the display name of the object.

GenerateIdentity

tinyint

yes

Leave blank

True (1) indicates that the ID for the class will be generated automatically.

GenerateKeyDef

tinyint

yes

Required

Set to True (1) if this class key has a single member. Set the IsPrimaryKey attribute to True (1) for the member. If this class key has more than one key member, a key definition must be explicitly defined.

GeneratePartitionDef

tinyint

yes

Leave blank

True (1) indicates that the partition definition will be generated automatically.

GenerateTableDef

tinyint

yes

Leave blank

True (1) indicates that the table definition will be generated automatically.

IdSize

int

yes

Leave blank

Stores the size of the identifier data in bytes.

InstExclusionExpr

nvarchar (128)

yes

Optional

Used as a filter for aggregations.

IsAbstract

tinyint

yes

Optional

Indicates whether the class is abstract. Abstract classes cannot be instantiated, but can be derived from. Default value is False (0).

IsActive

tinyint

yes

Optional

Indicates whether the class is active (instances may be added). Default value is 1.

IsPersistent

tinyint

yes

Optional

Indicates whether the class is persisted in the underlying data store. Default value is 1.

IsReadOnly

tinyint

yes

Optional

Indicates whether the class is read-only. Default value is 0.

IsTransactioned

tinyint

yes

Optional for Profiles System.

Leave blank for Analysis.

Used by the Profiles System.

IsUIDeletedEnabled

tinyint

yes

Reserved

Reserved.

MajorVersion

int

yes

Reserved

Stores the major version number for the class.

MinorVersion

int

yes

Reserved

Stores the minor version number for the class.

ModifiedTime

datetime

yes

Reserved

Stores the last time that the class was modified.

PartCriteriaExpr

nvarchar (128)

yes

Leave blank

Reserved.

PartitionID

int

yes

Leave blank

Reserved.

PartitionName

nvarchar (128)

yes

Leave blank

Stores the name of the default partition for the class.

PartViewName

nvarchar (128)

yes

Leave blank

Reserved.

SourceDefName

nvarchar (128)

yes

Required

Stores the name of the data source. A class definition has a SourceDef to describe where the data for a class will be stored. The SourceDef for new classes should be set to test_source.

SourceID

int

yes

Leave blank

Stores the identifier for the data source.

Status

int

yes

Reserved

Reserved.

See Also

Other Resources

Data Warehouse Meta-Model