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
Example: Rows of Interface-Specific Tables