CREATE TABLE [dbo].[patient_notes] (
    [pt_note_key]     INT              IDENTITY (1, 1) NOT NULL,
    [pt_key]          INT              NOT NULL,
    [pt_note]         VARCHAR (255)    NOT NULL,
    [pt_note_expired] BIT              NULL,
    [modified_dt]     DATETIME         NULL,
    [modified_by_key] UNIQUEIDENTIFIER NULL,
    CONSTRAINT [patient_notes_PK] PRIMARY KEY CLUSTERED ([pt_note_key] ASC),
    CONSTRAINT [patient_patient_notes_FK1] FOREIGN KEY ([pt_key]) REFERENCES [dbo].[patient] ([pt_key])
);

