使用CREATE TABLE命令。别为会员信息表,商品类别表,商品信息表、员工信息表、支付方式表、订单信息表、订单详情表的创建。
时间: 2023-07-10 21:38:42 浏览: 44
好的,以下是创建表的SQL语句:
创建会员信息表:
```
CREATE TABLE member_info (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50) NOT NULL,
gender ENUM('male', 'female') NOT NULL,
age INT NOT NULL,
phone VARCHAR(20) NOT NULL,
address VARCHAR(100) NOT NULL
);
```
创建商品类别表:
```
CREATE TABLE commodity_category (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50) NOT NULL,
description VARCHAR(100) NOT NULL
);
```
创建商品信息表:
```
CREATE TABLE commodity_info (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50) NOT NULL,
category_id INT NOT NULL,
price DECIMAL(10, 2) NOT NULL,
stock INT NOT NULL,
description VARCHAR(100) NOT NULL,
FOREIGN KEY (category_id) REFERENCES commodity_category(id)
);
```
创建员工信息表:
```
CREATE TABLE employee_info (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50) NOT NULL,
gender ENUM('male', 'female') NOT NULL,
age INT NOT NULL,
phone VARCHAR(20) NOT NULL,
address VARCHAR(100) NOT NULL,
position VARCHAR(50) NOT NULL,
salary DECIMAL(10, 2) NOT NULL
);
```
创建支付方式表:
```
CREATE TABLE payment_method (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50) NOT NULL,
description VARCHAR(100) NOT NULL
);
```
创建订单信息表:
```
CREATE TABLE order_info (
id INT AUTO_INCREMENT PRIMARY KEY,
member_id INT NOT NULL,
employee_id INT NOT NULL,
payment_method_id INT NOT NULL,
total_price DECIMAL(10, 2) NOT NULL,
create_time DATETIME NOT NULL,
update_time DATETIME NOT NULL,
FOREIGN KEY (member_id) REFERENCES member_info(id),
FOREIGN KEY (employee_id) REFERENCES employee_info(id),
FOREIGN KEY (payment_method_id) REFERENCES payment_method(id)
);
```
创建订单详情表:
```
CREATE TABLE order_detail (
id INT AUTO_INCREMENT PRIMARY KEY,
order_id INT NOT NULL,
commodity_id INT NOT NULL,
quantity INT NOT NULL,
price DECIMAL(10, 2) NOT NULL,
FOREIGN KEY (order_id) REFERENCES order_info(id),
FOREIGN KEY (commodity_id) REFERENCES commodity_info(id)
);
```
相关推荐
![](https://img-home.csdnimg.cn/images/20210720083646.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)