database.sql

/*
 @Table users
*/
CREATE TABLE IF NOT EXISTS users (
  id SERIAL PRIMARY KEY,
  name VARCHAR(155) NOT NULL,
  email VARCHAR(255) UNIQUE NOT NULL,
  password VARCHAR(255) NOT NULL,
  created_at TIMESTAMP NOT NULL
);

/*
 @Table books
*/
CREATE TABLE IF NOT EXISTS books (
  id SERIAL PRIMARY KEY,
  title VARCHAR (155) NOT NULL,
  description TEXT NOT NULL,
  created_at TIMESTAMP NOT NULL,
  user_id INT NOT NULL,
  FOREIGN KEY (user_id) REFERENCES users (id)
);

/*
 @Table images
*/
CREATE TABLE IF NOT EXISTS images (
  id SERIAL PRIMARY KEY,
  image BYTEA NOT NULL,
  created_at TIMESTAMP NOT NULL,
  book_id INT NOT NULL,
  user_id INT NOT NULL,
  FOREIGN KEY (book_id) REFERENCES books (id),
  FOREIGN KEY (user_id) REFERENCES users (id)
);