CREATE TABLE [dbo].[patient_comorbidity] (
    [pt_comorbidity_key]     INT              IDENTITY (1, 1) NOT NULL,
    [pt_key]                      INT              NOT NULL,
    [comorbidity_key]             INT              NOT NULL,
    [pt_comorbidity_comment] NVARCHAR (255)   NULL,
    [pt_comorbidity_dt]    DATETIME         NULL,
    [modified_dt]                 DATETIME         NOT NULL,
    [modified_by_key]             UNIQUEIDENTIFIER NOT NULL,
    CONSTRAINT [pt_comorbidity_PK] PRIMARY KEY CLUSTERED ([pt_comorbidity_key] ASC),
    CONSTRAINT [patient_patient_comorbidities_FK1] FOREIGN KEY ([pt_key]) REFERENCES [dbo].[patient] ([pt_key])
);

