CREATE DATABASE book_manage_sys;

USE book_manage_sys;

CREATE TABLE student(

 id INT UNSIGNED PRIMARY key not null auto_increment,

stu_name VARCHAR(200) not null,

pa_word VARCHAR(20) not null,

lend_book_name INT UNIQUE not null,

lend_time TIMESTAMP not null,

latest_return_time TIMESTAMP not null,

return_time TIMESTAMP not null,

headmaster int UNIQUE not null,

FOREIGN KEY (lend_book_name) references books(id),

foreign key (headmaster) references teachers(id)

);

CREATE TABLE books(

 id INT UNSIGNED PRIMARY key not null auto_increment,

 book_name VARCHAR(200) not null,

 author VARCHAR(20) not null,

 publish_time TIMESTAMP not null,

 publisher VARCHAR(200) not null,

 recom_read_time int not null

);

CREATE TABLE teachers(

  id INT UNSIGNED PRIMARY KEY not null auto_increment,

teacher_name VARCHAR(200) not null,

tell char(11) not null

);