OA办公管理系统数据库表设计9--1.考勤表create table Attendence(Attribute_RecordId number not null primary key, user_no number(4) not null,WorkDate date null,CalendarDate date null,OnDutyTime date null,OffDutyTime date null,OnDutyTimeStatus number null,OffDutyTimeStatus number null,LateRemark varchar2(200) null,LeaveEarlyRemark varchar2(200) null,checkremark varchar2(100) null);--2.邮件表create table email(Emai_id number not null primary key, user_no number(4) not null, ReceiveEmailPeopleId number null,EmailContent varchar2(100) null,SendEmailTime date null,emailremark varchar2(100) null);--3.文件表create table FILES(FILE_ID number(6) not null primary key, user_no number(4) null, FILE_NAME varchar2(50) null,FILE_CONTENT varchar2(200) null,SENDER_ID number(6) null,SENDER_NAME varchar2(40) null,DA TETIME date null,STA TE varchar2(1000) null,ISACCPET varchar2(10) null);--4.文件共享create table SHAREFILE(SHAREFILE_ID number(6) not null primary key, user_no number(4) null, SHAREFOLDER_ID number(20) null,SHAREFILE_NAME varchar2(50) null,SHAREFILE_PA TH varchar2(80) null,SHATEFILE_SIZE varchar2(20) null,SHAREFILE_TYPE varchar2(20) null,HEIR_TIME date null,DOWNLOAD_NUMBER number(6) null);--5.共享文件夹create table SHAREFOLDER(SHAREFOLDER_ID number(20) not null primary key, user_no number(4) null,SHAREFOLDER_NAME varchar2(50) null,SHAREFOLDER_DESC varchar2(500) null,CREATE_TIME date null);--6.申请create table appli(appli_no number(4) not null primary key,proce_no number(4) null,appli_title varchar2(20) null,appli_context varchar2(100) null,appli_time date null,begin_time date null,end_time date null,appli_type V ARCHAR2(20) null,appli_info varchar2(100) null);--7.附件表create table attachment(A TT_ID number(6) not null primary key,FILE_ID number(6) null,A TT_NAME varchar2(50) null,A TT_PATH varchar2(80) null,A TT_SIZE varchar2(20) null,A TT_TYPE varchar2(20) null--8.审核表create table audits(audit_no number(4) not null primary key, prore_no number(4) null, user_no number(4) not null,appli_no number(4) not null,deptno number(4) null,check_userno number(4) null,check_time date null,check_idea varchar2(100) null,isthrough number(2) null);--9.权限表create table competence(competence_no number not null primary key, competence_name varchar2(20) null,competence_code number null);--10.数据库备份create table databasebackup(backup_no number(4) not null primary key, user_no number(4) not null,backup_time date null,backup_address varchar2(200) null,backip_remark varchar2(200) null);--11.部门表create table dept(dept_no number(4) not null primary key, dept_name varchar2(20) null, dept_address varchar2(200) null,dept_code varchar2(20) null,dept_mgr number(4) null--12.员工表create table emp(emp_no number(4) not null primary key, dept_no number(4) not null, user_no number(4) not null,emp_name varchar2(20) null,emp_job varchar2(20) null,emp_sal number(10) null,emp_comm number(10) null,emp_mgr number(4) null,hiredate date null);--13.填写申请表create table fillappli(user_no number(4) not null,appli_no number(4) not null);--14.日志表create table log(log_id number(10) not null primary key, user_no number(4) null, log_title varchar2(50) null,log_content varchar2(1000) null,log_time date null,log_state varchar2(10) null,log_competence varchar2(20) null);--15.系统日志表create table logger(logger_no number(4) not null primary key, user_no number(4) not null, logger_option varchar2(20) null,logger_time date null,logger_remark varchar2(100) null,logger_address varchar2(200) null);--16.通讯录表create table mailList(MailListId number not null primary key, user_no number(4) not null,MailPeopleId number null);--17.消息表create table messages(message_id number(10) not null primary key, user_no number(4) null, message_content varchar2(1000) null,message_consignee varchar2(100) null,message_sendtime date null,message_state varchar2(10) null,sms_state varchar2(10) null,sms_address varchar2(100) null,sms_remark varchar2(100) null,sms_type varchar2(10) null);--18.流程过程表create table procerelation谢谢欣赏(prore_no number(4) not null primary key, proce_no number(4) not null, prore_name varchar2(20) null,before_order number(4) null,later_prder number(4) null);--19.流程表create table process(proce_no number(4) not null primary key, user_no number(4) not null,proce_name varchar2(20) null,proce_time date null,proce_other varchar2(100) null谢谢欣赏。