一份OA的数据库设计
来源：互联网 发布：windows访问smb无权限 编辑：程序博客网 时间：2024/04/28 23:08
一份OA的数据库设计- -
DROP TABLE IF EXISTS ADDRESS;
CREATE TABLE `address` (
`ADD_ID` int(11) NOT NULL auto_increment,
`USER_ID` varchar(20) NOT NULL default '',
`GROUP_ID` int(11) NOT NULL default '0',
`PSN_NAME` varchar(120) NOT NULL default '',
`SEX` char(1) NOT NULL default '',
`NICK_NAME` varchar(50) NOT NULL default '',
`BIRTHDAY` date NOT NULL default '0000-00-00',
`MINISTRATION` varchar(50) NOT NULL default '',
`MATE` varchar(50) NOT NULL default '',
`CHILD` varchar(50) NOT NULL default '',
`DEPT_NAME` varchar(50) NOT NULL default '',
`ADD_DEPT` varchar(200) NOT NULL default '',
`POST_NO_DEPT` varchar(50) NOT NULL default '',
`TEL_NO_DEPT` varchar(50) NOT NULL default '',
`FAX_NO_DEPT` varchar(50) NOT NULL default '',
`ADD_HOME` varchar(200) NOT NULL default '',
`POST_NO_HOME` varchar(50) NOT NULL default '',
`TEL_NO_HOME` varchar(50) NOT NULL default '',
`MOBIL_NO` varchar(50) NOT NULL default '',
`BP_NO` varchar(50) NOT NULL default '',
`EMAIL` varchar(100) NOT NULL default '',
`OICQ_NO` varchar(50) NOT NULL default '',
`ICQ_NO` varchar(50) NOT NULL default '',
`NOTES` text NOT NULL,
PRIMARY KEY (`ADD_ID`),
KEY `USER_ID` (`USER_ID`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS ADDRESS_GROUP;
CREATE TABLE `address_group` (
`GROUP_ID` int(11) NOT NULL auto_increment,
`GROUP_NAME` varchar(200) NOT NULL default '',
`USER_ID` varchar(200) NOT NULL default '',
PRIMARY KEY (`GROUP_ID`)
) TYPE=MyISAM;
INSERT INTO ADDRESS_GROUP VALUES('1','客户','admin');
INSERT INTO ADDRESS_GROUP VALUES('2','朋友','admin');
INSERT INTO ADDRESS_GROUP VALUES('3','客户','');
DROP TABLE IF EXISTS AFFAIR;
CREATE TABLE `affair` (
`AFF_ID` int(11) NOT NULL auto_increment,
`USER_ID` varchar(20) NOT NULL default '',
`BEGIN_TIME` datetime NOT NULL default '0000-00-00 00:00:00',
`TYPE` char(1) NOT NULL default '',
`REMIND_DATE` varchar(200) NOT NULL default '',
`REMIND_TIME` time NOT NULL default '00:00:00',
`CONTENT` text NOT NULL,
`LAST_REMIND` date NOT NULL default '0000-00-00',
PRIMARY KEY (`AFF_ID`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS ATTEND_CONFIG;
CREATE TABLE `attend_config` (
`DUTY_TYPE` int(11) NOT NULL auto_increment,
`DUTY_NAME` char(100) NOT NULL default '',
`DUTY_TIME1` char(50) NOT NULL default '',
`DUTY_TIME2` char(50) NOT NULL default '',
`DUTY_TIME3` char(50) NOT NULL default '',
`DUTY_TIME4` char(50) NOT NULL default '',
`DUTY_TIME5` char(50) NOT NULL default '',
`DUTY_TIME6` char(50) NOT NULL default '',
`DUTY_TYPE1` char(1) NOT NULL default '',
`DUTY_TYPE2` char(1) NOT NULL default '',
`DUTY_TYPE3` char(1) NOT NULL default '',
`DUTY_TYPE4` char(1) NOT NULL default '',
`DUTY_TYPE5` char(1) NOT NULL default '',
`DUTY_TYPE6` char(1) NOT NULL default '',
KEY `DUTY_TYPE` (`DUTY_TYPE`)
) TYPE=MyISAM;
INSERT INTO ATTEND_CONFIG VALUES('1','正常班','8:00:00','11:30:00','15:00:00','18:00:00','','','1','2','1','2','1','2');
INSERT INTO ATTEND_CONFIG VALUES('2','全日班','8:00:00','11:00:00','13:00:00','16:00:00','18:00:00','22:00:00','1','2','1','2','1','2');
DROP TABLE IF EXISTS ATTEND_DUTY;
CREATE TABLE `attend_duty` (
`USER_ID` char(20) NOT NULL default '',
`REGISTER_TYPE` char(1) NOT NULL default '',
`REGISTER_TIME` datetime NOT NULL default '0000-00-00 00:00:00',
KEY `USER_ID` (`USER_ID`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS ATTEND_EVECTION;
CREATE TABLE `attend_evection` (
`EVECTION_ID` int(11) NOT NULL auto_increment,
`USER_ID` char(20) NOT NULL default '',
`EVECTION_DEST` char(50) NOT NULL default '',
`EVECTION_DATE1` datetime NOT NULL default '0000-00-00 00:00:00',
`EVECTION_DATE2` datetime NOT NULL default '0000-00-00 00:00:00',
`STATUS` char(1) NOT NULL default '',
UNIQUE KEY `EVECTION_ID` (`EVECTION_ID`),
KEY `USER_ID` (`USER_ID`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS ATTEND_LEAVE;
CREATE TABLE `attend_leave` (
`LEAVE_ID` int(11) NOT NULL auto_increment,
`USER_ID` char(20) NOT NULL default '',
`LEADER_ID` char(20) NOT NULL default '',
`LEAVE_TYPE` char(100) NOT NULL default '',
`LEAVE_DATE1` datetime NOT NULL default '0000-00-00 00:00:00',
`LEAVE_DATE2` datetime NOT NULL default '0000-00-00 00:00:00',
`STATUS` char(1) NOT NULL default '',
`ALLOW` char(1) NOT NULL default '',
UNIQUE KEY `LEAVE_ID` (`LEAVE_ID`),
KEY `LEADER_ID` (`LEADER_ID`),
KEY `USER_ID` (`USER_ID`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS ATTEND_MANAGER;
CREATE TABLE `attend_manager` (
`MANAGER_ID` int(11) NOT NULL default '0',
`MANAGERS` text NOT NULL,
PRIMARY KEY (`MANAGER_ID`)
) TYPE=MyISAM;
INSERT INTO ATTEND_MANAGER VALUES('1','');
DROP TABLE IF EXISTS ATTEND_OUT;
CREATE TABLE `attend_out` (
`USER_ID` varchar(20) NOT NULL default '',
`LEADER_ID` varchar(20) NOT NULL default '',
`OUT_TYPE` varchar(100) NOT NULL default '',
`SUBMIT_TIME` datetime NOT NULL default '0000-00-00 00:00:00',
`OUT_TIME1` varchar(10) NOT NULL default '',
`OUT_TIME2` varchar(10) NOT NULL default '',
`ALLOW` char(1) NOT NULL default '',
`STATUS` char(1) NOT NULL default '0',
KEY `LEADER_ID` (`LEADER_ID`),
KEY `USER_ID` (`USER_ID`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS BBS_BOARD;
CREATE TABLE `bbs_board` (
`BOARD_ID` int(11) NOT NULL auto_increment,
`BOARD_NAME` char(100) NOT NULL default '',
`DEPT_ID` int(11) NOT NULL default '0',
`ANONYMITY_YN` char(1) NOT NULL default '',
`WELCOME_TEXT` char(200) NOT NULL default '',
KEY `DEPT_ID` (`DEPT_ID`),
KEY `SORT_ID` (`BOARD_ID`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS BBS_COMMENT;
CREATE TABLE `bbs_comment` (
`COMMENT_ID` int(11) NOT NULL auto_increment,
`BOARD_ID` int(11) NOT NULL default '0',
`USER_ID` varchar(20) NOT NULL default '',
`AUTHOR_NAME` varchar(50) NOT NULL default '',
`SUBJECT` varchar(200) NOT NULL default '',
`CONTENT` mediumtext NOT NULL,
`ATTACHMENT_ID` text NOT NULL,
`ATTACHMENT_NAME` text NOT NULL,
`SUBMIT_TIME` datetime NOT NULL default '0000-00-00 00:00:00',
`REPLY_CONT` int(11) NOT NULL default '0',
`READ_CONT` int(11) NOT NULL default '0',
PRIMARY KEY (`COMMENT_ID`),
KEY `Author_id` (`USER_ID`),
KEY `PID` (`BOARD_ID`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS BOOK_INFO;
CREATE TABLE `book_info` (
`BOOK_ID` int(11) NOT NULL auto_increment,
`ISBN` varchar(200) default NULL,
`TYPE_ID` int(4) default '0',
`DEPT` int(11) default '0',
`BOOK_NAME` varchar(200) NOT NULL default '',
`AUTHOR` varchar(200) default NULL,
`PUB_DATE` varchar(200) default NULL,
`PUB_HOUSE` varchar(200) default NULL,
`AMT` int(11) default '1',
`PRICE` varchar(20) default NULL,
`AREA` varchar(200) default NULL,
`BRIEF` text,
`OPEN` char(1) NOT NULL default '0',
`LEND` char(1) NOT NULL default '0',
`BORR_PERSON` varchar(200) default NULL,
`MEMO` varchar(255) default NULL,
PRIMARY KEY (`BOOK_ID`),
UNIQUE KEY `BOOK_ID0` (`BOOK_ID`,`ISBN`),
KEY `BOOK_ID0_2` (`BOOK_ID`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS BOOK_TYPE;
CREATE TABLE `book_type` (
`TYPE_ID` int(4) NOT NULL auto_increment,
`TYPE_NAME` char(200) NOT NULL default '',
PRIMARY KEY (`TYPE_ID`),
UNIQUE KEY `CLASS_ID0` (`TYPE_ID`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS CALENDAR;
CREATE TABLE `calendar` (
`CAL_ID` int(11) NOT NULL auto_increment,
`USER_ID` varchar(20) NOT NULL default '',
`CAL_TIME` datetime NOT NULL default '0000-00-00 00:00:00',
`END_TIME` datetime NOT NULL default '0000-00-00 00:00:00',
`CAL_TYPE` char(1) NOT NULL default '',
`CONTENT` text NOT NULL,
UNIQUE KEY `ID` (`CAL_ID`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS CHATROOM;
CREATE TABLE `chatroom` (
`CHAT_ID` int(11) NOT NULL auto_increment,
`SUBJECT` char(200) NOT NULL default '',
`STOP` char(1) NOT NULL default '',
UNIQUE KEY `ID` (`CHAT_ID`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS CONTACT;
CREATE TABLE `contact` (
`CONTACT_ID` int(11) NOT NULL auto_increment,
`CUSTOMER_ID` int(11) NOT NULL default '0',
`CONTACT_CONTENT` text NOT NULL,
`CONTACT_DATE` date NOT NULL default '0000-00-00',
`LINKMAN_NAME` varchar(200) NOT NULL default '',
`MEMO` text NOT NULL,
PRIMARY KEY (`CONTACT_ID`),
UNIQUE KEY `CONTACT_ID` (`CONTACT_ID`),
KEY `CONTACT_ID_2` (`CONTACT_ID`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS CP_ASSETCFG;
CREATE TABLE `cp_assetcfg` (
`DPCT_SORT` varchar(10) NOT NULL default '',
`BAL_SORT` varchar(10) NOT NULL default ''
) TYPE=MyISAM;
DROP TABLE IF EXISTS CP_CPTL_INFO;
CREATE TABLE `cp_cptl_info` (
`CPTL_ID` int(11) NOT NULL auto_increment,
`CPTL_NO` varchar(100) NOT NULL default '',
`CPTL_NAME` varchar(200) NOT NULL default '',
`DEPT_ID` int(11) NOT NULL default '0',
`CPTL_VAL` decimal(20,2) NOT NULL default '0.00',
`CPTL_BAL` decimal(20,2) NOT NULL default '0.00',
`DPCT_YY` decimal(10,2) NOT NULL default '0.00',
`MON_DPCT` decimal(20,2) NOT NULL default '0.00',
`SUM_DPCT` decimal(20,2) NOT NULL default '0.00',
`CPTL_KIND` varchar(10) NOT NULL default '',
`PRCS_ID` int(11) NOT NULL default '0',
`FINISH_FLAG` varchar(10) NOT NULL default '',
`CREATE_DATE` date NOT NULL default '0000-00-00',
`DCR_DATE` date NOT NULL default '0000-00-00',
`FROM_YYMM` date NOT NULL default '0000-00-00',
`DCR_PRCS_ID` int(11) NOT NULL default '0',
`KEEPER` varchar(20) NOT NULL default '',
`REMARK` text NOT NULL,
PRIMARY KEY (`CPTL_ID`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS CP_DPCT_SUB;
CREATE TABLE `cp_dpct_sub` (
`DEPRE_ID` int(11) NOT NULL auto_increment,
`CPTL_ID` int(11) NOT NULL default '0',
`PEPRE_DATE` date NOT NULL default '0000-00-00',
`FROM_YYMM` varchar(10) NOT NULL default '',
`TO_YYMM` varchar(10) NOT NULL default '',
`DEPRE_AMT` decimal(20,2) NOT NULL default '0.00',
PRIMARY KEY (`DEPRE_ID`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS CP_PRCS_PROP;
CREATE TABLE `cp_prcs_prop` (
`PRCS_ID` int(11) NOT NULL auto_increment,
`PRCS_CLASS` varchar(10) NOT NULL default '',
`PRCS_DESC` varchar(50) NOT NULL default '',
`PRCS_LONG_DESC` varchar(200) NOT NULL default '',
PRIMARY KEY (`PRCS_ID`)
) TYPE=MyISAM;
INSERT INTO CP_PRCS_PROP VALUES('1','A01','购入','购入不需安装的固定资产');
INSERT INTO CP_PRCS_PROP VALUES('2','A02','购入','购入需安装已完工的固定资产');
INSERT INTO CP_PRCS_PROP VALUES('3','A03','转入','其他单位转入的固定资产(新设备)');
INSERT INTO CP_PRCS_PROP VALUES('4','A04','转入','其他单位转入的固定资产(旧设备)');
INSERT INTO CP_PRCS_PROP VALUES('5','A05','捐赠','捐赠的固定资产');
INSERT INTO CP_PRCS_PROP VALUES('6','A06','租赁','融资租赁的固定资产');
INSERT INTO CP_PRCS_PROP VALUES('7','A07','盘盈','固定资产盘盈');
INSERT INTO CP_PRCS_PROP VALUES('8','D08','转出','固定资产出售');
INSERT INTO CP_PRCS_PROP VALUES('9','D09','报废','固定资产报废');
INSERT INTO CP_PRCS_PROP VALUES('10','D10','损毁','固定资产损毁');
INSERT INTO CP_PRCS_PROP VALUES('11','D11','盘亏','固定资产盘亏');
INSERT INTO CP_PRCS_PROP VALUES('12','D12','清理','固定资产清理');
DROP TABLE IF EXISTS CUSTOMER;
CREATE TABLE `customer` (
`CUSTOMER_ID` int(11) NOT NULL auto_increment,
`CUSTOMER_NAME` char(200) NOT NULL default '',
`TEL_NO` char(200) NOT NULL default '',
`FAX_NO` char(200) NOT NULL default '',
`CUSTOMER_WWW` char(200) NOT NULL default '',
`EMAIL` char(200) NOT NULL default '',
`CUSTOMER_ADD` char(200) NOT NULL default '',
`POSTALCODE` char(50) NOT NULL default '',
`MEMO` char(200) NOT NULL default '',
PRIMARY KEY (`CUSTOMER_ID`),
UNIQUE KEY `CUSTOMER_ID` (`CUSTOMER_ID`),
KEY `CUSTOMER_ID_2` (`CUSTOMER_ID`,`CUSTOMER_NAME`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS DEPARTMENT;
CREATE TABLE `department` (
`DEPT_ID` int(11) NOT NULL auto_increment,
`DEPT_NAME` char(50) NOT NULL default '',
`TEL_NO` char(50) NOT NULL default '',
`FAX_NO` char(50) NOT NULL default '',
`DEPT_NO` char(200) NOT NULL default '0',
`DEPT_PARENT` int(11) NOT NULL default '0',
KEY `DEPT_ID` (`DEPT_ID`),
KEY `DEPT_NO` (`DEPT_NO`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS DIARY;
CREATE TABLE `diary` (
`DIA_ID` int(11) NOT NULL auto_increment,
`USER_ID` varchar(20) NOT NULL default '',
`DIA_DATE` datetime NOT NULL default '0000-00-00 00:00:00',
`DIA_TYPE` char(1) NOT NULL default '',
`CONTENT` mediumtext NOT NULL,
UNIQUE KEY `ID` (`DIA_ID`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS EMAIL;
CREATE TABLE `email` (
`EMAIL_ID` int(11) NOT NULL auto_increment,
`FROM_ID` varchar(20) NOT NULL default '',
`TO_ID` text NOT NULL,
`TO_ID2` text NOT NULL,
`COPY_TO_ID` text NOT NULL,
`SECRET_TO_ID` text NOT NULL,
`SUBJECT` varchar(200) NOT NULL default '',
`CONTENT` mediumtext NOT NULL,
`SEND_TIME` datetime NOT NULL default '0000-00-00 00:00:00',
`ATTACHMENT_ID` text NOT NULL,
`ATTACHMENT_NAME` text NOT NULL,
`READ_FLAG` char(1) NOT NULL default '',
`SEND_FLAG` char(1) NOT NULL default '',
`DELETE_FLAG` char(1) NOT NULL default '',
`SMS_REMIND` varchar(20) NOT NULL default '',
`BOX_ID` int(11) NOT NULL default '0',
UNIQUE KEY `ID` (`EMAIL_ID`),
KEY `SEND_TIME` (`SEND_TIME`)
) TYPE=MyISAM;
INSERT INTO EMAIL VALUES('2','admin','admin','admin,','','','dd','ddd','2005-07-15 09:09:48','965468431,','control.jsp*','0','1','0','','0');
INSERT INTO EMAIL VALUES('4','admin','admin','admin,','','','sfadf','sadfasdf','2005-07-15 09:13:46','','','1','1','0','','0');
DROP TABLE IF EXISTS EMAIL_BOX;
CREATE TABLE `email_box` (
`BOX_ID` int(11) NOT NULL auto_increment,
`BOX_NO` int(11) NOT NULL default '0',
`BOX_NAME` varchar(200) NOT NULL default '',
`USER_ID` varchar(20) NOT NULL default '',
PRIMARY KEY (`BOX_ID`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS FILE_CONTENT;
CREATE TABLE `file_content` (
`CONTENT_ID` int(11) NOT NULL auto_increment,
`SORT_ID` int(11) NOT NULL default '0',
`SUBJECT` varchar(200) NOT NULL default '',
`CONTENT` mediumtext NOT NULL,
`SEND_TIME` datetime NOT NULL default '0000-00-00 00:00:00',
`ATTACHMENT_ID` text NOT NULL,
`ATTACHMENT_NAME` text NOT NULL,
`ATTACHMENT_DESC` varchar(100) NOT NULL default '',
UNIQUE KEY `ITEM_ID` (`CONTENT_ID`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS FILE_SORT;
CREATE TABLE `file_sort` (
`SORT_ID` int(11) NOT NULL auto_increment,
`SORT_PARENT` int(11) NOT NULL default '0',
`SORT_NAME` varchar(200) NOT NULL default '',
`SORT_TYPE` char(1) NOT NULL default '',
`DEPT_ID` int(11) NOT NULL default '0',
`USER_ID` text NOT NULL,
`NEW_USER` text NOT NULL,
`MANAGE_USER` text NOT NULL,
`DOWN_USER` text NOT NULL,
UNIQUE KEY `ITEM_ID` (`SORT_ID`),
KEY `DEPT_ID` (`DEPT_ID`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS FLOW_FORM_TYPE;
CREATE TABLE `flow_form_type` (
`FORM_ID` int(11) NOT NULL auto_increment,
`FORM_NAME` varchar(200) NOT NULL default '',
`PRINT_MODEL` mediumtext NOT NULL,
KEY `ITEM_ID` (`FORM_ID`)
) TYPE=MyISAM;
INSERT INTO FLOW_FORM_TYPE VALUES('1','工作交办卡','<TABLE class=Big width=580 align=center border=0>/r/n<TBODY>/r/n<TR align=right>/r/n<TD>文号：#[文号]#[时间] </TD></TR></TBODY></TABLE>/r/n<TABLE class=small cellSpacing=1 cellPadding=5 width=580 align=center border=0>/r/n<TBODY>/r/n<TR class=TableLine2>/r/n<TD width=80>具体工作：</td><td><INPUT title=具体工作> 完成时限：<INPUT title=完成时限> </TD></TR>/r/n<TR class=TableLine1>/r/n<TD>工作标准：</td><td>/r/n<TEXTAREA title=工作标准 rows=3 cols=50></TEXTAREA></TD></TR>/r/n<TR class=TableLine2>/r/n<TD>工作完成情况：</td><td>/r/n<TEXTAREA title=工作完成情况 rows=3 cols=50></TEXTAREA></TD></TR>/r/n<TR class=TableLine1>/r/n<TD>交办人意见：</td><td>/r/n<TEXTAREA title=交办人意见 rows=3 cols=50></TEXTAREA></TD></TR></TBODY></TABLE>');
INSERT INTO FLOW_FORM_TYPE VALUES('2','督查督办卡','<table width=/"580/" border=/"0/" align=/"center/" class=/"Big/">/r/n <tr align=/"right/">/r/n <td>文号：#[文号]/r/n #[时间]/r/n </td>/r/n </tr>/r/n</table>/r/n/r/n<table border=/"0/" cellspacing=/"1/" class=/"small/" cellpadding=/"5/" align=/"center/" width=/"580/">/r/n<tr>/r/n<td width=80 class=TableLine2>办结时间：</td><td class=TableLine1><INPUT title=/"办结时间/" type=text size=20> /r/n</td>/r/n</tr>/r/n<tr>/r/n<td class=TableLine2>主办内容及要求:</td><td class=TableLine1><TEXTAREA title=/"主办内容及要求/" cols=50 rows=3></TEXTAREA>/r/n</td>/r/n</tr>/r/n<tr>/r/n<td class=TableLine2>主办单位办理情况:</td><td class=TableLine1><TEXTAREA title=/"主办单位办理情况/" cols=50 rows=8></TEXTAREA>/r/n </td>/r/n </tr>/r/n <tr>/r/n <td class=TableLine2>督办单位意见：</td><td class=TableLine1><TEXTAREA title=/"督办单位意见/" cols=50 rows=4></TEXTAREA></center>/r/n </td>/r/n </tr></table>');
INSERT INTO FLOW_FORM_TYPE VALUES('3','收发文登记卡','<table width=/"580/" border=/"0/" align=/"center/" class=/"Big/">/r/n <tr align=/"right/">/r/n <td>文号：#[文号]/r/n #[时间]/r/n </td>/r/n </tr>/r/n</table>/r/n<table border=/"0/" cellspacing=/"1/" class=/"small/" cellpadding=/"5/" align=/"center/" width=/"580/">/r/n<tr>/r/n<td class=TableLine2>标题：</td><td class=TableLine1><INPUT title=/"标题/" type=text size=50></td></tr>/r/n<tr>/r/n<td class=TableLine2>摘要：</td><td class=TableLine1><TEXTAREA title=/"摘要/" cols=50 rows=3></TEXTAREA></td></tr>/r/n<tr>/r/n<td class=TableLine2>主题词：</td><td class=TableLine1><INPUT title=/"主题词/" type=text size=45></td></tr>/r/n<tr>/r/n<td class=TableLine2>附注：</td><td class=TableLine1><TEXTAREA title=/"附注/" cols=50 rows=5></TEXTAREA></td></tr>/r/n<tr>/r/n<td class=TableLine2>领导批示：</td><td class=TableLine1><TEXTAREA title=/"领导批示/" cols=50 rows=3></TEXTAREA></td></tr></table>');
DROP TABLE IF EXISTS FLOW_PROCESS;
CREATE TABLE `flow_process` (
`ID` int(11) NOT NULL auto_increment,
`FLOW_ID` int(11) NOT NULL default '0',
`PRCS_ID` int(11) NOT NULL default '0',
`PRCS_NAME` varchar(200) NOT NULL default '',
`PRCS_USER` text NOT NULL,
`PRCS_ITEM` text NOT NULL,
`PRCS_DEPT` text NOT NULL,
`PRCS_PRIV` text NOT NULL,
`PRCS_TO` text NOT NULL,
KEY `FLOW_ID` (`FLOW_ID`),
KEY `FORM_ID` (`PRCS_ID`),
KEY `ID` (`ID`)
) TYPE=MyISAM;
INSERT INTO FLOW_PROCESS VALUES('1','1','1','交办人交待工作','admin,','[A@],交办人意见,工作完成情况,工作标准,具体工作,','','','');
INSERT INTO FLOW_PROCESS VALUES('2','1','2','承办人办理','admin,','工作完成情况,','','','');
INSERT INTO FLOW_PROCESS VALUES('3','1','3','交办人意见','admin,','交办人意见,','','','');
INSERT INTO FLOW_PROCESS VALUES('4','1','4','承办人查阅','admin,','具体工作,工作标准,','','','');
INSERT INTO FLOW_PROCESS VALUES('5','2','1','督办单位交待工作','admin,','办结时间,主办内容及要求,','','','');
INSERT INTO FLOW_PROCESS VALUES('6','2','2','主办单位办理','admin,','主办单位办理情况,','','','');
INSERT INTO FLOW_PROCESS VALUES('7','2','3','督办单位意见','admin,','督办单位意见,','','','');
INSERT INTO FLOW_PROCESS VALUES('8','2','4','主办单位查阅','admin,','','','','');
INSERT INTO FLOW_PROCESS VALUES('9','3','1','收文登记','admin,','[A@],标题,摘要,附注,主题词,','','','');
INSERT INTO FLOW_PROCESS VALUES('10','3','2','领导批示','admin,','领导批示,[A@],附注,','','','');
INSERT INTO FLOW_PROCESS VALUES('11','3','3','办文单位办文','admin,','附注,','','','');
DROP TABLE IF EXISTS FLOW_RUN;
CREATE TABLE `flow_run` (
`RUN_ID` int(11) NOT NULL default '0',
`RUN_NAME` varchar(200) NOT NULL default '',
`FLOW_ID` int(11) NOT NULL default '0',
`ATTACHMENT_ID` text NOT NULL,
`ATTACHMENT_NAME` text NOT NULL,
KEY `FLOW_ID` (`RUN_ID`),
KEY `FORM_ID` (`FLOW_ID`)
) TYPE=MyISAM;
INSERT INTO FLOW_RUN VALUES('1','fdff(2005-07-23 10:15:08)','4','','');
DROP TABLE IF EXISTS FLOW_RUN_DATA;
CREATE TABLE `flow_run_data` (
`RUN_ID` int(11) NOT NULL default '0',
`ITEM_ID` int(11) NOT NULL default '0',
`ITEM_DATA` text NOT NULL,
KEY `FLOW_ID` (`RUN_ID`)
) TYPE=MyISAM;
INSERT INTO FLOW_RUN_DATA VALUES('1','5','c');
INSERT INTO FLOW_RUN_DATA VALUES('1','4','c');
INSERT INTO FLOW_RUN_DATA VALUES('1','3','c');
INSERT INTO FLOW_RUN_DATA VALUES('1','2','');
INSERT INTO FLOW_RUN_DATA VALUES('1','1','c');
DROP TABLE IF EXISTS FLOW_RUN_FEEDBACK;
CREATE TABLE `flow_run_feedback` (
`RUN_ID` int(11) NOT NULL default '0',
`USER_ID` varchar(20) NOT NULL default '',
`CONTENT` mediumtext NOT NULL,
`ATTACHMENT_ID` text NOT NULL,
`ATTACHMENT_NAME` text NOT NULL,
`EDIT_TIME` datetime NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM;
DROP TABLE IF EXISTS FLOW_RUN_PRCS;
CREATE TABLE `flow_run_prcs` (
`RUN_ID` int(11) NOT NULL default '0',
`PRCS_ID` int(11) NOT NULL default '0',
`USER_ID` varchar(20) NOT NULL default '',
`PRCS_TIME` datetime default NULL,
`DELIVER_TIME` datetime default NULL,
`PRCS_FLAG` char(1) NOT NULL default '',
`FLOW_PRCS` int(11) NOT NULL default '0',
`OP_FLAG` varchar(20) NOT NULL default '1',
KEY `FLOW_ID` (`RUN_ID`),
KEY `FORM_ID` (`USER_ID`),
KEY `PRCS_ID` (`PRCS_ID`)
) TYPE=MyISAM;
INSERT INTO FLOW_RUN_PRCS VALUES('1','2','admin','','','1','0','1');
INSERT INTO FLOW_RUN_PRCS VALUES('1','1','admin','2005-07-23 10:15:16','2005-07-23 10:15:49','3','1','1');
DROP TABLE IF EXISTS FLOW_TYPE;
CREATE TABLE `flow_type` (
`FLOW_ID` int(11) NOT NULL auto_increment,
`FLOW_NAME` varchar(200) NOT NULL default '',
`FORM_ID` int(11) NOT NULL default '0',
`FLOW_DOC` char(1) NOT NULL default '',
`FLOW_TYPE` char(1) NOT NULL default '',
`MANAGE_USER` text NOT NULL,
KEY `FLOW_ID` (`FLOW_ID`),
KEY `FORM_ID` (`FORM_ID`)
) TYPE=MyISAM;
INSERT INTO FLOW_TYPE VALUES('1','工作交办卡流程','1','1','1','admin,');
INSERT INTO FLOW_TYPE VALUES('2','督查督办卡流程','2','0','1','admin,');
INSERT INTO FLOW_TYPE VALUES('3','收发文流程','3','1','1','admin,');
INSERT INTO FLOW_TYPE VALUES('4','fdff','1','1','2','');
DROP TABLE IF EXISTS HRMS;
CREATE TABLE `hrms` (
`USER_ID` varchar(20) NOT NULL default '',
`CARD_NO` varchar(50) NOT NULL default '',
`MARRY` char(1) NOT NULL default '',
`WORK_DATE` datetime default '0000-00-00 00:00:00',
`JOIN_DATE` datetime default '0000-00-00 00:00:00',
`EDUCATION` char(1) NOT NULL default '',
`POLITICS` char(1) NOT NULL default '',
`REWARD` varchar(200) NOT NULL default '',
`CERTIFICATE` varchar(200) NOT NULL default '',
`TRAIN` varchar(200) NOT NULL default '',
`RESUME` text NOT NULL,
`PHOTO` varchar(200) NOT NULL default '',
`NO` varchar(200) NOT NULL default '',
`NATION` varchar(200) NOT NULL default '',
`NATIVE_PLACE` varchar(200) NOT NULL default '',
`SPECIALITY` varchar(200) NOT NULL default '',
`SCHOOL` varchar(200) NOT NULL default '',
`DEPARTMENT` varchar(200) NOT NULL default '',
`POST` varchar(200) NOT NULL default '',
`HOME_ADDR` varchar(200) NOT NULL default '',
`HOME_TEL` varchar(200) NOT NULL default '',
`EMAIL` varchar(200) NOT NULL default '',
`EDU` text NOT NULL,
`WORK` text NOT NULL,
`SOCIATY` text NOT NULL,
PRIMARY KEY (`USER_ID`)
) TYPE=MyISAM;
INSERT INTO HRMS VALUES('admin','','','','','','','','','','','','','','','','','','','','','','','','');
DROP TABLE IF EXISTS ICQCONTACT_TB;
CREATE TABLE `icqcontact_tb` (
`UIN` int(11) default NULL,
`Contact` int(11) default NULL,
UNIQUE KEY `PrimaryKey` (`UIN`,`Contact`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS ICQMSGS_TB;
CREATE TABLE `icqmsgs_tb` (
`touin` int(11) default NULL,
`fromuin` int(11) default NULL,
`message_date` datetime default NULL,
`message_size` int(11) default NULL,
`message_part` int(11) default NULL,
`message_type` int(11) default NULL,
`message_body` mediumtext,
KEY `icqmsgs_uin_idx` (`touin`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS ICQSERVERMSG_TB;
CREATE TABLE `icqservermsg_tb` (
`id` int(11) unsigned NOT NULL auto_increment,
`fromuin` int(11) default NULL,
`message_date` datetime default NULL,
`message_cat` int(11) default NULL,
`message_size` int(11) default NULL,
`message_part` int(11) default NULL,
`message_type` int(11) default NULL,
`message_body` mediumtext,
KEY `id` (`id`),
KEY `icqservermsg_cat_idx` (`message_cat`),
KEY `icqservermsg_date_idx` (`message_date`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS IK_APP;
CREATE TABLE `ik_app` (
`APP_ID` int(11) NOT NULL auto_increment,
`FORM_ID` int(11) NOT NULL default '0',
`APP_TYPE` varchar(10) NOT NULL default '',
`APP_FLD_VIEW` text NOT NULL,
`APP_FLD_READONLY` text NOT NULL,
`APP_FLD_LIST` text NOT NULL,
`APP_FLD_REPORT` text NOT NULL,
`APP_FLD_CTRL` varchar(10) NOT NULL default '',
`APP_DESC` text NOT NULL,
`APP_RETURN` text NOT NULL,
`FUNC_ID` varchar(200) NOT NULL default '',
`EDIT_APP_ID` varchar(200) NOT NULL default '',
PRIMARY KEY (`APP_ID`)
) TYPE=MyISAM;
INSERT INTO IK_APP VALUES('20','11','1','M_ID,M_STATUS,','M_REQUEST_TIME,M_PROPOSER,','','','0','会议申请','/general/meeting/','38','');
INSERT INTO IK_APP VALUES('21','11','3','M_ID,M_STATUS,','M_PROPOSER,M_REQUEST_TIME,','','','0','会议申请修改','/general/meeting/','40','');
INSERT INTO IK_APP VALUES('23','12','1','MR_ID,','','','','0','添加会议室','/general/meeting/meeting_room/','80','');
INSERT INTO IK_APP VALUES('24','12','3','MR_ID,','','','','0','会议室基本信息修改','/general/meeting/meeting_room/','80','');
INSERT INTO IK_APP VALUES('25','13','1','V_ID,','','V_NUM,V_MODEL','','0','添加车辆','/general/vehicle/manage','77','');
INSERT INTO IK_APP VALUES('26','13','3','V_ID,','','','','0','车辆基本信息修改','/general/vehicle/manage','77','');
INSERT INTO IK_APP VALUES('28','14','1','VU_ID,VU_STATUS,','VU_REQUEST_DATE,VU_PROPOSER,','','','0','车辆使用申请','/general/vehicle','32','');
INSERT INTO IK_APP VALUES('29','14','3','VU_ID,VU_STATUS,','VU_REQUEST_DATE,VU_PROPOSER,','','','0','车辆使用记录修改','/general/vehicle','77','');
INSERT INTO IK_APP VALUES('31','15','1','VM_ID,','','V_ID,VM_REQUEST_DATE,VM_TYPE,VM_FEE,VM_PERSON,','','0','添加车辆维护记录','/general/vehicle/maintenance','76','');
INSERT INTO IK_APP VALUES('32','15','3','VM_ID,','V_ID,','','','0','车辆维护记录修改','/general/vehicle/maintenance','76','');
INSERT INTO IK_APP VALUES('33','15','4','VM_ID,','','V_ID,VM_REQUEST_DATE,VM_TYPE,VM_REASON,VM_FEE,VM_PERSON,VM_REMARK,','VM_FEE,','1','车辆维护记录查询','/general/vehicle/maintenance','76','32');
INSERT INTO IK_APP VALUES('22','11','4','M_ID,','','M_NAME,M_TOPIC,M_DESC,M_ATTENDEE,M_START,M_END,M_ROOM,','','1','会议查询','/general/meeting/query','39','21');
INSERT INTO IK_APP VALUES('30','14','4','VU_ID,','','V_ID,VU_USER,VU_REASON,VU_START,VU_END,VU_MILEAGE,VU_DEPT,VU_STATUS,VU_REMARK,','VU_MILEAGE,','1','车辆使用记录查询','/general/vehicle/query','33','29');
DROP TABLE IF EXISTS IK_FIELD;
CREATE TABLE `ik_field` (
`FIELD_ID` int(11) NOT NULL auto_increment,
`TABLE_ID` int(11) NOT NULL default '0',
`FIELD_NAME` varchar(200) NOT NULL default '',
`FIELD_DESC` varchar(200) NOT NULL default '',
`FIELD_TYPE` varchar(10) NOT NULL default '',
`FIELD_LEN` int(11) NOT NULL default '0',
`FIELD_DEFVALUE` text NOT NULL,
`FIELD_AUTOVALUE` varchar(10) NOT NULL default '',
`FIELD_INDEX` varchar(10) NOT NULL default '',
`FIELD_CODE_FIX` text NOT NULL,
`FIELD_CODE_SQL` text NOT NULL,
`FIELD_INTERFACE_TYPE` varchar(10) NOT NULL default '',
`FIELD_RELATION` varchar(200) NOT NULL default '',
PRIMARY KEY (`FIELD_ID`)
) TYPE=MyISAM;
INSERT INTO IK_FIELD VALUES('52','8','MR_ID','编号','N','0','','','1','','','1','');
INSERT INTO IK_FIELD VALUES('53','8','MR_NAME','名称','C','50','','','0','','','1','');
INSERT INTO IK_FIELD VALUES('54','8','MR_CAPACITY','可容纳人数','T','0','','','0','','','1','');
INSERT INTO IK_FIELD VALUES('55','8','MR_DEVICE','设备情况','T','0','','','0','','','2','');
INSERT INTO IK_FIELD VALUES('56','8','MR_DESC','会议室描述','T','0','','','0','','','2','');
INSERT INTO IK_FIELD VALUES('57','8','MR_PLACE','地点','C','200','','','0','','','1','');
INSERT INTO IK_FIELD VALUES('58','7','M_ID','编号','N','0','','','1','','','1','');
INSERT INTO IK_FIELD VALUES('59','7','M_NAME','名称','C','50','','','0','','','1','');
INSERT INTO IK_FIELD VALUES('60','7','M_TOPIC','主题','C','200','','','0','','','1','');
INSERT INTO IK_FIELD VALUES('61','7','M_DESC','描述','T','0','','','0','','','2','');
INSERT INTO IK_FIELD VALUES('62','7','M_PROPOSER','申请人','C','20','','','0','','','1','LOGIN_USER_NAME');
INSERT INTO IK_FIELD VALUES('63','7','M_REQUEST_TIME','申请时间','D','0','','DT','0','','','1','');
INSERT INTO IK_FIELD VALUES('','7','M_ATTENDEE','出席人员','T','0','','','0','','','2','');
INSERT INTO IK_FIELD VALUES('65','7','M_START','开始时间','D','0','','DT','0','','','1','');
INSERT INTO IK_FIELD VALUES('66','7','M_END','结束时间','D','0','','DT','0','','','1','');
INSERT INTO IK_FIELD VALUES('67','7','M_ROOM','会议室','N','0','','','0','','select MR_ID,MR_NAME from MEETING_ROOM','3','');
INSERT INTO IK_FIELD VALUES('68','7','M_STATUS','状态','C','10','1','','0','','','1','');
INSERT INTO IK_FIELD VALUES('69','11','VM_ID','编号','N','0','','','1','','','1','');
INSERT INTO IK_FIELD VALUES('70','11','V_ID','车牌号','C','20','','','0','','select V_ID,V_NUM from vehicle ','3','');
INSERT INTO IK_FIELD VALUES('71','11','VM_REQUEST_DATE','维护日期','D','0','','D','0','','','1','');
INSERT INTO IK_FIELD VALUES('72','11','VM_TYPE','维护类型','C','20','','','0','维修,加油,洗车,年检,其它','','3','');
INSERT INTO IK_FIELD VALUES('73','11','VM_REASON','维护原因','T','0','','','0','','','2','');
INSERT INTO IK_FIELD VALUES('74','11','VM_FEE','维护费用','N','0','0','','0','','','1','');
INSERT INTO IK_FIELD VALUES('75','11','VM_PERSON','经办人','C','20','','','0','','','1','');
INSERT INTO IK_FIELD VALUES('76','11','VM_REMARK','备注','T','0','','','0','','','2','');
INSERT INTO IK_FIELD VALUES('77','10','VU_ID','编号','N','0','','','1','','','1','');
INSERT INTO IK_FIELD VALUES('78','10','V_ID','车牌号','C','20','','','0','','select V_ID,V_NUM from vehicle where V_STATUS = 0','3','');
INSERT INTO IK_FIELD VALUES('79','10','VU_REQUEST_DATE','申请日期','D','0','','DT','0','','','1','');
INSERT INTO IK_FIELD VALUES('80','10','VU_USER','用车人','C','20','','','0','','select USER_ID,USER_NAME from user','6','');
INSERT INTO IK_FIELD VALUES('81','10','VU_REASON','事由','T','0','','','0','','','2','');
INSERT INTO IK_FIELD VALUES('82','10','VU_START','起始时间','D','0','','DT','0','','','1','');
INSERT INTO IK_FIELD VALUES('83','10','VU_END','结束时间','D','0','','DT','0','','','1','');
INSERT INTO IK_FIELD VALUES('84','10','VU_MILEAGE','里程','N','0','0','','0','','','1','');
INSERT INTO IK_FIELD VALUES('85','10','VU_DEPT','用车部门','C','20','','','0','','select DEPT_ID,DEPT_NAME from DEPARTMENT','4','');
INSERT INTO IK_FIELD VALUES('86','10','VU_STATUS','当前状态','C','20','','','0','待批,已准,使用中,未准,结束','','3','');
INSERT INTO IK_FIELD VALUES('87','10','VU_REMARK','备注','T','0','','','0','','','2','');
INSERT INTO IK_FIELD VALUES('88','9','V_ID','编号','N','0','','','1','','','1','');
INSERT INTO IK_FIELD VALUES('89','9','V_MODEL','厂牌型号','C','200','','','0','','','1','');
INSERT INTO IK_FIELD VALUES('90','9','V_NUM','车牌号','C','20','','','0','','','1','');
INSERT INTO IK_FIELD VALUES('91','9','V_DRIVER','驾驶员','C','20','','','0','','','1','');
INSERT INTO IK_FIELD VALUES('92','9','V_TYPE','车辆类型','C','20','','','0','轿车,面包车,越野车,吉普车,巴士,工具车','','3','');
INSERT INTO IK_FIELD VALUES('93','9','V_DATE','购置日期','D','0','','D','0','','','1','');
INSERT INTO IK_FIELD VALUES('94','9','V_PRICE','购买价格','N','0','','','0','','','1','');
INSERT INTO IK_FIELD VALUES('95','9','V_ENGINE_NUM','发动机号码','C','20','','','0','','','1','');
INSERT INTO IK_FIELD VALUES('96','9','V_STATUS','当前状态','C','20','','','0','可用,损坏,维修中,报废','','3','');
INSERT INTO IK_FIELD VALUES('97','9','V_REMARK','备注','T','0','','','0','','','2','');
INSERT INTO IK_FIELD VALUES('98','10','VU_PROPOSER','申请人','C','20','','','0','','','1','LOGIN_USER_NAME');
INSERT INTO IK_FIELD VALUES('99','12','PLAN_ID','编号','N','0','','','1','','','1','');
INSERT INTO IK_FIELD VALUES('100','12','NAME','计划名称','C','200','','','0','','','1','');
INSERT INTO IK_FIELD VALUES('101','12','CONTENT','计划内容','T','0','','','0','','','2','');
INSERT INTO IK_FIELD VALUES('102','12','BEGIN_DATE','开始时间','D','0','','D','0','','','1','');
INSERT INTO IK_FIELD VALUES('103','12','END_DATE','结束时间','D','0','','D','0','','','1','');
INSERT INTO IK_FIELD VALUES('104','12','TYPE','计划类别','C','20','','','0','工作计划,项目计划,经营计划,生产计划,销售计划,采购计划','','3','');
INSERT INTO IK_FIELD VALUES('105','12','TO_ID','发布范围（部门）','C','20','','','0','','select DEPT_ID,DEPT_NAME from DEPARTMENT','4','');
INSERT INTO IK_FIELD VALUES('106','12','MANAGER','负责人','C','254','','','0','','','1','');
INSERT INTO IK_FIELD VALUES('107','12','PARTICIPATOR','参与人','C','254','','','0','','','1','');
INSERT INTO IK_FIELD VALUES('108','12','CREATOR','创建人','C','20','','','0','','','1','');
INSERT INTO IK_FIELD VALUES('109','12','CREATE_DATE','创建时间','D','0','','D','0','','','1','');
INSERT INTO IK_FIELD VALUES('110','12','ATTACHMENT_ID','附件编号','C','20','','','0','','','1','');
INSERT INTO IK_FIELD VALUES('111','12','ATTACHMENT_NAME','附件名称','C','200','','','0','','','1','');
INSERT INTO IK_FIELD VALUES('112','12','ATTACHMENT_COMMENT','附件说明','T','0','','','0','','','2','');
INSERT INTO IK_FIELD VALUES('113','12','REMARK','备注','T','0','','','0','','','2','');
INSERT INTO IK_FIELD VALUES('114','13','LOG_ID','登录编号','N','0','','','1','','','1','');
INSERT INTO IK_FIELD VALUES('115','13','USER_ID','用户名','C','20','','','0','','','1','');
INSERT INTO IK_FIELD VALUES('116','13','TIME','登录时间','D','0','','DT','0','','','1','');
INSERT INTO IK_FIELD VALUES('117','13','IP','用户IP','C','20','','','0','','','1','');
INSERT INTO IK_FIELD VALUES('118','13','TYPE','登录类型','C','10','','','0','登录，','','3','');
INSERT INTO IK_FIELD VALUES('119','14','IP_ID','编号','N','0','','','1','','','1','');
INSERT INTO IK_FIELD VALUES('120','14','BEGIN_IP','起始IP','C','20','','','0','','','1','');
INSERT INTO IK_FIELD VALUES('121','14','END_IP','结束IP','C','20','','','0','','','1','');
INSERT INTO IK_FIELD VALUES('122','14','TYPE','规则类型','C','10','0','','0','','','1','');
- 一份OA的数据库设计
- OA系统中 流程审批数据库的设计
- OA系统的设计文档
- OA系统的设计原则
- java OA 系统开发二：数据库设计之oa数据库设计
- 复制一份完整的全新的数据库
- 如何设计一份令人舒服的PPT
- OA权限管理设计的实现 下
- OA设计的6大原则
- OA软件的联网设计优势
- 项目OA之实体类的设计
- OA系统 权限管理的设计流程
- 一份关于连接数据库的Util类
- 一份访问SqlServer数据库的Helper类
- OA流程表设计
- 4、OA分页设计
- OA权限系统设计
- oa权限设计
- sunshine
- 不平衡
- Argument list too long
- 十大社区
- 一个男人的品位在于选择妻子
- 一份OA的数据库设计
- 陈年重返B2C市场 卓越骨干班底创办Vancl.com
- 验证码--数字和英文
- 复习JSTL
- Struts建立MVC应用
- RTSP（Real Time Streaming Protocol）
- js常识
- 验证码--汉字
- ASP.NET 2.0 之 Master Page 学习笔记
