Concept answer
Contents |
[edit]
Description
Stores answer values for all concepts that have coded datatypes (answers are other concepts from the dictionary).
[edit]
Attributes
| Column Name | Type | Default | Description | |
|---|---|---|---|---|
| | concept_answer_id | int | Unique key for this table. | |
| | concept_id concept.concept_id | int | Concept for which there is one or more coded answers for. | |
| answer_concept concept.concept_id | int | NULL | Answer term for a given concept. For each answer, there will be a row in this table. | |
| answer_drug drug.drug_id | int | NULL | When concepts have drug datatypes, they will have answers from the drug table. | |
| | creator users.user_id | int | Creator of the answer. | |
| | date_created | datetime | 0000-00-00 00:00:00 | Date the answer was created. |
| | ||||
