小型求职招聘系统（适合学院内部）

--------------------------------学生简历表 create table student ( sid varchar(10) primary key, password varchar(20) not null, name varchar(50) not null, idcard varchar(20) not null, sex varchar(10) not null, bornyear varchar(10) not null, province varchar(10) not null, call varchar(20) not null, email varchar(50) not null, english varchar(10) not null, hopeplace varchar(50) not null, hopesalary int not null, hopeposition int not null, descrip varchar(100), active int not null ) -------------------------------公司信息表 create table company ( cid varchar(20) primary key, password varchar(20) not null, name varchar(50) not null, type int not null, connect varchar(50) not null, call varchar(20) not null, province varchar(10) not null, email varchar(50) not null, descrip varchar(100), active int not null ) -------------------------------招聘信息表 create table trad ( tid int identity(0,1) primary key, cid varchar(20) foreign key references company(cid) on delete cascade, theme varchar(100) not null, type varchar(50) not null, position varchar(100) not null, salary int not null, deadline varchar(15) not null, hopeprovince varchar(10) not null, workplace varchar(50) not null, neednum int not null, descrip varchar(100), applynum int ) ---------------------------------学生收到的面试通知 create table audition ( sid varchar(10) foreign key references student(sid) on delete cascade, tid int foreign key references trad(tid), primary key(sid,tid) ) ----------------------------------收藏的招聘信息 create table savetrad ( sid varchar(10) foreign key references student(sid) on delete cascade, tid int foreign key references trad(tid), primary key(sid,tid) ) -----------------------------------公司收到的简历 create table getstudent ( cid varchar(20) foreign key references company(cid) on delete cascade, sid varchar(10) foreign key references student(sid) on delete cascade, tid int foreign key references trad(tid), type int, primary key(cid,sid,tid) ) -----------------------------------收藏的简历 create table savestudent ( cid varchar(20) foreign key references company(cid) on delete cascade, sid varchar(10) foreign key references student(sid), primary key(cid,sid) ) -----------------------------------管理员发布的新闻信息 create table news ( nid int identity(0,1) primary key, title varchar(50), content varchar(200), click int, time varchar(50) ) -----------------------------------邮件表 create table mail ( mid int identity(0,1) primary key, fromW varchar(20), toW varchar(20), title varchar(50), content varchar(200), time datetime, newORold int )