CREATE TABLE [dbo].[measurement] (
    [measurement_key]      INT           NOT NULL,
    [source]               NVARCHAR (50) NULL,
    [date_of_measure]      DATETIME      NULL,
    [date_recorded]        DATETIME      NULL,
    [measurement_type_key] INT           NOT NULL,
    [pt_key]               INT           NOT NULL,
    CONSTRAINT [PK_measurement] PRIMARY KEY CLUSTERED ([measurement_key] ASC),
    CONSTRAINT [measurement_measuremenent_type_FK] FOREIGN KEY ([measurement_type_key]) REFERENCES [dbo].[measurement_type] ([measurement_type_key]),
    CONSTRAINT [measurement_patient_FK] FOREIGN KEY ([pt_key]) REFERENCES [dbo].[patient] ([pt_key])
);

