This SQL table contains one row for each property definition object that is stored in the Repository. The information contained in this table is used by the Repository to create interface-specific SQL tables when an interface is added to the Repository. The IntID, Z_BranchID_Z, and Z_VS_Z columns form the primary key for this table.
| Column Name | Data Type | Description |
| IntID | RTIntID | The internal identifier for the property definition object. |
| Z_BranchID_Z | RTBrID | The value of this column is always zero. |
| Z_VS_Z | RTVerID | The value of this column is always zero. |
| Z_VE_Z | RTVerID | The value of this column is always VERINFINITY. |
| SQLColName | RTSQLName | The name of the column in the SQL table for this property. This field can be null. |
| APIType | RTSQLType | The C language data type for the property. This is the type of the property when it is passed through a Repository programming interface. |
| SQLType | RTSQLType | The SQL data type for the property. |
| SQLSize | RTSize | The length in bytes of the property in terms of its SQL data type. |
| SQLScale | RTScale | The scale for a numeric property; the number of digits after the decimal point. This field can be null. |
| Flags | RTFlags | Flags that determine property behavior. See the PropertyDefFlags Enumeration for a list of values and their specific purposes. |
Remarks
Remember that you can make only one version of each Property Type Definition. Nevertheless, this table includes the columns Z_BranchID_Z, Z_VS_Z, and Z_VE_Z because there are implementation advantages to including these columns. Similarly, the primary key includes the columns Z_BranchID_Z and Z_VS_Z for implementation reasons only.