elink-star
/
epdc-cloud-heart-yushan
12
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity
榆山
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
44 Commits
3 Branches
3 Tags
286 KiB
 
 
Branch: master
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
epdc-cloud-heart-yushan/db/epdc-events.html

579 lines
49 KiB
Raw Permalink Blame History

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>epdc-admin</title>
<style>
.index {
font-weight: bold;
font-size: 25px;
}
.title {
font-weight: bold;
font-size: 25px;
}
li {
list-style: none;
padding: 5px;
}
.first-li {
font-weight: bold;
font-size: 20px;
}
.second-li {
font-weight: bold;
}
.third-li {
font-weight: normal;
}
.block {
display: block;
}
table {
width: 100%;
margin-top: 10px;
border-color: #E8E8E8;
}
.first-tr {
text-align: center;
}
tr:hover {
background: #ECF9FF;
}
td {
font-weight: normal;
padding: 5px;
white-space: nowrap;
}
a {
color: #000000;
background-color: transparent;
text-decoration: none;
outline: none;
cursor: pointer;
}
.module {
color: green;
}
.module-list {
color: #1890ff;
}
</style>
</head>
<body><center class="index">目录</center>
<hr><ul>
<li class="first-li"><a class="module" id="module-DB_REVERSE_MYSQL-from" href="#module-DB_REVERSE_MYSQL-to">1 逆向解析_MYSQL</a>
<ul><li class="second-li"><a class="module-list" id="module-DB_REVERSE_MYSQL-relation-from" href="#module-DB_REVERSE_MYSQL-relation-to">1 关联关系</a></li>
<li class="second-li"><a class="module-list" id="module-DB_REVERSE_MYSQL-tableList-from" href="#module-DB_REVERSE_MYSQL-tableList-to">2 表清单</a></li>
<li class="second-li"><a class="module-list" id="module-DB_REVERSE_MYSQL-tableColumnList-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-to">3 表列清单</a>
<ul><li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_DEPT_KPI_CONFIG-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_DEPT_KPI_CONFIG-to">3.1 EPDC_DEPT_KPI_CONFIG【计分规则配置】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_DEPT_RESPOND_LOG-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_DEPT_RESPOND_LOG-to">3.2 EPDC_DEPT_RESPOND_LOG【部门响应记录】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_DEPT_RESPOND_TIME_CONFIG-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_DEPT_RESPOND_TIME_CONFIG-to">3.3 EPDC_DEPT_RESPOND_TIME_CONFIG【绩效考核时间规则表】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_EVENTS-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_EVENTS-to">3.4 EPDC_EVENTS【事件表 事件表】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_EVENT_CATEGORY-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_EVENT_CATEGORY-to">3.5 EPDC_EVENT_CATEGORY【事件分类字典表 事件分类字典表】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_EVENT_COMMENT-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_EVENT_COMMENT-to">3.6 EPDC_EVENT_COMMENT【事件评论表 事件评论表】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_EVENT_COMMENT_USER_ATTITUDE-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_EVENT_COMMENT_USER_ATTITUDE-to">3.7 EPDC_EVENT_COMMENT_USER_ATTITUDE【事件评论点赞点踩表 事件评论点赞点踩表】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_EVENT_USER_ATTITUDE-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_EVENT_USER_ATTITUDE-to">3.8 EPDC_EVENT_USER_ATTITUDE【事件点赞点踩表 事件点赞点踩表】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_GRID_WORK_SCORE-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_GRID_WORK_SCORE-to">3.9 EPDC_GRID_WORK_SCORE【履行抓基层党建工作职责得分】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_IMG-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_IMG-to">3.10 EPDC_IMG【党建系统图片表 党建系统图片表】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_INTERFACE_LOG-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_INTERFACE_LOG-to">3.11 EPDC_INTERFACE_LOG【接口日志表 接口日志表】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ISSUE-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ISSUE-to">3.12 EPDC_ISSUE【议题表 议题表】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ISSUE_HANDLE-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ISSUE_HANDLE-to">3.13 EPDC_ISSUE_HANDLE【议题处理表 议题处理表】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ITEM-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ITEM-to">3.14 EPDC_ITEM【项目表 项目表】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ITEM_DEPT-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ITEM_DEPT-to">3.15 EPDC_ITEM_DEPT【项目部门关系表】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ITEM_EVALUATE_DEPT-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ITEM_EVALUATE_DEPT-to">3.16 EPDC_ITEM_EVALUATE_DEPT【 部门满意度评价表】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ITEM_HANDLE_PROCESS-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ITEM_HANDLE_PROCESS-to">3.17 EPDC_ITEM_HANDLE_PROCESS【项目处理流程表 项目处理流程表】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ITEM_INFORMATION-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ITEM_INFORMATION-to">3.18 EPDC_ITEM_INFORMATION【 】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-UNDO_LOG-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-UNDO_LOG-to">3.19 UNDO_LOG【】</a></li>
</ul></li></ul></li></ul>
<hr><ul>
<li class="first-li"><a class="module" id="module-DB_REVERSE_MYSQL-to" href="#module-DB_REVERSE_MYSQL-from">1 逆向解析_MYSQL</a><ul>
<li class="second-li"><a class="module-list" class="block" id="module-DB_REVERSE_MYSQL-relation-to" href="#module-DB_REVERSE_MYSQL-relation-from">1.1 关联关系</a>
<img style="width: 98%;margin-top: 10px" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAPoAAAD6CAYAAACI7Fo9AAANo0lEQVR4Xu3cz8tNaxjG8ceEFBNKmPiRpAyMmCADGRkJMZEUpZSJf8B/oJRSBkgpGZgwERlgQimkJCUTSn5MSJk43fv0vGftx7PWel7nkiu+b53BOe/a9773517XXs/68Z45379//574QQCBP1pgDkH/o+fLh0NgIkDQ2REQ+AsECPpfMGQ+IgIEXbAPXLt2bVJl165do9Xevn2bTp8+nQ4dOpTWrl37w/ZR68GDB+n48eNp2bJlo/Vig9b3r2334sWL9OzZs8HeW7YZajR/5tevX09tdvLkyapB04dmo1kJEPRZcdU3bg1aDuXHjx/TgQMH0ty5c6cKRiDu3LmTli5dmubNm5c2b97c2128Z65z48aNpi+aWp9Pnz5Nly9fTmvWrKn29Pnz53TmzJlJ/WPHjqUFCxZM9RRfAhHYoZ8NGzZUXxuv+fbtW7p06VK6ffv2T01i+/bt1b5/qtgf/CKCLhhua9Bbjubr169Py5cvT1euXEn79u37IVjRbg7fli1bJl8Gfe+ft4uVRqwe+rbLYa2FJl4Tv6+FvI8uh/fly5ejK5O87bp166a+2OI9z58/P/j6+/fvp+fPnxP0hn2YoDcgxSaxU+UjW+NLZjaLkORA5qPwhw8f0sWLF9PBgwcnS/TYse/evTuz0w4tl1t6ifeMI2n0PBb0/PnevXuXtm3blhYtWjTpPX8BzGaJnb/MNm3aVD0dKD9nLej5Cyq+nIZOhwh6+55I0NutBpfR8cuhnbI8mnePrrFjX7hwIe3evXvqvDy2WbJkydSRrjya59OB2vsPHdFbltx9H7gv+FEzeq4d/XMvjx8/Tnv37p35QimD3t2u7/3zyuPhw4cc0Rv3X4LeCDW02djSPe/MUSPOzbtH88WLF0/OUcula/f8tfu7uKD16NGjtHPnzplz/P+7dC8/W/f8v7yOUHNoPc+unat3g55XIPFlUNu2XM5zRG/feQl6u9VPH9FrQYij3saNGychj6Vy32ogvzZvEyG8evVqU9cnTpxIt27dalq6dwvOJujlZ+se7btX2/PpS9l4N+hx6pBPbeJofe/evZnVQYS6++/5dINz9KZdgQdm2piGtxo7ondf3T0K5aVnhPzcuXMpjmTlTxzZjhw5MlkS930h/O4jek0nX0foXuCLPuNiY/e2Yt/FuBzkfF0klvvllyFH9Pa9lyN6g1XLxa+xMnFEW7169dQFuLHXtP7eKeg5uO/fv586V4//HrfQYgXTPboPXYyrffGtWLFi5ko8QW/dQ3gEtl2qZ8vuUrpveRovrV1E+9k3b7mQFkfAHTt2VK+6x1F17N73WG+1C3KxVO/eSajVyF75CJ2DHrcUnzx5MlnVDN13z6+PlcKqVavSq1evuL02NiyedW8QGtgkjihxXhk/X79+nfyzdevW3ifeynPrw4cPT3bUlodFukvX8up2eUTP/94X9KG7A0P31PsoWi/Gla+PsMazAvHMQHkxsruK6vsC5Yjevv+ydG+3mtqyu5PlJ9MiWLXbZK1v0fpwyq8KevfuwPz581Msk4eezssrlb7PPHSEj89w8+bNtGfPnhR+tbsOUb/7JVI+0EPQW/cslu7tUp0ty6vS3SPq2NNvfW9Yvm7ogZnWoJdH7rGLhhGc69evT86BFy5cOLXsb4Eq7/t3g57r5af5cr3yHL12WtJ3356gt0zl3204ordbzZxnl09slQFqfbKr+9Z9NcpgxGt+RdDzUrl2e6zvD3DKsMYFuP37909WAvFTBj2eHzh79uzUc/VDV93ziiGuvOcLc1yMm8UO29mUoDe65SDUzhf7jpTx38u/ROuee+aLTm/evKk+Udb3vHdf0OOjxHWAbhjKMJa36MaeS295pDW+HGq3v/qW7vmCWrxu5cqVvQ8MjY2GI/qY0H+/J+gNVmPnzkNL4tjZT506lb58+ZI+ffo0dWspH/X6/my1fKKu7ym1vvcvL5KVXwDlFfAhirxt94uu9kVU3oqsfQHkVUn80crRo0cnD/W0XJCs9cdfrzXswCzd25DGtho79+17/WyuVs/mD0vG+s1h7AthS79DtxLH3r/7+7Gl+1Atjujt0hzR261+25b5Nl7L/9jitzXJG1sLEHTr8dAcAhoBgq5xpAoC1gIE3Xo8NIeARoCgaxypgoC1AEG3Hg/NIaARIOgaR6ogYC1A0K3HQ3MIaAQIusaRKghYCxB06/HQHAIaAYKucaQKAtYCBN16PDSHgEaAoGscqYKAtQBBtx4PzSGgESDoGkeqIGAtQNCtx0NzCGgECLrGkSoIWAsQdOvx0BwCGgGCrnGkCgLWAgTdejw0h4BGgKBrHKmCgLUAQbceD80hoBEg6BpHqiBgLUDQrcdDcwhoBAi6xpEqCFgLEHTr8dAcAhoBgq5xpAoC1gIE3Xo8NIeARoCgaxypgoC1AEG3Hg/NIaARIOgaR6ogYC1A0K3HQ3MIaAQIusaRKghYCxB06/HQHAIaAYKucaQKAtYCBN16PDSHgEaAoGscqYKAtQBBtx4PzSGgESDoGkeqIGAtQNCtx0NzCGgECLrGkSoIWAsQdOvx0BwCGgGCrnGkCgLWAgTdejw0h4BGgKBrHKmCgLUAQbceD80hoBEg6BpHqiBgLUDQrcdDcwhoBAi6xpEqCFgLEHTr8dAcAhoBgq5xpAoC1gIE3Xo8NIeARoCgaxypgoC1AEG3Hg/NIaARIOgaR6ogYC1A0K3HQ3MIaAQIusaRKghYCxB06/HQHAIaAYKucaQKAtYCBN16PDSHgEaAoGscqYKAtQBBtx4PzSGgESDoGkeqIGAtQNCtx0NzCGgECLrGkSoIWAsQdOvx0BwCGgGCrnGkCgLWAgTdejw0h4BGgKBrHKmCgLUAQbceD80hoBEg6BpHqiBgLUDQrcdDcwhoBAi6xpEqCFgLEHTr8dAcAhoBgq5xpAoC1gIE3Xo8NIeARoCgaxypgoC1AEG3Hg/NIaARIOgaR6ogYC1A0K3HQ3MIaAQIusaRKghYCxB06/HQHAIaAYKucaQKAtYCBN16PDSHgEaAoGscqYKAtQBBtx4PzSGgESDoGkeqIGAtQNCtx0NzCGgECLrGkSoIWAsQdOvx0BwCGgGCrnGkCgLWAgTdejw0h4BGgKBrHKmCgLUAQbceD80hoBEg6BpHqiBgLUDQrcdDcwhoBAi6xpEqCFgLEHTr8dAcAhoBgq5xpAoC1gIE3Xo8NIeARoCgaxypgoC1AEG3Hg/NIaARIOgaR6ogYC1A0K3HQ3MIaAQIusaRKghYCxB06/HQHAIaAYKucaQKAtYCBN16PDSHgEaAoGscqYKAtQBBtx4PzSGgESDoGkeqIGAtQNCtx0NzCGgECLrGkSoIWAsQdOvx0BwCGgGCrnGkCgLWAgTdejw0h4BGgKBrHKmCgLUAQbceD80hoBEg6BpHqiBgLUDQrcdDcwhoBAi6xpEqCFgLEHTr8dAcAhoBgq5xpAoC1gIE3Xo8NIeARoCgaxypgoC1AEG3Hg/NIaARIOgaR6ogYC1A0K3HQ3MIaAQIusaRKghYCxB06/HQHAIaAYKucaQKAtYCBN16PDSHgEaAoGscqYKAtQBBtx4PzSGgESDoGkeqIGAtQNCtx0NzCGgECLrGkSoIWAsQdOvx0BwCGgGCrnGkCgLWAgTdejw0h4BGgKBrHKmCgLUAQbceD80hoBEg6BpHqiBgLUDQrcdDcwhoBAi6xpEqCFgLEHTr8dAcAhoBgq5xpAoC1gIE3Xo8NIeARoCgaxypgoC1AEG3Hg/NIaARIOgaR6ogYC1A0K3HQ3MIaAQIusaRKghYCxB06/HQHAIaAYKucaQKAtYCBN16PDSHgEaAoGscqYKAtQBBtx4PzSGgESDoGkeqIGAtQNCtx0NzCGgECLrGkSoIWAsQdOvx0BwCGgGCrnGkCgLWAgTdejw0h4BGgKBrHKmCgLUAQbceD80hoBEg6BpHqiBgLUDQrcdDcwhoBAi6xpEqCFgLEHTr8dAcAhoBgq5xpAoC1gIE3Xo8NIeARoCgaxypgoC1AEG3Hg/NIaARIOgaR6ogYC1A0K3HQ3MIaAQIusaRKghYCxB06/HQHAIaAYKucaQKAtYCBN16PDSHgEaAoGscqYKAtQBBtx4PzSGgESDoGkeqIGAtQNCtx0NzCGgECLrGkSoIWAsQdOvx0BwCGgGCrnGkCgLWAgTdejw0h4BGgKBrHKmCgLUAQbceD80hoBEg6BpHqiBgLUDQrcdDcwhoBAi6xpEqCFgLEHTr8dAcAhoBgq5xpAoC1gIE3Xo8NIeARoCgaxypgoC1AEG3Hg/NIaARIOgaR6ogYC1A0K3HQ3MIaAQIusaRKghYCxB06/HQHAIaAYKucaQKAtYCBN16PDSHgEaAoGscqYKAtQBBtx4PzSGgESDoGkeqIGAtQNCtx0NzCGgECLrGkSoIWAsQdOvx0BwCGgGCrnGkCgLWAgTdejw0h4BGgKBrHKmCgLUAQbceD80hoBEg6BpHqiBgLUDQrcdDcwhoBAi6xpEqCFgLEHTr8dAcAhoBgq5xpAoC1gIE3Xo8NIeARoCgaxypgoC1AEG3Hg/NIaARIOgaR6ogYC1A0K3HQ3MIaAQIusaRKghYCxB06/HQHAIaAYKucaQKAtYCBN16PDSHgEaAoGscqYKAtcA/uzO8i4BooncAAAAASUVORK5CYII=" title="DB_REVERSE_MYSQL-关系图"/>
</li><hr>
<li><a class="module-list" id="module-DB_REVERSE_MYSQL-tableList-to" href="module-DB_REVERSE_MYSQL-tableList-from">1.2 表清单</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
<tr><td>计分规则配置</td><td>EPDC_DEPT_KPI_CONFIG</td><td></td></tr>
<tr><td>部门响应记录</td><td>EPDC_DEPT_RESPOND_LOG</td><td></td></tr>
<tr><td>绩效考核时间规则表</td><td>EPDC_DEPT_RESPOND_TIME_CONFIG</td><td></td></tr>
<tr><td>事件表 事件表</td><td>EPDC_EVENTS</td><td></td></tr>
<tr><td>事件分类字典表 事件分类字典表</td><td>EPDC_EVENT_CATEGORY</td><td></td></tr>
<tr><td>事件评论表 事件评论表</td><td>EPDC_EVENT_COMMENT</td><td></td></tr>
<tr><td>事件评论点赞点踩表 事件评论点赞点踩表</td><td>EPDC_EVENT_COMMENT_USER_ATTITUDE</td><td></td></tr>
<tr><td>事件点赞点踩表 事件点赞点踩表</td><td>EPDC_EVENT_USER_ATTITUDE</td><td></td></tr>
<tr><td>履行抓基层党建工作职责得分</td><td>EPDC_GRID_WORK_SCORE</td><td></td></tr>
<tr><td>党建系统图片表 党建系统图片表</td><td>EPDC_IMG</td><td></td></tr>
<tr><td>接口日志表 接口日志表</td><td>EPDC_INTERFACE_LOG</td><td></td></tr>
<tr><td>议题表 议题表</td><td>EPDC_ISSUE</td><td></td></tr>
<tr><td>议题处理表 议题处理表</td><td>EPDC_ISSUE_HANDLE</td><td></td></tr>
<tr><td>项目表 项目表</td><td>EPDC_ITEM</td><td></td></tr>
<tr><td>项目部门关系表</td><td>EPDC_ITEM_DEPT</td><td></td></tr>
<tr><td> 部门满意度评价表</td><td>EPDC_ITEM_EVALUATE_DEPT</td><td></td></tr>
<tr><td>项目处理流程表 项目处理流程表</td><td>EPDC_ITEM_HANDLE_PROCESS</td><td></td></tr>
<tr><td> </td><td>EPDC_ITEM_INFORMATION</td><td></td></tr>
<tr><td></td><td>UNDO_LOG</td><td></td></tr>
</table>
</li><hr>
<li><a class="module-list" id="module-DB_REVERSE_MYSQL-tableColumnList-to" href="module-DB_REVERSE_MYSQL-tableColumnList-from">1.3 表列清单</a>
<ul style="padding: 0"> <li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_DEPT_KPI_CONFIG-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_DEPT_KPI_CONFIG-from">1.3.1 EPDC_DEPT_KPI_CONFIG【计分规则配置】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>ID</td><td>VARCHAR(32)</td><td>√</td><td></td></tr>
<tr><td>KPI_ITEM_CODE</td><td>绩效指标编码</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>KPI_ITEM_VALUE</td><td>绩效指标值</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>KPI_ITEM_DESC</td><td>绩效指标描述</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>DEL_FLAG</td><td>删除标识 0：未删除，1：删除</td><td>VARCHAR(2)</td><td></td><td></td></tr>
<tr><td>REVISION</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>CREATED_BY</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>CREATED_TIME</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>UPDATED_BY</td><td>更新人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>UPDATED_TIME</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_DEPT_RESPOND_LOG-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_DEPT_RESPOND_LOG-from">1.3.2 EPDC_DEPT_RESPOND_LOG【部门响应记录】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>ID</td><td>VARCHAR(32)</td><td>√</td><td></td></tr>
<tr><td>REFERENCE_ID</td><td>引用ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>REFERENCE_TYPE</td><td>引用类型 issue或item或event</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>RESPOND_DEPT_ID</td><td>响应部门的id（被呼叫的部门即审核部门）</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>RESPOND_TIME</td><td>响应时间即审核时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>RESPOND_TYPE</td><td>响应类型，参考枚举类DeptRespondTypeEnum</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>DEL_FLAG</td><td>删除标识 0：未删除，1：删除</td><td>VARCHAR(2)</td><td></td><td></td></tr>
<tr><td>REVISION</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>CREATED_BY</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>CREATED_TIME</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>UPDATED_BY</td><td>更新人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>UPDATED_TIME</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>RESPOND_FLAG</td><td>是否被响应 0 否 1是</td><td>VARCHAR(1)</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_DEPT_RESPOND_TIME_CONFIG-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_DEPT_RESPOND_TIME_CONFIG-from">1.3.3 EPDC_DEPT_RESPOND_TIME_CONFIG【绩效考核时间规则表】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>ID</td><td>VARCHAR(32)</td><td>√</td><td></td></tr>
<tr><td>CATEGORY_ID</td><td>议题或项目类别ID(不可重复)</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>CATEGORY_NAME</td><td>类别名称</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>GRID_VALID_RESP_LIMIT_HOUR</td><td>网格长在多少小时内响应算是有效响应</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>GRID_VALID_CLOSE_LIMIT_HOUR</td><td>网格长在多少小时内关闭算是有效关闭</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>COMM_VALID_RESP_LIMIT_HOUR</td><td>社区在多少小时内响应算是有效响应</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>STREET_VALID_RESP_LIMIT_HOUR</td><td>街道在多少小时内响应算是有效响应</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>DISTRICT_VALID_RESP_LIMIT_HOUR</td><td>区直在多少小时内响应算是有效响应</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>INVALID_RESP_LIMIT_HOUR</td><td>超过多少小时响应算是无效响应。此值应大于各部门的有效响应值。若响应发生在有效响应与无效响应之间，为超时响应。</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>VALID_RESP_COEFFICIENT</td><td>有效响应系数</td><td>DECIMAL(5,1)</td><td></td><td></td></tr>
<tr><td>OVERTIME_RESP_COEFFICIENT</td><td>超时响应系数</td><td>DECIMAL(5,1)</td><td></td><td></td></tr>
<tr><td>INVALID_RESP_COEFFICIENT</td><td>无效响应系数</td><td>DECIMAL(5,1)</td><td></td><td></td></tr>
<tr><td>DEL_FLAG</td><td>删除标识 0：未删除，1：删除</td><td>VARCHAR(2)</td><td></td><td></td></tr>
<tr><td>REVISION</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>CREATED_BY</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>CREATED_TIME</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>UPDATED_BY</td><td>更新人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>UPDATED_TIME</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_EVENTS-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_EVENTS-from">1.3.4 EPDC_EVENTS【事件表 事件表】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>ID</td><td>VARCHAR(32)</td><td>√</td><td></td></tr>
<tr><td>USER_ID</td><td>用户ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>NICK_NAME</td><td>用户昵称</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>USER_FACE</td><td>用户头像</td><td>VARCHAR(512)</td><td></td><td></td></tr>
<tr><td>IS_PARTY_MEMBER</td><td>党员标识 0：否，1：是</td><td>VARCHAR(1)</td><td></td><td></td></tr>
<tr><td>MOBILE</td><td>手机号</td><td>VARCHAR(20)</td><td></td><td></td></tr>
<tr><td>EVENT_CONTENT</td><td>议题内容</td><td>VARCHAR(2000)</td><td></td><td></td></tr>
<tr><td>AREA</td><td>区</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>AREA_ID</td><td>区ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>STREET</td><td>街道</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>STREET_ID</td><td>街道ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>COMMUNITY</td><td>社区</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>COMMUNITY_ID</td><td>社区ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>GRID</td><td>网格</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>GRID_ID</td><td>网格ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>ISSUE_ADDRESS</td><td>议题位置地址</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>ISSUE_CATEGORY_ID</td><td>议题分类ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>ISSUE_LATITUDE</td><td>议题位置纬度</td><td>DECIMAL(32,10)</td><td></td><td></td></tr>
<tr><td>ISSUE_LONGITUDE</td><td>议题位置经度</td><td>DECIMAL(32,10)</td><td></td><td></td></tr>
<tr><td>EVENT_STATE</td><td>事件状态 0-待审核，2-驳回，4-审核通过</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>ADVICE</td><td>意见</td><td>VARCHAR(500)</td><td></td><td></td></tr>
<tr><td>APPROVE_NUM</td><td>点赞次数</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>OPPOSE_NUM</td><td>踩次数</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>COMMENT_NUM</td><td>评论数</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>BROWSE_NUM</td><td>浏览数</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>DEL_FLAG</td><td>删除标识 0：未删除，1：已删除</td><td>VARCHAR(1)</td><td></td><td></td></tr>
<tr><td>REVISION</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>CREATED_BY</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>CREATED_TIME</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>UPDATED_BY</td><td>更新人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>UPDATED_TIME</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>SENSITIVE_FLAG</td><td>0 未进行校验；1 微信校验通过；2 微信校验不通过；3 管理员校验通过；4 管理员校验不通过</td><td>VARCHAR(1)</td><td></td><td></td></tr>
<tr><td>GROUP_ID</td><td>社群ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>GROUP_NAME</td><td>社群名称</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>TOPIC_ID</td><td>话题ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>FRIENDLY_COMMUNITY_ID</td><td></td><td>VARCHAR(32)</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_EVENT_CATEGORY-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_EVENT_CATEGORY-from">1.3.5 EPDC_EVENT_CATEGORY【事件分类字典表 事件分类字典表】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>ID</td><td>VARCHAR(32)</td><td>√</td><td></td></tr>
<tr><td>CATEGORY_NAME</td><td>分类名称</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>CATEGORY_CODE</td><td>类别编码 0-类别，1-敏感词</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>DESCRIPTION</td><td>描述</td><td>VARCHAR(1024)</td><td></td><td></td></tr>
<tr><td>SORT</td><td>排序</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>DEL_FLAG</td><td>删除标识 0：未删除，1：已删除</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>REVISION</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>CREATED_BY</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>CREATED_TIME</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>UPDATED_BY</td><td>更新人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>UPDATED_TIME</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_EVENT_COMMENT-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_EVENT_COMMENT-from">1.3.6 EPDC_EVENT_COMMENT【事件评论表 事件评论表】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>ID</td><td>VARCHAR(32)</td><td>√</td><td></td></tr>
<tr><td>EVENT_ID</td><td>事件ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>USER_ID</td><td>评论人ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>USER_NAME</td><td>评论人昵称</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>USER_FACE</td><td>评论人头像</td><td>VARCHAR(512)</td><td></td><td></td></tr>
<tr><td>CONTENT</td><td>评论内容</td><td>VARCHAR(1024)</td><td></td><td></td></tr>
<tr><td>COMMENT_TYPE</td><td>评论类型 0：评论，1：回复，2：回复的回复</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>COMMENT_ID</td><td>回复的评论ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>REPLY_COUNT</td><td>被回复数</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>REPLY_USER_ID</td><td>被回复人ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>REPLY_USER_NAME</td><td>被回复人名称</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>REPLY_USER_FACE</td><td>被回复人头像</td><td>VARCHAR(512)</td><td></td><td></td></tr>
<tr><td>LIKE_COUNT</td><td>点赞数</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>UN_LIKE_COUNT</td><td>点踩数</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>SHIELD_FLAG</td><td>屏蔽标识 0：未屏蔽，1：已屏蔽</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>DEL_FLAG</td><td>删除标识 0：未删除，1：已删除</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>REVISION</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>CREATED_BY</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>CREATED_TIME</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>UPDATED_BY</td><td>更新人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>UPDATED_TIME</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>SENSITIVE_FLAG</td><td>0 未进行校验；1 微信校验通过；2 微信校验不通过；3 管理员校验通过；4 管理员校验不通过</td><td>VARCHAR(1)</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_EVENT_COMMENT_USER_ATTITUDE-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_EVENT_COMMENT_USER_ATTITUDE-from">1.3.7 EPDC_EVENT_COMMENT_USER_ATTITUDE【事件评论点赞点踩表 事件评论点赞点踩表】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>ID</td><td>VARCHAR(32)</td><td>√</td><td></td></tr>
<tr><td>EVENT_COMMENT_ID</td><td>事件评论ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>USER_ID</td><td>用户ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>ATTITUDE_FLAG</td><td>用户点赞点踩标识 0：点赞，1：点踩</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>DEL_FLAG</td><td>删除标识 0：未删除，1：删除</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>REVISION</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>CREATED_BY</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>CREATED_TIME</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>UPDATED_BY</td><td>更新人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>UPDATED_TIME</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_EVENT_USER_ATTITUDE-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_EVENT_USER_ATTITUDE-from">1.3.8 EPDC_EVENT_USER_ATTITUDE【事件点赞点踩表 事件点赞点踩表】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>ID</td><td>VARCHAR(32)</td><td>√</td><td></td></tr>
<tr><td>EVENT_ID</td><td>事件ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>USER_ID</td><td>用户ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>ATTITUDE_FLAG</td><td>用户点赞点踩标识 0：点赞，1：踩</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>DEL_FLAG</td><td>删除标识 0：未删除，1：删除</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>REVISION</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>CREATED_BY</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>CREATED_TIME</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>UPDATED_BY</td><td>更新人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>UPDATED_TIME</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_GRID_WORK_SCORE-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_GRID_WORK_SCORE-from">1.3.9 EPDC_GRID_WORK_SCORE【履行抓基层党建工作职责得分】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>ID</td><td>VARCHAR(32)</td><td>√</td><td></td></tr>
<tr><td>USER_ID</td><td>用户ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>NICK_NAME</td><td>用户昵称</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>USER_FACE</td><td>用户头像</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>IS_PARTY_MEMBER</td><td>党员标识 0：否，1：是</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>DISTRICT</td><td>区</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>DISTRICT_ID</td><td>区ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>STREET</td><td>街道</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>STREET_ID</td><td>街道ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>COMMUNITY</td><td>社区</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>COMMUNITY_ID</td><td>社区ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>GRID</td><td>网格</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>GRID_ID</td><td>网格ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>SCORING_TIME</td><td>打分时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>SCORE</td><td>分值</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>DEL_FLAG</td><td>删除标识 0：未删除，1：已删除</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>REVISION</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>CREATED_BY</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>CREATED_TIME</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>UPDATED_BY</td><td>更新人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>UPDATED_TIME</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_IMG-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_IMG-from">1.3.10 EPDC_IMG【党建系统图片表 党建系统图片表】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>ID</td><td>VARCHAR(32)</td><td>√</td><td></td></tr>
<tr><td>REFERENCE_ID</td><td>引用ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>IMG_URL</td><td>图片地址</td><td>VARCHAR(512)</td><td></td><td></td></tr>
<tr><td>IMG_TYPE</td><td>图片类型</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>DEL_FLAG</td><td>删除标识 0：未删除，1：删除</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>REVISION</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>CREATED_BY</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>CREATED_TIME</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>UPDATED_BY</td><td>更新人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>UPDATED_TIME</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_INTERFACE_LOG-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_INTERFACE_LOG-from">1.3.11 EPDC_INTERFACE_LOG【接口日志表 接口日志表】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>主键</td><td>VARCHAR(32)</td><td>√</td><td></td></tr>
<tr><td>REFERENCE_ID</td><td>引用ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>BUSINESS_TYPE</td><td>业务类型</td><td>VARCHAR(100)</td><td></td><td></td></tr>
<tr><td>INTERFACE_NAME</td><td>调用接口名称</td><td>VARCHAR(200)</td><td></td><td></td></tr>
<tr><td>SUCCESS_FLAG</td><td>调用是否成功 0-调用失败，1-调用成功</td><td>VARCHAR(1)</td><td></td><td></td></tr>
<tr><td>CALL_MSG_BODY</td><td>调用消息体</td><td>VARCHAR(2000)</td><td></td><td></td></tr>
<tr><td>RETURN_MSG_BODY</td><td>调用返回消息体</td><td>TEXT</td><td></td><td></td></tr>
<tr><td>REVISION</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>CREATED_BY</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>CREATED_TIME</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>UPDATED_BY</td><td>更新人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>UPDATED_TIME</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>DEL_FLAG</td><td>删除标记</td><td>VARCHAR(1)</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ISSUE-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ISSUE-from">1.3.12 EPDC_ISSUE【议题表 议题表】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>ID</td><td>VARCHAR(32)</td><td>√</td><td></td></tr>
<tr><td>EVENT_ID</td><td>事件ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>USER_ID</td><td>用户ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>NICK_NAME</td><td>用户昵称</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>USER_FACE</td><td>用户头像</td><td>VARCHAR(512)</td><td></td><td></td></tr>
<tr><td>IS_PARTY_MEMBER</td><td>党员标识 0：否，1：是</td><td>VARCHAR(1)</td><td></td><td></td></tr>
<tr><td>MOBILE</td><td>手机号</td><td>VARCHAR(20)</td><td></td><td></td></tr>
<tr><td>ISSUE_CONTENT</td><td>议题内容</td><td>VARCHAR(2000)</td><td></td><td></td></tr>
<tr><td>DISTRIBUTE_TIME</td><td>发布时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>AREA</td><td>区</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>AREA_ID</td><td>区ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>STREET</td><td>街道</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>STREET_ID</td><td>街道ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>COMMUNITY</td><td>社区</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>COMMUNITY_ID</td><td>社区ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>GRID</td><td>网格</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>GRID_ID</td><td>网格ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>ISSUE_ADDRESS</td><td>议题位置地址</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>ISSUE_CATEGORY_ID</td><td>议题分类ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>ISSUE_LATITUDE</td><td>议题位置纬度</td><td>DECIMAL(32,10)</td><td></td><td></td></tr>
<tr><td>ISSUE_LONGITUDE</td><td>议题位置经度</td><td>DECIMAL(32,10)</td><td></td><td></td></tr>
<tr><td>ISSUE_STATE</td><td>议题状态 0-审核通过，2-已关闭，4-已转项目</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>DEL_FLAG</td><td>删除标识 0：未删除，1：已删除</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>REVISION</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>CREATED_BY</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>CREATED_TIME</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>UPDATED_BY</td><td>更新人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>UPDATED_TIME</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>GROUP_ID</td><td>社群ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>GROUP_NAME</td><td>社群名称</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>TOPIC_ID</td><td>话题ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>ISSUE_CODE</td><td>议题编号</td><td>VARCHAR(64)</td><td></td><td></td></tr>
<tr><td>FRIENDLY_COMMUNITY_ID</td><td></td><td>VARCHAR(32)</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ISSUE_HANDLE-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ISSUE_HANDLE-from">1.3.13 EPDC_ISSUE_HANDLE【议题处理表 议题处理表】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>主键</td><td>VARCHAR(32)</td><td>√</td><td></td></tr>
<tr><td>ISSUE_ID</td><td>议题ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>STATE</td><td>状态 0-审核通过，1-反馈，2-关闭</td><td>INT(10)</td><td>√</td><td></td></tr>
<tr><td>ADVICE</td><td>意见</td><td>VARCHAR(500)</td><td></td><td></td></tr>
<tr><td>HANDLER_DEPT_ID</td><td>操作人部门ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>HANDLER_DEPT</td><td>操作人部门</td><td>VARCHAR(255)</td><td></td><td></td></tr>
<tr><td>REVISION</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>CREATED_BY</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>CREATED_TIME</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>UPDATED_BY</td><td>更新人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>UPDATED_TIME</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>DEL_FLAG</td><td>删除标记</td><td>VARCHAR(1)</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ITEM-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ITEM-from">1.3.14 EPDC_ITEM【项目表 项目表】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>ID</td><td>VARCHAR(32)</td><td>√</td><td></td></tr>
<tr><td>EVENT_ID</td><td>事件ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>ISSUE_ID</td><td>议题ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>USER_ID</td><td>用户ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>NICK_NAME</td><td>用户昵称</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>USER_FACE</td><td>用户头像</td><td>VARCHAR(512)</td><td></td><td></td></tr>
<tr><td>IS_PARTY_MEMBER</td><td>党员标识 0：否，1：是</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>MOBILE</td><td>手机号</td><td>VARCHAR(20)</td><td></td><td></td></tr>
<tr><td>ITEM_CONTENT</td><td>项目内容</td><td>VARCHAR(2000)</td><td></td><td></td></tr>
<tr><td>DISTRIBUTE_TIME</td><td>发布时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>AREA</td><td>区</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>AREA_ID</td><td>区ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>STREET</td><td>街道</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>STREET_ID</td><td>街道ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>COMMUNITY</td><td>社区</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>COMMUNITY_ID</td><td>社区ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>GRID</td><td>网格</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>GRID_ID</td><td>网格ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>ISSUE_ADDRESS</td><td>议题位置地址</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>ISSUE_CATEGORY_ID</td><td>议题分类ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>ISSUE_LATITUDE</td><td>议题位置纬度</td><td>DECIMAL(32,10)</td><td></td><td></td></tr>
<tr><td>ISSUE_LONGITUDE</td><td>议题位置经度</td><td>DECIMAL(32,10)</td><td></td><td></td></tr>
<tr><td>EVALUATION_SCORE</td><td>满意度评价得分(0-不满意，1-基本满意，2-非常满意)</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>EVALUATION_CONTENT</td><td>满意度评价内容</td><td>VARCHAR(100)</td><td></td><td></td></tr>
<tr><td>EVALUATION_TIME</td><td>满意度评价时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>ITEM_STATE</td><td>项目状态 0-处理中，5-已关闭，10-已结案</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>DEL_FLAG</td><td>删除标识 0：未删除，1：已删除</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>REVISION</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>CREATED_BY</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>CREATED_TIME</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>UPDATED_BY</td><td>更新人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>UPDATED_TIME</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>LAST_HANDLE_TIME</td><td>最近一次处理时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>GROUP_ID</td><td>社群ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>GROUP_NAME</td><td>社群名称</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>TOPIC_ID</td><td>话题ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>ITEM_CODE</td><td>项目编号</td><td>VARCHAR(64)</td><td></td><td></td></tr>
<tr><td>FRIENDLY_COMMUNITY_ID</td><td></td><td>VARCHAR(32)</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ITEM_DEPT-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ITEM_DEPT-from">1.3.15 EPDC_ITEM_DEPT【项目部门关系表】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>主键</td><td>VARCHAR(32)</td><td>√</td><td></td></tr>
<tr><td>ITEM_ID</td><td>项目ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>DEPT_ID</td><td>部门ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>DEPT_NAME</td><td>部门名称</td><td>VARCHAR(255)</td><td></td><td></td></tr>
<tr><td>CREATED_DEPT_ID</td><td>操作人部门ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>REVISION</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>CREATED_BY</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>CREATED_TIME</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>UPDATED_BY</td><td>更新人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>UPDATED_TIME</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>DEL_FLAG</td><td>删除标记</td><td>VARCHAR(1)</td><td></td><td></td></tr>
<tr><td>ITEM_HANDLE_ID</td><td>项目处理表ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ITEM_EVALUATE_DEPT-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ITEM_EVALUATE_DEPT-from">1.3.16 EPDC_ITEM_EVALUATE_DEPT【 部门满意度评价表】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>主键</td><td>VARCHAR(32)</td><td>√</td><td></td></tr>
<tr><td>ITEM_ID</td><td>项目ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>DEPT_ID</td><td>被评价部门ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>DEPT_NAME</td><td>被评价部门名称</td><td>VARCHAR(256)</td><td></td><td></td></tr>
<tr><td>EVALUATION_LEVEL</td><td>评价结果：0-不满意，1-基本满意，2-非常满意</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>CREATED_DEPT_ID</td><td>操作人部门ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>REVISION</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>CREATED_BY</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>CREATED_TIME</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>UPDATED_BY</td><td>更新人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>UPDATED_TIME</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>DEL_FLAG</td><td>删除标记</td><td>VARCHAR(1)</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ITEM_HANDLE_PROCESS-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ITEM_HANDLE_PROCESS-from">1.3.17 EPDC_ITEM_HANDLE_PROCESS【项目处理流程表 项目处理流程表】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>主键</td><td>VARCHAR(32)</td><td>√</td><td></td></tr>
<tr><td>ITEM_ID</td><td>项目ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>STATE</td><td>0-处理中，5-已关闭，10-已结案</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>HANDLE_ADVICE</td><td>处理意见</td><td>VARCHAR(500)</td><td></td><td></td></tr>
<tr><td>OUT_HANDLE_ADVICE</td><td>处理意见（外部）</td><td>VARCHAR(500)</td><td></td><td></td></tr>
<tr><td>HANDLER_DEPT_ID</td><td>操作人部门ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>HANDLER_DEPT</td><td>操作人部门</td><td>VARCHAR(255)</td><td></td><td></td></tr>
<tr><td>REVISION</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>CREATED_BY</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>CREATED_TIME</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>UPDATED_BY</td><td>更新人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>UPDATED_TIME</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>DEL_FLAG</td><td>删除标记</td><td>VARCHAR(1)</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ITEM_INFORMATION-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_ITEM_INFORMATION-from">1.3.18 EPDC_ITEM_INFORMATION【 】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>主键</td><td>VARCHAR(32)</td><td>√</td><td></td></tr>
<tr><td>DEPT_ID</td><td>通知部门ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>TYPE</td><td>消息类型 0-项目</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>BUSINESS_TYPE</td><td>消息所属业务类型 0 -回应，1 -吹哨，5 -关闭，10- 结案</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>ASSOCIATED_BUSINESS_ID</td><td>消息关联业务ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>ASSOCIATED_BUSINESS_CONTENT</td><td>消息关联业务内容</td><td>VARCHAR(2000)</td><td></td><td></td></tr>
<tr><td>HANDLE_DEPT_ID</td><td>处理部门ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>HANDLE_DEPT</td><td>处理部门</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>HANDLE_ADVICE</td><td>处理意见</td><td>VARCHAR(500)</td><td></td><td></td></tr>
<tr><td>WHISTLE_DEPT</td><td>被吹哨部门（多个以逗号分隔）</td><td>VARCHAR(1024)</td><td></td><td></td></tr>
<tr><td>READ_FLAG</td><td>是否已读 0-否，1-是</td><td>VARCHAR(1)</td><td></td><td></td></tr>
<tr><td>REVISION</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>CREATED_BY</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>CREATED_TIME</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>UPDATED_BY</td><td>更新人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>UPDATED_TIME</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>DEL_FLAG</td><td>删除标记 0-否，1-是</td><td>VARCHAR(1)</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-UNDO_LOG-to" href="module-DB_REVERSE_MYSQL-tableColumnList-UNDO_LOG-from">1.3.19 UNDO_LOG【】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td></td><td>BIGINT(19)</td><td>√</td><td></td></tr>
<tr><td>BRANCH_ID</td><td></td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>XID</td><td></td><td>VARCHAR(100)</td><td></td><td></td></tr>
<tr><td>CONTEXT</td><td></td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>ROLLBACK_INFO</td><td></td><td>LONGBLOB</td><td></td><td></td></tr>
<tr><td>LOG_STATUS</td><td></td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>LOG_CREATED</td><td></td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>LOG_MODIFIED</td><td></td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>EXT</td><td></td><td>VARCHAR(100)</td><td></td><td></td></tr>
</table>
</li>
</ul></li></ul><hr></li></ul></body>
</html>