m1s1NzVQ

1CREATE TABLE IF NOT EXISTS product (
2  id INT UNSIGNED NOT NULL AUTO_INCREMENT,
3  name VARCHAR(255),
4  amount INT NOT NULL,
5  PRIMARY KEY (id)
6);
7
8CREATE TABLE IF NOT EXISTS category (
9  id INT UNSIGNED NOT NULL AUTO_INCREMENT,
10  name VARCHAR(255),
11  PRIMARY KEY (id)
12);
13
14CREATE TABLE IF NOT EXISTS subcategory (
15  id INT UNSIGNED NOT NULL AUTO_INCREMENT,
16  name VARCHAR(255),
17  PRIMARY KEY (id)
18);
19
20CREATE TABLE IF NOT EXISTS product_category_subcategory (
21  id INT UNSIGNED NOT NULL AUTO_INCREMENT,
22  product INT UNSIGNED NOT NULL,
23  category INT UNSIGNED NOT NULL,
24  subcategory INT UNSIGNED NOT NULL,
25  PRIMARY KEY (id),
26  FOREIGN KEY (product) REFERENCES product(id),
27  FOREIGN KEY (category) REFERENCES category(id),
28  FOREIGN KEY (subcategory) REFERENCES subcategory(id)
29);