思维导图![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/dc924a66df169b0ef995e48e5f7547af.png)
##在Navicat中创建数据库和表使用MySQL
##t_college表:
##t_status表:
##t_student:
##t_user:
##创建数据库,表和插入数据的代码如下:
/*
Navicat Premium Data Transfer
Source Server : localhost
Source Server Type : MySQL
Source Server Version : 50562
Source Host : localhost:3306
Source Schema : student
Target Server Type : MySQL
Target Server Version : 50562
File Encoding : 65001
Date: 01/07/2020 10:46:25
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for t_college
-- ----------------------------
DROP TABLE IF EXISTS `t_college`;
CREATE TABLE `t_college` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '学校名称',
`president` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '校长',
`start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '建校时间',
`telephone` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系电话',
`email` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL CO