py222基于python+django的高校学生信息管理系统

开发语言：Python编号：py222基于python+django的高校学生信息管理系统#毕业设计python框架：django软件版本：python3.7/python3.8数据库：mysql 5.7或更高版本数据库工具：Navicat11开发软件：PyCharm/vs code前端框架:vue.js开发出一个小型学生信息管理系统，完成学生在校期间各类信息的管理工作﹐用户为航空大学科技学院管理

wqq6310855

2452人浏览 · 2022-05-29 21:01:25

wqq6310855 · 2022-05-29 21:01:25 发布

开发出一个小型学生信息管理系统，完成学生在校期间各类信息的管理工作﹐用户为航空大学科技学院管理员、教师和学生,用于各系学生教育管理工作中相关数据信息的处理。为学生处工作人员和各系辅导员提供迅速、高效服务﹐避免手工处理的繁琐和误差﹐及时、准确地处理学生的信息﹐提高工作效率。它通过集中式的信息数据库将各类档案信息管理功能结合起来﹐达到共享数据﹐降低成本﹐提高效率﹐改进服务等目的，实现学生信息管理工作的系统化、规化和自动化,同时为管理层的决策提供详尽的数据支持。系统的设计和开发应满足对学校学生信息管理的需要﹐并达到操作过程中的直观，方便，实用，安全等要求。系统采用模块化程序设计的方法，既便于系统功能的组合和修改﹐又便于补充和维护。在实际运用中,此系统可以作为航空大学科技学院校园管理系统的一个子系统，也可作为一个独立的系统来使用。本系统既有针对性,又有普适性,对于航空大学科技学院的学生管理工作有很强的实用性，也可适用于不同高校。
在这里插入图片描述

SET FOREIGN_KEY_CHECKS=0;

– Table structure for chongzhixinxi

DROP TABLE IF EXISTS chongzhixinxi;
CREATE TABLE chongzhixinxi (
id bigint(20) NOT NULL AUTO_INCREMENT,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
xuehao varchar(200) NOT NULL COMMENT ‘学号’,
xingming varchar(200) DEFAULT NULL COMMENT ‘姓名’,
jine int(11) NOT NULL COMMENT ‘金额’,
chongzhiriqi date DEFAULT NULL COMMENT ‘充值日期’,
ispay varchar(200) DEFAULT ‘未支付’ COMMENT ‘是否支付’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1606117658865 DEFAULT CHARSET=utf8 COMMENT=‘充值信息’;

– Records of chongzhixinxi

INSERT INTO chongzhixinxi VALUES (‘1’, ‘2020-11-23 15:09:14’, ‘学号1’, ‘姓名1’, ‘1’, ‘2020-11-23’, ‘未支付’);
INSERT INTO chongzhixinxi VALUES (‘2’, ‘2020-11-23 15:09:14’, ‘学号2’, ‘姓名2’, ‘2’, ‘2020-11-23’, ‘未支付’);
INSERT INTO chongzhixinxi VALUES (‘3’, ‘2020-11-23 15:09:14’, ‘学号3’, ‘姓名3’, ‘3’, ‘2020-11-23’, ‘未支付’);
INSERT INTO chongzhixinxi VALUES (‘1606115878005’, ‘2020-11-23 15:17:58’, ‘001’, ‘姓名3’, ‘1000’, ‘2020-11-23’, ‘已支付’);
INSERT INTO chongzhixinxi VALUES (‘1606117658864’, ‘2020-11-23 15:47:38’, ‘1’, ‘刘倩’, ‘500’, ‘2020-10-28’, ‘已支付’);

– Table structure for config

DROP TABLE IF EXISTS config;
CREATE TABLE config (
id bigint(20) NOT NULL AUTO_INCREMENT,
name varchar(100) NOT NULL COMMENT ‘配置参数名称’,
value varchar(100) DEFAULT NULL COMMENT ‘配置参数值’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT=‘配置文件’;

– Records of config

INSERT INTO config VALUES (‘1’, ‘picture1’, ‘http://localhost:8080/djangorx1y3/upload/picture1.jpg’);
INSERT INTO config VALUES (‘2’, ‘picture2’, ‘http://localhost:8080/djangorx1y3/upload/picture2.jpg’);
INSERT INTO config VALUES (‘3’, ‘picture3’, ‘http://localhost:8080/djangorx1y3/upload/picture3.jpg’);
INSERT INTO config VALUES (‘4’, ‘picture4’, ‘http://localhost:8080/djangorx1y3/upload/picture4.jpg’);
INSERT INTO config VALUES (‘5’, ‘picture5’, ‘http://localhost:8080/djangorx1y3/upload/picture5.jpg’);
INSERT INTO config VALUES (‘6’, ‘homepage’, null);

– Table structure for ganbuxinxi

DROP TABLE IF EXISTS ganbuxinxi;
CREATE TABLE ganbuxinxi (
id bigint(20) NOT NULL AUTO_INCREMENT,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
xuehao varchar(200) NOT NULL COMMENT ‘学号’,
xingming varchar(200) DEFAULT NULL COMMENT ‘姓名’,
banji varchar(200) DEFAULT NULL COMMENT ‘班级’,
zhiwei varchar(200) DEFAULT NULL COMMENT ‘职位’,
riqi date DEFAULT NULL COMMENT ‘日期’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1606117231387 DEFAULT CHARSET=utf8 COMMENT=‘干部信息’;

– Records of ganbuxinxi

INSERT INTO ganbuxinxi VALUES (‘1’, ‘2020-11-23 15:09:13’, ‘学号1’, ‘姓名1’, ‘班级1’, ‘职位1’, ‘2020-11-23’);
INSERT INTO ganbuxinxi VALUES (‘2’, ‘2020-11-23 15:09:13’, ‘学号2’, ‘姓名2’, ‘班级2’, ‘职位2’, ‘2020-11-23’);
INSERT INTO ganbuxinxi VALUES (‘3’, ‘2020-11-23 15:09:13’, ‘001’, ‘姓名3’, ‘班级3’, ‘职位3’, ‘2020-10-27’);
INSERT INTO ganbuxinxi VALUES (‘1606117231386’, ‘2020-11-23 15:40:31’, ‘1’, ‘刘倩’, ‘201’, ‘学习委员’, ‘2020-10-26’);

– Table structure for jiangjinleixing

DROP TABLE IF EXISTS jiangjinleixing;
CREATE TABLE jiangjinleixing (
id bigint(20) NOT NULL AUTO_INCREMENT,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
jiangjinleixing varchar(200) NOT NULL COMMENT ‘奖金类型’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1606117276061 DEFAULT CHARSET=utf8 COMMENT=‘奖金类型’;

– Records of jiangjinleixing

INSERT INTO jiangjinleixing VALUES (‘1’, ‘2020-11-23 15:09:13’, ‘奖金类型1’);
INSERT INTO jiangjinleixing VALUES (‘2’, ‘2020-11-23 15:09:13’, ‘国家奖学金’);
INSERT INTO jiangjinleixing VALUES (‘3’, ‘2020-11-23 15:09:13’, ‘助学金’);
INSERT INTO jiangjinleixing VALUES (‘1606117276060’, ‘2020-11-23 15:41:16’, ‘奖学金’);

– Table structure for jiangjinshenqing

DROP TABLE IF EXISTS jiangjinshenqing;
CREATE TABLE jiangjinshenqing (
id bigint(20) NOT NULL AUTO_INCREMENT,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
jiangjinmingcheng varchar(200) NOT NULL COMMENT ‘奖金名称’,
jiangjinleixing varchar(200) DEFAULT NULL COMMENT ‘奖金类型’,
jine varchar(200) DEFAULT NULL COMMENT ‘金额’,
shenqingliyou longtext COMMENT ‘申请理由’,
shenqingriqi date DEFAULT NULL COMMENT ‘申请日期’,
xuehao varchar(200) DEFAULT NULL COMMENT ‘学号’,
sfsh varchar(200) DEFAULT ‘否’ COMMENT ‘是否审核’,
shhf longtext COMMENT ‘审核回复’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1606117547293 DEFAULT CHARSET=utf8 COMMENT=‘奖金申请’;

– Records of jiangjinshenqing

INSERT INTO jiangjinshenqing VALUES (‘1’, ‘2020-11-23 15:09:13’, ‘奖金名称1’, ‘奖金类型1’, ‘金额1’, ‘申请理由1’, ‘2020-11-23’, ‘学号1’, ‘否’, ‘’);
INSERT INTO jiangjinshenqing VALUES (‘2’, ‘2020-11-23 15:09:13’, ‘奖金名称2’, ‘奖金类型2’, ‘金额2’, ‘申请理由2’, ‘2020-11-23’, ‘学号2’, ‘否’, ‘’);
INSERT INTO jiangjinshenqing VALUES (‘3’, ‘2020-11-23 15:09:13’, ‘奖金名称3’, ‘奖金类型3’, ‘金额3’, ‘申请理由3’, ‘2020-11-23’, ‘学号3’, ‘否’, ‘’);
INSERT INTO jiangjinshenqing VALUES (‘1606115797133’, ‘2020-11-23 15:16:37’, ‘奖金名称2’, ‘奖金类型2’, ‘2’, ‘32323’, ‘2020-10-27’, ‘001’, null, ‘’);
INSERT INTO jiangjinshenqing VALUES (‘1606117547292’, ‘2020-11-23 15:45:47’, ‘国家给贫困学生资助’, ‘助学金’, ‘50000’, ‘属于贫困生，特此申请’, ‘2020-10-26’, ‘1’, ‘是’, ‘经过查看，信息属实，同意申请’);

– Table structure for jiangjinxinxi

DROP TABLE IF EXISTS jiangjinxinxi;
CREATE TABLE jiangjinxinxi (
id bigint(20) NOT NULL AUTO_INCREMENT,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
jiangjinmingcheng varchar(200) NOT NULL COMMENT ‘奖金名称’,
jiangjinleixing varchar(200) NOT NULL COMMENT ‘奖金类型’,
jine int(11) DEFAULT NULL COMMENT ‘金额’,
shenqingtiaojian longtext COMMENT ‘申请条件’,
faburiqi date DEFAULT NULL COMMENT ‘发布日期’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1606117361721 DEFAULT CHARSET=utf8 COMMENT=‘奖金信息’;

– Records of jiangjinxinxi

INSERT INTO jiangjinxinxi VALUES (‘1’, ‘2020-11-23 15:09:13’, ‘奖金名称1’, ‘奖金类型1’, ‘1’, ‘申请条件1’, ‘2020-11-23’);
INSERT INTO jiangjinxinxi VALUES (‘2’, ‘2020-11-23 15:09:13’, ‘奖金名称2’, ‘奖金类型2’, ‘2’, ‘申请条件2’, ‘2020-11-23’);
INSERT INTO jiangjinxinxi VALUES (‘3’, ‘2020-11-23 15:09:13’, ‘奖金名称3’, ‘奖金类型3’, ‘3’, ‘申请条件3’, ‘2020-11-23’);
INSERT INTO jiangjinxinxi VALUES (‘1606117361720’, ‘2020-11-23 15:42:41’, ‘国家给贫困学生资助’, ‘助学金’, ‘50000’, ‘属于农村户口的同学都可以享受这个待遇，可以凭借户口本到学校教务处领取’, ‘2020-10-25’);

– Table structure for kaoqinxinxi

DROP TABLE IF EXISTS kaoqinxinxi;
CREATE TABLE kaoqinxinxi (
id bigint(20) NOT NULL AUTO_INCREMENT,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
mingcheng varchar(200) NOT NULL COMMENT ‘名称’,
xuehao varchar(200) DEFAULT NULL COMMENT ‘学号’,
xingming varchar(200) DEFAULT NULL COMMENT ‘姓名’,
kaoqinriqi date DEFAULT NULL COMMENT ‘考勤日期’,
kaoqinzhuangkuang varchar(200) DEFAULT NULL COMMENT ‘考勤状况’,
beizhu longtext COMMENT ‘备注’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1606117448619 DEFAULT CHARSET=utf8 COMMENT=‘考勤信息’;

– Records of kaoqinxinxi

INSERT INTO kaoqinxinxi VALUES (‘1’, ‘2020-11-23 15:09:13’, ‘名称1’, ‘学号1’, ‘姓名1’, ‘2020-11-23’, ‘迟到’, ‘备注1’);
INSERT INTO kaoqinxinxi VALUES (‘2’, ‘2020-11-23 15:09:13’, ‘名称2’, ‘学号2’, ‘姓名2’, ‘2020-11-23’, ‘迟到’, ‘备注2’);
INSERT INTO kaoqinxinxi VALUES (‘3’, ‘2020-11-23 15:09:13’, ‘名称3’, ‘001’, ‘姓名3’, ‘2020-11-23’, ‘正常’, ‘备注3’);
INSERT INTO kaoqinxinxi VALUES (‘1606117448618’, ‘2020-11-23 15:44:08’, ‘1号考勤情况’, ‘1’, ‘刘倩’, ‘2020-10-25’, ‘迟到’, ‘今天迟到10分钟’);

– Table structure for kechengbiao

DROP TABLE IF EXISTS kechengbiao;
CREATE TABLE kechengbiao (
id bigint(20) NOT NULL AUTO_INCREMENT,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
mingcheng varchar(200) NOT NULL COMMENT ‘名称’,
kechengneirong longtext COMMENT ‘课程内容’,
kechengbiao varchar(200) DEFAULT NULL COMMENT ‘课程表’,
faburiqi date DEFAULT NULL COMMENT ‘发布日期’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1606117412648 DEFAULT CHARSET=utf8 COMMENT=‘课程表’;

– Records of kechengbiao

INSERT INTO kechengbiao VALUES (‘1’, ‘2020-11-23 15:09:13’, ‘名称1’, ‘课程内容1’, ‘课程表1’, ‘2020-11-23’);
INSERT INTO kechengbiao VALUES (‘2’, ‘2020-11-23 15:09:13’, ‘名称2’, ‘课程内容2’, ‘课程表2’, ‘2020-11-23’);
INSERT INTO kechengbiao VALUES (‘3’, ‘2020-11-23 15:09:13’, ‘名称3’, ‘课程内容3’, ‘http://localhost:8080/djangorx1y3/upload/1606123015820.doc’, ‘2020-11-23’);
INSERT INTO kechengbiao VALUES (‘1606117412647’, ‘2020-11-23 15:43:32’, ‘星期一课程表’, ‘以文档的形式发布，第一节课数学，第二节英语，第三节化学，，，’, ‘http://localhost:8080/djangorx1y3/upload/1606118638098.doc’, ‘2020-10-26’);

– Table structure for qingjiaxinxi

DROP TABLE IF EXISTS qingjiaxinxi;
CREATE TABLE qingjiaxinxi (
id bigint(20) NOT NULL AUTO_INCREMENT,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
mingcheng varchar(200) NOT NULL COMMENT ‘名称’,
qingjianeirong longtext COMMENT ‘请假内容’,
qingjiariqi date DEFAULT NULL COMMENT ‘请假日期’,
qingjiatianshu varchar(200) DEFAULT NULL COMMENT ‘请假天数’,
xuehao varchar(200) DEFAULT NULL COMMENT ‘学号’,
xingming varchar(200) DEFAULT NULL COMMENT ‘姓名’,
sfsh varchar(200) DEFAULT ‘否’ COMMENT ‘是否审核’,
shhf longtext COMMENT ‘审核回复’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1606117644810 DEFAULT CHARSET=utf8 COMMENT=‘请假信息’;

– Records of qingjiaxinxi

INSERT INTO qingjiaxinxi VALUES (‘1’, ‘2020-11-23 15:09:13’, ‘名称1’, ‘请假内容1’, ‘2020-11-23’, ‘请假天数1’, ‘学号1’, ‘姓名1’, ‘否’, ‘’);
INSERT INTO qingjiaxinxi VALUES (‘2’, ‘2020-11-23 15:09:13’, ‘名称2’, ‘请假内容2’, ‘2020-11-23’, ‘请假天数2’, ‘学号2’, ‘姓名2’, ‘否’, ‘’);
INSERT INTO qingjiaxinxi VALUES (‘3’, ‘2020-11-23 15:09:13’, ‘名称3’, ‘请假内容3’, ‘2020-11-23’, ‘请假天数3’, ‘学号3’, ‘姓名3’, ‘否’, ‘’);
INSERT INTO qingjiaxinxi VALUES (‘1606115870195’, ‘2020-11-23 15:17:50’, ‘32323’, ‘2121’, ‘2020-10-27’, ‘3’, ‘001’, ‘姓名3’, null, ‘’);
INSERT INTO qingjiaxinxi VALUES (‘1606117644809’, ‘2020-11-23 15:47:24’, ‘今天想请假’, ‘今天生病了想请假’, ‘2020-10-26’, ‘3’, ‘1’, ‘刘倩’, ‘是’, ‘同意请假，早日恢复健康回来上课’);

– Table structure for users

DROP TABLE IF EXISTS users;
CREATE TABLE users (
id bigint(20) NOT NULL AUTO_INCREMENT,
username varchar(100) NOT NULL COMMENT ‘用户名’,
password varchar(100) NOT NULL COMMENT ‘密码’,
role varchar(100) DEFAULT ‘管理员’ COMMENT ‘角色’,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘新增时间’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT=‘用户表’;

– Records of users

INSERT INTO users VALUES (‘1’, ‘abo’, ‘abo’, ‘管理员’, ‘2020-11-23 15:09:14’);
INSERT INTO users VALUES (‘2’, ‘1’, ‘1’, ‘’, ‘2020-11-23 15:44:36’);

– Table structure for weijixinxi

DROP TABLE IF EXISTS weijixinxi;
CREATE TABLE weijixinxi (
id bigint(20) NOT NULL AUTO_INCREMENT,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
mingcheng varchar(200) NOT NULL COMMENT ‘名称’,
xuehao varchar(200) DEFAULT NULL COMMENT ‘学号’,
xingming varchar(200) DEFAULT NULL COMMENT ‘姓名’,
weijidengji longtext COMMENT ‘违纪登记’,
riqi date DEFAULT NULL COMMENT ‘日期’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1606117263590 DEFAULT CHARSET=utf8 COMMENT=‘违纪信息’;

– Records of weijixinxi

INSERT INTO weijixinxi VALUES (‘1’, ‘2020-11-23 15:09:13’, ‘名称1’, ‘学号1’, ‘姓名1’, ‘违纪登记1’, ‘2020-11-23’);
INSERT INTO weijixinxi VALUES (‘2’, ‘2020-11-23 15:09:13’, ‘名称2’, ‘学号2’, ‘姓名2’, ‘违纪登记2’, ‘2020-11-23’);
INSERT INTO weijixinxi VALUES (‘3’, ‘2020-11-23 15:09:13’, ‘名称3’, ‘001’, ‘姓名3’, ‘违纪登记3’, ‘2020-11-23’);
INSERT INTO weijixinxi VALUES (‘1606117263589’, ‘2020-11-23 15:41:03’, ‘上课不专心，看小说’, ‘1’, ‘刘倩’, ‘上课不认真听讲看小说’, ‘2020-10-26’);

– Table structure for xiaofeixinxi

DROP TABLE IF EXISTS xiaofeixinxi;
CREATE TABLE xiaofeixinxi (
id bigint(20) NOT NULL AUTO_INCREMENT,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
biaoti varchar(200) NOT NULL COMMENT ‘标题’,
xuehao varchar(200) DEFAULT NULL COMMENT ‘学号’,
xingming varchar(200) DEFAULT NULL COMMENT ‘姓名’,
jine int(11) DEFAULT NULL COMMENT ‘金额’,
beizhu longtext COMMENT ‘备注’,
xiaofeiriqi date DEFAULT NULL COMMENT ‘消费日期’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1606117716297 DEFAULT CHARSET=utf8 COMMENT=‘消费信息’;

– Records of xiaofeixinxi

INSERT INTO xiaofeixinxi VALUES (‘1’, ‘2020-11-23 15:09:14’, ‘标题1’, ‘学号1’, ‘姓名1’, ‘1’, ‘备注1’, ‘2020-11-23’);
INSERT INTO xiaofeixinxi VALUES (‘2’, ‘2020-11-23 15:09:14’, ‘标题2’, ‘学号2’, ‘姓名2’, ‘2’, ‘备注2’, ‘2020-11-23’);
INSERT INTO xiaofeixinxi VALUES (‘3’, ‘2020-11-23 15:09:14’, ‘标题3’, ‘学号3’, ‘姓名3’, ‘3’, ‘备注3’, ‘2020-11-23’);
INSERT INTO xiaofeixinxi VALUES (‘1606115910770’, ‘2020-11-23 15:18:30’, ‘121’, ‘001’, ‘姓名3’, ‘500’, ‘212’, ‘2020-10-28’);
INSERT INTO xiaofeixinxi VALUES (‘1606117716296’, ‘2020-11-23 15:48:36’, ‘吃饭消费’, ‘1’, ‘刘倩’, ‘30’, ‘饭堂点餐’, ‘2020-10-25’);

– Table structure for xiaoyuankaxinxi

DROP TABLE IF EXISTS xiaoyuankaxinxi;
CREATE TABLE xiaoyuankaxinxi (
id bigint(20) NOT NULL AUTO_INCREMENT,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
mingcheng varchar(200) NOT NULL COMMENT ‘名称’,
xuehao varchar(200) DEFAULT NULL COMMENT ‘学号’,
xingming varchar(200) DEFAULT NULL COMMENT ‘姓名’,
jine int(11) DEFAULT NULL COMMENT ‘金额’,
banliriqi date DEFAULT NULL COMMENT ‘办理日期’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1606117468963 DEFAULT CHARSET=utf8 COMMENT=‘校园卡信息’;

– Records of xiaoyuankaxinxi

INSERT INTO xiaoyuankaxinxi VALUES (‘1’, ‘2020-11-23 15:09:14’, ‘名称1’, ‘001’, ‘姓名3’, ‘501’, ‘2020-11-23’);
INSERT INTO xiaoyuankaxinxi VALUES (‘2’, ‘2020-11-23 15:09:14’, ‘名称2’, ‘学号2’, ‘姓名2’, ‘2’, ‘2020-11-23’);
INSERT INTO xiaoyuankaxinxi VALUES (‘3’, ‘2020-11-23 15:09:14’, ‘名称3’, ‘学号3’, ‘姓名3’, ‘3’, ‘2020-11-23’);
INSERT INTO xiaoyuankaxinxi VALUES (‘1606117468962’, ‘2020-11-23 15:44:28’, ‘一卡通’, ‘1’, ‘刘倩’, ‘470’, ‘2020-10-27’);

– Table structure for xuejixinxi

DROP TABLE IF EXISTS xuejixinxi;
CREATE TABLE xuejixinxi (
id bigint(20) NOT NULL AUTO_INCREMENT,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
xuehao varchar(200) NOT NULL COMMENT ‘学号’,
xingming varchar(200) DEFAULT NULL COMMENT ‘姓名’,
xingbie varchar(200) DEFAULT NULL COMMENT ‘性别’,
minzu varchar(200) DEFAULT NULL COMMENT ‘民族’,
xueyuan varchar(200) DEFAULT NULL COMMENT ‘学院’,
nianji varchar(200) DEFAULT NULL COMMENT ‘年级’,
banji varchar(200) DEFAULT NULL COMMENT ‘班级’,
zhuanye varchar(200) DEFAULT NULL COMMENT ‘专业’,
shenfenzheng varchar(200) DEFAULT NULL COMMENT ‘身份证’,
shouji varchar(200) DEFAULT NULL COMMENT ‘手机’,
ruxueriqi date DEFAULT NULL COMMENT ‘入学日期’,
beizhu longtext COMMENT ‘备注’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1606117215750 DEFAULT CHARSET=utf8 COMMENT=‘学籍信息’;

– Records of xuejixinxi

INSERT INTO xuejixinxi VALUES (‘1’, ‘2020-11-23 15:09:13’, ‘学号1’, ‘姓名1’, ‘性别1’, ‘民族1’, ‘学院1’, ‘年级1’, ‘班级1’, ‘专业1’, ‘440300199101010001’, ‘13823888881’, ‘2020-11-23’, ‘备注1’);
INSERT INTO xuejixinxi VALUES (‘2’, ‘2020-11-23 15:09:13’, ‘学号2’, ‘姓名2’, ‘性别2’, ‘民族2’, ‘学院2’, ‘年级2’, ‘班级2’, ‘专业2’, ‘440300199202020002’, ‘13823888882’, ‘2020-11-23’, ‘备注2’);
INSERT INTO xuejixinxi VALUES (‘3’, ‘2020-11-23 15:09:13’, ‘学号3’, ‘姓名3’, ‘性别3’, ‘民族3’, ‘学院3’, ‘年级3’, ‘班级3’, ‘专业3’, ‘440300199303030003’, ‘13823888883’, ‘2020-11-23’, ‘备注3’);
INSERT INTO xuejixinxi VALUES (‘1606117215749’, ‘2020-11-23 15:40:15’, ‘1’, ‘刘倩’, ‘女’, ‘汉族’, ‘上海大学’, ‘大二’, ‘201’, ‘计算机’, ‘441214121412141214’, ‘15214121412’, ‘2020-10-27’, ‘学校成绩优异。品德高尚。’);

– Table structure for xuesheng

DROP TABLE IF EXISTS xuesheng;
CREATE TABLE xuesheng (
id bigint(20) NOT NULL AUTO_INCREMENT,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
xuehao varchar(200) NOT NULL COMMENT ‘学号’,
mima varchar(200) NOT NULL COMMENT ‘密码’,
xingming varchar(200) DEFAULT NULL COMMENT ‘姓名’,
xingbie varchar(200) DEFAULT NULL COMMENT ‘性别’,
touxiang varchar(200) DEFAULT NULL COMMENT ‘头像’,
PRIMARY KEY (id),
UNIQUE KEY xuehao (xuehao)
) ENGINE=InnoDB AUTO_INCREMENT=1606117142747 DEFAULT CHARSET=utf8 COMMENT=‘学生’;

– Records of xuesheng

INSERT INTO xuesheng VALUES (‘1’, ‘2020-11-23 15:09:13’, ‘学生1’, ‘123456’, ‘姓名1’, ‘男’, ‘http://localhost:8080/djangorx1y3/upload/xuesheng_touxiang1.jpg’);
INSERT INTO xuesheng VALUES (‘2’, ‘2020-11-23 15:09:13’, ‘学生2’, ‘123456’, ‘姓名2’, ‘男’, ‘http://localhost:8080/djangorx1y3/upload/xuesheng_touxiang2.jpg’);
INSERT INTO xuesheng VALUES (‘3’, ‘2020-11-23 15:09:13’, ‘001’, ‘001’, ‘李明’, ‘男’, ‘http://localhost:8080/djangorx1y3/upload/xuesheng_touxiang3.jpg’);
INSERT INTO xuesheng VALUES (‘1606117142746’, ‘2020-11-23 15:39:02’, ‘1’, ‘1’, ‘谢俞’, ‘女’, ‘http://localhost:8080/djangorx1y3/upload/1606117508094.png’);