Export (0) Print
Expand All

Interface-Specific Tables

SQL Server 2000

Interface-Specific Tables

When you create an information model, the repository engine enlarges the database schema to accommodate the new kinds of data. The additional tables that the repository engine adds are called the extended schema. Generally, the repository engine creates one table for each new interface you create. Several interfaces, however, can share a table. For more information, see Information Model Creation Issues.

Each row of an interface-specific table indicates that a set of property values applies to a particular range of object versions. For more information, see Ranges in the Version Graph.

The primary key of any interface-specific table consists of three columns: IntID, Z_BranchID_Z, and Z_VS_Z, as shown in the following table.

Column name Data type Description
IntID RTIntID The internal identifier for the object
Z_BranchID_Z RTBrID Indicates the branch of the version graph containing the range to whose items the property values in this row apply
Z_VS_Z RTVerID A version-within-branch identifier indicating the lower bound of the range to whose items the property values in this row apply
Z_VE_Z RTVerID A version-within-branch identifier indicating the upper limit of the range to whose items the property values in this row apply
(User-supplied column name for Interface-Specific Property 1) (User-supplied data type) A column that corresponds to a property you defined in your information model
(User-supplied column name for Interface-Specific Property n...) (User-supplied data type) Other columns that correspond to other properties you defined in your information model

Each row indicates a range and a set of property values. Every object version in the range is described by every property value.

See Also

Branches in the Version Graph

Example: Rows of Interface-Specific Tables

Repository SQL Schema

Repository SQL Tables

Storage Strategy in a Repository Database

Version Graph

Show:
© 2015 Microsoft