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.
397 lines
33 KiB
397 lines
33 KiB
5 years ago
|
<!DOCTYPE html>
|
||
|
|
<html lang="en">
|
||
|
|
<head>
|
||
|
|
<meta charset="UTF-8">
|
||
|
|
<title>epdc-job</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_PARTY_AUTHENTICATION_FAILED-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_PARTY_AUTHENTICATION_FAILED-to">3.1 EPDC_PARTY_AUTHENTICATION_FAILED【党员认证失败表 党员认证失败表】</a></li>
|
||
|
|
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_PARTY_MEMBERS-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_PARTY_MEMBERS-to">3.2 EPDC_PARTY_MEMBERS【党员表】</a></li>
|
||
|
|
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_PARTY_TAG_RELATION-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_PARTY_TAG_RELATION-to">3.3 EPDC_PARTY_TAG_RELATION【党员标签关系表】</a></li>
|
||
|
|
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER-to">3.4 EPDC_USER【用户信息表】</a></li>
|
||
|
|
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER_AUTHENTICATE_HISTORY-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER_AUTHENTICATE_HISTORY-to">3.5 EPDC_USER_AUTHENTICATE_HISTORY【用户认证历史表】</a></li>
|
||
|
|
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER_BEHAVIOR-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER_BEHAVIOR-to">3.6 EPDC_USER_BEHAVIOR【用户行为表 用户行为表】</a></li>
|
||
|
|
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER_GRID_RELATION-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER_GRID_RELATION-to">3.7 EPDC_USER_GRID_RELATION【网格长与网格关系表】</a></li>
|
||
|
|
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER_MESSAGE-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER_MESSAGE-to">3.8 EPDC_USER_MESSAGE【用户消息表 用户消息表】</a></li>
|
||
|
|
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER_TAG-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER_TAG-to">3.9 EPDC_USER_TAG【用户标签表】</a></li>
|
||
|
|
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER_TAG_RELATION-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER_TAG_RELATION-to">3.10 EPDC_USER_TAG_RELATION【用户标签关系表】</a></li>
|
||
|
|
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER_WX_FORM_ID-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER_WX_FORM_ID-to">3.11 EPDC_USER_WX_FORM_ID【微信formId表】</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.12 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/HQHAIaAYKucaQKAtYCBN16PDSHgEaAoGscqYKAtQBBtx4PzSGgESDoGkeqIGAtQNCtx0NzCGgECLrGkSoIWAsQdOvx0BwCGgGCrnGkCgLWAgTdejw0h4BGgKBrHKmCgLUAQbceD80hoBEg6BpHqiBgLUDQrcdDcwhoBAi6xpE
|
||
|
|
</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_PARTY_AUTHENTICATION_FAILED</td><td></td></tr>
|
||
|
|
<tr><td>党员表</td><td>EPDC_PARTY_MEMBERS</td><td></td></tr>
|
||
|
|
<tr><td>党员标签关系表</td><td>EPDC_PARTY_TAG_RELATION</td><td></td></tr>
|
||
|
|
<tr><td>用户信息表</td><td>EPDC_USER</td><td></td></tr>
|
||
|
|
<tr><td>用户认证历史表</td><td>EPDC_USER_AUTHENTICATE_HISTORY</td><td></td></tr>
|
||
|
|
<tr><td>用户行为表 用户行为表</td><td>EPDC_USER_BEHAVIOR</td><td></td></tr>
|
||
|
|
<tr><td>网格长与网格关系表</td><td>EPDC_USER_GRID_RELATION</td><td></td></tr>
|
||
|
|
<tr><td>用户消息表 用户消息表</td><td>EPDC_USER_MESSAGE</td><td></td></tr>
|
||
|
|
<tr><td>用户标签表</td><td>EPDC_USER_TAG</td><td></td></tr>
|
||
|
|
<tr><td>用户标签关系表</td><td>EPDC_USER_TAG_RELATION</td><td></td></tr>
|
||
|
|
<tr><td>微信formId表</td><td>EPDC_USER_WX_FORM_ID</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_PARTY_AUTHENTICATION_FAILED-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_PARTY_AUTHENTICATION_FAILED-from">1.3.1 EPDC_PARTY_AUTHENTICATION_FAILED【党员认证失败表 党员认证失败表】</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>REAL_NAME</td><td>姓名</td><td>VARCHAR(20)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>MOBILE</td><td>手机号</td><td>VARCHAR(20)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>IDENTITY_NO</td><td>身份证号</td><td>VARCHAR(20)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>POST</td><td>职务 字典表dict_name</td><td>VARCHAR(128)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>POST_VALUE</td><td>职务ID 字典表dict_value</td><td>VARCHAR(32)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>CADRE_FLAG</td><td>干部下沉标识 0-否，1-是</td><td>VARCHAR(1)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>REGIST_FLAG</td><td>注册状态 0-否，1-是</td><td>VARCHAR(1)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>REGIST_TIME</td><td>注册时间</td><td>DATETIME</td><td></td><td></td></tr>
|
||
|
|
<tr><td>STREET_NAME</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_NAME</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_NAME</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>DEPT_ID</td><td>部门ID</td><td>BIGINT(19)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>STATE</td><td>状态 0-认证失败</td><td>INT(10)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>PROCESSING_OPINIONS</td><td>处理意见</td><td>VARCHAR(500)</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>
|
||
|
|
<tr><td>USER_ID</td><td>用户ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>ADDRESS</td><td>居民住址</td><td>VARCHAR(512)</td><td></td><td></td></tr>
|
||
|
|
</table>
|
||
|
|
</li>
|
||
|
|
|
||
|
|
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_PARTY_MEMBERS-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_PARTY_MEMBERS-from">1.3.2 EPDC_PARTY_MEMBERS【党员表】</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>REAL_NAME</td><td>姓名</td><td>VARCHAR(20)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>MOBILE</td><td>手机号</td><td>VARCHAR(20)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>IDENTITY_NO</td><td>身份证号</td><td>VARCHAR(20)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>POST</td><td>职务（字典表dict_name）</td><td>VARCHAR(128)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>POST_VALUE</td><td>职务ID（字典表dict_value）</td><td>VARCHAR(32)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>CADRE_FLAG</td><td>干部下沉标识(0-否，1-是)</td><td>VARCHAR(1)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>REGIST_FLAG</td><td>注册状态（0-否，1-是）</td><td>VARCHAR(1)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>REGIST_TIME</td><td>注册时间</td><td>DATETIME</td><td></td><td></td></tr>
|
||
|
|
<tr><td>STREET_NAME</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_NAME</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_NAME</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>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>ADDRESS</td><td>居民住址</td><td>VARCHAR(512)</td><td></td><td></td></tr>
|
||
|
|
</table>
|
||
|
|
</li>
|
||
|
|
|
||
|
|
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_PARTY_TAG_RELATION-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_PARTY_TAG_RELATION-from">1.3.3 EPDC_PARTY_TAG_RELATION【党员标签关系表】</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>PARTY_ID</td><td>党员ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>TAG_ID</td><td>标签ID</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>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_USER-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER-from">1.3.4 EPDC_USER【用户信息表】</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>NICKNAME</td><td>昵称</td><td>VARCHAR(50)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>MOBILE</td><td>手机号</td><td>VARCHAR(20)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>PASSWORD</td><td>密码</td><td>VARCHAR(30)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>REGISTER_TIME</td><td>注册时间</td><td>DATETIME</td><td></td><td></td></tr>
|
||
|
|
<tr><td>FACE_IMG</td><td>头像</td><td>VARCHAR(512)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>SEX</td><td>性别(女性-0，男性-1)</td><td>VARCHAR(10)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>BIRTHDAY</td><td>生日</td><td>DATE</td><td></td><td></td></tr>
|
||
|
|
<tr><td>EMAIL</td><td>邮箱</td><td>VARCHAR(128)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>TELEPHONE</td><td>电话</td><td>VARCHAR(20)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>ZIP_CODE</td><td>邮编</td><td>VARCHAR(10)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>PROFESSION</td><td>职业</td><td>VARCHAR(50)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>HOBBIES</td><td>爱好</td><td>VARCHAR(100)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>USER_SIGN</td><td>个性签名</td><td>VARCHAR(100)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>INVITATION_CODE</td><td>邀请码</td><td>VARCHAR(10)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>LAST_LOGIN_TIME</td><td>最近登录时间</td><td>DATETIME</td><td></td><td></td></tr>
|
||
|
|
<tr><td>LAST_LOGIN_IP</td><td>最近登录IP</td><td>VARCHAR(50)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>LAST_LONGITUDE</td><td>最近登录位置经度</td><td>VARCHAR(30)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>LAST_LATITUDE</td><td>最近登录位置维度</td><td>VARCHAR(30)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>REAL_NAME</td><td>真实姓名</td><td>VARCHAR(30)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>IDENTITY_NO</td><td>身份证号</td><td>VARCHAR(20)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>ROAD</td><td>所在道路（如山东路168号）</td><td>VARCHAR(64)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>VILLAGE_NAME</td><td>小区名称</td><td>VARCHAR(64)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>DWELLING_PLACE</td><td>住处（楼栋-单元-房间）</td><td>VARCHAR(128)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>ADDRESS</td><td>居民住址</td><td>VARCHAR(512)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>WX_OPEN_ID</td><td>微信OPENID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>WX_UNION_ID</td><td>微信unionId</td><td>VARCHAR(32)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>PARTY_FLAG</td><td>是否是党员(0-否，1-是)</td><td>VARCHAR(32)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>REGISTER_WAY</td><td>注册方式（wx：微信注册）</td><td>VARCHAR(10)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>REGISTER_SOURCE</td><td>用户来源(wp:公众号)</td><td>VARCHAR(10)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>MOBILE_PROVINCE</td><td>手机号所属省份</td><td>VARCHAR(50)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>MOBILE_CITY</td><td>手机号所属城市</td><td>VARCHAR(50)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>MOBILE_CARRIER</td><td>手机号所属运营商</td><td>VARCHAR(50)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>POINTS</td><td>用户积分</td><td>INT(10)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>INVITE_USER_ID</td><td>邀请人ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>STATE</td><td>状态(0-已注册，1-已完善信息待审核，2-信息审核不通过，3-信息审核通过)</td><td>VARCHAR(1)</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>DEL_FLAG</td><td>删除标记</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>LAST_NAME</td><td>姓</td><td>VARCHAR(32)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>FIRST_NAME</td><td>名</td><td>VARCHAR(32)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>REMARK</td><td>审核备注</td><td>VARCHAR(255)</td><td></td><td></td></tr>
|
||
|
|
</table>
|
||
|
|
</li>
|
||
|
|
|
||
|
|
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER_AUTHENTICATE_HISTORY-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER_AUTHENTICATE_HISTORY-from">1.3.5 EPDC_USER_AUTHENTICATE_HISTORY【用户认证历史表】</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>USER_ID</td><td>用户ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>MOBILE</td><td>手机号</td><td>VARCHAR(20)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>REAL_NAME</td><td>姓名</td><td>VARCHAR(20)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>ADDRESS</td><td>居民地址</td><td>VARCHAR(512)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>AUTHENTICATED_FLAG</td><td>是否认证通过 0未通过1通过</td><td>VARCHAR(1)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>REMARK</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>删除标记 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_USER_BEHAVIOR-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER_BEHAVIOR-from">1.3.6 EPDC_USER_BEHAVIOR【用户行为表 用户行为表】</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>BEHAVIOR</td><td>行为</td><td>VARCHAR(32)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>BEHAVIOR_TYPE</td><td>行为类型</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>REFERENCE_ID</td><td>引用ID</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>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_USER_GRID_RELATION-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER_GRID_RELATION-from">1.3.7 EPDC_USER_GRID_RELATION【网格长与网格关系表】</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>USER_ID</td><td>用户ID</td><td>VARCHAR(32)</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_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>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(64)</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>SWITCHED_TIME</td><td>最后切换此网格的时间</td><td>DATETIME</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>LEADER_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_USER_MESSAGE-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER_MESSAGE-from">1.3.8 EPDC_USER_MESSAGE【用户消息表 用户消息表】</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>MESS_TYPE</td><td>消息类型 审核通知、互动通知、项目通知</td><td>VARCHAR(32)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>MESS_DETAIL_TYPE</td><td>消息详细类型</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>REFERENCE_ID</td><td>引用ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>ASSIST_REFERENCE_ID</td><td>辅助引用ID</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>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_USER_TAG-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER_TAG-from">1.3.9 EPDC_USER_TAG【用户标签表】</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>TAG_NAME</td><td>标签名</td><td>VARCHAR(50)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>TAG_DESC</td><td>标签描述</td><td>VARCHAR(100)</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_USER_TAG_RELATION-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER_TAG_RELATION-from">1.3.10 EPDC_USER_TAG_RELATION【用户标签关系表】</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>USER_ID</td><td>用户ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>TAG_ID</td><td>标签ID</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>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_USER_WX_FORM_ID-to" href="module-DB_REVERSE_MYSQL-tableColumnList-EPDC_USER_WX_FORM_ID-from">1.3.11 EPDC_USER_WX_FORM_ID【微信formId表】</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>WX_OPEN_ID</td><td>微信openId</td><td>VARCHAR(32)</td><td></td><td></td></tr>
|
||
|
|
<tr><td>WX_FORM_ID</td><td>微信formId</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>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-UNDO_LOG-to" href="module-DB_REVERSE_MYSQL-tableColumnList-UNDO_LOG-from">1.3.12 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>
|