Relmemdef Table: Relation Member Definition Metadata
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
A relation member definition maps an explicit relationship between a member in a child class and a member that is not a key in a parent class. The relmemdef table contains metadata that defines relation members between classes. The OLE DB provider for Commerce Server uses metadata from the relmemdef table and other metadata to store instances of user classes in the database.
The metadata for the relation and the data members that are involved in the relation must already be defined. The RelationName identifies the link to the encompassing relation. Therefore, the relation name in the RelationName attribute must match the RelationName attribute for the relation.
For information about how to create a new relation member for a class, see Creating a New Class Relation Member.
The following table describes the columns in the relmemdef table. There is a row in the relmemdef table for each relation member that is defined.
Column name |
Type |
Allow null |
Requirement |
Description |
|---|---|---|---|---|
RelMemberID |
int |
no |
Leave blank |
Stores the unique identifier for the relation member. |
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". |
ChildMemID |
int |
yes |
Leave blank |
Stores the identifier for the data member of the child class to relate. |
ChildMemName |
nvarchar (100) |
yes |
Required |
Stores the name of the data member of the child class to relate. |
CreatedTime |
datetime |
yes |
Reserved |
Records when the relation member was created. |
Description |
nvarchar (128) |
yes |
Optional |
Stores the description of the object. |
DisplayName |
nvarchar (128) |
yes |
Optional |
Stores the display name of the object. |
MajorVersion |
int |
yes |
Reserved |
Stores the major version number for the relation member. |
MinorVersion |
int |
yes |
Reserved |
Stores the minor version number for the relation member. |
ModifiedTime |
datetime |
yes |
Reserved |
Records when the relation member was last modified. |
ParentMemID |
int |
yes |
Leave blank |
Stores the identifier of the data member of the parent class to relate. |
ParentMemName |
nvarchar (100) |
yes |
Required |
Stores the name of the data member of the parent class to relate. |
RelationID |
int |
yes |
Leave blank |
Stores the identifier of the relation that contains the relation member. |
RelationName |
nvarchar (128) |
yes |
Required |
Stores the name of the class relation. |
Status |
int |
yes |
Reserved |
Reserved. |