create table jobcategory --入职类别
(
id number(2) primary key,
j_sname varchar2(7) not null --入职类别
);
create table depart --教学部
(
id number(2) primary key,
dname varchar2(6) not null, --部门名称
dno varchar2(3) not null --部门编号
);
create table jobs --职位
(
id number(2) primary key,
jname varchar2(12) not null --职位名称
);
create table fund_non --公积金账号
(
id number(2) primary key,
fno varchar2(5) unique --公积金账号
);
create table staff --教职员fun
(
id number(2) primary key, --编号
sname varchar2(8) not null, --姓名
ssalary varchar2(7) not null, --薪水
stime varchar2(5) not null, --工龄
ssort varchar2(5) not null, --类别
cid number(10) unique,
sid number(10) not null,
aid number(10) not null,
constraint fk_staff1_itcategory foreign key(sid) references jobcategory (id),
constraint fk_staff2_itcategory foreign key(cid) references fund_non(id),
constraint fk_staff3_itcategory foreign key(aid) references depart(id)
);
create table staff_jobs
(
sid number(2),
cid number(2),
constraint pk_sid_cid primary key(sid,cid),
constraint fk_sid foreign key(sid) references staff(id),
constraint fk_cid foreign key(cid) references jobs(id)
);