【正文】 BOOKS primary key(bookID))go/*================*/ /* Table: booktype*/ /*================*/ create table booktype（Smalltype_idvarchar(50)not null，Bigtype_idvarchar(50)not null，Bigtype_namevarchar(50)not null，constraint PK_BOOKTYPE primary key(Smalltype_id))go/*================*/ /* Table: booktype2*/ /*================*/ create table booktype2（Smalltype_idvarchar(50)not null，Smalltype_namevarchar(50)not null，Bigtype_idvarchar(50)not null，constraint PK_BOOKTYPE2 primary key(Smalltype_id))go/*================*/ /* Table: discount*/ /*================*/ create table discount（datetimevarchar(10)not null，discountdouble precisionnot null，remarkdatetimenot null，constraint PK_DISCOUNT primary key(datetime))go/*================*/ /* Table: leaveWords*/ /*================*/ create table leaveWords（Lword_idvarchar(50)not null，use_Usernamevarchar(20)null，Usernamevarchar(6)not null，Subjectvarchar(6)not null，Submit_datedatetimenull，Lword_texevarchar(4000)null，Re_statusvarchar(10)null，constraint PK_LEAVEWORDS primary key(Lword_id))go/*================*/ /* Table: limite*/ /*================*/ create table limite（usernamevarchar(20)not null，Administrator_idvarchar(50)null，user_limitevarchar(2)not null，constraint PK_LIMITE primary key(username))go/*================*/ /* Table: model*/ /*================*/ create table model（model_idvarchar(10)not null，usernamevarchar(20)null，modelnamevarchar(20)not null，remarkvarchar(20)not null，constraint PK_MODEL primary key(model_id))go/*================*/ /* Table: orders*/ /*================*/ create table orders（Order_idvarchar(50)not null，bookIDvarchar(50)null，Usernamevarchar(20)null，Ship_idvarchar(50)null，shipaddressvarchar(50)not null，Order_datedatetimenot null，Book_idvarchar(50)not null，quantityintnot null，statusvarchar(2)not null，constraint PK_ORDERS primary key(Order_id))go/*================*/ /* Table: publish*/ /*================*/ create table publish（Pub_idvarchar(50)not null，Pub_namevarchar(50)not null，Pub_phonevarchar(15)not null，Pub_addvarchar(50)not null，constraint PK_PUBLISH primary key(Pub_id))go/*================*/ /* Table: sales*/ /*================*/ create table sales（Sale_idvarchar(50)not null，Order_idvarchar(50)null，Sale_datedatetimenull，Salervarchar(20)not null，Sale_statusvarchar(2)null，constraint PK_SALES primary key(Sale_id))go/*================*/ /* Table: shipped*/ /*================*/ create table shipped（Ship_idvarchar(50)not null，Sale_idvarchar(50)null，receive_namevarchar(10)not null，receive_addressvarchar(50)not null，Ship_datedatetimenot null，Ship_manvarchar(10)not null，receive_postcodevarchar(6)not null，receive_telephonevarchar(20)not null，constraint PK_SHIPPED primary key(Ship_id))go/*================*/ /* Table: shoppingcar*/ /*================*/ create table shoppingcar（shoppingcaridvarchar(10)not null，Smalltype_idvarchar(50)null，bookIDvarchar(50)null，Usernamevarchar(20)null，totalpricedouble precisionnot null，constraint PK_SHOPPINGCAR primary key(shoppingcarid))go/*================*/ /* Table: users*/ /*================*/ create table users（Usernamevarchar(20)not null，lim_usernamevarchar(20)null，Passwordvarchar(10)not null，degreevarchar(2)not null，Phonevarchar(15)null，“Emall”varchar(30)null，Addressvarchar(100)not null，True_namevarchar(10)not null，Postcodevarchar(6)not null，constraint PK_USERS primary key(Username))goalter table Administratorsadd constraint FK_ADMINIST_REFERENCE_USERS foreign key(Username)references users(Username)goalter table Re_statusadd constraint FK_RE_STATU_REFERENCE_ADMINIST foreign key(Administrator_id)references Administrators(Administrator_id)goalter table booksadd constraint FK_BOOKS_REFERENCE_BOOKTYPE foreign key(Smalltype_id)references booktype(Smalltype_id)goalter table booksadd constraint FK_BOOKS_REFERENCE_PUBLISH foreign key(Pub_id)references publish(Pub_id)goalter table booktypeadd constraint FK_BOOKTYPE_REFERENCE_BOOKTYPE foreign key(Smalltype_id)references booktype2(Smalltype_id)goalter table leaveWordsadd constraint FK_LEAVEWOR_REFERENCE_USERS foreign key(use_Username)references users(Username)goalter table limiteadd constraint FK_LIMITE_REFERENCE_ADMINIST foreign key(Administrator_id)references Administrators(Administrator_id)goalter table modeladd constraint FK_MODEL_REFERENCE_LIMITE foreign key(username)references limite(username)goalter table ordersadd constraint FK_ORDERS_REFERENCE_SHIPPED foreign key(Ship_id)references shipped(Ship_id)goalter table ordersadd constraint FK_ORDERS_REFERENCE_BOOKS foreign key(bookID)references books(bookID)goalter table ordersadd constraint FK_ORDERS_REFERENCE_USERS foreign key(Username)references users(Username)goalter table salesadd constraint FK