酒店预订系统-酒店预订系统-预订 - MySQL数据库表结构设计

-- 数据库大全：酒店预订系统-酒店预订系统-预订
-- 来源：YesApi.cn
CREATE TABLE `yesapi_hotel_reservation` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `reservation_id` int(11) NOT NULL COMMENT '预订ID',
    `reservation_no` varchar(50) NOT NULL COMMENT '预订号',
    `reservation_guest_name` varchar(50) NOT NULL COMMENT '客人姓名',
    `reservation_guest_phone` varchar(20) NOT NULL COMMENT '客人电话',
    `reservation_room_id` int(11) NOT NULL COMMENT '客房ID',
    `reservation_check_in` date NOT NULL COMMENT '入住日期',
    `reservation_check_out` date NOT NULL COMMENT '退房日期',
    `reservation_nights` int(11) NOT NULL DEFAULT '1' COMMENT '入住晚数',
    `reservation_total` decimal(10,0) NOT NULL DEFAULT '0' COMMENT '总金额',
    `reservation_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
    `reservation_create_time` datetime NOT NULL COMMENT '创建时间',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '酒店预订系统-酒店预订系统-预订';