clinical_notes_procedure_results


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_procedure_results.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 procedure results/lab values

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
procedure_result_id BIGINT 19 null
procedure_result.procedure_result_id Defined in XML R

Foreign key to procedure_result.procedure_result_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_procedure_result_id Performance Asc procedure_result_id
unique_note_result Must be unique Asc/Asc clinical_note_id + procedure_result_id

Relationships

Close relationships within degrees of separation