CREATE TABLE [dbo].[patient_consult] (
    [pt_consult_key]     INT              IDENTITY (1, 1) NOT NULL,
    [pt_key]             INT              NOT NULL,
    [pt_symptoms]        NVARCHAR (500) NULL,
    [pt_signs] NVARCHAR (255)   NULL,
    [pt_med_hist_notes]  NVARCHAR (500)       NULL,
    [modified_dt]        DATETIME         NOT NULL,
    [modified_by_key]    UNIQUEIDENTIFIER NOT NULL,
    CONSTRAINT [pt_consult_PK] PRIMARY KEY CLUSTERED ([pt_consult_key] ASC),
    CONSTRAINT [patient_patient_consult_FK1] FOREIGN KEY ([pt_key]) REFERENCES [dbo].[patient] ([pt_key])
);