duty.sql

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

create table duty
( emp_id int not null,
  emp_name  varchar(20) not null primary key,
  staff_leave datetime ,
  staff_reaL varchar (1000),
  staff_travel datetime ,
  staff_reaT varchar (1000),
  staff_on datetime ,
  staff_off datetime
)

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