响应式网站建设价位_鄂州市鄂城区政府网_成都服务器idc托管_浙江致居软装设计有限公司

```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}```

上海环球金融中心多少层广东东莞疫情严重吗漳州十大建筑模板厂家搜索引擎优化涉及到内容电子商务平台内经营者享有公平交易的权利企业服务入口语音app开发云南网上工商办事大厅免费网站站长推广网页制作素材1001无标题北京市建设工程信息网交易网站wap手机云兰装潢公司总部地址电话郴州网站建设系统在线网站建设询问报价湛江网站设计公司地址设计电影完整版视频在线筑龙网建筑资料下载上海有什么互联网公司网页开发视频教程邯郸市出租房屋信息网推广模式怎么写电商设计助理面试问题详情页设计善用什么公共资源交易中心是事业单位吗西安人才网官网最好看的免费观看视频企业服务方案网页设计与制作教程 pdf中小企业网络客户服务存在的问题及改进策略手机网络不稳定