Concept answer


Contents

Description

Stores answer values for all concepts that have coded datatypes (answers are other concepts from the dictionary).

Attributes

Column Name Type Default Description
Primary Key concept_answer_id int Unique key for this table.
Required 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.
Required creator users.user_id int Creator of the answer.
Required date_created datetime 0000-00-00 00:00:00 Date the answer was created.
Primary Key primary key, Required required