Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int identity | 4 | √ | null |
|
|
Data field - id information for dtproperties business operations |
|
| objectid | int | 4 | √ | null |
|
|
Object ID - Reference to the database object |
|
| property | varchar | 64 | null |
|
|
Data field - property information for dtproperties business operations |
||
| value | varchar | 255 | √ | null |
|
|
Property value - Value of the database property |
|
| uvalue | nvarchar | 510 | √ | null |
|
|
Unicode value - Unicode representation of the property value |
|
| lvalue | image | 2147483647 | √ | null |
|
|
Large value - Large text or binary property value |
|
| version | int | 4 | (0) |
|
|
Version - Version number of the property |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pk_dtproperties | Primary key | Asc/Asc | id + property |