work_record.sql

来自「很不错的！！大家可以试试！！！D:学习专业课程设计成果OA.rar」· SQL 代码 · 共 18 行

create table work_record
(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),

finishwork_qk varchar(10) ,
memo varchar(10) )
select * 
from work_record
alter table work_record
add foreign key(emp_id) references emp_info(emp_id)