Book Table

Book,sql

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)
);