CREATE TABLE [dbo].[patient_condition] (
	[pt_condition_key] INT IDENTITY (1, 1) NOT NULL,
	[pt_key] INT NOT NULL,
	[icd_code] NVARCHAR(7) NOT NULL,
	pt_condition_diag_dt datetime not null,
	[modified_dt] DATETIME  NOT NULL,
    [modified_by_key] UNIQUEIDENTIFIER NOT NULL,
    CONSTRAINT [pt_condition_PK] PRIMARY KEY CLUSTERED ([pt_condition_key] ASC),
	CONSTRAINT [patient_patient_condition_FK1] FOREIGN KEY ([pt_key]) REFERENCES [dbo].[patient] ([pt_key])
);

