categories_to_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 categories_to_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

Mapping table connecting documents to categories

Columns

Column Type Size Nulls Auto Default Children Parents Comments
category_id INT 10 0
categories.id Defined in XML R
document_id INT 10 0
documents.id Defined in XML R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc category_id + document_id

Relationships

Close relationships within degrees of separation