clinical_notes_documents


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of clinical_notes_documents.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Links clinical notes to patient documents

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
clinical_note_id BIGINT 19 null
form_clinical_notes.id Defined in XML R

Foreign key to form_clinical_notes.id
document_id BIGINT 19 null
documents.id Defined in XML R

Foreign key to documents.id
created_at TIMESTAMP 19 current_timestamp()

When the link was created
created_by VARCHAR 255 √ NULL
users.username Defined in XML R

Username who created the link

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_clinical_note_id Performance Asc clinical_note_id
idx_created_at Performance Asc created_at
idx_document_id Performance Asc document_id
unique_note_document Must be unique Asc/Asc clinical_note_id + document_id

Relationships

Close relationships within degrees of separation