用Mysql写酒店管理系统数据库的开头代码
时间: 2024-05-07 22:20:15 浏览: 4
以下是一个简单的酒店管理系统数据库的开头代码:
```
CREATE DATABASE hotel_management;
USE hotel_management;
CREATE TABLE rooms (
room_number INT PRIMARY KEY,
room_type ENUM('single', 'double', 'suite'),
price DECIMAL(10, 2),
status ENUM('available', 'occupied', 'maintenance')
);
CREATE TABLE customers (
customer_id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(50),
email VARCHAR(50),
phone VARCHAR(20),
address VARCHAR(100)
);
CREATE TABLE bookings (
booking_id INT PRIMARY KEY AUTO_INCREMENT,
customer_id INT,
room_number INT,
check_in_date DATE,
check_out_date DATE,
FOREIGN KEY (customer_id) REFERENCES customers(customer_id),
FOREIGN KEY (room_number) REFERENCES rooms(room_number)
);
```
这段代码创建了一个名为`hotel_management`的数据库,并在其中创建了三张表格:`rooms`,`customers`和`bookings`。`rooms`表格记录了房间的信息,包括房间号、房间类型、价格和状态;`customers`表格记录了客户的信息,包括客户ID、姓名、邮箱、电话和地址;`bookings`表格记录了客户和房间的预订信息,包括预订ID、客户ID、房间号、入住日期和退房日期。