Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int identity | 4 | √ | null |
|
|
Property ID - Unique identifier for each property |
|
| objectid | int | 4 | √ | null |
|
|
Object ID - Database object identifier this property applies to |
|
| property | varchar | 64 | null |
|
|
Property name - Name of the database property |
||
| value | varchar | 255 | √ | null |
|
|
Property value - String value of the property |
|
| uvalue | nvarchar | 510 | √ | null |
|
|
Unicode value - Unicode string value of the property |
|
| lvalue | image | 2147483647 | √ | null |
|
|
Large value - Binary or large value of the property |
|
| version | int | 4 | (0) |
|
|
Property version - Version number of the property |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pk_dtproperties | Primary key | Asc/Asc | id + property |
Relationships
Close relationships within degrees of separation
