MySQL数据库表设计：商品（Goods）和商品详情（GoodsDetail）表创建教程

CREATE TABLE Goods (\n id INT PRIMARY KEY AUTO_INCREMENT,\n name VARCHAR(255) NOT NULL,\n price DECIMAL(10, 2) NOT NULL,\n description TEXT,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP\n);\n\nCREATE TABLE GoodsDetail (\n id INT PRIMARY KEY AUTO_INCREMENT,\n goods_id INT NOT NULL,\n color VARCHAR(50) NOT NULL,\n size VARCHAR(20) NOT NULL,\n stock INT NOT NULL,\n FOREIGN KEY (goods_id) REFERENCES Goods(id)\n);