Navicat MySQL Data Transfer
Source Server : workplace
Source Server Version : 50610
Source Host : 127.0.0.1:3306
Source Database : dormdb
Target Server Type : MYSQL
Target Server Version : 50610
File Encoding : 65001
Date: 2019-08-13 10:29:35
*/
create database mydormdb;
use mydormdb;
SET FOREIGN_KEY_CHECKS=0;
-- Table structure for building
DROP TABLE IF EXISTS building;
CREATE TABLE building (buildId int(11) NOT NULL AUTO_INCREMENT,buildName varchar(30) DEFAULT NULL,dormCount int(11) DEFAULT NULL,dormFloor int(11) DEFAULT NULL,
PRIMARY KEY (buildId)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
-- Records of building
INSERT INTO building VALUES (‘1‘, ‘崇明楼（男）‘, ‘60‘, ‘1‘);
INSERT INTO building VALUES (‘2‘, ‘崇明楼（男）‘, ‘60‘, ‘2‘);
INSERT INTO building VALUES (‘3‘, ‘崇明楼（男）‘, ‘60‘, ‘3‘);
INSERT INTO building VALUES (‘4‘, ‘崇明楼（男）‘, ‘60‘, ‘4‘);
INSERT INTO building VALUES (‘5‘, ‘崇明楼（男）‘, ‘60‘, ‘5‘);
INSERT INTO building VALUES (‘6‘, ‘尚礼楼（女）‘, ‘50‘, ‘1‘);
INSERT INTO building VALUES (‘7‘, ‘尚礼楼（女）‘, ‘50‘, ‘2‘);
INSERT INTO building VALUES (‘8‘, ‘尚礼楼（女）‘, ‘50‘, ‘3‘);
INSERT INTO building VALUES (‘9‘, ‘尚礼楼（女）‘, ‘50‘, ‘4‘);
INSERT INTO building VALUES (‘10‘, ‘尚礼楼（女）‘, ‘50‘, ‘5‘);
INSERT INTO building VALUES (‘11‘, ‘崇明楼（男）‘, ‘60‘, ‘1‘);
-- Table structure for categroy
DROP TABLE IF EXISTS categroy;
CREATE TABLE categroy (categroyid int(11) NOT NULL AUTO_INCREMENT,categroyname varchar(20) NOT NULL,
PRIMARY KEY (categroyid)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- Records of categroy
INSERT INTO categroy VALUES (‘1‘, ‘饮料‘);
INSERT INTO categroy VALUES (‘2‘, ‘啤酒‘);
INSERT INTO categroy VALUES (‘3‘, ‘白酒‘);
INSERT INTO categroy VALUES (‘4‘, ‘小吃‘);
INSERT INTO categroy VALUES (‘5‘, ‘泡面‘);
-- Table structure for charge
DROP TABLE IF EXISTS charge;
CREATE TABLE charge (chargeId int(11) NOT NULL AUTO_INCREMENT,chargeDate datetime DEFAULT NULL,fk_typeId int(11) DEFAULT NULL,fk_stuId int(11) DEFAULT NULL,payMoney decimal(10,2) DEFAULT NULL,fk_teachId int(11) DEFAULT NULL,memo varchar(100) DEFAULT NULL,
PRIMARY KEY (chargeId),
KEY fk_typeId (fk_typeId),
KEY fk_stuId (fk_stuId),
KEY fk_teachId (fk_teachId),
CONSTRAINT charge_ibfk_1 FOREIGN KEY (fk_typeId) REFERENCES chargetype (typeid),
CONSTRAINT charge_ibfk_2 FOREIGN KEY (fk_stuId) REFERENCES student (stuId),
CONSTRAINT charge_ibfk_3 FOREIGN KEY (fk_teachId) REFERENCES teacher (teachId)
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8;
-- Records of charge
INSERT INTO charge VALUES (‘1‘, ‘2019-04-17 19:22:02‘, ‘1‘, ‘1‘, ‘434.00‘, ‘2‘, ‘无‘);
INSERT INTO charge VALUES (‘3‘, ‘2019-04-18 08:52:52‘, ‘1‘, ‘23‘, ‘700.00‘, ‘2‘, ‘无‘);
INSERT INTO charge VALUES (‘5‘, ‘2019-04-18 09:38:49‘, ‘1‘, ‘24‘, ‘22222.00‘, ‘2‘, ‘‘);
INSERT INTO charge VALUES (‘6‘, ‘2019-04-18 09:56:37‘, ‘1‘, ‘25‘, ‘23324.00‘, ‘2‘, ‘‘);
INSERT INTO charge VALUES (‘9‘, ‘2019-04-18 10:14:01‘, ‘1‘, ‘26‘, ‘3.00‘, ‘2‘, ‘无‘);
INSERT INTO charge VALUES (‘11‘, ‘2019-04-18 10:32:33‘, ‘1‘, ‘27‘, ‘0.00‘, ‘3‘, ‘无‘);
INSERT INTO charge VALUES (‘13‘, ‘2019-04-19 11:30:51‘, ‘1‘, ‘3‘, ‘800.00‘, ‘2‘, ‘无‘);
INSERT INTO charge VALUES (‘14‘, ‘2019-04-19 11:31:23‘, ‘3‘, ‘9‘, ‘888.00‘, ‘2‘, ‘‘);
INSERT INTO charge VALUES (‘15‘, ‘2019-04-19 11:31:31‘, ‘2‘, ‘11‘, ‘888.00‘, ‘2‘, ‘‘);
INSERT INTO charge VALUES (‘16‘, ‘2019-04-19 11:31:44‘, ‘3‘, ‘14‘, ‘899.00‘, ‘2‘, ‘‘);
INSERT INTO charge VALUES (‘17‘, ‘2019-04-19 11:31:51‘, ‘1‘, ‘15‘, ‘888.00‘, ‘2‘, ‘‘);
INSERT INTO charge VALUES (‘20‘, ‘2019-04-19 11:56:10‘, ‘1‘, ‘9‘, ‘8888.00‘, ‘2‘, ‘‘);
INSERT INTO charge VALUES (‘27‘, ‘2019-04-19 12:47:02‘, ‘1‘, ‘16‘, ‘7777.00‘, ‘2‘, ‘‘);
INSERT INTO charge VALUES (‘29‘, ‘2019-04-19 14:36:00‘, ‘2‘, ‘17‘, ‘800.00‘, ‘2‘, ‘无‘);
INSERT INTO charge VALUES (‘31‘, ‘2019-04-20 10:52:37‘, ‘3‘, ‘6‘, ‘800.00‘, ‘3‘, ‘无‘);
INSERT INTO charge VALUES (‘32‘, ‘2019-04-20 16:02:02‘, ‘2‘, ‘18‘, ‘800.00‘, ‘2‘, ‘无‘);
INSERT INTO charge VALUES (‘33‘, ‘2019-04-20 16:02:09‘, ‘1‘, ‘19‘, ‘2222.00‘, ‘2‘, ‘‘);
INSERT INTO charge VALUES (‘34‘, ‘2019-04-20 16:02:16‘, ‘1‘, ‘20‘, ‘999.00‘, ‘2‘, ‘‘);
INSERT INTO charge VALUES (‘35‘, ‘2019-04-20 16:09:52‘, ‘1‘, ‘23‘, ‘800.00‘, ‘2‘, ‘无‘);
INSERT INTO charge VALUES (‘36‘, ‘2019-04-20 16:57:54‘, ‘1‘, ‘2‘, ‘800.00‘, ‘1‘, ‘无‘);
INSERT INTO charge VALUES (‘37‘, ‘2019-04-20 16:58:10‘, ‘1‘, ‘7‘, ‘2000.00‘, ‘1‘, ‘‘);
INSERT INTO charge VALUES (‘39‘, ‘2019-04-20 17:42:29‘, ‘2‘, ‘24‘, ‘2332.00‘, ‘2‘, ‘‘);
INSERT INTO charge VALUES (‘46‘, ‘2019-04-20 19:43:04‘, ‘1‘, ‘25‘, ‘800.00‘, ‘2‘, ‘无‘);
INSERT INTO charge VALUES (‘48‘, ‘2019-04-20 19:45:35‘, ‘1‘, ‘8‘, ‘800.00‘, ‘1‘, ‘无‘);
INSERT INTO charge VALUES (‘49‘, ‘2019-04-20 19:46:39‘, ‘2‘, ‘5‘, ‘800.00‘, ‘3‘, ‘无‘);
INSERT INTO charge VALUES (‘50‘, ‘2019-04-20 19:53:46‘, ‘1‘, ‘10‘, ‘800.00‘, ‘3‘, ‘无‘);
INSERT INTO charge VALUES (‘51‘, ‘2019-04-20 19:55:33‘, ‘1‘, ‘4‘, ‘800.00‘, ‘1‘, ‘无‘);
INSERT INTO charge VALUES (‘52‘, ‘2019-04-20 19:57:35‘, ‘2‘, ‘12‘, ‘700.00‘, ‘3‘, ‘无‘);
INSERT INTO charge VALUES (‘53‘, ‘2019-04-20 19:58:47‘, ‘4‘, ‘13‘, ‘600.00‘, ‘3‘, ‘无‘);
INSERT INTO charge VALUES (‘54‘, ‘2019-04-20 19:59:56‘, ‘1‘, ‘14‘, ‘0.00‘, ‘2‘, ‘无‘);
INSERT INTO charge VALUES (‘55‘, ‘2019-04-21 14:51:06‘, ‘1‘, ‘28‘, ‘800.00‘, ‘2‘, ‘无‘);
INSERT INTO charge VALUES (‘56‘, ‘2019-04-21 16:34:48‘, ‘1‘, ‘22‘, ‘800.00‘, ‘3‘, ‘无‘);
INSERT INTO charge VALUES (‘57‘, ‘2019-04-21 16:35:33‘, ‘1‘, ‘29‘, ‘900.00‘, ‘5‘, ‘‘);
INSERT INTO charge VALUES (‘58‘, ‘2019-04-21 16:35:55‘, ‘1‘, ‘30‘, ‘800.00‘, ‘5‘, ‘无‘);
INSERT INTO charge VALUES (‘60‘, ‘2019-04-21 16:41:17‘, ‘1‘, ‘21‘, ‘800.00‘, ‘3‘, ‘无‘);
INSERT INTO charge VALUES (‘61‘, ‘2019-04-21 18:54:46‘, ‘1‘, ‘27‘, ‘800.00‘, ‘2‘, ‘无‘);
INSERT INTO charge VALUES (‘64‘, ‘2019-04-22 13:09:19‘, ‘1‘, ‘26‘, ‘800.00‘, ‘1‘, ‘无‘);
INSERT INTO charge VALUES (‘65‘, ‘2019-04-22 13:09:38‘, ‘1‘, ‘31‘, ‘800.00‘, ‘2‘, ‘‘);
INSERT INTO charge VALUES (‘72‘, ‘2019-04-23 09:39:47‘, ‘1‘, ‘3‘, ‘800.00‘, ‘1‘, ‘无‘);
INSERT INTO charge VALUES (‘73‘, ‘2019-04-23 09:40:03‘, ‘1‘, ‘16‘, ‘800.00‘, ‘1‘, ‘无‘);
INSERT INTO charge VALUES (‘74‘, ‘2019-04-23 09:40:17‘, ‘1‘, ‘18‘, ‘800.00‘, ‘1‘, ‘无‘);
INSERT INTO charge VALUES (‘75‘, ‘2019-04-23 09:40:30‘, ‘1‘, ‘19‘, ‘800.00‘, ‘1‘, ‘无‘);
INSERT INTO charge VALUES (‘76‘, ‘2019-04-23 09:40:39‘, ‘1‘, ‘20‘, ‘800.00‘, ‘1‘, ‘无‘);
INSERT INTO charge VALUES (‘77‘, ‘2019-04-23 09:40:50‘, ‘1‘, ‘23‘, ‘700.00‘, ‘1‘, ‘无‘);
INSERT INTO charge VALUES (‘78‘, ‘2019-04-23 09:41:01‘, ‘1‘, ‘24‘, ‘700.00‘, ‘1‘, ‘无‘);
INSERT INTO charge VALUES (‘83‘, ‘2019-04-23 10:31:10‘, ‘1‘, ‘3‘, ‘0.00‘, ‘1‘, ‘无‘);
INSERT INTO charge VALUES (‘84‘, ‘2019-04-27 15:01:10‘, ‘2‘, ‘33‘, ‘800.00‘, ‘5‘, ‘无‘);
INSERT INTO charge VALUES (‘85‘, ‘2019-04-27 15:05:48‘, ‘1‘, ‘33‘, ‘0.00‘, ‘5‘, ‘无‘);
-- Table structure for chargetype
DROP TABLE IF EXISTS chargetype;
CREATE TABLE chargetype (typeid int(11) NOT NULL AUTO_INCREMENT,typeName varchar(20) DEFAULT NULL,unitPrice decimal(18,2) DEFAULT NULL,flag int(11) DEFAULT NULL,memo varchar(100) DEFAULT NULL,
PRIMARY KEY (typeid)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
-- Records of chargetype
INSERT INTO chargetype VALUES (‘1‘, ‘微信‘, ‘50.00‘, ‘1‘, ‘无‘);
INSERT INTO chargetype VALUES (‘2‘, ‘支付宝‘, ‘50.00‘, ‘1‘, ‘无‘);
INSERT INTO chargetype VALUES (‘3‘, ‘银行卡‘, ‘50.00‘, ‘1‘, ‘无‘);
INSERT INTO chargetype VALUES (‘4‘, ‘现金‘, ‘50.00‘, ‘1‘, ‘无‘);
-- Table structure for classinfo
DROP TABLE IF EXISTS classinfo;
CREATE TABLE classinfo (classId int(11) NOT NULL AUTO_INCREMENT,className varchar(20) DEFAULT NULL,fk_teachId int(11) DEFAULT NULL,createDate datetime DEFAULT NULL,endDate datetime DEFAULT NULL,flag int(11) DEFAULT NULL,memo varchar(100) DEFAULT NULL,
PRIMARY KEY (classId),
KEY fk_teachId (fk_teachId),
CONSTRAINT classinfo_ibfk_1 FOREIGN KEY (fk_teachId) REFERENCES teacher (teachId)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
-- Records of classinfo
INSERT INTO classinfo VALUES (‘1‘, ‘A126‘, ‘1‘, ‘2019-04-12 16:10:41‘, null, ‘1‘, ‘无‘);
INSERT INTO classinfo VALUES (‘2‘, ‘A127‘, ‘2‘, ‘2019-04-12 16:11:07‘, null, ‘1‘, ‘无‘);
INSERT INTO classinfo VALUES (‘3‘, ‘A128‘, ‘5‘, ‘2019-04-12 16:11:32‘, null, ‘1‘, ‘无‘);
INSERT INTO classinfo VALUES (‘4‘, ‘A129‘, ‘2‘, ‘2019-04-12 16:11:49‘, null, ‘1‘, ‘无‘);
INSERT INTO classinfo VALUES (‘5‘, ‘A130‘, ‘6‘, ‘2019-04-21 10:48:55‘, null, ‘1‘, null);
INSERT INTO classinfo VALUES (‘6‘, ‘A139‘, ‘5‘, ‘2019-04-27 14:56:14‘, null, ‘1‘, null);
-- Table structure for dorm
DROP TABLE IF EXISTS dorm;
CREATE TABLE dorm (dormId int(11) NOT NULL AUTO_INCREMENT,dormNum varchar(10) DEFAULT NULL,fk_typeId int(11) DEFAULT NULL,fk_buildid int(11) DEFAULT NULL,personCount int(11) DEFAULT NULL,flag int(11) DEFAULT NULL,memo varchar(100) DEFAULT NULL,
PRIMARY KEY (dormId),
KEY fk_typeId (fk_typeId),
KEY fk_buildid (fk_buildid),
CONSTRAINT dorm_ibfk_1 FOREIGN KEY (fk_typeId) REFERENCES dormtype (typeId),
CONSTRAINT dorm_ibfk_2 FOREIGN KEY (fk_buildid) REFERENCES building (buildId)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
-- Records of dorm
INSERT INTO dorm VALUES (‘1‘, ‘1001‘, ‘1‘, ‘1‘, ‘4‘, ‘2‘, ‘无‘);
INSERT INTO dorm VALUES (‘2‘, ‘1002‘, ‘1‘, ‘1‘, ‘3‘, ‘1‘, ‘无‘);
INSERT INTO dorm VALUES (‘3‘, ‘1003‘, ‘1‘, ‘1‘, ‘2‘, ‘1‘, ‘无‘);
INSERT INTO dorm VALUES (‘4‘, ‘1004‘, ‘1‘, ‘1‘, ‘2‘, ‘1‘, ‘无‘);
INSERT INTO dorm VALUES (‘5‘, ‘1005‘, ‘1‘, ‘1‘, ‘4‘, ‘2‘, ‘无‘);
INSERT INTO dorm VALUES (‘6‘, ‘1006‘, ‘1‘, ‘1‘, ‘2‘, ‘1‘, ‘无‘);
INSERT INTO dorm VALUES (‘7‘, ‘1007‘, ‘2‘, ‘4‘, ‘2‘, ‘1‘, ‘无‘);
INSERT INTO dorm VALUES (‘9‘, ‘1009‘, ‘3‘, ‘2‘, ‘1‘, ‘1‘, ‘无‘);
INSERT INTO dorm VALUES (‘10‘, ‘1010‘, ‘3‘, ‘2‘, ‘1‘, ‘1‘, ‘无‘);
INSERT INTO dorm VALUES (‘11‘, ‘1011‘, ‘3‘, ‘1‘, ‘0‘, ‘1‘, ‘无‘);
INSERT INTO dorm VALUES (‘12‘, ‘1012‘, ‘3‘, ‘1‘, ‘0‘, ‘1‘, ‘无‘);
INSERT INTO dorm VALUES (‘13‘, ‘1001‘, ‘1‘, ‘1‘, ‘0‘, ‘1‘, ‘无‘);
INSERT INTO dorm VALUES (‘14‘, ‘1002‘, ‘1‘, ‘1‘, ‘4‘, ‘2‘, ‘无‘);
INSERT INTO dorm VALUES (‘15‘, ‘1003‘, ‘4‘, ‘10‘, ‘3‘, ‘1‘, ‘无‘);
INSERT INTO dorm VALUES (‘16‘, ‘1004‘, ‘4‘, ‘9‘, ‘2‘, ‘1‘, ‘无‘);
INSERT INTO dorm VALUES (‘17‘, ‘1005‘, ‘5‘, ‘8‘, ‘1‘, ‘1‘, ‘无‘);
INSERT INTO dorm VALUES (‘18‘, ‘1006‘, ‘5‘, ‘7‘, ‘0‘, ‘1‘, ‘无‘);
INSERT INTO dorm VALUES (‘19‘, ‘1007‘, ‘5‘, ‘6‘, ‘0‘, ‘1‘, ‘无‘);
INSERT INTO dorm VALUES (‘20‘, ‘1008‘, ‘5‘, ‘9‘, ‘0‘, ‘1‘, ‘无‘);
INSERT INTO dorm VALUES (‘21‘, ‘1009‘, ‘6‘, ‘10‘, ‘0‘, ‘1‘, ‘无‘);
INSERT INTO dorm VALUES (‘22‘, ‘1010‘, ‘6‘, ‘6‘, ‘0‘, ‘1‘, ‘无‘);
INSERT INTO dorm VALUES (‘23‘, ‘1011‘, ‘6‘, ‘8‘, ‘0‘, ‘1‘, ‘无‘);
INSERT INTO dorm VALUES (‘24‘, ‘1012‘, ‘6‘, ‘7‘, ‘0‘, ‘1‘, ‘无‘);
INSERT INTO dorm VALUES (‘25‘, ‘1020‘, ‘7‘, ‘11‘, ‘0‘, ‘1‘, null);
INSERT INTO dorm VALUES (‘26‘, ‘0020‘, ‘7‘, ‘1‘, ‘0‘, ‘1‘, null);
-- Table structure for dormtype
DROP TABLE IF EXISTS dormtype;
CREATE TABLE dormtype (typeId int(11) NOT NULL AUTO_INCREMENT,typeName varchar(20) DEFAULT NULL,personCount int(11) DEFAULT NULL,price decimal(8,2) DEFAULT NULL,flag int(11) DEFAULT NULL,sex char(2) DEFAULT NULL,memeo varchar(50) DEFAULT NULL,
PRIMARY KEY (typeId)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
-- Records of dormtype
INSERT INTO dormtype VALUES (‘1‘, ‘四人间（男）‘, ‘4‘, ‘800.00‘, ‘1‘, ‘男‘, ‘无‘);
INSERT INTO dormtype VALUES (‘2‘, ‘六人间（男）‘, ‘6‘, ‘700.00‘, ‘1‘, ‘男‘, ‘无‘);
INSERT INTO dormtype VALUES (‘3‘, ‘八人间（男）‘, ‘8‘, ‘600.00‘, ‘1‘, ‘男‘, ‘无‘);
INSERT INTO dormtype VALUES (‘4‘, ‘四人间（女）‘, ‘4‘, ‘800.00‘, ‘1‘, ‘女‘, ‘无‘);
INSERT INTO dormtype VALUES (‘5‘, ‘六人间（女）‘, ‘6‘, ‘700.00‘, ‘1‘, ‘女‘, ‘无‘);
INSERT INTO dormtype VALUES (‘6‘, ‘八人间（女）‘, ‘8‘, ‘600.00‘, ‘1‘, ‘女‘, ‘无‘);
INSERT INTO dormtype VALUES (‘7‘, ‘七人间（男）‘, ‘7‘, ‘650.00‘, ‘1‘, ‘男‘, ‘‘);
-- Table structure for good
DROP TABLE IF EXISTS good;
CREATE TABLE good (goodid int(11) NOT NULL AUTO_INCREMENT,goodname varchar(20) NOT NULL,goodprice decimal(5,2) DEFAULT NULL,goodaddress varchar(20) DEFAULT NULL,goodtime date DEFAULT NULL,count int(20) DEFAULT ‘0‘,categroyid int(11) DEFAULT NULL,remark varchar(20) DEFAULT NULL,
PRIMARY KEY (goodid),
KEY category_good_id (categroyid),
CONSTRAINT category_good_id FOREIGN KEY (categroyid) REFERENCES categroy (categroyid)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
-- Records of good
INSERT INTO good VALUES (‘1‘, ‘雪碧‘, ‘10.00‘, ‘北京朝阳区‘, ‘2019-04-02‘, ‘26‘, ‘1‘, ‘‘);
INSERT INTO good VALUES (‘2‘, ‘可乐‘, ‘15.00‘, ‘上海‘, ‘2019-03-02‘, ‘16‘, ‘1‘, ‘‘);
INSERT INTO good VALUES (‘3‘, ‘青稞‘, ‘45.00‘, ‘山西‘, ‘2019-03-06‘, ‘98‘, ‘3‘, ‘‘);
INSERT INTO good VALUES (‘4‘, ‘江小白‘, ‘45.00‘, ‘山东青岛‘, ‘2019-02-02‘, ‘67‘, ‘3‘, ‘‘);
INSERT INTO good VALUES (‘5‘, ‘红烧牛肉面‘, ‘6.00‘, ‘山东威海‘, ‘2019-03-07‘, ‘77‘, ‘5‘, ‘‘);
INSERT INTO good VALUES (‘6‘, ‘老坛酸菜牛肉面‘, ‘10.00‘, ‘江苏‘, ‘2019-04-01‘, ‘68‘, ‘5‘, ‘‘);
INSERT INTO good VALUES (‘7‘, ‘青岛‘, ‘6.00‘, ‘甘肃‘, ‘2019-04-01‘, ‘98‘, ‘2‘, ‘一瓶6元,一箱70元‘);
INSERT INTO good VALUES (‘8‘, ‘崂山‘, ‘4.00‘, ‘陕北‘, ‘2019-03-07‘, ‘76‘, ‘2‘, ‘一瓶4元,一箱45元‘);
INSERT INTO good VALUES (‘9‘, ‘可比克‘, ‘8.00‘, ‘河北‘, ‘2019-04-02‘, ‘99‘, ‘4‘, ‘‘);
INSERT INTO good VALUES (‘10‘, ‘面包‘, ‘7.00‘, ‘北京朝阳区‘, ‘2019-04-02‘, ‘80‘, ‘4‘, ‘‘);
INSERT INTO good VALUES (‘11‘, ‘乐虎‘, ‘15.00‘, ‘北京朝阳区‘, ‘2019-02-04‘, ‘89‘, ‘1‘, ‘‘);
INSERT INTO good VALUES (‘12‘, ‘薯片‘, ‘10.00‘, ‘北京朝阳区‘, ‘2019-02-04‘, ‘77‘, ‘4‘, ‘‘);
-- Table structure for student
DROP TABLE IF EXISTS student;
CREATE TABLE student (stuId int(11) NOT NULL AUTO_INCREMENT,stuNum varchar(30) DEFAULT NULL,stuName varchar(20) DEFAULT NULL,stuUserName varchar(20) DEFAULT NULL,stuPass varchar(20) DEFAULT NULL,sex varchar(2) DEFAULT NULL,birthday datetime DEFAULT NULL,cardId varchar(20) DEFAULT NULL,fk_classId int(11) DEFAULT NULL,tel varchar(20) DEFAULT NULL,province varchar(20) DEFAULT NULL,city varchar(20) DEFAULT NULL,inDate datetime DEFAULT NULL,outDate datetime DEFAULT NULL,dormEndDate datetime DEFAULT NULL,fk_dormId int(11) DEFAULT NULL,flag int(11) DEFAULT NULL,memo varchar(100) DEFAULT NULL,
PRIMARY KEY (stuId),
KEY fk_classId (fk_classId),
KEY fk_dormId (fk_dormId),
CONSTRAINT student_ibfk_1 FOREIGN KEY (fk_classId) REFERENCES classinfo (classId),
CONSTRAINT student_ibfk_2 FOREIGN KEY (fk_dormId) REFERENCES dorm (dormId)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;
-- Records of student
INSERT INTO student VALUES (‘1‘, ‘20181‘, ‘任子方‘, ‘20181‘, ‘20180000‘, ‘男‘, ‘2000-05-07 16:10:05‘, ‘410423200005072513‘, ‘1‘, ‘15938992150‘, ‘河南‘, ‘平顶山‘, ‘2018-08-12 00:00:00‘, null, null, ‘5‘, ‘1‘, ‘‘);
INSERT INTO student VALUES (‘2‘, ‘20182‘, ‘行政‘, ‘20182‘, ‘20180000‘, ‘男‘, ‘2000-06-12 16:16:20‘, ‘410423200005072222‘, ‘2‘, ‘15938994578‘, ‘河南‘, ‘郑州‘, ‘2018-08-16 16:17:09‘, null, null, ‘3‘, ‘1‘, ‘无‘);
INSERT INTO student VALUES (‘3‘, ‘20183‘, ‘赵闯‘, ‘20183‘, ‘201800000‘, ‘男‘, ‘2000-06-19 16:16:20‘, ‘410423200005073333‘, ‘1‘, ‘15938975842‘, ‘河南‘, ‘洛阳‘, ‘2018-08-14 16:17:09‘, null, null, ‘1‘, ‘1‘, ‘‘);
INSERT INTO student VALUES (‘4‘, ‘20184‘, ‘晁明阳‘, ‘20184‘, ‘20180000‘, ‘男‘, ‘2000-06-12 16:16:20‘, ‘410423200005079999‘, ‘1‘, ‘11593897657‘, ‘河南‘, ‘洛阳‘, ‘2019-04-13 11:33:09‘, null, null, ‘5‘, ‘1‘, ‘‘);
INSERT INTO student VALUES (‘5‘, ‘20185‘, ‘邓慧敏‘, ‘20185‘, ‘20180000‘, ‘女‘, ‘2000-06-12 16:16:20‘, ‘410423200005079999‘, ‘3‘, ‘11593897654‘, ‘河南‘, ‘洛阳‘, ‘2019-04-13 00:00:00‘, null, null, ‘15‘, ‘1‘, ‘‘);
INSERT INTO student VALUES (‘6‘, ‘20186‘, ‘王萍‘, ‘20186‘, ‘20180000‘, ‘女‘, ‘2019-04-11 01:04:03‘, ‘410423200005076666‘, ‘2‘, ‘15938995472‘, ‘河南‘, ‘安阳‘, ‘2019-04-13 11:41:38‘, null, null, ‘15‘, ‘1‘, ‘白富美‘);
INSERT INTO student VALUES (‘7‘, ‘20187‘, ‘朱明慧‘, ‘20187‘, ‘20180000‘, ‘女‘, ‘2019-04-20 01:04:16‘, ‘410423200005076669‘, ‘2‘, ‘15934861254‘, ‘河南‘, ‘新乡‘, ‘2019-04-13 11:45:21‘, null, null, ‘14‘, ‘1‘, ‘白富美‘);
INSERT INTO student VALUES (‘8‘, ‘20188‘, ‘代俊强‘, ‘20188‘, ‘20180000‘, ‘男‘, ‘2019-04-16 01:04:07‘, ‘410423200005074569‘, ‘2‘, ‘15596687464‘, ‘河南‘, ‘驻马店‘, ‘2019-04-13 11:49:02‘, null, null, ‘4‘, ‘1‘, ‘高富帅‘);
INSERT INTO student VALUES (‘9‘, ‘20189‘, ‘陈慧慧‘, ‘20189‘, ‘20180000‘, ‘女‘, ‘0001-01-01 00:00:00‘, ‘410423200005077775‘, ‘2‘, ‘15934589786‘, ‘河南‘, ‘三门峡‘, ‘2019-04-13 12:06:10‘, null, null, ‘14‘, ‘1‘, ‘白富美‘);
INSERT INTO student VALUES (‘10‘, ‘201810‘, ‘孟嘉怡‘, ‘201810‘, ‘20180000‘, ‘女‘, ‘2019-04-13 01:04:21‘, ‘410423200005077772‘, ‘3‘, ‘15927561558‘, ‘河南‘, ‘三门峡‘, ‘2019-04-13 12:07:47‘, null, null, ‘15‘, ‘1‘, ‘白富美‘);
INSERT INTO student VALUES (‘11‘, ‘201811‘, ‘宋月月‘, ‘201811‘, ‘20180000‘, ‘女‘, ‘2019-04-02 01:03:53‘, ‘410423200000504564‘, ‘1‘, ‘15896798685‘, ‘河南‘, ‘洛阳‘, ‘2019-04-13 12:12:12‘, null, null, ‘14‘, ‘1‘, ‘白富美‘);
INSERT INTO student VALUES (‘12‘, ‘201812‘, ‘王宇慧‘, ‘201812‘, ‘20180000‘, ‘女‘, ‘2019-04-02 01:05:16‘, ‘410423200005071883‘, ‘4‘, ‘15938992514‘, ‘河南‘, ‘周口‘, ‘2019-04-13 12:16:02‘, null, null, ‘17‘, ‘1‘, ‘白富美‘);
INSERT INTO student VALUES (‘13‘, ‘201813‘, ‘党齐飞‘, ‘201813‘, ‘20180000‘, ‘男‘, ‘2019-04-04 01:05:21‘, ‘410423200005075247‘, ‘4‘, ‘15972867926‘, ‘河南‘, ‘开封‘, ‘2019-04-13 12:19:03‘, null, null, ‘9‘, ‘1‘, ‘‘);
INSERT INTO student VALUES (‘14‘, ‘201814‘, ‘杨超超‘, ‘201814‘, ‘20180000‘, ‘男‘, ‘2019-04-03 01:05:26‘, ‘410423200005079247‘, ‘1‘, ‘15895485256‘, ‘河南‘, ‘南阳‘, ‘2019-04-13 12:20:52‘, null, null, ‘4‘, ‘1‘, ‘‘);
INSERT INTO student VALUES (‘15‘, ‘201815‘, ‘185‘, ‘201815‘, ‘20180000‘, ‘男‘, ‘2000-06-12 16:16:20‘, ‘410423200005079515‘, ‘3‘, ‘15958944854‘, ‘河南‘, ‘平顶山‘, ‘2019-04-13 12:22:07‘, null, null, ‘1‘, ‘1‘, ‘‘);
INSERT INTO student VALUES (‘16‘, ‘201816‘, ‘王俊杰‘, ‘201816‘, ‘20180000‘, ‘男‘, ‘2000-06-12 16:16:20‘, ‘410423200005072549‘, ‘1‘, ‘15498694234‘, ‘河南‘, ‘平顶山‘, ‘2019-04-13 12:27:33‘, null, null, ‘1‘, ‘1‘, ‘‘);
INSERT INTO student VALUES (‘17‘, ‘201817‘, ‘郭梦怡‘, ‘201817‘, ‘20180000‘, ‘女‘, ‘2000-06-12 16:16:20‘, ‘410423200005072513‘, ‘1‘, ‘15938992150‘, ‘河南‘, ‘新乡‘, ‘2019-04-13 17:25:14‘, null, null, ‘14‘, ‘1‘, ‘白富美‘);
INSERT INTO student VALUES (‘18‘, ‘201818‘, ‘赵嘉诚‘, ‘201818‘, ‘20180000‘, ‘男‘, ‘2019-04-13 00:00:00‘, ‘410423200008057216‘, ‘1‘, ‘15938917527‘, ‘浙江‘, ‘杭州‘, ‘2019-04-13 17:48:12‘, null, null, ‘2‘, ‘1‘, ‘‘);
INSERT INTO student VALUES (‘19‘, ‘201819‘, ‘宋浩‘, ‘201819‘, ‘20180000‘, ‘男‘, ‘2019-04-13 00:00:00‘, ‘410423200004054827‘, ‘1‘, ‘15975782785‘, ‘浙江‘, ‘杭州‘, ‘2019-04-13 22:21:38‘, null, null, ‘2‘, ‘1‘, ‘527颜值担当‘);
INSERT INTO student VALUES (‘20‘, ‘201820‘, ‘张争光‘, ‘201820‘, ‘20180000‘, ‘男‘, ‘2019-04-02 00:58:26‘, ‘410423200005075489‘, ‘1‘, ‘15938942727‘, ‘浙江‘, ‘宁波‘, ‘2019-04-04 01:02:37‘, null, null, ‘5‘, ‘1‘, null);
INSERT INTO student VALUES (‘21‘, ‘201821‘, ‘吕云龙‘, ‘201821‘, ‘20180000‘, ‘男‘, ‘2019-04-10 01:03:43‘, ‘410423200005073549‘, ‘4‘, ‘15938992159‘, ‘浙江‘, ‘嘉兴‘, ‘2019-04-11 01:07:01‘, null, null, ‘2‘, ‘1‘, null);
INSERT INTO student VALUES (‘22‘, ‘201822‘, ‘吴旺‘, ‘201822‘, ‘20180000‘, ‘男‘, ‘2000-06-16 00:00:00‘, ‘410423200005079874‘, ‘3‘, ‘15975896248‘, ‘浙江‘, ‘绍兴‘, ‘2019-04-16 11:13:42‘, null, null, ‘1‘, ‘1‘, ‘高富帅‘);
INSERT INTO student VALUES (‘23‘, ‘12323‘, ‘孟令辉‘, ‘12323‘, ‘000000‘, ‘男‘, ‘2019-04-18 00:00:00‘, ‘‘, ‘1‘, ‘‘, ‘‘, ‘‘, ‘2019-04-18 08:51:50‘, null, null, ‘7‘, ‘1‘, ‘‘);
INSERT INTO student VALUES (‘24‘, ‘12324‘, ‘王驰‘, ‘12324‘, ‘000000‘, ‘男‘, ‘2019-04-18 00:00:00‘, ‘‘, ‘1‘, ‘‘, ‘‘, ‘‘, ‘2019-04-18 09:37:59‘, null, null, ‘7‘, ‘1‘, ‘‘);
INSERT INTO student VALUES (‘25‘, ‘12325‘, ‘王震‘, ‘12325‘, ‘000000‘, ‘男‘, ‘2019-04-18 00:00:00‘, ‘‘, ‘1‘, ‘‘, ‘‘, ‘‘, ‘2019-04-18 09:55:50‘, null, null, ‘5‘, ‘1‘, ‘‘);
INSERT INTO student VALUES (‘26‘, ‘12326‘, ‘ooo‘, ‘12326‘, ‘000000‘, ‘男‘, ‘2019-04-18 00:00:00‘, ‘‘, ‘1‘, ‘‘, ‘‘, ‘‘, ‘2019-04-18 10:12:09‘, null, null, ‘6‘, ‘1‘, ‘‘);
INSERT INTO student VALUES (‘27‘, ‘12327‘, ‘孙占山‘, ‘12327‘, ‘000000‘, ‘男‘, ‘2019-04-18 00:00:00‘, ‘‘, ‘2‘, ‘‘, ‘‘, ‘‘, ‘2019-04-18 10:30:57‘, null, null, ‘3‘, ‘1‘, ‘‘);
INSERT INTO student VALUES (‘28‘, ‘12328‘, ‘王允‘, ‘12328‘, ‘000000‘, ‘女‘, ‘2019-04-21 00:00:00‘, ‘‘, ‘1‘, ‘‘, ‘‘, ‘‘, ‘2019-04-21 14:45:49‘, null, null, ‘16‘, ‘1‘, ‘‘);
INSERT INTO student VALUES (‘29‘, ‘12329‘, ‘孙占山‘, ‘12329‘, ‘000000‘, ‘男‘, ‘2013-02-14 00:00:00‘, ‘‘, ‘5‘, ‘‘, ‘‘, ‘‘, ‘2019-04-21 15:37:55‘, null, null, ‘6‘, ‘1‘, ‘‘);
INSERT INTO student VALUES (‘30‘, ‘12330‘, ‘小朱朱‘, ‘12330‘, ‘000000‘, ‘女‘, ‘2019-04-21 00:00:00‘, ‘‘, ‘5‘, ‘‘, ‘‘, ‘‘, ‘2019-04-21 15:56:39‘, null, null, ‘16‘, ‘1‘, ‘‘);
INSERT INTO student VALUES (‘31‘, ‘12331‘, ‘666‘, ‘12331‘, ‘000000‘, ‘男‘, ‘2019-04-21 00:00:00‘, ‘‘, ‘2‘, ‘‘, ‘‘, ‘‘, ‘2019-04-21 16:48:03‘, null, null, ‘10‘, ‘1‘, ‘‘);
INSERT INTO student VALUES (‘32‘, ‘12332‘, ‘孙孙‘, ‘12332‘, ‘000000‘, ‘男‘, ‘2019-04-22 00:00:00‘, ‘‘, ‘4‘, ‘‘, ‘‘, ‘‘, ‘2019-04-22 14:37:54‘, null, null, null, ‘1‘, ‘‘);
INSERT INTO student VALUES (‘33‘, ‘12333‘, ‘田阳‘, ‘12333‘, ‘000000‘, ‘男‘, ‘2019-04-10 00:00:00‘, ‘‘, ‘6‘, ‘‘, ‘‘, ‘‘, ‘2019-04-27 14:57:44‘, null, null, null, ‘1‘, ‘‘);
INSERT INTO student VALUES (‘34‘, ‘12334‘, ‘王萍‘, ‘12334‘, ‘000000‘, ‘女‘, ‘2019-04-27 00:00:00‘, ‘‘, ‘6‘, ‘‘, ‘‘, ‘‘, ‘2019-04-27 15:02:34‘, null, null, null, ‘1‘, ‘‘);
INSERT INTO student VALUES (‘35‘, ‘12335‘, ‘孙占山‘, ‘12335‘, ‘000000‘, ‘男‘, ‘2019-04-27 00:00:00‘, ‘‘, ‘6‘, ‘‘, ‘‘, ‘‘, ‘2019-04-27 15:02:49‘, null, null, null, ‘1‘, ‘‘);
-- Table structure for teacher
DROP TABLE IF EXISTS teacher;
CREATE TABLE teacher (teachId int(11) NOT NULL AUTO_INCREMENT,teachName varchar(30) DEFAULT NULL,teachUserName varchar(20) DEFAULT NULL,teachPass varchar(20) DEFAULT NULL,sex varchar(2) DEFAULT NULL,birthday datetime DEFAULT NULL,idCard varchar(20) DEFAULT NULL,edulevel varchar(20) DEFAULT NULL,specialty varchar(30) DEFAULT NULL,tel varchar(20) DEFAULT NULL,address varchar(50) DEFAULT NULL,flag int(11) DEFAULT NULL,memo varchar(100) DEFAULT NULL,hireDate datetime DEFAULT NULL,leaveDate datetime DEFAULT NULL,fk_typeid int(11) DEFAULT NULL,
PRIMARY KEY (teachId),
KEY fk_typeid (fk_typeid),
CONSTRAINT teacher_ibfk_1 FOREIGN KEY (fk_typeid) REFERENCES teachtype (typeId)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
-- Records of teacher
INSERT INTO teacher VALUES (‘1‘, ‘王杨‘, ‘2019001‘, ‘0000‘, ‘男‘, ‘2019-01-15 16:01:49‘, ‘410423200005070000‘, ‘本科‘, ‘Java‘, ‘11111111111‘, ‘二七‘, ‘1‘, ‘无‘, ‘2019-04-01 16:05:28‘, null, ‘1‘);
INSERT INTO teacher VALUES (‘2‘, ‘赵明芳‘, ‘2019002‘, ‘0000‘, ‘男‘, ‘2019-01-23 16:03:50‘, ‘410423200005071111‘, ‘本科‘, ‘管理‘, ‘22222222222‘, ‘二七‘, ‘1‘, ‘无‘, ‘2019-04-01 16:05:32‘, null, ‘2‘);
INSERT INTO teacher VALUES (‘3‘, ‘司朝贵‘, ‘2019003‘, null, ‘女‘, ‘2019-01-16 16:08:00‘, ‘410423200005072222‘, ‘本科‘, ‘英语‘, ‘33333333333‘, ‘金水‘, ‘2‘, ‘无‘, ‘2019-04-01 16:08:44‘, ‘2019-04-27 14:43:09‘, ‘2‘);
INSERT INTO teacher VALUES (‘4‘, ‘admin‘, ‘admin‘, ‘admin‘, ‘女‘, ‘2009-01-28 16:28:09‘, ‘488888888888888888‘, ‘博士‘, ‘经营管理‘, ‘88888888888‘, ‘二七‘, ‘1‘, ‘无‘, ‘2010-02-03 16:29:15‘, null, ‘4‘);
INSERT INTO teacher VALUES (‘5‘, ‘杨顺利‘, ‘2019005‘, ‘0000‘, ‘男‘, ‘2019-01-30 17:29:21‘, ‘429999999999999999‘, ‘本科‘, ‘Java‘, ‘77777777777‘, ‘二七‘, ‘1‘, ‘无‘, ‘2019-01-01 00:00:00‘, null, ‘1‘);
INSERT INTO teacher VALUES (‘6‘, ‘王丽娜‘, ‘2019006‘, ‘0000‘, ‘女‘, ‘2016-03-03 00:00:00‘, ‘489777777777777777‘, ‘本科‘, ‘Java‘, ‘77779966666‘, ‘二七‘, ‘1‘, ‘无‘, ‘2018-01-01 00:00:00‘, null, ‘2‘);
INSERT INTO teacher VALUES (‘7‘, ‘林秀‘, ‘2019007‘, ‘0000‘, ‘女‘, ‘2019-02-12 08:43:53‘, ‘573890999999999999‘, ‘本科‘, ‘暂无‘, ‘28478944444‘, ‘中原‘, ‘1‘, ‘无‘, ‘2019-05-14 08:44:41‘, null, ‘3‘);
-- Table structure for teachtype
DROP TABLE IF EXISTS teachtype;
CREATE TABLE teachtype (typeId int(11) NOT NULL AUTO_INCREMENT,typeName varchar(30) DEFAULT NULL,memo varchar(100) DEFAULT NULL,
PRIMARY KEY (typeId)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
-- Records of teachtype
INSERT INTO teachtype VALUES (‘1‘, ‘教员‘, ‘教课‘);
INSERT INTO teachtype VALUES (‘2‘, ‘班主任‘, ‘管理班级‘);
INSERT INTO teachtype VALUES (‘3‘, ‘宿管‘, ‘管理宿舍‘);
INSERT INTO teachtype VALUES (‘4‘, ‘校长‘, ‘厉害极了‘);