create table student
(
sno bigint auto_increment primary key,
sname varchar(10),
sex char(2),
birthday date,
native_place varchar(10),
cname varchar(20),
spname varchar(20),
dname varchar(20)
);
create table changes
(
cid int auto_increment primary key,
sno bigint,
ctype char(5),
time date,
foreign key (sno) references student (sno)
);
create table punishments
(
pid int auto_increment primary key,
sno bigint,
ptype char(5),
time date,
foreign key (sno) references student (sno)
);
create table reward
(
rid int auto_increment primary key,
sno bigint,
rtype char(5),
time date,
foreign key (sno) references student (sno)
);
insert into student
values
(3119005400,'张三','男','2000-01-01','广东省','信息安全2班','信息安全','计算机学院'),
(3119005401,'李四','女','2000-02-02','四川省','信息安全1班','信息安全','计算机学院'),
(3119005402,'王五','男','2000-03-03','湖南省','英语2班','英语','外国语学院');
insert into changes
values
(1,'3119005400','休学','2021-12-6');
insert into reward
values
(1,'3119005401','国级','2021-12-6');
insert into punishments
values
(1,'3119005402','警告','2021-12-6');