-- Schema bookjounaldb
CREATE SCHEMA IF NOT EXISTS bookjounaldb DEFAULT CHARACTER SET utf8 ;
USE bookjounaldb ;

-- Table bookjounaldb.user
CREATE TABLE IF NOT EXISTS bookjounaldb.user (
seq INT NOT NULL AUTO_INCREMENT,
user_id VARCHAR(45) NOT NULL,
name VARCHAR(45) NOT NULL,
pw VARCHAR(45) NOT NULL,
PRIMARY KEY (seq))
ENGINE = InnoDB;

-- Table bookjounaldb.book
CREATE TABLE IF NOT EXISTS bookjounaldb.book (
seq INT NOT NULL AUTO_INCREMENT,
isbn VARCHAR(45) NOT NULL,
title VARCHAR(45) NOT NULL,
author VARCHAR(45) NOT NULL,
cover VARCHAR(45) NOT NULL,
PRIMARY KEY (seq))
ENGINE = InnoDB;

-- Table bookjounaldb.bookjounal
CREATE TABLE IF NOT EXISTS bookjounaldb.bookjounal (
seq INT NOT NULL AUTO_INCREMENT,
user_id VARCHAR(45) NOT NULL,
isbn VARCHAR(45) NOT NULL,
state INT NOT NULL,
grade INT NULL,
start_date DATE NULL,
end_date DATE NULL,
memo VARCHAR(3000) NULL,
release VARCHAR(30) NULL,
reg_date DATE NULL,
PRIMARY KEY (seq))
ENGINE = InnoDB;