登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
1 Star 0 Fork 24

bingo2014 / 小程序上课考勤系统，后台管理，小程序前端GPS签到，小程序定位打卡，迟到统计等等

forked from Coding365 / 小程序上课考勤系统-毕业优秀作品 
代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
克隆/下载
kc_database.sql 16.14 KB
一键复制 编辑 原始数据 按行查看 历史
Coding365 提交于 2022-03-31 12:27 . 修复bug
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296
/*

 Navicat Premium Data Transfer



 Source Server         : 本地mysql

 Source Server Type    : MySQL

 Source Server Version : 50722

 Source Host           : localhost:3306

 Source Schema         : kc



 Target Server Type    : MySQL

 Target Server Version : 50722

 File Encoding         : 65001



 Date: 31/03/2022 12:25:54

*/



SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



-- ----------------------------

-- Table structure for kc_class_time

-- ----------------------------

DROP TABLE IF EXISTS `kc_class_time`;

CREATE TABLE `kc_class_time`  (

  `id` int(10) NOT NULL AUTO_INCREMENT,

  `week_num` int(10) NULL DEFAULT NULL,

  `lou` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `start_time` datetime NULL DEFAULT NULL,

  `end_time` datetime NULL DEFAULT NULL,

  `longitude` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `latitude` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `course_id` int(11) NULL DEFAULT NULL,

  `uid` int(11) NULL DEFAULT NULL,

  `class_grade` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `class_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `dept_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `teacher_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `course_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `distance` double NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of kc_class_time

-- ----------------------------

INSERT INTO `kc_class_time` VALUES (1, 212, '1221', '2022-03-27 00:00:00', '2022-03-29 00:00:00', '117.70562599696932', '39.09461899662046', NULL, 1, '112', NULL, NULL, NULL, NULL, 122);

INSERT INTO `kc_class_time` VALUES (2, 3, '2', '2022-03-31 00:00:00', '2022-04-01 00:00:00', '117.99998274647878', '38.97983035384176', 3, 1, '1511211', NULL, NULL, NULL, NULL, 1);



-- ----------------------------

-- Table structure for kc_course

-- ----------------------------

DROP TABLE IF EXISTS `kc_course`;

CREATE TABLE `kc_course`  (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `course_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `course_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `dept_id` int(11) NULL DEFAULT NULL,

  `uid` int(11) NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of kc_course

-- ----------------------------

INSERT INTO `kc_course` VALUES (3, '151121', '151121', 1, 1);



-- ----------------------------

-- Table structure for kc_dept

-- ----------------------------

DROP TABLE IF EXISTS `kc_dept`;

CREATE TABLE `kc_dept`  (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `dept_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `dept_num` int(11) NULL DEFAULT NULL,

  `dept_class` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `dept_grade` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `uid` int(11) NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of kc_dept

-- ----------------------------

INSERT INTO `kc_dept` VALUES (1, '151121', 151121, '151121', '151121', 1);

INSERT INTO `kc_dept` VALUES (2, '151121', 151121, '151121', '151121', 1);



-- ----------------------------

-- Table structure for kc_sign

-- ----------------------------

DROP TABLE IF EXISTS `kc_sign`;

CREATE TABLE `kc_sign`  (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `kc_class_time_id` int(11) NULL DEFAULT NULL,

  `stu_id` int(11) NULL DEFAULT NULL,

  `sign_time` datetime NULL DEFAULT NULL,

  `sign_status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `course_id` int(11) NULL DEFAULT NULL,

  `longtitude` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `lantitude` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `class_grade` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `kc_stu_id` int(11) NULL DEFAULT NULL,

  `num` int(11) NULL DEFAULT NULL,

  `course_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of kc_sign

-- ----------------------------



-- ----------------------------

-- Table structure for ke_token

-- ----------------------------

DROP TABLE IF EXISTS `ke_token`;

CREATE TABLE `ke_token`  (

  `user_id` bigint(20) NOT NULL,

  `token` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

  `expire_time` datetime NULL DEFAULT NULL,

  `update_time` datetime NULL DEFAULT NULL,

  PRIMARY KEY (`user_id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of ke_token

-- ----------------------------

INSERT INTO `ke_token` VALUES (15112111, 'wdty2iq3qrcz072e4pau0hheay06qrv7', '2022-03-29 04:57:06', '2022-03-28 16:57:06');



-- ----------------------------

-- Table structure for ke_user

-- ----------------------------

DROP TABLE IF EXISTS `ke_user`;

CREATE TABLE `ke_user`  (

  `user_id` int(11) NOT NULL,

  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

  `grade` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `tel` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `sex` int(1) NULL DEFAULT NULL,

  `nickname` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `per_sign` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `question` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `answer` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  PRIMARY KEY (`user_id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of ke_user

-- ----------------------------

INSERT INTO `ke_user` VALUES (1511211, '123456', '石胜', '大四', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `ke_user` VALUES (1511212, '123456', 'ad', '12', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `ke_user` VALUES (15112111, '123456', 'asa', 'as', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `ke_user` VALUES (15112133, '123456', '石大爷', '大一', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `ke_user` VALUES (15112166, '50603493a9856a846f9f9b15bd6a6aaea3adbe2a81e01b597f1eed036a9275d5', '飒飒2121', '大四', '13985901413', 0, '飒飒', '212', '2121', '1221', '12', '2121');



-- ----------------------------

-- Table structure for sys_permission

-- ----------------------------

DROP TABLE IF EXISTS `sys_permission`;

CREATE TABLE `sys_permission`  (

  `menu_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '父编号列表',

  `parent_id` int(11) NULL DEFAULT NULL COMMENT '父编号,本权限可能是该父编号权限的子权限',

  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限名称',

  `permission` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限字符串,menu例子：role:*，button例子：role:create,role:update,role:delete,role:view',

  `resource_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源类型，[menu|button]',

  `url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源路径 如：/userinfo/list',

  `available` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '是否可用0可用  1不可用',

  PRIMARY KEY (`menu_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sys_permission

-- ----------------------------

INSERT INTO `sys_permission` VALUES (1, 0, '用户管理', 'userInfo:view', 'menu', 'userInfo/view', '0');

INSERT INTO `sys_permission` VALUES (2, 1, '用户添加', 'userInfo:add', 'button', 'userInfo/add', '0');

INSERT INTO `sys_permission` VALUES (3, 1, '用户删除', 'userInfo:del', 'button', 'userInfo/del', '0');



-- ----------------------------

-- Table structure for sys_role

-- ----------------------------

DROP TABLE IF EXISTS `sys_role`;

CREATE TABLE `sys_role`  (

  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',

  `available` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '是否可用0可用  1不可用',

  `role` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色标识程序中判断使用,如\"admin\"',

  `description` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色描述,UI界面显示使用',

  PRIMARY KEY (`id`) USING BTREE,

  UNIQUE INDEX `role`(`role`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sys_role

-- ----------------------------

INSERT INTO `sys_role` VALUES (1, '0', 'admin', '管理员');

INSERT INTO `sys_role` VALUES (2, '0', 'vip', 'VIP会员');

INSERT INTO `sys_role` VALUES (3, '1', 'test', '测试');



-- ----------------------------

-- Table structure for sys_role_permission

-- ----------------------------

DROP TABLE IF EXISTS `sys_role_permission`;

CREATE TABLE `sys_role_permission`  (

  `role_id` int(11) NULL DEFAULT NULL COMMENT '角色id',

  `permission_id` int(11) NULL DEFAULT NULL COMMENT '权限id',

  INDEX `role_id`(`role_id`) USING BTREE,

  INDEX `permission_id`(`permission_id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sys_role_permission

-- ----------------------------

INSERT INTO `sys_role_permission` VALUES (1, 1);

INSERT INTO `sys_role_permission` VALUES (1, 2);

INSERT INTO `sys_role_permission` VALUES (2, 1);

INSERT INTO `sys_role_permission` VALUES (2, 2);

INSERT INTO `sys_role_permission` VALUES (2, 3);

INSERT INTO `sys_role_permission` VALUES (1, 2);



-- ----------------------------

-- Table structure for sys_user_role

-- ----------------------------

DROP TABLE IF EXISTS `sys_user_role`;

CREATE TABLE `sys_user_role`  (

  `uid` int(11) NULL DEFAULT NULL COMMENT '用户id',

  `role_id` int(11) NULL DEFAULT NULL COMMENT '角色id',

  INDEX `uid`(`uid`) USING BTREE,

  INDEX `role_id`(`role_id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sys_user_role

-- ----------------------------

INSERT INTO `sys_user_role` VALUES (1, 1);

INSERT INTO `sys_user_role` VALUES (2, 2);

INSERT INTO `sys_user_role` VALUES (50, 1);



-- ----------------------------

-- Table structure for test

-- ----------------------------

DROP TABLE IF EXISTS `test`;

CREATE TABLE `test`  (

  `id` int(11) NOT NULL,

  `zhou` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `week` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `jieci` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of test

-- ----------------------------

INSERT INTO `test` VALUES (1, '1,2,3,4,5,6,7', '2,3,4,5', '1,2');



-- ----------------------------

-- Table structure for user_info

-- ----------------------------

DROP TABLE IF EXISTS `user_info`;

CREATE TABLE `user_info`  (

  `uid` int(11) NOT NULL AUTO_INCREMENT,

  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '用户名',

  `password` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录密码',

  `name` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名字(匿名)',

  `tel` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `id_card_num` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户身份证号',

  `state` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '用户状态：0:正常状态,1：用户被锁定',

  `nickname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '昵称',

  `real_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '实名',

  `email` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',

  `per_sig` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '个性签名',

  `per_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像地址',

  `salt` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '加盐',

  `question` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `answer` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `register_time` datetime NULL DEFAULT NULL COMMENT '注册事件',

  `update_time` datetime NULL DEFAULT NULL COMMENT '密码修改时间',

  PRIMARY KEY (`uid`) USING BTREE,

  UNIQUE INDEX `username`(`username`) USING BTREE,

  UNIQUE INDEX `id_card_num`(`id_card_num`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 55 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of user_info

-- ----------------------------

INSERT INTO `user_info` VALUES (1, 'admin', '$2a$10$VwLFpjvIRGpAAaV8pVfEHefHJ0po9R7ABUZ.3mhz3v1MyabkGRGUG', '超哥', NULL, '133333333333333333', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `user_info` VALUES (2, 'test', '$2a$10$VwLFpjvIRGpAAaV8pVfEHefHJ0po9R7ABUZ.3mhz3v1MyabkGRGUG', '孙悟空', NULL, '155555555555555555', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `user_info` VALUES (48, 'test1', '$2a$10$VwLFpjvIRGpAAaV8pVfEHefHJ0po9R7ABUZ.3mhz3v1MyabkGRGUG', NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `user_info` VALUES (49, '10086', '$2a$10$9wZ29SJRBBOJ3CTztfvFYudBW/Fk/i0QfmOoAtMH9mugA/Q2aHrdu', NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `user_info` VALUES (50, 'admin100', '$2a$10$zAwSx2EC7BJpwgioNXjLke6fODSonL8hxEwrOEBLhnh1AIp3oGbGG', NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `user_info` VALUES (51, 'admin2121', '$2a$10$4.pjlvLM7MbAHGXwTgV.4OM8713BKKiXx.zOk//e9eOB0gb0KUFAO', NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `user_info` VALUES (52, 'admin111', '$2a$10$gDeit9nglWPIBnqfOtDNF..6WIDvUYX920uRQBlTWkvRnNC7YJSCS', NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `user_info` VALUES (53, 'admin12345', '$2a$10$e5U7I/bxRcpIK4xFR5zhwO7J3a.HSvAgROW4gD8Ub9mcl5g4J8Axy', NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `user_info` VALUES (54, 'admin1', '$2a$10$pQd1o9MrEs3xhxGeIw7HQO381e.0pfi..usX6cQpO7lK/1H7MI.Ae', NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);



SET FOREIGN_KEY_CHECKS = 1;
Java
1
https://gitee.com/nwb/ke200.git
git@gitee.com:nwb/ke200.git
nwb
ke200
小程序上课考勤系统，后台管理，小程序前端GPS签到，小程序定位打卡，迟到统计等等
kc-1.0.0
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部