php添加一个商品要建哪些表

CREATE TABLE product (
  id INT NOT NULL AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL,
  description TEXT,
  price DECIMAL(10, 2) NOT NULL,
  stock INT NOT NULL,
  CONSTRAINT PK_product PRIMARY KEY (id)
);

CREATE TABLE category (
  id INT NOT NULL AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL,
  description TEXT,
  CONSTRAINT PK_category PRIMARY KEY (id)
);

CREATE TABLE product_category (
  product_id INT NOT NULL,
  category_id INT NOT NULL,
  CONSTRAINT PK_product_category PRIMARY KEY (product_id, category_id),
  CONSTRAINT FK_product FOREIGN KEY (product_id) REFERENCES product (id),
  CONSTRAINT FK_category FOREIGN KEY (category_id) REFERENCES category (id)
);

CREATE TABLE product_image (
  id INT NOT NULL AUTO_INCREMENT,
  product_id INT NOT NULL,
  image_url VARCHAR(255) NOT NULL,
  CONSTRAINT PK_product_image PRIMARY KEY (id),
  CONSTRAINT FK_product FOREIGN KEY (product_id) REFERENCES product (id)
);