MEDICATIONINDICATION
Description: Reason to use a certain medication

Primary Key
Column Name Ordinal Position

Foreign Key
Column Name Ordinal Position Referenced Table
MEDICATIONID 2 MEDICATION
MEDICATIONDOSEFORMSTRENGTHID 3 MEDICATIONDOSEFORMSTRENGTH
INDICATIONREFERENCEOBSERVATIONDEFINITIONID 7 OBSERVATIONDEFINITION

Column Information
Name Type
1 MEDICATIONINDICATIONID INT
Description: The unique Id for the MedicationIndication table
Name Type
2 MEDICATIONID INT
Description: MedicationId is a foreign key to the Medication table
Name Type
3 MEDICATIONDOSEFORMSTRENGTHID INT
Description: MedicationDoseFormStrengthId is a foreign key to the MedicationDoseFormStrength table
Name Type
4 INDICATION NVARCHAR
Description: The indication related to the medication
Name Type
5 SYSTEM NVARCHAR
Description: The system use for the indication
Name Type
6 DESCRIPTION NVARCHAR
Description: Detailed Description
Name Type
7 INDICATIONREFERENCEOBSERVATIONDEFINITIONID INT
Description: IndicationReferenceObservationDefinitionId is a foreign key to the ObservationDefinition table