categories


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

Categories that documents can be assigned to

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 0
categories_to_documents.category_id Defined in XML R
name VARCHAR 255 √ NULL
value VARCHAR 255 √ NULL
parent INT 10 0
lft INT 10 0
rght INT 10 0
aco_spec VARCHAR 63 'patients|docs'
codes VARCHAR 255 ''

Category codes for documents stored in this category

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
lft Performance Asc/Asc lft + rght
parent Performance Asc parent

Relationships

Close relationships within degrees of separation