/*
Navicat MySQL Data Transfer

Source Server         : mysql
Source Server Version : 50151
Source Host           : localhost:3306
Source Database       : dormitory

Target Server Type    : MYSQL
Target Server Version : 50151
File Encoding         : 65001

Date: 2020-05-04 13:15:48
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for c_contacts
-- ----------------------------
DROP TABLE IF EXISTS `c_contacts`;
CREATE TABLE `c_contacts` (
  `c_id` int(11) NOT NULL AUTO_INCREMENT,
  `c_phone` int(13) NOT NULL,
  `c_name` varchar(20) DEFAULT NULL,
  `c_sex` varchar(20) DEFAULT NULL,
  `c_age` varchar(20) DEFAULT NULL,
  `c_address` varchar(20) DEFAULT NULL,
  `c_subordinate` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`c_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of c_contacts
-- ----------------------------
INSERT INTO `c_contacts` VALUES ('1', '654378654', '黄华', '男', '54', '深圳', '小明');
INSERT INTO `c_contacts` VALUES ('8', '123456789', '张东', '男', '23', '珠海', '小红');

-- ----------------------------
-- Table structure for d_admin
-- ----------------------------
DROP TABLE IF EXISTS `d_admin`;
CREATE TABLE `d_admin` (
  `a_id` int(11) NOT NULL AUTO_INCREMENT,
  `a_username` varchar(20) NOT NULL,
  `a_password` varchar(50) NOT NULL,
  `a_name` varchar(20) DEFAULT NULL,
  `a_phone` bigint(20) DEFAULT NULL,
  `a_power` varchar(20) DEFAULT NULL,
  `a_describe` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`a_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of d_admin
-- ----------------------------
INSERT INTO `d_admin` VALUES ('1', 'zxk', '696E25FDACEE8106BC5232AFC69155D6', '周荀凯', '138138138', '1', '高');
INSERT INTO `d_admin` VALUES ('2', 'zj', '696E25FDACEE8106BC5232AFC69155D6', '张杰', '138138138', '2', '低');
INSERT INTO `d_admin` VALUES ('3', 'zh', '696E25FDACEE8106BC5232AFC69155D6', '张欢', '138138138', '1', '高');
INSERT INTO `d_admin` VALUES ('4', 'zk', '696E25FDACEE8106BC5232AFC69155D6', '赵凯', '138138138', '2', '低');
INSERT INTO `d_admin` VALUES ('5', 'ywj', '696E25FDACEE8106BC5232AFC69155D6', '杨雯雯', '138138138', '1', '高');
INSERT INTO `d_admin` VALUES ('6', 'wh', '696E25FDACEE8106BC5232AFC69155D6', '王皓', '138138138', '1', '高');
INSERT INTO `d_admin` VALUES ('7', 'zw', '696E25FDACEE8106BC5232AFC69155D6', '张伟', '138138138', '2', '低');
INSERT INTO `d_admin` VALUES ('8', 'zj', '696E25FDACEE8106BC5232AFC69155D6', '赵佳', '138138138', '2', '低');
INSERT INTO `d_admin` VALUES ('9', 'wf', '696E25FDACEE8106BC5232AFC69155D6', '王凡', '138138138', '1', '高');
INSERT INTO `d_admin` VALUES ('10', 'zn', '696E25FDACEE8106BC5232AFC69155D6', '张娜', '138138138', '1', '高');
INSERT INTO `d_admin` VALUES ('11', 'jzh', '696E25FDACEE8106BC5232AFC69155D6', '蒋子华', '138138138', '2', '低');
INSERT INTO `d_admin` VALUES ('12', 'xl', '696E25FDACEE8106BC5232AFC69155D6', '薛磊', '138138138', '2', '低');
INSERT INTO `d_admin` VALUES ('13', 'lkq', '723D505516E0C197E42A6BE3C0AF910E', '凌康乾', '176761696', '2', '高');

-- ----------------------------
-- Table structure for d_class
-- ----------------------------
DROP TABLE IF EXISTS `d_class`;
CREATE TABLE `d_class` (
  `c_id` int(11) NOT NULL AUTO_INCREMENT,
  `c_classid` int(11) NOT NULL,
  `c_classname` varchar(30) DEFAULT NULL,
  `c_counsellor` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`c_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of d_class
-- ----------------------------

-- ----------------------------
-- Table structure for d_client
-- ----------------------------
DROP TABLE IF EXISTS `d_client`;
CREATE TABLE `d_client` (
  `d_id` int(11) NOT NULL AUTO_INCREMENT,
  `d_phone` int(13) NOT NULL,
  `d_name` varchar(20) DEFAULT NULL,
  `d_sex` varchar(20) DEFAULT NULL,
  `d_age` varchar(20) DEFAULT NULL,
  `d_address` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`d_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of d_client
-- ----------------------------
INSERT INTO `d_client` VALUES ('1', '1232343523', '小明', '男', '61', '广东');
INSERT INTO `d_client` VALUES ('2', '1672442424', '小红', '女', '28', '北京');
INSERT INTO `d_client` VALUES ('3', '123456789', '小龙', '男', '32', '广州');

-- ----------------------------
-- Table structure for d_dormgrade
-- ----------------------------
DROP TABLE IF EXISTS `d_dormgrade`;
CREATE TABLE `d_dormgrade` (
  `g_id` int(11) NOT NULL AUTO_INCREMENT,
  `d_id` int(11) NOT NULL,
  `d_dormbuilding` varchar(20) DEFAULT NULL,
  `d_grade` int(11) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`g_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of d_dormgrade
-- ----------------------------
INSERT INTO `d_dormgrade` VALUES ('1', '301', '24号楼', '7', '2019-04-25 10:51:17', '2019-12-23 12:50:19');
INSERT INTO `d_dormgrade` VALUES ('2', '302', '24号楼', '7', '2019-05-01 16:36:47', '2019-05-01 16:36:55');
INSERT INTO `d_dormgrade` VALUES ('3', '322', '24号楼', '8', '2019-05-04 16:37:42', '2019-05-04 16:37:47');
INSERT INTO `d_dormgrade` VALUES ('4', '602', '23号楼', '7', '2019-05-08 16:38:25', '2019-05-08 16:38:30');
INSERT INTO `d_dormgrade` VALUES ('5', '112', '22号楼', '7', '2019-05-12 16:38:53', '2019-05-12 16:39:00');
INSERT INTO `d_dormgrade` VALUES ('6', '222', '27号楼', '9', '2019-05-09 16:39:37', '2019-05-09 16:39:41');
INSERT INTO `d_dormgrade` VALUES ('7', '213', '27号楼', '8', '2019-05-10 16:40:02', '2019-05-10 16:40:08');
INSERT INTO `d_dormgrade` VALUES ('8', '543', '24号楼', '6', '2020-02-22 13:39:31', '2020-02-22 13:39:31');

-- ----------------------------
-- Table structure for d_dormrepair
-- ----------------------------
DROP TABLE IF EXISTS `d_dormrepair`;
CREATE TABLE `d_dormrepair` (
  `r_id` int(11) NOT NULL AUTO_INCREMENT,
  `d_id` int(11) NOT NULL,
  `d_dormbuilding` varchar(20) NOT NULL,
  `r_name` varchar(20) DEFAULT NULL,
  `reason` varchar(50) DEFAULT NULL,
  `create_time` varchar(50) DEFAULT NULL,
  `update_time` varchar(50) DEFAULT NULL,
  `contact_id` int(11) NOT NULL,
  PRIMARY KEY (`r_id`),
  KEY `contact_id` (`contact_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of d_dormrepair
-- ----------------------------
INSERT INTO `d_dormrepair` VALUES ('5', '213', '27号楼', '冯军', '排风扇', '2019-05-18 16:32:54', '2019-05-14 16:33:00', '4');
INSERT INTO `d_dormrepair` VALUES ('6', '312', '26号楼', '彭建国', '空调', '2019-05-20 16:33:56', '2019-05-20 16:34:01', '1');
INSERT INTO `d_dormrepair` VALUES ('7', '123', '12321', '12312', '123213', '1', '2019-12-22 14:52:14', '1');

-- ----------------------------
-- Table structure for d_leavingschool
-- ----------------------------
DROP TABLE IF EXISTS `d_leavingschool`;
CREATE TABLE `d_leavingschool` (
  `k_id` int(11) NOT NULL AUTO_INCREMENT,
  `k_classid` int(11) NOT NULL,
  `k_username` varchar(50) DEFAULT NULL,
  `k_dormbuilding` varchar(50) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `k_reason` varchar(500) DEFAULT NULL,
  `k_valuables` varchar(300) DEFAULT NULL,
  PRIMARY KEY (`k_id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of d_leavingschool
-- ----------------------------
INSERT INTO `d_leavingschool` VALUES ('20', '1', '小帅龙', '520', '2019-12-23 12:20:58', '88', '100');
INSERT INTO `d_leavingschool` VALUES ('29', '2', 'QQQ', '45', '2019-12-23 12:22:54', '54566', '4865');

-- ----------------------------
-- Table structure for d_lreturn
-- ----------------------------
DROP TABLE IF EXISTS `d_lreturn`;
CREATE TABLE `d_lreturn` (
  `l_id` int(11) NOT NULL AUTO_INCREMENT,
  `l_lreturnnanme` varchar(255) DEFAULT NULL,
  `l_studentid` int(11) DEFAULT NULL,
  `l_dormitoryid` int(11) DEFAULT NULL,
  `night_time` datetime DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`l_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of d_lreturn
-- ----------------------------

-- ----------------------------
-- Table structure for d_stgrade
-- ----------------------------
DROP TABLE IF EXISTS `d_stgrade`;
CREATE TABLE `d_stgrade` (
  `g_id` int(11) NOT NULL AUTO_INCREMENT,
  `s_studentid` int(11) NOT NULL,
  `s_name` varchar(20) DEFAULT NULL,
  `s_grade` int(11) DEFAULT NULL,
  `s_classid` int(11) DEFAULT NULL,
  `s_dormitoryid` int(11) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`g_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of d_stgrade
-- ----------------------------
INSERT INTO `d_stgrade` VALUES ('1', '1413032001', '张杰', '6', '141', '301', '2019-04-26 09:56:51', '2019-04-26 11:02:13');
INSERT INTO `d_stgrade` VALUES ('2', '1413032002', '赵凯', '7', '141', '301', '2019-05-01 17:00:05', '2019-05-01 17:00:13');
INSERT INTO `d_stgrade` VALUES ('3', '1413032003', '许文文', '6', '141', '301', '2019-05-06 17:00:54', '2019-05-06 17:01:01');
INSERT INTO `d_stgrade` VALUES ('4', '1413032003', '许文文', '7', '141', '301', '2019-05-16 17:01:33', '2019-05-16 17:02:15');
INSERT INTO `d_stgrade` VALUES ('5', '1413032004', '王浩', '7', '141', '301', '2019-05-10 17:03:03', '2019-05-10 17:03:09');
INSERT INTO `d_stgrade` VALUES ('6', '1413032005', '张伟', '8', '141', '301', '2019-05-14 17:03:53', '2019-05-14 17:03:56');
INSERT INTO `d_stgrade` VALUES ('7', '1513112412', '赵跃', '9', '151', '112', '2019-05-08 17:05:04', '2019-05-08 17:05:07');
INSERT INTO `d_stgrade` VALUES ('8', '1513112412', '赵跃', '9', '151', '112', '2019-05-17 17:05:34', '2019-05-17 17:05:39');
INSERT INTO `d_stgrade` VALUES ('9', '1513122418', '田野', '8', '151', '213', '2019-05-15 17:06:28', '2019-05-15 17:06:35');
INSERT INTO `d_stgrade` VALUES ('10', '1513122419', '张嘉佳', '8', '151', '213', '2019-05-15 17:07:09', '2019-05-15 17:07:13');

-- ----------------------------
-- Table structure for d_student
-- ----------------------------
DROP TABLE IF EXISTS `d_student`;
CREATE TABLE `d_student` (
  `s_id` int(11) NOT NULL AUTO_INCREMENT,
  `s_studentid` int(11) NOT NULL,
  `s_name` varchar(20) DEFAULT NULL,
  `s_sex` varchar(20) DEFAULT NULL,
  `s_age` int(11) DEFAULT NULL,
  `s_phone` bigint(20) DEFAULT NULL,
  `s_classid` int(11) NOT NULL,
  `s_classname` varchar(20) DEFAULT NULL,
  `s_dormitoryid` int(11) NOT NULL,
  PRIMARY KEY (`s_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of d_student
-- ----------------------------
INSERT INTO `d_student` VALUES ('1', '1413032001', '张杰', '男', '22', '138138138', '141', '音乐', '301');
INSERT INTO `d_student` VALUES ('2', '1413032002', '林俊杰', '男', '22', '138138138', '141', '音乐', '301');
INSERT INTO `d_student` VALUES ('3', '1413032003', '于文文', '男', '21', '138138138', '141', '音乐', '301');
INSERT INTO `d_student` VALUES ('4', '1413032004', '张学友', '男', '22', '138138138', '141', '音乐', '301');
INSERT INTO `d_student` VALUES ('5', '1413032005', '张伟', '男', '22', '138138138', '141', '电影', '302');
INSERT INTO `d_student` VALUES ('6', '1413032006', '成龙', '男', '21', '138138138', '141', '电影', '302');
INSERT INTO `d_student` VALUES ('7', '1513112411', '吴京', '男', '20', '138138138', '151', '电影', '302');
INSERT INTO `d_student` VALUES ('8', '1513112412', '古力娜扎', '女', '21', '138138138', '151', '冲哈', '110');
INSERT INTO `d_student` VALUES ('9', '1513112413', '迪丽热巴', '女', '21', '138138138', '151', '明星的自我修养班', '111');
INSERT INTO `d_student` VALUES ('11', '1513122418', '罗志祥', '男', '21', '138138138', '153', '音乐电影', '112');
INSERT INTO `d_student` VALUES ('12', '1513122419', '林允儿', '女', '20', '138138138', '153', '明星的自我修养班', '111');
INSERT INTO `d_student` VALUES ('13', '1513122420', '乌鸦哥', '男', '21', '138138138', '153', '电影', '302');
INSERT INTO `d_student` VALUES ('14', '180113122', '凌康乾6666', '男', '18', '17676169', '3', '18IT专才3班', '423');

-- ----------------------------
-- Table structure for d_visitor
-- ----------------------------
DROP TABLE IF EXISTS `d_visitor`;
CREATE TABLE `d_visitor` (
  `v_id` int(11) NOT NULL AUTO_INCREMENT,
  `v_name` varchar(20) DEFAULT NULL,
  `v_phone` bigint(20) DEFAULT NULL,
  `v_dormitoryid` int(11) DEFAULT NULL,
  `v_dormbuilding` varchar(20) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`v_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of d_visitor
-- ----------------------------
INSERT INTO `d_visitor` VALUES ('1', '郑杰', '138138138', '301', '24号楼', '2019-05-14 13:26:13');
INSERT INTO `d_visitor` VALUES ('2', '李博', '138138138', '322', '24号楼', '2019-05-12 19:36:23');
INSERT INTO `d_visitor` VALUES ('3', '张盈盈', '138138138', '601', '23号楼', '2019-05-13 19:37:11');
INSERT INTO `d_visitor` VALUES ('4', '王涛', '138138138', '111', '22号楼', '2019-05-15 19:37:46');
INSERT INTO `d_visitor` VALUES ('5', '胡浩', '138138138', '222', '27号楼', '2019-05-16 19:38:27');
INSERT INTO `d_visitor` VALUES ('6', '陈昊', '138138138', '213', '27号楼', '2019-05-18 19:39:03');
INSERT INTO `d_visitor` VALUES ('7', '刘军', '138138138', '213', '27号楼', '2019-05-20 19:39:42');
INSERT INTO `d_visitor` VALUES ('8', '黄智', '138138138', '312', '26号楼', '2019-05-22 19:46:38');
INSERT INTO `d_visitor` VALUES ('9', '郑杰', '123123123', '311', '24号楼', '2019-05-16 16:59:06');