elink-star
/
epdc-cloud-job-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.
51 Commits
5 Branches
2 Tags
203 KiB
 
 
 
 
Branch: master
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
epdc-cloud-job-yushan/db/epdc-job.html

302 lines
23 KiB
Raw Permalink Blame History

<!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-QRTZ_BLOB_TRIGGERS-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_BLOB_TRIGGERS-to">3.1 QRTZ_BLOB_TRIGGERS【】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_CALENDARS-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_CALENDARS-to">3.2 QRTZ_CALENDARS【】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_CRON_TRIGGERS-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_CRON_TRIGGERS-to">3.3 QRTZ_CRON_TRIGGERS【】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_FIRED_TRIGGERS-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_FIRED_TRIGGERS-to">3.4 QRTZ_FIRED_TRIGGERS【】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_JOB_DETAILS-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_JOB_DETAILS-to">3.5 QRTZ_JOB_DETAILS【】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_LOCKS-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_LOCKS-to">3.6 QRTZ_LOCKS【】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_PAUSED_TRIGGER_GRPS-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_PAUSED_TRIGGER_GRPS-to">3.7 QRTZ_PAUSED_TRIGGER_GRPS【】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_SCHEDULER_STATE-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_SCHEDULER_STATE-to">3.8 QRTZ_SCHEDULER_STATE【】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_SIMPLE_TRIGGERS-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_SIMPLE_TRIGGERS-to">3.9 QRTZ_SIMPLE_TRIGGERS【】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_SIMPROP_TRIGGERS-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_SIMPROP_TRIGGERS-to">3.10 QRTZ_SIMPROP_TRIGGERS【】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_TRIGGERS-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_TRIGGERS-to">3.11 QRTZ_TRIGGERS【】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-SCHEDULE_JOB-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-SCHEDULE_JOB-to">3.12 SCHEDULE_JOB【定时任务】</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-SCHEDULE_JOB_LOG-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-SCHEDULE_JOB_LOG-to">3.13 SCHEDULE_JOB_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>QRTZ_BLOB_TRIGGERS</td><td></td></tr>
<tr><td></td><td>QRTZ_CALENDARS</td><td></td></tr>
<tr><td></td><td>QRTZ_CRON_TRIGGERS</td><td></td></tr>
<tr><td></td><td>QRTZ_FIRED_TRIGGERS</td><td></td></tr>
<tr><td></td><td>QRTZ_JOB_DETAILS</td><td></td></tr>
<tr><td></td><td>QRTZ_LOCKS</td><td></td></tr>
<tr><td></td><td>QRTZ_PAUSED_TRIGGER_GRPS</td><td></td></tr>
<tr><td></td><td>QRTZ_SCHEDULER_STATE</td><td></td></tr>
<tr><td></td><td>QRTZ_SIMPLE_TRIGGERS</td><td></td></tr>
<tr><td></td><td>QRTZ_SIMPROP_TRIGGERS</td><td></td></tr>
<tr><td></td><td>QRTZ_TRIGGERS</td><td></td></tr>
<tr><td>定时任务</td><td>SCHEDULE_JOB</td><td></td></tr>
<tr><td>定时任务日志</td><td>SCHEDULE_JOB_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-QRTZ_BLOB_TRIGGERS-to" href="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_BLOB_TRIGGERS-from">1.3.1 QRTZ_BLOB_TRIGGERS【】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>SCHED_NAME</td><td></td><td>VARCHAR(120)</td><td>√</td><td></td></tr>
<tr><td>TRIGGER_NAME</td><td></td><td>VARCHAR(200)</td><td>√</td><td></td></tr>
<tr><td>TRIGGER_GROUP</td><td></td><td>VARCHAR(200)</td><td>√</td><td></td></tr>
<tr><td>BLOB_DATA</td><td></td><td>BLOB</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_CALENDARS-to" href="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_CALENDARS-from">1.3.2 QRTZ_CALENDARS【】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>SCHED_NAME</td><td></td><td>VARCHAR(120)</td><td>√</td><td></td></tr>
<tr><td>CALENDAR_NAME</td><td></td><td>VARCHAR(200)</td><td>√</td><td></td></tr>
<tr><td>CALENDAR</td><td></td><td>BLOB</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_CRON_TRIGGERS-to" href="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_CRON_TRIGGERS-from">1.3.3 QRTZ_CRON_TRIGGERS【】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>SCHED_NAME</td><td></td><td>VARCHAR(120)</td><td>√</td><td></td></tr>
<tr><td>TRIGGER_NAME</td><td></td><td>VARCHAR(200)</td><td>√</td><td></td></tr>
<tr><td>TRIGGER_GROUP</td><td></td><td>VARCHAR(200)</td><td>√</td><td></td></tr>
<tr><td>CRON_EXPRESSION</td><td></td><td>VARCHAR(120)</td><td></td><td></td></tr>
<tr><td>TIME_ZONE_ID</td><td></td><td>VARCHAR(80)</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_FIRED_TRIGGERS-to" href="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_FIRED_TRIGGERS-from">1.3.4 QRTZ_FIRED_TRIGGERS【】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>SCHED_NAME</td><td></td><td>VARCHAR(120)</td><td>√</td><td></td></tr>
<tr><td>ENTRY_ID</td><td></td><td>VARCHAR(95)</td><td>√</td><td></td></tr>
<tr><td>TRIGGER_NAME</td><td></td><td>VARCHAR(200)</td><td></td><td></td></tr>
<tr><td>TRIGGER_GROUP</td><td></td><td>VARCHAR(200)</td><td></td><td></td></tr>
<tr><td>INSTANCE_NAME</td><td></td><td>VARCHAR(200)</td><td></td><td></td></tr>
<tr><td>FIRED_TIME</td><td></td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>SCHED_TIME</td><td></td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>PRIORITY</td><td></td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>STATE</td><td></td><td>VARCHAR(16)</td><td></td><td></td></tr>
<tr><td>JOB_NAME</td><td></td><td>VARCHAR(200)</td><td></td><td></td></tr>
<tr><td>JOB_GROUP</td><td></td><td>VARCHAR(200)</td><td></td><td></td></tr>
<tr><td>IS_NONCONCURRENT</td><td></td><td>VARCHAR(1)</td><td></td><td></td></tr>
<tr><td>REQUESTS_RECOVERY</td><td></td><td>VARCHAR(1)</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_JOB_DETAILS-to" href="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_JOB_DETAILS-from">1.3.5 QRTZ_JOB_DETAILS【】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>SCHED_NAME</td><td></td><td>VARCHAR(120)</td><td>√</td><td></td></tr>
<tr><td>JOB_NAME</td><td></td><td>VARCHAR(200)</td><td>√</td><td></td></tr>
<tr><td>JOB_GROUP</td><td></td><td>VARCHAR(200)</td><td>√</td><td></td></tr>
<tr><td>DESCRIPTION</td><td></td><td>VARCHAR(250)</td><td></td><td></td></tr>
<tr><td>JOB_CLASS_NAME</td><td></td><td>VARCHAR(250)</td><td></td><td></td></tr>
<tr><td>IS_DURABLE</td><td></td><td>VARCHAR(1)</td><td></td><td></td></tr>
<tr><td>IS_NONCONCURRENT</td><td></td><td>VARCHAR(1)</td><td></td><td></td></tr>
<tr><td>IS_UPDATE_DATA</td><td></td><td>VARCHAR(1)</td><td></td><td></td></tr>
<tr><td>REQUESTS_RECOVERY</td><td></td><td>VARCHAR(1)</td><td></td><td></td></tr>
<tr><td>JOB_DATA</td><td></td><td>BLOB</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_LOCKS-to" href="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_LOCKS-from">1.3.6 QRTZ_LOCKS【】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>SCHED_NAME</td><td></td><td>VARCHAR(120)</td><td>√</td><td></td></tr>
<tr><td>LOCK_NAME</td><td></td><td>VARCHAR(40)</td><td>√</td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_PAUSED_TRIGGER_GRPS-to" href="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_PAUSED_TRIGGER_GRPS-from">1.3.7 QRTZ_PAUSED_TRIGGER_GRPS【】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>SCHED_NAME</td><td></td><td>VARCHAR(120)</td><td>√</td><td></td></tr>
<tr><td>TRIGGER_GROUP</td><td></td><td>VARCHAR(200)</td><td>√</td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_SCHEDULER_STATE-to" href="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_SCHEDULER_STATE-from">1.3.8 QRTZ_SCHEDULER_STATE【】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>SCHED_NAME</td><td></td><td>VARCHAR(120)</td><td>√</td><td></td></tr>
<tr><td>INSTANCE_NAME</td><td></td><td>VARCHAR(200)</td><td>√</td><td></td></tr>
<tr><td>LAST_CHECKIN_TIME</td><td></td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>CHECKIN_INTERVAL</td><td></td><td>BIGINT(19)</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_SIMPLE_TRIGGERS-to" href="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_SIMPLE_TRIGGERS-from">1.3.9 QRTZ_SIMPLE_TRIGGERS【】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>SCHED_NAME</td><td></td><td>VARCHAR(120)</td><td>√</td><td></td></tr>
<tr><td>TRIGGER_NAME</td><td></td><td>VARCHAR(200)</td><td>√</td><td></td></tr>
<tr><td>TRIGGER_GROUP</td><td></td><td>VARCHAR(200)</td><td>√</td><td></td></tr>
<tr><td>REPEAT_COUNT</td><td></td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>REPEAT_INTERVAL</td><td></td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>TIMES_TRIGGERED</td><td></td><td>BIGINT(19)</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_SIMPROP_TRIGGERS-to" href="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_SIMPROP_TRIGGERS-from">1.3.10 QRTZ_SIMPROP_TRIGGERS【】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>SCHED_NAME</td><td></td><td>VARCHAR(120)</td><td>√</td><td></td></tr>
<tr><td>TRIGGER_NAME</td><td></td><td>VARCHAR(200)</td><td>√</td><td></td></tr>
<tr><td>TRIGGER_GROUP</td><td></td><td>VARCHAR(200)</td><td>√</td><td></td></tr>
<tr><td>STR_PROP_1</td><td></td><td>VARCHAR(512)</td><td></td><td></td></tr>
<tr><td>STR_PROP_2</td><td></td><td>VARCHAR(512)</td><td></td><td></td></tr>
<tr><td>STR_PROP_3</td><td></td><td>VARCHAR(512)</td><td></td><td></td></tr>
<tr><td>INT_PROP_1</td><td></td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>INT_PROP_2</td><td></td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>LONG_PROP_1</td><td></td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>LONG_PROP_2</td><td></td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>DEC_PROP_1</td><td></td><td>DECIMAL(13,4)</td><td></td><td></td></tr>
<tr><td>DEC_PROP_2</td><td></td><td>DECIMAL(13,4)</td><td></td><td></td></tr>
<tr><td>BOOL_PROP_1</td><td></td><td>VARCHAR(1)</td><td></td><td></td></tr>
<tr><td>BOOL_PROP_2</td><td></td><td>VARCHAR(1)</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_TRIGGERS-to" href="module-DB_REVERSE_MYSQL-tableColumnList-QRTZ_TRIGGERS-from">1.3.11 QRTZ_TRIGGERS【】</a>
<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>SCHED_NAME</td><td></td><td>VARCHAR(120)</td><td>√</td><td></td></tr>
<tr><td>TRIGGER_NAME</td><td></td><td>VARCHAR(200)</td><td>√</td><td></td></tr>
<tr><td>TRIGGER_GROUP</td><td></td><td>VARCHAR(200)</td><td>√</td><td></td></tr>
<tr><td>JOB_NAME</td><td></td><td>VARCHAR(200)</td><td></td><td></td></tr>
<tr><td>JOB_GROUP</td><td></td><td>VARCHAR(200)</td><td></td><td></td></tr>
<tr><td>DESCRIPTION</td><td></td><td>VARCHAR(250)</td><td></td><td></td></tr>
<tr><td>NEXT_FIRE_TIME</td><td></td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>PREV_FIRE_TIME</td><td></td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>PRIORITY</td><td></td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>TRIGGER_STATE</td><td></td><td>VARCHAR(16)</td><td></td><td></td></tr>
<tr><td>TRIGGER_TYPE</td><td></td><td>VARCHAR(8)</td><td></td><td></td></tr>
<tr><td>START_TIME</td><td></td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>END_TIME</td><td></td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>CALENDAR_NAME</td><td></td><td>VARCHAR(200)</td><td></td><td></td></tr>
<tr><td>MISFIRE_INSTR</td><td></td><td>SMALLINT(5)</td><td></td><td></td></tr>
<tr><td>JOB_DATA</td><td></td><td>BLOB</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-SCHEDULE_JOB-to" href="module-DB_REVERSE_MYSQL-tableColumnList-SCHEDULE_JOB-from">1.3.12 SCHEDULE_JOB【定时任务】</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>BIGINT(19)</td><td>√</td><td></td></tr>
<tr><td>BEAN_NAME</td><td>spring bean名称</td><td>VARCHAR(200)</td><td></td><td></td></tr>
<tr><td>PARAMS</td><td>参数</td><td>VARCHAR(2000)</td><td></td><td></td></tr>
<tr><td>CRON_EXPRESSION</td><td>cron表达式</td><td>VARCHAR(100)</td><td></td><td></td></tr>
<tr><td>STATUS</td><td>任务状态 0：暂停 1：正常</td><td>TINYINT UNSIGNED(3)</td><td></td><td></td></tr>
<tr><td>REMARK</td><td>备注</td><td>VARCHAR(255)</td><td></td><td></td></tr>
<tr><td>CREATOR</td><td>创建者</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>CREATE_DATE</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>UPDATER</td><td>更新者</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>UPDATE_DATE</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
</table>
</li>
<li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-SCHEDULE_JOB_LOG-to" href="module-DB_REVERSE_MYSQL-tableColumnList-SCHEDULE_JOB_LOG-from">1.3.13 SCHEDULE_JOB_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>BIGINT(19)</td><td>√</td><td></td></tr>
<tr><td>JOB_ID</td><td>任务id</td><td>BIGINT(19)</td><td></td><td></td></tr>
<tr><td>BEAN_NAME</td><td>spring bean名称</td><td>VARCHAR(200)</td><td></td><td></td></tr>
<tr><td>PARAMS</td><td>参数</td><td>VARCHAR(2000)</td><td></td><td></td></tr>
<tr><td>STATUS</td><td>任务状态 0：失败 1：成功</td><td>TINYINT UNSIGNED(3)</td><td></td><td></td></tr>
<tr><td>ERROR</td><td>失败信息</td><td>VARCHAR(2000)</td><td></td><td></td></tr>
<tr><td>TIMES</td><td>耗时(单位：毫秒)</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>CREATE_DATE</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
</table>
</li>
</ul></li></ul><hr></li></ul></body>
</html>