## 数据字典 ```[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 ; ```