CREATE TABLE [dbo].[scheme] (
    [scheme_key]        INT           NOT NULL,
    [scheme_name]       VARCHAR (100) NOT NULL,
    [scheme_short_name] VARCHAR (50)  NOT NULL,
    [scheme_type_key]   INT           NOT NULL,
    [scheme_from_dt]    DATE          NULL,
    [scheme_till_dt]    DATE          NULL,
    CONSTRAINT [scheme_PK] PRIMARY KEY CLUSTERED ([scheme_key] ASC),
    CONSTRAINT [scheme_type_scheme_FK1] FOREIGN KEY ([scheme_type_key]) REFERENCES [dbo].[scheme_type] ([scheme_type_key])
);

