Connect tables demographic.subject_type and demographic.subject_category into one table
In the release 02.02.0000
, a new table has been added to the demographic
schema - subject_category
. This table should represent categories (at this time specific for Mayo institution) of the subjects, namely: n/a, Control, Epilepsy, Artic Sun, Movement Disorders, and Pain.
However, the categories stored in this table could be stored in the table subject_type
under the new column - subtype
. This solution should be considered during the development of the new MINED update.
It is important to note that such adjustment would require subsequent adjustments in SQL functions manipulating with table demographic.subject
, same as adjustments to the minedpy
and mined_web
.