Implement database structure for Item lookups

[SergeyDz]

Investigate and propose list of work item drop-downs.

Investigate existing solutions and propose database columns and data types for storing Work Item lookups.

As final result, table creational DDL script need to be created.

[davands]

I propose the following database columns for storing Work Item lookups:

Type int not null, Priority int, Assigny int, Status int not null, Resolution int not null, Security Level int not null

Each lookup will be populated from appropriate dictionary table.

Columns and data type for dictionary tables:

Id int identity (1,1) not null, Code int not null, Name nvarchar (50) not null, Active bit not null

+

table [Users] for 'Assigny' lookup.