# assess_system_backend

**Repository Path**: blue-gate7/assess_system_backend

## Basic Information

- **Project Name**: assess_system_backend
- **Description**: 敏捷开发-学生综合测评系统后端
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 6
- **Created**: 2023-05-16
- **Last Updated**: 2023-12-29

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 学生评测后端项目

**note:**运行前调整application.yaml中的数据库配置信息


### SQL语句

```SQL
# 建立数据库

create database assessment_system;

use assessment_system;

# 建立学生信息表、用户表、汇总表

CREATE TABLE assessment_system.studentinfo (
	student_id varchar(100) NOT null primary key,
	name varchar(100) NOT NULL,
	volunteer_hour int NOT NULL,
	gpa double NOT NULL
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4;

CREATE TABLE assessment_system.`user` (
	id varchar(100) NOT null primary key,
	password varchar(100) NOT NULL,
	`type` enum('stu','stuwork','teacher') NOT NULL,
	name varchar(100) NOT NULL
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4;

# 在学生信息表和用户表中插入信息

insert into studentinfo (student_id, name, volunteer_hour, gpa)
values ('001','Alice', 10, 3.5),
('002','Bob', 7, 3.6),
('003','Cathy', 15, 3.4);

insert into `user` (id, password, `type`, name)
values ('001', '001', 'stu', 'Alice'),
('002', '002', 'stu', 'Bob'),
('003', '003', 'stu', 'Cathy'),
('004', '004', 'stuwork', 'Admin1'),
('005', '005', 'stuwork', 'Admin2'),
('006', '006', 'teacher', 'Teacher1'),
('007', '007', 'teacher', 'Teacher2');

# 建立科研情况、骨干服务、社会实践三张大表

CREATE TABLE assessment_system.research (
	research_id int NOT null primary key auto_increment,
	student_id varchar(100) NOT NULL,
	`date` varchar(100) NOT NULL,
	prize varchar(100) NOT NULL,
	place varchar(100) NOT NULL
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4;

CREATE TABLE assessment_system.service (
	service_id int not null primary key auto_increment,
	student_id varchar(100) NOT NULL,
	`date` varchar(100) NOT NULL,
	job_name varchar(100) NOT NULL,
	job_content varchar(100) NOT NULL,
	`level` varchar(100) NOT NULL
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4;

CREATE TABLE assessment_system.practice (
	service_id int not null primary key auto_increment,
	student_id varchar(100) NOT NULL,
	organization varchar(100) NOT NULL,
	location varchar(100) NOT NULL,
	duration int NOT NULL,
	member_number int NOT NULL,
	job_content varchar(100) NOT NULL,
	online enum('yes','no') NOT NULL,
	prize_or_not enum('yes','no') NOT NULL,
	prize varchar(100) NULL
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4;


```