數據字典 · 專利平臺文檔

## 數據字典 ```[sql] -- ---------------------------- -- Table structure for `xinhu_1` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_1`; CREATE TABLE `xinhu_1` ( `id` int(11) NOT NULL AUTO_INCREMENT , `mid` int(11) NULL DEFAULT 0 COMMENT '對應主表buzheng.id' , `sort` int(11) NULL DEFAULT 0 COMMENT '排序號' , PRIMARY KEY (`id`), INDEX `mid` (`mid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_11` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_11`; CREATE TABLE `xinhu_11` ( `id` int(11) NOT NULL AUTO_INCREMENT , `mid` int(11) NULL DEFAULT 0 COMMENT '對應主表buzheng.id' , `sort` int(11) NULL DEFAULT 0 COMMENT '排序號' , PRIMARY KEY (`id`), INDEX `mid` (`mid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_2` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_2`; CREATE TABLE `xinhu_2` ( `id` int(11) NOT NULL AUTO_INCREMENT , `mid` int(11) NULL DEFAULT 0 COMMENT '對應主表buzheng.id' , `sort` int(11) NULL DEFAULT 0 COMMENT '排序號' , PRIMARY KEY (`id`), INDEX `mid` (`mid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_22` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_22`; CREATE TABLE `xinhu_22` ( `id` int(11) NOT NULL AUTO_INCREMENT , `mid` int(11) NULL DEFAULT 0 COMMENT '對應主表buzheng.id' , `sort` int(11) NULL DEFAULT 0 COMMENT '排序號' , PRIMARY KEY (`id`), INDEX `mid` (`mid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_admin` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_admin`; CREATE TABLE `xinhu_admin` ( `id` int(11) NOT NULL AUTO_INCREMENT , `num` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '編號' , `user` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用戶名' , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名' , `pass` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密碼' , `loginci` smallint(6) NULL DEFAULT 0 COMMENT '登錄次數' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '是否啟用' , `type` tinyint(1) NULL DEFAULT 0 COMMENT '0普通1管理員' , `sex` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性別' , `tel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '電話' , `face` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '頭像地址' , `deptid` int(11) NULL DEFAULT 0 COMMENT '主部門ID' , `deptname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部門' , `deptids` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '其他部門ID' , `deptnames` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '多部門' , `rankings` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '多職位' , `deptallname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部門全部路徑' , `superid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `superman` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上級主管' , `ranking` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '崗位' , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序號' , `deptpath` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部門路徑' , `superpath` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上級主管路徑' , `groupname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `mobile` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `apptx` tinyint(1) NULL DEFAULT 1 COMMENT '是否app提醒' , `workdate` date NULL DEFAULT NULL COMMENT '入職時間' , `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '郵箱' , `lastpush` datetime NULL DEFAULT NULL COMMENT '最后app推送時間' , `adddt` datetime NULL DEFAULT NULL COMMENT '新增時間' , `weixinid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信號' , `quitdt` date NULL DEFAULT NULL COMMENT '離職日期' , `style` tinyint(2) NULL DEFAULT 0 COMMENT '默認樣式' , `pingyin` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名字拼音' , `emailpass` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '郵箱密碼' , `companyid` int(11) NULL DEFAULT 0 COMMENT '所在公司單位Id' , `online` tinyint(1) NULL DEFAULT 0 COMMENT '在線狀態' , `lastonline` datetime NULL DEFAULT NULL COMMENT '最后在線時間' , `isvcard` tinyint(1) NULL DEFAULT 1 COMMENT '是否在通訊錄上顯示' , `randslat` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '隨機字符串' , PRIMARY KEY (`id`, `user`), INDEX `email` (`email`) USING BTREE , INDEX `status` (`status`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='用戶表' AUTO_INCREMENT=10 ; -- ---------------------------- -- Table structure for `xinhu_applicant` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_applicant`; CREATE TABLE `xinhu_applicant` ( `id` int(11) NOT NULL AUTO_INCREMENT , `sqname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申請人姓名' , `applytype` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申請人類型' , `certificate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '證件號碼' , `sheng` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所在省' , `shi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所在市' , `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址' , `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '郵箱' , `tel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '電話' , `reductfee` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '費減狀態' , `beiandate` date NULL DEFAULT NULL COMMENT '備案期限' , `remark` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '備注' , `custid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所屬客戶' , `custname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所屬客戶' , `uid` int(11) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` int(11) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=6 ; -- ---------------------------- -- Table structure for `xinhu_assetm` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_assetm`; CREATE TABLE `xinhu_assetm` ( `id` int(11) NOT NULL AUTO_INCREMENT , `typeid` smallint(6) NULL DEFAULT 0 COMMENT '類別' , `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名稱' , `num` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '編號' , `brand` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '品牌' , `model` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '規格型號' , `laiyuan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '來源' , `shuname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所屬部門' , `dt` date NULL DEFAULT NULL COMMENT '日期' , `ckid` smallint(50) NULL DEFAULT 0 COMMENT '存放地點' , `state` tinyint(1) NULL DEFAULT 0 COMMENT '狀態' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `adddt` datetime NULL DEFAULT NULL COMMENT '添加時間' , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `buydt` date NULL DEFAULT NULL COMMENT '購進日期' , `price` decimal(10,2) NULL DEFAULT NULL COMMENT '價格' , `optid` smallint(6) NULL DEFAULT 0 , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `useid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' , `usename` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '使用人' , `fengmian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '封面圖片' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='固定資產表' AUTO_INCREMENT=9 ; -- ---------------------------- -- Table structure for `xinhu_book` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_book`; CREATE TABLE `xinhu_book` ( `id` int(11) NOT NULL AUTO_INCREMENT , `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '書名' , `typeid` smallint(6) NULL DEFAULT 0 COMMENT '對應分類' , `num` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '編號' , `author` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作者' , `chuban` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出版社' , `cbdt` date NULL DEFAULT NULL COMMENT '出版日期' , `price` decimal(10,2) NULL DEFAULT 0.00 COMMENT '價格' , `weizhi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '存放位置' , `shul` smallint(6) NULL DEFAULT 0 COMMENT '數量' , `adddt` datetime NULL DEFAULT NULL , `optdt` datetime NULL DEFAULT NULL , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `optid` smallint(6) NULL DEFAULT 0 , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `isbn` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `jieshu` smallint(6) NULL DEFAULT 0 COMMENT '被借閱數' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='圖書表' AUTO_INCREMENT=5 ; -- ---------------------------- -- Table structure for `xinhu_bookborrow` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_bookborrow`; CREATE TABLE `xinhu_bookborrow` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` smallint(6) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `bookid` smallint(6) NULL DEFAULT 0 , `bookname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '書名' , `jydt` date NULL DEFAULT NULL COMMENT '借閱日期' , `yjdt` date NULL DEFAULT NULL COMMENT '預計歸還' , `ghtime` datetime NULL DEFAULT NULL COMMENT '歸還時間' , `isgh` tinyint(1) NULL DEFAULT 0 COMMENT '是否歸返' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='圖書借閱' AUTO_INCREMENT=4 ; -- ---------------------------- -- Table structure for `xinhu_buzheng` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_buzheng`; CREATE TABLE `xinhu_buzheng` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` int(11) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `casename` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案件名稱' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_carm` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_carm`; CREATE TABLE `xinhu_carm` ( `id` int(11) NOT NULL AUTO_INCREMENT , `carnum` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '車牌號' , `carbrand` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '車輛品牌' , `carmode` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '型號' , `cartype` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '車輛類型' , `buydt` date NULL DEFAULT NULL COMMENT '購買日期' , `buyprice` mediumint(9) NULL DEFAULT NULL COMMENT '購買價格' , `enginenb` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '發動機號' , `ispublic` tinyint(1) NULL DEFAULT 1 COMMENT '是否公開使用' , `optdt` datetime NULL DEFAULT NULL , `optid` smallint(6) NULL DEFAULT NULL , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `adddt` datetime NULL DEFAULT NULL , `createname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `state` tinyint(1) NULL DEFAULT 0 COMMENT '狀態@0|辦理中,1|可用,2|維修中,3|報廢' , `framenum` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '車架號' , `status` tinyint(4) NULL DEFAULT 1 , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='車輛表' AUTO_INCREMENT=3 ; -- ---------------------------- -- Table structure for `xinhu_carmang` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_carmang`; CREATE TABLE `xinhu_carmang` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` smallint(6) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `carid` smallint(6) NULL DEFAULT 0 COMMENT '維修車輛' , `reason` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '維修原因' , `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '維修地點' , `jianame` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '駕駛員' , `jiaid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `bujian` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更換部件' , `startdt` datetime NULL DEFAULT NULL COMMENT '維修時間' , `enddt` datetime NULL DEFAULT NULL COMMENT '維修截止時間' , `money` decimal(8,2) NULL DEFAULT 0.00 COMMENT '維修金額' , `type` tinyint(1) NULL DEFAULT 0 COMMENT '類型@0|車輛維修,1|保養' , `nextdt` date NULL DEFAULT NULL COMMENT '下次保養日期' , `kmshu` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '當前保養公里數' , `kmnshu` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '下次保養公里數' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='車輛維修保養記錄表' AUTO_INCREMENT=3 ; -- ---------------------------- -- Table structure for `xinhu_carmrese` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_carmrese`; CREATE TABLE `xinhu_carmrese` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` int(11) NULL DEFAULT NULL , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` int(11) NULL DEFAULT NULL , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 0 , `isturn` tinyint(1) NULL DEFAULT 0 , `useid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `usename` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '使用者' , `useren` smallint(6) NULL DEFAULT 0 COMMENT '使用人數' , `startdt` datetime NULL DEFAULT NULL COMMENT '開始時間' , `enddt` datetime NULL DEFAULT NULL COMMENT '截止時間' , `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '目的地' , `carid` smallint(6) NULL DEFAULT NULL , `carnum` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '使用車輛' , `xianlines` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '線路' , `jiaid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `jianame` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '駕駛員' , `kmstart` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '起始公里數' , `kmend` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '結束公里數' , `returndt` datetime NULL DEFAULT NULL COMMENT '歸還時間' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='車輛預定' AUTO_INCREMENT=8 ; -- ---------------------------- -- Table structure for `xinhu_carms` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_carms`; CREATE TABLE `xinhu_carms` ( `id` int(11) NOT NULL AUTO_INCREMENT , `carid` int(11) NULL DEFAULT 0 COMMENT '車輛Id' , `otype` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '類型,加油' , `startdt` date NULL DEFAULT NULL , `enddt` date NULL DEFAULT NULL COMMENT '截止時間' , `money` decimal(8,2) NULL DEFAULT 0.00 COMMENT '花費金額' , `optid` int(11) NULL DEFAULT 0 COMMENT '添加人id' , `optdt` datetime NULL DEFAULT NULL , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '添加人' , `status` tinyint(1) NULL DEFAULT 0 COMMENT '狀態' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `unitname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應名稱' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地點' , `jiaid` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `jianame` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '駕駛員' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='車輛信息登記表' AUTO_INCREMENT=4 ; -- ---------------------------- -- Table structure for `xinhu_chargems` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_chargems`; CREATE TABLE `xinhu_chargems` ( `id` int(11) NOT NULL AUTO_INCREMENT , `type` tinyint(1) NULL DEFAULT 0 , `mid` smallint(6) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL , `updatedt` datetime NULL DEFAULT NULL , `key` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `modeid` smallint(6) NULL DEFAULT 0 COMMENT '對應安裝模塊Id' , PRIMARY KEY (`id`), INDEX `type` (`type`, `mid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='系統升級' AUTO_INCREMENT=94 ; -- ---------------------------- -- Table structure for `xinhu_city` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_city`; CREATE TABLE `xinhu_city` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT , `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '上級ＩＤ' , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' , `type` tinyint(1) NOT NULL DEFAULT 2 COMMENT '類型0國家,1省,2市,3縣' , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序' , `pinyin` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `pinyins` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '拼音簡稱' , PRIMARY KEY (`id`), INDEX `parent_id` (`pid`) USING BTREE , INDEX `region_type` (`type`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='城市表' AUTO_INCREMENT=3409 ; -- ---------------------------- -- Table structure for `xinhu_company` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_company`; CREATE TABLE `xinhu_company` ( `id` int(11) NOT NULL AUTO_INCREMENT , `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司名稱' , `nameen` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '英文名' , `tel` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '電話' , `fax` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '傳真' , `pid` int(11) NULL DEFAULT 0 COMMENT '對應上級' , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序號' , `fuzeid` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應負責人Id' , `fuzename` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應負責人' , `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址' , `city` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所在城市' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='公司單位表' AUTO_INCREMENT=5 ; -- ---------------------------- -- Table structure for `xinhu_cusorder` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_cusorder`; CREATE TABLE `xinhu_cusorder` ( `id` int(11) NOT NULL AUTO_INCREMENT , `mid` int(11) NULL DEFAULT 0 COMMENT '對應主表custract.id' , `sort` int(11) NULL DEFAULT 0 COMMENT '排序號' , `fuwutype` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '服務項目' , `salename` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '銷售人員' , `saleid` smallint(6) NULL DEFAULT NULL COMMENT '銷售人員的ID' , `givedt` date NULL DEFAULT NULL COMMENT '交付日期' , `unitprice` smallint(6) NULL DEFAULT NULL COMMENT '單價' , `gfee` smallint(6) NULL DEFAULT NULL COMMENT '預收官費' , `num` smallint(6) NULL DEFAULT NULL COMMENT '數量' , PRIMARY KEY (`id`), INDEX `mid` (`mid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=2 ; -- ---------------------------- -- Table structure for `xinhu_custappy` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_custappy`; CREATE TABLE `xinhu_custappy` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` smallint(6) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `custid` int(11) NULL DEFAULT 0 COMMENT '客戶ID' , `custname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客戶名稱' , PRIMARY KEY (`id`), INDEX `custid` (`custid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='客戶申請使用' AUTO_INCREMENT=5 ; -- ---------------------------- -- Table structure for `xinhu_custbill` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_custbill`; CREATE TABLE `xinhu_custbill` ( `id` int(11) NOT NULL AUTO_INCREMENT , `mid` int(11) NULL DEFAULT 0 COMMENT '對應主表custfina.id' , `sort` int(11) NULL DEFAULT 0 COMMENT '排序號' , `uid` int(11) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` int(11) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `account` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '賬戶' , `money` smallint(6) NULL DEFAULT NULL COMMENT '金額' , `suredt` date NULL DEFAULT NULL COMMENT '支付時間' , `remark` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '備注' , PRIMARY KEY (`id`), INDEX `mid` (`mid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_custfina` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_custfina`; CREATE TABLE `xinhu_custfina` ( `id` int(11) NOT NULL AUTO_INCREMENT , `htid` int(11) NULL DEFAULT 0 COMMENT '合同ID' , `htnum` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `dt` date NULL DEFAULT NULL COMMENT '所屬日期' , `uid` smallint(6) NULL DEFAULT 0 , `custid` smallint(6) NULL DEFAULT 0 , `custname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客戶名稱' , `optdt` datetime NULL DEFAULT NULL , `optname` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `money` decimal(10,2) NULL DEFAULT 0.00 , `type` tinyint(1) NULL DEFAULT 0 COMMENT '0收款單,1付款單' , `ispay` tinyint(1) NULL DEFAULT 0 COMMENT '是否收款,付款' , `paydt` datetime NULL DEFAULT NULL COMMENT '收付款時間' , `explain` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `createdt` datetime NULL DEFAULT NULL COMMENT '創建時間' , `createname` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `createid` smallint(6) NULL DEFAULT 0 , `ismove` tinyint(1) NULL DEFAULT 0 COMMENT '是否轉移的' , PRIMARY KEY (`id`), INDEX `htid` (`htid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='客戶收付款' AUTO_INCREMENT=9 ; -- ---------------------------- -- Table structure for `xinhu_customer` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_customer`; CREATE TABLE `xinhu_customer` ( `id` int(11) NOT NULL AUTO_INCREMENT , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名稱' , `type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客戶類型' , `uid` smallint(6) NULL DEFAULT 0 COMMENT '所屬人' , `optdt` datetime NULL DEFAULT NULL , `optname` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `linkname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '聯系人' , `unitname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '單位名稱' , `laiyuan` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '來源' , `tel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `mobile` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `routeline` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `url` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主頁地址' , `status` tinyint(4) NULL DEFAULT 1 COMMENT '啟用停用' , `adddt` datetime NULL DEFAULT NULL COMMENT '添加時間' , `createname` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `createid` smallint(6) NULL DEFAULT 0 , `shate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '共享給' , `shateid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `isgys` tinyint(1) NULL DEFAULT 0 COMMENT '是否供應商' , `isstat` tinyint(1) NULL DEFAULT 0 COMMENT '是否標*客戶' , `fzid` smallint(6) NULL DEFAULT 0 , `fzname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客戶負責人' , `htshu` smallint(6) NULL DEFAULT 0 COMMENT '合同數' , `moneyz` decimal(10,2) NULL DEFAULT 0.00 COMMENT '銷售總額' , `moneyd` decimal(10,2) NULL DEFAULT 0.00 COMMENT '待收金額' , `sheng` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所在省' , `shi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所在市' , `isgh` tinyint(1) NULL DEFAULT 0 COMMENT '是否放入公海' , `lastdt` datetime NULL DEFAULT NULL COMMENT '最后跟進時間' , `shibieid` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '納稅識別號' , `openbank` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '開戶行' , `cardid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '開戶帳號' , `linkid` smallint(6) NULL DEFAULT NULL COMMENT '聯系人的ID' , `salename` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所屬銷售' , `saleid` smallint(6) NULL DEFAULT NULL COMMENT '所屬銷售的ID' , `adviser` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所屬顧問' , `adviserid` smallint(6) NULL DEFAULT NULL COMMENT '所屬顧問的ID' , `iacinfo` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工商信息' , `remark` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '備注' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='客戶' AUTO_INCREMENT=20 ; -- ---------------------------- -- Table structure for `xinhu_custract` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_custract`; CREATE TABLE `xinhu_custract` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` smallint(6) NULL DEFAULT 0 , `num` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同編號' , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '備注' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `custid` int(11) NULL DEFAULT 0 , `custname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客戶名稱' , `linkman` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客戶聯系人' , `money` decimal(10,2) NULL DEFAULT 0.00 COMMENT '合同金額' , `moneys` decimal(10,2) NULL DEFAULT 0.00 COMMENT '待收金額' , `startdt` date NULL DEFAULT NULL COMMENT '生效日期' , `enddt` date NULL DEFAULT NULL COMMENT '截止日期' , `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '合同內容' , `saleid` smallint(6) NULL DEFAULT 0 COMMENT '銷售機會Id' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `signdt` date NULL DEFAULT NULL COMMENT '簽約日期' , `type` tinyint(1) NULL DEFAULT 0 COMMENT '0收款合同，1付款合同' , `ispay` tinyint(1) NULL DEFAULT 0 COMMENT '0待,1已完成,2部分' , `isover` tinyint(1) NULL DEFAULT 0 COMMENT '是否已全部創建收付款單' , `createname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `createid` smallint(6) NULL DEFAULT 0 , `salename` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '銷售人員' , `givedt` date NULL DEFAULT NULL COMMENT '交付日期' , `lxid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '聯系人' , `lxname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '聯系人' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='客戶合同' AUTO_INCREMENT=7 ; -- ---------------------------- -- Table structure for `xinhu_custsale` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_custsale`; CREATE TABLE `xinhu_custsale` ( `id` int(11) NOT NULL AUTO_INCREMENT , `custid` int(11) NULL DEFAULT 0 , `custname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `uid` smallint(6) NULL DEFAULT 0 , `optname` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `optdt` datetime NULL DEFAULT NULL , `state` tinyint(4) NULL DEFAULT 0 COMMENT '狀態' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `money` decimal(10,2) NULL DEFAULT 0.00 , `applydt` date NULL DEFAULT NULL , `dealdt` datetime NULL DEFAULT NULL COMMENT '成交時間' , `adddt` datetime NULL DEFAULT NULL , `laiyuan` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '銷售來源' , `createid` smallint(6) NULL DEFAULT 0 , `createname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `htid` smallint(6) NULL DEFAULT 0 COMMENT '合同ID' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='銷售機會' AUTO_INCREMENT=7 ; -- ---------------------------- -- Table structure for `xinhu_daily` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_daily`; CREATE TABLE `xinhu_daily` ( `id` int(11) NOT NULL AUTO_INCREMENT , `dt` date NULL DEFAULT NULL COMMENT '日期' , `content` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '內容' , `adddt` datetime NULL DEFAULT NULL COMMENT '新增時間' , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `uid` int(11) NULL DEFAULT NULL , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名' , `type` tinyint(1) NULL DEFAULT 0 COMMENT '類型@0|日報,1|周報,2|月報,3|年報' , `plan` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '明日計劃' , `status` tinyint(1) NULL DEFAULT 0 , `enddt` date NULL DEFAULT NULL , `optid` int(11) NULL DEFAULT NULL , `mark` smallint(6) NULL DEFAULT 0 COMMENT '得分' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='日報' AUTO_INCREMENT=27 ; -- ---------------------------- -- Table structure for `xinhu_dailyfx` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_dailyfx`; CREATE TABLE `xinhu_dailyfx` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` int(11) NULL DEFAULT NULL , `month` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '月份' , `optdt` datetime NULL DEFAULT NULL COMMENT '分析時間' , `day1` tinyint(1) NULL DEFAULT 0 COMMENT '0未寫,1已寫,2請假,3休息日' , `day2` tinyint(1) NULL DEFAULT 0 , `day3` tinyint(1) NULL DEFAULT 0 , `day4` tinyint(1) NULL DEFAULT 0 , `day5` tinyint(1) NULL DEFAULT 0 , `day6` tinyint(1) NULL DEFAULT 0 , `day7` tinyint(1) NULL DEFAULT 0 , `day8` tinyint(1) NULL DEFAULT 0 , `day9` tinyint(1) NULL DEFAULT 0 , `day10` tinyint(1) NULL DEFAULT 0 , `day11` tinyint(1) NULL DEFAULT 0 , `day12` tinyint(1) NULL DEFAULT 0 , `day13` tinyint(1) NULL DEFAULT 0 , `day14` tinyint(1) NULL DEFAULT 0 , `day15` tinyint(1) NULL DEFAULT 0 , `day16` tinyint(1) NULL DEFAULT 0 , `day17` tinyint(1) NULL DEFAULT 0 , `day18` tinyint(1) NULL DEFAULT 0 , `day19` tinyint(1) NULL DEFAULT 0 , `day20` tinyint(1) NULL DEFAULT 0 , `day21` tinyint(1) NULL DEFAULT 0 , `day22` tinyint(1) NULL DEFAULT 0 , `day23` tinyint(1) NULL DEFAULT 0 , `day24` tinyint(1) NULL DEFAULT 0 , `day25` tinyint(1) NULL DEFAULT 0 , `day26` tinyint(1) NULL DEFAULT 0 , `day27` tinyint(1) NULL DEFAULT 0 , `day28` tinyint(1) NULL DEFAULT 0 , `day29` tinyint(1) NULL DEFAULT 0 , `day30` tinyint(1) NULL DEFAULT 0 , `day31` tinyint(1) NULL DEFAULT 0 , `totaly` smallint(6) NULL DEFAULT 0 COMMENT '應寫次數' , `totalx` smallint(6) NULL DEFAULT 0 COMMENT '已寫次數' , `totalw` smallint(6) NULL DEFAULT 0 COMMENT '未寫次數' , `explain` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , PRIMARY KEY (`id`), INDEX `uid` (`uid`, `month`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='日報分析統計表' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_demo` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_demo`; CREATE TABLE `xinhu_demo` ( `id` int(11) NOT NULL AUTO_INCREMENT , `sheng` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '省' , `shi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '市' , `xian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '縣(區)' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `uid` smallint(6) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `tanxuan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '彈出下來單選' , `tanxuancheck` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '彈框下拉多選' , `upfile1` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件上傳1' , `upfile2` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件上傳2' , `testfirs` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '測試字段' , `custname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客戶' , `custid` int(11) NULL DEFAULT 0 COMMENT '客戶id' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='演示測試模塊' AUTO_INCREMENT=6 ; -- ---------------------------- -- Table structure for `xinhu_dept` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_dept`; CREATE TABLE `xinhu_dept` ( `id` int(11) NOT NULL AUTO_INCREMENT , `num` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '編號' , `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `pid` int(11) NULL DEFAULT NULL , `sort` int(11) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL , `headman` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '負責人' , `headid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , PRIMARY KEY (`id`), INDEX `name` (`name`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='組織結構部門' AUTO_INCREMENT=7 ; -- ---------------------------- -- Table structure for `xinhu_editrecord` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_editrecord`; CREATE TABLE `xinhu_editrecord` ( `id` int(11) NOT NULL AUTO_INCREMENT , `fieldsname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字段名稱' , `oldval` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原來值' , `newval` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '新值' , `table` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `mid` int(11) NULL DEFAULT NULL , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` smallint(6) NULL DEFAULT NULL COMMENT '操作人Id' , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `editci` smallint(6) NULL DEFAULT 0 COMMENT '第幾次修改記錄' , PRIMARY KEY (`id`), INDEX `table` (`table`, `mid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='修改記錄表' AUTO_INCREMENT=5 ; -- ---------------------------- -- Table structure for `xinhu_email_cont` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_email_cont`; CREATE TABLE `xinhu_email_cont` ( `id` int(11) NOT NULL AUTO_INCREMENT , `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '標題' , `body` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '內容' , `receid` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' , `recename` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接收人' , `receemail` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接收郵件' , `optdt` datetime NULL DEFAULT NULL , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '添加人' , `status` tinyint(1) NULL DEFAULT 0 COMMENT '0待發送,1成功,2失敗' , `senddt` datetime NULL DEFAULT NULL COMMENT '發送時間' , `ccname` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '抄送給' , `ccemail` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '抄送郵件' , `attachpath` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '附件路徑' , `attachname` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '福建名稱' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='系統發送郵件內容' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_emailm` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_emailm`; CREATE TABLE `xinhu_emailm` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` smallint(6) NULL DEFAULT 0 COMMENT '用戶iD' , `title` varchar(220) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主題' , `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '郵件內容' , `sendid` smallint(6) NULL DEFAULT NULL , `sendname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '發送人' , `senddt` datetime NULL DEFAULT NULL COMMENT '發送時間' , `receid` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `recename` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接收人' , `isturn` tinyint(1) NULL DEFAULT 0 COMMENT '@0|草稿,1|已發送' , `hid` smallint(6) NULL DEFAULT 0 COMMENT '@回復id' , `isfile` tinyint(1) NULL DEFAULT 0 COMMENT '@是否有附件' , `applydt` date NULL DEFAULT NULL , `message_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '郵件Id' , `fromemail` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '發送人郵件' , `toemail` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '發給郵件人' , `reply_toemail` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '回復郵件' , `ccemail` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '抄送給' , `size` int(11) NULL DEFAULT 0 COMMENT '郵件大小' , `ccname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '抄送給' , `ccid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `type` tinyint(1) NULL DEFAULT 0 COMMENT '0內部郵件,1用郵件外發' , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `numoi` int(11) NULL DEFAULT 0 , PRIMARY KEY (`id`), INDEX `message_id` (`message_id`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='郵件主表' AUTO_INCREMENT=21 ; -- ---------------------------- -- Table structure for `xinhu_emails` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_emails`; CREATE TABLE `xinhu_emails` ( `id` int(11) NOT NULL AUTO_INCREMENT , `mid` int(11) NULL DEFAULT 0 , `uid` smallint(6) NULL DEFAULT 0 , `zt` tinyint(1) NULL DEFAULT 0 COMMENT '@0|未讀,1|已讀' , `type` tinyint(1) NULL DEFAULT 0 COMMENT '0接收,1抄送,2發送者' , `ishui` tinyint(1) NULL DEFAULT 0 COMMENT '是否回復' , `isdel` tinyint(1) NULL DEFAULT 0 COMMENT '@0|未刪,1|已刪' , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `personal` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '人員' , PRIMARY KEY (`id`), INDEX `mid` (`mid`, `email`, `type`) USING BTREE , INDEX `mid_2` (`mid`, `uid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='郵件子表' AUTO_INCREMENT=24 ; -- ---------------------------- -- Table structure for `xinhu_feiyong` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_feiyong`; CREATE TABLE `xinhu_feiyong` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` int(11) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_file` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_file`; CREATE TABLE `xinhu_file` ( `id` int(11) NOT NULL AUTO_INCREMENT , `filenum` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件編號' , `valid` tinyint(4) NULL DEFAULT 1 , `filename` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `filetype` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `fileext` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `filesize` int(11) NULL DEFAULT NULL , `filesizecn` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `filepath` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `thumbpath` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `optid` int(11) NULL DEFAULT NULL , `optname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上傳者' , `adddt` datetime NULL DEFAULT NULL , `ip` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `web` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `mtype` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應類型' , `mid` int(11) NULL DEFAULT 0 COMMENT '管理id' , `downci` int(11) NULL DEFAULT 0 COMMENT '下載次數' , `keyoi` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應序號郵件附件中用到' , `pdfpath` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '轉pdf后路徑' , `oid` int(11) NULL DEFAULT 0 COMMENT '舊ID' , `mknum` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模塊編號' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='上傳文件記錄表' AUTO_INCREMENT=28 ; -- ---------------------------- -- Table structure for `xinhu_files` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_files`; CREATE TABLE `xinhu_files` ( `id` int(11) NOT NULL AUTO_INCREMENT , `table` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `mid` int(11) NULL DEFAULT 0 , `fileid` int(11) NULL DEFAULT 0 COMMENT '關聯file.id' , `optid` int(11) NULL DEFAULT 0 , PRIMARY KEY (`id`), INDEX `table` (`table`, `mid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='文件子表' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_fininfom` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_fininfom`; CREATE TABLE `xinhu_fininfom` ( `id` int(11) NOT NULL AUTO_INCREMENT , `type` tinyint(2) NULL DEFAULT 0 COMMENT '類型@0|報銷單,1|出差報銷,2|借款單,3|還款單,4|付款申請,5|開票申請' , `uid` int(11) NULL DEFAULT NULL , `money` decimal(10,2) NULL DEFAULT 0.00 COMMENT '金額' , `moneycn` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '大寫金額' , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` int(11) NULL DEFAULT NULL , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 0 , `isturn` tinyint(1) NULL DEFAULT 0 , `bills` smallint(6) NULL DEFAULT NULL COMMENT '附單據(張)' , `paytype` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '付款方式' , `fullname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收款人全稱' , `cardid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收款帳號' , `openbank` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '開戶行' , `purpose` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用途' , `purresult` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `paydt` date NULL DEFAULT NULL COMMENT '付款日期' , `num` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同號/訂單號' , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '開票名稱' , `shibieid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '納稅識別號' , `address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司地址' , `tel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '電話' , `custid` int(11) NULL DEFAULT 0 COMMENT '對應客戶ID' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='費用報銷' AUTO_INCREMENT=12 ; -- ---------------------------- -- Table structure for `xinhu_fininfos` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_fininfos`; CREATE TABLE `xinhu_fininfos` ( `id` int(11) NOT NULL AUTO_INCREMENT , `mid` smallint(6) NULL DEFAULT 0 COMMENT '對應主表fininfom.id' , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序號' , `sdt` date NULL DEFAULT NULL COMMENT '發生日期' , `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所屬項目' , `money` decimal(10,2) NULL DEFAULT 0.00 COMMENT '金額' , `sm` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `didian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '發生地點' , PRIMARY KEY (`id`), INDEX `mid` (`mid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='費用報銷子表' AUTO_INCREMENT=10 ; -- ---------------------------- -- Table structure for `xinhu_finpiao` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_finpiao`; CREATE TABLE `xinhu_finpiao` ( `id` int(11) NOT NULL AUTO_INCREMENT , `optname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `optdt` datetime NULL DEFAULT NULL , `optid` int(11) NULL DEFAULT 0 , `custid` int(11) NULL DEFAULT 0 COMMENT '對應客戶ID' , `maicustname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '購買方' , `maicustid` int(11) NULL DEFAULT 0 COMMENT '購買方Id' , `type` tinyint(1) NULL DEFAULT 0 COMMENT '0開,1收到' , `custname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客戶名稱' , `daima` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '發票代碼' , `haoma` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '發票號碼' , `money` decimal(10,2) NULL DEFAULT 0.00 COMMENT '金額' , `opendt` date NULL DEFAULT NULL COMMENT '開票日期' , `ptype` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '發票類型' , `status` tinyint(1) NULL DEFAULT 0 COMMENT '狀態' , `kainame` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '開票人' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_flow_bill` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_flow_bill`; CREATE TABLE `xinhu_flow_bill` ( `id` int(11) NOT NULL AUTO_INCREMENT , `sericnum` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '單號' , `table` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應表' , `mid` int(11) NULL DEFAULT NULL COMMENT '主id' , `modeid` smallint(6) NULL DEFAULT 0 COMMENT '模塊id' , `modename` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模塊名稱' , `uname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申請人姓名' , `uid` smallint(6) NULL DEFAULT NULL COMMENT '用戶id' , `udeptname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申請人部門' , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` smallint(6) NULL DEFAULT 0 COMMENT '操作人Id' , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `allcheckid` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '@所有審核人' , `isdel` tinyint(4) NULL DEFAULT 0 COMMENT '是否刪除' , `nstatus` tinyint(1) NULL DEFAULT 0 COMMENT '當前狀態值' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `nstatustext` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '當前狀態' , `status` tinyint(1) NULL DEFAULT 0 , `nowcourseid` int(11) NULL DEFAULT 0 COMMENT '當前步驟Id' , `nowcheckid` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '當前審核人id' , `nowcheckname` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '當前審核人' , `checksm` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最后審核說明' , `updt` datetime NULL DEFAULT NULL COMMENT '最后更新時間' , `createdt` datetime NULL DEFAULT NULL COMMENT '創建時間' , `tuiid` int(11) NULL DEFAULT 0 COMMENT '退回flow_log.Id' , `isturn` tinyint(1) NULL DEFAULT 0 COMMENT '是否已提交了' , PRIMARY KEY (`id`), INDEX `sericnum` (`sericnum`) USING BTREE , INDEX `table` (`table`, `mid`) USING BTREE , INDEX `status` (`status`) USING BTREE , INDEX `modeid` (`modeid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='流程單據' AUTO_INCREMENT=191 ; -- ---------------------------- -- Table structure for `xinhu_flow_chao` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_flow_chao`; CREATE TABLE `xinhu_flow_chao` ( `id` int(11) NOT NULL AUTO_INCREMENT , `modeid` int(11) NULL DEFAULT 0 , `table` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應表' , `mid` int(11) NULL DEFAULT 0 COMMENT '對應記錄Id' , `uid` int(11) NULL DEFAULT 0 COMMENT '人員Id' , `csname` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '抄送給' , `csnameid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , PRIMARY KEY (`id`), UNIQUE INDEX `table` (`table`, `mid`) USING BTREE , INDEX `modeid` (`modeid`) USING BTREE , INDEX `uid` (`uid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='抄送表' AUTO_INCREMENT=8 ; -- ---------------------------- -- Table structure for `xinhu_flow_checks` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_flow_checks`; CREATE TABLE `xinhu_flow_checks` ( `id` int(11) NOT NULL AUTO_INCREMENT , `table` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' , `mid` int(11) NULL DEFAULT NULL , `modeid` smallint(6) NULL DEFAULT 0 , `courseid` smallint(6) NULL DEFAULT 0 , `checkid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `checkname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `optdt` datetime NULL DEFAULT NULL , `status` tinyint(1) NULL DEFAULT 0 COMMENT '狀態' , `addlx` tinyint(1) NULL DEFAULT 0 COMMENT '類型1自定義,2撤回添加,3退回添加,4轉移添加' , PRIMARY KEY (`id`), INDEX `table` (`table`, `mid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='單據的審核人' AUTO_INCREMENT=90 ; -- ---------------------------- -- Table structure for `xinhu_flow_cname` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_flow_cname`; CREATE TABLE `xinhu_flow_cname` ( `id` int(11) NOT NULL AUTO_INCREMENT , `num` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '編號' , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '審核組名' , `checkid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `checkname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '審核人' , `pid` int(11) NULL DEFAULT 0 COMMENT '上級ID' , `receid` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `recename` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '適用對象' , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序號' , PRIMARY KEY (`id`), INDEX `num` (`num`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='自定義審核人組' AUTO_INCREMENT=5 ; -- ---------------------------- -- Table structure for `xinhu_flow_course` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_flow_course`; CREATE TABLE `xinhu_flow_course` ( `id` int(11) NOT NULL AUTO_INCREMENT , `mid` int(11) NULL DEFAULT 0 COMMENT '上級ID' , `nid` int(11) NULL DEFAULT 0 COMMENT '下級步驟ID' , `setid` smallint(6) NULL DEFAULT 0 COMMENT '模塊ID' , `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '步驟名稱' , `num` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `checktype` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '審核人類型' , `checktypeid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `checktypename` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '審核人' , `sort` smallint(6) NULL DEFAULT 0 , `whereid` smallint(6) NULL DEFAULT 0 COMMENT '流程模塊條件下的Id' , `where` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '審核條件' , `explain` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `optdt` datetime NULL DEFAULT NULL , `status` tinyint(1) NULL DEFAULT 1 , `courseact` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '審核動作' , `checkshu` tinyint(2) NULL DEFAULT 1 COMMENT '至少幾人審核 ,0全部' , `checkfields` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '審核處理表單' , `pid` smallint(6) NULL DEFAULT 0 COMMENT '上級Id(棄用)' , `optid` smallint(6) NULL DEFAULT 0 COMMENT '操作人id' , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人姓名' , `receid` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '適用對象id' , `recename` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '適用對象' , `iszf` tinyint(1) NULL DEFAULT 0 COMMENT '是否可以轉給他人辦理' , `isqm` tinyint(1) NULL DEFAULT 0 COMMENT '手寫簽名0不用,1都需要,2只需要通過,3只需要不通過' , `coursetype` tinyint(1) NULL DEFAULT 0 COMMENT '審批方式0順序,1前置審批,2后置審批' , `zshtime` int(11) NULL DEFAULT 0 COMMENT '超時時間(分鐘)' , `zshstate` tinyint(2) NULL DEFAULT 1 COMMENT '自動審核類型' , `zbrangeame` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '轉辦人員可選范圍' , `zbrangeid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '轉辦人員可選范圍ID' , `smlx` tinyint(1) NULL DEFAULT 0 COMMENT '處理說明類型' , `wjlx` tinyint(1) NULL DEFAULT 0 COMMENT '相關文件類型' , `isxgfj` tinyint(1) NULL DEFAULT 0 COMMENT '審批時是否可直接編輯附件' , PRIMARY KEY (`id`), INDEX `setid` (`setid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='流程步驟表' AUTO_INCREMENT=121 ; -- ---------------------------- -- Table structure for `xinhu_flow_element` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_flow_element`; CREATE TABLE `xinhu_flow_element` ( `id` int(11) NOT NULL AUTO_INCREMENT , `mid` smallint(6) NULL DEFAULT 0 , `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `fields` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應字段' , `fieldstype` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `sort` smallint(6) NULL DEFAULT 0 , `dev` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '默認值' , `isbt` tinyint(1) NULL DEFAULT 0 COMMENT '是否必填' , `data` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '數據源' , `islu` tinyint(1) NULL DEFAULT 1 COMMENT '是否錄入元素' , `iszs` tinyint(1) NULL DEFAULT 1 COMMENT '是否列表展示' , `attr` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '屬性' , `iszb` tinyint(1) NULL DEFAULT 0 , `isss` tinyint(1) NULL DEFAULT 0 , `lattr` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '列屬性' , `width` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '列寬' , `lens` smallint(6) NULL DEFAULT 0 COMMENT '字段長度' , `savewhere` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保存條件' , `islb` tinyint(1) NULL DEFAULT 1 COMMENT '是否列表列' , `ispx` tinyint(1) NULL DEFAULT 0 COMMENT '是否可排序' , `isalign` tinyint(1) NULL DEFAULT 0 COMMENT '0居中,1居左,2居右' , `issou` tinyint(1) NULL DEFAULT 0 COMMENT '是否可搜索' , `istj` tinyint(1) NULL DEFAULT 0 COMMENT '是否可統計' , `gongsi` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '計算公式' , `placeholder` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提示內容' , `isonly` tinyint(1) NULL DEFAULT 0 COMMENT '是否唯一' , `isdr` tinyint(1) NULL DEFAULT 0 COMMENT '是否導入字段' , PRIMARY KEY (`id`), INDEX `mid` (`mid`) USING BTREE , INDEX `fields` (`fields`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='模塊元素' AUTO_INCREMENT=981 ; -- ---------------------------- -- Table structure for `xinhu_flow_extent` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_flow_extent`; CREATE TABLE `xinhu_flow_extent` ( `id` int(11) NOT NULL AUTO_INCREMENT , `recename` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `receid` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `modeid` smallint(6) NULL DEFAULT 0 COMMENT '模塊' , `type` tinyint(1) NULL DEFAULT 0 COMMENT '0查看,1添加,2編輯,3刪除' , `wherestr` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '條件' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `status` tinyint(1) NOT NULL DEFAULT 1 , `whereid` smallint(6) NULL DEFAULT 0 COMMENT '條件Id' , `fieldstr` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '相關字段' , PRIMARY KEY (`id`), INDEX `modeid` (`modeid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='模塊權限' AUTO_INCREMENT=213 ; -- ---------------------------- -- Table structure for `xinhu_flow_log` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_flow_log`; CREATE TABLE `xinhu_flow_log` ( `id` int(11) NOT NULL AUTO_INCREMENT , `table` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `mid` int(11) NULL DEFAULT NULL , `status` tinyint(4) NULL DEFAULT 0 COMMENT '1通過' , `statusname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '狀態名稱' , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '進程名稱' , `courseid` int(11) NULL DEFAULT NULL , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `ip` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `web` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '瀏覽器' , `checkname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `checkid` smallint(6) NULL DEFAULT NULL , `modeid` smallint(6) NULL DEFAULT NULL COMMENT '@模塊Id' , `color` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `valid` tinyint(1) NULL DEFAULT 1 , `step` smallint(6) NULL DEFAULT 0 COMMENT '步驟號' , `qmimg` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '簽名的圖片base64' , `iszb` tinyint(1) NULL DEFAULT 0 COMMENT '是否轉辦記錄' , PRIMARY KEY (`id`), INDEX `table` (`table`, `mid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='單據操作記錄' AUTO_INCREMENT=1639 ; -- ---------------------------- -- Table structure for `xinhu_flow_menu` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_flow_menu`; CREATE TABLE `xinhu_flow_menu` ( `id` int(11) NOT NULL AUTO_INCREMENT , `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '顯示名稱' , `num` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '編號' , `sort` tinyint(4) NULL DEFAULT 0 , `statusname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `statuscolor` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `statusvalue` tinyint(1) NULL DEFAULT 1 COMMENT '狀態值' , `actname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '動作名稱' , `setid` smallint(6) NULL DEFAULT 0 COMMENT '對應模塊' , `wherestr` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '顯示條件' , `explain` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `status` tinyint(1) NULL DEFAULT 1 , `islog` tinyint(1) NULL DEFAULT 1 , `issm` tinyint(1) NULL DEFAULT 1 , `type` tinyint(1) NULL DEFAULT 0 COMMENT '類型' , `changeaction` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '觸發的方法' , `fields` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `upgcont` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新內容' , `iszs` tinyint(1) NULL DEFAULT 0 COMMENT '是否在詳情頁面顯示' , PRIMARY KEY (`id`), INDEX `setid` (`setid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='單據操作菜單' AUTO_INCREMENT=46 ; -- ---------------------------- -- Table structure for `xinhu_flow_remind` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_flow_remind`; CREATE TABLE `xinhu_flow_remind` ( `id` int(11) NOT NULL AUTO_INCREMENT , `startdt` datetime NULL DEFAULT NULL COMMENT '開始時間' , `enddt` datetime NULL DEFAULT NULL COMMENT '截止時間' , `uid` smallint(6) NULL DEFAULT NULL COMMENT '用戶Id' , `optdt` datetime NULL DEFAULT NULL , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `modenum` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應模塊編號' , `table` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `mid` int(11) NULL DEFAULT 0 COMMENT '主Id' , `ratecont` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '頻率' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提醒內容' , `rate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提醒頻率o僅一次,d天,w周,m月' , `rateval` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `status` tinyint(1) NULL DEFAULT 1 , `receid` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `recename` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提醒給' , PRIMARY KEY (`id`), UNIQUE INDEX `table` (`uid`, `table`, `mid`) USING BTREE , UNIQUE INDEX `uid` (`uid`, `modenum`, `mid`) USING BTREE , INDEX `table_2` (`table`, `mid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='單據提醒設置表' AUTO_INCREMENT=10 ; -- ---------------------------- -- Table structure for `xinhu_flow_set` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_flow_set`; CREATE TABLE `xinhu_flow_set` ( `id` int(11) NOT NULL AUTO_INCREMENT , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模塊名稱' , `num` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模塊編號' , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序' , `table` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應的表' , `where` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '相關條件' , `summary` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '摘要' , `summarx` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '應用摘要' , `type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分類' , `pctx` tinyint(1) NULL DEFAULT 0 COMMENT 'pc端提醒' , `mctx` tinyint(1) NULL DEFAULT 0 COMMENT 'app提醒' , `wxtx` tinyint(1) NULL DEFAULT 0 COMMENT '微信提醒' , `emtx` tinyint(1) NULL DEFAULT 0 COMMENT '是否郵件提醒' , `sericnum` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '編號規則' , `isflow` tinyint(1) NULL DEFAULT 1 COMMENT '是否有流程' , `receid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `recename` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '針對對象' , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `status` tinyint(1) NULL DEFAULT 1 , `islu` tinyint(1) NULL DEFAULT 1 COMMENT '是否可錄入' , `tables` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '多行子表' , `names` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '多行子表名稱' , `statusstr` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '狀態值設置' , `isgbjl` tinyint(1) NULL DEFAULT 0 COMMENT '是否關閉操作記錄' , `isgbcy` tinyint(1) NULL DEFAULT 0 COMMENT '是否不顯示查閱記錄' , `isscl` tinyint(1) NULL DEFAULT 0 COMMENT '是否生成列表頁' , `isup` tinyint(1) NULL DEFAULT 1 COMMENT '更新時是否同步' , `ddtx` tinyint(1) NULL DEFAULT 0 COMMENT '是否釘釘提醒' , `isbxs` tinyint(1) NULL DEFAULT 0 COMMENT '錄入頁面是否不顯示流程圖' , `lbztxs` tinyint(1) NULL DEFAULT 0 COMMENT '列表頁狀態搜索顯示0默認,1必須顯示,2顯示' , `isflowlx` tinyint(1) NULL DEFAULT 0 COMMENT '從新提交時0默認，1從新走流程' , `iscs` tinyint(1) NULL DEFAULT 0 COMMENT '是否自定義抄送' , `zfeitime` int(11) NULL DEFAULT 0 COMMENT '超過分鐘自動作廢' , `ispl` tinyint(1) NULL DEFAULT 1 COMMENT '是否開啟評論' , `istxset` tinyint(1) NULL DEFAULT 1 COMMENT '是否開啟單據提醒設置' , `ishz` tinyint(1) NULL DEFAULT 0 COMMENT '回執確認0不開啟,1必須選擇,2可選' , PRIMARY KEY (`id`, `num`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='流程模塊' AUTO_INCREMENT=97 ; -- ---------------------------- -- Table structure for `xinhu_flow_todo` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_flow_todo`; CREATE TABLE `xinhu_flow_todo` ( `id` int(11) NOT NULL AUTO_INCREMENT , `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名稱標題' , `num` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '編號' , `setid` smallint(6) NULL DEFAULT 0 COMMENT '對應模塊' , `explain` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `whereid` smallint(6) NULL DEFAULT 0 COMMENT '對應條件id' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `receid` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `recename` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '通知給' , `changefields` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '改變字段' , `changecourse` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應步做id' , `boturn` tinyint(1) NULL DEFAULT 0 COMMENT '提交時' , `boedit` tinyint(1) NULL DEFAULT 0 COMMENT '編輯時' , `bochang` tinyint(1) NULL DEFAULT 0 COMMENT '字段改變時' , `bodel` tinyint(1) NULL DEFAULT 0 COMMENT '刪除時' , `bozuofei` tinyint(1) NULL DEFAULT 0 COMMENT '作廢時' , `botong` tinyint(1) NULL DEFAULT 0 COMMENT '步驟處理通過時' , `bobutong` tinyint(1) NULL DEFAULT 0 COMMENT '步驟處理不通過時' , `bofinish` tinyint(1) NULL DEFAULT 0 COMMENT '處理完成時' , `bozhui` tinyint(1) NULL DEFAULT 0 COMMENT '追加說明時' , `bozhuan` tinyint(1) NULL DEFAULT 0 COMMENT '流程轉辦時' , `toturn` tinyint(1) NULL DEFAULT 0 COMMENT '是否通知給提交人' , `tocourse` tinyint(1) NULL DEFAULT 0 COMMENT '是否通知給流程所有參與人' , `todofields` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '通知給主表上字段' , `summary` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '通知內容摘要' , `botask` tinyint(1) NULL DEFAULT 0 COMMENT '計劃任務' , `boping` tinyint(1) NULL DEFAULT 0 COMMENT '評論時' , `bohuiz` tinyint(1) NULL DEFAULT 0 COMMENT '回執時' , `tosuper` tinyint(1) NULL DEFAULT 0 COMMENT '直屬上級' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='單據通知設置表' AUTO_INCREMENT=14 ; -- ---------------------------- -- Table structure for `xinhu_flow_todos` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_flow_todos`; CREATE TABLE `xinhu_flow_todos` ( `id` int(11) NOT NULL AUTO_INCREMENT , `modenum` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '對應模塊編號' , `modename` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模塊名稱' , `table` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應主表' , `mid` int(11) NULL DEFAULT 0 COMMENT '主表Id' , `uid` int(11) NULL DEFAULT 0 COMMENT '對應人員' , `adddt` datetime NULL DEFAULT NULL COMMENT '添加時間' , `readdt` datetime NULL DEFAULT NULL COMMENT '已讀時間' , `isread` tinyint(1) NULL DEFAULT 0 COMMENT '是否已讀' , PRIMARY KEY (`id`), INDEX `table` (`table`, `mid`) USING BTREE , INDEX `modenum` (`modenum`, `mid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='單據通知給對應人員' AUTO_INCREMENT=115 ; -- ---------------------------- -- Table structure for `xinhu_flow_where` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_flow_where`; CREATE TABLE `xinhu_flow_where` ( `id` smallint(6) NOT NULL AUTO_INCREMENT , `setid` smallint(6) NULL DEFAULT 0 COMMENT '對應模塊' , `num` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '編號' , `pnum` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '編號分組' , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '條件名稱' , `wheresstr` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應表條件' , `whereustr` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用戶條件' , `wheredstr` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應部門條件' , `sort` smallint(6) NULL DEFAULT NULL , `explain` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `receid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `recename` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '包含用戶' , `nreceid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `nrecename` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '不包含用戶' , `islb` tinyint(1) NULL DEFAULT 0 COMMENT '是否在生成列表頁面上顯示' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `syrid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `syrname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '此條件可適用對象' , PRIMARY KEY (`id`), INDEX `setid` (`setid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='單據條件' AUTO_INCREMENT=235 ; -- ---------------------------- -- Table structure for `xinhu_godepot` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_godepot`; CREATE TABLE `xinhu_godepot` ( `id` int(11) NOT NULL AUTO_INCREMENT , `depotname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '倉庫名稱' , `depotaddress` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '倉庫地址' , `cgname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '倉庫管理員' , `cgid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '倉庫管理員的ID' , `depotexplain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序號' , `depotnum` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '倉庫編號' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='物品倉庫表' AUTO_INCREMENT=3 ; -- ---------------------------- -- Table structure for `xinhu_goodm` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_goodm`; CREATE TABLE `xinhu_goodm` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` int(11) NULL DEFAULT NULL , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` int(11) NULL DEFAULT NULL , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `type` tinyint(1) NULL DEFAULT 0 COMMENT '0領用,1采購申請' , `money` decimal(10,2) NULL DEFAULT 0.00 COMMENT '費用' , `custid` smallint(6) NULL DEFAULT 0 , `custname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '供應商名稱' , `discount` decimal(8,2) NULL DEFAULT 0.00 COMMENT '優惠價格' , `state` tinyint(1) NULL DEFAULT 0 COMMENT '0待出入庫,2部分出入庫,1已全部出入庫' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='物品領用采購申請主表' AUTO_INCREMENT=10 ; -- ---------------------------- -- Table structure for `xinhu_goodn` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_goodn`; CREATE TABLE `xinhu_goodn` ( `id` int(11) NOT NULL AUTO_INCREMENT , `mid` smallint(6) NULL DEFAULT 0 COMMENT '對應主表' , `aid` smallint(6) NULL DEFAULT 0 COMMENT '物品Id' , `count` smallint(6) NULL DEFAULT 0 COMMENT '數量' , `couns` smallint(6) NULL DEFAULT 0 COMMENT '已出庫入庫數跟count相等時就全部了' , `sort` smallint(6) NULL DEFAULT 0 , `unit` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '單位' , `price` decimal(10,2) NULL DEFAULT 0.00 COMMENT '單價' , PRIMARY KEY (`id`), INDEX `mid` (`mid`) USING BTREE , INDEX `aid` (`aid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='物品庫存詳細表' AUTO_INCREMENT=12 ; -- ---------------------------- -- Table structure for `xinhu_goods` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_goods`; CREATE TABLE `xinhu_goods` ( `id` int(11) NOT NULL AUTO_INCREMENT , `typeid` smallint(6) NULL DEFAULT 0 COMMENT '對應分類' , `num` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '物品編號' , `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `guige` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '規格' , `xinghao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '型號' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `price` decimal(10,2) NULL DEFAULT 0.00 COMMENT '單價' , `unit` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '單位' , `adddt` datetime NULL DEFAULT NULL , `optdt` datetime NULL DEFAULT NULL , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `stock` int(11) NULL DEFAULT 0 COMMENT '庫存' , `stockcs` int(11) NULL DEFAULT 0 COMMENT '初始庫存' , PRIMARY KEY (`id`), INDEX `typeid` (`typeid`) USING BTREE , INDEX `name` (`name`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='物品表' AUTO_INCREMENT=7 ; -- ---------------------------- -- Table structure for `xinhu_goodss` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_goodss`; CREATE TABLE `xinhu_goodss` ( `id` int(11) NOT NULL AUTO_INCREMENT , `aid` smallint(6) NULL DEFAULT 0 COMMENT '物品Id' , `count` smallint(6) NULL DEFAULT 0 COMMENT '數量' , `uid` smallint(6) NULL DEFAULT 0 , `type` tinyint(1) NULL DEFAULT 0 COMMENT '0入庫,1出庫' , `kind` tinyint(2) NULL DEFAULT 0 COMMENT '出入庫類型' , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `optdt` datetime NULL DEFAULT NULL , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `status` tinyint(1) NULL DEFAULT 1 , `optid` int(11) NULL DEFAULT 0 , `mid` smallint(6) NULL DEFAULT 0 COMMENT '對應主表' , `sort` smallint(6) NULL DEFAULT 0 , `unit` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '單位' , `price` decimal(10,2) NULL DEFAULT 0.00 COMMENT '單價' , `depotid` smallint(6) NULL DEFAULT 1 COMMENT '存放倉庫ID' , PRIMARY KEY (`id`), INDEX `aiddepotid` (`aid`, `depotid`) USING BTREE , INDEX `applydt` (`applydt`) USING BTREE , INDEX `status` (`status`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='物品庫存詳細表' AUTO_INCREMENT=21 ; -- ---------------------------- -- Table structure for `xinhu_group` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_group`; CREATE TABLE `xinhu_group` ( `id` smallint(6) NOT NULL AUTO_INCREMENT , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '組名' , `sort` tinyint(4) NULL DEFAULT 0 , `ispir` tinyint(4) NULL DEFAULT 1 COMMENT '是否權限驗證' , `indate` datetime NULL DEFAULT NULL , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='系統組' AUTO_INCREMENT=3 ; -- ---------------------------- -- Table structure for `xinhu_gwfj` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_gwfj`; CREATE TABLE `xinhu_gwfj` ( `id` int(11) NOT NULL AUTO_INCREMENT , `sort` int(11) NULL DEFAULT 0 COMMENT '排序號' , `senddt` date NULL DEFAULT NULL COMMENT '發文日' , `notetype` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '通知書類型' , `officialdt` date NULL DEFAULT NULL COMMENT '官方絕限' , `caseid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案件編號' , `uid` int(11) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` int(11) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=14 ; -- ---------------------------- -- Table structure for `xinhu_homeitems` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_homeitems`; CREATE TABLE `xinhu_homeitems` ( `id` int(11) NOT NULL AUTO_INCREMENT , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名稱' , `num` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '編號' , `receid` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `recename` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序號' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `row` tinyint(1) NULL DEFAULT 0 COMMENT '所在位置' , PRIMARY KEY (`id`, `num`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='桌面項目表' AUTO_INCREMENT=10 ; -- ---------------------------- -- Table structure for `xinhu_hrcheck` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_hrcheck`; CREATE TABLE `xinhu_hrcheck` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` smallint(6) NULL DEFAULT 0 , `applyname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申請人姓名' , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `uname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應人' , `month` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '{month}' COMMENT '月份' , `content` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '考核內容' , `fenzp` decimal(6,1) NULL DEFAULT 0.0 COMMENT '自評分數' , `fensj` decimal(6,1) NULL DEFAULT 0.0 COMMENT '上級評分' , `fenrs` decimal(6,1) NULL DEFAULT 0.0 COMMENT '人事評分' , `fen` decimal(6,1) NULL DEFAULT 0.0 COMMENT '最后得分' , `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '考核名稱' , `khid` int(11) NULL DEFAULT 0 COMMENT '關聯考核項目hrkaohem.id' , `createdt` datetime NULL DEFAULT NULL COMMENT '創建時間' , `startdt` date NULL DEFAULT NULL COMMENT '評分開始時間' , `enddt` date NULL DEFAULT NULL COMMENT '評分截止時間' , `pfren` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '評分人' , `pfrenid` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `pfrenids` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '未評分人Id' , `pfrens` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '未評分人' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='考核評分表' AUTO_INCREMENT=3 ; -- ---------------------------- -- Table structure for `xinhu_hrcheckn` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_hrcheckn`; CREATE TABLE `xinhu_hrcheckn` ( `id` int(11) NOT NULL AUTO_INCREMENT , `itemname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '評分項目' , `pfname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '評分名稱' , `mid` smallint(6) NULL DEFAULT 0 COMMENT '對應主表hrcheck.id' , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序號' , `sid` int(11) NULL DEFAULT 0 COMMENT '對應hrchecks.id' , `fenshu` smallint(6) NULL DEFAULT 0 COMMENT '評分分數' , `weight` decimal(6,1) NULL DEFAULT 0.0 COMMENT '權重' , `optid` int(11) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '評分人' , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `defen` decimal(6,1) NULL DEFAULT 0.0 COMMENT '最后得分' , `pfid` int(11) NULL DEFAULT 0 COMMENT '關聯評分hrkaohen.Id' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_hrchecks` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_hrchecks`; CREATE TABLE `xinhu_hrchecks` ( `id` int(11) NOT NULL AUTO_INCREMENT , `mid` smallint(6) NULL DEFAULT 0 COMMENT '對應主表hrkaohem.id' , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序號' , `itemname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '考評項目' , `weight` decimal(6,1) NULL DEFAULT 0.0 COMMENT '權重(%)' , `fenshu` decimal(6,1) NULL DEFAULT 0.0 COMMENT '占用分數' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_hrdemint` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_hrdemint`; CREATE TABLE `xinhu_hrdemint` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` smallint(6) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `type` tinyint(1) NULL DEFAULT 0 COMMENT '0需求,1面試' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `zhiwei` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '需求職位' , `xinzi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '薪資' , `renshu` smallint(6) NULL DEFAULT 1 COMMENT '需求人數' , `content` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '職位要求/面試者簡歷' , `bumen` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '需求部門' , `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名' , `msuser` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '面試人員' , `msuserid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '面試人員的ID' , `mscont` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '面試記錄' , `state` tinyint(1) NULL DEFAULT 0 COMMENT '面試結果0待面試,1錄用,2不適合' , `msdt` datetime NULL DEFAULT NULL COMMENT '面試時間' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='面試和人員需求表' AUTO_INCREMENT=4 ; -- ---------------------------- -- Table structure for `xinhu_hrkaohem` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_hrkaohem`; CREATE TABLE `xinhu_hrkaohem` ( `id` int(11) NOT NULL AUTO_INCREMENT , `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '考核名稱' , `startdt` date NULL DEFAULT NULL COMMENT '開始日期' , `enddt` date NULL DEFAULT NULL COMMENT '截止日期' , `receid` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `recename` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應考核人' , `optid` int(11) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `hegfen` smallint(6) NULL DEFAULT 0 COMMENT '合格分數' , `maxfen` smallint(6) NULL DEFAULT 100 COMMENT '最高分數' , `pinlv` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'm' COMMENT '考核頻率' , `sctime` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生成時間' , `pfsj` smallint(6) NULL DEFAULT 3 COMMENT '評分時間(天)' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '是否啟用' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_hrkaohen` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_hrkaohen`; CREATE TABLE `xinhu_hrkaohen` ( `id` int(11) NOT NULL AUTO_INCREMENT , `mid` smallint(6) NULL DEFAULT 0 COMMENT '對應主表hrkaohem.id' , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序號' , `pfname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '評分名稱' , `pftype` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '評分人類型' , `pfren` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '評分人' , `pfrenid` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `pfweight` decimal(6,1) NULL DEFAULT 0.0 COMMENT '評分權重' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_hrkaohes` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_hrkaohes`; CREATE TABLE `xinhu_hrkaohes` ( `id` int(11) NOT NULL AUTO_INCREMENT , `mid` smallint(6) NULL DEFAULT 0 COMMENT '對應主表hrkaohem.id' , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序號' , `itemname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '考評項目' , `weight` decimal(6,1) NULL DEFAULT 0.0 COMMENT '權重(%)' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_hrpositive` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_hrpositive`; CREATE TABLE `xinhu_hrpositive` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` int(11) NULL DEFAULT NULL , `applyname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申請人姓名' , `ranking` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '職位' , `entrydt` date NULL DEFAULT NULL COMMENT '入職日期' , `syenddt` date NULL DEFAULT NULL COMMENT '試用到期日' , `positivedt` date NULL DEFAULT NULL COMMENT '轉正日期' , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 0 COMMENT '@0|待審核,1|審核通過,2|審核不通過' , `isturn` tinyint(1) NULL DEFAULT 0 COMMENT '@0|未提交,1|提交' , `isover` tinyint(1) NULL DEFAULT 0 , `optid` int(11) NULL DEFAULT NULL , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='HR轉正' AUTO_INCREMENT=4 ; -- ---------------------------- -- Table structure for `xinhu_hrredund` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_hrredund`; CREATE TABLE `xinhu_hrredund` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` int(11) NULL DEFAULT NULL , `applyname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申請人姓名' , `ranking` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '職位' , `entrydt` date NULL DEFAULT NULL COMMENT '入職日期' , `quitdt` date NULL DEFAULT NULL COMMENT '離職日期' , `redundtype` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '離職類型' , `redundreson` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '離職原因' , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 0 COMMENT '@0|待審核,1|審核通過,2|審核不通過' , `isturn` tinyint(1) NULL DEFAULT 0 COMMENT '@0|未提交,1|提交' , `isover` tinyint(1) NULL DEFAULT 0 , `optid` int(11) NULL DEFAULT NULL , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='離職申請' AUTO_INCREMENT=2 ; -- ---------------------------- -- Table structure for `xinhu_hrsalarm` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_hrsalarm`; CREATE TABLE `xinhu_hrsalarm` ( `id` int(11) NOT NULL AUTO_INCREMENT , `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模版名稱' , `receid` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `recename` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '適用對象' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `optid` int(11) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `optdt` datetime NULL DEFAULT NULL , `atype` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模版類型' , `startdt` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '開始月份' , `enddt` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '截止月份' , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序號' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '是否啟用' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_hrsalars` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_hrsalars`; CREATE TABLE `xinhu_hrsalars` ( `id` int(11) NOT NULL AUTO_INCREMENT , `mid` smallint(6) NULL DEFAULT 0 COMMENT '對應主表hrsalarm.id' , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序號' , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名稱' , `fields` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應字段' , `gongsi` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公式' , `type` tinyint(1) NULL DEFAULT 0 COMMENT '0字段,1增加,2減少' , `beizhu` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '備注' , `devzhi` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '默認值' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_hrsalary` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_hrsalary`; CREATE TABLE `xinhu_hrsalary` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` smallint(6) NULL DEFAULT 0 , `xuid` smallint(6) NULL DEFAULT 0 , `uname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應人' , `udeptname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應人員部門' , `ranking` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '職位' , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `month` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '月份' , `base` decimal(10,2) NULL DEFAULT 0.00 COMMENT '基本工資' , `money` decimal(10,2) NULL DEFAULT 0.00 COMMENT '實發' , `postjt` decimal(10,2) NULL DEFAULT 0.00 COMMENT '職務津貼' , `skilljt` decimal(10,2) NULL DEFAULT 0.00 COMMENT '技能津貼' , `travelbt` decimal(10,2) NULL DEFAULT 0.00 COMMENT '交通補貼' , `telbt` decimal(10,2) NULL DEFAULT 0.00 COMMENT '通信補貼' , `reward` decimal(10,2) NULL DEFAULT 0.00 COMMENT '獎勵' , `punish` decimal(10,2) NULL DEFAULT 0.00 COMMENT '處罰' , `socials` decimal(10,2) NULL DEFAULT 0.00 COMMENT '個人社保' , `taxes` decimal(10,2) NULL DEFAULT 0.00 COMMENT '個人所得稅' , `ispay` tinyint(1) NULL DEFAULT 0 COMMENT '是否發放' , `otherzj` decimal(10,2) NULL DEFAULT 0.00 COMMENT '其它增加' , `otherjs` decimal(10,2) NULL DEFAULT 0.00 COMMENT '其它減少' , `cidao` smallint(6) NULL DEFAULT 0 COMMENT '遲到(次)' , `cidaos` decimal(10,2) NULL DEFAULT 0.00 COMMENT '遲到處罰' , `zaotui` smallint(6) NULL DEFAULT 0 COMMENT '早退(次)' , `zaotuis` decimal(10,2) NULL DEFAULT 0.00 COMMENT '早退處罰' , `leave` smallint(6) NULL DEFAULT 0 COMMENT '請假(小時)' , `leaves` decimal(10,2) NULL DEFAULT 0.00 COMMENT '請假減少' , `jiaban` smallint(6) NULL DEFAULT 0 COMMENT '加班(小時)' , `jiabans` decimal(10,2) NULL DEFAULT 0.00 COMMENT '加班補貼' , `weidk` smallint(6) NULL DEFAULT 0 COMMENT '未打卡(次)' , `weidks` decimal(10,2) NULL DEFAULT 0.00 COMMENT '未打卡減少' , `mones` decimal(10,2) NULL DEFAULT 0.00 COMMENT '應發工資' , `socialsunit` decimal(10,2) NULL DEFAULT 0.00 COMMENT '單位社保繳費' , `taxbase` decimal(10,2) NULL DEFAULT 0.00 COMMENT '個稅起征點' , `jxjs` decimal(10,2) NULL DEFAULT 0.00 COMMENT '績效基數' , `jxxs` decimal(10,2) NULL DEFAULT 0.00 COMMENT '績效系數' , `jxdf` decimal(10,2) NULL DEFAULT 0.00 COMMENT '績效打分' , `jtpost` decimal(10,2) NULL DEFAULT 0.00 COMMENT '績效收入' , `ysbtime` decimal(10,1) NULL DEFAULT 0.0 COMMENT '應上班天數' , `zsbtime` decimal(10,1) NULL DEFAULT 0.0 COMMENT '已上班天數' , `gonggeren` decimal(10,2) NULL DEFAULT 0.00 COMMENT '公積金個人' , `gongunit` decimal(10,2) NULL DEFAULT 0.00 COMMENT '公積金單位' , `foodbt` decimal(10,2) NULL DEFAULT 0.00 COMMENT '餐補貼' , `hotbt` decimal(10,2) NULL DEFAULT 0.00 COMMENT '高溫津貼' , `dnbt` decimal(10,2) NULL DEFAULT 0.00 COMMENT '電腦補貼' , `jiansr` decimal(10,2) NULL DEFAULT 0.00 COMMENT '計件收入' , `otherbt` decimal(10,2) NULL DEFAULT 0.00 COMMENT '其他補貼' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='工資表' AUTO_INCREMENT=25 ; -- ---------------------------- -- Table structure for `xinhu_hrshebao` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_hrshebao`; CREATE TABLE `xinhu_hrshebao` ( `id` int(11) NOT NULL AUTO_INCREMENT , `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名稱' , `recename` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '適用對象' , `receid` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `status` tinyint(1) NULL DEFAULT 1 COMMENT '是否開啟' , `gongjishu` decimal(10,2) NULL DEFAULT 0.00 COMMENT '公積金基數' , `yljishu` decimal(10,2) NULL DEFAULT 0.00 COMMENT '養老保險基數' , `ylgeren` decimal(10,2) NULL DEFAULT 0.00 COMMENT '養老個人比例(%)' , `ylunit` decimal(10,2) NULL DEFAULT 0.00 COMMENT '養老單位比例(%)' , `syjishu` decimal(10,2) NULL DEFAULT 0.00 COMMENT '失業報銷基數' , `sygeren` decimal(10,2) NULL DEFAULT 0.00 COMMENT '失業個人比例(%)' , `syunit` decimal(10,2) NULL DEFAULT 0.00 COMMENT '失業單位比例(%)' , `gsjishu` decimal(10,2) NULL DEFAULT 0.00 COMMENT '工傷報銷基數' , `gsgeren` decimal(10,2) NULL DEFAULT 0.00 COMMENT '工傷個人比例(%)' , `gsunit` decimal(10,2) NULL DEFAULT 0.00 COMMENT '工傷單位比例(%)' , `syujishu` decimal(10,2) NULL DEFAULT 0.00 COMMENT '生育保險基數' , `syugeren` decimal(10,2) NULL DEFAULT 0.00 COMMENT '生育個人比例(%)' , `syuunit` decimal(10,2) NULL DEFAULT 0.00 COMMENT '生育單位比例(%)' , `yijishu` decimal(10,2) NULL DEFAULT 0.00 COMMENT '醫療報銷基數' , `yigeren` decimal(10,2) NULL DEFAULT 0.00 COMMENT '醫療個人比例(%)' , `yiunit` decimal(10,2) NULL DEFAULT 0.00 COMMENT '醫療單位比例(%)' , `dbgeren` decimal(10,2) NULL DEFAULT 0.00 COMMENT '大病個人' , `gjjgeren` decimal(10,2) NULL DEFAULT 0.00 COMMENT '公積金個人比例(%)' , `gjjunit` decimal(10,2) NULL DEFAULT 0.00 COMMENT '公積金單位比例(%)' , `shebaogeren` decimal(10,2) NULL DEFAULT 0.00 COMMENT '個人社保繳費' , `shebaounit` decimal(10,2) NULL DEFAULT 0.00 COMMENT '單位社保繳費' , `sctime` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '每月生成時間' , `optdt` datetime NULL DEFAULT NULL , `gonggeren` decimal(10,2) NULL DEFAULT 0.00 COMMENT '公積金個人' , `gongunit` decimal(10,2) NULL DEFAULT 0.00 COMMENT '公積金單位' , `explian` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `startdt` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '開始月份' , `enddt` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '截止月份' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_hrtransfer` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_hrtransfer`; CREATE TABLE `xinhu_hrtransfer` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` smallint(6) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `tranuid` smallint(6) NULL DEFAULT 0 , `tranname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '要調動人' , `trantype` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '調動類型' , `olddeptname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原來部門' , `oldranking` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原來職位' , `effectivedt` date NULL DEFAULT NULL COMMENT '生效日期' , `newdeptname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '調動后部門' , `newdeptid` smallint(6) NULL DEFAULT NULL , `newranking` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '調動后職位' , `isover` tinyint(1) NULL DEFAULT 0 COMMENT '是否已完成' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='職位調動' AUTO_INCREMENT=2 ; -- ---------------------------- -- Table structure for `xinhu_hrtrsalary` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_hrtrsalary`; CREATE TABLE `xinhu_hrtrsalary` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` smallint(6) NULL DEFAULT 0 , `applyname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申請人姓名' , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `effectivedt` date NULL DEFAULT NULL COMMENT '生效日期' , `floats` smallint(6) NULL DEFAULT 0 COMMENT '調薪幅度' , `ranking` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '職位' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='調薪申請' AUTO_INCREMENT=2 ; -- ---------------------------- -- Table structure for `xinhu_im_group` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_im_group`; CREATE TABLE `xinhu_im_group` ( `id` int(11) NOT NULL AUTO_INCREMENT , `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名稱' , `pid` smallint(6) NULL DEFAULT 0 COMMENT '對應上級' , `types` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '應用分類' , `type` tinyint(1) NULL DEFAULT 0 COMMENT '類型@0|群,1|討論組,2|應用' , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序號' , `createid` int(11) NULL DEFAULT NULL , `createname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '創建人' , `createdt` datetime NULL DEFAULT NULL COMMENT '創建時間' , `face` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '頭像' , `num` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `receid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `recename` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `valid` tinyint(1) NULL DEFAULT 1 , `explain` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `iconfont` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應字體圖標' , `iconcolor` varchar(7) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字體圖標顏色' , `yylx` tinyint(1) NULL DEFAULT 0 COMMENT '應用類型0全部,1pc,2手機' , `urlpc` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '應用上PC地址' , `urlm` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '應用上手機端地址' , `deptid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應部門id' , PRIMARY KEY (`id`), INDEX `num` (`num`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='IM會話表' AUTO_INCREMENT=47 ; -- ---------------------------- -- Table structure for `xinhu_im_groupuser` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_im_groupuser`; CREATE TABLE `xinhu_im_groupuser` ( `id` int(11) NOT NULL AUTO_INCREMENT , `gid` smallint(6) NOT NULL DEFAULT 0 , `uid` smallint(6) NOT NULL DEFAULT 0 , `istx` tinyint(1) NOT NULL DEFAULT 1 , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='IM會話人員' AUTO_INCREMENT=110 ; -- ---------------------------- -- Table structure for `xinhu_im_history` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_im_history`; CREATE TABLE `xinhu_im_history` ( `id` int(11) NOT NULL AUTO_INCREMENT , `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `receid` smallint(6) NULL DEFAULT 0 , `uid` smallint(6) NULL DEFAULT NULL , `sendid` smallint(6) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL , `cont` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `stotal` smallint(6) NULL DEFAULT 0 , `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '推送時標題' , PRIMARY KEY (`id`), UNIQUE INDEX `type` (`type`, `receid`, `uid`) USING BTREE , INDEX `optdt` (`optdt`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='IM會話記錄歷史表' AUTO_INCREMENT=14 ; -- ---------------------------- -- Table structure for `xinhu_im_menu` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_im_menu`; CREATE TABLE `xinhu_im_menu` ( `id` int(11) NOT NULL AUTO_INCREMENT , `mid` smallint(6) NOT NULL DEFAULT 0 , `pid` smallint(6) NOT NULL DEFAULT 0 , `name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名稱' , `sort` smallint(6) NOT NULL DEFAULT 0 , `type` tinyint(4) NULL DEFAULT 0 COMMENT '1url,0事件' , `url` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應地址' , `num` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `color` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '顏色' , `receid` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `recename` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '可使用人員' , PRIMARY KEY (`id`), INDEX `mid` (`mid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='IM下應用菜單' AUTO_INCREMENT=162 ; -- ---------------------------- -- Table structure for `xinhu_im_mess` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_im_mess`; CREATE TABLE `xinhu_im_mess` ( `id` int(11) NOT NULL AUTO_INCREMENT , `optdt` datetime NULL DEFAULT NULL , `zt` tinyint(1) NULL DEFAULT 0 COMMENT '狀態' , `cont` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '內容' , `sendid` smallint(6) NULL DEFAULT NULL , `receid` smallint(6) NULL DEFAULT 0 COMMENT '接收' , `receuid` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接收用戶id' , `type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '信息類型' , `url` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '相關地址' , `fileid` int(11) NOT NULL DEFAULT 0 COMMENT '對應文件Id' , `msgid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , PRIMARY KEY (`id`), INDEX `optdt` (`optdt`, `receid`) USING BTREE , INDEX `msgid` (`msgid`) USING BTREE , INDEX `type` (`type`, `receid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='IM聊天記錄表' AUTO_INCREMENT=2 ; -- ---------------------------- -- Table structure for `xinhu_im_messzt` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_im_messzt`; CREATE TABLE `xinhu_im_messzt` ( `id` int(11) NOT NULL AUTO_INCREMENT , `mid` int(11) NULL DEFAULT NULL COMMENT '信息id' , `uid` int(11) NULL DEFAULT NULL COMMENT '人員id' , `gid` smallint(6) NULL DEFAULT 0 , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='IM聊天消息狀態表' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_infor` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_infor`; CREATE TABLE `xinhu_infor` ( `id` int(11) NOT NULL AUTO_INCREMENT , `title` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `optdt` datetime NULL DEFAULT NULL , `typename` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL , `url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `receid` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接收人Id' , `recename` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `enddt` datetime NULL DEFAULT NULL COMMENT '截止時間' , `startdt` datetime NULL DEFAULT NULL COMMENT '開始時間' , `zuozhe` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '發布者' , `indate` date NULL DEFAULT NULL COMMENT '日期' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `fengmian` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '封面圖片' , `mintou` smallint(6) NULL DEFAULT 0 COMMENT '至少投票' , `maxtou` smallint(6) NULL DEFAULT 0 COMMENT '最多投投票0不限制' , `issms` tinyint(1) NULL DEFAULT 0 COMMENT '是否發短信' , `istop` tinyint(1) NULL DEFAULT 0 COMMENT '是否置頂' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='通知公告' AUTO_INCREMENT=10 ; -- ---------------------------- -- Table structure for `xinhu_infors` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_infors`; CREATE TABLE `xinhu_infors` ( `id` int(11) NOT NULL AUTO_INCREMENT , `mid` smallint(6) NULL DEFAULT 0 COMMENT '對應主表infor.id' , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序號' , `touitems` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '投票選項' , `touci` int(11) NULL DEFAULT 0 COMMENT '得到票數' , PRIMARY KEY (`id`), INDEX `mid` (`mid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='信息子表投票項' AUTO_INCREMENT=4 ; -- ---------------------------- -- Table structure for `xinhu_inventor` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_inventor`; CREATE TABLE `xinhu_inventor` ( `id` int(11) NOT NULL AUTO_INCREMENT , `invname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '發明人姓名' , `tel` smallint(6) NULL DEFAULT NULL COMMENT '電話號碼' , `certificate` smallint(6) NULL DEFAULT NULL COMMENT '證件號碼' , `remark` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '備注' , `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '郵箱' , `uid` int(11) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` int(11) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `custid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所屬客戶' , `custname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所屬客戶' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=2 ; -- ---------------------------- -- Table structure for `xinhu_knowledge` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_knowledge`; CREATE TABLE `xinhu_knowledge` ( `id` int(11) NOT NULL AUTO_INCREMENT , `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '標題' , `typeid` smallint(6) NULL DEFAULT 0 COMMENT '對應分類' , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序' , `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL , `optdt` datetime NULL DEFAULT NULL , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `adddt` datetime NULL DEFAULT NULL , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='知識信息' AUTO_INCREMENT=2 ; -- ---------------------------- -- Table structure for `xinhu_knowtiku` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_knowtiku`; CREATE TABLE `xinhu_knowtiku` ( `id` int(11) NOT NULL AUTO_INCREMENT , `title` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '標題' , `typeid` smallint(6) NULL DEFAULT 0 , `type` tinyint(1) NULL DEFAULT 0 COMMENT '0單選,1多選' , `ana` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '答案A' , `anb` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '答案B' , `anc` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '答案C' , `and` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '答案D' , `answer` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `sort` smallint(6) NULL DEFAULT 0 , `adddt` datetime NULL DEFAULT NULL , `optdt` datetime NULL DEFAULT NULL , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `content` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `optid` smallint(6) NULL DEFAULT 0 , `imgurl` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '相關圖片地址' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='知識題庫' AUTO_INCREMENT=11 ; -- ---------------------------- -- Table structure for `xinhu_knowtraim` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_knowtraim`; CREATE TABLE `xinhu_knowtraim` ( `id` int(11) NOT NULL AUTO_INCREMENT , `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '標題' , `optid` int(11) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `optdt` datetime NULL DEFAULT NULL , `dxshu` smallint(6) NULL DEFAULT 0 COMMENT '多選題目數量' , `dsshu` smallint(6) NULL DEFAULT 0 COMMENT '單選題目數量' , `reshu` smallint(6) NULL DEFAULT 0 COMMENT '培訓人數' , `startdt` datetime NULL DEFAULT NULL COMMENT '開始時間' , `enddt` datetime NULL DEFAULT NULL COMMENT '截止時間' , `kstime` smallint(6) NULL DEFAULT 0 COMMENT '考試時間(分鐘)' , `ydshu` smallint(6) NULL DEFAULT 0 COMMENT '已答題人數' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `receid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `recename` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '發給誰培訓' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `state` tinyint(1) NULL DEFAULT 0 COMMENT '0還沒開始,1考試中,2已結束' , `zfenshu` int(11) NULL DEFAULT 0 COMMENT '總分' , `hgfen` int(11) NULL DEFAULT 0 COMMENT '合格分數' , `tikuid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `tikuname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應題庫' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='培訓表出題考試' AUTO_INCREMENT=4 ; -- ---------------------------- -- Table structure for `xinhu_knowtrais` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_knowtrais`; CREATE TABLE `xinhu_knowtrais` ( `id` int(11) NOT NULL AUTO_INCREMENT , `mid` int(11) NULL DEFAULT 0 , `uid` int(11) NULL DEFAULT 0 , `kssdt` datetime NULL DEFAULT NULL COMMENT '考試時間' , `ksedt` datetime NULL DEFAULT NULL COMMENT '考試結束時間' , `fenshu` smallint(6) NULL DEFAULT 0 COMMENT '得分' , `kstime` int(11) NULL DEFAULT 0 COMMENT '考試時間(秒數)' , `isks` tinyint(1) NULL DEFAULT 0 COMMENT '是否已考試' , `tkids` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '考試題目id' , `dyids` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '我做題得到答案' , `dyjgs` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '答題結果0未答,1正確,2錯誤' , PRIMARY KEY (`id`), UNIQUE INDEX `mid` (`mid`, `uid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='考試培訓子表' AUTO_INCREMENT=28 ; -- ---------------------------- -- Table structure for `xinhu_kqanay` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_kqanay`; CREATE TABLE `xinhu_kqanay` ( `id` int(11) NOT NULL AUTO_INCREMENT , `dt` date NULL DEFAULT NULL COMMENT '日期' , `uid` smallint(6) NULL DEFAULT NULL COMMENT '人員id' , `ztname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '狀態名稱' , `time` datetime NULL DEFAULT NULL , `state` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '狀態名稱' , `states` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '其他狀態,如請假' , `sort` smallint(6) NULL DEFAULT 0 , `iswork` tinyint(4) NULL DEFAULT 1 COMMENT '是否工作日' , `emiao` int(11) NULL DEFAULT 0 COMMENT '秒數' , `optdt` datetime NULL DEFAULT NULL , `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `timesb` decimal(6,1) NULL DEFAULT 0.0 COMMENT '應上班時間(小時)' , `timeys` decimal(6,1) NULL DEFAULT 0.0 COMMENT '已上班時間(小時)' , PRIMARY KEY (`id`), INDEX `uiddt` (`uid`, `dt`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='考勤分析' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_kqdist` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_kqdist`; CREATE TABLE `xinhu_kqdist` ( `id` int(11) NOT NULL AUTO_INCREMENT , `recename` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '適用對象' , `receid` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `mid` smallint(6) NULL DEFAULT 0 , `type` tinyint(1) NULL DEFAULT 0 COMMENT '0考勤時間,1休息,2定位的' , `startdt` date NULL DEFAULT NULL , `enddt` date NULL DEFAULT NULL , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `sort` int(11) NULL DEFAULT 0 COMMENT '排序號' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='考勤分配表' AUTO_INCREMENT=10 ; -- ---------------------------- -- Table structure for `xinhu_kqdisv` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_kqdisv`; CREATE TABLE `xinhu_kqdisv` ( `id` int(11) NOT NULL AUTO_INCREMENT , `plx` tinyint(1) NULL DEFAULT 1 COMMENT '1組排班,2人員' , `receid` int(11) NULL DEFAULT 0 COMMENT '組id,人員Id' , `dt` date NULL DEFAULT NULL COMMENT '日期' , `type` tinyint(1) NULL DEFAULT 0 COMMENT '0考勤時間,1休息,2工作日' , `mid` int(11) NULL DEFAULT 0 COMMENT '對應主ID' , PRIMARY KEY (`id`), INDEX `receid` (`plx`, `receid`, `dt`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='考勤排班' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_kqdkjl` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_kqdkjl`; CREATE TABLE `xinhu_kqdkjl` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` int(11) NOT NULL DEFAULT 0 , `dkdt` datetime NULL DEFAULT NULL , `optdt` datetime NULL DEFAULT NULL , `type` tinyint(1) NULL DEFAULT 0 COMMENT '0在線打卡,1考勤機,2手機定位,3手動添加,4異常添加,5數據導入,6接口導入' , `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '定位地址' , `lat` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '緯度' , `lng` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '經度' , `accuracy` smallint(6) NULL DEFAULT 0 COMMENT '精確范圍' , `ip` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `mac` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `explain` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `imgpath` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '相關圖片' , `snid` int(11) NULL DEFAULT 0 COMMENT '考勤機設備id' , `sntype` tinyint(4) NULL DEFAULT 0 COMMENT '考勤機打卡方式0密碼,1指紋,2刷卡' , PRIMARY KEY (`id`), INDEX `uid` (`uid`, `dkdt`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='打卡記錄' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_kqdw` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_kqdw`; CREATE TABLE `xinhu_kqdw` ( `id` smallint(6) NOT NULL AUTO_INCREMENT , `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名稱' , `location_x` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `location_y` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '位置名稱' , `precision` int(11) NULL DEFAULT 0 COMMENT '允許誤差米' , `scale` smallint(6) NULL DEFAULT 0 , `wifiname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '打卡wifi名' , `iswgd` tinyint(1) NULL DEFAULT 0 COMMENT '是否為無固定地點' , `dwids` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '關聯對應ID,實現多點定位' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='考勤定位規則' AUTO_INCREMENT=3 ; -- ---------------------------- -- Table structure for `xinhu_kqerr` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_kqerr`; CREATE TABLE `xinhu_kqerr` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` smallint(6) NULL DEFAULT 0 , `uname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申請人' , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `errtype` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '異常類型' , `dt` date NULL DEFAULT NULL COMMENT '異常日期' , `ytime` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '應打卡時間' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='打卡異常申請' AUTO_INCREMENT=4 ; -- ---------------------------- -- Table structure for `xinhu_kqinfo` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_kqinfo`; CREATE TABLE `xinhu_kqinfo` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` smallint(6) NULL DEFAULT 0 , `uname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `stime` datetime NULL DEFAULT NULL , `etime` datetime NULL DEFAULT NULL , `kind` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '類型' , `qjkind` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '請假類型' , `explain` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `status` tinyint(1) NULL DEFAULT 0 COMMENT '狀態' , `totals` decimal(6,1) NULL DEFAULT 0.0 COMMENT '時間' , `optdt` datetime NULL DEFAULT NULL , `isturn` tinyint(1) NULL DEFAULT 0 COMMENT '是否提交' , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `optid` smallint(6) NULL DEFAULT 0 , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `jiafee` decimal(6,2) NULL DEFAULT 0.00 COMMENT '加班費' , `jiatype` tinyint(1) NULL DEFAULT 0 COMMENT '加班方式0換調休,1給加班費' , `totday` decimal(8,2) NULL DEFAULT 0.00 COMMENT '請假天數' , `enddt` datetime NULL DEFAULT NULL COMMENT '截止使用時間' , PRIMARY KEY (`id`), INDEX `uid` (`uid`) USING BTREE , INDEX `kind` (`kind`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='請假條加班單' AUTO_INCREMENT=136 ; -- ---------------------------- -- Table structure for `xinhu_kqjcmd` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_kqjcmd`; CREATE TABLE `xinhu_kqjcmd` ( `id` int(11) NOT NULL , `snid` int(11) NULL DEFAULT 0 COMMENT '設備ID' , `cmd` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '發送命令內容' , `status` tinyint(1) NULL DEFAULT 0 COMMENT '運行狀態0待運行,1已運行,2請求中' , `qjtime` datetime NULL DEFAULT NULL COMMENT '請求時間' , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `cjtime` datetime NULL DEFAULT NULL COMMENT '處理時間' , `atype` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '類型' , `others` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '推送主鍵id' , PRIMARY KEY (`id`), INDEX `snid` (`snid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='考勤機命令發送表' ; -- ---------------------------- -- Table structure for `xinhu_kqjsn` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_kqjsn`; CREATE TABLE `xinhu_kqjsn` ( `id` int(11) NOT NULL AUTO_INCREMENT , `num` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '設備號' , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '設備名稱' , `company` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司名' , `sort` int(11) NULL DEFAULT 0 COMMENT '排序號' , `optdt` datetime NULL DEFAULT NULL , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `deptids` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部門ID聚合' , `userids` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '人員ID聚合' , `lastdt` datetime NULL DEFAULT NULL COMMENT '最后請求時間' , `space` int(11) NULL DEFAULT 0 COMMENT 'sd卡剩余空間' , `memory` int(11) NULL DEFAULT 0 COMMENT '剩余內存' , `usershu` int(11) NULL DEFAULT 0 COMMENT '人員數' , `fingerprintshu` int(11) NULL DEFAULT 0 COMMENT '指紋數' , `headpicshu` int(11) NULL DEFAULT 0 COMMENT '頭像數量' , `clockinshu` int(11) NULL DEFAULT 0 COMMENT '打卡數' , `picshu` int(11) NULL DEFAULT 0 COMMENT '現場照片數' , `romver` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '系統版本' , `appver` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '應用版本' , `model` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '設備型號' , `pinpai` tinyint(4) NULL DEFAULT 0 COMMENT '品牌0群英,1中控' , `snip` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分配的ip' , `snport` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分配端口號' , PRIMARY KEY (`id`, `num`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='考勤機設備表' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_kqjuser` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_kqjuser`; CREATE TABLE `xinhu_kqjuser` ( `id` int(11) NOT NULL AUTO_INCREMENT , `snid` int(11) NULL DEFAULT 0 COMMENT '設備ID' , `uid` int(11) NULL DEFAULT 0 COMMENT '用戶ID' , `fingerprint1` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '指紋1' , `fingerprint2` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '指紋2' , `headpic` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '頭像' , PRIMARY KEY (`id`), UNIQUE INDEX `snid_uid` (`snid`, `uid`) USING BTREE , INDEX `snid` (`snid`) USING BTREE , INDEX `uid` (`uid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='考勤機上人員' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_kqout` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_kqout`; CREATE TABLE `xinhu_kqout` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` smallint(6) NULL DEFAULT NULL , `applyname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申請人姓名' , `outtime` datetime NULL DEFAULT NULL COMMENT '外出時間' , `intime` datetime NULL DEFAULT NULL COMMENT '回崗時間' , `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '外出地址' , `reason` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '外出事由' , `atype` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '外出類型@外出,出差' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `status` tinyint(1) NULL DEFAULT 0 COMMENT '@0|待審核,1|審核通過,2|審核不通過' , `isturn` tinyint(1) NULL DEFAULT 0 COMMENT '@0|未提交,1|提交' , `optid` int(11) NULL DEFAULT NULL , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `isxj` tinyint(1) NULL DEFAULT 0 COMMENT '是否銷假@0|否,1|是' , `sicksm` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '銷假說明' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='外出出差' AUTO_INCREMENT=6 ; -- ---------------------------- -- Table structure for `xinhu_kqsjgz` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_kqsjgz`; CREATE TABLE `xinhu_kqsjgz` ( `id` smallint(6) NOT NULL AUTO_INCREMENT , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名稱' , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序號' , `pid` smallint(6) NULL DEFAULT 0 COMMENT '主' , `stime` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '開始時間' , `etime` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '結束時間' , `qtype` tinyint(1) NULL DEFAULT 0 COMMENT '取值類型@0|最小值,1|最大值' , `iskt` tinyint(1) NULL DEFAULT 0 COMMENT '是否跨天' , `iskq` tinyint(1) NULL DEFAULT 1 COMMENT '是否需要考勤' , `isxx` tinyint(1) NULL DEFAULT 0 COMMENT '是否休息斷' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='考勤時間規則' AUTO_INCREMENT=64 ; -- ---------------------------- -- Table structure for `xinhu_kqxxsj` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_kqxxsj`; CREATE TABLE `xinhu_kqxxsj` ( `id` int(11) NOT NULL AUTO_INCREMENT , `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `dt` date NULL DEFAULT NULL , `pid` smallint(6) NULL DEFAULT 0 , `type` tinyint(1) NULL DEFAULT 0 COMMENT '0休息日,1工作日' , `uid` int(11) NULL DEFAULT 0 COMMENT '對應用戶/部門Id' , PRIMARY KEY (`id`), INDEX `pid` (`pid`, `dt`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='休息時間規則' AUTO_INCREMENT=2 ; -- ---------------------------- -- Table structure for `xinhu_lianxi` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_lianxi`; CREATE TABLE `xinhu_lianxi` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` int(11) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` int(11) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `custid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所屬客戶' , `custname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所屬客戶' , `lxname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '聯系人姓名' , `lianxitype` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '聯系人類型' , `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '郵件地址' , `tel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '電話號碼' , `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址' , `remark` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '備注' , `qq` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'qq' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=2 ; -- ---------------------------- -- Table structure for `xinhu_location` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_location`; CREATE TABLE `xinhu_location` ( `id` int(11) NOT NULL AUTO_INCREMENT , `user` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `uid` int(11) NULL DEFAULT 0 , `agentid` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '應用Id' , `optdt` datetime NULL DEFAULT NULL , `location_x` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地理位置緯度' , `location_y` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地理位置經度 ' , `scale` smallint(6) NULL DEFAULT 0 COMMENT '地圖縮放大小' , `label` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地理位置' , `msgid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `precision` smallint(6) NULL DEFAULT 0 COMMENT '地理位置精度' , `type` tinyint(4) NULL DEFAULT 0 COMMENT '0普通,1事件,2企業微信定位' , `explain` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `imgpath` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '相關圖片' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='外勤定位' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_log` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_log`; CREATE TABLE `xinhu_log` ( `id` int(11) NOT NULL AUTO_INCREMENT , `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '類型' , `optid` int(11) NULL DEFAULT NULL COMMENT '操作人id' , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '備注' , `optdt` datetime NULL DEFAULT NULL COMMENT '添加時間' , `ip` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'IP地址' , `web` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '瀏覽器' , `device` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `level` tinyint(1) NULL DEFAULT 0 COMMENT '日志級別0普通,1提示,2錯誤' , `url` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , PRIMARY KEY (`id`), INDEX `level` (`level`) USING BTREE , INDEX `type` (`type`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='系統日志' AUTO_INCREMENT=761 ; -- ---------------------------- -- Table structure for `xinhu_logintoken` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_logintoken`; CREATE TABLE `xinhu_logintoken` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` int(11) NULL DEFAULT 0 COMMENT '用戶ID' , `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `token` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `adddt` datetime NULL DEFAULT NULL , `moddt` datetime NULL DEFAULT NULL , `cfrom` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `device` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `ip` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `web` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `online` tinyint(1) NULL DEFAULT 1 , PRIMARY KEY (`id`), INDEX `token` (`token`) USING BTREE , INDEX `uid` (`uid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='系統登錄token' AUTO_INCREMENT=40 ; -- ---------------------------- -- Table structure for `xinhu_meet` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_meet`; CREATE TABLE `xinhu_meet` ( `id` int(11) NOT NULL AUTO_INCREMENT , `hyname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '會議室名稱' , `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主題' , `startdt` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '開始時間' , `enddt` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '結束時間' , `state` tinyint(1) NULL DEFAULT 0 COMMENT '會議狀態@0|正常,1|會議中,2|結束,3|取消' , `status` tinyint(1) NULL DEFAULT 0 , `type` tinyint(1) NULL DEFAULT 0 COMMENT '類型@0|普通,1|固定,2|紀要' , `joinid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `joinname` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '參加人員' , `mid` int(11) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '發起人' , `rate` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `uid` int(11) NULL DEFAULT NULL , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` int(11) NULL DEFAULT 0 , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `cancelreason` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `jyid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '會議紀要人id' , `jyname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '會議紀要人' , `content` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '會議紀要內容' , `issms` tinyint(1) NULL DEFAULT 0 COMMENT '是否短信通知' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='會議' AUTO_INCREMENT=2 ; -- ---------------------------- -- Table structure for `xinhu_menu` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_menu`; CREATE TABLE `xinhu_menu` ( `id` smallint(6) NOT NULL AUTO_INCREMENT , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜單名' , `pid` smallint(6) NULL DEFAULT 0 COMMENT '上級id' , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序' , `url` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `icons` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `optdt` datetime NULL DEFAULT NULL , `num` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '編號' , `ispir` tinyint(1) NULL DEFAULT 1 COMMENT '1驗證' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '1啟用' , `color` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `ishs` tinyint(1) NULL DEFAULT 0 COMMENT '是否在首頁顯示' , `iszm` tinyint(1) NULL DEFAULT 0 COMMENT '是否為桌面版圖標' , PRIMARY KEY (`id`), INDEX `pid` (`pid`, `status`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='系統菜單' AUTO_INCREMENT=285 ; -- ---------------------------- -- Table structure for `xinhu_news` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_news`; CREATE TABLE `xinhu_news` ( `id` int(11) NOT NULL AUTO_INCREMENT , `title` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `optdt` datetime NULL DEFAULT NULL , `typename` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL , `url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `receid` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接收人Id' , `recename` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `optid` int(11) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `enddt` date NULL DEFAULT NULL COMMENT '截止時間' , `startdt` date NULL DEFAULT NULL COMMENT '開始時間' , `zuozhe` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '發布者' , `indate` date NULL DEFAULT NULL COMMENT '日期' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `fengmian` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '封面圖片' , `mintou` smallint(6) NULL DEFAULT 0 COMMENT '至少投票' , `maxtou` smallint(6) NULL DEFAULT 0 COMMENT '最多投投票0不限制' , `issms` tinyint(1) NULL DEFAULT 0 COMMENT '是否發短信' , `istop` tinyint(1) NULL DEFAULT 0 COMMENT '是否置頂' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_official` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_official`; CREATE TABLE `xinhu_official` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` smallint(6) NULL DEFAULT 0 , `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '標題' , `titles` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '副標題' , `class` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '類型' , `type` tinyint(1) NULL DEFAULT 0 COMMENT '0收文單,1發文單' , `grade` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '等級' , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `optdt` datetime NULL DEFAULT NULL , `status` tinyint(1) NULL DEFAULT 0 COMMENT '狀態' , `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '內容' , `receid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '來源' , `recename` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '發給' , `applydt` date NULL DEFAULT NULL COMMENT '日期' , `num` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '編號' , `optid` smallint(6) NULL DEFAULT 0 , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `filecontid` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '正文文件Id' , `zinum` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '發文字號' , `unitname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '發給單位' , `unitsame` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '發文單位' , `miji` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公文密級' , `laidt` date NULL DEFAULT NULL COMMENT '來文日期' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='公文' AUTO_INCREMENT=5 ; -- ---------------------------- -- Table structure for `xinhu_option` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_option`; CREATE TABLE `xinhu_option` ( `id` int(11) NOT NULL AUTO_INCREMENT , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名稱' , `type` int(11) NULL DEFAULT 0 COMMENT '選項類型' , `pid` int(11) NULL DEFAULT NULL , `num` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '編號' , `value` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應值' , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序號' , `values` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `valid` tinyint(1) NULL DEFAULT 1 , `optdt` datetime NULL DEFAULT NULL , `optid` smallint(6) NULL DEFAULT 0 , `receid` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `recename` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `explain` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , PRIMARY KEY (`id`), INDEX `num` (`num`) USING BTREE , INDEX `pid` (`pid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='系統選項' AUTO_INCREMENT=476 ; -- ---------------------------- -- Table structure for `xinhu_project` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_project`; CREATE TABLE `xinhu_project` ( `id` int(11) NOT NULL AUTO_INCREMENT , `pid` smallint(6) NULL DEFAULT 0 , `type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '項目類型' , `num` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '編號' , `status` tinyint(1) NULL DEFAULT 0 , `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '項目名稱' , `startdt` datetime NULL DEFAULT NULL COMMENT '開始時間' , `enddt` datetime NULL DEFAULT NULL COMMENT '預計結束時間' , `fuze` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '負責人' , `fuzeid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `runuser` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '執行人員' , `runuserid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `progress` smallint(6) NULL DEFAULT 0 COMMENT '進度' , `viewuser` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '授權查看' , `viewuserid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `content` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明備注' , `optid` smallint(6) NULL DEFAULT NULL , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `optdt` datetime NULL DEFAULT NULL , `adddt` datetime NULL DEFAULT NULL COMMENT '添加時間' , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='項目表' AUTO_INCREMENT=6 ; -- ---------------------------- -- Table structure for `xinhu_reads` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_reads`; CREATE TABLE `xinhu_reads` ( `id` int(11) NOT NULL AUTO_INCREMENT , `table` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `mid` int(11) NULL DEFAULT NULL , `optid` smallint(6) NULL DEFAULT NULL , `optdt` datetime NULL DEFAULT NULL , `ip` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `web` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `adddt` datetime NULL DEFAULT NULL COMMENT '第一次瀏覽' , `stotal` smallint(6) NULL DEFAULT 1 COMMENT '流程次數' , PRIMARY KEY (`id`), UNIQUE INDEX `table_2` (`table`, `mid`, `optid`) USING BTREE , INDEX `table` (`table`, `mid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='單據瀏覽記錄表' AUTO_INCREMENT=91 ; -- ---------------------------- -- Table structure for `xinhu_receipt` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_receipt`; CREATE TABLE `xinhu_receipt` ( `id` int(11) NOT NULL AUTO_INCREMENT , `modenum` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '對應模塊編號' , `modename` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模塊名稱' , `table` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應主表' , `mid` int(11) NULL DEFAULT 0 COMMENT '主表Id' , `uid` int(11) NULL DEFAULT 0 COMMENT '對應人員' , `receid` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '發送給' , `recename` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `receids` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '已確認人員Id' , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '內容' , `ushuz` int(11) NULL DEFAULT 0 COMMENT '總人數' , `ushuy` int(11) NULL DEFAULT 0 COMMENT '已確認' , `status` tinyint(1) NULL DEFAULT 1 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , PRIMARY KEY (`id`), INDEX `modenum` (`modenum`, `mid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=2 ; -- ---------------------------- -- Table structure for `xinhu_repair` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_repair`; CREATE TABLE `xinhu_repair` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` smallint(6) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `assetm` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '報修資產' , `reason` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保修原因' , `reasons` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '實際原因' , `iswx` tinyint(1) NULL DEFAULT 0 COMMENT '需要外修' , `money` decimal(8,2) NULL DEFAULT 0.00 COMMENT '維修金額' , `wxname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '維修人員' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='維修報修' AUTO_INCREMENT=3 ; -- ---------------------------- -- Table structure for `xinhu_reward` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_reward`; CREATE TABLE `xinhu_reward` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` smallint(6) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `object` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '獎懲對象' , `objectid` smallint(6) NULL DEFAULT 0 , `type` tinyint(1) NULL DEFAULT 0 COMMENT '獎懲類型0獎勵,1處罰' , `result` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '獎懲結果' , `money` mediumint(6) NULL DEFAULT NULL COMMENT '獎懲金額' , `happendt` datetime NULL DEFAULT NULL COMMENT '發生時間' , `hapaddress` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '發生地點' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='獎懲' AUTO_INCREMENT=3 ; -- ---------------------------- -- Table structure for `xinhu_schedule` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_schedule`; CREATE TABLE `xinhu_schedule` ( `id` int(11) NOT NULL AUTO_INCREMENT , `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '標題' , `startdt` datetime NULL DEFAULT NULL , `enddt` datetime NULL DEFAULT NULL , `uid` smallint(6) NULL DEFAULT NULL COMMENT '用戶Id' , `optdt` datetime NULL DEFAULT NULL , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `mid` int(11) NULL DEFAULT 0 COMMENT '主Id' , `ratecont` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '頻率' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `rate` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `rateval` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `txsj` tinyint(1) NULL DEFAULT 0 COMMENT '是否提醒' , `status` tinyint(1) NULL DEFAULT 1 , `receid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `recename` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提醒給' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='日程' AUTO_INCREMENT=5 ; -- ---------------------------- -- Table structure for `xinhu_seal` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_seal`; CREATE TABLE `xinhu_seal` ( `id` int(11) NOT NULL AUTO_INCREMENT , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '印章名稱' , `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '印章類型' , `bgname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保管人' , `bgid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `optdt` datetime NULL DEFAULT NULL , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序號' , `sealimg` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應印章圖片' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `startdt` date NULL DEFAULT NULL COMMENT '簽發日期' , `enddt` date NULL DEFAULT NULL COMMENT '截止日期' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='印章表' AUTO_INCREMENT=3 ; -- ---------------------------- -- Table structure for `xinhu_sealapl` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_sealapl`; CREATE TABLE `xinhu_sealapl` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` smallint(6) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `sealid` smallint(6) NULL DEFAULT 0 COMMENT '印章id' , `sealname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '印章名稱' , `isout` tinyint(1) NULL DEFAULT 0 COMMENT '是否外帶' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='印章申請使用表' AUTO_INCREMENT=5 ; -- ---------------------------- -- Table structure for `xinhu_sjoin` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_sjoin`; CREATE TABLE `xinhu_sjoin` ( `id` int(11) NOT NULL AUTO_INCREMENT , `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '類型' , `mid` int(11) NULL DEFAULT NULL , `sid` int(11) NULL DEFAULT NULL , `indate` datetime NULL DEFAULT NULL , PRIMARY KEY (`id`), INDEX `type_mid` (`type`, `mid`) USING BTREE , INDEX `type_sid` (`type`, `sid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='后臺菜單權限' AUTO_INCREMENT=26 ; -- ---------------------------- -- Table structure for `xinhu_subscribe` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_subscribe`; CREATE TABLE `xinhu_subscribe` ( `id` int(11) NOT NULL AUTO_INCREMENT , `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '訂閱標題' , `cont` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '訂閱時提醒內容' , `explain` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '訂閱說明' , `optid` int(11) NULL DEFAULT 0 COMMENT '操作人ID' , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `optdt` datetime NULL DEFAULT NULL , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `suburl` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '訂閱地址' , `suburlpost` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '訂閱地址post參數' , `lastdt` datetime NULL DEFAULT NULL COMMENT '最后運行時間' , `shateid` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `shatename` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '共享給' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='訂閱管理表' AUTO_INCREMENT=2 ; -- ---------------------------- -- Table structure for `xinhu_subscribeinfo` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_subscribeinfo`; CREATE TABLE `xinhu_subscribeinfo` ( `id` int(11) NOT NULL AUTO_INCREMENT , `mid` int(11) NULL DEFAULT 0 COMMENT '對應定ID' , `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '標題' , `cont` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '內容' , `optdt` datetime NULL DEFAULT NULL , `filepath` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件路徑' , `receid` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '發送給' , `recename` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應人' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='訂閱內容信息' AUTO_INCREMENT=4 ; -- ---------------------------- -- Table structure for `xinhu_task` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_task`; CREATE TABLE `xinhu_task` ( `id` smallint(6) NOT NULL AUTO_INCREMENT , `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `fenlei` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '類型分類' , `url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '運行地址' , `type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `time` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `ratecont` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `status` tinyint(1) NULL DEFAULT 1 COMMENT '是否啟用' , `state` tinyint(1) NULL DEFAULT 0 COMMENT '最后狀態' , `lastdt` datetime NULL DEFAULT NULL , `optdt` datetime NULL DEFAULT NULL , `sort` smallint(6) NULL DEFAULT 0 , `startdt` datetime NULL DEFAULT NULL COMMENT '開始時間' , `lastcont` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `explain` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `todoid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `todoname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='計劃任務' AUTO_INCREMENT=17 ; -- ---------------------------- -- Table structure for `xinhu_todo` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_todo`; CREATE TABLE `xinhu_todo` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` smallint(6) NULL DEFAULT NULL , `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '類型' , `mess` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '信息內容' , `status` tinyint(1) NULL DEFAULT 0 COMMENT '狀態@0|未讀,1|已讀' , `optdt` datetime NULL DEFAULT NULL COMMENT '時間' , `table` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `mid` int(11) NULL DEFAULT NULL , `readdt` datetime NULL DEFAULT NULL COMMENT '已讀時間' , `tododt` datetime NULL DEFAULT NULL COMMENT '提醒時間' , `modenum` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '對應模塊編號' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='提醒消息表' AUTO_INCREMENT=104 ; -- ---------------------------- -- Table structure for `xinhu_tovoid` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_tovoid`; CREATE TABLE `xinhu_tovoid` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` smallint(6) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `type` tinyint(1) NULL DEFAULT 0 COMMENT '0|作廢,1|刪除' , `modename` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模塊' , `modeid` smallint(6) NULL DEFAULT 0 COMMENT '對應模塊id' , `tonum` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作廢單號' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='單據申請作廢表' AUTO_INCREMENT=6 ; -- ---------------------------- -- Table structure for `xinhu_userinfo` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_userinfo`; CREATE TABLE `xinhu_userinfo` ( `id` int(11) NOT NULL DEFAULT 0 , `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名' , `num` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '編號' , `deptname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `deptnames` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '多部門' , `ranking` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `rankings` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '多職位' , `dkip` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `dkmac` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `state` tinyint(1) NULL DEFAULT 0 COMMENT '狀態來自userstate' , `sex` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性別' , `tel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '電話' , `mobile` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手機號' , `workdate` date NULL DEFAULT NULL COMMENT '入職時間' , `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '郵箱' , `quitdt` date NULL DEFAULT NULL COMMENT '離職日期' , `iskq` tinyint(1) NULL DEFAULT 1 COMMENT '是否考勤' , `isdwdk` tinyint(1) NULL DEFAULT 0 COMMENT '是否定位打卡' , `birthday` date NULL DEFAULT NULL COMMENT '生日' , `xueli` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `birtype` tinyint(1) NULL DEFAULT 0 COMMENT '0陽歷1農歷' , `minzu` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '民族' , `hunyin` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '婚姻' , `jiguan` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '籍貫' , `nowdizhi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '現住址' , `housedizhi` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '家庭地址' , `syenddt` date NULL DEFAULT NULL COMMENT '試用期到' , `positivedt` date NULL DEFAULT NULL COMMENT '轉正日期' , `bankname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '開戶行' , `banknum` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工資卡帳號' , `zhaopian` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '照片' , `idnum` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份證號' , `spareman` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '備用聯系人' , `sparetel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '備用聯系人電話' , `isdaily` tinyint(4) NULL DEFAULT 1 COMMENT '是否需要寫日報' , `companyid` int(11) NULL DEFAULT 0 COMMENT '所在公司單位Id' , `finger` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '關聯考勤機人員編號' , `deptallname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='用戶檔案表' ; -- ---------------------------- -- Table structure for `xinhu_userinfos` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_userinfos`; CREATE TABLE `xinhu_userinfos` ( `id` int(11) NOT NULL AUTO_INCREMENT , `mid` smallint(6) NULL DEFAULT 0 COMMENT '對應主表userinfo.id' , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序號' , `startdt` date NULL DEFAULT NULL COMMENT '開始日期' , `enddt` date NULL DEFAULT NULL COMMENT '截止日期' , `rank` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '職位' , `unitname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '單位名稱' , `sslx` tinyint(1) NULL DEFAULT 0 COMMENT '0工作經歷,1教育經歷' , PRIMARY KEY (`id`), INDEX `mid` (`mid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='人員檔案子表' AUTO_INCREMENT=7 ; -- ---------------------------- -- Table structure for `xinhu_userract` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_userract`; CREATE TABLE `xinhu_userract` ( `id` int(11) NOT NULL AUTO_INCREMENT , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `startdt` date NULL DEFAULT NULL COMMENT '開始日期' , `enddt` date NULL DEFAULT NULL COMMENT '截止日期' , `uid` smallint(6) NULL DEFAULT 0 , `sort` smallint(6) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `httype` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同類型' , `state` tinyint(1) NULL DEFAULT 0 COMMENT '0|待執行,1|生效中,2|已終止,3|已過期' , `tqenddt` date NULL DEFAULT NULL COMMENT '提前終止' , `company` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '簽署公司' , `uname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '簽署人' , `companyid` smallint(6) NULL DEFAULT 0 COMMENT '簽署公司Id' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='用戶合同表' AUTO_INCREMENT=4 ; -- ---------------------------- -- Table structure for `xinhu_vcard` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_vcard`; CREATE TABLE `xinhu_vcard` ( `id` int(11) NOT NULL AUTO_INCREMENT , `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名' , `mobile` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手機號' , `optdt` datetime NULL DEFAULT NULL , `uid` smallint(6) NULL DEFAULT 0 , `tel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '電話' , `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '郵箱' , `gname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所在組名' , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址' , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序號' , `unitname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '單位名稱' , `sex` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性別' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='個人通訊錄' AUTO_INCREMENT=8 ; -- ---------------------------- -- Table structure for `xinhu_worc` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_worc`; CREATE TABLE `xinhu_worc` ( `id` int(11) NOT NULL AUTO_INCREMENT , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文檔分區名稱' , `recename` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '可查看人員' , `receid` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `sort` smallint(6) NULL DEFAULT 0 COMMENT '排序號' , `guanname` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理人員' , `guanid` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `uid` int(11) NULL DEFAULT 0 COMMENT '所屬用戶' , `optname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '創建人' , `uptype` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '限制上傳類型' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='文檔分區表' AUTO_INCREMENT=5 ; -- ---------------------------- -- Table structure for `xinhu_word` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_word`; CREATE TABLE `xinhu_word` ( `id` int(11) NOT NULL AUTO_INCREMENT , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名稱' , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `fileid` int(11) NULL DEFAULT 0 , `shateid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `shate` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分享給我的' , `optdt` datetime NULL DEFAULT NULL , `typeid` smallint(6) NULL DEFAULT 0 COMMENT '對應類型' , `cid` int(11) NULL DEFAULT 0 COMMENT '文檔分區ID' , `type` tinyint(1) NULL DEFAULT 0 COMMENT '0文件,1文件夾' , `sort` smallint(1) NULL DEFAULT 0 COMMENT '排序號' , PRIMARY KEY (`id`), INDEX `cid` (`cid`) USING BTREE , INDEX `type` (`type`) USING BTREE , INDEX `typeid` (`typeid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='文檔表' AUTO_INCREMENT=4 ; -- ---------------------------- -- Table structure for `xinhu_wordeil` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_wordeil`; CREATE TABLE `xinhu_wordeil` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` int(11) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '標題' , `filecontid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '相關文件' , `qianname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '簽收人' , `qiannameid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '簽收人的ID' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_wordxie` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_wordxie`; CREATE TABLE `xinhu_wordxie` ( `id` int(11) NOT NULL AUTO_INCREMENT , `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文檔名稱' , `fenlei` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分類' , `wtype` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文檔類型' , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `optid` int(11) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL , `xiename` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '協作人' , `xienameid` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `recename` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '可查看人' , `receid` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `status` tinyint(1) NULL DEFAULT 1 , `fileid` int(11) NULL DEFAULT 0 , `explian` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_work` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_work`; CREATE TABLE `xinhu_work` ( `id` int(11) NOT NULL AUTO_INCREMENT , `num` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `title` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '標題' , `type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任務類型' , `grade` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任務等級' , `distid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `dist` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分配給' , `explain` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` int(11) NULL DEFAULT NULL , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `startdt` datetime NULL DEFAULT NULL COMMENT '開始時間' , `enddt` datetime NULL DEFAULT NULL COMMENT '結束時間' , `state` tinyint(1) NULL DEFAULT 0 COMMENT '狀態' , `txdt` datetime NULL DEFAULT NULL , `fen` smallint(6) NULL DEFAULT 0 COMMENT '分值' , `status` tinyint(1) NULL DEFAULT 1 , `projectid` smallint(6) NULL DEFAULT 0 COMMENT '對應項目Id' , `ddid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `ddname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '督導人員，不填默認上級' , `score` smallint(6) NULL DEFAULT 0 COMMENT '任務分數' , `mark` smallint(6) NULL DEFAULT 0 COMMENT '得分' , `uid` smallint(6) NULL DEFAULT 0 , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='任務' AUTO_INCREMENT=7 ; -- ---------------------------- -- Table structure for `xinhu_wotpl` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_wotpl`; CREATE TABLE `xinhu_wotpl` ( `id` int(11) NOT NULL AUTO_INCREMENT , `template_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模版消息id' , `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板標題' , `primary_industry` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板所屬行業的一級行業' , `deputy_industry` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板所屬行業的二級行業' , `content` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板內容' , `example` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板示例' , `modename` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '使用名稱' , `modeparams` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '參數設置' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_wouser` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_wouser`; CREATE TABLE `xinhu_wouser` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` int(11) NULL DEFAULT 0 COMMENT '綁定用戶Id' , `openid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '微信openid' , `nickname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信昵稱' , `sex` tinyint(1) NULL DEFAULT 1 COMMENT '性別1男2女0未知' , `province` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '省份' , `city` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '城市' , `country` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '國家' , `headimgurl` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信頭像' , `adddt` datetime NULL DEFAULT NULL COMMENT '添加時間' , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'IP' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='微信用戶信息表' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `xinhu_zhuanli` -- ---------------------------- DROP TABLE IF EXISTS `xinhu_zhuanli`; CREATE TABLE `xinhu_zhuanli` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uid` smallint(6) NULL DEFAULT 0 , `optdt` datetime NULL DEFAULT NULL COMMENT '操作時間' , `optid` smallint(6) NULL DEFAULT 0 , `optname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' , `applydt` date NULL DEFAULT NULL COMMENT '申請日期' , `explain` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明' , `status` tinyint(1) NULL DEFAULT 1 COMMENT '狀態' , `isturn` tinyint(1) NULL DEFAULT 1 COMMENT '是否提交' , `kehu` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客戶' , `service_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '服務類型' , `ipr` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'IPR' , `iprid` smallint(6) NULL DEFAULT NULL COMMENT 'IPR的ID' , `case_title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案件標題' , `zl_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '專利類型' , `jishu` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '技術聯系人' , `jishuid` smallint(6) NULL DEFAULT NULL COMMENT '技術聯系人的ID' , `hetype` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同類型' , `costplan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '費用策略' , `caseid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案號' , `sort` int(11) NULL DEFAULT 0 COMMENT '排序號' , `custid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客戶' , `custname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客戶' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=15 ; ```