iCommunicateInDocuments


Description

Communication document associations linking internal communication messages to related documents and attachments. This junction table manages the relationship between communication messages and documents to support document sharing, attachment management, and comprehensive communication workflows with supporting documentation for healthcare team collaboration.

Columns

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

Primary key - Unique identifier for each communication-document association
fkCommunicateID int 4 √ null
iCommunicate.pkCommunicateID FK_iCommunicateInDocuments_iCommunicate R

Communication reference - Links to iCommunicate table for the message
fkDocID int 4 √ null

Document reference - Links to the document associated with the communication

Indexes

Constraint Name Type Sort Column(s)
PK_iCommunicateInDocuments Primary key Asc pkiCommunicateDocID

Relationships

Close relationships within degrees of separation