0 Star 0 Fork 0

kylecust / PublicCMS-lib

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
克隆/下载
db.html 84.17 KB
一键复制 编辑 原始数据 按行查看 历史
sanluan 提交于 2016-05-13 17:19 . add documents
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879288028812882288328842885288628872888288928902891289228932894289528962897289828992900290129022903290429052906290729082909291029112912291329142915291629172918291929202921292229232924292529262927292829292930293129322933293429352936293729382939294029412942294329442945294629472948294929502951295229532954295529562957295829592960296129622963296429652966296729682969297029712972297329742975297629772978297929802981298229832984298529862987298829892990299129922993299429952996299729982999300030013002300330043005300630073008300930103011301230133014301530163017301830193020302130223023302430253026302730283029303030313032303330343035303630373038303930403041304230433044304530463047304830493050305130523053305430553056305730583059306030613062306330643065306630673068306930703071307230733074
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="utf-8">
<title>Public CMS数据字典</title>
<style>
h2 {font-size:2em;font-weight:normal;text-shadow:0 1px 0 #fff;padding:10px 0 10px 3px;color:#777;}
th {font-weight:bold;color:#000000;background:#f3f3f3;background: -webkit-gradient(linear, left top, left bottom, from(#ffffff), to(#cccccc));background: -webkit-linear-gradient(top, #ffffff, #cccccc);background: -moz-linear-gradient(top, #ffffff, #cccccc);background: -ms-linear-gradient(top, #ffffff, #cccccc);background: -o-linear-gradient(top, #ffffff, #cccccc);}
a img {border:0;}
hr {color:#000000;background-color:#000000;border:0;height:1px;}
table caption,table th,table td {padding:0.3em;margin:0.1em;vertical-align:top;text-shadow:0 1px 0 #FFFFFF;}
table{border-collapse:collapse;}
th{border-right:1px solid #fff; text-align:left;}
table tr.odd th,.odd {background: #fff;}
table tr.even th,.even {background: #DFDFDF;}
table tr.odd th,table tr.odd,table tr.even th,table tr.even {text-align:left;}
td.marked,table tr.marked td,table tr.marked th,table tr.marked {background:#b6c6d7;color:#000000;}
.odd:hover,.even:hover,.hover,.structure_actions_dropdown {background:#b6c6d7; /* 3.4 */color:#000000;}
table tr.odd:hover th,table tr.even:hover th,table tr.hover th {background:#b6c6d7; /* 3.4 */color:#000000;}
</style>
</head>
<body>
<div>
<h2>cms_category</h2>
表注释: 分类 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">site_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">name</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>名称</td>
</tr>
<tr class="even">
<td nowrap="nowrap">parent_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>父分类ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">type_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>分类类型</td>
</tr>
<tr class="even">
<td nowrap="nowrap">child_ids</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">text</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>所有子分类ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">tag_type_ids</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(100)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>标签分类</td>
</tr>
<tr class="even">
<td nowrap="nowrap">english_name</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>英文名</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">template_path</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>模板路径</td>
</tr>
<tr class="even">
<td nowrap="nowrap">path</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(2000)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>首页路径</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">has_static</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>已经静态化</td>
</tr>
<tr class="even">
<td nowrap="nowrap">url</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(2048)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>首页地址</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">content_path</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(500)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>内容路径</td>
</tr>
<tr class="even">
<td nowrap="nowrap">page_size</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>每页数据条数</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">allow_contribute</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>允许投稿</td>
</tr>
<tr class="even">
<td nowrap="nowrap">sort</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap">0</td>
<td>顺序</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">hidden</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>隐藏</td>
</tr>
<tr class="even">
<td nowrap="nowrap">disabled</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>是否删除</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">contents</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap">0</td>
<td>内容数</td>
</tr>
<tr class="even">
<td nowrap="nowrap">extend_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>扩展ID</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>cms_category_attribute</h2>
表注释: 分类扩展 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">category_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>分类ID</td>
</tr>
<tr class="even">
<td nowrap="nowrap">title</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(80)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>标题</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">keywords</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(100)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>关键词</td>
</tr>
<tr class="even">
<td nowrap="nowrap">description</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(300)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>描述</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">data</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">longtext</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>数据JSON</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>cms_category_model</h2>
表注释: 分类模型 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">category_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>分类ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">model_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>模型ID</td>
</tr>
<tr class="even">
<td nowrap="nowrap">template_path</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(200)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>内容模板路径</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>cms_category_type</h2>
表注释: cms_category_type<br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">siteId</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">name</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>名称</td>
</tr>
<tr class="even">
<td nowrap="nowrap">sort</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>排序</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">extend_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>扩展ID</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>cms_content</h2>
表注释: 内容 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">site_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">title</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>标题</td>
</tr>
<tr class="even">
<td nowrap="nowrap">user_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>发表用户</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">check_user_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>审核用户</td>
</tr>
<tr class="even">
<td nowrap="nowrap">category_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>分类</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">model_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>模型</td>
</tr>
<tr class="even">
<td nowrap="nowrap">parent_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>父内容ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">copied</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>是否转载</td>
</tr>
<tr class="even">
<td nowrap="nowrap">author</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>作者</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">editor</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>编辑</td>
</tr>
<tr class="even">
<td nowrap="nowrap">only_url</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>外链</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">has_images</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>拥有图片列表</td>
</tr>
<tr class="even">
<td nowrap="nowrap">has_files</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>拥有附件列表</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">has_static</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>已经静态化</td>
</tr>
<tr class="even">
<td nowrap="nowrap">url</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(2048)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>地址</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">description</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(300)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>简介</td>
</tr>
<tr class="even">
<td nowrap="nowrap">tag_ids</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(100)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>标签</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">cover</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>封面</td>
</tr>
<tr class="even">
<td nowrap="nowrap">childs</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>内容页数</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">scores</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>分数</td>
</tr>
<tr class="even">
<td nowrap="nowrap">comments</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>评论数</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">clicks</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>点击数</td>
</tr>
<tr class="even">
<td nowrap="nowrap">publish_date</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">datetime</td>
<td></td>
<td nowrap="nowrap"></td>
<td>发布日期</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">create_date</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">datetime</td>
<td></td>
<td nowrap="nowrap"></td>
<td>创建日期</td>
</tr>
<tr class="even">
<td nowrap="nowrap">status</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>状态:0、草稿 1、已发布 2、待审核</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">disabled</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>是否删除</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>cms_content_attribute</h2>
表注释: 内容扩展 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">content_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">source</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>内容来源</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">source_url</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(2048)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>来源地址</td>
</tr>
<tr class="even">
<td nowrap="nowrap">data</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">longtext</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>数据JSON</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">text</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">text</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>内容</td>
</tr>
<tr class="even">
<td nowrap="nowrap">word_count</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>字数</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>cms_content_file</h2>
表注释: 内容附件 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">content_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>内容</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">user_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>用户</td>
</tr>
<tr class="even">
<td nowrap="nowrap">file_path</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>文件路径</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">image</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>是否图片</td>
</tr>
<tr class="even">
<td nowrap="nowrap">size</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>大小</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">clicks</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>点击数</td>
</tr>
<tr class="even">
<td nowrap="nowrap">sort</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>排序</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">description</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(300)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>描述</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>cms_content_related</h2>
表注释: 推荐推荐 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">content_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>内容</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">related_content_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>推荐内容</td>
</tr>
<tr class="even">
<td nowrap="nowrap">user_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>推荐用户</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">url</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(2048)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>推荐链接地址</td>
</tr>
<tr class="even">
<td nowrap="nowrap">title</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>推荐标题</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">description</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(300)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>推荐简介</td>
</tr>
<tr class="even">
<td nowrap="nowrap">clicks</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>点击数</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">sort</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>排序</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>cms_content_tag</h2>
表注释: 内容标签 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">tag_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>标签ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">content_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>内容ID</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>cms_model</h2>
表注释: 模型 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">site_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">parent_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>父模型</td>
</tr>
<tr class="even">
<td nowrap="nowrap">name</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>内容模型名称</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">template_path</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(200)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>默认内容模板路径</td>
</tr>
<tr class="even">
<td nowrap="nowrap">has_child</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>拥有子模型</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">only_url</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap">0</td>
<td>是链接</td>
</tr>
<tr class="even">
<td nowrap="nowrap">has_images</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>拥有图片列表</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">has_files</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>拥有附件列表</td>
</tr>
<tr class="even">
<td nowrap="nowrap">disabled</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>是否删除</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">extend_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>扩展ID</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>cms_place</h2>
表注释: 页面数据 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">site_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">path</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>模板路径</td>
</tr>
<tr class="even">
<td nowrap="nowrap">user_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>提交用户</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">item_type</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>推荐项目类型</td>
</tr>
<tr class="even">
<td nowrap="nowrap">item_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>推荐项目ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">title</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>标题</td>
</tr>
<tr class="even">
<td nowrap="nowrap">url</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(2048)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>超链接</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">cover</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>封面图</td>
</tr>
<tr class="even">
<td nowrap="nowrap">create_date</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">datetime</td>
<td></td>
<td nowrap="nowrap"></td>
<td>创建日期</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">publish_date</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">datetime</td>
<td></td>
<td nowrap="nowrap"></td>
<td>发布日期</td>
</tr>
<tr class="even">
<td nowrap="nowrap">status</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>状态:0、前台提交 1、已发布</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">clicks</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>点击数</td>
</tr>
<tr class="even">
<td nowrap="nowrap">disabled</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>已禁用</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>cms_place_attribute</h2>
表注释: 推荐位数据扩展 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">place_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>位置ID</td>
</tr>
<tr class="even">
<td nowrap="nowrap">data</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">longtext</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>数据JSON</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>cms_tag</h2>
表注释: 标签 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">site_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">name</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>名称</td>
</tr>
<tr class="even">
<td nowrap="nowrap">type_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>分类ID</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>cms_tag_type</h2>
表注释: 标签类型 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">site_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">name</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>名称</td>
</tr>
<tr class="even">
<td nowrap="nowrap">count</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>标签数</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>cms_word</h2>
表注释: cms_word<br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">name</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>名称</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">site_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点</td>
</tr>
<tr class="even">
<td nowrap="nowrap">search_count</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>搜素次数</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">hidden</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>隐藏</td>
</tr>
<tr class="even">
<td nowrap="nowrap">create_date</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">datetime</td>
<td></td>
<td nowrap="nowrap"></td>
<td>创建日期</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>home_message</h2>
表注释: 用户消息 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">user_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>所属用户</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">send_user_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>发送用户</td>
</tr>
<tr class="even">
<td nowrap="nowrap">receive_user_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>接收用户</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">message_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>关联消息</td>
</tr>
<tr class="even">
<td nowrap="nowrap">channel</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>渠道</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">create_date</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>创建日期</td>
</tr>
<tr class="even">
<td nowrap="nowrap">content</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">text</td>
<td></td>
<td nowrap="nowrap"></td>
<td>消息</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>log_login</h2>
表注释: 登陆日志 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">site_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">name</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>用户名</td>
</tr>
<tr class="even">
<td nowrap="nowrap">user_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>用户ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">ip</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(64)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>IP</td>
</tr>
<tr class="even">
<td nowrap="nowrap">channel</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap">web</td>
<td>登陆渠道</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">result</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>结果</td>
</tr>
<tr class="even">
<td nowrap="nowrap">create_date</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">datetime</td>
<td></td>
<td nowrap="nowrap"></td>
<td>创建日期</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">error_password</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(100)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>错误密码</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>log_operate</h2>
表注释: 操作日志 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">site_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">user_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>用户ID</td>
</tr>
<tr class="even">
<td nowrap="nowrap">channel</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>操作取到</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">operate</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(40)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>操作</td>
</tr>
<tr class="even">
<td nowrap="nowrap">ip</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(64)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>IP</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">create_date</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">datetime</td>
<td></td>
<td nowrap="nowrap"></td>
<td>创建日期</td>
</tr>
<tr class="even">
<td nowrap="nowrap">content</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(500)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>内容</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>log_task</h2>
表注释: 任务计划日志 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">site_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">task_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>任务</td>
</tr>
<tr class="even">
<td nowrap="nowrap">begintime</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">datetime</td>
<td></td>
<td nowrap="nowrap"></td>
<td>开始时间</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">endtime</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">datetime</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>结束时间</td>
</tr>
<tr class="even">
<td nowrap="nowrap">success</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>执行成功</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">result</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">longtext</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>执行结果</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>plugin_lottery</h2>
表注释: plugin_lottery<br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">site_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">start_date</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">datetime</td>
<td></td>
<td nowrap="nowrap"></td>
<td>开始日期</td>
</tr>
<tr class="even">
<td nowrap="nowrap">end_date</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">datetime</td>
<td></td>
<td nowrap="nowrap"></td>
<td>结束日期</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">interval_hour</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>抽奖间隔小时</td>
</tr>
<tr class="even">
<td nowrap="nowrap">gift</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>每次可抽奖数量</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">total_gift</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>奖品总数</td>
</tr>
<tr class="even">
<td nowrap="nowrap">last_gift</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>剩余数量</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">lottery_count</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>可抽奖次数</td>
</tr>
<tr class="even">
<td nowrap="nowrap">fractions</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>概率分子</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">numerator</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>概率分母</td>
</tr>
<tr class="even">
<td nowrap="nowrap">url</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(2048)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>地址</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">title</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(100)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>标题</td>
</tr>
<tr class="even">
<td nowrap="nowrap">description</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(300)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>描述</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">disabled</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>是否禁用</td>
</tr>
<tr class="even">
<td nowrap="nowrap">extend_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>扩展ID</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>plugin_lottery_user</h2>
表注释: plugin_lottery_user<br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">lottery_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>抽奖ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">user_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>用户ID</td>
</tr>
<tr class="even">
<td nowrap="nowrap">winning</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>是否中奖</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">ip</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(64)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>IP</td>
</tr>
<tr class="even">
<td nowrap="nowrap">create_date</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">datetime</td>
<td></td>
<td nowrap="nowrap"></td>
<td>创建日期</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">attribute_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>扩展属性ID</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>plugin_lottery_user_attribute</h2>
表注释: 抽奖用户扩展 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">lottery_user_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>抽奖用户ID</td>
</tr>
<tr class="even">
<td nowrap="nowrap">data</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">longtext</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>数据JSON</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>plugin_site</h2>
表注释: plugin_site<br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">site_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">plugin_code</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>插件</td>
</tr>
<tr class="even">
<td nowrap="nowrap">widget_template</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>内容插件模板</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">static_template</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>静态化模板</td>
</tr>
<tr class="even">
<td nowrap="nowrap">path</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(2000)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>静态化路径</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>plugin_vote</h2>
表注释: plugin_vote<br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">site_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">start_date</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">datetime</td>
<td></td>
<td nowrap="nowrap"></td>
<td>开始日期</td>
</tr>
<tr class="even">
<td nowrap="nowrap">end_date</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">datetime</td>
<td></td>
<td nowrap="nowrap"></td>
<td>结束日期</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">interval_hour</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>投票间隔小时</td>
</tr>
<tr class="even">
<td nowrap="nowrap">max_vote</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>最大投票数</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">anonymous</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>匿名投票</td>
</tr>
<tr class="even">
<td nowrap="nowrap">user_counts</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>参与用户数</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">url</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(2048)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>地址</td>
</tr>
<tr class="even">
<td nowrap="nowrap">title</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(100)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>标题</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">description</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(300)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>描述</td>
</tr>
<tr class="even">
<td nowrap="nowrap">disabled</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>已禁用</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">item_extend_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>扩展ID</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>plugin_vote_item</h2>
表注释: plugin_vote_item<br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">vote_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>投票</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">title</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(100)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>标题</td>
</tr>
<tr class="even">
<td nowrap="nowrap">description</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(300)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>描述</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">scores</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>票数</td>
</tr>
<tr class="even">
<td nowrap="nowrap">sort</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>顺序</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>plugin_vote_item_attribute</h2>
表注释: 投票选项扩展 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">vote_item_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>选项ID</td>
</tr>
<tr class="even">
<td nowrap="nowrap">data</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">longtext</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>数据JSON</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>plugin_vote_user</h2>
表注释: plugin_vote_user<br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">lottery_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>抽奖ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">user_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>用户ID</td>
</tr>
<tr class="even">
<td nowrap="nowrap">item_ids</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(100)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>投票选项</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">ip</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(64)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>IP</td>
</tr>
<tr class="even">
<td nowrap="nowrap">create_date</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">datetime</td>
<td></td>
<td nowrap="nowrap"></td>
<td>创建日期</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>sys_app</h2>
表注释: sys_app<br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">site_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">channel</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>渠道</td>
</tr>
<tr class="even">
<td nowrap="nowrap">app_key</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>APP key</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">app_secret</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>APP secret</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>sys_app_client</h2>
表注释: sys_app_client<br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">site_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">channel</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(20)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>渠道</td>
</tr>
<tr class="even">
<td nowrap="nowrap">uuid</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>唯一标识</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">user_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>绑定用户</td>
</tr>
<tr class="even">
<td nowrap="nowrap">client_version</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>版本</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">allow_push</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>允许推送</td>
</tr>
<tr class="even">
<td nowrap="nowrap">push_token</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>推送授权码</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">last_login_date</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">datetime</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>上次登录时间</td>
</tr>
<tr class="even">
<td nowrap="nowrap">last_login_ip</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(20)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>上次登录IP</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">create_date</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">datetime</td>
<td></td>
<td nowrap="nowrap"></td>
<td>创建日期</td>
</tr>
<tr class="even">
<td nowrap="nowrap">disabled</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>是否禁用</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>sys_app_token</h2>
表注释: sys_app_token<br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">auth_token</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(40)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>授权验证</td>
</tr>
<tr class="even">
<td nowrap="nowrap">app_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>应用ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">create_date</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">datetime</td>
<td></td>
<td nowrap="nowrap"></td>
<td>创建日期</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>sys_dept</h2>
表注释: 部门 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">site_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">name</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>名称</td>
</tr>
<tr class="even">
<td nowrap="nowrap">parent_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>父部门ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">description</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(300)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>描述</td>
</tr>
<tr class="even">
<td nowrap="nowrap">user_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>负责人</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">owns_all_category</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>拥有全部分类权限</td>
</tr>
<tr class="even">
<td nowrap="nowrap">owns_all_page</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>拥有全部页面权限</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>sys_dept_category</h2>
表注释: 部门分类 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">dept_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>部门ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">category_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>分类ID</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>sys_dept_page</h2>
表注释: 部门页面 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">dept_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>部门ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">page</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>页面</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>sys_domain</h2>
表注释: 域名 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">name</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>域名</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">site_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点</td>
</tr>
<tr class="even">
<td nowrap="nowrap">path</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>路径</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">login_path</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>登陆模板路径</td>
</tr>
<tr class="even">
<td nowrap="nowrap">register_path</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>注册模板路径</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>sys_email_token</h2>
表注释: 邮件地址验证日志 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">auth_token</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(40)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>验证码</td>
</tr>
<tr class="even">
<td nowrap="nowrap">user_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>用户ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">email</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(100)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>邮件地址</td>
</tr>
<tr class="even">
<td nowrap="nowrap">create_date</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">datetime</td>
<td></td>
<td nowrap="nowrap"></td>
<td>创建日期</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>sys_extend</h2>
表注释: sys_extend<br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">item_type</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(20)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>扩展类型</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">item_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>扩展项目ID</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>sys_extend_field</h2>
表注释: 扩展 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">extend_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>扩展ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">required</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>是否必填</td>
</tr>
<tr class="even">
<td nowrap="nowrap">name</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(20)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>名称</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">description</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(100)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>解释</td>
</tr>
<tr class="even">
<td nowrap="nowrap">code</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(20)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>编码</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">input_type</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(20)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>表单类型</td>
</tr>
<tr class="even">
<td nowrap="nowrap">default_value</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>默认值</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>sys_ftp_user</h2>
表注释: sys_ftp_user<br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">site_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">name</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>用户名</td>
</tr>
<tr class="even">
<td nowrap="nowrap">password</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(32)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>密码</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">path</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>路径</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>sys_moudle</h2>
表注释: 模块 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">name</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(100)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>名称</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">url</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>链接地址</td>
</tr>
<tr class="even">
<td nowrap="nowrap">authorized_url</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">text</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>授权地址</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">parent_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>父模块</td>
</tr>
<tr class="even">
<td nowrap="nowrap">sort</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>排序</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>sys_role</h2>
表注释: 角色 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">site_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">name</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>名称</td>
</tr>
<tr class="even">
<td nowrap="nowrap">owns_all_right</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>拥有全部权限</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">show_all_moudle</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>显示全部模块</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>sys_role_authorized</h2>
表注释: 角色授权地址 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">role_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>角色ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">url</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>授权地址</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>sys_role_moudle</h2>
表注释: 角色授权模块 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">role_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>角色ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">moudle_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>模块ID</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>sys_role_user</h2>
表注释: 用户角色 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">role_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>角色ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">user_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>用户ID</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>sys_site</h2>
表注释: 站点 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">name</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="odd">
<td nowrap="nowrap">use_static</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>启用静态化</td>
</tr>
<tr class="even">
<td nowrap="nowrap">site_path</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点地址</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">use_ssi</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>启用服务器端包含</td>
</tr>
<tr class="even">
<td nowrap="nowrap">dynamic_path</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>动态站点地址</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">resource_path</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>资源站点地址</td>
</tr>
<tr class="even">
<td nowrap="nowrap">disabled</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>禁用</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>sys_task</h2>
表注释: 任务计划 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">site_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">name</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>名称</td>
</tr>
<tr class="even">
<td nowrap="nowrap">status</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>状态</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">cron_expression</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>表达式</td>
</tr>
<tr class="even">
<td nowrap="nowrap">description</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(300)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>描述</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">file_path</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(255)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>文件路径</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>sys_user</h2>
表注释: 用户 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td></td>
</tr>
<tr class="even">
<td nowrap="nowrap">site_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">name</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>用户名</td>
</tr>
<tr class="even">
<td nowrap="nowrap">password</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(32)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>密码</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">nick_name</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(45)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>昵称</td>
</tr>
<tr class="even">
<td nowrap="nowrap">dept_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>部门</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">roles</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">text</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>角色</td>
</tr>
<tr class="even">
<td nowrap="nowrap">email</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(100)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>邮箱地址</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">email_checked</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>已验证邮箱</td>
</tr>
<tr class="even">
<td nowrap="nowrap">superuser_access</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>是否管理员</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">disabled</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">tinyint(1)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>是否禁用</td>
</tr>
<tr class="even">
<td nowrap="nowrap">last_login_date</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">datetime</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>最后登录日期</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">last_login_ip</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(20)</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>最后登录ip</td>
</tr>
<tr class="even">
<td nowrap="nowrap">login_count</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>登录次数</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">registered_date</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">datetime</td>
<td></td>
<td nowrap="nowrap"><i>NULL</i></td>
<td>注册日期</td>
</tr>
</tbody>
</table>
</div>
<div>
<h2>sys_user_token</h2>
表注释: 用户令牌 <br> <br>
<table width="100%" class="print">
<tbody>
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40"></th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td nowrap="nowrap">auth_token</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(40)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>登陆授权</td>
</tr>
<tr class="even">
<td nowrap="nowrap">site_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>站点ID</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">user_id</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">int(11)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>用户ID</td>
</tr>
<tr class="even">
<td nowrap="nowrap">channel</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(50)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>渠道</td>
</tr>
<tr class="odd">
<td nowrap="nowrap">create_date</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">datetime</td>
<td></td>
<td nowrap="nowrap"></td>
<td>创建日期</td>
</tr>
<tr class="even">
<td nowrap="nowrap">login_ip</td>
<td nowrap="nowrap" xml:lang="en" dir="ltr">varchar(20)</td>
<td></td>
<td nowrap="nowrap"></td>
<td>登陆IP</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>
1
https://gitee.com/kylecust/PublicCMS-lib.git
git@gitee.com:kylecust/PublicCMS-lib.git
kylecust
PublicCMS-lib
PublicCMS-lib
master

搜索帮助