ExtendedProps Table
The ExtendedProps table stores the characteristics of resource properties. Together with the SystemProps table, this table defines the schema of the Administration database.
The columns of the ExtendedProps table are described in the following table.
| ExtendedProps Columns | Description |
| s_ResourceType | A string used to map a single row in the SystemProps table, representing a single resource type, with the associated resource properties in this table. The corresponding column in the SystemProps table is also named s_ResourceType. |
| s_PropertyName | Set to an arbitrary string that serves as the internal name of the property, and used when accessing the property programmatically with the GlobalConfig, SiteConfig, and SiteConfigReadOnly objects.
Typically, this name is descriptive and begins with a letter indicating the data type of the property and an underscore. For example, "i_AuctionOptions" indicates an integer data type. |
| f_IsConnStr | When set to "1", indicates that the property is an OLE DB connection string. If set, Commerce Server Manager uses a Universal Data Link (UDL) dialog box to set the value, and Commerce Server Site Packager will prompt for connect information for a specific database when unpacking.
For additional information about this flag and its relationship to connection string configuration values, see the note in ResourceProps Table. |
| f_IsHidden | When set to "1", the Generic Resource dialog box will not display the property. Set this flag to "1" for properties for which there is a custom MMC snap-in. |
| f_IsSimpleList | When set to "1", indicates that the new property is a SimpleList object. This feature allows the storage of multi-valued properties. |
| s_Description | An arbitrary descriptive string that is displayed in the Generic Resource dialog box. |
| i_Vartype | An integer indicating the Variant type of the data being stored. For example, 8 indicates a string and 8200 indicates an array of strings. All Variant types except SafeArray, IUnknown, and IDispatch are allowed.
Set to an integer value indicating the data type of the new property. The value 8200 indicates a Variant array of strings. |
| s_Value | The default value for this resource property, if any. |
| s_DisplayName | A user-friendly display name for the property that is shown in the Generic Resource dialog box. |