# ************************************************************
# Sequel Pro SQL dump
# Version 5446
#
# https://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 127.0.0.1 (MySQL 8.0.23)
# Database: poorstudent
# Generation Time: 2022-11-25 08:23:56 +0000
# ************************************************************
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
SET NAMES utf8mb4;
/*!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 */;
# Dump of table hard
# ------------------------------------------------------------
DROP TABLE IF EXISTS `hard`;
CREATE TABLE `hard` (
`hard_id` int unsigned NOT NULL AUTO_INCREMENT,
`hard_reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`hard_result` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`student_id` int unsigned DEFAULT NULL,
PRIMARY KEY (`hard_id`) USING BTREE,
KEY `hard_ibfk_1` (`student_id`) USING BTREE,
CONSTRAINT `hard_ibfk_1` FOREIGN KEY (`student_id`) REFERENCES `student` (`student_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
LOCK TABLES `hard` WRITE;
/*!40000 ALTER TABLE `hard` DISABLE KEYS */;
INSERT INTO `hard` (`hard_id`, `hard_reason`, `hard_result`, `student_id`)
VALUES
(7,'aaaa','通过',5);
/*!40000 ALTER TABLE `hard` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table resource
# ------------------------------------------------------------
DROP TABLE IF EXISTS `resource`;
CREATE TABLE `resource` (
`resource_id` int unsigned NOT NULL AUTO_INCREMENT,
`resource_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`resource_time` datetime DEFAULT NULL,
`resource_info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`resource_level` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`resource_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
LOCK TABLES `resource` WRITE;
/*!40000 ALTER TABLE `resource` DISABLE KEYS */;
INSERT INTO `resource` (`resource_id`, `resource_name`, `resource_time`, `resource_info`, `resource_level`)
VALUES
(2,'院级奖学金','2021-01-06 14:22:22','简介','院校'),
(3,'国家奖学金','2021-01-07 16:23:42','国家奖','国家'),
(4,'社会援助','2021-01-14 16:50:34','社会援助','社会'),
(5,'社会援助2','2020-12-16 16:50:53','社会116','社会'),
(7,'我的援助','2021-02-04 15:08:57','我的援助,\r\n非常长非常长非常长非常长非常长非常长非常长非常长非常长非常长非常长非常长非常长非常长非常长非常长非常长非常长非常长非常长非常长','社会');
/*!40000 ALTER TABLE `resource` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table student
# ------------------------------------------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`student_id` int unsigned NOT NULL AUTO_INCREMENT,
`student_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`student_sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`student_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`student_cardid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`student_year` int DEFAULT NULL,
`student_education` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`student_department` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`student_class` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`student_population` int DEFAULT NULL,
`student_res` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`user_id` int unsigned DEFAULT NULL,
`special_oad` bit(1) DEFAULT NULL,
`special_sp` bit(1) DEFAULT NULL,
`special_com` bit(1) DEFAULT NULL,
`special_fo` bit(1) DEFAULT NULL,
`special_sa` bit(1) DEFAULT NULL,
PRIMARY KEY (`student_id`) USING BTREE,
KEY `student_ibfk_1` (`user_id`) USING BTREE,
CONSTRAINT `student_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
LOCK TABLES `student` WRITE;
/*!40000 ALTER TABLE `student` DISABLE KEYS */;
INSERT INTO `student` (`student_id`, `student_name`, `student_sex`, `student_number`, `student_cardid`, `student_year`, `student_education`, `student_department`, `student_class`, `student_population`, `student_res`, `user_id`, `special_oad`, `special_sp`, `special_com`, `special_fo`, `special_sa`)
VALUES
(5,'小明','男','006','420982165412453564',2022,'专科','马术学院','(3)班',4,'城市户口',1,b'0',b'1',b'1',b'0',b'0'),
(7,'测试1','男','011','420982165412453561',2022,'专科','信息工程学院','(4)班',3,'城市户口',NULL,b'1',b'0',b'1',b'1',b'0'),
(8,'测试2','女','012','420982165412453562',2022,'本科','信息工程学院','(2)班',2,'城市户口',NULL,b'0',b'1',b'1',b'0',b'0'),
(9,'测试3','男','013','420982165412453563',2022,'本科','信息工程学院','(1)班',2,'农村户口',NULL,b'1',b'0',b'1',b'1',b'0'),
(10,'测试4','女','014','420982165412453565',2022,'本科','信息工程学院','(1)班',1,'农村户口',NULL,b'0',b'1',b'0',b'1',b'1');
/*!40000 ALTER TABLE `student` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table support
# ------------------------------------------------------------
DROP TABLE IF EXISTS `support`;
CREATE TABLE `support` (
`support_id` int unsigned NOT NULL AUTO_INCREMENT,
`resource_id` int unsigned DEFAULT NULL,
`student_id` int unsigned DEFAULT NULL,
`support_result` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`support_id`) USING BTREE,
KEY `support_ibfk_1` (`resource_id`) USING BTREE,
KEY `support_ibfk_2` (`student_id`) USING BTREE,
CONSTRAINT `support_ibfk_1` FOREIGN KEY (`resource_id`) REFERENCES `resource` (`resource_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `support_ibfk_2` FOREIGN KEY (`student_id`) REFERENCES `student` (`student_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
LOCK TABLES `support` WRITE;
/*!40000 ALTER TABLE `support` DISABLE KEYS */;
INSERT INTO `support` (`support_id`, `resource_id`, `student_id`, `support_result`)
VALUES
(10,3,5,'未通过'),
(21,2,5,'待认定'),
(24,7,5,'通过'),
(26,4,5,'待认定'),
(29,5,5,'待认定');
/*!40000 ALTER TABLE `support` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table user
# ------------------------------------------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`user_id` int unsigned NOT NULL AUTO_INCREMENT,
`user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`user_password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`user_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`user_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`user_role` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` (`user_id`, `user_name`, `user_password`, `user_phone`, `user_email`, `user_role`)
VALUES
(1,'student','57b015dd4f2422d2ee44115d90ef710e','15971253779','1432721789@qq.com','学生'),
(3,'t','57b015dd4f2422d2ee44115d90ef710e','15971253779','1432721789@qq.com','资助管理�