Clsdef Table: Class Definition Metadata
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 2009 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. |