Skip to main content
A category assigned to the condition, such as problem-list-item or encounter-diagnosis (Condition.category[]). One row per anchor_index on the normalized stage table. Primary Keys:
  • condition_category_id (surrogate)
Foreign Keys:
  • condition_id – links to the condition table
ColumnData TypeDescription
condition_category_idvarcharSurrogate key for this category row
condition_idvarcharParent condition
textvarcharCategory narrative (Condition.category[].text)
Related Tables: Parent: Child: