sage int not null, smianmao char(10) not null, syingjie char(10) not null, sxueli char(10) not null, scomefrom char(10) not null, sleibie char(10) not null, szhuanye int not null); 考生成绩表 create table grade (sno char(10) primary key, sname char(10) not null, waiyu int not null, zhengzhi int not null, zhuanye int not null); 考生总成绩表 create table z (sno char(10)primary key, sname char(10)not null, grade int not null); 录取名单表 create table luqu (sno char(10) primary key, luqudanwei char(10) not null, fushikemu int not null , fushigrade int not null); 专业字典表 create table zidian (zhuanyesno char(10) primary key, zhuanyename char(10) not null, jihuanei int,