CREATE TABLE bookInfo BookId INT PRIMARY KEY bookNo VARCHAR50 NOT NULL BookName VARCHAR100 NOT NULL BTypeId INT NOT NULL Price DECIMAL102 NOT NULL BookCount INT NOT NULL BSheIfId INT NO

CREATE TABLE bookInfo ( BookId INT PRIMARY KEY AUTO_INCREMENT, bookNo VARCHAR(50) NOT NULL, BookName VARCHAR(100) NOT NULL, BTypeId INT NOT NULL, Price DECIMAL(10,2) NOT NULL, BookCount INT NOT NULL, BSheIfId INT NOT NULL, BookRemark VARCHAR(500), IsDeleTed BIT NOT NULL DEFAULT 0 );