python语言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  # 数据库的端口
    }
}

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 */;

以上两种方法二选一即可

8.启动项目

1.手动启动
执行命令：
python manage.py runserver
2.自动启动
在这里插入图片描述