schema.sql

DROP DATABASE IF EXISTS reviews;

CREATE DATABASE reviews;

USE reviews;

CREATE TABLE products (
  id INT NOT NULL AUTO_INCREMENT=10275,
  item_name VARCHAR(255) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE users (
  id INT NOT NULL AUTO_INCREMENT,
  first_name VARCHAR(255) NOT NULL,
  last_name VARCHAR(255) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE overall (
  id INT NOT NULL AUTO_INCREMENT,
  rating VARCHAR(255) NOT NULL,
  difficulty VARCHAR(255) NOT NULL,
  experience VARCHAR(255) NOT NULL,
  value_money VARCHAR(255) NOT NULL,
  rate1 INT NOT NULL,
  rate2 INT NOT NULL,
  rate3 INT NOT NULL,
  rate4 INT NOT NULL,
  rate5 INT NOT NULL,
  ratePercentage1 VARCHAR(255) NOT NULL,
  ratePercentage2 VARCHAR(255) NOT NULL,
  ratePercentage3 VARCHAR(255) NOT NULL,
  ratePercentage4 VARCHAR(255) NOT NULL,
  ratePercentage5 VARCHAR(255) NOT NULL,
  recommendToOther VARCHAR(255) NOT NULL,
  number_review INT NOT NULL,
  product_id INT NOT NULL,
  PRIMARY KEY (id),
  FOREIGN KEY (product_id) REFERENCES products(id)
);

CREATE TABLE reviewList (
  id INT NOT NULL AUTO_INCREMENT,
  date_create VARCHAR(200) NOT NULL,
  overall_rate INT NOT NULL,
  username VARCHAR(255) NOT NULL,
  age INT(200) NOT NULL,
  recommend BOOLEAN,
  purchase_for VARCHAR(255),
  title VARCHAR(255) NOT NULL,
  content TEXT NOT NULL,
  play_experience INT,
  level_difficulty INT,
  value_for_money INT,
  build_time INT,
  building_experience VARCHAR(255),
  helpful_yes INT,
  helpful_no INT,
  image1 VARCHAR(255),
  image2 VARCHAR(255),
  image3 VARCHAR(255),
  product_id INT NOT NULL,
  users_id INT NOT NULL,
  lego_reply TEXT,
  PRIMARY KEY (id),
  FOREIGN KEY (product_id) REFERENCES products(id),
  FOREIGN KEY (users_id) REFERENCES users(id)
);