这是我的几张表, 该如何编写这个数据字典的查询? /*用户*/
create table `B_user`
(
`username` VARCHAR(20),
`password` VARCHAR(20)
)
insert into B_user(user_id ,user_password ) values('admin','123')
insert into B_user(user_id ,user_password ) values('teacher','123')/*学生信息*/ (student_id,student_name,sex,class_id,id_number,address,Tel_number)
create table `B_student`
(
`student_id` varchar(40) not null,
`student_name` varchar(40),
`sex` BIT,
`class_id` integer(10) not null,
`id_number` varchar(40),
`address` varchar(50),
`Tel_number` varchar(20),
primary key (`student_id`)
) type=innoDB;
/*奖惩信息*/ (institution_id,student_id,institution_name,institution_content,createtime)
create table B_institution
(
`institution_id` integer not null auto_increment,
`student_id` varchar(40) not null,
`institution_name` varchar(20),
`institution_content` varchar(100),
`createtime` DATETIME,
primary key(`institution_id`),
index(`student_id`),
foreign key (`student_id`) references B_student(`student_id`)on delete cascade
) type=innoDB;
/*成绩单信息*/ (scoreList_id,student_id,class_id,course_id,course_name,score)
create table B_scoreList
(
`scoreList_id` integer not null auto_increment,
`student_id` varchar(40) not null,
`class_id` varchar(40) not null,
`course_id` varchar(40) not null,
`course_name` varchar(40),
`score` float,
primary key(`scoreList_id`),
index(`student_id`),
foreign key (`student_id`) references B_student(`student_id`)on delete cascade
)type=innoDB
create table `B_user`
(
`username` VARCHAR(20),
`password` VARCHAR(20)
)
insert into B_user(user_id ,user_password ) values('admin','123')
insert into B_user(user_id ,user_password ) values('teacher','123')/*学生信息*/ (student_id,student_name,sex,class_id,id_number,address,Tel_number)
create table `B_student`
(
`student_id` varchar(40) not null,
`student_name` varchar(40),
`sex` BIT,
`class_id` integer(10) not null,
`id_number` varchar(40),
`address` varchar(50),
`Tel_number` varchar(20),
primary key (`student_id`)
) type=innoDB;
/*奖惩信息*/ (institution_id,student_id,institution_name,institution_content,createtime)
create table B_institution
(
`institution_id` integer not null auto_increment,
`student_id` varchar(40) not null,
`institution_name` varchar(20),
`institution_content` varchar(100),
`createtime` DATETIME,
primary key(`institution_id`),
index(`student_id`),
foreign key (`student_id`) references B_student(`student_id`)on delete cascade
) type=innoDB;
/*成绩单信息*/ (scoreList_id,student_id,class_id,course_id,course_name,score)
create table B_scoreList
(
`scoreList_id` integer not null auto_increment,
`student_id` varchar(40) not null,
`class_id` varchar(40) not null,
`course_id` varchar(40) not null,
`course_name` varchar(40),
`score` float,
primary key(`scoreList_id`),
index(`student_id`),
foreign key (`student_id`) references B_student(`student_id`)on delete cascade
)type=innoDB
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货