VAR_PGX_MED_USE_NARR

Description: |
This table stores the medication usage narrative for a pharmacogenomic variant.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
VARIANT_ID | 1 |
GROUP_LINE | 2 |
VALUE_LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | VARIANT_ID | NUMERIC | No |
The unique identifier for the variant record.
2 | GROUP_LINE | INTEGER | No |
The line number of the medication usage narrative for a pharmacogenomic variant. Together with VARIANT_ID, this forms the foreign key to the VAR_PGX_MED_USE_NARR table.
3 | VALUE_LINE | INTEGER | No |
The line number of a portion of the medication usage narrative associated with the pharmacogenomic variant and medication from the VAR_PGX_MED_USE table
4 | MED_USE_NARRATIVE | VARCHAR | No |
Free text field denoting alteration to medication based on drug-gene interactions