## 數據字典
## 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 | 上級ID |
| \*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 | 客戶 |