CREATE TABLE [dbo].[patient_medication] (
    [medication_key] INT           IDENTITY (1, 1) NOT NULL,
    [code]           NCHAR (10)    NULL,
    [name]           NVARCHAR (50) NULL,
    [description]    NTEXT         NOT NULL,
    CONSTRAINT [PK_patient_medication] PRIMARY KEY CLUSTERED ([medication_key] ASC)
);

