python语言Django框架搭建学生信息管理系统_django创建一个信息平台

1.系统介绍

本系统是基于Django 2.2.3开发的，面向学生信息管理系统。

系统以学生个体为核心向外拓展诸如宿舍、班级、学生组织等一系列组，诸如请假、签到、通知发布等一系列应用。

计划内实现功能有：班级、学生、宿舍三大项为基础的信息管理系统，早检、晨跑、卫检及相应结果查询系统，通知按组发布、公告发布为主的信息发布平台， 课表查询、成绩查询、校园卡流水查询、竞赛通知查询、竞赛组队、图书馆借阅查询、考试安排查询、校内信息发布等一系列功能的整合的学生端应用。

现已初步完成班级、学生、宿舍三大基础模型的搭建、学生事件记录、晨跑统计及查询系统。

注意事项
由于系统以学生、班级、宿舍三大模型为基础，使用系统时应当先对信息进行导入操作，确保导入成功后再进行其他操作。

导入时建议先将班级、宿舍信息导入并确认无误后在对学生信息进行导入。

2.系统思维导图

3.系统成果展示：

4. 环境搭建

安装Django version 2.2.7版本，和依赖包，切记版本需要对得上。
如果遇见版本问题，不懂如何安装的，可以咸鱼下单咨询：
【闲鱼】https://m.tb.cn/h.UR01X7p?tk=3rY2d3oxlU3 CZ0001 「我在闲鱼发布了【python编程解答，需要联系，价格优惠【老客户专属】】」
点击链接直接打开

5.源码百度网盘地址：

链接：https://pan.baidu.com/s/1og4JF6qTyMQ-UFARJ2dpsg?pwd=8dsf
提取码：8dsf
–来自百度网盘超级会员V5的分享

6.数据库配置：

可以更改成自己的数据库地址，只需要更改settings.py的数据库配置

DATABASES = {
    # 'default': {
    #     # 'ENGINE': 'django.db.backends.sqlite3',  # Django 默认的数据库为sqlite3
    #     # 指定数据库引擎
    #     'ENGINE': 'django.db.backends.mysql',
    #     # 指定数据库名
    #     'NAME': 'dev3',
    #     # 数据数据用户名
    #     'USER': 'root',
    #     'PASSWORD': 'python',  # 数据库密码
    #     'HOST': '1.15.135.116',  # 数据库主机域名或者ip
    #     'PORT': 3306  # 数据库的端口
    # },
    'default': {
        # 'ENGINE': 'django.db.backends.sqlite3',  # Django 默认的数据库为sqlite3
        # 指定数据库引擎
        'ENGINE': 'django.db.backends.mysql',
        # 指定数据库名
        'NAME': 'Django_light',
        # 数据数据用户名
        'USER': 'light',
        'PASSWORD': '123456',  # 数据库密码
        'HOST': '121.5.58.73',  # 数据库主机域名或者ip
        'PORT': 3306  # 数据库的端口
    }
}
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

7.mysql表创建

1.自动生成

执行 makemigrations

再执行

表自动创建成功

2. 手动创建，执行SQL

/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.7.40 : Database - test_student
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`test_student` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;

USE `test_student`;

/*Table structure for table `auth_group` */

DROP TABLE IF EXISTS `auth_group`;

CREATE TABLE `auth_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `auth_group` */

/*Table structure for table `auth_group_permissions` */

DROP TABLE IF EXISTS `auth_group_permissions`;

CREATE TABLE `auth_group_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
  KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`),
  CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `auth_group_permissions` */

/*Table structure for table `auth_permission` */

DROP TABLE IF EXISTS `auth_permission`;

CREATE TABLE `auth_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_type_id` int(11) NOT NULL,
  `codename` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
  CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `auth_permission` */

insert  into `auth_permission`(`id`,`name`,`content_type_id`,`codename`) values (1,'Can add log entry',1,'add_logentry'),(2,'Can change log entry',1,'change_logentry'),(3,'Can delete log entry',1,'delete_logentry'),(4,'Can view log entry',1,'view_logentry'),(5,'Can add permission',2,'add_permission'),(6,'Can change permission',2,'change_permission'),(7,'Can delete permission',2,'delete_permission'),(8,'Can view permission',2,'view_permission'),(9,'Can add group',3,'add_group'),(10,'Can change group',3,'change_group'),(11,'Can delete group',3,'delete_group'),(12,'Can view group',3,'view_group'),(13,'Can add user',4,'add_user'),(14,'Can change user',4,'change_user'),(15,'Can delete user',4,'delete_user'),(16,'Can view user',4,'view_user'),(17,'Can add content type',5,'add_contenttype'),(18,'Can change content type',5,'change_contenttype'),(19,'Can delete content type',5,'delete_contenttype'),(20,'Can view content type',5,'view_contenttype'),(21,'Can add session',6,'add_session'),(22,'Can change session',6,'change_session'),(23,'Can delete session',6,'delete_session'),(24,'Can view session',6,'view_session'),(25,'Can add Class',7,'add_class'),(26,'Can change Class',7,'change_class'),(27,'Can delete Class',7,'delete_class'),(28,'Can view Class',7,'view_class'),(29,'Can add Dormitory',8,'add_dormitory'),(30,'Can change Dormitory',8,'change_dormitory'),(31,'Can delete Dormitory',8,'delete_dormitory'),(32,'Can view Dormitory',8,'view_dormitory'),(33,'Can add Live',9,'add_live'),(34,'Can change Live',9,'change_live'),(35,'Can delete Live',9,'delete_live'),(36,'Can view Live',9,'view_live'),(37,'Can add Student',10,'add_student'),(38,'Can change Student',10,'change_student'),(39,'Can delete Student',10,'delete_student'),(40,'Can view Student',10,'view_student'),(41,'Can add representative',11,'add_representative'),(42,'Can change representative',11,'change_representative'),(43,'Can delete representative',11,'delete_representative'),(44,'Can view representative',11,'view_representative'),(45,'Can add 学生事件',12,'add_event'),(46,'Can change 学生事件',12,'change_event'),(47,'Can delete 学生事件',12,'delete_event'),(48,'Can view 学生事件',12,'view_event'),(49,'Can add 请假',13,'add_takeleave'),(50,'Can change 请假',13,'change_takeleave'),(51,'Can delete 请假',13,'delete_takeleave'),(52,'Can view 请假',13,'view_takeleave'),(53,'Can add 考勤',14,'add_attendance'),(54,'Can change 考勤',14,'change_attendance'),(55,'Can delete 考勤',14,'delete_attendance'),(56,'Can view 考勤',14,'view_attendance');

/*Table structure for table `auth_user` */

DROP TABLE IF EXISTS `auth_user`;

CREATE TABLE `auth_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `password` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_login` datetime(6) DEFAULT NULL,
  `is_superuser` tinyint(1) NOT NULL,
  `username` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `first_name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_staff` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `date_joined` datetime(6) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `auth_user` */

/*Table structure for table `auth_user_groups` */

DROP TABLE IF EXISTS `auth_user_groups`;

CREATE TABLE `auth_user_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_user_groups_user_id_group_id_94350c0c_uniq` (`user_id`,`group_id`),
  KEY `auth_user_groups_group_id_97559544_fk_auth_group_id` (`group_id`),
  CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
  CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `auth_user_groups` */

/*Table structure for table `auth_user_user_permissions` */

DROP TABLE IF EXISTS `auth_user_user_permissions`;

CREATE TABLE `auth_user_user_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` (`user_id`,`permission_id`),
  KEY `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` (`permission_id`),
  CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `auth_user_user_permissions` */

/*Table structure for table `django_admin_log` */

DROP TABLE IF EXISTS `django_admin_log`;

CREATE TABLE `django_admin_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action_time` datetime(6) NOT NULL,
  `object_id` longtext COLLATE utf8mb4_unicode_ci,
  `object_repr` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `action_flag` smallint(5) unsigned NOT NULL,
  `change_message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_type_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
  KEY `django_admin_log_user_id_c564eba6_fk_auth_user_id` (`user_id`),
  CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
  CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `django_admin_log` */

/*Table structure for table `django_content_type` */

DROP TABLE IF EXISTS `django_content_type`;

CREATE TABLE `django_content_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app_label` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `django_content_type` */

insert  into `django_content_type`(`id`,`app_label`,`model`) values (1,'admin','logentry'),(3,'auth','group'),(2,'auth','permission'),(4,'auth','user'),(5,'contenttypes','contenttype'),(7,'infosys','class'),(8,'infosys','dormitory'),(12,'infosys','event'),(9,'infosys','live'),(11,'infosys','representative'),(10,'infosys','student'),(14,'runningattendance','attendance'),(13,'runningattendance','takeleave'),(6,'sessions','session');

/*Table structure for table `django_migrations` */

DROP TABLE IF EXISTS `django_migrations`;

CREATE TABLE `django_migrations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `applied` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `django_migrations` */

insert  into `django_migrations`(`id`,`app`,`name`,`applied`) values (1,'contenttypes','0001_initial','2022-12-13 07:43:00.493366'),(2,'auth','0001_initial','2022-12-13 07:43:01.573289'),(3,'admin','0001_initial','2022-12-13 07:43:03.308731'),(4,'admin','0002_logentry_remove_auto_add','2022-12-13 07:43:03.737754'),(5,'admin','0003_logentry_add_action_flag_choices','2022-12-13 07:43:03.943205'),(6,'contenttypes','0002_remove_content_type_name','2022-12-13 07:43:04.344238'),(7,'auth','0002_alter_permission_name_max_length','2022-12-13 07:43:04.487420'),(8,'auth','0003_alter_user_email_max_length','2022-12-13 07:43:04.592147'),(9,'auth','0004_alter_user_username_opts','2022-12-13 07:43:04.658967'),(10,'auth','0005_alter_user_last_login_null','2022-12-13 07:43:04.790615'),(11,'auth','0006_require_contenttypes_0002','2022-12-13 07:43:04.854448'),(12,'auth','0007_alter_validators_add_error_messages','2022-12-13 07:43:04.922277'),(13,'auth','0008_alter_user_username_max_length','2022-12-13 07:43:05.060891'),(14,'auth','0009_alter_user_last_name_max_length','2022-12-13 07:43:05.204507'),(15,'auth','0010_alter_group_name_max_length','2022-12-13 07:43:05.300250'),(16,'auth','0011_update_proxy_permissions','2022-12-13 07:43:05.464814'),(17,'infosys','0001_initial','2022-12-13 07:43:06.927094'),(18,'infosys','0002_event_representative','2022-12-13 07:43:08.199231'),(19,'infosys','0003_remove_student_live_id','2022-12-13 07:43:08.998271'),(20,'runningattendance','0001_initial','2022-12-13 07:43:09.457274'),(21,'sessions','0001_initial','2022-12-13 07:43:09.943972');

/*Table structure for table `django_session` */

DROP TABLE IF EXISTS `django_session`;

CREATE TABLE `django_session` (
  `session_key` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `session_data` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expire_date` datetime(6) NOT NULL,
  PRIMARY KEY (`session_key`),
  KEY `django_session_expire_date_a5c62663` (`expire_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `django_session` */

/*Table structure for table `infosys_class` */

DROP TABLE IF EXISTS `infosys_class`;

CREATE TABLE `infosys_class` (
  `class_id` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `class_name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `grade` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
  `major` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `college` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`class_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `infosys_class` */

/*Table structure for table `infosys_dormitory` */

DROP TABLE IF EXISTS `infosys_dormitory`;

CREATE TABLE `infosys_dormitory` (
  `dormitory_id` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `building_num` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `room_num` varchar(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `floor` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `master_id` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`dormitory_id`),
  UNIQUE KEY `master_id` (`master_id`),
  CONSTRAINT `infosys_dormitory_master_id_861d5cd3_fk_infosys_live_live_id` FOREIGN KEY (`master_id`) REFERENCES `infosys_live` (`live_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `infosys_dormitory` */

/*Table structure for table `infosys_event` */

DROP TABLE IF EXISTS `infosys_event`;

CREATE TABLE `infosys_event` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `add_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `content` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `student_id` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `infosys_event_student_id_17f3924b_fk_infosys_student_student_id` (`student_id`),
  CONSTRAINT `infosys_event_student_id_17f3924b_fk_infosys_student_student_id` FOREIGN KEY (`student_id`) REFERENCES `infosys_student` (`student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `infosys_event` */

/*Table structure for table `infosys_live` */

DROP TABLE IF EXISTS `infosys_live`;

CREATE TABLE `infosys_live` (
  `live_id` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bed_num` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dormitory_id_id` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `student_id_id` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`live_id`),
  UNIQUE KEY `student_id_id` (`student_id_id`),
  KEY `infosys_live_dormitory_id_id_4d5a7ad5_fk_infosys_d` (`dormitory_id_id`),
  CONSTRAINT `infosys_live_dormitory_id_id_4d5a7ad5_fk_infosys_d` FOREIGN KEY (`dormitory_id_id`) REFERENCES `infosys_dormitory` (`dormitory_id`),
  CONSTRAINT `infosys_live_student_id_id_e342a0cd_fk_infosys_s` FOREIGN KEY (`student_id_id`) REFERENCES `infosys_student` (`student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `infosys_live` */

/*Table structure for table `infosys_representative` */

DROP TABLE IF EXISTS `infosys_representative`;

CREATE TABLE `infosys_representative` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `position` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `class_id_id` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `student_id` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `infosys_representati_class_id_id_862e5f0a_fk_infosys_c` (`class_id_id`),
  KEY `infosys_representati_student_id_570a46f8_fk_infosys_s` (`student_id`),
  CONSTRAINT `infosys_representati_class_id_id_862e5f0a_fk_infosys_c` FOREIGN KEY (`class_id_id`) REFERENCES `infosys_class` (`class_id`),
  CONSTRAINT `infosys_representati_student_id_570a46f8_fk_infosys_s` FOREIGN KEY (`student_id`) REFERENCES `infosys_student` (`student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `infosys_representative` */

/*Table structure for table `infosys_student` */

DROP TABLE IF EXISTS `infosys_student`;

CREATE TABLE `infosys_student` (
  `student_id` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `student_name` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `student_sex` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `student_birth` date DEFAULT NULL,
  `student_address` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `student_tel` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `student_qq` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `class_id_id` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`student_id`),
  KEY `infosys_student_class_id_id_cd284a58_fk_infosys_class_class_id` (`class_id_id`),
  CONSTRAINT `infosys_student_class_id_id_cd284a58_fk_infosys_class_class_id` FOREIGN KEY (`class_id_id`) REFERENCES `infosys_class` (`class_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `infosys_student` */

/*Table structure for table `runningattendance_attendance` */

DROP TABLE IF EXISTS `runningattendance_attendance`;

CREATE TABLE `runningattendance_attendance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `time` time(6) NOT NULL,
  `inspector_id` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `student_id` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `runningattendance_at_inspector_id_425c0f33_fk_infosys_s` (`inspector_id`),
  KEY `runningattendance_at_student_id_857cd6a4_fk_infosys_s` (`student_id`),
  CONSTRAINT `runningattendance_at_inspector_id_425c0f33_fk_infosys_s` FOREIGN KEY (`inspector_id`) REFERENCES `infosys_student` (`student_id`),
  CONSTRAINT `runningattendance_at_student_id_857cd6a4_fk_infosys_s` FOREIGN KEY (`student_id`) REFERENCES `infosys_student` (`student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `runningattendance_attendance` */

/*Table structure for table `runningattendance_takeleave` */

DROP TABLE IF EXISTS `runningattendance_takeleave`;

CREATE TABLE `runningattendance_takeleave` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `start` date NOT NULL,
  `end` date NOT NULL,
  `reason` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `inspector_id` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `student_id` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `runningattendance_ta_inspector_id_dcac2dee_fk_infosys_s` (`inspector_id`),
  KEY `runningattendance_ta_student_id_8dc4d4fb_fk_infosys_s` (`student_id`),
  CONSTRAINT `runningattendance_ta_inspector_id_dcac2dee_fk_infosys_s` FOREIGN KEY (`inspector_id`) REFERENCES `infosys_student` (`student_id`),
  CONSTRAINT `runningattendance_ta_student_id_8dc4d4fb_fk_infosys_s` FOREIGN KEY (`student_id`) REFERENCES `infosys_student` (`student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `runningattendance_takeleave` */

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340

以上两种方法二选一即可

8.启动项目

1.手动启动
执行命令：
python manage.py runserver
2.自动启动