MySQL数据库设计：学生奖项、毕业信息和专业技能表
CREATE TABLE awards (
id int(11) NOT NULL AUTO_INCREMENT,
student_id int(11) NOT NULL,
award_type varchar(50) NOT NULL,
award_year int(11) NOT NULL,
disciplinary_action tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (id),
FOREIGN KEY (student_id) REFERENCES students(id)
);
CREATE TABLE graduation (
id int(11) NOT NULL AUTO_INCREMENT,
student_id int(11) NOT NULL,
year int(11) NOT NULL,
is_excellent tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (id),
FOREIGN KEY (student_id) REFERENCES students(id)
);
CREATE TABLE skills (
id int(11) NOT NULL AUTO_INCREMENT,
student_id int(11) NOT NULL,
skill varchar(50) NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY (student_id) REFERENCES students(id)
);
CREATE TABLE students (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(50) NOT NULL,
major varchar(50) NOT NULL,
PRIMARY KEY (id)
);
原文地址: https://www.cveoy.top/t/topic/oba9 著作权归作者所有。请勿转载和采集!