數據字典2 · 專利平臺文檔

## 數據字典 ## xinhu\_1 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | mid | int(11) | 0 | 對應主表buzheng.id | | sort | int(11) | 0 | 排序號 | | INDEX | mid (mid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_11 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | mid | int(11) | 0 | 對應主表buzheng.id | | sort | int(11) | 0 | 排序號 | | INDEX | mid (mid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_2 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | mid | int(11) | 0 | 對應主表buzheng.id | | sort | int(11) | 0 | 排序號 | | INDEX | mid (mid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_22 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | mid | int(11) | 0 | 對應主表buzheng.id | | sort | int(11) | 0 | 排序號 | | INDEX | mid (mid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_admin:用戶表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | num | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 編號 | | \*user | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 用戶名 | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 姓名 | | pass | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 密碼 | | loginci | smallint(6) | 0 | 登錄次數 | | status | tinyint(1) | 1 | 是否啟用 | | type | tinyint(1) | 0 | 0普通1管理員 | | sex | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 性別 | | tel | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 電話 | | face | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 頭像地址 | | deptid | int(11) | 0 | 主部門ID | | deptname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 部門 | | deptids | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 其他部門ID | | deptnames | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 多部門 | | rankings | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 多職位 | | deptallname | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 部門全部路徑 | | superid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | superman | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 上級主管 | | ranking | varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 崗位 | | sort | smallint(6) | 0 | 排序號 | | deptpath | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 部門路徑 | | superpath | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 上級主管路徑 | | groupname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mobile | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | apptx | tinyint(1) | 1 | 是否app提醒 | | workdate | date | NULL | 入職時間 | | email | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 郵箱 | | lastpush | datetime | NULL | 最后app推送時間 | | adddt | datetime | NULL | 新增時間 | | weixinid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 微信號 | | quitdt | date | NULL | 離職日期 | | style | tinyint(2) | 0 | 默認樣式 | | pingyin | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名字拼音 | | emailpass | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 郵箱密碼 | | companyid | int(11) | 0 | 所在公司單位Id | | online | tinyint(1) | 0 | 在線狀態 | | lastonline | datetime | NULL | 最后在線時間 | | isvcard | tinyint(1) | 1 | 是否在通訊錄上顯示 | | randslat | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 隨機字符串 | | user) | | | | | INDEX | email (email) USING BTREE | | | | INDEX | status (status) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_applicant | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | sqname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 申請人姓名 | | applytype | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 申請人類型 | | certificate | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 證件號碼 | | sheng | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所在省 | | shi | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所在市 | | address | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 地址 | | email | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 郵箱 | | tel | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 電話 | | reductfee | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 費減狀態 | | beiandate | date | NULL | 備案期限 | | remark | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 備注 | | custid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所屬客戶 | | custname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所屬客戶 | | uid | int(11) | 0 | | | optdt | datetime | NULL | 操作時間 | | optid | int(11) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | ## xinhu\_assetm:固定資產表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | typeid | smallint(6) | 0 | 類別 | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名稱 | | num | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 編號 | | brand | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 品牌 | | model | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 規格型號 | | laiyuan | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 來源 | | shuname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所屬部門 | | dt | date | NULL | 日期 | | ckid | smallint(50) | 0 | 存放地點 | | state | tinyint(1) | 0 | 狀態 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | adddt | datetime | NULL | 添加時間 | | optdt | datetime | NULL | 操作時間 | | buydt | date | NULL | 購進日期 | | price | decimal(10,2) | NULL | 價格 | | optid | smallint(6) | 0 | | | status | tinyint(1) | 1 | 狀態 | | useid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | 0 | | | usename | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 使用人 | | fengmian | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 封面圖片 | ## xinhu\_book:圖書表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 書名 | | typeid | smallint(6) | 0 | 對應分類 | | num | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 編號 | | author | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 作者 | | chuban | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 出版社 | | cbdt | date | NULL | 出版日期 | | price | decimal(10,2) | 0.00 | 價格 | | weizhi | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 存放位置 | | shul | smallint(6) | 0 | 數量 | | adddt | datetime | NULL | | | optdt | datetime | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | optid | smallint(6) | 0 | | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | isbn | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | jieshu | smallint(6) | 0 | 被借閱數 | ## xinhu\_bookborrow:圖書借閱 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | optdt | datetime | NULL | 操作時間 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | | bookid | smallint(6) | 0 | | | bookname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 書名 | | jydt | date | NULL | 借閱日期 | | yjdt | date | NULL | 預計歸還 | | ghtime | datetime | NULL | 歸還時間 | | isgh | tinyint(1) | 0 | 是否歸返 | ## xinhu\_buzheng | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | int(11) | 0 | | | optdt | datetime | NULL | 操作時間 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | | casename | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 案件名稱 | ## xinhu\_carm:車輛表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | carnum | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 車牌號 | | carbrand | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 車輛品牌 | | carmode | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 型號 | | cartype | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 車輛類型 | | buydt | date | NULL | 購買日期 | | buyprice | mediumint(9) | NULL | 購買價格 | | enginenb | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 發動機號 | | ispublic | tinyint(1) | 1 | 是否公開使用 | | optdt | datetime | NULL | | | optid | smallint(6) | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | adddt | datetime | NULL | | | createname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | state | tinyint(1) | 0 | 狀態@0|辦理中,1|可用,2|維修中,3|報廢 | | framenum | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 車架號 | | status | tinyint(4) | 1 | | ## xinhu\_carmang:車輛維修保養記錄表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | optdt | datetime | NULL | 操作時間 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | | carid | smallint(6) | 0 | 維修車輛 | | reason | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 維修原因 | | address | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 維修地點 | | jianame | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 駕駛員 | | jiaid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | bujian | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 更換部件 | | startdt | datetime | NULL | 維修時間 | | enddt | datetime | NULL | 維修截止時間 | | money | decimal(8,2) | 0.00 | 維修金額 | | type | tinyint(1) | 0 | 類型@0|車輛維修,1|保養 | | nextdt | date | NULL | 下次保養日期 | | kmshu | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 當前保養公里數 | | kmnshu | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 下次保養公里數 | ## xinhu\_carmrese:車輛預定 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | int(11) | NULL | | | optdt | datetime | NULL | 操作時間 | | optid | int(11) | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 0 | | | isturn | tinyint(1) | 0 | | | useid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | usename | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 使用者 | | useren | smallint(6) | 0 | 使用人數 | | startdt | datetime | NULL | 開始時間 | | enddt | datetime | NULL | 截止時間 | | address | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 目的地 | | carid | smallint(6) | NULL | | | carnum | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 使用車輛 | | xianlines | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 線路 | | jiaid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | jianame | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 駕駛員 | | kmstart | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 起始公里數 | | kmend | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 結束公里數 | | returndt | datetime | NULL | 歸還時間 | ## xinhu\_carms:車輛信息登記表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | carid | int(11) | 0 | 車輛Id | | otype | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 類型,加油 | | startdt | date | NULL | | | enddt | date | NULL | 截止時間 | | money | decimal(8,2) | 0.00 | 花費金額 | | optid | int(11) | 0 | 添加人id | | optdt | datetime | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 添加人 | | status | tinyint(1) | 0 | 狀態 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | unitname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應名稱 | | applydt | date | NULL | 申請日期 | | address | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 地點 | | jiaid | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | jianame | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 駕駛員 | ## xinhu\_chargems:系統升級 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | type | tinyint(1) | 0 | | | mid | smallint(6) | 0 | | | optdt | datetime | NULL | | | updatedt | datetime | NULL | | | modeid | smallint(6) | 0 | 對應安裝模塊Id | | INDEX | type (type | | | | mid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_city:城市表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) UNSIGNED | | | | \*pid | int(11) UNSIGNED | 0 | 上級ＩＤ | | \*name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | | | | \*type | tinyint(1) | 2 | 類型0國家,1省,2市,3縣 | | sort | smallint(6) | 0 | 排序 | | pinyin | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | pinyins | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 拼音簡稱 | | INDEX | parent\_id (pid) USING BTREE | | | | INDEX | region\_type (type) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_company:公司單位表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 公司名稱 | | nameen | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 英文名 | | tel | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 電話 | | fax | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 傳真 | | pid | int(11) | 0 | 對應上級 | | sort | smallint(6) | 0 | 排序號 | | fuzeid | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應負責人Id | | fuzename | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應負責人 | | address | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 地址 | | city | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所在城市 | ## xinhu\_cusorder | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | mid | int(11) | 0 | 對應主表custract.id | | sort | int(11) | 0 | 排序號 | | fuwutype | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 服務項目 | | salename | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 銷售人員 | | saleid | smallint(6) | NULL | 銷售人員的ID | | givedt | date | NULL | 交付日期 | | unitprice | smallint(6) | NULL | 單價 | | gfee | smallint(6) | NULL | 預收官費 | | num | smallint(6) | NULL | 數量 | | INDEX | mid (mid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_custappy:客戶申請使用 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | optdt | datetime | NULL | 操作時間 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | | custid | int(11) | 0 | 客戶ID | | custname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 客戶名稱 | | INDEX | custid (custid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_custbill | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | mid | int(11) | 0 | 對應主表custfina.id | | sort | int(11) | 0 | 排序號 | | uid | int(11) | 0 | | | optdt | datetime | NULL | 操作時間 | | optid | int(11) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | | account | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 賬戶 | | money | smallint(6) | NULL | 金額 | | suredt | date | NULL | 支付時間 | | remark | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 備注 | | INDEX | mid (mid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_custfina:客戶收付款 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | htid | int(11) | 0 | 合同ID | | htnum | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | dt | date | NULL | 所屬日期 | | uid | smallint(6) | 0 | | | custid | smallint(6) | 0 | | | custname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 客戶名稱 | | optdt | datetime | NULL | | | optname | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | money | decimal(10,2) | 0.00 | | | type | tinyint(1) | 0 | 0收款單,1付款單 | | ispay | tinyint(1) | 0 | 是否收款,付款 | | paydt | datetime | NULL | 收付款時間 | | explain | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | createdt | datetime | NULL | 創建時間 | | createname | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | createid | smallint(6) | 0 | | | ismove | tinyint(1) | 0 | 是否轉移的 | | INDEX | htid (htid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_customer:客戶 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名稱 | | type | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 客戶類型 | | uid | smallint(6) | 0 | 所屬人 | | optdt | datetime | NULL | | | optname | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | linkname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 聯系人 | | unitname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 單位名稱 | | laiyuan | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 來源 | | tel | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mobile | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | email | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | address | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | routeline | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | url | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 主頁地址 | | status | tinyint(4) | 1 | 啟用停用 | | adddt | datetime | NULL | 添加時間 | | createname | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | createid | smallint(6) | 0 | | | shate | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 共享給 | | shateid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | isgys | tinyint(1) | 0 | 是否供應商 | | isstat | tinyint(1) | 0 | 是否標\*客戶 | | fzid | smallint(6) | 0 | | | fzname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 客戶負責人 | | htshu | smallint(6) | 0 | 合同數 | | moneyz | decimal(10,2) | 0.00 | 銷售總額 | | moneyd | decimal(10,2) | 0.00 | 待收金額 | | sheng | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所在省 | | shi | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所在市 | | isgh | tinyint(1) | 0 | 是否放入公海 | | lastdt | datetime | NULL | 最后跟進時間 | | shibieid | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 納稅識別號 | | openbank | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 開戶行 | | cardid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 開戶帳號 | | linkid | smallint(6) | NULL | 聯系人的ID | | salename | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所屬銷售 | | saleid | smallint(6) | NULL | 所屬銷售的ID | | adviser | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所屬顧問 | | adviserid | smallint(6) | NULL | 所屬顧問的ID | | iacinfo | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 工商信息 | | remark | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 備注 | ## xinhu\_custract:客戶合同 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | num | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 合同編號 | | optdt | datetime | NULL | 操作時間 | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 備注 | | status | tinyint(1) | 1 | 狀態 | | custid | int(11) | 0 | | | custname | varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 客戶名稱 | | linkman | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 客戶聯系人 | | money | decimal(10,2) | 0.00 | 合同金額 | | moneys | decimal(10,2) | 0.00 | 待收金額 | | startdt | date | NULL | 生效日期 | | enddt | date | NULL | 截止日期 | | content | text CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 合同內容 | | saleid | smallint(6) | 0 | 銷售機會Id | | isturn | tinyint(1) | 1 | 是否提交 | | signdt | date | NULL | 簽約日期 | | type | tinyint(1) | 0 | 0收款合同，1付款合同 | | ispay | tinyint(1) | 0 | 0待,1已完成,2部分 | | isover | tinyint(1) | 0 | 是否已全部創建收付款單 | | createname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | createid | smallint(6) | 0 | | | salename | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 銷售人員 | | givedt | date | NULL | 交付日期 | | lxid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 聯系人 | | lxname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 聯系人 | ## xinhu\_custsale:銷售機會 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | custid | int(11) | 0 | | | custname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | uid | smallint(6) | 0 | | | optname | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optdt | datetime | NULL | | | state | tinyint(4) | 0 | 狀態 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | money | decimal(10,2) | 0.00 | | | applydt | date | NULL | | | dealdt | datetime | NULL | 成交時間 | | adddt | datetime | NULL | | | laiyuan | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 銷售來源 | | createid | smallint(6) | 0 | | | createname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | htid | smallint(6) | 0 | 合同ID | ## xinhu\_daily:日報 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | dt | date | NULL | 日期 | | content | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 內容 | | adddt | datetime | NULL | 新增時間 | | optdt | datetime | NULL | 操作時間 | | uid | int(11) | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 姓名 | | type | tinyint(1) | 0 | 類型@0|日報,1|周報,2|月報,3|年報 | | plan | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 明日計劃 | | status | tinyint(1) | 0 | | | enddt | date | NULL | | | optid | int(11) | NULL | | | mark | smallint(6) | 0 | 得分 | ## xinhu\_dailyfx:日報分析統計表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | int(11) | NULL | | | month | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 月份 | | optdt | datetime | NULL | 分析時間 | | day1 | tinyint(1) | 0 | 0未寫,1已寫,2請假,3休息日 | | day2 | tinyint(1) | 0 | | | day3 | tinyint(1) | 0 | | | day4 | tinyint(1) | 0 | | | day5 | tinyint(1) | 0 | | | day6 | tinyint(1) | 0 | | | day7 | tinyint(1) | 0 | | | day8 | tinyint(1) | 0 | | | day9 | tinyint(1) | 0 | | | day10 | tinyint(1) | 0 | | | day11 | tinyint(1) | 0 | | | day12 | tinyint(1) | 0 | | | day13 | tinyint(1) | 0 | | | day14 | tinyint(1) | 0 | | | day15 | tinyint(1) | 0 | | | day16 | tinyint(1) | 0 | | | day17 | tinyint(1) | 0 | | | day18 | tinyint(1) | 0 | | | day19 | tinyint(1) | 0 | | | day20 | tinyint(1) | 0 | | | day21 | tinyint(1) | 0 | | | day22 | tinyint(1) | 0 | | | day23 | tinyint(1) | 0 | | | day24 | tinyint(1) | 0 | | | day25 | tinyint(1) | 0 | | | day26 | tinyint(1) | 0 | | | day27 | tinyint(1) | 0 | | | day28 | tinyint(1) | 0 | | | day29 | tinyint(1) | 0 | | | day30 | tinyint(1) | 0 | | | day31 | tinyint(1) | 0 | | | totaly | smallint(6) | 0 | 應寫次數 | | totalx | smallint(6) | 0 | 已寫次數 | | totalw | smallint(6) | 0 | 未寫次數 | | explain | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | INDEX | uid (uid | | | | month) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_demo:演示測試模塊 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | sheng | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 省 | | shi | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 市 | | xian | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 縣(區) | | applydt | date | NULL | 申請日期 | | uid | smallint(6) | 0 | | | optdt | datetime | NULL | 操作時間 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | | tanxuan | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 彈出下來單選 | | tanxuancheck | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 彈框下拉多選 | | upfile1 | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 文件上傳1 | | upfile2 | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 文件上傳2 | | testfirs | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 測試字段 | | custname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 客戶 | | custid | int(11) | 0 | 客戶id | ## xinhu\_dept:組織結構部門 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | num | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 編號 | | name | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | pid | int(11) | NULL | | | sort | int(11) | 0 | | | optdt | datetime | NULL | | | headman | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 負責人 | | headid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | INDEX | name (name) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_editrecord:修改記錄表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | fieldsname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 字段名稱 | | oldval | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 原來值 | | newval | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 新值 | | table | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mid | int(11) | NULL | | | optdt | datetime | NULL | 操作時間 | | optid | smallint(6) | NULL | 操作人Id | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | editci | smallint(6) | 0 | 第幾次修改記錄 | | INDEX | table (table | | | | mid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_email\_cont:系統發送郵件內容 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 標題 | | body | longtext CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 內容 | | receid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | 0 | | | recename | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 接收人 | | receemail | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 接收郵件 | | optdt | datetime | NULL | | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 添加人 | | status | tinyint(1) | 0 | 0待發送,1成功,2失敗 | | senddt | datetime | NULL | 發送時間 | | ccname | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 抄送給 | | ccemail | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 抄送郵件 | | attachpath | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 附件路徑 | | attachname | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 福建名稱 | ## xinhu\_emailm:郵件主表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | 用戶iD | | title | varchar(220) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 主題 | | content | longtext CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 郵件內容 | | sendid | smallint(6) | NULL | | | sendname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 發送人 | | senddt | datetime | NULL | 發送時間 | | receid | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 接收人 | | isturn | tinyint(1) | 0 | @0|草稿,1|已發送 | | hid | smallint(6) | 0 | @回復id | | isfile | tinyint(1) | 0 | @是否有附件 | | applydt | date | NULL | | | message\_id | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 郵件Id | | fromemail | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 發送人郵件 | | toemail | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 發給郵件人 | | reply\_toemail | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 回復郵件 | | ccemail | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 抄送給 | | size | int(11) | 0 | 郵件大小 | | ccname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 抄送給 | | ccid | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | type | tinyint(1) | 0 | 0內部郵件,1用郵件外發 | | optdt | datetime | NULL | 操作時間 | | numoi | int(11) | 0 | | | INDEX | message\_id (message\_id) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_emails:郵件子表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | mid | int(11) | 0 | | | uid | smallint(6) | 0 | | | zt | tinyint(1) | 0 | @0|未讀,1|已讀 | | type | tinyint(1) | 0 | 0接收,1抄送,2發送者 | | ishui | tinyint(1) | 0 | 是否回復 | | isdel | tinyint(1) | 0 | @0|未刪,1|已刪 | | optdt | datetime | NULL | 操作時間 | | email | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | personal | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 人員 | | INDEX | mid (mid | | | | email | | | | | type) | USING BTREE | | | | INDEX | mid\_2 (mid | | | | uid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_feiyong | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | int(11) | 0 | | | optdt | datetime | NULL | 操作時間 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | ## xinhu\_file:上傳文件記錄表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | filenum | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 文件編號 | | valid | tinyint(4) | 1 | | | filename | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | filetype | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | fileext | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | filesize | int(11) | NULL | | | filesizecn | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | filepath | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | thumbpath | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optid | int(11) | NULL | | | optname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 上傳者 | | adddt | datetime | NULL | | | ip | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | web | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mtype | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應類型 | | mid | int(11) | 0 | 管理id | | downci | int(11) | 0 | 下載次數 | | keyoi | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應序號郵件附件中用到 | | pdfpath | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 轉pdf后路徑 | | oid | int(11) | 0 | 舊ID | | mknum | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模塊編號 | ## xinhu\_files:文件子表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | table | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mid | int(11) | 0 | | | fileid | int(11) | 0 | 關聯file.id | | optid | int(11) | 0 | | | INDEX | table (table | | | | mid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_fininfom:費用報銷 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | type | tinyint(2) | 0 | 類型@0|報銷單,1|出差報銷,2|借款單,3|還款單,4|付款申請,5|開票申請 | | uid | int(11) | NULL | | | money | decimal(10,2) | 0.00 | 金額 | | moneycn | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 大寫金額 | | optdt | datetime | NULL | 操作時間 | | optid | int(11) | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 0 | | | isturn | tinyint(1) | 0 | | | bills | smallint(6) | NULL | 附單據(張) | | paytype | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 付款方式 | | fullname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 收款人全稱 | | cardid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 收款帳號 | | openbank | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 開戶行 | | purpose | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 用途 | | purresult | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | paydt | date | NULL | 付款日期 | | num | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 合同號/訂單號 | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 開票名稱 | | shibieid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 納稅識別號 | | address | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 公司地址 | | tel | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 電話 | | custid | int(11) | 0 | 對應客戶ID | ## xinhu\_fininfos:費用報銷子表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | mid | smallint(6) | 0 | 對應主表fininfom.id | | sort | smallint(6) | 0 | 排序號 | | sdt | date | NULL | 發生日期 | | name | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所屬項目 | | money | decimal(10,2) | 0.00 | 金額 | | sm | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | didian | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 發生地點 | | INDEX | mid (mid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_finpiao | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | optname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optdt | datetime | NULL | | | optid | int(11) | 0 | | | custid | int(11) | 0 | 對應客戶ID | | maicustname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 購買方 | | maicustid | int(11) | 0 | 購買方Id | | type | tinyint(1) | 0 | 0開,1收到 | | custname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 客戶名稱 | | daima | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 發票代碼 | | haoma | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 發票號碼 | | money | decimal(10,2) | 0.00 | 金額 | | opendt | date | NULL | 開票日期 | | ptype | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 發票類型 | | status | tinyint(1) | 0 | 狀態 | | kainame | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 開票人 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | ## xinhu\_flow\_bill:流程單據 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | sericnum | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 單號 | | table | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應表 | | mid | int(11) | NULL | 主id | | modeid | smallint(6) | 0 | 模塊id | | modename | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模塊名稱 | | uname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 申請人姓名 | | uid | smallint(6) | NULL | 用戶id | | udeptname | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 申請人部門 | | optdt | datetime | NULL | 操作時間 | | optid | smallint(6) | 0 | 操作人Id | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | allcheckid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | @所有審核人 | | isdel | tinyint(4) | 0 | 是否刪除 | | nstatus | tinyint(1) | 0 | 當前狀態值 | | applydt | date | NULL | 申請日期 | | nstatustext | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 當前狀態 | | status | tinyint(1) | 0 | | | nowcourseid | int(11) | 0 | 當前步驟Id | | nowcheckid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 當前審核人id | | nowcheckname | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 當前審核人 | | checksm | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 最后審核說明 | | updt | datetime | NULL | 最后更新時間 | | createdt | datetime | NULL | 創建時間 | | tuiid | int(11) | 0 | 退回flow\_log.Id | | isturn | tinyint(1) | 0 | 是否已提交了 | | INDEX | sericnum (sericnum) USING BTREE | | | | INDEX | table (table | | | | mid) | USING BTREE | | | | INDEX | status (status) USING BTREE | | | | INDEX | modeid (modeid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_chao:抄送表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | modeid | int(11) | 0 | | | table | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應表 | | mid | int(11) | 0 | 對應記錄Id | | uid | int(11) | 0 | 人員Id | | csname | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 抄送給 | | csnameid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mid) | USING BTREE | | | | INDEX | modeid (modeid) USING BTREE | | | | INDEX | uid (uid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_checks:單據的審核人 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | table | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | 0 | | | mid | int(11) | NULL | | | modeid | smallint(6) | 0 | | | courseid | smallint(6) | 0 | | | checkid | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | checkname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optdt | datetime | NULL | | | status | tinyint(1) | 0 | 狀態 | | addlx | tinyint(1) | 0 | 類型1自定義,2撤回添加,3退回添加,4轉移添加 | | INDEX | table (table | | | | mid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_cname:自定義審核人組 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | num | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 編號 | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 審核組名 | | checkid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | checkname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 審核人 | | pid | int(11) | 0 | 上級ID | | receid | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 適用對象 | | sort | smallint(6) | 0 | 排序號 | | INDEX | num (num) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_course:流程步驟表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | mid | int(11) | 0 | 上級ID | | nid | int(11) | 0 | 下級步驟ID | | setid | smallint(6) | 0 | 模塊ID | | name | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 步驟名稱 | | num | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | checktype | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 審核人類型 | | checktypeid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | checktypename | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 審核人 | | sort | smallint(6) | 0 | | | whereid | smallint(6) | 0 | 流程模塊條件下的Id | | where | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 審核條件 | | explain | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | optdt | datetime | NULL | | | status | tinyint(1) | 1 | | | courseact | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 審核動作 | | checkshu | tinyint(2) | 1 | 至少幾人審核 ,0全部 | | checkfields | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 審核處理表單 | | pid | smallint(6) | 0 | 上級Id(棄用) | | optid | smallint(6) | 0 | 操作人id | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人姓名 | | receid | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 適用對象id | | recename | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 適用對象 | | iszf | tinyint(1) | 0 | 是否可以轉給他人辦理 | | isqm | tinyint(1) | 0 | 手寫簽名0不用,1都需要,2只需要通過,3只需要不通過 | | coursetype | tinyint(1) | 0 | 審批方式0順序,1前置審批,2后置審批 | | zshtime | int(11) | 0 | 超時時間(分鐘) | | zshstate | tinyint(2) | 1 | 自動審核類型 | | zbrangeame | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 轉辦人員可選范圍 | | zbrangeid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 轉辦人員可選范圍ID | | smlx | tinyint(1) | 0 | 處理說明類型 | | wjlx | tinyint(1) | 0 | 相關文件類型 | | isxgfj | tinyint(1) | 0 | 審批時是否可直接編輯附件 | | INDEX | setid (setid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_element:模塊元素 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | mid | smallint(6) | 0 | | | name | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | fields | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應字段 | | fieldstype | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | sort | smallint(6) | 0 | | | dev | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 默認值 | | isbt | tinyint(1) | 0 | 是否必填 | | data | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 數據源 | | islu | tinyint(1) | 1 | 是否錄入元素 | | iszs | tinyint(1) | 1 | 是否列表展示 | | attr | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 屬性 | | iszb | tinyint(1) | 0 | | | isss | tinyint(1) | 0 | | | lattr | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 列屬性 | | width | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 列寬 | | lens | smallint(6) | 0 | 字段長度 | | savewhere | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 保存條件 | | islb | tinyint(1) | 1 | 是否列表列 | | ispx | tinyint(1) | 0 | 是否可排序 | | isalign | tinyint(1) | 0 | 0居中,1居左,2居右 | | issou | tinyint(1) | 0 | 是否可搜索 | | istj | tinyint(1) | 0 | 是否可統計 | | gongsi | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 計算公式 | | placeholder | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 提示內容 | | isonly | tinyint(1) | 0 | 是否唯一 | | isdr | tinyint(1) | 0 | 是否導入字段 | | INDEX | mid (mid) USING BTREE | | | | INDEX | fields (fields) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_extent:模塊權限 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | recename | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | receid | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | modeid | smallint(6) | 0 | 模塊 | | type | tinyint(1) | 0 | 0查看,1添加,2編輯,3刪除 | | wherestr | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 條件 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | \*status | tinyint(1) | 1 | | | whereid | smallint(6) | 0 | 條件Id | | fieldstr | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 相關字段 | | INDEX | modeid (modeid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_log:單據操作記錄 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | table | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mid | int(11) | NULL | | | status | tinyint(4) | 0 | 1通過 | | statusname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 狀態名稱 | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 進程名稱 | | courseid | int(11) | NULL | | | optdt | datetime | NULL | 操作時間 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | ip | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | web | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 瀏覽器 | | checkname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | checkid | smallint(6) | NULL | | | modeid | smallint(6) | NULL | @模塊Id | | color | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | valid | tinyint(1) | 1 | | | step | smallint(6) | 0 | 步驟號 | | qmimg | text CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 簽名的圖片base64 | | iszb | tinyint(1) | 0 | 是否轉辦記錄 | | INDEX | table (table | | | | mid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_menu:單據操作菜單 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 顯示名稱 | | num | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 編號 | | sort | tinyint(4) | 0 | | | statusname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | statuscolor | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | statusvalue | tinyint(1) | 1 | 狀態值 | | actname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 動作名稱 | | setid | smallint(6) | 0 | 對應模塊 | | wherestr | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 顯示條件 | | explain | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | status | tinyint(1) | 1 | | | islog | tinyint(1) | 1 | | | issm | tinyint(1) | 1 | | | type | tinyint(1) | 0 | 類型 | | changeaction | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 觸發的方法 | | fields | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | upgcont | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 更新內容 | | iszs | tinyint(1) | 0 | 是否在詳情頁面顯示 | | INDEX | setid (setid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_remind:單據提醒設置表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | startdt | datetime | NULL | 開始時間 | | enddt | datetime | NULL | 截止時間 | | uid | smallint(6) | NULL | 用戶Id | | optdt | datetime | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | modenum | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應模塊編號 | | table | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mid | int(11) | 0 | 主Id | | ratecont | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 頻率 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 提醒內容 | | rate | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 提醒頻率o僅一次,d天,w周,m月 | | rateval | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | status | tinyint(1) | 1 | | | receid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 提醒給 | | table | | | | | mid) | USING BTREE | | | | modenum | | | | | mid) | USING BTREE | | | | INDEX | table\_2 (table | | | | mid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_set:流程模塊 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模塊名稱 | | \*num | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 模塊編號 | | sort | smallint(6) | 0 | 排序 | | table | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應的表 | | where | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 相關條件 | | summary | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 摘要 | | summarx | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 應用摘要 | | type | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 分類 | | pctx | tinyint(1) | 0 | pc端提醒 | | mctx | tinyint(1) | 0 | app提醒 | | wxtx | tinyint(1) | 0 | 微信提醒 | | emtx | tinyint(1) | 0 | 是否郵件提醒 | | sericnum | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 編號規則 | | isflow | tinyint(1) | 1 | 是否有流程 | | receid | varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 針對對象 | | optdt | datetime | NULL | 操作時間 | | status | tinyint(1) | 1 | | | islu | tinyint(1) | 1 | 是否可錄入 | | tables | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 多行子表 | | names | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 多行子表名稱 | | statusstr | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 狀態值設置 | | isgbjl | tinyint(1) | 0 | 是否關閉操作記錄 | | isgbcy | tinyint(1) | 0 | 是否不顯示查閱記錄 | | isscl | tinyint(1) | 0 | 是否生成列表頁 | | isup | tinyint(1) | 1 | 更新時是否同步 | | ddtx | tinyint(1) | 0 | 是否釘釘提醒 | | isbxs | tinyint(1) | 0 | 錄入頁面是否不顯示流程圖 | | lbztxs | tinyint(1) | 0 | 列表頁狀態搜索顯示0默認,1必須顯示,2顯示 | | isflowlx | tinyint(1) | 0 | 從新提交時0默認，1從新走流程 | | iscs | tinyint(1) | 0 | 是否自定義抄送 | | zfeitime | int(11) | 0 | 超過分鐘自動作廢 | | ispl | tinyint(1) | 1 | 是否開啟評論 | | istxset | tinyint(1) | 1 | 是否開啟單據提醒設置 | | ishz | tinyint(1) | 0 | 回執確認0不開啟,1必須選擇,2可選 | | num) | ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_todo:單據通知設置表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名稱標題 | | num | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 編號 | | setid | smallint(6) | 0 | 對應模塊 | | explain | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | whereid | smallint(6) | 0 | 對應條件id | | status | tinyint(1) | 1 | 狀態 | | receid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 通知給 | | changefields | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 改變字段 | | changecourse | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應步做id | | boturn | tinyint(1) | 0 | 提交時 | | boedit | tinyint(1) | 0 | 編輯時 | | bochang | tinyint(1) | 0 | 字段改變時 | | bodel | tinyint(1) | 0 | 刪除時 | | bozuofei | tinyint(1) | 0 | 作廢時 | | botong | tinyint(1) | 0 | 步驟處理通過時 | | bobutong | tinyint(1) | 0 | 步驟處理不通過時 | | bofinish | tinyint(1) | 0 | 處理完成時 | | bozhui | tinyint(1) | 0 | 追加說明時 | | bozhuan | tinyint(1) | 0 | 流程轉辦時 | | toturn | tinyint(1) | 0 | 是否通知給提交人 | | tocourse | tinyint(1) | 0 | 是否通知給流程所有參與人 | | todofields | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 通知給主表上字段 | | summary | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 通知內容摘要 | | botask | tinyint(1) | 0 | 計劃任務 | | boping | tinyint(1) | 0 | 評論時 | | bohuiz | tinyint(1) | 0 | 回執時 | | tosuper | tinyint(1) | 0 | 直屬上級 | ## xinhu\_flow\_todos:單據通知給對應人員 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | modenum | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | 0 | 對應模塊編號 | | modename | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模塊名稱 | | table | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應主表 | | mid | int(11) | 0 | 主表Id | | uid | int(11) | 0 | 對應人員 | | adddt | datetime | NULL | 添加時間 | | readdt | datetime | NULL | 已讀時間 | | isread | tinyint(1) | 0 | 是否已讀 | | INDEX | table (table | | | | mid) | USING BTREE | | | | INDEX | modenum (modenum | | | | mid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_flow\_where:單據條件 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | smallint(6) | | | | setid | smallint(6) | 0 | 對應模塊 | | num | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 編號 | | pnum | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 編號分組 | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 條件名稱 | | wheresstr | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應表條件 | | whereustr | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 用戶條件 | | wheredstr | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應部門條件 | | sort | smallint(6) | NULL | | | explain | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | receid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 包含用戶 | | nreceid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | nrecename | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 不包含用戶 | | islb | tinyint(1) | 0 | 是否在生成列表頁面上顯示 | | status | tinyint(1) | 1 | 狀態 | | syrid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | syrname | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 此條件可適用對象 | | INDEX | setid (setid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_godepot:物品倉庫表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | depotname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 倉庫名稱 | | depotaddress | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 倉庫地址 | | cgname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 倉庫管理員 | | cgid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 倉庫管理員的ID | | depotexplain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | sort | smallint(6) | 0 | 排序號 | | depotnum | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 倉庫編號 | ## xinhu\_goodm:物品領用采購申請主表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | int(11) | NULL | | | optdt | datetime | NULL | 操作時間 | | optid | int(11) | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | | type | tinyint(1) | 0 | 0領用,1采購申請 | | money | decimal(10,2) | 0.00 | 費用 | | custid | smallint(6) | 0 | | | custname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 供應商名稱 | | discount | decimal(8,2) | 0.00 | 優惠價格 | | state | tinyint(1) | 0 | 0待出入庫,2部分出入庫,1已全部出入庫 | ## xinhu\_goodn:物品庫存詳細表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | mid | smallint(6) | 0 | 對應主表 | | aid | smallint(6) | 0 | 物品Id | | count | smallint(6) | 0 | 數量 | | couns | smallint(6) | 0 | 已出庫入庫數跟count相等時就全部了 | | sort | smallint(6) | 0 | | | unit | varchar(5) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 單位 | | price | decimal(10,2) | 0.00 | 單價 | | INDEX | mid (mid) USING BTREE | | | | INDEX | aid (aid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_goods:物品表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | typeid | smallint(6) | 0 | 對應分類 | | num | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 物品編號 | | name | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | guige | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 規格 | | xinghao | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 型號 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | price | decimal(10,2) | 0.00 | 單價 | | unit | varchar(5) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 單位 | | adddt | datetime | NULL | | | optdt | datetime | NULL | | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | stock | int(11) | 0 | 庫存 | | stockcs | int(11) | 0 | 初始庫存 | | INDEX | typeid (typeid) USING BTREE | | | | INDEX | name (name) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_goodss:物品庫存詳細表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | aid | smallint(6) | 0 | 物品Id | | count | smallint(6) | 0 | 數量 | | uid | smallint(6) | 0 | | | type | tinyint(1) | 0 | 0入庫,1出庫 | | kind | tinyint(2) | 0 | 出入庫類型 | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | applydt | date | NULL | 申請日期 | | optdt | datetime | NULL | | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | status | tinyint(1) | 1 | | | optid | int(11) | 0 | | | mid | smallint(6) | 0 | 對應主表 | | sort | smallint(6) | 0 | | | unit | varchar(5) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 單位 | | price | decimal(10,2) | 0.00 | 單價 | | depotid | smallint(6) | 1 | 存放倉庫ID | | INDEX | aiddepotid (aid | | | | depotid) | USING BTREE | | | | INDEX | applydt (applydt) USING BTREE | | | | INDEX | status (status) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_group:系統組 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | smallint(6) | | | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 組名 | | sort | tinyint(4) | 0 | | | ispir | tinyint(4) | 1 | 是否權限驗證 | | indate | datetime | NULL | | ## xinhu\_gwfj | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | sort | int(11) | 0 | 排序號 | | senddt | date | NULL | 發文日 | | notetype | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 通知書類型 | | officialdt | date | NULL | 官方絕限 | | caseid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 案件編號 | | uid | int(11) | 0 | | | optdt | datetime | NULL | 操作時間 | | optid | int(11) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | ## xinhu\_homeitems:桌面項目表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名稱 | | \*num | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 編號 | | receid | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | sort | smallint(6) | 0 | 排序號 | | status | tinyint(1) | 1 | 狀態 | | row | tinyint(1) | 0 | 所在位置 | | num) | ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_hrcheck:考核評分表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | applyname | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 申請人姓名 | | optdt | datetime | NULL | 操作時間 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | | uname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應人 | | month | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | {month} | 月份 | | content | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 考核內容 | | fenzp | decimal(6,1) | 0.0 | 自評分數 | | fensj | decimal(6,1) | 0.0 | 上級評分 | | fenrs | decimal(6,1) | 0.0 | 人事評分 | | fen | decimal(6,1) | 0.0 | 最后得分 | | title | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 考核名稱 | | khid | int(11) | 0 | 關聯考核項目hrkaohem.id | | createdt | datetime | NULL | 創建時間 | | startdt | date | NULL | 評分開始時間 | | enddt | date | NULL | 評分截止時間 | | pfren | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 評分人 | | pfrenid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | pfrenids | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 未評分人Id | | pfrens | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 未評分人 | ## xinhu\_hrcheckn | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | itemname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 評分項目 | | pfname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 評分名稱 | | mid | smallint(6) | 0 | 對應主表hrcheck.id | | sort | smallint(6) | 0 | 排序號 | | sid | int(11) | 0 | 對應hrchecks.id | | fenshu | smallint(6) | 0 | 評分分數 | | weight | decimal(6,1) | 0.0 | 權重 | | optid | int(11) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 評分人 | | optdt | datetime | NULL | 操作時間 | | defen | decimal(6,1) | 0.0 | 最后得分 | | pfid | int(11) | 0 | 關聯評分hrkaohen.Id | ## xinhu\_hrchecks | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | mid | smallint(6) | 0 | 對應主表hrkaohem.id | | sort | smallint(6) | 0 | 排序號 | | itemname | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 考評項目 | | weight | decimal(6,1) | 0.0 | 權重(%) | | fenshu | decimal(6,1) | 0.0 | 占用分數 | ## xinhu\_hrdemint:面試和人員需求表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | optdt | datetime | NULL | 操作時間 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | type | tinyint(1) | 0 | 0需求,1面試 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | | zhiwei | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 需求職位 | | xinzi | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 薪資 | | renshu | smallint(6) | 1 | 需求人數 | | content | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 職位要求/面試者簡歷 | | bumen | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 需求部門 | | name | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 姓名 | | msuser | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 面試人員 | | msuserid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 面試人員的ID | | mscont | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 面試記錄 | | state | tinyint(1) | 0 | 面試結果0待面試,1錄用,2不適合 | | msdt | datetime | NULL | 面試時間 | ## xinhu\_hrkaohem | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 考核名稱 | | startdt | date | NULL | 開始日期 | | enddt | date | NULL | 截止日期 | | receid | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應考核人 | | optid | int(11) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | optdt | datetime | NULL | 操作時間 | | hegfen | smallint(6) | 0 | 合格分數 | | maxfen | smallint(6) | 100 | 最高分數 | | pinlv | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | m | 考核頻率 | | sctime | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 生成時間 | | pfsj | smallint(6) | 3 | 評分時間(天) | | status | tinyint(1) | 1 | 是否啟用 | ## xinhu\_hrkaohen | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | mid | smallint(6) | 0 | 對應主表hrkaohem.id | | sort | smallint(6) | 0 | 排序號 | | pfname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 評分名稱 | | pftype | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 評分人類型 | | pfren | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 評分人 | | pfrenid | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | pfweight | decimal(6,1) | 0.0 | 評分權重 | ## xinhu\_hrkaohes | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | mid | smallint(6) | 0 | 對應主表hrkaohem.id | | sort | smallint(6) | 0 | 排序號 | | itemname | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 考評項目 | | weight | decimal(6,1) | 0.0 | 權重(%) | ## xinhu\_hrpositive:HR轉正 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | int(11) | NULL | | | applyname | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 申請人姓名 | | ranking | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 職位 | | entrydt | date | NULL | 入職日期 | | syenddt | date | NULL | 試用到期日 | | positivedt | date | NULL | 轉正日期 | | optdt | datetime | NULL | 操作時間 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 0 | @0|待審核,1|審核通過,2|審核不通過 | | isturn | tinyint(1) | 0 | @0|未提交,1|提交 | | isover | tinyint(1) | 0 | | | optid | int(11) | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | ## xinhu\_hrredund:離職申請 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | int(11) | NULL | | | applyname | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 申請人姓名 | | ranking | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 職位 | | entrydt | date | NULL | 入職日期 | | quitdt | date | NULL | 離職日期 | | redundtype | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 離職類型 | | redundreson | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 離職原因 | | optdt | datetime | NULL | 操作時間 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 0 | @0|待審核,1|審核通過,2|審核不通過 | | isturn | tinyint(1) | 0 | @0|未提交,1|提交 | | isover | tinyint(1) | 0 | | | optid | int(11) | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | ## xinhu\_hrsalarm | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模版名稱 | | receid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 適用對象 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optid | int(11) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optdt | datetime | NULL | | | atype | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模版類型 | | startdt | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 開始月份 | | enddt | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 截止月份 | | sort | smallint(6) | 0 | 排序號 | | status | tinyint(1) | 1 | 是否啟用 | ## xinhu\_hrsalars | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | mid | smallint(6) | 0 | 對應主表hrsalarm.id | | sort | smallint(6) | 0 | 排序號 | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名稱 | | fields | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應字段 | | gongsi | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 公式 | | type | tinyint(1) | 0 | 0字段,1增加,2減少 | | beizhu | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 備注 | | devzhi | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 默認值 | ## xinhu\_hrsalary:工資表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | xuid | smallint(6) | 0 | | | uname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應人 | | udeptname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應人員部門 | | ranking | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 職位 | | optdt | datetime | NULL | 操作時間 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | | month | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 月份 | | base | decimal(10,2) | 0.00 | 基本工資 | | money | decimal(10,2) | 0.00 | 實發 | | postjt | decimal(10,2) | 0.00 | 職務津貼 | | skilljt | decimal(10,2) | 0.00 | 技能津貼 | | travelbt | decimal(10,2) | 0.00 | 交通補貼 | | telbt | decimal(10,2) | 0.00 | 通信補貼 | | reward | decimal(10,2) | 0.00 | 獎勵 | | punish | decimal(10,2) | 0.00 | 處罰 | | socials | decimal(10,2) | 0.00 | 個人社保 | | taxes | decimal(10,2) | 0.00 | 個人所得稅 | | ispay | tinyint(1) | 0 | 是否發放 | | otherzj | decimal(10,2) | 0.00 | 其它增加 | | otherjs | decimal(10,2) | 0.00 | 其它減少 | | cidao | smallint(6) | 0 | 遲到(次) | | cidaos | decimal(10,2) | 0.00 | 遲到處罰 | | zaotui | smallint(6) | 0 | 早退(次) | | zaotuis | decimal(10,2) | 0.00 | 早退處罰 | | leave | smallint(6) | 0 | 請假(小時) | | leaves | decimal(10,2) | 0.00 | 請假減少 | | jiaban | smallint(6) | 0 | 加班(小時) | | jiabans | decimal(10,2) | 0.00 | 加班補貼 | | weidk | smallint(6) | 0 | 未打卡(次) | | weidks | decimal(10,2) | 0.00 | 未打卡減少 | | mones | decimal(10,2) | 0.00 | 應發工資 | | socialsunit | decimal(10,2) | 0.00 | 單位社保繳費 | | taxbase | decimal(10,2) | 0.00 | 個稅起征點 | | jxjs | decimal(10,2) | 0.00 | 績效基數 | | jxxs | decimal(10,2) | 0.00 | 績效系數 | | jxdf | decimal(10,2) | 0.00 | 績效打分 | | jtpost | decimal(10,2) | 0.00 | 績效收入 | | ysbtime | decimal(10,1) | 0.0 | 應上班天數 | | zsbtime | decimal(10,1) | 0.0 | 已上班天數 | | gonggeren | decimal(10,2) | 0.00 | 公積金個人 | | gongunit | decimal(10,2) | 0.00 | 公積金單位 | | foodbt | decimal(10,2) | 0.00 | 餐補貼 | | hotbt | decimal(10,2) | 0.00 | 高溫津貼 | | dnbt | decimal(10,2) | 0.00 | 電腦補貼 | | jiansr | decimal(10,2) | 0.00 | 計件收入 | | otherbt | decimal(10,2) | 0.00 | 其他補貼 | ## xinhu\_hrshebao | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名稱 | | recename | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 適用對象 | | receid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | status | tinyint(1) | 1 | 是否開啟 | | gongjishu | decimal(10,2) | 0.00 | 公積金基數 | | yljishu | decimal(10,2) | 0.00 | 養老保險基數 | | ylgeren | decimal(10,2) | 0.00 | 養老個人比例(%) | | ylunit | decimal(10,2) | 0.00 | 養老單位比例(%) | | syjishu | decimal(10,2) | 0.00 | 失業報銷基數 | | sygeren | decimal(10,2) | 0.00 | 失業個人比例(%) | | syunit | decimal(10,2) | 0.00 | 失業單位比例(%) | | gsjishu | decimal(10,2) | 0.00 | 工傷報銷基數 | | gsgeren | decimal(10,2) | 0.00 | 工傷個人比例(%) | | gsunit | decimal(10,2) | 0.00 | 工傷單位比例(%) | | syujishu | decimal(10,2) | 0.00 | 生育保險基數 | | syugeren | decimal(10,2) | 0.00 | 生育個人比例(%) | | syuunit | decimal(10,2) | 0.00 | 生育單位比例(%) | | yijishu | decimal(10,2) | 0.00 | 醫療報銷基數 | | yigeren | decimal(10,2) | 0.00 | 醫療個人比例(%) | | yiunit | decimal(10,2) | 0.00 | 醫療單位比例(%) | | dbgeren | decimal(10,2) | 0.00 | 大病個人 | | gjjgeren | decimal(10,2) | 0.00 | 公積金個人比例(%) | | gjjunit | decimal(10,2) | 0.00 | 公積金單位比例(%) | | shebaogeren | decimal(10,2) | 0.00 | 個人社保繳費 | | shebaounit | decimal(10,2) | 0.00 | 單位社保繳費 | | sctime | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 每月生成時間 | | optdt | datetime | NULL | | | gonggeren | decimal(10,2) | 0.00 | 公積金個人 | | gongunit | decimal(10,2) | 0.00 | 公積金單位 | | explian | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | startdt | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 開始月份 | | enddt | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 截止月份 | ## xinhu\_hrtransfer:職位調動 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | optdt | datetime | NULL | 操作時間 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | | tranuid | smallint(6) | 0 | | | tranname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 要調動人 | | trantype | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 調動類型 | | olddeptname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 原來部門 | | oldranking | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 原來職位 | | effectivedt | date | NULL | 生效日期 | | newdeptname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 調動后部門 | | newdeptid | smallint(6) | NULL | | | newranking | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 調動后職位 | | isover | tinyint(1) | 0 | 是否已完成 | ## xinhu\_hrtrsalary:調薪申請 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | applyname | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 申請人姓名 | | optdt | datetime | NULL | 操作時間 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | | effectivedt | date | NULL | 生效日期 | | floats | smallint(6) | 0 | 調薪幅度 | | ranking | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 職位 | ## xinhu\_im\_group:IM會話表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名稱 | | pid | smallint(6) | 0 | 對應上級 | | types | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 應用分類 | | type | tinyint(1) | 0 | 類型@0|群,1|討論組,2|應用 | | sort | smallint(6) | 0 | 排序號 | | createid | int(11) | NULL | | | createname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 創建人 | | createdt | datetime | NULL | 創建時間 | | face | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 頭像 | | num | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | receid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | url | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | valid | tinyint(1) | 1 | | | explain | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | iconfont | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應字體圖標 | | iconcolor | varchar(7) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 字體圖標顏色 | | yylx | tinyint(1) | 0 | 應用類型0全部,1pc,2手機 | | urlpc | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 應用上PC地址 | | urlm | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 應用上手機端地址 | | deptid | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應部門id | | INDEX | num (num) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_im\_groupuser:IM會話人員 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | \*gid | smallint(6) | 0 | | | \*uid | smallint(6) | 0 | | | \*istx | tinyint(1) | 1 | | ## xinhu\_im\_history:IM會話記錄歷史表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | type | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | receid | smallint(6) | 0 | | | uid | smallint(6) | NULL | | | sendid | smallint(6) | 0 | | | optdt | datetime | NULL | | | cont | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | stotal | smallint(6) | 0 | | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 推送時標題 | | receid | | | | | uid) | USING BTREE | | | | INDEX | optdt (optdt) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_im\_menu:IM下應用菜單 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | \*mid | smallint(6) | 0 | | | \*pid | smallint(6) | 0 | | | name | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名稱 | | \*sort | smallint(6) | 0 | | | type | tinyint(4) | 0 | 1url,0事件 | | url | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應地址 | | num | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | color | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 顏色 | | receid | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 可使用人員 | | INDEX | mid (mid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_im\_mess:IM聊天記錄表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | optdt | datetime | NULL | | | zt | tinyint(1) | 0 | 狀態 | | cont | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 內容 | | sendid | smallint(6) | NULL | | | receid | smallint(6) | 0 | 接收 | | receuid | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 接收用戶id | | type | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 信息類型 | | url | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 相關地址 | | \*fileid | int(11) | 0 | 對應文件Id | | msgid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | INDEX | optdt (optdt | | | | receid) | USING BTREE | | | | INDEX | msgid (msgid) USING BTREE | | | | INDEX | type (type | | | | receid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_im\_messzt:IM聊天消息狀態表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | mid | int(11) | NULL | 信息id | | uid | int(11) | NULL | 人員id | | gid | smallint(6) | 0 | | ## xinhu\_infor:通知公告 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optdt | datetime | NULL | | | typename | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | content | text CHARACTER SET utf8 COLLATE utf8\_general\_ci | | | | url | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | receid | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 接收人Id | | recename | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | enddt | datetime | NULL | 截止時間 | | startdt | datetime | NULL | 開始時間 | | zuozhe | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 發布者 | | indate | date | NULL | 日期 | | status | tinyint(1) | 1 | 狀態 | | fengmian | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 封面圖片 | | mintou | smallint(6) | 0 | 至少投票 | | maxtou | smallint(6) | 0 | 最多投投票0不限制 | | issms | tinyint(1) | 0 | 是否發短信 | | istop | tinyint(1) | 0 | 是否置頂 | ## xinhu\_infors:信息子表投票項 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | mid | smallint(6) | 0 | 對應主表infor.id | | sort | smallint(6) | 0 | 排序號 | | touitems | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 投票選項 | | touci | int(11) | 0 | 得到票數 | | INDEX | mid (mid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_inventor | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | invname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 發明人姓名 | | tel | smallint(6) | NULL | 電話號碼 | | certificate | smallint(6) | NULL | 證件號碼 | | remark | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 備注 | | email | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 郵箱 | | uid | int(11) | 0 | | | optdt | datetime | NULL | 操作時間 | | optid | int(11) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | | custid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所屬客戶 | | custname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所屬客戶 | ## xinhu\_knowledge:知識信息 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 標題 | | typeid | smallint(6) | 0 | 對應分類 | | sort | smallint(6) | 0 | 排序 | | content | text CHARACTER SET utf8 COLLATE utf8\_general\_ci | | | | optdt | datetime | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | adddt | datetime | NULL | | ## xinhu\_knowtiku:知識題庫 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 標題 | | typeid | smallint(6) | 0 | | | type | tinyint(1) | 0 | 0單選,1多選 | | ana | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 答案A | | anb | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 答案B | | anc | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 答案C | | and | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 答案D | | answer | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | sort | smallint(6) | 0 | | | adddt | datetime | NULL | | | optdt | datetime | NULL | | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | status | tinyint(1) | 1 | 狀態 | | content | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optid | smallint(6) | 0 | | | imgurl | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 相關圖片地址 | ## xinhu\_knowtraim:培訓表出題考試 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 標題 | | optid | int(11) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | optdt | datetime | NULL | | | dxshu | smallint(6) | 0 | 多選題目數量 | | dsshu | smallint(6) | 0 | 單選題目數量 | | reshu | smallint(6) | 0 | 培訓人數 | | startdt | datetime | NULL | 開始時間 | | enddt | datetime | NULL | 截止時間 | | kstime | smallint(6) | 0 | 考試時間(分鐘) | | ydshu | smallint(6) | 0 | 已答題人數 | | status | tinyint(1) | 1 | 狀態 | | receid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 發給誰培訓 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | state | tinyint(1) | 0 | 0還沒開始,1考試中,2已結束 | | zfenshu | int(11) | 0 | 總分 | | hgfen | int(11) | 0 | 合格分數 | | tikuid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | tikuname | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應題庫 | ## xinhu\_knowtrais:考試培訓子表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | mid | int(11) | 0 | | | uid | int(11) | 0 | | | kssdt | datetime | NULL | 考試時間 | | ksedt | datetime | NULL | 考試結束時間 | | fenshu | smallint(6) | 0 | 得分 | | kstime | int(11) | 0 | 考試時間(秒數) | | isks | tinyint(1) | 0 | 是否已考試 | | tkids | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 考試題目id | | dyids | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 我做題得到答案 | | dyjgs | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 答題結果0未答,1正確,2錯誤 | | uid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_kqanay:考勤分析 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | dt | date | NULL | 日期 | | uid | smallint(6) | NULL | 人員id | | ztname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 狀態名稱 | | time | datetime | NULL | | | state | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 狀態名稱 | | states | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 其他狀態,如請假 | | sort | smallint(6) | 0 | | | iswork | tinyint(4) | 1 | 是否工作日 | | emiao | int(11) | 0 | 秒數 | | optdt | datetime | NULL | | | remark | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | timesb | decimal(6,1) | 0.0 | 應上班時間(小時) | | timeys | decimal(6,1) | 0.0 | 已上班時間(小時) | | INDEX | uiddt (uid | | | | dt) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_kqdist:考勤分配表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | recename | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 適用對象 | | receid | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mid | smallint(6) | 0 | | | type | tinyint(1) | 0 | 0考勤時間,1休息,2定位的 | | startdt | date | NULL | | | enddt | date | NULL | | | status | tinyint(1) | 1 | 狀態 | | sort | int(11) | 0 | 排序號 | ## xinhu\_kqdisv:考勤排班 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | plx | tinyint(1) | 1 | 1組排班,2人員 | | receid | int(11) | 0 | 組id,人員Id | | dt | date | NULL | 日期 | | type | tinyint(1) | 0 | 0考勤時間,1休息,2工作日 | | mid | int(11) | 0 | 對應主ID | | INDEX | receid (plx | | | | receid | | | | | dt) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_kqdkjl:打卡記錄 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | \*uid | int(11) | 0 | | | dkdt | datetime | NULL | | | optdt | datetime | NULL | | | type | tinyint(1) | 0 | 0在線打卡,1考勤機,2手機定位,3手動添加,4異常添加,5數據導入,6接口導入 | | address | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 定位地址 | | lat | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 緯度 | | lng | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 經度 | | accuracy | smallint(6) | 0 | 精確范圍 | | ip | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mac | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | explain | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | imgpath | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 相關圖片 | | snid | int(11) | 0 | 考勤機設備id | | sntype | tinyint(4) | 0 | 考勤機打卡方式0密碼,1指紋,2刷卡 | | INDEX | uid (uid | | | | dkdt) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_kqdw:考勤定位規則 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | smallint(6) | | | | name | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名稱 | | location\_x | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | location\_y | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | address | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 位置名稱 | | precision | int(11) | 0 | 允許誤差米 | | scale | smallint(6) | 0 | | | wifiname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 打卡wifi名 | | iswgd | tinyint(1) | 0 | 是否為無固定地點 | | dwids | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 關聯對應ID,實現多點定位 | ## xinhu\_kqerr:打卡異常申請 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | uname | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 申請人 | | optdt | datetime | NULL | 操作時間 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | | errtype | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 異常類型 | | dt | date | NULL | 異常日期 | | ytime | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 應打卡時間 | ## xinhu\_kqinfo:請假條加班單 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | uname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | stime | datetime | NULL | | | etime | datetime | NULL | | | kind | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 類型 | | qjkind | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 請假類型 | | explain | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | status | tinyint(1) | 0 | 狀態 | | totals | decimal(6,1) | 0.0 | 時間 | | optdt | datetime | NULL | | | isturn | tinyint(1) | 0 | 是否提交 | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optid | smallint(6) | 0 | | | applydt | date | NULL | 申請日期 | | jiafee | decimal(6,2) | 0.00 | 加班費 | | jiatype | tinyint(1) | 0 | 加班方式0換調休,1給加班費 | | totday | decimal(8,2) | 0.00 | 請假天數 | | enddt | datetime | NULL | 截止使用時間 | | INDEX | uid (uid) USING BTREE | | | | INDEX | kind (kind) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_kqjcmd:考勤機命令發送表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | \*id | int(11) | | | | snid | int(11) | 0 | 設備ID | | cmd | text CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 發送命令內容 | | status | tinyint(1) | 0 | 運行狀態0待運行,1已運行,2請求中 | | qjtime | datetime | NULL | 請求時間 | | optdt | datetime | NULL | 操作時間 | | cjtime | datetime | NULL | 處理時間 | | atype | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 類型 | | others | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 推送主鍵id | | INDEX | snid (snid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_kqjsn:考勤機設備表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | \*num | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 設備號 | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 設備名稱 | | company | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 公司名 | | sort | int(11) | 0 | 排序號 | | optdt | datetime | NULL | | | status | tinyint(1) | 1 | 狀態 | | deptids | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 部門ID聚合 | | userids | text CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 人員ID聚合 | | lastdt | datetime | NULL | 最后請求時間 | | space | int(11) | 0 | sd卡剩余空間 | | memory | int(11) | 0 | 剩余內存 | | usershu | int(11) | 0 | 人員數 | | fingerprintshu | int(11) | 0 | 指紋數 | | headpicshu | int(11) | 0 | 頭像數量 | | clockinshu | int(11) | 0 | 打卡數 | | picshu | int(11) | 0 | 現場照片數 | | romver | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 系統版本 | | appver | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 應用版本 | | model | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 設備型號 | | pinpai | tinyint(4) | 0 | 品牌0群英,1中控 | | snip | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 分配的ip | | snport | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 分配端口號 | | num) | ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_kqjuser:考勤機上人員 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | snid | int(11) | 0 | 設備ID | | uid | int(11) | 0 | 用戶ID | | fingerprint1 | text CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 指紋1 | | fingerprint2 | text CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 指紋2 | | headpic | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 頭像 | | uid) | USING BTREE | | | | INDEX | snid (snid) USING BTREE | | | | INDEX | uid (uid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_kqout:外出出差 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | NULL | | | applyname | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 申請人姓名 | | outtime | datetime | NULL | 外出時間 | | intime | datetime | NULL | 回崗時間 | | address | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 外出地址 | | reason | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 外出事由 | | atype | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 外出類型@外出,出差 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | optdt | datetime | NULL | 操作時間 | | status | tinyint(1) | 0 | @0|待審核,1|審核通過,2|審核不通過 | | isturn | tinyint(1) | 0 | @0|未提交,1|提交 | | optid | int(11) | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | isxj | tinyint(1) | 0 | 是否銷假@0|否,1|是 | | sicksm | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 銷假說明 | ## xinhu\_kqsjgz:考勤時間規則 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | smallint(6) | | | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名稱 | | sort | smallint(6) | 0 | 排序號 | | pid | smallint(6) | 0 | 主 | | stime | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 開始時間 | | etime | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 結束時間 | | qtype | tinyint(1) | 0 | 取值類型@0|最小值,1|最大值 | | iskt | tinyint(1) | 0 | 是否跨天 | | iskq | tinyint(1) | 1 | 是否需要考勤 | | isxx | tinyint(1) | 0 | 是否休息斷 | ## xinhu\_kqxxsj:休息時間規則 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | dt | date | NULL | | | pid | smallint(6) | 0 | | | type | tinyint(1) | 0 | 0休息日,1工作日 | | uid | int(11) | 0 | 對應用戶/部門Id | | INDEX | pid (pid | | | | dt) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_lianxi | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | int(11) | 0 | | | optdt | datetime | NULL | 操作時間 | | optid | int(11) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | | custid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所屬客戶 | | custname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所屬客戶 | | lxname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 聯系人姓名 | | lianxitype | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 聯系人類型 | | email | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 郵件地址 | | tel | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 電話號碼 | | address | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 地址 | | remark | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 備注 | | qq | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | qq | ## xinhu\_location:外勤定位 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | user | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | uid | int(11) | 0 | | | agentid | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 應用Id | | optdt | datetime | NULL | | | location\_x | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 地理位置緯度 | | location\_y | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 地理位置經度 | | scale | smallint(6) | 0 | 地圖縮放大小 | | label | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 地理位置 | | msgid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | precision | smallint(6) | 0 | 地理位置精度 | | type | tinyint(4) | 0 | 0普通,1事件,2企業微信定位 | | explain | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | imgpath | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 相關圖片 | ## xinhu\_log:系統日志 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | type | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 類型 | | optid | int(11) | NULL | 操作人id | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | remark | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 備注 | | optdt | datetime | NULL | 添加時間 | | ip | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | IP地址 | | web | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 瀏覽器 | | device | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | level | tinyint(1) | 0 | 日志級別0普通,1提示,2錯誤 | | url | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | INDEX | level (level) USING BTREE | | | | INDEX | type (type) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_logintoken:系統登錄token | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | int(11) | 0 | 用戶ID | | name | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | token | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | adddt | datetime | NULL | | | moddt | datetime | NULL | | | cfrom | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | device | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | ip | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | web | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | online | tinyint(1) | 1 | | | INDEX | token (token) USING BTREE | | | | INDEX | uid (uid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_meet:會議 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | hyname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 會議室名稱 | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 主題 | | startdt | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 開始時間 | | enddt | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 結束時間 | | state | tinyint(1) | 0 | 會議狀態@0|正常,1|會議中,2|結束,3|取消 | | status | tinyint(1) | 0 | | | type | tinyint(1) | 0 | 類型@0|普通,1|固定,2|紀要 | | joinid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | joinname | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 參加人員 | | mid | int(11) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 發起人 | | rate | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | uid | int(11) | NULL | | | optdt | datetime | NULL | 操作時間 | | optid | int(11) | 0 | | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | cancelreason | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | jyid | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 會議紀要人id | | jyname | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 會議紀要人 | | content | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 會議紀要內容 | | issms | tinyint(1) | 0 | 是否短信通知 | ## xinhu\_menu:系統菜單 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | smallint(6) | | | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 菜單名 | | pid | smallint(6) | 0 | 上級id | | sort | smallint(6) | 0 | 排序 | | url | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | icons | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optdt | datetime | NULL | | | num | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 編號 | | ispir | tinyint(1) | 1 | 1驗證 | | status | tinyint(1) | 1 | 1啟用 | | color | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | ishs | tinyint(1) | 0 | 是否在首頁顯示 | | iszm | tinyint(1) | 0 | 是否為桌面版圖標 | | INDEX | pid (pid | | | | status) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_news | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optdt | datetime | NULL | | | typename | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | content | text CHARACTER SET utf8 COLLATE utf8\_general\_ci | | | | url | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | receid | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 接收人Id | | recename | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optid | int(11) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | enddt | date | NULL | 截止時間 | | startdt | date | NULL | 開始時間 | | zuozhe | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 發布者 | | indate | date | NULL | 日期 | | status | tinyint(1) | 1 | 狀態 | | fengmian | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 封面圖片 | | mintou | smallint(6) | 0 | 至少投票 | | maxtou | smallint(6) | 0 | 最多投投票0不限制 | | issms | tinyint(1) | 0 | 是否發短信 | | istop | tinyint(1) | 0 | 是否置頂 | ## xinhu\_official:公文 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | title | varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 標題 | | titles | varchar(255) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 副標題 | | class | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 類型 | | type | tinyint(1) | 0 | 0收文單,1發文單 | | grade | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 等級 | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optdt | datetime | NULL | | | status | tinyint(1) | 0 | 狀態 | | content | text CHARACTER SET utf8 COLLATE utf8\_general\_ci | | 內容 | | receid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 來源 | | recename | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 發給 | | applydt | date | NULL | 日期 | | num | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 編號 | | optid | smallint(6) | 0 | | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | isturn | tinyint(1) | 1 | 是否提交 | | filecontid | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 正文文件Id | | zinum | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 發文字號 | | unitname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 發給單位 | | unitsame | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 發文單位 | | miji | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 公文密級 | | laidt | date | NULL | 來文日期 | ## xinhu\_option:系統選項 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名稱 | | type | int(11) | 0 | 選項類型 | | pid | int(11) | NULL | | | num | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 編號 | | value | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應值 | | sort | smallint(6) | 0 | 排序號 | | values | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | valid | tinyint(1) | 1 | | | optdt | datetime | NULL | | | optid | smallint(6) | 0 | | | receid | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | explain | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | INDEX | num (num) USING BTREE | | | | INDEX | pid (pid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_project:項目表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | pid | smallint(6) | 0 | | | type | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 項目類型 | | num | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 編號 | | status | tinyint(1) | 0 | | | title | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 項目名稱 | | startdt | datetime | NULL | 開始時間 | | enddt | datetime | NULL | 預計結束時間 | | fuze | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 負責人 | | fuzeid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | runuser | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 執行人員 | | runuserid | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | progress | smallint(6) | 0 | 進度 | | viewuser | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 授權查看 | | viewuserid | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | content | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明備注 | | optid | smallint(6) | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | optdt | datetime | NULL | | | adddt | datetime | NULL | 添加時間 | | sort | smallint(6) | 0 | 排序 | ## xinhu\_reads:單據瀏覽記錄表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | table | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mid | int(11) | NULL | | | optid | smallint(6) | NULL | | | optdt | datetime | NULL | | | ip | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | web | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | adddt | datetime | NULL | 第一次瀏覽 | | stotal | smallint(6) | 1 | 流程次數 | | mid | | | | | optid) | USING BTREE | | | | INDEX | table (table | | | | mid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_receipt | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | modenum | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | 0 | 對應模塊編號 | | modename | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模塊名稱 | | table | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應主表 | | mid | int(11) | 0 | 主表Id | | uid | int(11) | 0 | 對應人員 | | receid | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 發送給 | | recename | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | receids | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 已確認人員Id | | optdt | datetime | NULL | 操作時間 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 內容 | | ushuz | int(11) | 0 | 總人數 | | ushuy | int(11) | 0 | 已確認 | | status | tinyint(1) | 1 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | INDEX | modenum (modenum | | | | mid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_repair:維修報修 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | optdt | datetime | NULL | 操作時間 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | | assetm | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 報修資產 | | reason | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 保修原因 | | reasons | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 實際原因 | | iswx | tinyint(1) | 0 | 需要外修 | | money | decimal(8,2) | 0.00 | 維修金額 | | wxname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 維修人員 | ## xinhu\_reward:獎懲 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | optdt | datetime | NULL | 操作時間 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | | object | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 獎懲對象 | | objectid | smallint(6) | 0 | | | type | tinyint(1) | 0 | 獎懲類型0獎勵,1處罰 | | result | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 獎懲結果 | | money | mediumint(6) | NULL | 獎懲金額 | | happendt | datetime | NULL | 發生時間 | | hapaddress | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 發生地點 | ## xinhu\_schedule:日程 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 標題 | | startdt | datetime | NULL | | | enddt | datetime | NULL | | | uid | smallint(6) | NULL | 用戶Id | | optdt | datetime | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | mid | int(11) | 0 | 主Id | | ratecont | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 頻率 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | rate | varchar(5) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | rateval | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | txsj | tinyint(1) | 0 | 是否提醒 | | status | tinyint(1) | 1 | | | receid | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 提醒給 | ## xinhu\_seal:印章表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 印章名稱 | | type | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 印章類型 | | bgname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 保管人 | | bgid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optdt | datetime | NULL | | | sort | smallint(6) | 0 | 排序號 | | sealimg | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應印章圖片 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | startdt | date | NULL | 簽發日期 | | enddt | date | NULL | 截止日期 | ## xinhu\_sealapl:印章申請使用表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | optdt | datetime | NULL | 操作時間 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | | sealid | smallint(6) | 0 | 印章id | | sealname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 印章名稱 | | isout | tinyint(1) | 0 | 是否外帶 | ## xinhu\_sjoin:后臺菜單權限 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | type | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 類型 | | mid | int(11) | NULL | | | sid | int(11) | NULL | | | indate | datetime | NULL | | | INDEX | type\_mid (type | | | | mid) | USING BTREE | | | | INDEX | type\_sid (type | | | | sid) | USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_subscribe:訂閱管理表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 訂閱標題 | | cont | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 訂閱時提醒內容 | | explain | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 訂閱說明 | | optid | int(11) | 0 | 操作人ID | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | optdt | datetime | NULL | | | status | tinyint(1) | 1 | 狀態 | | suburl | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 訂閱地址 | | suburlpost | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 訂閱地址post參數 | | lastdt | datetime | NULL | 最后運行時間 | | shateid | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | shatename | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 共享給 | ## xinhu\_subscribeinfo:訂閱內容信息 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | mid | int(11) | 0 | 對應定ID | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 標題 | | cont | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 內容 | | optdt | datetime | NULL | | | filepath | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 文件路徑 | | receid | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 發送給 | | recename | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應人 | ## xinhu\_task:計劃任務 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | smallint(6) | | | | name | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | fenlei | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 類型分類 | | url | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 運行地址 | | type | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | time | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | ratecont | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | status | tinyint(1) | 1 | 是否啟用 | | state | tinyint(1) | 0 | 最后狀態 | | lastdt | datetime | NULL | | | optdt | datetime | NULL | | | sort | smallint(6) | 0 | | | startdt | datetime | NULL | 開始時間 | | lastcont | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | explain | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | todoid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | todoname | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | ## xinhu\_todo:提醒消息表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | NULL | | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 類型 | | mess | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 信息內容 | | status | tinyint(1) | 0 | 狀態@0|未讀,1|已讀 | | optdt | datetime | NULL | 時間 | | table | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | mid | int(11) | NULL | | | readdt | datetime | NULL | 已讀時間 | | tododt | datetime | NULL | 提醒時間 | | modenum | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 對應模塊編號 | ## xinhu\_tovoid:單據申請作廢表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | optdt | datetime | NULL | 操作時間 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | | type | tinyint(1) | 0 | 0|作廢,1|刪除 | | modename | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模塊 | | modeid | smallint(6) | 0 | 對應模塊id | | tonum | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 作廢單號 | ## xinhu\_userinfo:用戶檔案表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | \*id | int(11) | 0 | | | name | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 姓名 | | num | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 編號 | | deptname | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | deptnames | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 多部門 | | ranking | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | rankings | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 多職位 | | dkip | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | dkmac | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | state | tinyint(1) | 0 | 狀態來自userstate | | sex | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 性別 | | tel | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 電話 | | mobile | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 手機號 | | workdate | date | NULL | 入職時間 | | email | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 郵箱 | | quitdt | date | NULL | 離職日期 | | iskq | tinyint(1) | 1 | 是否考勤 | | isdwdk | tinyint(1) | 0 | 是否定位打卡 | | birthday | date | NULL | 生日 | | xueli | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | birtype | tinyint(1) | 0 | 0陽歷1農歷 | | minzu | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 民族 | | hunyin | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 婚姻 | | jiguan | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 籍貫 | | nowdizhi | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 現住址 | | housedizhi | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 家庭地址 | | syenddt | date | NULL | 試用期到 | | positivedt | date | NULL | 轉正日期 | | bankname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 開戶行 | | banknum | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 工資卡帳號 | | zhaopian | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 照片 | | idnum | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 身份證號 | | spareman | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 備用聯系人 | | sparetel | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 備用聯系人電話 | | isdaily | tinyint(4) | 1 | 是否需要寫日報 | | companyid | int(11) | 0 | 所在公司單位Id | | finger | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 關聯考勤機人員編號 | | deptallname | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | ## xinhu\_userinfos:人員檔案子表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | mid | smallint(6) | 0 | 對應主表userinfo.id | | sort | smallint(6) | 0 | 排序號 | | startdt | date | NULL | 開始日期 | | enddt | date | NULL | 截止日期 | | rank | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 職位 | | unitname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 單位名稱 | | sslx | tinyint(1) | 0 | 0工作經歷,1教育經歷 | | INDEX | mid (mid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_userract:用戶合同表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | startdt | date | NULL | 開始日期 | | enddt | date | NULL | 截止日期 | | uid | smallint(6) | 0 | | | sort | smallint(6) | 0 | | | optdt | datetime | NULL | | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | httype | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 合同類型 | | state | tinyint(1) | 0 | 0|待執行,1|生效中,2|已終止,3|已過期 | | tqenddt | date | NULL | 提前終止 | | company | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 簽署公司 | | uname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 簽署人 | | companyid | smallint(6) | 0 | 簽署公司Id | ## xinhu\_vcard:個人通訊錄 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 姓名 | | mobile | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 手機號 | | optdt | datetime | NULL | | | uid | smallint(6) | 0 | | | tel | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 電話 | | email | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 郵箱 | | gname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 所在組名 | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | address | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 地址 | | sort | smallint(6) | 0 | 排序號 | | unitname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 單位名稱 | | sex | varchar(5) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 性別 | ## xinhu\_worc:文檔分區表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 文檔分區名稱 | | recename | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 可查看人員 | | receid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | sort | smallint(6) | 0 | 排序號 | | guanname | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 管理人員 | | guanid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optdt | datetime | NULL | 操作時間 | | uid | int(11) | 0 | 所屬用戶 | | optname | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 創建人 | | uptype | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 限制上傳類型 | ## xinhu\_word:文檔表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 名稱 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | fileid | int(11) | 0 | | | shateid | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | shate | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 分享給我的 | | optdt | datetime | NULL | | | typeid | smallint(6) | 0 | 對應類型 | | cid | int(11) | 0 | 文檔分區ID | | type | tinyint(1) | 0 | 0文件,1文件夾 | | sort | smallint(1) | 0 | 排序號 | | INDEX | cid (cid) USING BTREE | | | | INDEX | type (type) USING BTREE | | | | INDEX | typeid (typeid) USING BTREE ) ENGINE=MyISAM | CHARACTER | | ## xinhu\_wordeil | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | int(11) | 0 | | | optdt | datetime | NULL | 操作時間 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | | title | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 標題 | | filecontid | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 相關文件 | | qianname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 簽收人 | | qiannameid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 簽收人的ID | ## xinhu\_wordxie | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | name | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 文檔名稱 | | fenlei | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 分類 | | wtype | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 文檔類型 | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | optid | int(11) | 0 | | | optdt | datetime | NULL | | | xiename | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 協作人 | | xienameid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | recename | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 可查看人 | | receid | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | status | tinyint(1) | 1 | | | fileid | int(11) | 0 | | | explian | varchar(2000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | ## xinhu\_work:任務 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | num | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | title | varchar(200) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 標題 | | type | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 任務類型 | | grade | varchar(10) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 任務等級 | | distid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | dist | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 分配給 | | explain | varchar(4000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | optdt | datetime | NULL | 操作時間 | | optid | int(11) | NULL | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | startdt | datetime | NULL | 開始時間 | | enddt | datetime | NULL | 結束時間 | | state | tinyint(1) | 0 | 狀態 | | txdt | datetime | NULL | | | fen | smallint(6) | 0 | 分值 | | status | tinyint(1) | 1 | | | projectid | smallint(6) | 0 | 對應項目Id | | ddid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | | | ddname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 督導人員，不填默認上級 | | score | smallint(6) | 0 | 任務分數 | | mark | smallint(6) | 0 | 得分 | | uid | smallint(6) | 0 | | | applydt | date | NULL | 申請日期 | | isturn | tinyint(1) | 1 | 是否提交 | ## xinhu\_wotpl | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | template\_id | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模版消息id | | title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模板標題 | | primary\_industry | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模板所屬行業的一級行業 | | deputy\_industry | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模板所屬行業的二級行業 | | content | varchar(1000) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模板內容 | | example | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 模板示例 | | modename | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 使用名稱 | | modeparams | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 參數設置 | | status | tinyint(1) | 1 | 狀態 | ## xinhu\_wouser:微信用戶信息表 | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | int(11) | 0 | 綁定用戶Id | | openid | varchar(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci | 微信openid | | | nickname | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 微信昵稱 | | sex | tinyint(1) | 1 | 性別1男2女0未知 | | province | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 省份 | | city | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 城市 | | country | varchar(30) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 國家 | | headimgurl | varchar(300) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 微信頭像 | | adddt | datetime | NULL | 添加時間 | | optdt | datetime | NULL | 操作時間 | | ip | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | IP | ## xinhu\_zhuanli | 字段 | 類型 | 默認值 | 注釋 | | --- | --- | --- | --- | | id | int(11) | | | | uid | smallint(6) | 0 | | | optdt | datetime | NULL | 操作時間 | | optid | smallint(6) | 0 | | | optname | varchar(20) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 操作人 | | applydt | date | NULL | 申請日期 | | explain | varchar(500) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 說明 | | status | tinyint(1) | 1 | 狀態 | | isturn | tinyint(1) | 1 | 是否提交 | | kehu | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 客戶 | | service\_type | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 服務類型 | | ipr | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | IPR | | iprid | smallint(6) | NULL | IPR的ID | | case\_title | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 案件標題 | | zl\_type | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 專利類型 | | jishu | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 技術聯系人 | | jishuid | smallint(6) | NULL | 技術聯系人的ID | | hetype | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 合同類型 | | costplan | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 費用策略 | | caseid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 案號 | | sort | int(11) | 0 | 排序號 | | custid | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 客戶 | | custname | varchar(50) CHARACTER SET utf8 COLLATE utf8\_general\_ci | NULL | 客戶 |