Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Id | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each extended property, auto-incrementing integer |
||||
| ControlId | int | 4 | null |
|
|
Control reference - Foreign key linking to cf_Control for the control being extended (required field) |
|||||
| PropertyName | nvarchar | 100 | √ | null |
|
|
Property name - Name of the extended property being defined |
||||
| PropertyValue | nvarchar | 1073741823 | √ | null |
|
|
Property value - Value of the extended property for control configuration |
||||
| PropertyType | nvarchar | 512 | √ | null |
|
|
Property data type - Data type of the property value for proper handling and validation |
||||
| OrderPosition | int | 4 | √ | null |
|
|
Property order - Numeric position for ordering properties in configuration interfaces |
||||
| Method | nvarchar | 100 | √ | null |
|
|
Property method - Processing method associated with this extended property |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__cf_Contr__3214EC0710D8F65D | Primary key | Asc | Id |