帮我生成一份进销存前后端管理系统的mysql数据库表

以下是一个简单的进销存前后端管理系统的MySQL数据库表：

商品表

CREATE TABLE products ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, description varchar(255) DEFAULT NULL, category_id int(11) NOT NULL, supplier_id int(11) NOT NULL, cost decimal(10,2) NOT NULL, price decimal(10,2) NOT NULL, stock int(11) NOT NULL, PRIMARY KEY (id), KEY category_id (category_id), KEY supplier_id (supplier_id), CONSTRAINT products_ibfk_1 FOREIGN KEY (category_id) REFERENCES categories (id), CONSTRAINT products_ibfk_2 FOREIGN KEY (supplier_id) REFERENCES suppliers (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

分类表

CREATE TABLE categories ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, description varchar(255) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

供应商表

CREATE TABLE suppliers ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, address varchar(255) DEFAULT NULL, phone varchar(20) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

销售订单表

CREATE TABLE sales_orders ( id int(11) NOT NULL AUTO_INCREMENT, customer_id int(11) NOT NULL, order_date date NOT NULL, total decimal(10,2) NOT NULL, PRIMARY KEY (id), KEY customer_id (customer_id), CONSTRAINT sales_orders_ibfk_1 FOREIGN KEY (customer_id) REFERENCES customers (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

销售订单详情表

CREATE TABLE sales_order_details ( id int(11) NOT NULL AUTO_INCREMENT, order_id int(11) NOT NULL, product_id int(11) NOT NULL, quantity int(11) NOT NULL, unit_price decimal(10,2) NOT NULL, PRIMARY KEY (id), KEY order_id (order_id), KEY product_id (product_id), CONSTRAINT sales_order_details_ibfk_1 FOREIGN KEY (order_id) REFERENCES sales_orders (id), CONSTRAINT sales_order_details_ibfk_2 FOREIGN KEY (product_id) REFERENCES products (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

采购订单表

CREATE TABLE purchase_orders ( id int(11) NOT NULL AUTO_INCREMENT, supplier_id int(11) NOT NULL, order_date date NOT NULL, total decimal(10,2) NOT NULL, PRIMARY KEY (id), KEY supplier_id (supplier_id), CONSTRAINT purchase_orders_ibfk_1 FOREIGN KEY (supplier_id) REFERENCES suppliers (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

采购订单详情表

CREATE TABLE purchase_order_details ( id int(11) NOT NULL AUTO_INCREMENT, order_id int(11) NOT NULL, product_id int(11) NOT NULL, quantity int(11) NOT NULL, unit_price decimal(10,2) NOT NULL, PRIMARY KEY (id), KEY order_id (order_id), KEY product_id (product_id), CONSTRAINT purchase_order_details_ibfk_1 FOREIGN KEY (order_id) REFERENCES purchase_orders (id), CONSTRAINT purchase_order_details_ibfk_2 FOREIGN KEY (product_id) REFERENCES products (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

客户表

CREATE TABLE customers ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, address varchar(255) DEFAULT NULL, phone varchar(20) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

以上是一个简单的进销存前后端管理系统的MySQL数据库表，可以根据实际需求进行修改和扩展。