| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202 |
- /*
- Navicat MySQL Data Transfer
- Source Server : localhost_3306
- Source Server Version : 50635
- Source Host : localhost:3306
- Source Database : conference_room
- Target Server Type : MYSQL
- Target Server Version : 50635
- File Encoding : 65001
- Date: 2019-02-12 22:28:13
- */
- SET FOREIGN_KEY_CHECKS=0;
- -- ----------------------------
- -- Table structure for reservation
- -- ----------------------------
- DROP TABLE IF EXISTS `reservation`;
- CREATE TABLE `reservation` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `room_id` int(11) DEFAULT NULL,
- `user` varchar(32) DEFAULT NULL,
- `mobile` varchar(20) DEFAULT NULL,
- `date` date DEFAULT NULL,
- `begintime` time DEFAULT NULL,
- `endtime` time DEFAULT NULL,
- `mark` varchar(10) DEFAULT NULL,
- -- 主题
- `subject` varchar(60) DEFAULT NULL,
- -- 部门
- `department` varchar(60) DEFAULT NULL,
- -- 会议纪要
- `summary` varchar(5000) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_reservation_room` (`room_id`),
- CONSTRAINT `fk_reservation_room` FOREIGN KEY (`room_id`) REFERENCES `room` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Records of reservation
- -- ----------------------------
- -- ---------------------------------------------------
- -- Table structure for reservation_users--参会人员
- -- ---------------------------------------------------
- Drop TABLE IF EXISTS `reservation_users`;
- CREATE Table `reservation_users`(
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `reservation_id` int(11) NOT NULL,
- `user_id` varchar(32) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_reservation_users_reservation` (reservation_id),
- CONSTRAINT `fk_reservation_users_reservation` FOREIGN KEY (`reservation_id`) REFERENCES `reservation` (`id`),
- KEY `fk_reservation_users_user` (user_id),
- CONSTRAINT `fk_reservation_users_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
- )ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Records of reservation_users
- -- ----------------------------
- -- ---------------------------------------------------
- -- Table structure for reservation_resource--会议资料
- -- ---------------------------------------------------
- Drop TABLE IF EXISTS `reservation_resource`;
- CREATE TABLE `reservation_resource` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `reservation_id` int(11) NOT NULL,
- -- 资料名称
- `name` varchar(60) NOT NULL,
- -- 资料路径
- `path` varchar(100) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_reservation_users_room` (reservation_id),
- CONSTRAINT `fk_reservation_users_room` FOREIGN KEY (`reservation_id`) REFERENCES `reservation` (`id`)
- )ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Records of reservation_resource
- -- ----------------------------
- -- ----------------------------
- -- Table structure for role
- -- ----------------------------
- DROP TABLE IF EXISTS `role`;
- CREATE TABLE `role` (
- `role_id` int(11) NOT NULL,
- `role_name` varchar(50) DEFAULT NULL,
- PRIMARY KEY (`role_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Records of role
- -- ----------------------------
- INSERT INTO `role` VALUES ('1', 'admin');
- INSERT INTO `role` VALUES ('2', 'ordinary');
- -- ----------------------------
- -- Table structure for room
- -- ----------------------------
- DROP TABLE IF EXISTS `room`;
- CREATE TABLE `room` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(60) NOT NULL,
- `message` varchar(200) DEFAULT NULL,
- -- 物理位置
- `position` varchar(200) DEFAULT NULL,
- -- 会议室图片
- `image` varchar(200) DEFAULT NULL,
- -- 容量
- `capacity` int(11) DEFAULT NULL,
- -- 会议室区域
- `region` varchar(60) DEFAULT NULL,
- -- 会议室二维码
- `code` varchar(60) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Records of room
- -- ----------------------------
- INSERT INTO `room`(id,name,message) VALUES ('1', 'Cpeco会议室', '小会议室,适合十人小型会议,含多媒体');
- INSERT INTO `room`(id,name,message) VALUES ('2', 'Meos会议室', '大型会议室,可使用多媒体,适合开会、讲座');
- INSERT INTO `room`(id,name,message) VALUES ('3', 'Wellzoom会议室', '小会议室,适合十人小型会议,含多媒体');
- INSERT INTO `room`(id,name,message) VALUES ('4', '上格云大会议室', '大型会议室,可使用多媒体,适合开会、讲座');
- INSERT INTO `room`(id,name,message) VALUES ('5', '尚格云小会议室', '小会议室,适合十人小型会议,含多媒体');
- INSERT INTO `room`(id,name,message) VALUES ('6', 'Beecom会议室', '小会议室,适合十人小型会议,含多媒体');
- -- ----------------------------------------
- -- Table structure for Facility--会议室设备
- -- ----------------------------------------
- Drop TABLE IF EXISTS `facility`;
- CREATE Table `facility`(
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `room_id` int(11) NOT NULL,
- `facility_name` varchar(60) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_facility_room` (`room_id`),
- CONSTRAINT `fk_facility_room` FOREIGN KEY (`room_id`) REFERENCES `room` (`id`)
- )ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Records of Facility
- -- ----------------------------
- -- ----------------------------
- -- Table structure for user
- -- ----------------------------
- DROP TABLE IF EXISTS `user`;
- CREATE TABLE `user` (
- `id` varchar(32) NOT NULL,
- `password` varchar(32) NOT NULL,
- `role` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_user_role` (`role`),
- CONSTRAINT `fk_user_role` FOREIGN KEY (`role`) REFERENCES `role` (`role_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Records of user
- -- ----------------------------
- INSERT INTO `user` VALUES ('201801', '123', '2');
- INSERT INTO `user` VALUES ('admin', 'emadmin', '1');
- INSERT INTO `user` VALUES ('ordinary', '123456', '2');
- -- ----------------------------------------
- -- Table structure for roomauthority--会议室权限
- -- ----------------------------------------
- Drop TABLE IF EXISTS `room_authority`;
- CREATE Table `room_authority`(
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `room_id` int(11) NOT NULL,
- `user_id` varchar(32) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_authority_room` (`room_id`),
- CONSTRAINT `fk_authority_room` FOREIGN KEY (`room_id`) REFERENCES `room` (`id`),
- KEY `fk_authority_user` (user_id),
- CONSTRAINT `fk_authority_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
- )ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Records of roomauthority
- -- ----------------------------
|