CREATE TABLE [dbo].[scheme_option] (
    [scheme_opt_key]     VARCHAR (7)   NOT NULL,
    [scheme_opt_name]    VARCHAR (100) NOT NULL,
    [scheme_key]         INT           NOT NULL,
    [scheme_opt_from_dt] DATE          NULL,
    [scheme_opt_till_dt] DATE          NULL,
    CONSTRAINT [scheme_option_PK] PRIMARY KEY CLUSTERED ([scheme_opt_key] ASC),
    CONSTRAINT [scheme_scheme_option_FK1] FOREIGN KEY ([scheme_key]) REFERENCES [dbo].[scheme] ([scheme_key])
);

