work_rate.sql

很不错的！！大家可以试试！！！D:学习专业课程设计成果OA.rar

create table work_rate
(
department_id int not null ,
department_name varchar(40) not null primary key,

emp_id int not null,
emp_name  varchar(20) not null,

work_title varchar(20) not null,
work_text varchar(60) ,

start_time float(10) not null,
end_time float(10) not null,

department_time float(10) not null,
employee_time float(10) ,

memo varchar(10) )


select * 
from work_rate 
alter table work_rate
add foreign key(emp_id) references emp_info(emp_id)