CREATE TABLE [dbo].[Book] ( [Id] INT NOT NULL, [CurrentLocation] INT NOT NULL, [NumberPerBox] INT NOT NULL, [ReturnPolicy] INT NOT NULL, [Title] VARCHAR (255) NULL, [Active] BIT NOT NULL, [BooksInStore] INT NOT NULL, [BoxesInWarehouse] INT NOT NULL, [BookType] INT NOT NULL, CONSTRAINT [PK_Book] PRIMARY KEY CLUSTERED ([Id] ASC) );