## 数据字典 ## xinhu\_1 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | mid | int(11) | 0 | 对应主表buzheng.id | | sort | int(11) | 0 | 排序号 | | INDEX | mid (mid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_11 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | mid | int(11) | 0 | 对应主表buzheng.id | | sort | int(11) | 0 | 排序号 | | INDEX | mid (mid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_2 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | mid | int(11) | 0 | 对应主表buzheng.id | | sort | int(11) | 0 | 排序号 | | INDEX | mid (mid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_22 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | mid | int(11) | 0 | 对应主表buzheng.id | | sort | int(11) | 0 | 排序号 | | INDEX | mid (mid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_admin:用户表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | num | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 编号 | | \*user | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 用户名 | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 姓名 | | pass | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 密码 | | loginci | smallint(6) | 0 | 登录次数 | | status | tinyint(1) | 1 | 是否启用 | | type | tinyint(1) | 0 | 0普通1管理员 | | sex | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 性别 | | tel | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 电话 | | face | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 头像地址 | | deptid | int(11) | 0 | 主部门ID | | deptname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 部门 | | deptids | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 其他部门ID | | deptnames | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 多部门 | | rankings | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 多职位 | | deptallname | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 部门全部路径 | | superid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | superman | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 上级主管 | | ranking | varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 岗位 | | sort | smallint(6) | 0 | 排序号 | | deptpath | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 部门路径 | | superpath | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 上级主管路径 | | groupname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mobile | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | apptx | tinyint(1) | 1 | 是否app提醒 | | workdate | date | NULL | 入职时间 | | email | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 邮箱 | | lastpush | datetime | NULL | 最后app推送时间 | | adddt | datetime | NULL | 新增时间 | | weixinid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 微信号 | | quitdt | date | NULL | 离职日期 | | style | tinyint(2) | 0 | 默认样式 | | pingyin | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名字拼音 | | emailpass | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 邮箱密码 | | companyid | int(11) | 0 | 所在公司单位Id | | online | tinyint(1) | 0 | 在线状态 | | lastonline | datetime | NULL | 最后在线时间 | | isvcard | tinyint(1) | 1 | 是否在通讯录上显示 | | randslat | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 随机字符串 | | user) | | | | | INDEX | email (email) USING BTREE | | | | INDEX | status (status) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_applicant | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | sqname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 申请人姓名 | | applytype | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 申请人类型 | | certificate | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 证件号码 | | sheng | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所在省 | | shi | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所在市 | | address | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 地址 | | email | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 邮箱 | | tel | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 电话 | | reductfee | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 费减状态 | | beiandate | date | NULL | 备案期限 | | remark | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 备注 | | custid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所属客户 | | custname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所属客户 | | uid | int(11) | 0 | | | optdt | datetime | NULL | 操作时间 | | optid | int(11) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | ## xinhu\_assetm:固定资产表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | typeid | smallint(6) | 0 | 类别 | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名称 | | num | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 编号 | | brand | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 品牌 | | model | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 规格型号 | | laiyuan | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 来源 | | shuname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所属部门 | | dt | date | NULL | 日期 | | ckid | smallint(50) | 0 | 存放地点 | | state | tinyint(1) | 0 | 状态 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | adddt | datetime | NULL | 添加时间 | | optdt | datetime | NULL | 操作时间 | | buydt | date | NULL | 购进日期 | | price | decimal(10,2) | NULL | 价格 | | optid | smallint(6) | 0 | | | status | tinyint(1) | 1 | 状态 | | useid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | 0 | | | usename | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 使用人 | | fengmian | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 封面图片 | ## xinhu\_book:图书表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 书名 | | typeid | smallint(6) | 0 | 对应分类 | | num | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 编号 | | author | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 作者 | | chuban | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 出版社 | | cbdt | date | NULL | 出版日期 | | price | decimal(10,2) | 0.00 | 价格 | | weizhi | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 存放位置 | | shul | smallint(6) | 0 | 数量 | | adddt | datetime | NULL | | | optdt | datetime | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | optid | smallint(6) | 0 | | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | isbn | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | jieshu | smallint(6) | 0 | 被借阅数 | ## xinhu\_bookborrow:图书借阅 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | optdt | datetime | NULL | 操作时间 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | | bookid | smallint(6) | 0 | | | bookname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 书名 | | jydt | date | NULL | 借阅日期 | | yjdt | date | NULL | 预计归还 | | ghtime | datetime | NULL | 归还时间 | | isgh | tinyint(1) | 0 | 是否归返 | ## xinhu\_buzheng | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | int(11) | 0 | | | optdt | datetime | NULL | 操作时间 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | | casename | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 案件名称 | ## xinhu\_carm:车辆表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | carnum | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 车牌号 | | carbrand | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 车辆品牌 | | carmode | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 型号 | | cartype | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 车辆类型 | | buydt | date | NULL | 购买日期 | | buyprice | mediumint(9) | NULL | 购买价格 | | enginenb | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 发动机号 | | ispublic | tinyint(1) | 1 | 是否公开使用 | | optdt | datetime | NULL | | | optid | smallint(6) | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | adddt | datetime | NULL | | | createname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | state | tinyint(1) | 0 | 状态@0|办理中,1|可用,2|维修中,3|报废 | | framenum | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 车架号 | | status | tinyint(4) | 1 | | ## xinhu\_carmang:车辆维修保养记录表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | optdt | datetime | NULL | 操作时间 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | | carid | smallint(6) | 0 | 维修车辆 | | reason | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 维修原因 | | address | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 维修地点 | | jianame | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 驾驶员 | | jiaid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | bujian | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 更换部件 | | startdt | datetime | NULL | 维修时间 | | enddt | datetime | NULL | 维修截止时间 | | money | decimal(8,2) | 0.00 | 维修金额 | | type | tinyint(1) | 0 | 类型@0|车辆维修,1|保养 | | nextdt | date | NULL | 下次保养日期 | | kmshu | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 当前保养公里数 | | kmnshu | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 下次保养公里数 | ## xinhu\_carmrese:车辆预定 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | int(11) | NULL | | | optdt | datetime | NULL | 操作时间 | | optid | int(11) | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 0 | | | isturn | tinyint(1) | 0 | | | useid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | usename | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 使用者 | | useren | smallint(6) | 0 | 使用人数 | | startdt | datetime | NULL | 开始时间 | | enddt | datetime | NULL | 截止时间 | | address | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 目的地 | | carid | smallint(6) | NULL | | | carnum | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 使用车辆 | | xianlines | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 线路 | | jiaid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | jianame | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 驾驶员 | | kmstart | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 起始公里数 | | kmend | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 结束公里数 | | returndt | datetime | NULL | 归还时间 | ## xinhu\_carms:车辆信息登记表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | carid | int(11) | 0 | 车辆Id | | otype | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 类型,加油 | | startdt | date | NULL | | | enddt | date | NULL | 截止时间 | | money | decimal(8,2) | 0.00 | 花费金额 | | optid | int(11) | 0 | 添加人id | | optdt | datetime | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 添加人 | | status | tinyint(1) | 0 | 状态 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | unitname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应名称 | | applydt | date | NULL | 申请日期 | | address | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 地点 | | jiaid | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | jianame | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 驾驶员 | ## xinhu\_chargems:系统升级 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | type | tinyint(1) | 0 | | | mid | smallint(6) | 0 | | | optdt | datetime | NULL | | | updatedt | datetime | NULL | | | modeid | smallint(6) | 0 | 对应安装模块Id | | INDEX | type (type | | | | mid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_city:城市表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) UNSIGNED | | | | \*pid | int(11) UNSIGNED | 0 | 上级ＩＤ | | \*name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | | | | \*type | tinyint(1) | 2 | 类型0国家,1省,2市,3县 | | sort | smallint(6) | 0 | 排序 | | pinyin | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | pinyins | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 拼音简称 | | INDEX | parent\_id (pid) USING BTREE | | | | INDEX | region\_type (type) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_company:公司单位表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 公司名称 | | nameen | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 英文名 | | tel | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 电话 | | fax | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 传真 | | pid | int(11) | 0 | 对应上级 | | sort | smallint(6) | 0 | 排序号 | | fuzeid | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应负责人Id | | fuzename | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应负责人 | | address | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 地址 | | city | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所在城市 | ## xinhu\_cusorder | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | mid | int(11) | 0 | 对应主表custract.id | | sort | int(11) | 0 | 排序号 | | fuwutype | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 服务项目 | | salename | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 销售人员 | | saleid | smallint(6) | NULL | 销售人员的ID | | givedt | date | NULL | 交付日期 | | unitprice | smallint(6) | NULL | 单价 | | gfee | smallint(6) | NULL | 预收官费 | | num | smallint(6) | NULL | 数量 | | INDEX | mid (mid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_custappy:客户申请使用 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | optdt | datetime | NULL | 操作时间 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | | custid | int(11) | 0 | 客户ID | | custname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 客户名称 | | INDEX | custid (custid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_custbill | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | mid | int(11) | 0 | 对应主表custfina.id | | sort | int(11) | 0 | 排序号 | | uid | int(11) | 0 | | | optdt | datetime | NULL | 操作时间 | | optid | int(11) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | | account | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 账户 | | money | smallint(6) | NULL | 金额 | | suredt | date | NULL | 支付时间 | | remark | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 备注 | | INDEX | mid (mid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_custfina:客户收付款 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | htid | int(11) | 0 | 合同ID | | htnum | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | dt | date | NULL | 所属日期 | | uid | smallint(6) | 0 | | | custid | smallint(6) | 0 | | | custname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 客户名称 | | optdt | datetime | NULL | | | optname | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | money | decimal(10,2) | 0.00 | | | type | tinyint(1) | 0 | 0收款单,1付款单 | | ispay | tinyint(1) | 0 | 是否收款,付款 | | paydt | datetime | NULL | 收付款时间 | | explain | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | createdt | datetime | NULL | 创建时间 | | createname | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | createid | smallint(6) | 0 | | | ismove | tinyint(1) | 0 | 是否转移的 | | INDEX | htid (htid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_customer:客户 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名称 | | type | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 客户类型 | | uid | smallint(6) | 0 | 所属人 | | optdt | datetime | NULL | | | optname | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | linkname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 联系人 | | unitname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 单位名称 | | laiyuan | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 来源 | | tel | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mobile | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | email | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | address | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | routeline | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | url | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 主页地址 | | status | tinyint(4) | 1 | 启用停用 | | adddt | datetime | NULL | 添加时间 | | createname | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | createid | smallint(6) | 0 | | | shate | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 共享给 | | shateid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | isgys | tinyint(1) | 0 | 是否供应商 | | isstat | tinyint(1) | 0 | 是否标\*客户 | | fzid | smallint(6) | 0 | | | fzname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 客户负责人 | | htshu | smallint(6) | 0 | 合同数 | | moneyz | decimal(10,2) | 0.00 | 销售总额 | | moneyd | decimal(10,2) | 0.00 | 待收金额 | | sheng | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所在省 | | shi | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所在市 | | isgh | tinyint(1) | 0 | 是否放入公海 | | lastdt | datetime | NULL | 最后跟进时间 | | shibieid | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 纳税识别号 | | openbank | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 开户行 | | cardid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 开户帐号 | | linkid | smallint(6) | NULL | 联系人的ID | | salename | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所属销售 | | saleid | smallint(6) | NULL | 所属销售的ID | | adviser | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所属顾问 | | adviserid | smallint(6) | NULL | 所属顾问的ID | | iacinfo | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 工商信息 | | remark | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 备注 | ## xinhu\_custract:客户合同 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | num | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 合同编号 | | optdt | datetime | NULL | 操作时间 | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 备注 | | status | tinyint(1) | 1 | 状态 | | custid | int(11) | 0 | | | custname | varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 客户名称 | | linkman | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 客户联系人 | | money | decimal(10,2) | 0.00 | 合同金额 | | moneys | decimal(10,2) | 0.00 | 待收金额 | | startdt | date | NULL | 生效日期 | | enddt | date | NULL | 截止日期 | | content | text CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 合同内容 | | saleid | smallint(6) | 0 | 销售机会Id | | isturn | tinyint(1) | 1 | 是否提交 | | signdt | date | NULL | 签约日期 | | type | tinyint(1) | 0 | 0收款合同，1付款合同 | | ispay | tinyint(1) | 0 | 0待,1已完成,2部分 | | isover | tinyint(1) | 0 | 是否已全部创建收付款单 | | createname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | createid | smallint(6) | 0 | | | salename | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 销售人员 | | givedt | date | NULL | 交付日期 | | lxid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 联系人 | | lxname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 联系人 | ## xinhu\_custsale:销售机会 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | custid | int(11) | 0 | | | custname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | uid | smallint(6) | 0 | | | optname | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optdt | datetime | NULL | | | state | tinyint(4) | 0 | 状态 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | money | decimal(10,2) | 0.00 | | | applydt | date | NULL | | | dealdt | datetime | NULL | 成交时间 | | adddt | datetime | NULL | | | laiyuan | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 销售来源 | | createid | smallint(6) | 0 | | | createname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | htid | smallint(6) | 0 | 合同ID | ## xinhu\_daily:日报 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | dt | date | NULL | 日期 | | content | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 内容 | | adddt | datetime | NULL | 新增时间 | | optdt | datetime | NULL | 操作时间 | | uid | int(11) | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 姓名 | | type | tinyint(1) | 0 | 类型@0|日报,1|周报,2|月报,3|年报 | | plan | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 明日计划 | | status | tinyint(1) | 0 | | | enddt | date | NULL | | | optid | int(11) | NULL | | | mark | smallint(6) | 0 | 得分 | ## xinhu\_dailyfx:日报分析统计表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | int(11) | NULL | | | month | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 月份 | | optdt | datetime | NULL | 分析时间 | | day1 | tinyint(1) | 0 | 0未写,1已写,2请假,3休息日 | | day2 | tinyint(1) | 0 | | | day3 | tinyint(1) | 0 | | | day4 | tinyint(1) | 0 | | | day5 | tinyint(1) | 0 | | | day6 | tinyint(1) | 0 | | | day7 | tinyint(1) | 0 | | | day8 | tinyint(1) | 0 | | | day9 | tinyint(1) | 0 | | | day10 | tinyint(1) | 0 | | | day11 | tinyint(1) | 0 | | | day12 | tinyint(1) | 0 | | | day13 | tinyint(1) | 0 | | | day14 | tinyint(1) | 0 | | | day15 | tinyint(1) | 0 | | | day16 | tinyint(1) | 0 | | | day17 | tinyint(1) | 0 | | | day18 | tinyint(1) | 0 | | | day19 | tinyint(1) | 0 | | | day20 | tinyint(1) | 0 | | | day21 | tinyint(1) | 0 | | | day22 | tinyint(1) | 0 | | | day23 | tinyint(1) | 0 | | | day24 | tinyint(1) | 0 | | | day25 | tinyint(1) | 0 | | | day26 | tinyint(1) | 0 | | | day27 | tinyint(1) | 0 | | | day28 | tinyint(1) | 0 | | | day29 | tinyint(1) | 0 | | | day30 | tinyint(1) | 0 | | | day31 | tinyint(1) | 0 | | | totaly | smallint(6) | 0 | 应写次数 | | totalx | smallint(6) | 0 | 已写次数 | | totalw | smallint(6) | 0 | 未写次数 | | explain | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | INDEX | uid (uid | | | | month) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_demo:演示测试模块 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | sheng | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 省 | | shi | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 市 | | xian | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 县(区) | | applydt | date | NULL | 申请日期 | | uid | smallint(6) | 0 | | | optdt | datetime | NULL | 操作时间 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | | tanxuan | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 弹出下来单选 | | tanxuancheck | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 弹框下拉多选 | | upfile1 | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 文件上传1 | | upfile2 | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 文件上传2 | | testfirs | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 测试字段 | | custname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 客户 | | custid | int(11) | 0 | 客户id | ## xinhu\_dept:组织结构部门 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | num | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 编号 | | name | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | pid | int(11) | NULL | | | sort | int(11) | 0 | | | optdt | datetime | NULL | | | headman | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 负责人 | | headid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | INDEX | name (name) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_editrecord:修改记录表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | fieldsname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 字段名称 | | oldval | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 原来值 | | newval | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 新值 | | table | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mid | int(11) | NULL | | | optdt | datetime | NULL | 操作时间 | | optid | smallint(6) | NULL | 操作人Id | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | editci | smallint(6) | 0 | 第几次修改记录 | | INDEX | table (table | | | | mid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_email\_cont:系统发送邮件内容 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 标题 | | body | longtext CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 内容 | | receid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | 0 | | | recename | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 接收人 | | receemail | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 接收邮件 | | optdt | datetime | NULL | | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 添加人 | | status | tinyint(1) | 0 | 0待发送,1成功,2失败 | | senddt | datetime | NULL | 发送时间 | | ccname | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 抄送给 | | ccemail | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 抄送邮件 | | attachpath | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 附件路径 | | attachname | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 福建名称 | ## xinhu\_emailm:邮件主表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | 用户iD | | title | varchar(220) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 主题 | | content | longtext CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 邮件内容 | | sendid | smallint(6) | NULL | | | sendname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 发送人 | | senddt | datetime | NULL | 发送时间 | | receid | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 接收人 | | isturn | tinyint(1) | 0 | @0|草稿,1|已发送 | | hid | smallint(6) | 0 | @回复id | | isfile | tinyint(1) | 0 | @是否有附件 | | applydt | date | NULL | | | message\_id | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 邮件Id | | fromemail | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 发送人邮件 | | toemail | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 发给邮件人 | | reply\_toemail | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 回复邮件 | | ccemail | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 抄送给 | | size | int(11) | 0 | 邮件大小 | | ccname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 抄送给 | | ccid | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | type | tinyint(1) | 0 | 0内部邮件,1用邮件外发 | | optdt | datetime | NULL | 操作时间 | | numoi | int(11) | 0 | | | INDEX | message\_id (message\_id) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_emails:邮件子表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | mid | int(11) | 0 | | | uid | smallint(6) | 0 | | | zt | tinyint(1) | 0 | @0|未读,1|已读 | | type | tinyint(1) | 0 | 0接收,1抄送,2发送者 | | ishui | tinyint(1) | 0 | 是否回复 | | isdel | tinyint(1) | 0 | @0|未删,1|已删 | | optdt | datetime | NULL | 操作时间 | | email | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | personal | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 人员 | | INDEX | mid (mid | | | | email | | | | | type) | USING BTREE | | | | INDEX | mid\_2 (mid | | | | uid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_feiyong | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | int(11) | 0 | | | optdt | datetime | NULL | 操作时间 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | ## xinhu\_file:上传文件记录表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | filenum | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 文件编号 | | valid | tinyint(4) | 1 | | | filename | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | filetype | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | fileext | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | filesize | int(11) | NULL | | | filesizecn | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | filepath | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | thumbpath | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optid | int(11) | NULL | | | optname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 上传者 | | adddt | datetime | NULL | | | ip | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | web | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mtype | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应类型 | | mid | int(11) | 0 | 管理id | | downci | int(11) | 0 | 下载次数 | | keyoi | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应序号邮件附件中用到 | | pdfpath | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 转pdf后路径 | | oid | int(11) | 0 | 旧ID | | mknum | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模块编号 | ## xinhu\_files:文件子表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | table | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mid | int(11) | 0 | | | fileid | int(11) | 0 | 关联file.id | | optid | int(11) | 0 | | | INDEX | table (table | | | | mid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_fininfom:费用报销 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | type | tinyint(2) | 0 | 类型@0|报销单,1|出差报销,2|借款单,3|还款单,4|付款申请,5|开票申请 | | uid | int(11) | NULL | | | money | decimal(10,2) | 0.00 | 金额 | | moneycn | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 大写金额 | | optdt | datetime | NULL | 操作时间 | | optid | int(11) | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 0 | | | isturn | tinyint(1) | 0 | | | bills | smallint(6) | NULL | 附单据(张) | | paytype | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 付款方式 | | fullname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 收款人全称 | | cardid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 收款帐号 | | openbank | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 开户行 | | purpose | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 用途 | | purresult | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | paydt | date | NULL | 付款日期 | | num | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 合同号/订单号 | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 开票名称 | | shibieid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 纳税识别号 | | address | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 公司地址 | | tel | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 电话 | | custid | int(11) | 0 | 对应客户ID | ## xinhu\_fininfos:费用报销子表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | mid | smallint(6) | 0 | 对应主表fininfom.id | | sort | smallint(6) | 0 | 排序号 | | sdt | date | NULL | 发生日期 | | name | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所属项目 | | money | decimal(10,2) | 0.00 | 金额 | | sm | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | didian | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 发生地点 | | INDEX | mid (mid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_finpiao | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | optname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optdt | datetime | NULL | | | optid | int(11) | 0 | | | custid | int(11) | 0 | 对应客户ID | | maicustname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 购买方 | | maicustid | int(11) | 0 | 购买方Id | | type | tinyint(1) | 0 | 0开,1收到 | | custname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 客户名称 | | daima | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 发票代码 | | haoma | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 发票号码 | | money | decimal(10,2) | 0.00 | 金额 | | opendt | date | NULL | 开票日期 | | ptype | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 发票类型 | | status | tinyint(1) | 0 | 状态 | | kainame | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 开票人 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | ## xinhu\_flow\_bill:流程单据 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | sericnum | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 单号 | | table | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应表 | | mid | int(11) | NULL | 主id | | modeid | smallint(6) | 0 | 模块id | | modename | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模块名称 | | uname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 申请人姓名 | | uid | smallint(6) | NULL | 用户id | | udeptname | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 申请人部门 | | optdt | datetime | NULL | 操作时间 | | optid | smallint(6) | 0 | 操作人Id | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | allcheckid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | @所有审核人 | | isdel | tinyint(4) | 0 | 是否删除 | | nstatus | tinyint(1) | 0 | 当前状态值 | | applydt | date | NULL | 申请日期 | | nstatustext | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 当前状态 | | status | tinyint(1) | 0 | | | nowcourseid | int(11) | 0 | 当前步骤Id | | nowcheckid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 当前审核人id | | nowcheckname | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 当前审核人 | | checksm | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 最后审核说明 | | updt | datetime | NULL | 最后更新时间 | | createdt | datetime | NULL | 创建时间 | | tuiid | int(11) | 0 | 退回flow\_log.Id | | isturn | tinyint(1) | 0 | 是否已提交了 | | INDEX | sericnum (sericnum) USING BTREE | | | | INDEX | table (table | | | | mid) | USING BTREE | | | | INDEX | status (status) USING BTREE | | | | INDEX | modeid (modeid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_chao:抄送表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | modeid | int(11) | 0 | | | table | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应表 | | mid | int(11) | 0 | 对应记录Id | | uid | int(11) | 0 | 人员Id | | csname | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 抄送给 | | csnameid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mid) | USING BTREE | | | | INDEX | modeid (modeid) USING BTREE | | | | INDEX | uid (uid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_checks:单据的审核人 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | table | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | 0 | | | mid | int(11) | NULL | | | modeid | smallint(6) | 0 | | | courseid | smallint(6) | 0 | | | checkid | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | checkname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optdt | datetime | NULL | | | status | tinyint(1) | 0 | 状态 | | addlx | tinyint(1) | 0 | 类型1自定义,2撤回添加,3退回添加,4转移添加 | | INDEX | table (table | | | | mid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_cname:自定义审核人组 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | num | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 编号 | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 审核组名 | | checkid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | checkname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 审核人 | | pid | int(11) | 0 | 上级ID | | receid | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 适用对象 | | sort | smallint(6) | 0 | 排序号 | | INDEX | num (num) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_course:流程步骤表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | mid | int(11) | 0 | 上级ID | | nid | int(11) | 0 | 下级步骤ID | | setid | smallint(6) | 0 | 模块ID | | name | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 步骤名称 | | num | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | checktype | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 审核人类型 | | checktypeid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | checktypename | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 审核人 | | sort | smallint(6) | 0 | | | whereid | smallint(6) | 0 | 流程模块条件下的Id | | where | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 审核条件 | | explain | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | optdt | datetime | NULL | | | status | tinyint(1) | 1 | | | courseact | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 审核动作 | | checkshu | tinyint(2) | 1 | 至少几人审核 ,0全部 | | checkfields | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 审核处理表单 | | pid | smallint(6) | 0 | 上级Id(弃用) | | optid | smallint(6) | 0 | 操作人id | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人姓名 | | receid | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 适用对象id | | recename | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 适用对象 | | iszf | tinyint(1) | 0 | 是否可以转给他人办理 | | isqm | tinyint(1) | 0 | 手写签名0不用,1都需要,2只需要通过,3只需要不通过 | | coursetype | tinyint(1) | 0 | 审批方式0顺序,1前置审批,2后置审批 | | zshtime | int(11) | 0 | 超时时间(分钟) | | zshstate | tinyint(2) | 1 | 自动审核类型 | | zbrangeame | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 转办人员可选范围 | | zbrangeid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 转办人员可选范围ID | | smlx | tinyint(1) | 0 | 处理说明类型 | | wjlx | tinyint(1) | 0 | 相关文件类型 | | isxgfj | tinyint(1) | 0 | 审批时是否可直接编辑附件 | | INDEX | setid (setid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_element:模块元素 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | mid | smallint(6) | 0 | | | name | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | fields | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应字段 | | fieldstype | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | sort | smallint(6) | 0 | | | dev | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 默认值 | | isbt | tinyint(1) | 0 | 是否必填 | | data | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 数据源 | | islu | tinyint(1) | 1 | 是否录入元素 | | iszs | tinyint(1) | 1 | 是否列表展示 | | attr | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 属性 | | iszb | tinyint(1) | 0 | | | isss | tinyint(1) | 0 | | | lattr | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 列属性 | | width | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 列宽 | | lens | smallint(6) | 0 | 字段长度 | | savewhere | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 保存条件 | | islb | tinyint(1) | 1 | 是否列表列 | | ispx | tinyint(1) | 0 | 是否可排序 | | isalign | tinyint(1) | 0 | 0居中,1居左,2居右 | | issou | tinyint(1) | 0 | 是否可搜索 | | istj | tinyint(1) | 0 | 是否可统计 | | gongsi | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 计算公式 | | placeholder | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 提示内容 | | isonly | tinyint(1) | 0 | 是否唯一 | | isdr | tinyint(1) | 0 | 是否导入字段 | | INDEX | mid (mid) USING BTREE | | | | INDEX | fields (fields) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_extent:模块权限 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | recename | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | receid | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | modeid | smallint(6) | 0 | 模块 | | type | tinyint(1) | 0 | 0查看,1添加,2编辑,3删除 | | wherestr | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 条件 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | \*status | tinyint(1) | 1 | | | whereid | smallint(6) | 0 | 条件Id | | fieldstr | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 相关字段 | | INDEX | modeid (modeid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_log:单据操作记录 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | table | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mid | int(11) | NULL | | | status | tinyint(4) | 0 | 1通过 | | statusname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 状态名称 | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 进程名称 | | courseid | int(11) | NULL | | | optdt | datetime | NULL | 操作时间 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | ip | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | web | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 浏览器 | | checkname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | checkid | smallint(6) | NULL | | | modeid | smallint(6) | NULL | @模块Id | | color | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | valid | tinyint(1) | 1 | | | step | smallint(6) | 0 | 步骤号 | | qmimg | text CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 签名的图片base64 | | iszb | tinyint(1) | 0 | 是否转办记录 | | INDEX | table (table | | | | mid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_menu:单据操作菜单 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 显示名称 | | num | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 编号 | | sort | tinyint(4) | 0 | | | statusname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | statuscolor | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | statusvalue | tinyint(1) | 1 | 状态值 | | actname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 动作名称 | | setid | smallint(6) | 0 | 对应模块 | | wherestr | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 显示条件 | | explain | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | status | tinyint(1) | 1 | | | islog | tinyint(1) | 1 | | | issm | tinyint(1) | 1 | | | type | tinyint(1) | 0 | 类型 | | changeaction | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 触发的方法 | | fields | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | upgcont | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 更新内容 | | iszs | tinyint(1) | 0 | 是否在详情页面显示 | | INDEX | setid (setid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_remind:单据提醒设置表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | startdt | datetime | NULL | 开始时间 | | enddt | datetime | NULL | 截止时间 | | uid | smallint(6) | NULL | 用户Id | | optdt | datetime | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | modenum | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应模块编号 | | table | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mid | int(11) | 0 | 主Id | | ratecont | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 频率 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 提醒内容 | | rate | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 提醒频率o仅一次,d天,w周,m月 | | rateval | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | status | tinyint(1) | 1 | | | receid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 提醒给 | | table | | | | | mid) | USING BTREE | | | | modenum | | | | | mid) | USING BTREE | | | | INDEX | table\_2 (table | | | | mid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_set:流程模块 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模块名称 | | \*num | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 模块编号 | | sort | smallint(6) | 0 | 排序 | | table | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应的表 | | where | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 相关条件 | | summary | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 摘要 | | summarx | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 应用摘要 | | type | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 分类 | | pctx | tinyint(1) | 0 | pc端提醒 | | mctx | tinyint(1) | 0 | app提醒 | | wxtx | tinyint(1) | 0 | 微信提醒 | | emtx | tinyint(1) | 0 | 是否邮件提醒 | | sericnum | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 编号规则 | | isflow | tinyint(1) | 1 | 是否有流程 | | receid | varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 针对对象 | | optdt | datetime | NULL | 操作时间 | | status | tinyint(1) | 1 | | | islu | tinyint(1) | 1 | 是否可录入 | | tables | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 多行子表 | | names | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 多行子表名称 | | statusstr | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 状态值设置 | | isgbjl | tinyint(1) | 0 | 是否关闭操作记录 | | isgbcy | tinyint(1) | 0 | 是否不显示查阅记录 | | isscl | tinyint(1) | 0 | 是否生成列表页 | | isup | tinyint(1) | 1 | 更新时是否同步 | | ddtx | tinyint(1) | 0 | 是否钉钉提醒 | | isbxs | tinyint(1) | 0 | 录入页面是否不显示流程图 | | lbztxs | tinyint(1) | 0 | 列表页状态搜索显示0默认,1必须显示,2显示 | | isflowlx | tinyint(1) | 0 | 从新提交时0默认，1从新走流程 | | iscs | tinyint(1) | 0 | 是否自定义抄送 | | zfeitime | int(11) | 0 | 超过分钟自动作废 | | ispl | tinyint(1) | 1 | 是否开启评论 | | istxset | tinyint(1) | 1 | 是否开启单据提醒设置 | | ishz | tinyint(1) | 0 | 回执确认0不开启,1必须选择,2可选 | | num) | ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_todo:单据通知设置表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名称标题 | | num | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 编号 | | setid | smallint(6) | 0 | 对应模块 | | explain | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | whereid | smallint(6) | 0 | 对应条件id | | status | tinyint(1) | 1 | 状态 | | receid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 通知给 | | changefields | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 改变字段 | | changecourse | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应步做id | | boturn | tinyint(1) | 0 | 提交时 | | boedit | tinyint(1) | 0 | 编辑时 | | bochang | tinyint(1) | 0 | 字段改变时 | | bodel | tinyint(1) | 0 | 删除时 | | bozuofei | tinyint(1) | 0 | 作废时 | | botong | tinyint(1) | 0 | 步骤处理通过时 | | bobutong | tinyint(1) | 0 | 步骤处理不通过时 | | bofinish | tinyint(1) | 0 | 处理完成时 | | bozhui | tinyint(1) | 0 | 追加说明时 | | bozhuan | tinyint(1) | 0 | 流程转办时 | | toturn | tinyint(1) | 0 | 是否通知给提交人 | | tocourse | tinyint(1) | 0 | 是否通知给流程所有参与人 | | todofields | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 通知给主表上字段 | | summary | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 通知内容摘要 | | botask | tinyint(1) | 0 | 计划任务 | | boping | tinyint(1) | 0 | 评论时 | | bohuiz | tinyint(1) | 0 | 回执时 | | tosuper | tinyint(1) | 0 | 直属上级 | ## xinhu\_flow\_todos:单据通知给对应人员 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | modenum | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | 0 | 对应模块编号 | | modename | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模块名称 | | table | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应主表 | | mid | int(11) | 0 | 主表Id | | uid | int(11) | 0 | 对应人员 | | adddt | datetime | NULL | 添加时间 | | readdt | datetime | NULL | 已读时间 | | isread | tinyint(1) | 0 | 是否已读 | | INDEX | table (table | | | | mid) | USING BTREE | | | | INDEX | modenum (modenum | | | | mid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_where:单据条件 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | smallint(6) | | | | setid | smallint(6) | 0 | 对应模块 | | num | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 编号 | | pnum | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 编号分组 | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 条件名称 | | wheresstr | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应表条件 | | whereustr | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 用户条件 | | wheredstr | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应部门条件 | | sort | smallint(6) | NULL | | | explain | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | receid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 包含用户 | | nreceid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | nrecename | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 不包含用户 | | islb | tinyint(1) | 0 | 是否在生成列表页面上显示 | | status | tinyint(1) | 1 | 状态 | | syrid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | syrname | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 此条件可适用对象 | | INDEX | setid (setid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_godepot:物品仓库表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | depotname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 仓库名称 | | depotaddress | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 仓库地址 | | cgname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 仓库管理员 | | cgid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 仓库管理员的ID | | depotexplain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | sort | smallint(6) | 0 | 排序号 | | depotnum | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 仓库编号 | ## xinhu\_goodm:物品领用采购申请主表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | int(11) | NULL | | | optdt | datetime | NULL | 操作时间 | | optid | int(11) | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | | type | tinyint(1) | 0 | 0领用,1采购申请 | | money | decimal(10,2) | 0.00 | 费用 | | custid | smallint(6) | 0 | | | custname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 供应商名称 | | discount | decimal(8,2) | 0.00 | 优惠价格 | | state | tinyint(1) | 0 | 0待出入库,2部分出入库,1已全部出入库 | ## xinhu\_goodn:物品库存详细表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | mid | smallint(6) | 0 | 对应主表 | | aid | smallint(6) | 0 | 物品Id | | count | smallint(6) | 0 | 数量 | | couns | smallint(6) | 0 | 已出库入库数跟count相等时就全部了 | | sort | smallint(6) | 0 | | | unit | varchar(5) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 单位 | | price | decimal(10,2) | 0.00 | 单价 | | INDEX | mid (mid) USING BTREE | | | | INDEX | aid (aid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_goods:物品表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | typeid | smallint(6) | 0 | 对应分类 | | num | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 物品编号 | | name | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | guige | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 规格 | | xinghao | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 型号 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | price | decimal(10,2) | 0.00 | 单价 | | unit | varchar(5) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 单位 | | adddt | datetime | NULL | | | optdt | datetime | NULL | | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | stock | int(11) | 0 | 库存 | | stockcs | int(11) | 0 | 初始库存 | | INDEX | typeid (typeid) USING BTREE | | | | INDEX | name (name) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_goodss:物品库存详细表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | aid | smallint(6) | 0 | 物品Id | | count | smallint(6) | 0 | 数量 | | uid | smallint(6) | 0 | | | type | tinyint(1) | 0 | 0入库,1出库 | | kind | tinyint(2) | 0 | 出入库类型 | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | applydt | date | NULL | 申请日期 | | optdt | datetime | NULL | | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | status | tinyint(1) | 1 | | | optid | int(11) | 0 | | | mid | smallint(6) | 0 | 对应主表 | | sort | smallint(6) | 0 | | | unit | varchar(5) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 单位 | | price | decimal(10,2) | 0.00 | 单价 | | depotid | smallint(6) | 1 | 存放仓库ID | | INDEX | aiddepotid (aid | | | | depotid) | USING BTREE | | | | INDEX | applydt (applydt) USING BTREE | | | | INDEX | status (status) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_group:系统组 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | smallint(6) | | | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 组名 | | sort | tinyint(4) | 0 | | | ispir | tinyint(4) | 1 | 是否权限验证 | | indate | datetime | NULL | | ## xinhu\_gwfj | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | sort | int(11) | 0 | 排序号 | | senddt | date | NULL | 发文日 | | notetype | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 通知书类型 | | officialdt | date | NULL | 官方绝限 | | caseid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 案件编号 | | uid | int(11) | 0 | | | optdt | datetime | NULL | 操作时间 | | optid | int(11) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | ## xinhu\_homeitems:桌面项目表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名称 | | \*num | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 编号 | | receid | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | sort | smallint(6) | 0 | 排序号 | | status | tinyint(1) | 1 | 状态 | | row | tinyint(1) | 0 | 所在位置 | | num) | ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_hrcheck:考核评分表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | applyname | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 申请人姓名 | | optdt | datetime | NULL | 操作时间 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | | uname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应人 | | month | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | {month} | 月份 | | content | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 考核内容 | | fenzp | decimal(6,1) | 0.0 | 自评分数 | | fensj | decimal(6,1) | 0.0 | 上级评分 | | fenrs | decimal(6,1) | 0.0 | 人事评分 | | fen | decimal(6,1) | 0.0 | 最后得分 | | title | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 考核名称 | | khid | int(11) | 0 | 关联考核项目hrkaohem.id | | createdt | datetime | NULL | 创建时间 | | startdt | date | NULL | 评分开始时间 | | enddt | date | NULL | 评分截止时间 | | pfren | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 评分人 | | pfrenid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | pfrenids | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 未评分人Id | | pfrens | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 未评分人 | ## xinhu\_hrcheckn | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | itemname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 评分项目 | | pfname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 评分名称 | | mid | smallint(6) | 0 | 对应主表hrcheck.id | | sort | smallint(6) | 0 | 排序号 | | sid | int(11) | 0 | 对应hrchecks.id | | fenshu | smallint(6) | 0 | 评分分数 | | weight | decimal(6,1) | 0.0 | 权重 | | optid | int(11) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 评分人 | | optdt | datetime | NULL | 操作时间 | | defen | decimal(6,1) | 0.0 | 最后得分 | | pfid | int(11) | 0 | 关联评分hrkaohen.Id | ## xinhu\_hrchecks | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | mid | smallint(6) | 0 | 对应主表hrkaohem.id | | sort | smallint(6) | 0 | 排序号 | | itemname | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 考评项目 | | weight | decimal(6,1) | 0.0 | 权重(%) | | fenshu | decimal(6,1) | 0.0 | 占用分数 | ## xinhu\_hrdemint:面试和人员需求表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | optdt | datetime | NULL | 操作时间 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | type | tinyint(1) | 0 | 0需求,1面试 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | | zhiwei | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 需求职位 | | xinzi | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 薪资 | | renshu | smallint(6) | 1 | 需求人数 | | content | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 职位要求/面试者简历 | | bumen | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 需求部门 | | name | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 姓名 | | msuser | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 面试人员 | | msuserid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 面试人员的ID | | mscont | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 面试记录 | | state | tinyint(1) | 0 | 面试结果0待面试,1录用,2不适合 | | msdt | datetime | NULL | 面试时间 | ## xinhu\_hrkaohem | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 考核名称 | | startdt | date | NULL | 开始日期 | | enddt | date | NULL | 截止日期 | | receid | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应考核人 | | optid | int(11) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | optdt | datetime | NULL | 操作时间 | | hegfen | smallint(6) | 0 | 合格分数 | | maxfen | smallint(6) | 100 | 最高分数 | | pinlv | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | m | 考核频率 | | sctime | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 生成时间 | | pfsj | smallint(6) | 3 | 评分时间(天) | | status | tinyint(1) | 1 | 是否启用 | ## xinhu\_hrkaohen | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | mid | smallint(6) | 0 | 对应主表hrkaohem.id | | sort | smallint(6) | 0 | 排序号 | | pfname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 评分名称 | | pftype | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 评分人类型 | | pfren | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 评分人 | | pfrenid | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | pfweight | decimal(6,1) | 0.0 | 评分权重 | ## xinhu\_hrkaohes | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | mid | smallint(6) | 0 | 对应主表hrkaohem.id | | sort | smallint(6) | 0 | 排序号 | | itemname | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 考评项目 | | weight | decimal(6,1) | 0.0 | 权重(%) | ## xinhu\_hrpositive:HR转正 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | int(11) | NULL | | | applyname | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 申请人姓名 | | ranking | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 职位 | | entrydt | date | NULL | 入职日期 | | syenddt | date | NULL | 试用到期日 | | positivedt | date | NULL | 转正日期 | | optdt | datetime | NULL | 操作时间 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 0 | @0|待审核,1|审核通过,2|审核不通过 | | isturn | tinyint(1) | 0 | @0|未提交,1|提交 | | isover | tinyint(1) | 0 | | | optid | int(11) | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | ## xinhu\_hrredund:离职申请 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | int(11) | NULL | | | applyname | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 申请人姓名 | | ranking | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 职位 | | entrydt | date | NULL | 入职日期 | | quitdt | date | NULL | 离职日期 | | redundtype | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 离职类型 | | redundreson | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 离职原因 | | optdt | datetime | NULL | 操作时间 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 0 | @0|待审核,1|审核通过,2|审核不通过 | | isturn | tinyint(1) | 0 | @0|未提交,1|提交 | | isover | tinyint(1) | 0 | | | optid | int(11) | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | ## xinhu\_hrsalarm | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模版名称 | | receid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 适用对象 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optid | int(11) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optdt | datetime | NULL | | | atype | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模版类型 | | startdt | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 开始月份 | | enddt | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 截止月份 | | sort | smallint(6) | 0 | 排序号 | | status | tinyint(1) | 1 | 是否启用 | ## xinhu\_hrsalars | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | mid | smallint(6) | 0 | 对应主表hrsalarm.id | | sort | smallint(6) | 0 | 排序号 | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名称 | | fields | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应字段 | | gongsi | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 公式 | | type | tinyint(1) | 0 | 0字段,1增加,2减少 | | beizhu | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 备注 | | devzhi | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 默认值 | ## xinhu\_hrsalary:工资表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | xuid | smallint(6) | 0 | | | uname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应人 | | udeptname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应人员部门 | | ranking | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 职位 | | optdt | datetime | NULL | 操作时间 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | | month | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 月份 | | base | decimal(10,2) | 0.00 | 基本工资 | | money | decimal(10,2) | 0.00 | 实发 | | postjt | decimal(10,2) | 0.00 | 职务津贴 | | skilljt | decimal(10,2) | 0.00 | 技能津贴 | | travelbt | decimal(10,2) | 0.00 | 交通补贴 | | telbt | decimal(10,2) | 0.00 | 通信补贴 | | reward | decimal(10,2) | 0.00 | 奖励 | | punish | decimal(10,2) | 0.00 | 处罚 | | socials | decimal(10,2) | 0.00 | 个人社保 | | taxes | decimal(10,2) | 0.00 | 个人所得税 | | ispay | tinyint(1) | 0 | 是否发放 | | otherzj | decimal(10,2) | 0.00 | 其它增加 | | otherjs | decimal(10,2) | 0.00 | 其它减少 | | cidao | smallint(6) | 0 | 迟到(次) | | cidaos | decimal(10,2) | 0.00 | 迟到处罚 | | zaotui | smallint(6) | 0 | 早退(次) | | zaotuis | decimal(10,2) | 0.00 | 早退处罚 | | leave | smallint(6) | 0 | 请假(小时) | | leaves | decimal(10,2) | 0.00 | 请假减少 | | jiaban | smallint(6) | 0 | 加班(小时) | | jiabans | decimal(10,2) | 0.00 | 加班补贴 | | weidk | smallint(6) | 0 | 未打卡(次) | | weidks | decimal(10,2) | 0.00 | 未打卡减少 | | mones | decimal(10,2) | 0.00 | 应发工资 | | socialsunit | decimal(10,2) | 0.00 | 单位社保缴费 | | taxbase | decimal(10,2) | 0.00 | 个税起征点 | | jxjs | decimal(10,2) | 0.00 | 绩效基数 | | jxxs | decimal(10,2) | 0.00 | 绩效系数 | | jxdf | decimal(10,2) | 0.00 | 绩效打分 | | jtpost | decimal(10,2) | 0.00 | 绩效收入 | | ysbtime | decimal(10,1) | 0.0 | 应上班天数 | | zsbtime | decimal(10,1) | 0.0 | 已上班天数 | | gonggeren | decimal(10,2) | 0.00 | 公积金个人 | | gongunit | decimal(10,2) | 0.00 | 公积金单位 | | foodbt | decimal(10,2) | 0.00 | 餐补贴 | | hotbt | decimal(10,2) | 0.00 | 高温津贴 | | dnbt | decimal(10,2) | 0.00 | 电脑补贴 | | jiansr | decimal(10,2) | 0.00 | 计件收入 | | otherbt | decimal(10,2) | 0.00 | 其他补贴 | ## xinhu\_hrshebao | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名称 | | recename | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 适用对象 | | receid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | status | tinyint(1) | 1 | 是否开启 | | gongjishu | decimal(10,2) | 0.00 | 公积金基数 | | yljishu | decimal(10,2) | 0.00 | 养老保险基数 | | ylgeren | decimal(10,2) | 0.00 | 养老个人比例(%) | | ylunit | decimal(10,2) | 0.00 | 养老单位比例(%) | | syjishu | decimal(10,2) | 0.00 | 失业报销基数 | | sygeren | decimal(10,2) | 0.00 | 失业个人比例(%) | | syunit | decimal(10,2) | 0.00 | 失业单位比例(%) | | gsjishu | decimal(10,2) | 0.00 | 工伤报销基数 | | gsgeren | decimal(10,2) | 0.00 | 工伤个人比例(%) | | gsunit | decimal(10,2) | 0.00 | 工伤单位比例(%) | | syujishu | decimal(10,2) | 0.00 | 生育保险基数 | | syugeren | decimal(10,2) | 0.00 | 生育个人比例(%) | | syuunit | decimal(10,2) | 0.00 | 生育单位比例(%) | | yijishu | decimal(10,2) | 0.00 | 医疗报销基数 | | yigeren | decimal(10,2) | 0.00 | 医疗个人比例(%) | | yiunit | decimal(10,2) | 0.00 | 医疗单位比例(%) | | dbgeren | decimal(10,2) | 0.00 | 大病个人 | | gjjgeren | decimal(10,2) | 0.00 | 公积金个人比例(%) | | gjjunit | decimal(10,2) | 0.00 | 公积金单位比例(%) | | shebaogeren | decimal(10,2) | 0.00 | 个人社保缴费 | | shebaounit | decimal(10,2) | 0.00 | 单位社保缴费 | | sctime | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 每月生成时间 | | optdt | datetime | NULL | | | gonggeren | decimal(10,2) | 0.00 | 公积金个人 | | gongunit | decimal(10,2) | 0.00 | 公积金单位 | | explian | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | startdt | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 开始月份 | | enddt | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 截止月份 | ## xinhu\_hrtransfer:职位调动 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | optdt | datetime | NULL | 操作时间 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | | tranuid | smallint(6) | 0 | | | tranname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 要调动人 | | trantype | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 调动类型 | | olddeptname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 原来部门 | | oldranking | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 原来职位 | | effectivedt | date | NULL | 生效日期 | | newdeptname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 调动后部门 | | newdeptid | smallint(6) | NULL | | | newranking | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 调动后职位 | | isover | tinyint(1) | 0 | 是否已完成 | ## xinhu\_hrtrsalary:调薪申请 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | applyname | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 申请人姓名 | | optdt | datetime | NULL | 操作时间 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | | effectivedt | date | NULL | 生效日期 | | floats | smallint(6) | 0 | 调薪幅度 | | ranking | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 职位 | ## xinhu\_im\_group:IM会话表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名称 | | pid | smallint(6) | 0 | 对应上级 | | types | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 应用分类 | | type | tinyint(1) | 0 | 类型@0|群,1|讨论组,2|应用 | | sort | smallint(6) | 0 | 排序号 | | createid | int(11) | NULL | | | createname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 创建人 | | createdt | datetime | NULL | 创建时间 | | face | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 头像 | | num | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | receid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | url | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | valid | tinyint(1) | 1 | | | explain | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | iconfont | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应字体图标 | | iconcolor | varchar(7) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 字体图标颜色 | | yylx | tinyint(1) | 0 | 应用类型0全部,1pc,2手机 | | urlpc | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 应用上PC地址 | | urlm | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 应用上手机端地址 | | deptid | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应部门id | | INDEX | num (num) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_im\_groupuser:IM会话人员 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | \*gid | smallint(6) | 0 | | | \*uid | smallint(6) | 0 | | | \*istx | tinyint(1) | 1 | | ## xinhu\_im\_history:IM会话记录历史表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | type | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | receid | smallint(6) | 0 | | | uid | smallint(6) | NULL | | | sendid | smallint(6) | 0 | | | optdt | datetime | NULL | | | cont | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | stotal | smallint(6) | 0 | | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 推送时标题 | | receid | | | | | uid) | USING BTREE | | | | INDEX | optdt (optdt) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_im\_menu:IM下应用菜单 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | \*mid | smallint(6) | 0 | | | \*pid | smallint(6) | 0 | | | name | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名称 | | \*sort | smallint(6) | 0 | | | type | tinyint(4) | 0 | 1url,0事件 | | url | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应地址 | | num | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | color | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 颜色 | | receid | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 可使用人员 | | INDEX | mid (mid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_im\_mess:IM聊天记录表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | optdt | datetime | NULL | | | zt | tinyint(1) | 0 | 状态 | | cont | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 内容 | | sendid | smallint(6) | NULL | | | receid | smallint(6) | 0 | 接收 | | receuid | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 接收用户id | | type | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 信息类型 | | url | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 相关地址 | | \*fileid | int(11) | 0 | 对应文件Id | | msgid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | INDEX | optdt (optdt | | | | receid) | USING BTREE | | | | INDEX | msgid (msgid) USING BTREE | | | | INDEX | type (type | | | | receid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_im\_messzt:IM聊天消息状态表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | mid | int(11) | NULL | 信息id | | uid | int(11) | NULL | 人员id | | gid | smallint(6) | 0 | | ## xinhu\_infor:通知公告 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optdt | datetime | NULL | | | typename | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | content | text CHARACTER SET utf8 COLLATE utf8\_general\_ci | | | | url | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | receid | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 接收人Id | | recename | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | enddt | datetime | NULL | 截止时间 | | startdt | datetime | NULL | 开始时间 | | zuozhe | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 发布者 | | indate | date | NULL | 日期 | | status | tinyint(1) | 1 | 状态 | | fengmian | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 封面图片 | | mintou | smallint(6) | 0 | 至少投票 | | maxtou | smallint(6) | 0 | 最多投投票0不限制 | | issms | tinyint(1) | 0 | 是否发短信 | | istop | tinyint(1) | 0 | 是否置顶 | ## xinhu\_infors:信息子表投票项 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | mid | smallint(6) | 0 | 对应主表infor.id | | sort | smallint(6) | 0 | 排序号 | | touitems | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 投票选项 | | touci | int(11) | 0 | 得到票数 | | INDEX | mid (mid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_inventor | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | invname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 发明人姓名 | | tel | smallint(6) | NULL | 电话号码 | | certificate | smallint(6) | NULL | 证件号码 | | remark | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 备注 | | email | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 邮箱 | | uid | int(11) | 0 | | | optdt | datetime | NULL | 操作时间 | | optid | int(11) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | | custid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所属客户 | | custname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所属客户 | ## xinhu\_knowledge:知识信息 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 标题 | | typeid | smallint(6) | 0 | 对应分类 | | sort | smallint(6) | 0 | 排序 | | content | text CHARACTER SET utf8 COLLATE utf8\_general\_ci | | | | optdt | datetime | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | adddt | datetime | NULL | | ## xinhu\_knowtiku:知识题库 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 标题 | | typeid | smallint(6) | 0 | | | type | tinyint(1) | 0 | 0单选,1多选 | | ana | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 答案A | | anb | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 答案B | | anc | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 答案C | | and | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 答案D | | answer | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | sort | smallint(6) | 0 | | | adddt | datetime | NULL | | | optdt | datetime | NULL | | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | status | tinyint(1) | 1 | 状态 | | content | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optid | smallint(6) | 0 | | | imgurl | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 相关图片地址 | ## xinhu\_knowtraim:培训表出题考试 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 标题 | | optid | int(11) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | optdt | datetime | NULL | | | dxshu | smallint(6) | 0 | 多选题目数量 | | dsshu | smallint(6) | 0 | 单选题目数量 | | reshu | smallint(6) | 0 | 培训人数 | | startdt | datetime | NULL | 开始时间 | | enddt | datetime | NULL | 截止时间 | | kstime | smallint(6) | 0 | 考试时间(分钟) | | ydshu | smallint(6) | 0 | 已答题人数 | | status | tinyint(1) | 1 | 状态 | | receid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 发给谁培训 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | state | tinyint(1) | 0 | 0还没开始,1考试中,2已结束 | | zfenshu | int(11) | 0 | 总分 | | hgfen | int(11) | 0 | 合格分数 | | tikuid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | tikuname | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应题库 | ## xinhu\_knowtrais:考试培训子表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | mid | int(11) | 0 | | | uid | int(11) | 0 | | | kssdt | datetime | NULL | 考试时间 | | ksedt | datetime | NULL | 考试结束时间 | | fenshu | smallint(6) | 0 | 得分 | | kstime | int(11) | 0 | 考试时间(秒数) | | isks | tinyint(1) | 0 | 是否已考试 | | tkids | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 考试题目id | | dyids | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 我做题得到答案 | | dyjgs | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 答题结果0未答,1正确,2错误 | | uid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_kqanay:考勤分析 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | dt | date | NULL | 日期 | | uid | smallint(6) | NULL | 人员id | | ztname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 状态名称 | | time | datetime | NULL | | | state | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 状态名称 | | states | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 其他状态,如请假 | | sort | smallint(6) | 0 | | | iswork | tinyint(4) | 1 | 是否工作日 | | emiao | int(11) | 0 | 秒数 | | optdt | datetime | NULL | | | remark | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | timesb | decimal(6,1) | 0.0 | 应上班时间(小时) | | timeys | decimal(6,1) | 0.0 | 已上班时间(小时) | | INDEX | uiddt (uid | | | | dt) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_kqdist:考勤分配表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | recename | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 适用对象 | | receid | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mid | smallint(6) | 0 | | | type | tinyint(1) | 0 | 0考勤时间,1休息,2定位的 | | startdt | date | NULL | | | enddt | date | NULL | | | status | tinyint(1) | 1 | 状态 | | sort | int(11) | 0 | 排序号 | ## xinhu\_kqdisv:考勤排班 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | plx | tinyint(1) | 1 | 1组排班,2人员 | | receid | int(11) | 0 | 组id,人员Id | | dt | date | NULL | 日期 | | type | tinyint(1) | 0 | 0考勤时间,1休息,2工作日 | | mid | int(11) | 0 | 对应主ID | | INDEX | receid (plx | | | | receid | | | | | dt) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_kqdkjl:打卡记录 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | \*uid | int(11) | 0 | | | dkdt | datetime | NULL | | | optdt | datetime | NULL | | | type | tinyint(1) | 0 | 0在线打卡,1考勤机,2手机定位,3手动添加,4异常添加,5数据导入,6接口导入 | | address | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 定位地址 | | lat | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 纬度 | | lng | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 经度 | | accuracy | smallint(6) | 0 | 精确范围 | | ip | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mac | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | explain | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | imgpath | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 相关图片 | | snid | int(11) | 0 | 考勤机设备id | | sntype | tinyint(4) | 0 | 考勤机打卡方式0密码,1指纹,2刷卡 | | INDEX | uid (uid | | | | dkdt) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_kqdw:考勤定位规则 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | smallint(6) | | | | name | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名称 | | location\_x | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | location\_y | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | address | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 位置名称 | | precision | int(11) | 0 | 允许误差米 | | scale | smallint(6) | 0 | | | wifiname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 打卡wifi名 | | iswgd | tinyint(1) | 0 | 是否为无固定地点 | | dwids | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 关联对应ID,实现多点定位 | ## xinhu\_kqerr:打卡异常申请 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | uname | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 申请人 | | optdt | datetime | NULL | 操作时间 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | | errtype | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 异常类型 | | dt | date | NULL | 异常日期 | | ytime | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 应打卡时间 | ## xinhu\_kqinfo:请假条加班单 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | uname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | stime | datetime | NULL | | | etime | datetime | NULL | | | kind | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 类型 | | qjkind | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 请假类型 | | explain | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | status | tinyint(1) | 0 | 状态 | | totals | decimal(6,1) | 0.0 | 时间 | | optdt | datetime | NULL | | | isturn | tinyint(1) | 0 | 是否提交 | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optid | smallint(6) | 0 | | | applydt | date | NULL | 申请日期 | | jiafee | decimal(6,2) | 0.00 | 加班费 | | jiatype | tinyint(1) | 0 | 加班方式0换调休,1给加班费 | | totday | decimal(8,2) | 0.00 | 请假天数 | | enddt | datetime | NULL | 截止使用时间 | | INDEX | uid (uid) USING BTREE | | | | INDEX | kind (kind) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_kqjcmd:考勤机命令发送表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | \*id | int(11) | | | | snid | int(11) | 0 | 设备ID | | cmd | text CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 发送命令内容 | | status | tinyint(1) | 0 | 运行状态0待运行,1已运行,2请求中 | | qjtime | datetime | NULL | 请求时间 | | optdt | datetime | NULL | 操作时间 | | cjtime | datetime | NULL | 处理时间 | | atype | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 类型 | | others | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 推送主键id | | INDEX | snid (snid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_kqjsn:考勤机设备表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | \*num | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 设备号 | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 设备名称 | | company | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 公司名 | | sort | int(11) | 0 | 排序号 | | optdt | datetime | NULL | | | status | tinyint(1) | 1 | 状态 | | deptids | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 部门ID聚合 | | userids | text CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 人员ID聚合 | | lastdt | datetime | NULL | 最后请求时间 | | space | int(11) | 0 | sd卡剩余空间 | | memory | int(11) | 0 | 剩余内存 | | usershu | int(11) | 0 | 人员数 | | fingerprintshu | int(11) | 0 | 指纹数 | | headpicshu | int(11) | 0 | 头像数量 | | clockinshu | int(11) | 0 | 打卡数 | | picshu | int(11) | 0 | 现场照片数 | | romver | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 系统版本 | | appver | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 应用版本 | | model | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 设备型号 | | pinpai | tinyint(4) | 0 | 品牌0群英,1中控 | | snip | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 分配的ip | | snport | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 分配端口号 | | num) | ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_kqjuser:考勤机上人员 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | snid | int(11) | 0 | 设备ID | | uid | int(11) | 0 | 用户ID | | fingerprint1 | text CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 指纹1 | | fingerprint2 | text CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 指纹2 | | headpic | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 头像 | | uid) | USING BTREE | | | | INDEX | snid (snid) USING BTREE | | | | INDEX | uid (uid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_kqout:外出出差 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | NULL | | | applyname | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 申请人姓名 | | outtime | datetime | NULL | 外出时间 | | intime | datetime | NULL | 回岗时间 | | address | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 外出地址 | | reason | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 外出事由 | | atype | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 外出类型@外出,出差 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | optdt | datetime | NULL | 操作时间 | | status | tinyint(1) | 0 | @0|待审核,1|审核通过,2|审核不通过 | | isturn | tinyint(1) | 0 | @0|未提交,1|提交 | | optid | int(11) | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | isxj | tinyint(1) | 0 | 是否销假@0|否,1|是 | | sicksm | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 销假说明 | ## xinhu\_kqsjgz:考勤时间规则 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | smallint(6) | | | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名称 | | sort | smallint(6) | 0 | 排序号 | | pid | smallint(6) | 0 | 主 | | stime | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 开始时间 | | etime | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 结束时间 | | qtype | tinyint(1) | 0 | 取值类型@0|最小值,1|最大值 | | iskt | tinyint(1) | 0 | 是否跨天 | | iskq | tinyint(1) | 1 | 是否需要考勤 | | isxx | tinyint(1) | 0 | 是否休息断 | ## xinhu\_kqxxsj:休息时间规则 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | dt | date | NULL | | | pid | smallint(6) | 0 | | | type | tinyint(1) | 0 | 0休息日,1工作日 | | uid | int(11) | 0 | 对应用户/部门Id | | INDEX | pid (pid | | | | dt) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_lianxi | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | int(11) | 0 | | | optdt | datetime | NULL | 操作时间 | | optid | int(11) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | | custid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所属客户 | | custname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所属客户 | | lxname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 联系人姓名 | | lianxitype | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 联系人类型 | | email | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 邮件地址 | | tel | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 电话号码 | | address | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 地址 | | remark | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 备注 | | qq | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | qq | ## xinhu\_location:外勤定位 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | user | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | uid | int(11) | 0 | | | agentid | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 应用Id | | optdt | datetime | NULL | | | location\_x | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 地理位置纬度 | | location\_y | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 地理位置经度 | | scale | smallint(6) | 0 | 地图缩放大小 | | label | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 地理位置 | | msgid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | precision | smallint(6) | 0 | 地理位置精度 | | type | tinyint(4) | 0 | 0普通,1事件,2企业微信定位 | | explain | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | imgpath | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 相关图片 | ## xinhu\_log:系统日志 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | type | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 类型 | | optid | int(11) | NULL | 操作人id | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | remark | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 备注 | | optdt | datetime | NULL | 添加时间 | | ip | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | IP地址 | | web | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 浏览器 | | device | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | level | tinyint(1) | 0 | 日志级别0普通,1提示,2错误 | | url | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | INDEX | level (level) USING BTREE | | | | INDEX | type (type) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_logintoken:系统登录token | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | int(11) | 0 | 用户ID | | name | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | token | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | adddt | datetime | NULL | | | moddt | datetime | NULL | | | cfrom | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | device | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | ip | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | web | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | online | tinyint(1) | 1 | | | INDEX | token (token) USING BTREE | | | | INDEX | uid (uid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_meet:会议 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | hyname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 会议室名称 | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 主题 | | startdt | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 开始时间 | | enddt | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 结束时间 | | state | tinyint(1) | 0 | 会议状态@0|正常,1|会议中,2|结束,3|取消 | | status | tinyint(1) | 0 | | | type | tinyint(1) | 0 | 类型@0|普通,1|固定,2|纪要 | | joinid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | joinname | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 参加人员 | | mid | int(11) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 发起人 | | rate | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | uid | int(11) | NULL | | | optdt | datetime | NULL | 操作时间 | | optid | int(11) | 0 | | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | cancelreason | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | jyid | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 会议纪要人id | | jyname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 会议纪要人 | | content | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 会议纪要内容 | | issms | tinyint(1) | 0 | 是否短信通知 | ## xinhu\_menu:系统菜单 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | smallint(6) | | | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 菜单名 | | pid | smallint(6) | 0 | 上级id | | sort | smallint(6) | 0 | 排序 | | url | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | icons | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optdt | datetime | NULL | | | num | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 编号 | | ispir | tinyint(1) | 1 | 1验证 | | status | tinyint(1) | 1 | 1启用 | | color | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | ishs | tinyint(1) | 0 | 是否在首页显示 | | iszm | tinyint(1) | 0 | 是否为桌面版图标 | | INDEX | pid (pid | | | | status) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_news | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optdt | datetime | NULL | | | typename | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | content | text CHARACTER SET utf8 COLLATE utf8\_general\_ci | | | | url | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | receid | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 接收人Id | | recename | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optid | int(11) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | enddt | date | NULL | 截止时间 | | startdt | date | NULL | 开始时间 | | zuozhe | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 发布者 | | indate | date | NULL | 日期 | | status | tinyint(1) | 1 | 状态 | | fengmian | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 封面图片 | | mintou | smallint(6) | 0 | 至少投票 | | maxtou | smallint(6) | 0 | 最多投投票0不限制 | | issms | tinyint(1) | 0 | 是否发短信 | | istop | tinyint(1) | 0 | 是否置顶 | ## xinhu\_official:公文 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | title | varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 标题 | | titles | varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 副标题 | | class | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 类型 | | type | tinyint(1) | 0 | 0收文单,1发文单 | | grade | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 等级 | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optdt | datetime | NULL | | | status | tinyint(1) | 0 | 状态 | | content | text CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 内容 | | receid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 来源 | | recename | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 发给 | | applydt | date | NULL | 日期 | | num | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 编号 | | optid | smallint(6) | 0 | | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | isturn | tinyint(1) | 1 | 是否提交 | | filecontid | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 正文文件Id | | zinum | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 发文字号 | | unitname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 发给单位 | | unitsame | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 发文单位 | | miji | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 公文密级 | | laidt | date | NULL | 来文日期 | ## xinhu\_option:系统选项 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名称 | | type | int(11) | 0 | 选项类型 | | pid | int(11) | NULL | | | num | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 编号 | | value | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应值 | | sort | smallint(6) | 0 | 排序号 | | values | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | valid | tinyint(1) | 1 | | | optdt | datetime | NULL | | | optid | smallint(6) | 0 | | | receid | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | explain | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | INDEX | num (num) USING BTREE | | | | INDEX | pid (pid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_project:项目表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | pid | smallint(6) | 0 | | | type | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 项目类型 | | num | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 编号 | | status | tinyint(1) | 0 | | | title | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 项目名称 | | startdt | datetime | NULL | 开始时间 | | enddt | datetime | NULL | 预计结束时间 | | fuze | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 负责人 | | fuzeid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | runuser | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 执行人员 | | runuserid | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | progress | smallint(6) | 0 | 进度 | | viewuser | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 授权查看 | | viewuserid | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | content | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明备注 | | optid | smallint(6) | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | optdt | datetime | NULL | | | adddt | datetime | NULL | 添加时间 | | sort | smallint(6) | 0 | 排序 | ## xinhu\_reads:单据浏览记录表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | table | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mid | int(11) | NULL | | | optid | smallint(6) | NULL | | | optdt | datetime | NULL | | | ip | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | web | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | adddt | datetime | NULL | 第一次浏览 | | stotal | smallint(6) | 1 | 流程次数 | | mid | | | | | optid) | USING BTREE | | | | INDEX | table (table | | | | mid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_receipt | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | modenum | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | 0 | 对应模块编号 | | modename | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模块名称 | | table | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应主表 | | mid | int(11) | 0 | 主表Id | | uid | int(11) | 0 | 对应人员 | | receid | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 发送给 | | recename | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | receids | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 已确认人员Id | | optdt | datetime | NULL | 操作时间 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 内容 | | ushuz | int(11) | 0 | 总人数 | | ushuy | int(11) | 0 | 已确认 | | status | tinyint(1) | 1 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | INDEX | modenum (modenum | | | | mid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_repair:维修报修 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | optdt | datetime | NULL | 操作时间 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | | assetm | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 报修资产 | | reason | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 保修原因 | | reasons | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 实际原因 | | iswx | tinyint(1) | 0 | 需要外修 | | money | decimal(8,2) | 0.00 | 维修金额 | | wxname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 维修人员 | ## xinhu\_reward:奖惩 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | optdt | datetime | NULL | 操作时间 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | | object | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 奖惩对象 | | objectid | smallint(6) | 0 | | | type | tinyint(1) | 0 | 奖惩类型0奖励,1处罚 | | result | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 奖惩结果 | | money | mediumint(6) | NULL | 奖惩金额 | | happendt | datetime | NULL | 发生时间 | | hapaddress | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 发生地点 | ## xinhu\_schedule:日程 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 标题 | | startdt | datetime | NULL | | | enddt | datetime | NULL | | | uid | smallint(6) | NULL | 用户Id | | optdt | datetime | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | mid | int(11) | 0 | 主Id | | ratecont | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 频率 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | rate | varchar(5) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | rateval | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | txsj | tinyint(1) | 0 | 是否提醒 | | status | tinyint(1) | 1 | | | receid | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 提醒给 | ## xinhu\_seal:印章表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 印章名称 | | type | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 印章类型 | | bgname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 保管人 | | bgid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optdt | datetime | NULL | | | sort | smallint(6) | 0 | 排序号 | | sealimg | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应印章图片 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | startdt | date | NULL | 签发日期 | | enddt | date | NULL | 截止日期 | ## xinhu\_sealapl:印章申请使用表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | optdt | datetime | NULL | 操作时间 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | | sealid | smallint(6) | 0 | 印章id | | sealname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 印章名称 | | isout | tinyint(1) | 0 | 是否外带 | ## xinhu\_sjoin:后台菜单权限 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | type | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 类型 | | mid | int(11) | NULL | | | sid | int(11) | NULL | | | indate | datetime | NULL | | | INDEX | type\_mid (type | | | | mid) | USING BTREE | | | | INDEX | type\_sid (type | | | | sid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_subscribe:订阅管理表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 订阅标题 | | cont | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 订阅时提醒内容 | | explain | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 订阅说明 | | optid | int(11) | 0 | 操作人ID | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | optdt | datetime | NULL | | | status | tinyint(1) | 1 | 状态 | | suburl | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 订阅地址 | | suburlpost | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 订阅地址post参数 | | lastdt | datetime | NULL | 最后运行时间 | | shateid | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | shatename | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 共享给 | ## xinhu\_subscribeinfo:订阅内容信息 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | mid | int(11) | 0 | 对应定ID | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 标题 | | cont | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 内容 | | optdt | datetime | NULL | | | filepath | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 文件路径 | | receid | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 发送给 | | recename | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应人 | ## xinhu\_task:计划任务 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | smallint(6) | | | | name | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | fenlei | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 类型分类 | | url | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 运行地址 | | type | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | time | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | ratecont | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | status | tinyint(1) | 1 | 是否启用 | | state | tinyint(1) | 0 | 最后状态 | | lastdt | datetime | NULL | | | optdt | datetime | NULL | | | sort | smallint(6) | 0 | | | startdt | datetime | NULL | 开始时间 | | lastcont | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | explain | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | todoid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | todoname | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | ## xinhu\_todo:提醒消息表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | NULL | | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 类型 | | mess | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 信息内容 | | status | tinyint(1) | 0 | 状态@0|未读,1|已读 | | optdt | datetime | NULL | 时间 | | table | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mid | int(11) | NULL | | | readdt | datetime | NULL | 已读时间 | | tododt | datetime | NULL | 提醒时间 | | modenum | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 对应模块编号 | ## xinhu\_tovoid:单据申请作废表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | optdt | datetime | NULL | 操作时间 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | | type | tinyint(1) | 0 | 0|作废,1|删除 | | modename | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模块 | | modeid | smallint(6) | 0 | 对应模块id | | tonum | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 作废单号 | ## xinhu\_userinfo:用户档案表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | \*id | int(11) | 0 | | | name | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 姓名 | | num | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 编号 | | deptname | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | deptnames | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 多部门 | | ranking | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | rankings | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 多职位 | | dkip | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | dkmac | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | state | tinyint(1) | 0 | 状态来自userstate | | sex | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 性别 | | tel | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 电话 | | mobile | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 手机号 | | workdate | date | NULL | 入职时间 | | email | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 邮箱 | | quitdt | date | NULL | 离职日期 | | iskq | tinyint(1) | 1 | 是否考勤 | | isdwdk | tinyint(1) | 0 | 是否定位打卡 | | birthday | date | NULL | 生日 | | xueli | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | birtype | tinyint(1) | 0 | 0阳历1农历 | | minzu | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 民族 | | hunyin | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 婚姻 | | jiguan | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 籍贯 | | nowdizhi | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 现住址 | | housedizhi | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 家庭地址 | | syenddt | date | NULL | 试用期到 | | positivedt | date | NULL | 转正日期 | | bankname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 开户行 | | banknum | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 工资卡帐号 | | zhaopian | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 照片 | | idnum | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 身份证号 | | spareman | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 备用联系人 | | sparetel | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 备用联系人电话 | | isdaily | tinyint(4) | 1 | 是否需要写日报 | | companyid | int(11) | 0 | 所在公司单位Id | | finger | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 关联考勤机人员编号 | | deptallname | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | ## xinhu\_userinfos:人员档案子表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | mid | smallint(6) | 0 | 对应主表userinfo.id | | sort | smallint(6) | 0 | 排序号 | | startdt | date | NULL | 开始日期 | | enddt | date | NULL | 截止日期 | | rank | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 职位 | | unitname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 单位名称 | | sslx | tinyint(1) | 0 | 0工作经历,1教育经历 | | INDEX | mid (mid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_userract:用户合同表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | startdt | date | NULL | 开始日期 | | enddt | date | NULL | 截止日期 | | uid | smallint(6) | 0 | | | sort | smallint(6) | 0 | | | optdt | datetime | NULL | | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | httype | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 合同类型 | | state | tinyint(1) | 0 | 0|待执行,1|生效中,2|已终止,3|已过期 | | tqenddt | date | NULL | 提前终止 | | company | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 签署公司 | | uname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 签署人 | | companyid | smallint(6) | 0 | 签署公司Id | ## xinhu\_vcard:个人通讯录 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 姓名 | | mobile | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 手机号 | | optdt | datetime | NULL | | | uid | smallint(6) | 0 | | | tel | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 电话 | | email | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 邮箱 | | gname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所在组名 | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | address | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 地址 | | sort | smallint(6) | 0 | 排序号 | | unitname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 单位名称 | | sex | varchar(5) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 性别 | ## xinhu\_worc:文档分区表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 文档分区名称 | | recename | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 可查看人员 | | receid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | sort | smallint(6) | 0 | 排序号 | | guanname | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 管理人员 | | guanid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optdt | datetime | NULL | 操作时间 | | uid | int(11) | 0 | 所属用户 | | optname | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 创建人 | | uptype | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 限制上传类型 | ## xinhu\_word:文档表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名称 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | fileid | int(11) | 0 | | | shateid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | shate | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 分享给我的 | | optdt | datetime | NULL | | | typeid | smallint(6) | 0 | 对应类型 | | cid | int(11) | 0 | 文档分区ID | | type | tinyint(1) | 0 | 0文件,1文件夹 | | sort | smallint(1) | 0 | 排序号 | | INDEX | cid (cid) USING BTREE | | | | INDEX | type (type) USING BTREE | | | | INDEX | typeid (typeid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_wordeil | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | int(11) | 0 | | | optdt | datetime | NULL | 操作时间 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | | title | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 标题 | | filecontid | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 相关文件 | | qianname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 签收人 | | qiannameid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 签收人的ID | ## xinhu\_wordxie | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 文档名称 | | fenlei | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 分类 | | wtype | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 文档类型 | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optid | int(11) | 0 | | | optdt | datetime | NULL | | | xiename | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 协作人 | | xienameid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 可查看人 | | receid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | status | tinyint(1) | 1 | | | fileid | int(11) | 0 | | | explian | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | ## xinhu\_work:任务 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | num | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | title | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 标题 | | type | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 任务类型 | | grade | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 任务等级 | | distid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | dist | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 分配给 | | explain | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | optdt | datetime | NULL | 操作时间 | | optid | int(11) | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | startdt | datetime | NULL | 开始时间 | | enddt | datetime | NULL | 结束时间 | | state | tinyint(1) | 0 | 状态 | | txdt | datetime | NULL | | | fen | smallint(6) | 0 | 分值 | | status | tinyint(1) | 1 | | | projectid | smallint(6) | 0 | 对应项目Id | | ddid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | ddname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 督导人员，不填默认上级 | | score | smallint(6) | 0 | 任务分数 | | mark | smallint(6) | 0 | 得分 | | uid | smallint(6) | 0 | | | applydt | date | NULL | 申请日期 | | isturn | tinyint(1) | 1 | 是否提交 | ## xinhu\_wotpl | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | template\_id | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模版消息id | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模板标题 | | primary\_industry | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模板所属行业的一级行业 | | deputy\_industry | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模板所属行业的二级行业 | | content | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模板内容 | | example | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模板示例 | | modename | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 使用名称 | | modeparams | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 参数设置 | | status | tinyint(1) | 1 | 状态 | ## xinhu\_wouser:微信用户信息表 | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | int(11) | 0 | 绑定用户Id | | openid | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | 微信openid | | | nickname | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 微信昵称 | | sex | tinyint(1) | 1 | 性别1男2女0未知 | | province | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 省份 | | city | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 城市 | | country | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 国家 | | headimgurl | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 微信头像 | | adddt | datetime | NULL | 添加时间 | | optdt | datetime | NULL | 操作时间 | | ip | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | IP | ## xinhu\_zhuanli | 字段 | 类型 | 默认值 | 注释 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | optdt | datetime | NULL | 操作时间 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申请日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 说明 | | status | tinyint(1) | 1 | 状态 | | isturn | tinyint(1) | 1 | 是否提交 | | kehu | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 客户 | | service\_type | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 服务类型 | | ipr | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | IPR | | iprid | smallint(6) | NULL | IPR的ID | | case\_title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 案件标题 | | zl\_type | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 专利类型 | | jishu | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 技术联系人 | | jishuid | smallint(6) | NULL | 技术联系人的ID | | hetype | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 合同类型 | | costplan | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 费用策略 | | caseid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 案号 | | sort | int(11) | 0 | 排序号 | | custid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 客户 | | custname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 客户 |