CREATE TABLE [dbo].[lookup_table] (
    [lookup_key]                  INT           IDENTITY (1, 1) NOT NULL,
    [lookup_dropdown_value]       VARCHAR (255) NOT NULL,
    [lookup_dropdown_description] VARCHAR (300) NOT NULL,
    [lookup_type]                 VARCHAR (255) NOT NULL,
    [lookup_display_order]        INT           NOT NULL,
    [active]                      BIT           NOT NULL,
    CONSTRAINT [lookup_PK] PRIMARY KEY CLUSTERED ([lookup_key] ASC)
);

