下面是sql语句
create database bookstore character set UTF8;
use bookstore;
/*类型表*/
CREATE TABLE TYPES(
id VARCHAR(32) PRIMARY KEY,
NAME VARCHAR(50),
des VARCHAR(200)
);
/*关联表*/
create table booktype(
bookid varchar(32) not null,
typeid varchar(32) not null,
CONSTRAINT btpk primary key(bookid,typeid),
constraint btfk1 foreign key(bookid) references books(id),
constraint btfk2 foreign key(typeid) references types(id)
);