--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,DATETIME date null,STATE 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_PATH 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 VARCHAR2(20) null,appli_info varchar2(100) null);--7.附件表create table attachment(ATT_ID number(6) not null primary key, FILE_ID number(6) null,ATT_NAME varchar2(50) null,ATT_PATH varchar2(80) null,ATT_SIZE varchar2(20) null,ATT_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) nulltable_id NUMBER(4) null,);--20.收件人create table recipient(RECI_ID number(6) not null primary key, FILE_ID number(6) null,RECI_NAME varchar2(20) null,RECI_TIME date null);--21.角色表create table role(role_no number not null primary key,role_name varchar2(20) null,role_code number null);--22.角色权限表create table role_competence(role_no number not null,competence_no number not null);--23.日程安排create table schedule(schedule_id number(20) not null primary key, user_no number(4) null,schedule_content varchar2(1000) null,plan_time date null,finish_time date null,Release_time date null,schedule_competence varchar2(20) null,finish_state varchar2(20) null,plan_people varchar2(20) null);--24.用户表create table users(user_no number(4) not null primary key, user_account varchar2(20) null,user_password varchar2(20) null,user_name varchar2(20) null,user_sex varchar2(4) null,user_email varchar2(40) null,user_address varchar2(40) null,user_birth date null,user_tell varchar2(20) null,user_photo varchar2(1000) null,isnoline number(4) null)--会议室表create table MeetingRoom(meeting_no NUMBER(4) not null primary key, proce_no NUMBER(4),doorplatetablet VARCHAR2(4),meeting_count NUMBER(4),meetingroom_state NUMBER(4),);--用车表create table UserCars(Cars_no NUMBER(4) not null primary key,proce_no NUMBER(4),cars_plate VARCHAR2(20),Cars_Type VARCHAR2(20),cars_model VARCHAR2(20),Use_state NUMBER(4),);。