dtproperties


Description

Database diagram properties storing SQL Server database diagram properties and metadata. This system table manages database diagram information including object properties, values, and versioning to support database design documentation and diagram management for the healthcare database schema.

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