/*
Navicat MySQL Data Transfer
Version: v0.5.8
Date: 2021-05-08 18:45:42
*/SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ 用户表-- ----------------------------DROPTABLEIFEXISTS`user`;CREATETABLE`user`(`user_id`int(11)NOTNULLAUTO_INCREMENTCOMMENT'用户id',`user_password`varchar(64)NOTNULL,`user_name`varchar(64)DEFAULTNULLCOMMENT'姓名',`user_type`intNOTNULLDEFAULT1COMMENT'用户类型:默认为管理员 value=1',`phone`varchar(16)DEFAULTNULLCOMMENT'手机号',`gender`intDEFAULTNULLCOMMENT'性别',`email`varchar(255)DEFAULTNULLCOMMENT'邮箱',`id_card`varchar(32)DEFAULTNULLCOMMENT'身份证',`invite_code`varchar(255)DEFAULTNULLCOMMENT'邀请码',PRIMARYKEY(`user_id`))ENGINE=InnoDBDEFAULTCHARSET=utf8;-- ------------------------------ Records of 用户表 is null.-- ------------------------------ ------------------------------ Table structure for 订单明细表-- ----------------------------DROPTABLEIFEXISTS`order_detail`;CREATETABLE`order_detail`(`detail_id`int(11)NOTNULLAUTO_INCREMENTCOMMENT'明细id',`order_id`int(11)NOTNULLCOMMENT'订单id',`room_id`int(11)NOTNULLCOMMENT'房间号',`register_id`int(11)NOTNULLCOMMENT'登记id',`sub_amount`decimal(9,2)DEFAULTNULLCOMMENT'小计',`advance`decimal(9,2)DEFAULTNULLCOMMENT'预付款额',PRIMARYKEY(`detail_id`),KEY`order_id`(`order_id`),KEY`room_id`(`room_id`),CONSTRAINT`room_id`FOREIGNKEY(`room_id`)REFERENCES`room`(`room_id`),CONSTRAINT`order_id`FOREIGNKEY(`order_id`)REFERENCES`order`(`order_id`))ENGINE=InnoDBDEFAULTCHARSET=utf8;-- ------------------------------ Records of order_detail is null-- ------------------------------ ------------------------------ Table structure for 订单表-- ----------------------------DROPTABLEIFEXISTS`order`;CREATETABLE`order`(`order_id`int(11)NOTNULLAUTO_INCREMENTCOMMENT'订单id',`user_id`int(11)NOTNULLCOMMENT'处理人id',`buyer_name`varchar(64)DEFAULTNULLCOMMENT'买方姓名',`buyer_phone`varchar(16)DEFAULTNULLCOMMENT'买方联系方式',`create_time`datetimeDEFAULTNULLCOMMENT'订单创建时间',`update_time`datetimeDEFAULTNULLCOMMENT'订单修改时间',`amount`decimal(9,2)DEFAULTNULLCOMMENT'总金额',`pay_status`int(1)DEFAULT0COMMENT'付款状态',`order_status`int(1)DEFAULT0COMMENT'订单状态',PRIMARYKEY(`order_id`),KEY`userId`(`user_id`),CONSTRAINT`userId`FOREIGNKEY(`user_id`)REFERENCES`user`(`user_id`))ENGINE=InnoDBDEFAULTCHARSET=utf8;-- ------------------------------ Records of order-- ------------------------------ ------------------------------ Table structure for `登记信息`-- ----------------------------DROPTABLEIFEXISTS`register_record`;CREATETABLE`register_record`(`register_id`int(11)NOTNULLAUTO_INCREMENTCOMMENT'登记id',`detail_id`int(11)NOTNULLCOMMENT'明细id',`customer_id`varchar(32)DEFAULTNULLCOMMENT'顾客身份证号码',`customer_name`varchar(32)DEFAULTNULLCOMMENT'顾客姓名',`customer_phone`varchar(16)DEFAULTNULLCOMMENT'顾客联系方式',`register_time`datetimeDEFAULTNULLCOMMENT'入住时间',`checkout_time`datetimeDEFAULTNULLCOMMENT'退房时间',PRIMARYKEY(`register_id`),KEY`detail_id`(`detail_id`),CONSTRAINT`detail_id`FOREIGNKEY(`detail_id`)REFERENCES`order_detail`(`detail_id`))ENGINE=InnoDBDEFAULTCHARSET=utf8;-- ------------------------------ Records of 登记信息 is null-- ------------------------------ ------------------------------ Table structure for `room`-- ----------------------------DROPTABLEIFEXISTS`room`;CREATETABLE`room`(`room_id`int(11)NOTNULLAUTO_INCREMENTCOMMENT'房间号',`type_id`int(11)DEFAULTNULLCOMMENT'房间类型',`room_status`int(11)DEFAULTNULLCOMMENT'房间状态',PRIMARYKEY(`room_id`),KEY`type_id`(`type_id`),CONSTRAINT`type_id`FOREIGNKEY(`type_id`)REFERENCES`room_type`(`type_id`))ENGINE=InnoDBDEFAULTCHARSET=utf8;-- ------------------------------ Records of room-- ------------------------------ ------------------------------ Table structure for `room_type`-- ----------------------------DROPTABLEIFEXISTS`room_type`;CREATETABLE`room_type`(`type_id`int(11)NOTNULLAUTO_INCREMENTCOMMENT'房间类型id',`type_name`varchar(64)DEFAULTNULLCOMMENT'房间类型简称',`bed_num`int(3)DEFAULTNULLCOMMENT'床位',`price`decimal(9,2)DEFAULTNULLCOMMENT'单价',`introduction`varchar(255)DEFAULTNULLCOMMENT'简介',PRIMARYKEY(`type_id`))ENGINE=InnoDBDEFAULTCHARSET=utf8;-- ------------------------------ Records of room_type-- ----------------------------