广告营销有哪些_中国互联网信息中心_网页数据库系统怎么做_网站内部优化策略
```sql-- 创建学院表CREATE TABLE College (id INT PRIMARY KEY AUTO_INCREMENT,name VARCHAR(255) NOT NULL,description TEXT,create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,update_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);-- 创建专业表CREATE TABLE Major (id INT PRIMARY KEY AUTO_INCREMENT,college_id INT,name VARCHAR(255) NOT NULL,description TEXT,create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,update_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,FOREIGN KEY (college_id) REFERENCES College(id));-- 创建教师表CREATE TABLE Teacher (id INT PRIMARY KEY AUTO_INCREMENT,college_id INT,name VARCHAR(255) NOT NULL,age INT,email VARCHAR(255),phone VARCHAR(20),major_id INT,create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,update_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,FOREIGN KEY (college_id) REFERENCES College(id),FOREIGN KEY (major_id) REFERENCES Major(id));-- 创建学生表CREATE TABLE Student (id INT PRIMARY KEY AUTO_INCREMENT,college_id INT,name VARCHAR(255) NOT NULL,gender ENUM('M', 'F'),age INT,email VARCHAR(255),phone VARCHAR(20),create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,update_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,FOREIGN KEY (college_id) REFERENCES College(id));-- 创建课程表CREATE TABLE Course (id INT PRIMARY KEY AUTO_INCREMENT,college_id INT,name VARCHAR(255) NOT NULL,description TEXT,credits INT,teacher_id INT,create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,update_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,FOREIGN KEY (college_id) REFERENCES College(id),FOREIGN KEY (teacher_id) REFERENCES Teacher(id));-- 创建学生选课表CREATE TABLE StudentCourseRegistration (id INT PRIMARY KEY AUTO_INCREMENT,student_id INT,course_id INT,grade ENUM('A', 'B', 'C'),create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,update_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,FOREIGN KEY (student_id) REFERENCES Student(id),FOREIGN KEY (course_id) REFERENCES Course(id));```以上代码将创建名为"College"、"Major"、"Teacher"、"Student"、"Course"和"StudentCourseRegistration"的表,并定义了它们之间的外键关系。每个表都包含了相应的字段和属性,如字段名、说明、大小、类型、主键/外键等。基于Spring Boot的信息学院网站分析,以下是使用Java和Spring Boot编写的数据库表对应的类代码:```java// 学院类@Entity@Table(name = "college")public class College {@Id@GeneratedValue(strategy = GenerationType.IDENTITY)private int id;@Column(nullable = false, unique = true)private String name;@Column(nullable = false)private String description;@Column(name = "create_time", nullable = false)private LocalDateTime createTime;@Column(name = "update_time", nullable = false)private LocalDateTime updateTime;// Getters and Setters}// 专业类@Entity@Table(name = "major")public class Major {@Id@GeneratedValue(strategy = GenerationType.IDENTITY)private int id;@ManyToOne@JoinColumn(name = "college_id", nullable = false)private College college;@Column(nullable = false, unique = true)private String name;@Column(nullable = false)private String description;@Column(name = "create_time", nullable = false)private LocalDateTime createTime;@Column(name = "update_time", nullable = false)private LocalDateTime updateTime;// Getters and Setters}// 教师类@Entity@Table(name = "teacher")public class Teacher {@Id@GeneratedValue(strategy = GenerationType.IDENTITY)private int id;@ManyToOne@JoinColumn(name = "college_id", nullable = false)private College college;@Column(nullable = false, unique = true)private String name;@Column(nullable = false)private int age;@Column(nullable = false, length = 100)private String email;@Column(nullable = false, length = 15)private String phone;@ManyToOne@JoinColumn(name = "major_id", nullable = false)private Major major;@Column(name = "create_time", nullable = false)private LocalDateTime createTime;@Column(name = "update_time", nullable = false)private LocalDateTime updateTime;// Getters and Setters}// 学生类@Entity@Table(name = "student")public class Student {@Id@GeneratedValue(strategy = GenerationType.IDENTITY)private int id;@ManyToOne@JoinColumn(name = "college_id", nullable = false)private College college;@Column(nullable = false, unique = true)private String name;@Column(nullable = false)private String gender;@Column(nullable = false)private int age;@Column(nullable = false, length = 100)private String email;@Column(nullable = false, length = 15)private String phone;@ManyToOne@JoinColumn(name = "major_id", nullable = false)private Major major;@Column(name = "create_time", nullable = false)private LocalDateTime createTime;@Column(name = "update_time", nullable = false)private LocalDateTime updateTime;// Getters and Setters}// 课程类@Entity@Table(name = "course")public class Course {@Id@GeneratedValue(strategy = GenerationType.IDENTITY)private int id;@ManyToOne@JoinColumn(name = "college_id", nullable = false)private College college;@Column(nullable = false, unique = true)private String name;@Column(nullable = false)private String description;@Column(name = "credits", nullable = false)private int credits;@ManyToOne@JoinColumn(name = "teacher_id", nullable = false)private Teacher teacher;@Column(name = "create_time", nullable = false)private LocalDateTime createTime;@Column(name = "update_time", nullable = false)private LocalDateTime updateTime;// Getters and Setters}// 学生选课表类@Entity@Table(name = "student_course_registration")public class StudentCourseRegistration {@Id@GeneratedValue(strategy = GenerationType.IDENTITY)private int id;@ManyToOne@JoinColumn(name = "student_id", nullable = false)private Student student;@ManyToOne@JoinColumn(name = "course_id", nullable = false)private Course course;@Column(name = "grade", nullable = false)private String grade;@Column(name = "create_time", nullable = false)private LocalDateTime createTime;@Column(name = "update_time", nullable = false)private LocalDateTime updateTime;// Getters and Setters}```">