Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Id | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each control extension |
||||
| ControlId | int | 4 | null |
|
|
Control reference - Links to cf_Control table for the extended control |
|||||
| DisplayOrder | Unknown | 0 | null |
|
|
Display order - Order for displaying extended properties in configuration interfaces |
|||||
| IsRequired | Unknown | 0 | null |
|
|
Required flag - Boolean indicating if this extended property is required |
|||||
| PropertyName | nvarchar | 100 | √ | null |
|
|
Property name - Name of the extended property or attribute |
||||
| PropertyValue | nvarchar | 1073741823 | √ | null |
|
|
Property value - Value of the extended property |
||||
| PropertyType | nvarchar | 512 | √ | null |
|
|
Property type - Data type of the property (string, boolean, number, etc.) |
||||
| OrderPosition | int | 4 | √ | null |
|
|
Order position - Display order for this property |
||||
| Method | nvarchar | 100 | √ | null |
|
|
Method - Method or function associated with this property |
||||
| ValidationRule | Unknown | 0 | null |
|
|
Validation rule - Validation logic for the extended property |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__cf_Contr__3214EC0710D8F65D | Primary key | Asc | Id |
| IX_ExtendControlID | Performance | Asc | ControlId |
Relationships
Close relationships within degrees of separation
