TaggedRecord


Description

Tagged record associations linking tags to specific records across different tables in the healthcare system. This junction table enables flexible tagging of any record type, supporting cross-functional categorization, workflow management, and custom organizational structures for patients, claims, activities, and other business entities.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
TagRecordId int identity 4 √ null

Primary key - Unique identifier for each tag-record association
LinkTo nvarchar 400 √ null

Target table - Name of the table containing the record being tagged
LinkToId int 4 √ null

Target record ID - Primary key of the record being tagged
FkTagId int 4 √ null
Tag.Id FK_TaggedRecord_TaggedRecord R

Tag reference - Links to the tag being applied (Tag.Id)
CreateBy int 4 √ null

Created by user - UserID of the person who applied the tag
CreateDate datetime 16,3 √ null

Creation date - Date and time when the tag was applied
LinkToDataSourceId int 4 √ null

Data source identifier - Identifier for the data source of the linked record

Indexes

Constraint Name Type Sort Column(s)
PK_TaggedRecord Primary key Asc TagRecordId

Relationships

Close relationships within degrees of separation