Data Warehouse Classes
This section provides an alphabetical list of the Commerce Server 2000 Data Warehouse logical classes. Information about the class data members, class relations, and class keys is included. The physical classes corresponding to these logical classes can be found in the Microsoft Management Console (MMC) under Microsoft SQL Servers\SQL Server Group\<server name>\Databases\<data warehouse database>\Tables.
The following table contains the relation types and the corresponding type codes used in the Relations table of each class description.
| Relation Type | Code | Description |
| One-to-many | 2 | Each parent has zero or more children, each child has one parent. The identifier ("Classname"ID) of the parent is used as a foreign key by the child. |
| Many-to-many | 3 | Each parent has zero or more children, each child has one or more parents. |
| One-to-many with inheritance | 194 | Same as a one-to-many relation except all members of the parent are visible to the children. (In a regular one-to-many relation, only the key members of the parent class are visible.) |
Commerce Server 2000 Data Warehouse Logical Classes
The following table contains links to the logical classes of the Data Warehouse.