/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50711
 Source Host           : localhost:3306
 Source Schema         : baseteacher

 Target Server Type    : MySQL
 Target Server Version : 50711
 File Encoding         : 65001

 Date: 23/10/2018 17:15:02
*/


-- ----------------------------
-- Table structure for sxd_activity
-- ----------------------------
CREATE TABLE `sxd_activity`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `biaoti` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '标题',
  `huodongjibie` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '活动级别',
  `shijianstart` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '开始时间',
  `shijianend` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '结束时间',
  `wenjian` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '文件',
  `wenjianmiaoshu` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '文件描述',
  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '内容',
  `zhuangtai` int(10) DEFAULT 0 COMMENT '状态',
  `faburen` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发布人',
  `fabushijian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发布时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '活动表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sxd_activityshenqin
-- ----------------------------
CREATE TABLE `sxd_activityshenqin`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `xuehao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学号',
  `xingming` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
  `xiebie` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '性别',
  `nianji` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '年级',
  `banji` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '班级',
  `zhuangtai` int(10) DEFAULT 0 COMMENT '状态',
  `actid` int(10) DEFAULT NULL COMMENT '活动ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '活动申请表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sxd_association
-- ----------------------------
CREATE TABLE `sxd_association`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `shetuanmingcheng` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '社团名称',
  `shenqinshijian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请时间',
  `xuehao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `shenqinren` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请人',
  `shenqinshuoming` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '申请说明',
  `bohuishuoming` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '驳回说明',
  `zhuangtai` int(10) DEFAULT 0 COMMENT '状态',
  `chuanglishijian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创立时间',
  `renshu` int(50) DEFAULT 0 COMMENT '人数',
  `shenheren` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人',
  `qudishijian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '取缔时间',
  `qudiren` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '取缔人',
  `qudishuoming` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '社团' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sxd_associationgonggao
-- ----------------------------
CREATE TABLE `sxd_associationgonggao`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `aid` int(10) DEFAULT NULL COMMENT '社团ID',
  `biaoti` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '标题',
  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '内容',
  `faburen` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发布人',
  `fabushijian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发布时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '社团公告' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sxd_associationshenqin
-- ----------------------------
CREATE TABLE `sxd_associationshenqin`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `sheid` int(10) DEFAULT NULL COMMENT '社团ID',
  `shenqinleixin` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请类型',
  `xuehao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学号',
  `xingming` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
  `xinbie` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '性别',
  `nianji` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '年级',
  `banji` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '班级',
  `shenqinshijian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请时间',
  `shuoming` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '说明',
  `shenhezhuangtai` int(10) DEFAULT 0 COMMENT '审核状态',
  `shenheshuoming` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '审核说明',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '社团申请' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sxd_auth
-- ----------------------------
CREATE TABLE `sxd_auth`  (
  `auth_id` int(10) NOT NULL AUTO_INCREMENT,
  `auth_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `auth_pid` int(10) NOT NULL,
  `auth_c` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `auth_a` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `auth_path` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `auth_level` int(10) NOT NULL,
  `auth_isshow` int(10) NOT NULL COMMENT '是否显示',
  `auth_icon` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '图标',
  PRIMARY KEY (`auth_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 48 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '权限' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sxd_auth
-- ----------------------------
INSERT INTO `sxd_auth` VALUES (1, '教学基本设置', 0, '', '', '1-1', 0, 1, 'icon icon-basic');
INSERT INTO `sxd_auth` VALUES (2, '基础设置', 1, 'Index', 'welcome', '1-2', 1, 1, NULL);
INSERT INTO `sxd_auth` VALUES (3, '权限管理', 1, 'Role', 'index', '1-3', 1, 1, NULL);
INSERT INTO `sxd_auth` VALUES (7, '在校信息', 0, '', '', '7-7', 0, 1, 'icon icon-schoolInfo');
INSERT INTO `sxd_auth` VALUES (8, '学籍管理', 7, 'Schoolinformation', 'xueji', '7-8', 1, 1, NULL);
INSERT INTO `sxd_auth` VALUES (9, '班级管理', 7, 'Classmanage', 'index', '7-9', 1, 1, NULL);
INSERT INTO `sxd_auth` VALUES (10, '增加用户', 1, 'Usersc', 'add', '1-10', 1, 0, NULL);
INSERT INTO `sxd_auth` VALUES (11, '删除用户', 1, 'Usersc', 'deleteszhs', '1-10', 1, 0, NULL);
INSERT INTO `sxd_auth` VALUES (12, '编辑用户', 1, 'Usersc', 'update', '1-10', 1, 0, NULL);
INSERT INTO `sxd_auth` VALUES (14, '用户管理', 1, 'Usersc', 'index', '1-14', 1, 1, NULL);
INSERT INTO `sxd_auth` VALUES (15, '缴费管理', 7, 'Paymanage', 'index', '7-15', 1, 1, NULL);
INSERT INTO `sxd_auth` VALUES (16, '升级', 7, 'Schoolinformation', 'upgrade', '7-16', 1, 2, NULL);
INSERT INTO `sxd_auth` VALUES (17, '机构管理', 0, NULL, NULL, '17-17', 0, 1, 'icon icon-organization-manage');
INSERT INTO `sxd_auth` VALUES (18, '党员信息', 17, 'Organ', 'index', '17-18', 1, 1, NULL);
INSERT INTO `sxd_auth` VALUES (19, '团员信息', 17, 'Organ', 'tuanyuan', '17-19', 1, 1, NULL);
INSERT INTO `sxd_auth` VALUES (20, '组织公告', 17, 'Organ', 'gonggao', '17-20', 1, 1, NULL);
INSERT INTO `sxd_auth` VALUES (21, '社团管理', 17, 'Association', 'index', '17-21', 1, 1, NULL);
INSERT INTO `sxd_auth` VALUES (22, '评价管理', 17, 'Evaluation', 'index', '17-22', 1, 1, NULL);
INSERT INTO `sxd_auth` VALUES (23, '素质管理', 0, NULL, NULL, '23-23', 0, 1, 'icon icon-quality-manage');
INSERT INTO `sxd_auth` VALUES (24, '健康管理', 23, 'Quality', 'index', '23-24', 1, 1, NULL);
INSERT INTO `sxd_auth` VALUES (25, '校园机制', 0, NULL, NULL, '25-25', 0, 1, 'icon icon-school-mechanism');
INSERT INTO `sxd_auth` VALUES (26, '奖惩管理', 25, 'Reward', 'index', '25-26', 1, 1, NULL);
INSERT INTO `sxd_auth` VALUES (27, '困难生管理', 25, 'Poorstudents', 'index', '25-27', 1, 1, NULL);
INSERT INTO `sxd_auth` VALUES (28, '奖/助学金管理', 25, 'Scholarships', 'index', '25-28', 1, 1, NULL);
INSERT INTO `sxd_auth` VALUES (29, '勤工岗位管理', 25, 'Diligent', 'index', '25-29', 1, 1, NULL);
INSERT INTO `sxd_auth` VALUES (30, '活动管理', 0, NULL, NULL, '30-30', 0, 1, 'icon icon-activity-manage');
INSERT INTO `sxd_auth` VALUES (31, '活动发布', 30, 'Activity', 'index', '30-31', 1, 1, NULL);
INSERT INTO `sxd_auth` VALUES (32, '毕业生管理', 0, NULL, NULL, '32-32', 0, 1, 'icon icon-graduate-manage');
INSERT INTO `sxd_auth` VALUES (33, '毕业生管理', 32, 'Graduate', 'index', '32-33', 1, 1, NULL);
INSERT INTO `sxd_auth` VALUES (34, '数据综合分析', 0, NULL, NULL, '34-34', 0, 1, 'icon icon-data-analysis');
INSERT INTO `sxd_auth` VALUES (35, '毕业分析', 34, 'Analysis', 'index', '34-35', 1, 1, NULL);
INSERT INTO `sxd_auth` VALUES (36, '籍贯生源分析', 34, 'Analysis', 'nativeplace', '34-36', 1, 1, NULL);
INSERT INTO `sxd_auth` VALUES (37, '添加组织公告', 17, 'Organ', 'addgonggao', '17-37', 1, 0, NULL);
INSERT INTO `sxd_auth` VALUES (38, '修改组织公告', 17, 'Organ', 'updategonggao', '17-38', 1, 0, NULL);
INSERT INTO `sxd_auth` VALUES (39, '删除组织公告', 17, 'Organ', 'deletegonggao', '17-39', 1, 0, NULL);
INSERT INTO `sxd_auth` VALUES (40, '添加奖惩申请', 25, 'Reward', 'addshenqin', '25-40', 1, 0, NULL);
INSERT INTO `sxd_auth` VALUES (41, '修改奖惩申请', 25, 'Reward', 'updateshenqin', '25-41', 1, 0, NULL);
INSERT INTO `sxd_auth` VALUES (42, '删除奖惩申请', 25, 'Reward', 'deleteshenqin', '25-42', 1, 0, NULL);
INSERT INTO `sxd_auth` VALUES (43, '审核奖惩申请', 25, 'Reward', 'doshenhe', '25-43', 1, 0, NULL);
INSERT INTO `sxd_auth` VALUES (44, '活动发布', 30, 'Activity', 'addactivity', '30-44', 1, 0, NULL);
INSERT INTO `sxd_auth` VALUES (45, '活动修改', 30, 'Activity', 'updateactivity', '30-45', 1, 0, NULL);
INSERT INTO `sxd_auth` VALUES (46, '活动删除', 30, 'Activity', 'deleteActivity', '30-46', 1, 0, NULL);
INSERT INTO `sxd_auth` VALUES (47, '活动人员审核', 30, 'Activity', 'joinactivity', '30-47', 1, 0, NULL);

-- ----------------------------
-- Table structure for sxd_biye_info
-- ----------------------------
CREATE TABLE `sxd_biye_info`  (
  `s_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '毕业生表',
  `s_xuehao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学号',
  `s_xingming` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
  `s_nianji` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '年级',
  `s_mingzu` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '民族',
  `s_xinbie` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '1' COMMENT '性别',
  `s_chushenriqi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '出生日期',
  `s_ruxuenianfen` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '入学年份',
  `s_zhenjianhao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '证件号',
  `s_zhenzhimianmao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '政治面貌',
  `s_jiguan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '籍贯',
  `s_xianzhuzhi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '现住址',
  `s_hukouleixin` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '户口类型',
  `s_biyeyuanxiao` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '毕业院校',
  `s_jiudufangshi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '就读方式',
  `s_xuejizhuangtai` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学籍状态',
  `s_yuwencj` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '语文成绩',
  `s_shuxuecj` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '数学成绩',
  `s_yinyucj` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '英语成绩',
  `s_kaoshenhao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '考生号',
  `s_lishicj` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '历史成绩',
  `s_sixiangzhenzhicj` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '思想政治成绩',
  `s_dilicj` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '地理成绩',
  `s_wenkezonghecj` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '文科综合',
  `s_biyezhuangkuang` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '毕业状况',
  `s_xuanzeyuanxiao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '选择院校',
  `s_baosongzige` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '保送资格',
  `s_biyefangxiang` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '毕业方式',
  `s_ispingkun` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否贫困',
  `s_lianxifangshi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系方式',
  `s_jianglizige` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '奖励资格',
  `s_img` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '头像',
  `s_zongfen` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '总分',
  `s_biyenianfen` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '毕业年份',
  PRIMARY KEY (`s_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 39 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '毕业信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sxd_biye_info
-- ----------------------------
INSERT INTO `sxd_biye_info` VALUES (38, 'B02122', '测试生', '八年级', '汉族', '1', '1992/3/3', '2018', '34056985688458', '团员', '安徽', '合肥', '城市', '清华大学', '走读', '毕业', '66', '66', '66', '12505424', '66', '66', '66', '66', '已毕业', '北京大学', '无', '正常升学', '否', '13922212112', '无', NULL, '462', '2018');

-- ----------------------------
-- Table structure for sxd_bulletin
-- ----------------------------
CREATE TABLE `sxd_bulletin`  (
  `b_id` int(10) NOT NULL AUTO_INCREMENT,
  `b_biaoti` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '标题',
  `b_zhaiyao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '摘要',
  `b_shijian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发布时间',
  `b_faburen` int(10) DEFAULT NULL COMMENT '发布人',
  `b_wenjian` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '文件',
  `b_gonggao` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '公告',
  `b_zhuangtai` int(10) DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`b_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '所有公告' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sxd_bulletin
-- ----------------------------
INSERT INTO `sxd_bulletin` VALUES (13, '是打发', '是', '1539745663', 1, '20181017\\5276b5841f732d28e79577d057284e91.sql', '是的', 1);
INSERT INTO `sxd_bulletin` VALUES (14, '阿萨德', '阿萨德', '1539745790', 1, '20181017\\9f24ccb582300a11ee80ee9b3fdf7f45.jpg', 'as的', 1);
INSERT INTO `sxd_bulletin` VALUES (15, '打算', '阿萨德 ', '1539746006', 1, '20181017\\629b58e0213d894887d654543012f6e0.jpg', '阿萨德', 0);
INSERT INTO `sxd_bulletin` VALUES (16, '的说法是', '是 ', '1539746135', 1, '20181017\\429188ee55245e83863c6813fa27ba59.jpg', '是打发是', 1);
INSERT INTO `sxd_bulletin` VALUES (17, '是大法师', '是打发是', '1539746355', 1, '20181017\\6b6d8ac49ba47bff4e71804de5d8d9a2.jpg', '是大法师 ', 0);
INSERT INTO `sxd_bulletin` VALUES (18, 'asda ', 'asda ', '1539746522', 1, '20181017\\faf26b41caecd78ce0c2e4b44fbfa0f4.jpg', 'asda ', 0);
INSERT INTO `sxd_bulletin` VALUES (19, 'asda ', 'ad ', '1539746649', 1, '20181017\\aca53e8cf32a8f63de361d375f46a9dd.jpg', 'ad ', 0);
INSERT INTO `sxd_bulletin` VALUES (20, 'asd ', 'asd ', '1539746669', 1, '20181017\\270d039814c203c2b4f2a82dd0427f49.jpg', 'asd ', 0);
INSERT INTO `sxd_bulletin` VALUES (21, 'asd ', 'asd ', '1539746704', 1, '20181017\\d89604e97dd1464d5a21bc3e3dc1900f.jpg', 'ad ', 0);
INSERT INTO `sxd_bulletin` VALUES (22, 'asda ', 'asd a', '1539746741', 1, '20181017\\c77a867a98ac5984856f1423e24f56e6.jpg', 'asdad ', 0);
INSERT INTO `sxd_bulletin` VALUES (23, 'asd ', 'a da', '1539746853', 1, '20181017\\a97bdc689489923ebb8e71141561ce59.jpg', 'as d', 0);
INSERT INTO `sxd_bulletin` VALUES (24, 'dsfs ', 'sdf ', '1539759424', 1, '20181017\\6bf22f0a88f37a4f726969c4dd343083.jpg', 'sdf ', 0);
INSERT INTO `sxd_bulletin` VALUES (25, 'asda ', 'asda ', '1539842408', 1, '20181018\\e877de9c4fbebf531d25c551e7a6da8d.jpg', 'asd', 0);

-- ----------------------------
-- Table structure for sxd_class
-- ----------------------------
CREATE TABLE `sxd_class`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `cid` int(50) DEFAULT NULL,
  `beizhu` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 39 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '班级' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sxd_class
-- ----------------------------
INSERT INTO `sxd_class` VALUES (6, '2班', 10, '九年级');
INSERT INTO `sxd_class` VALUES (5, '1班', 10, '九年级');
INSERT INTO `sxd_class` VALUES (4, '2班', 12, '八年级');
INSERT INTO `sxd_class` VALUES (3, '1班', 12, '八年级');
INSERT INTO `sxd_class` VALUES (2, '2班', 11, '七年级');
INSERT INTO `sxd_class` VALUES (1, '1班', 11, '七年级');

-- ----------------------------
-- Table structure for sxd_diligent
-- ----------------------------
CREATE TABLE `sxd_diligent`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `fabujigou` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发布机构',
  `gangweimingcheng` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '岗位名称',
  `lianxiren` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人',
  `lianxidianhua` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系电话',
  `shenqinstart` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请开始时间',
  `shenqinend` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请结束时间',
  `gongzuostart` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '工作开始时间',
  `gongzuoend` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '工作结束时间',
  `xinzijisuan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '薪资计算',
  `danweibaochou` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '单位报酬',
  `zhaopinrenshu` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '招聘人数',
  `gangweimiaoshu` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '岗位描述',
  `gangweiyaoqiu` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '岗位要求',
  `zhuangtai` int(10) DEFAULT 0 COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '勤工岗位' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sxd_diligentpersonnum
-- ----------------------------
CREATE TABLE `sxd_diligentpersonnum`  (
  `id` int(10) NOT NULL,
  `num` int(10) DEFAULT NULL COMMENT '个人可申请岗位数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '个人可申请岗位数' ROW_FORMAT = Fixed;

-- ----------------------------
-- Records of sxd_diligentpersonnum
-- ----------------------------
INSERT INTO `sxd_diligentpersonnum` VALUES (1, 3);

-- ----------------------------
-- Table structure for sxd_diligentshenhe
-- ----------------------------
CREATE TABLE `sxd_diligentshenhe`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `xuehao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学号',
  `xingming` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
  `nianji` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '年级',
  `banji` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '班级',
  `kunnanshen` int(10) DEFAULT NULL COMMENT '困难生',
  `did` int(10) DEFAULT NULL COMMENT '岗位ID',
  `shenqinshijian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请时间',
  `zhuangtai` int(10) DEFAULT 0 COMMENT '状态',
  `yijian` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '意见',
  `shenheren` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人',
  `shenheshijian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核时间',
  `jieshuluyong` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '结束录用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '岗位发布审核' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sxd_division
-- ----------------------------
CREATE TABLE `sxd_division`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `type_id` int(10) DEFAULT 0 COMMENT '1=按名次分班，2=按学号分班',
  `mingcistatrt` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '名次开始',
  `mingciend` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '名次结束',
  `xuehaostart` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学号开始',
  `xuehaoend` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学号结束',
  `num` int(10) DEFAULT 0 COMMENT '班级数量',
  `is_tongming` int(10) DEFAULT 0 COMMENT '是否同名',
  `is_nannv` int(10) DEFAULT 0 COMMENT '是否男女',
  `beizhu` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 53 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分班规则' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sxd_evaluation
-- ----------------------------
CREATE TABLE `sxd_evaluation`  (
  `e_id` int(10) NOT NULL AUTO_INCREMENT,
  `e_xuehao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学号',
  `e_status` int(10) DEFAULT 0 COMMENT '状态',
  `e_pinyu` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '评语',
  `e_banji` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '班级',
  `e_nianji` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '年级',
  `e_xingming` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
  `e_qishu` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '期数',
  PRIMARY KEY (`e_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '教师评价' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sxd_evaluationkaiguan
-- ----------------------------
CREATE TABLE `sxd_evaluationkaiguan`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `kaiguan` int(11) DEFAULT NULL COMMENT '开关',
  `qishu` int(10) DEFAULT NULL COMMENT '期数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '评价开关' ROW_FORMAT = Fixed;

-- ----------------------------
-- Records of sxd_evaluationkaiguan
-- ----------------------------
INSERT INTO `sxd_evaluationkaiguan` VALUES (1, 0, 1);

-- ----------------------------
-- Table structure for sxd_evaluationname
-- ----------------------------
CREATE TABLE `sxd_evaluationname`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '评价问题名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '评价科目' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sxd_evaluationname
-- ----------------------------
INSERT INTO `sxd_evaluationname` VALUES (6, '体育');
INSERT INTO `sxd_evaluationname` VALUES (5, '智慧');
INSERT INTO `sxd_evaluationname` VALUES (4, '品德');
INSERT INTO `sxd_evaluationname` VALUES (7, '劳动');
INSERT INTO `sxd_evaluationname` VALUES (8, '学习');
INSERT INTO `sxd_evaluationname` VALUES (9, '综合评价');

-- ----------------------------
-- Table structure for sxd_evaluationpinjia
-- ----------------------------
CREATE TABLE `sxd_evaluationpinjia`  (
  `p_id` int(10) NOT NULL AUTO_INCREMENT,
  `p_xuehao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学号',
  `p_uid` int(10) DEFAULT NULL COMMENT '用户ID',
  `p_nid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `p_dengji` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `p_xuenian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `p_xueqi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `p_qishu` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`p_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 148 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '评价' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sxd_evaluationselfpinjia
-- ----------------------------
CREATE TABLE `sxd_evaluationselfpinjia`  (
  `p_id` int(10) NOT NULL AUTO_INCREMENT,
  `p_xuehao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `p_uid` int(10) DEFAULT NULL,
  `p_nid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `p_dengji` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `p_xuenian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `p_xueqi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `p_qishu` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`p_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 52 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '学生评价' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sxd_grade
-- ----------------------------
CREATE TABLE `sxd_grade`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '年级' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sxd_grade
-- ----------------------------
INSERT INTO `sxd_grade` VALUES (10, '九年级');
INSERT INTO `sxd_grade` VALUES (11, '七年级');
INSERT INTO `sxd_grade` VALUES (12, '八年级');

-- ----------------------------
-- Table structure for sxd_partymember
-- ----------------------------
CREATE TABLE `sxd_partymember`  (
  `p_id` int(10) NOT NULL AUTO_INCREMENT,
  `p_xingming` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
  `p_xuehao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学号',
  `p_zhenjianhao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '证件号',
  `p_nianji` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '年级',
  `p_banji` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '班级',
  `p_shouji` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机号码',
  `p_rudangriqi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '入党日期',
  `p_zhuanzhenriqi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '转正日期',
  `p_zhibu` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '所在支部',
  `p_jiatindizhi` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '家庭地址',
  `p_type` int(10) DEFAULT 1 COMMENT '1=党员 2=团员',
  `p_tuanfei` int(10) DEFAULT 0 COMMENT '团费',
  PRIMARY KEY (`p_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 38 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '团员党员表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sxd_pay
-- ----------------------------
CREATE TABLE `sxd_pay`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `xuenian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学年',
  `xueqi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学期',
  `jiaofeimingcheng` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '缴费名称',
  `jiaofeijinge` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '缴费金额',
  `guanlijigou` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '管理机构',
  `jigoufuzeren` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '机构负责人',
  `jigoulianxifangshi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '机构联系方式',
  `fuzerenlianxifangshi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '负责人联系方式',
  `beizhu` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '缴费' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sxd_pay
-- ----------------------------
INSERT INTO `sxd_pay` VALUES (1, '2010', '第一学期', '学费', '666.5', '合肥教委会', '0987-221211', '13955914483', '13908765678', '没有什么备注');
INSERT INTO `sxd_pay` VALUES (5, '2010', '第一学期', '学费', '777.5', '合肥教委会', '王强', '13955914483', '13908765678', '444');
INSERT INTO `sxd_pay` VALUES (10, '', '', '', '', '', '', '', '', '');

-- ----------------------------
-- Table structure for sxd_payroll
-- ----------------------------
CREATE TABLE `sxd_payroll`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `xuehao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学号',
  `xingming` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
  `banji` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '班级',
  `fabujigou` varbinary(50) DEFAULT NULL COMMENT '发布机构',
  `gangweimingcheng` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '岗位名称',
  `gongzuoshijian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '工作时间',
  `jixinyuefen` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '计薪月份',
  `jine` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '金额',
  `kaohe` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '考核状态',
  `yinghangkahao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '银行卡号',
  `leixin` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '类型',
  `zhuangtai` int(10) DEFAULT 0 COMMENT '状态',
  `shenheren` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人',
  `shenheshijian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核时间',
  `yijian` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '意见',
  `is_fafang` int(10) DEFAULT 0 COMMENT '是否发放工资',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 28 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '工资单' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sxd_poor
-- ----------------------------
CREATE TABLE `sxd_poor`  (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '贫困生',
  `xuenian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学年',
  `shijianstart` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '开始时间',
  `shijianend` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '结束时间',
  `wenjian` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '文件',
  `neirong` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '内容',
  `zhuangtai` int(10) DEFAULT 0 COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 30 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '困难学生' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sxd_poorshenqin
-- ----------------------------
CREATE TABLE `sxd_poorshenqin`  (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '贫困生审核',
  `xuehao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学号',
  `xingming` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
  `banji` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '班级',
  `xuenian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学年',
  `shenqinshijian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请时间',
  `shenheyijian` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '审核意见',
  `wenjian` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '文件',
  `zhuangtai` int(10) DEFAULT 0 COMMENT '状态',
  `shenheren` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人',
  `shenheshijian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '贫困申请' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sxd_quality
-- ----------------------------
CREATE TABLE `sxd_quality`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `xingming` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
  `xingbie` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '性别',
  `chushenriqi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '出生日期',
  `shenfenzhen` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '身份证',
  `zhiye` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '职业',
  `hunyinzhuangtai` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学号（不是婚姻状态）',
  `xuexin` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '血型',
  `wenhuachengdu` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '文化程度',
  `yaowuguomin` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '药物过敏',
  `yaowu` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `tiwen` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '体温',
  `maibo` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '脉搏',
  `huxipinlu` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '呼吸频率',
  `xueya` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '血压',
  `shengao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '身高',
  `tizhong` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '体重',
  `shili` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '视力',
  `qitashili` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '其他视力',
  `jibin` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '疾病',
  `quezhenriqi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '确诊日期',
  `shoushu` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手术',
  `jibinmingchen` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '疾病名称',
  `jibinshijian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '疾病时间',
  `yichuanbinshi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '遗传病史',
  `yinchuanbin` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '遗传病',
  `canjiqinkuang` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '残疾情况',
  `lurushijian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '录入时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 23 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '健康' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sxd_reward
-- ----------------------------
CREATE TABLE `sxd_reward`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `xuehao` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学号',
  `jiangchenleixin` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '奖惩类型',
  `jiangchenshijian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '奖惩时间',
  `shuoming` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '说明',
  `status` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '0' COMMENT '状态',
  `shenqinren` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请人',
  `shenqinshijian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请时间',
  `shenheyijian` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '审核意见',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 20 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '奖惩' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sxd_role
-- ----------------------------
CREATE TABLE `sxd_role`  (
  `r_id` int(10) NOT NULL,
  `pid` int(10) NOT NULL DEFAULT 0,
  `r_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `r_menu` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
  PRIMARY KEY (`r_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sxd_role
-- ----------------------------
INSERT INTO `sxd_role` VALUES (1, 0, '管理员', '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47');
INSERT INTO `sxd_role` VALUES (2, 0, '教职工', '1,2,3,10,11,12,14');
INSERT INTO `sxd_role` VALUES (3, 0, '学生', '1,2,3,10,11,12,14,7,8,9,15,16');
INSERT INTO `sxd_role` VALUES (4, 0, '家长', '1,2,3,10,11,12,14');
INSERT INTO `sxd_role` VALUES (5, 2, '123', '1');
INSERT INTO `sxd_role` VALUES (6, 5, '12', '1');

-- ----------------------------
-- Table structure for sxd_scholarships
-- ----------------------------
CREATE TABLE `sxd_scholarships`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `jiangxuejinleixin` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '奖学金类型',
  `shijianstart` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '开始时间',
  `shijianend` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '结束时间',
  `wenjian` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '文件名称',
  `xinqin` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '奖惩说明',
  `zhuangtai` int(10) DEFAULT 0 COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '奖学金' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sxd_scholarshipsshenqin
-- ----------------------------
CREATE TABLE `sxd_scholarshipsshenqin`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `xuehao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学号',
  `xingming` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
  `banji` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '班级',
  `shenqinleixin` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请类型',
  `wenjian` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '文件',
  `shenqinshijian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请时间',
  `yijian` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '意见',
  `zhuangtai` int(10) DEFAULT 0 COMMENT '状态',
  `shenheren` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人',
  `shenheshijian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '奖学金申请' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sxd_scholarshipsshenqin
-- ----------------------------
INSERT INTO `sxd_scholarshipsshenqin` VALUES (5, 'B321', NULL, NULL, '学业贷款', NULL, '2018/10/22', '65165', 2, 'admin', '1540208140');

-- ----------------------------
-- Table structure for sxd_semester
-- ----------------------------
CREATE TABLE `sxd_semester`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sxd_semester
-- ----------------------------
INSERT INTO `sxd_semester` VALUES (5, '第一学期');

-- ----------------------------
-- Table structure for sxd_setting
-- ----------------------------
CREATE TABLE `sxd_setting`  (
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `over_at` int(10) NOT NULL DEFAULT 0
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sxd_setting
-- ----------------------------
INSERT INTO `sxd_setting` VALUES ('apitoken', '3a56f7c4e7554fb77251fd8c68bea0d9', 1540971079);

-- ----------------------------
-- Table structure for sxd_student_info
-- ----------------------------
CREATE TABLE `sxd_student_info`  (
  `s_id` int(10) NOT NULL AUTO_INCREMENT,
  `s_xuehao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学号',
  `s_xingming` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
  `s_nianji` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '年级',
  `s_mingzu` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '民族',
  `s_xinbie` int(10) DEFAULT 1 COMMENT '性别',
  `s_chushenriqi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '出生日期',
  `s_ruxuenianfen` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '入学年份',
  `s_zhenjianhao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '证件号',
  `s_zhenzhimianmao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '政治面貌',
  `s_jiguan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '籍贯',
  `s_xianzhuzhi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '现住址',
  `s_hukouleixin` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '户口类型',
  `s_biyeyuanxiao` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '毕业院校',
  `s_jiudufangshi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '就读方式',
  `s_xuejizhuangtai` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学籍状态',
  `s_yuwencj` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '语文成绩',
  `s_shuxuecj` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '数学成绩',
  `s_yinyucj` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '英语成绩',
  `s_kaoshenhao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '考生号',
  `s_lishicj` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '历史成绩',
  `s_sixiangzhenzhicj` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '思想政治成绩',
  `s_dilicj` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '地理成绩',
  `s_wenkezonghecj` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '文科综合成绩',
  `s_ajhrxinmin` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人一姓名',
  `s_ajhrguanxi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人一关系',
  `s_ajhrgongzuodizhi` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人一工作地址',
  `s_ajhrlianxifangshi` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人一联系方式',
  `s_bjhrxinmin` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人二姓名',
  `s_bjhrguanxi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人二关系',
  `s_bjhrgongzuodizhi` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人二工作地址',
  `s_bjhrlianxifangshi` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人二联系方式',
  `s_shifouliushou` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否留守',
  `s_shifoudushen` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否独生',
  `s_shifouguer` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否孤儿',
  `s_shifouliudong` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否流动',
  `s_techang` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '特长',
  `s_jianglichufa` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '奖励处罚',
  `s_img` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '头像',
  `s_zongfen` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '总分',
  `s_banji` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '0' COMMENT '班级',
  `s_numbanji` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '班级',
  PRIMARY KEY (`s_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 60 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '学生信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sxd_transfer
-- ----------------------------
CREATE TABLE `sxd_transfer`  (
  `t_id` int(10) NOT NULL AUTO_INCREMENT,
  `t_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '异动名称',
  PRIMARY KEY (`t_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '学籍异动' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sxd_transfer
-- ----------------------------
INSERT INTO `sxd_transfer` VALUES (1, '肄业');
INSERT INTO `sxd_transfer` VALUES (2, '留级');

-- ----------------------------
-- Table structure for sxd_transferinfo
-- ----------------------------
CREATE TABLE `sxd_transferinfo`  (
  `tr_id` int(10) NOT NULL AUTO_INCREMENT,
  `tr_uid` int(10) DEFAULT NULL COMMENT '用户ID',
  `tr_tid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '异动ID',
  `tr_content` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `tr_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `tr_status` int(10) DEFAULT 0,
  PRIMARY KEY (`tr_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sxd_years
-- ----------------------------
CREATE TABLE `sxd_years`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '年份',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 93 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '学年' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sxd_years
-- ----------------------------
INSERT INTO `sxd_years` VALUES (6, '2018-2019学年');
INSERT INTO `sxd_years` VALUES (5, '2017-2018学年');

