CREATE TABLE [dbo].[patient_condition_link] (
    [condition_link_key] INT IDENTITY (1, 1) NOT NULL,
    [pt_id]              INT NULL,
    [condition_key]      INT NULL,
    CONSTRAINT [PK_patient_allergy_link] PRIMARY KEY CLUSTERED ([condition_link_key] ASC),
    CONSTRAINT [patient_condition_link_patient_condition_FK] FOREIGN KEY ([condition_key]) REFERENCES [dbo].[patient_condition] ([pt_condition_key]),
    CONSTRAINT [patient_condition_link_patient_FK] FOREIGN KEY ([pt_id]) REFERENCES [dbo].[patient] ([pt_key])
);

