宾馆管理系统数据库

-- 创建客房表
CREATE TABLE `rooms` (
  `room_id` INT PRIMARY KEY AUTO_INCREMENT,
  `room_number` VARCHAR(10) NOT NULL,
  `room_type` VARCHAR(50) NOT NULL,
  `price` DECIMAL(10, 2) NOT NULL,
  `status` VARCHAR(20) NOT NULL
);

-- 创建客户表
CREATE TABLE `customers` (
  `customer_id` INT PRIMARY KEY AUTO_INCREMENT,
  `name` VARCHAR(100) NOT NULL,
  `phone` VARCHAR(20) NOT NULL,
  `email` VARCHAR(100) NOT NULL
);

-- 创建预订表
CREATE TABLE `reservations` (
  `reservation_id` INT PRIMARY KEY AUTO_INCREMENT,
  `customer_id` INT NOT NULL,
  `room_id` INT NOT NULL,
  `check_in_date` DATE NOT NULL,
  `check_out_date` DATE NOT NULL,
  FOREIGN KEY (`customer_id`) REFERENCES `customers`(`customer_id`),
  FOREIGN KEY (`room_id`) REFERENCES `rooms`(`room_id`)
);