These should be indicated with an appropriate row in the clinical codes table and perhaps a details table to store the data.
For text records, we don't expect to get raw text. We will probably get specific terms mined from text data (e.g., "diabetes"). So, this will either need to be mapped to an existing vocab or put in as raw text.
For QOL data, we might get scale scores or answers to individual questions. Each instrument could be considered its own vocabulary with names for questions and scores. And the values could be in the clinical codes table.
These should be indicated with an appropriate row in the clinical codes table and perhaps a details table to store the data.
For text records, we don't expect to get raw text. We will probably get specific terms mined from text data (e.g., "diabetes"). So, this will either need to be mapped to an existing vocab or put in as raw text.
For QOL data, we might get scale scores or answers to individual questions. Each instrument could be considered its own vocabulary with names for questions and scores. And the values could be in the clinical codes table.