123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255325632573258325932603261326232633264326532663267326832693270327132723273327432753276327732783279328032813282328332843285328632873288328932903291329232933294329532963297329832993300330133023303330433053306330733083309331033113312331333143315331633173318331933203321332233233324332533263327332833293330333133323333333433353336333733383339334033413342334333443345334633473348334933503351335233533354335533563357335833593360336133623363336433653366336733683369337033713372337333743375337633773378337933803381338233833384338533863387338833893390339133923393339433953396339733983399340034013402340334043405340634073408340934103411341234133414341534163417341834193420342134223423342434253426342734283429343034313432343334343435343634373438343934403441344234433444344534463447344834493450345134523453345434553456345734583459346034613462346334643465346634673468346934703471347234733474347534763477347834793480348134823483348434853486348734883489349034913492349334943495349634973498349935003501350235033504350535063507350835093510351135123513351435153516351735183519352035213522352335243525352635273528352935303531353235333534353535363537353835393540354135423543354435453546354735483549355035513552355335543555355635573558355935603561356235633564356535663567356835693570357135723573357435753576357735783579358035813582358335843585358635873588358935903591359235933594359535963597359835993600360136023603360436053606360736083609361036113612361336143615361636173618361936203621362236233624362536263627362836293630363136323633363436353636363736383639364036413642364336443645364636473648364936503651365236533654365536563657365836593660366136623663366436653666366736683669367036713672367336743675367636773678367936803681368236833684368536863687368836893690369136923693369436953696369736983699370037013702370337043705370637073708370937103711371237133714371537163717371837193720372137223723372437253726372737283729373037313732373337343735373637373738373937403741374237433744374537463747374837493750375137523753375437553756375737583759376037613762376337643765376637673768376937703771377237733774377537763777377837793780378137823783378437853786378737883789379037913792379337943795379637973798379938003801380238033804380538063807380838093810381138123813381438153816381738183819382038213822382338243825382638273828382938303831383238333834383538363837383838393840384138423843384438453846384738483849385038513852385338543855385638573858385938603861386238633864386538663867386838693870387138723873387438753876387738783879388038813882388338843885388638873888388938903891389238933894389538963897389838993900390139023903390439053906390739083909391039113912391339143915391639173918391939203921392239233924392539263927392839293930393139323933393439353936393739383939394039413942394339443945394639473948394939503951395239533954395539563957395839593960396139623963396439653966396739683969397039713972397339743975397639773978397939803981398239833984398539863987398839893990399139923993399439953996399739983999400040014002400340044005400640074008400940104011401240134014401540164017401840194020402140224023402440254026402740284029403040314032403340344035403640374038403940404041404240434044404540464047404840494050405140524053405440554056405740584059406040614062406340644065406640674068406940704071407240734074407540764077407840794080408140824083408440854086408740884089409040914092409340944095409640974098409941004101410241034104410541064107410841094110411141124113411441154116411741184119412041214122412341244125412641274128412941304131413241334134413541364137413841394140414141424143414441454146414741484149415041514152415341544155415641574158415941604161416241634164416541664167416841694170417141724173417441754176417741784179418041814182418341844185418641874188418941904191419241934194419541964197419841994200420142024203420442054206420742084209421042114212421342144215421642174218421942204221422242234224422542264227422842294230423142324233423442354236423742384239424042414242424342444245424642474248424942504251425242534254425542564257425842594260426142624263426442654266426742684269427042714272427342744275427642774278427942804281428242834284428542864287428842894290429142924293429442954296429742984299430043014302430343044305430643074308430943104311431243134314431543164317431843194320432143224323432443254326432743284329433043314332433343344335433643374338433943404341434243434344434543464347434843494350435143524353435443554356435743584359436043614362436343644365436643674368436943704371437243734374437543764377437843794380438143824383438443854386438743884389439043914392439343944395439643974398439944004401440244034404440544064407440844094410441144124413441444154416441744184419442044214422442344244425442644274428442944304431443244334434443544364437443844394440444144424443444444454446444744484449445044514452445344544455445644574458445944604461446244634464446544664467446844694470447144724473447444754476447744784479448044814482448344844485448644874488448944904491449244934494449544964497449844994500450145024503450445054506450745084509451045114512451345144515451645174518451945204521452245234524452545264527452845294530453145324533453445354536453745384539454045414542454345444545454645474548454945504551455245534554455545564557455845594560456145624563456445654566456745684569457045714572457345744575457645774578457945804581458245834584458545864587458845894590459145924593459445954596459745984599460046014602460346044605460646074608460946104611461246134614461546164617461846194620462146224623462446254626462746284629463046314632463346344635463646374638463946404641464246434644464546464647464846494650465146524653465446554656465746584659466046614662466346644665466646674668466946704671467246734674467546764677467846794680468146824683468446854686468746884689469046914692469346944695469646974698469947004701470247034704470547064707470847094710471147124713471447154716471747184719472047214722472347244725472647274728472947304731473247334734473547364737473847394740474147424743474447454746474747484749475047514752475347544755475647574758475947604761476247634764476547664767476847694770477147724773477447754776477747784779478047814782478347844785478647874788478947904791479247934794479547964797479847994800480148024803480448054806480748084809481048114812481348144815481648174818481948204821482248234824482548264827482848294830483148324833483448354836483748384839484048414842484348444845484648474848484948504851485248534854485548564857485848594860486148624863486448654866486748684869487048714872487348744875487648774878487948804881488248834884488548864887488848894890489148924893489448954896 |
- <?xml version='1.0' encoding='UTF-8' standalone='yes'?>
- <!DOCTYPE html>
- <html lang='en' xmlns='http://www.w3.org/1999/xhtml'>
- <head>
- <title>RuoYi</title>
- <meta http-equiv='Content-Type' content='text/html; charset=UTF-8'/>
- <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
- <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-alpha.6/css/bootstrap.min.css"
- integrity="sha384-rwoIResjU2yc3z8GV/NPeZWAv56rSmLldC3R/AZzGRnGxQQKnKkoFVhFQhNUwEyJ" crossorigin="anonymous">
- <script src="https://cdnjs.cloudflare.com/ajax/libs/tether/1.4.0/js/tether.min.js"
- integrity="sha384-DztdAPBWPRXSA/3eYEEUWrWCy7G5KFbe8fFjk5JAIxUYHKkDx6Qin1DkWx51bBrb"
- crossorigin="anonymous"></script>
- <!--<script src="https://code.jquery.com/jquery-3.1.1.slim.min.js" integrity="sha384-A7FZj7v+d/sdmMqp/nOQwliLvUsJfDHW+k9Omg/a/EheAdgtzNs3hpfag6Ed950n" crossorigin="anonymous"></script>-->
- <!--<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-alpha.6/js/bootstrap.min.js" integrity="sha384-vBWWzlZJ8ea9aCX4pEW3rVHjgjt7zpkNpZk+02D9phzyeVkE+jo0ieGizqPLForn" crossorigin="anonymous"></script>-->
- <link rel="shortcut icon" href="https://www.dbschema.com/images/favicon.ico">
- <style type='text/css'>
- body {
- font-family: 'Segoe UI', 'Lucida sans', Dialog;
- font-size: 13px;
- background-color: #f5f5f5;
- margin: 10px;
- }
- </style>
- </head>
- <body>
- <div class='svg-container'>
- <svg xmlns='http://www.w3.org/2000/svg' xmlns:xlink='http://www.w3.org/1999/xlink' width='1890' height='1100'
- viewBox='0 0 1890 1100'>
- <script type='text/ecmascript'>
- <![CDATA[
- function hghl(el) {
- for (var i in el) {
- var elem = document.getElementById(el[i]);
- if (elem != null) elem.setAttribute('class', 'highlight');
- }
- }
- function uhghl(el) {
- for (var i in el) {
- var elem = document.getElementById(el[i]);
- if (elem != null) elem.setAttribute('class', 'scene');
- }
- }
- ]]>
- </script>
- <style type='text/css'>
- text {
- fill: #000000;
- font-family: SimSun, 'Trebuchet MS', Dialog;
- font-size: 11px;
- }
- a text:hover {
- fill: #94025f;
- text-shadow: 0px 0px 6px #d0ce00;
- font-size: 13px;
- }
- text.highlight {
- fill: #94025f;
- text-shadow: 0px 0px 4px #eac533;
- font-size: 13px;
- }
- text.colType {
- fill: #b3b3b3;
- }
- text.relName {
- fill: #b09c7c;
- }
- path {
- stroke: #5c554f;
- stroke-width: 1.15;
- fill: none;
- }
- path {
- stroke: #5c554f;
- stroke-width: 1.15;
- fill: none;
- }
- path.virtual {
- stroke: #b7642d;
- }
- path.logo {
- fill: #fbeac0;
- fill-opacity: 1;
- stroke-width: 0.3;
- stroke: #222222;
- }
- path.dotted {
- stroke-dasharray: 4, 2;
- }
- path.scene {
- stroke-width: 10;
- opacity: 0;
- }
- path.highlight {
- stroke-width: 5;
- stroke: #c1a662;
- opacity: 0.6;
- }
- rect.entity {
- fill: #ffffff;
- stroke: #aaa;
- stroke-width: 1;
- shape-rendering: crispEdges;
- filter: url(#shadow);
- }
- line.delim {
- stroke-width: 1;
- shape-rendering: crispEdges;
- }
- text.callout {
- fill: #000000;
- font-family: SimSun, 'Trebuchet MS', Dialog;
- font-size: 12px;
- }
- rect.callout {
- fill: url(#calloutGradient);
- stroke: #bebdbd;
- stroke-width: 0.5;
- filter: url(#shadow);
- }
- rect.grp {
- stroke: #b1b1b1;
- stroke-width: 1.7;
- opacity: 0.8;
- }
- path.st0 {
- fill: #ececec;
- fill-opacity: 1;
- stroke-width: 0.6;
- stroke: #aaaaaa;
- }
- </style>
- <defs>
- <pattern id='layoutBgA' patternUnits='userSpaceOnUse' width='10' height='20' x='0' y='0' viewBox='0 0 5 10'>
- <line x1='-2' y1='1' x2='7' y2='10' stroke='#f3f3f3' stroke-width='.5'/>
- <line x1='-2' y1='6' x2='7' y2='15' stroke='#f3f3f3' stroke-width='.5'/>
- <line x1='-2' y1='-4' x2='7' y2='5' stroke='#f3f3f3' stroke-width='.5'/>
- </pattern>
- <radialGradient id='layoutBgB' gradientUnits='userSpaceOnUse' cx='50%' cy='50%' r='75%' fx='46%' fy='22%'>
- <stop offset='0%' stop-opacity='.2' stop-color='#f5f5f5'/>
- <stop offset='100%' stop-color='#efefef'/>
- </radialGradient>
- <pattern id='layoutBgTr' patternUnits='userSpaceOnUse' width='300' height='300' x='0' y='0'
- viewBox='0 0 300 300'>
- <path class='st0'
- d='m 62.011835,91.267143 c 3.536475,3.175214 2.262669,8.705999 -1.637711,11.015197 -3.594697,5.8423 -6.34682,-2.892623 -9.715478,-4.653898 -5.609222,-2.838926 2.050802,-6.680123 4.77004,-8.319046 2.334696,-0.724067 4.935143,0.312302 6.583149,1.957747 z m -2.720492,2.538595 c -2.698397,-3.517732 -9.282815,1.269287 -3.69635,3.568637 2.765331,5.605665 7.052809,-0.56184 3.69635,-3.568637 z'/>
- <path class='st0'
- d='m 72.25864,84.624638 c 4.108046,3.143003 -0.737059,6.895259 -1.994918,8.323564 -3.586718,5.561143 -6.495079,-4.197379 -10.07759,-5.582178 -4.443422,-1.088878 1.349298,-7.249213 2.503526,-2.503449 2.464639,4.517161 2.304019,-3.70697 6.291113,-1.995914 1.280083,0.137865 2.410691,0.864819 3.277869,1.757977 z m -2.646109,2.323242 c -4.797162,-3.078383 -2.810517,6.305507 0.515161,1.990646 0.296432,-0.688582 0.01209,-1.493412 -0.515161,-1.990646 z'/>
- <path class='st0'
- d='m 78.230641,79.436735 c 4.142121,3.027466 -2.020102,10.435276 -3.450543,5.477315 3.306312,-5.248112 -9.186019,-2.220094 -5.805994,-8.77679 -0.544141,-3.93011 6.797826,-2.102227 3.386015,0.245477 -0.181085,2.915838 4.637371,1.019311 5.870522,3.053982 z'/>
- <path class='st0'
- d='m 82.744502,72.597397 c -4.901605,1.926521 1.146497,6.285555 2.559694,2.225783 6.21817,3.539297 -6.640186,8.416664 -7.590325,1.997457 -2.24365,-2.914883 4.026676,-10.148618 5.030631,-4.22324 z'/>
- <path class='st0'
- d='m 90.727458,64.259158 c 1.583987,1.690029 3.321317,3.2696 4.81267,5.026353 -2.535706,6.849794 -6.445583,-5.918773 -8.388458,-0.167017 0.782768,2.03426 5.877405,3.752079 2.670979,5.711199 -3.315119,1.519161 -5.782422,-5.157931 -8.858893,-6.780537 -4.229842,-1.139816 1.510134,-7.074128 2.586227,-2.385939 3.141198,5.495193 1.840537,-5.598295 7.177489,-1.404062 z'/>
- <path class='st0'
- d='m 99.622027,58.374253 c 1.493293,1.9548 -6.281936,7.024659 -0.885258,4.740447 0.386238,-4.434477 6.131941,-1.133173 2.175851,1.618005 -4.421491,6.12739 -13.666659,-3.151506 -7.058299,-7.136537 1.785129,-1.119329 4.348209,-0.743179 5.767706,0.778085 z m -2.900824,1.89746 c -3.608188,-2.208543 -2.280489,5.00803 -0.12563,0.329531 z'/>
- <path class='st0'
- d='m 115.18023,50.570441 c -1.61703,5.201678 -4.6204,-0.364502 -7.01598,-1.749619 -4.40977,2.122562 4.89641,4.913939 1.89606,7.018157 -2.48061,3.877635 -4.11404,-4.060614 -7.01192,-2.6391 -1.76318,3.107252 7.28394,6.252304 0.87346,7.876177 -1.74515,-2.956649 -9.055498,-5.610518 -3.950378,-8.66062 1.696478,1.897023 1.770418,-5.43503 5.347308,-3.072411 -0.44014,-5.474701 6.11995,-4.950882 7.7846,-0.815355 0.69076,0.682329 1.39587,1.351469 2.07685,2.042771 z'/>
- <path class='st0'
- d='m 120.54891,39.417125 c 2.50681,1.334124 4.80466,4.941837 0.75044,5.297362 -0.46414,1.89865 -5.25369,5.602652 -8.01742,1.815475 -3.87345,-2.809139 -0.0676,-7.603869 2.3036,-8.133924 1.6795,-3.853018 3.16703,-1.199465 4.96338,1.021087 z m -2.2464,2.175828 c -4.8049,-2.992167 -3.08987,6.380358 0.42374,2.036159 0.33052,-0.677508 0.12099,-1.525836 -0.42374,-2.036159 z'/>
- <path class='st0'
- d='m 128.50836,24.06821 c -5.10403,3.035506 3.20535,6.383175 5.05938,9.450276 -0.91853,2.95886 -4.06493,3.650723 -5.34691,0.265618 -2.25715,-2.089033 -4.65672,-6.948595 -7.07024,-2.584686 -4.71758,-3.764394 3.81217,-5.812054 5.12382,-9.226328 0.75738,0.677487 1.38637,1.498638 2.23389,2.095175 z'/>
- <path class='st0'
- d='m 137.14366,22.299812 c -3.09615,2.259885 0.71537,4.412454 1.99042,6.435866 -3.08975,5.080354 -5.91384,-2.98648 -8.92144,-4.094939 1.44369,-3.219573 3.3497,-1.335928 4.27156,-4.41058 0.97822,-0.894325 1.75044,1.871047 2.65946,2.069653 z'/>
- <path class='st0'
- d='m 136.85093,14.890174 c 2.31562,5.283511 -7.17975,1.771993 -1.29675,-0.475107 l 0.7108,0.08973 z m 4.867,5.317354 c 2.56912,1.439678 4.26517,4.725219 0.30678,5.233637 -1.56592,-3.098864 -9.51683,-5.749448 -3.64502,-8.633714 1.17746,0.325095 2.15375,2.591149 3.33824,3.400077 z'/>
- <path class='st0'
- d='m 149.95578,11.976423 c 2.50679,1.334142 4.80455,4.94192 0.75041,5.297394 -0.4641,1.898604 -5.25368,5.602645 -8.0174,1.81545 -3.87347,-2.80918 -0.0676,-7.603844 2.30366,-8.133968 1.67949,-3.8530525 3.16695,-1.1993573 4.96333,1.021124 z m -2.24641,2.175828 c -4.80489,-2.992177 -3.08986,6.380343 0.42374,2.036167 0.33055,-0.677518 0.121,-1.52585 -0.42374,-2.036167 z'/>
- <path class='st0'
- d='m 153.26135,7.538431 c 2.60497,1.5799548 6.03999,5.944272 1.08117,6.050232 -2.53319,-3.231828 -7.20316,-6.4304525 -8.84748,-9.4582682 1.89121,-2.8664883 3.78452,-2.247699 5.38514,0.8929426 0.78017,0.8503859 1.57195,1.6911437 2.38118,2.5150667 z'/>
- </pattern>
- <linearGradient id='groupUnderTitleLine' x1='0%' y1='0%' x2='100%' y2='0%'>
- <stop offset='0%' stop-color='#999999' stop-opacity='0.7'/>
- <stop offset='100%' stop-color='#999999' stop-opacity='0'/>
- </linearGradient>
- <radialGradient id='calloutGradient' cx='25%' cy='20%' r='80%' fx='10%' fy='10%'>
- <stop offset='0%' stop-color='#ffffff'/>
- <stop offset='100%' stop-color='#f8f6d1'/>
- </radialGradient>
- <filter id='shadow' width='120%' height='120%'>
- <feOffset result='offOut' in='SourceGraphic' dx='1' dy='1'/>
- <feColorMatrix result='matrixOut' in='offOut' type='matrix'
- values='0.1 0 0 0 0 0 0.4 0 0 0 0 0 0.6 0 0 0 0 0 0.3 0'/>
- <feGaussianBlur result='blurOut' in='matrixOut' stdDeviation='3'/>
- <feBlend in='SourceGraphic' in2='blurOut' mode='normal'/>
- </filter>
- <filter id='fkShadow' height='130%'>
- <feGaussianBlur in='SourceAlpha' stdDeviation='1.5'/> <!-- stdDeviation is how much to blur -->
- <feOffset dx='1.2' dy='1.2' result='offsetblur'/> <!-- how much to offset -->
- <feMerge>
- <feMergeNode/> <!-- this contains the offset blurred image -->
- <feMergeNode in='SourceGraphic'/> <!-- this contains the element that the filter is applied to -->
- </feMerge>
- </filter>
- <radialGradient id='legendGradient' fx='5%' fy='5%' r='75%' spreadMethod='pad'>
- <stop offset='0%' stop-color='#eefbf2' stop-opacity='1'/>
- <stop offset='100%' stop-color='#cff9cb' stop-opacity='1'/>
- </radialGradient>
- <symbol id='calloutArrowDown' overflow='visible'>
- <path d='M 0,0 L 7,11 L 15,0 z' style='fill:#f8f6d1;stroke:none; filter: url(#shadow);'/>
- <path d='M 0,0 L 7,11 L 15,0' style='stroke:#bebdbd; stroke-width:0.5;'/>
- </symbol>
- <symbol id='calloutArrowUp' overflow='visible'>
- <path d='M 0,15 L 7,3 L 15,15 z' style='fill:#ffffff; stroke:none; filter: url(#shadow);'/>
- <path d='M 0,15 L 7,3 L 15,15' style='stroke:#bebdbd; stroke-width:0.5;'/>
- </symbol>
- <symbol id='pk' overflow='visible'>
- <g transform='scale(0.99)'>
- <path style='fill:#fffa7d;stroke:#765f03;stroke-width:0.6;stroke-linecap:round;stroke-linejoin:round;'
- d='M 9.3678877,3.5695485 C 9.1030218,3.2729386 9.0796382,2.7628519 9.3396185,2.4517097 9.5449651,2.1956495 9.9040386,2.0980533 10.199638,2.2169415 10.533525,2.3415459 10.775153,2.706942 10.750675,3.0842709 10.737029,3.3980003 10.541153,3.699122 10.258248,3.8066067 9.966649,3.9250429 9.6169668,3.8418805 9.4008073,3.6062324 9.3894892,3.5943518 9.3785264,3.582104 9.3678886,3.5695487 z M 11.226617,6.9916004 C 11.888137,6.3548946 12.293488,5.4172188 12.311087,4.442353 12.378144,2.7379364 11.248678,1.0541269 9.7322318,0.44767357 8.3887112,-0.1280313 6.7865012,0.26822889 5.8918395,1.4007929 5.080823,2.3839145 4.9336815,3.8452096 5.3635544,5.101615 L 4.3670905,5.315913 C 4.0664984,5.3682645 4.0967703,5.6316724 4.2574957,5.8208829 L 4.9124,6.5655244 4.1543436,7.2512357 3.2136002,7.2163506 3.1674775,8.5586827 2.0406832,8.5086512 1.5965306,8.9299953 1.5471661,10.179833 0.75616674,10.195223 0.2112857,10.758575 0.15354288,11.735988 0.07199052,12.765553 c 0.36440953,0.238225 0.79006967,0.195492 1.44938278,-0.02675 L 6.3033562,8.1282037 6.8217102,8.6765688 C 6.9985465,8.8799427 7.3003699,8.7497574 7.358381,8.5016252 L 7.4938877,7.5084164 c 0.8537488,0.3985387 1.8303125,0.4711541 2.6851793,0.1427713 0.393927,-0.1407258 0.746858,-0.3701772 1.04755,-0.6595873 z'/>
- <path d='M 6.8014948,6.3102123 0.15369063,13.024481 0.21560535,12.141962 6.0062342,6.2683782 z'
- style='fill:#ffe5a5;fill-opacity:1;stroke:#854e31;stroke-width:0.06912433;stroke-linecap:round;stroke-linejoin:round;stroke-miterlimit:4;stroke-opacity:1;stroke-dasharray:none;stroke-dashoffset:3.00300009'/>
- </g>
- </symbol>
- <symbol id='dist' overflow='visible'>
- <g transform='scale(0.99)'>
- <path style='fill:none;stroke:#000000;stroke-width:1px;stroke-linecap:butt;stroke-linejoin:miter;'
- d='M 0.177,11.431 12.28,11.449'/>
- <path style='fill:none;stroke:#000000;stroke-width:1px;stroke-linecap:butt;stroke-linejoin:miter;'
- d='m 6.124,3.954 0.066,7.154 v 0'/>
- <rect width='11.78' height='3.40' x='0.40' y='0.44'
- style='fill:#fffa7d;stroke:#765f03;stroke-width:0.6;' ry='0.83'/>
- <rect width='11.78' height='3.40' x='0.40' y='5.609'
- style='fill:#fffa7d;stroke:#765f03;stroke-width:0.6;' ry='0.832'/>
- </g>
- </symbol>
- <symbol id='unq' overflow='visible'>
- <g transform='scale(0.99)'>
- <rect style='fill:#fbea8e;stroke:#7e4d31;stroke-width:0.71934468;stroke-linecap:round;stroke-linejoin:round;'
- width='2.29' height='8.43' x='7.48' y='-0.76' ry='1.14'
- transform='matrix(0.701,0.713,-0.727,0.685,0,0)'/>
- <path style='fill:white;stroke:#858585;stroke-width:1.2;stroke-linecap:round;stroke-linejoin:round;stroke-miterlimit:4;'
- d='m 26.04,8.64 a 4.13,4.13 0 1 1 -8.26,0 4.13,4.13 0 1 1 8.26,0 z'
- transform='matrix(1.025,0,0,0.987,-14.690,-3.862)'/>
- <text x='5.8' y='7.4' style='font-size:7px;fill:#8a8a8a;'>1</text>
- </g>
- </symbol>
- <symbol id='idx' overflow='visible'>
- <g transform='scale(0.99)'>
- <rect style='fill:#fbea8e;stroke:#7e4d31;stroke-width:0.71934468;stroke-linecap:round;stroke-linejoin:round;'
- width='2.29' height='8.43' x='7.48' y='-0.76' ry='1.14'
- transform='matrix(0.701,0.713,-0.727,0.685,0,0)'/>
- <path style='fill:white;stroke:#858585;stroke-width:1.2;stroke-linecap:round;stroke-linejoin:round;stroke-miterlimit:4;'
- d='m 26.04,8.64 a 4.13,4.13 0 1 1 -8.26,0 4.13,4.13 0 1 1 8.26,0 z'
- transform='matrix(1.025,0,0,0.987,-14.690,-3.862)'/>
- </g>
- </symbol>
- <symbol id='fk' overflow='visible'>
- <g transform='scale(0.87)'>
- <path style='fill:#f3e1b7;stroke:#7e471f;stroke-width:0.5;stroke-linecap:butt;stroke-linejoin:round;stroke-miterlimit:4;'
- d='M 12.48,0.33 7.07,0.89 9.067,2.974 0.329,11.731 1.073,12.597 9.811,3.841 11.77,5.78 z'/>
- </g>
- </symbol>
- <symbol id='ref' overflow='visible'>
- <g transform='scale(0.87)'>
- <path style='fill:#f3e1b7;stroke:#7e471f;stroke-width:0.5;stroke-linecap:butt;stroke-linejoin:round;stroke-miterlimit:4;'
- d='M 0.10,12.70 5.31,12.15 3.40,10.06 11.82,1.32 11.11,0.45 2.68,9.19 0.80,7.24 z'/>
- </g>
- </symbol>
- <symbol id='flag0' overflow='visible'>
- <g transform='scale(0.92)'>
- <path style='fill:#b7d0f6;stroke:#000000;stroke-width:0.5;stroke-linecap:butt;stroke-linejoin:round;stroke-miterlimit:4;'
- d='M 0.12,12.67 0.16,7.22 C 2.59,7.22 4.13,8.78 9.22,4.22 5.68,4.98 2.53,4.50 0.09,1.80 z'/>
- </g>
- </symbol>
- <symbol id='flag1' overflow='visible'>
- <g transform='scale(0.92)'>
- <path style='fill:#f4a393;stroke:#000000;stroke-width:0.5;stroke-linecap:butt;stroke-linejoin:round;stroke-miterlimit:4;'
- d='M 0.12,12.67 0.16,7.22 C 2.59,7.22 4.13,8.78 9.22,4.22 5.68,4.98 2.53,4.50 0.09,1.80 z'/>
- </g>
- </symbol>
- <symbol id='flag2' overflow='visible'>
- <g transform='scale(0.92)'>
- <path style='fill:#77ec8b;stroke:#000000;stroke-width:0.5;stroke-linecap:butt;stroke-linejoin:round;stroke-miterlimit:4;'
- d='M 0.12,12.67 0.16,7.22 C 2.59,7.22 4.13,8.78 9.22,4.22 5.68,4.98 2.53,4.50 0.09,1.80 z'/>
- </g>
- </symbol>
- <symbol id='nn' overflow='visible'>
- <path style='stroke:#9b3e50;stroke-width:0.5;stroke-linecap:butt;stroke-linejoin:round;stroke-miterlimit:4;'
- d='M 0,0 3,3 M 0,3 3,0 z'/>
- </symbol>
- <symbol id='view' overflow='visible'>
- <g transform='scale(0.99)'>
- <line x1='12' y1='6' x2='19' y2='0' stroke='black' stroke-width='0.5'/>
- <line x1='0' y1='6' x2='7' y2='0' stroke='black' stroke-width='0.5'/>
- <circle cx='3' cy='6' r='3' fill='#f9ebbc' stroke='black' stroke-width='0.5'/>
- <circle cx='10' cy='6' r='3' fill='#f9ebbc' stroke='black' stroke-width='0.5'/>
- </g>
- </symbol>
- <marker id='arrow01' viewBox='0 0 15.00 7.50' refX='7.50' refY='3.75' markerUnits='strokeWidth'
- markerWidth='15.00' markerHeight='7.50' orient='auto'>
- <path d='M 7.500,3.750 L 15.000,3.750 L 7.500,0.000 L 15.000,3.750 L 7.500,7.500'/>
- </marker>
- <marker id='arrow1' viewBox='0 0 15.00 7.50' refX='7.50' refY='3.75' markerUnits='strokeWidth'
- markerWidth='15.00' markerHeight='7.50' orient='auto'>
- <path d='M 7.500,3.750 L 15.000,3.750 L 7.500,0.000 L 15.000,3.750 L 7.500,7.500'/>
- </marker>
- <marker id='foot01' viewBox='0 0 15.00 7.50' refX='7.50' refY='3.75' markerUnits='strokeWidth'
- markerWidth='15.00' markerHeight='7.50' orient='auto'>
- <path d='M 0.00,3.75 L 15.00,3.75 z'/>
- <circle cx='11.25' cy='3.75' r='2.50' style='fill:white;stroke:#5e554d;'/>
- <path d='M 3.75,0.00 L 3.75, 7.50 z'/>
- </marker>
- <marker id='foot0p' viewBox='0 0 15.00 7.50' refX='7.50' refY='3.75' markerUnits='strokeWidth'
- markerWidth='15.00' markerHeight='7.50' orient='auto'>
- <path d='M 0.00,3.75 L 15.00,3.75 z'/>
- <circle cx='11.25' cy='3.75' r='2.50' style='fill:white;stroke:#5e554d;'/>
- <path d='M 0.00,0.00 L 7.50,3.75 L 0.00,7.50'/>
- </marker>
- <marker id='foot1' viewBox='0 0 15.00 7.50' refX='7.50' refY='3.75' markerUnits='strokeWidth'
- markerWidth='15.00' markerHeight='7.50' orient='auto'>
- <path d='M 0.00,3.75 L 15.00,3.75 z'/>
- <path d='M 7.50,0.00 L 7.50, 7.50 z'/>
- <path d='M 3.75,0.00 L 3.75, 7.50 z'/>
- </marker>
- <marker id='foot1p' viewBox='0 0 15.00 7.50' refX='7.50' refY='3.75' markerUnits='strokeWidth'
- markerWidth='15.00' markerHeight='7.50' orient='auto'>
- <path d='M 0.00,3.75 L 15.00,3.75 z'/>
- <path d='M 7.50,0.00 L 7.50, 7.50 z'/>
- <path d='M 0.00,0.00 L 7.50,3.75 L 0.00,7.50'/>
- </marker>
- <linearGradient id='tbg_bfd4f5' x1='0%' y1='0%' x2='0%' y2='100%'>
- <stop offset='0%' stop-color='#496ba1'/>
- <stop offset='100%' stop-color='#1f4682'/>
- </linearGradient>
- <linearGradient id='tbg_c8f5bf' x1='0%' y1='0%' x2='0%' y2='100%'>
- <stop offset='0%' stop-color='#58a149'/>
- <stop offset='100%' stop-color='#30821f'/>
- </linearGradient>
- <linearGradient id='tbg_f5ddbf' x1='0%' y1='0%' x2='0%' y2='100%'>
- <stop offset='0%' stop-color='#a17a49'/>
- <stop offset='100%' stop-color='#82561f'/>
- </linearGradient>
- <linearGradient id='tbg_bfbff5' x1='0%' y1='0%' x2='0%' y2='100%'>
- <stop offset='0%' stop-color='#4949a1'/>
- <stop offset='100%' stop-color='#1f1f82'/>
- </linearGradient>
- </defs>
- <!-- == Desktop == -->
- <rect x='1' y='1' width='1888' height='1098' rx='7' ry='7'
- style='fill:url(#layoutBgB); stroke:#777777; stroke-width:0.5;'/>
- <rect x='1' y='1' width='1888' height='1098' rx='7' ry='7'
- style='fill:url(#layoutBgA); stroke:#777777; stroke-width:0.5;'/>
- <!-- == Legend == -->
- <g transform='translate(10,10)'>
- <rect x='10' y='10' width='330' height='56' rx='6' ry='6'
- style='fill:url(#legendGradient);filter:url(#shadow);'/>
- <text x='20' y='43'>RuoYi</text>
- <text x='20' y='57' style='fill:#aaaaaa; font-size:11px;'>
- <tspan>Move the mouse over tables & columns to read the comments.</tspan>
- </text>
- <a xlink:href='https://www.dbschema.com'>
- <path class='logo'
- d='m 32.309685,20.963194 c 0.411708,4.732616 -4.298055,7.925636 -8.723583,6.970196 -6.616967,1.8448 -2.656457,-6.434594 -3.911969,-10.01566 -2.15469,-5.89407 6.06247,-3.508505 9.167655,-2.863689 2.199228,1.054873 3.389343,3.582089 3.467897,5.909153 z m -3.720955,0.01451 c 0.434195,-4.414565 -7.644142,-5.37533 -5.137307,0.107342 -1.812268,5.992146 5.532698,4.379388 5.137307,-0.107342 z'/>
- <path class='logo'
- d='m 44.329732,23.050637 c 0.850982,5.097305 -5.250434,4.558924 -7.144836,4.752415 -6.418993,1.64391 -1.872992,-7.49274 -3.541914,-10.942842 -2.499646,-3.817859 5.939283,-4.402698 3.538545,-0.13612 -1.287874,4.989123 4.215411,-1.154796 5.956717,2.809584 0.840273,0.970849 1.168829,2.272413 1.191488,3.516963 z m -3.519477,-0.09299 c -1.398216,-5.518069 -6.361061,2.717467 -0.984368,1.810718 0.686994,-0.30388 1.029454,-1.087638 0.984368,-1.810718 z'/>
- <path class='logo'
- d='m 52.234961,23.301163 c 0.954818,5.035675 -8.606408,6.284861 -6.262292,1.674914 6.000358,-1.604717 -5.188764,-7.870044 1.75972,-10.384908 2.288682,-3.253567 6.399287,3.075831 2.304111,2.48058 -2.124941,2.016587 2.688777,3.89858 2.198472,6.229403 z'/>
- <path class='logo'
- d='m 60.204336,21.349224 c -4.894917,-1.916474 -3.458707,5.391212 0.347494,3.37231 2.120589,6.821713 -10.599623,1.664746 -6.906229,-3.691132 0.354172,-3.663246 9.875349,-4.711252 6.558735,0.318822 z'/>
- <path class='logo'
- d='m 71.730617,20.654299 c 0.0013,2.316285 0.190131,4.655698 0.07825,6.958009 -6.532419,3.303565 -0.660423,-8.722256 -6.009639,-5.821653 -0.818815,2.024533 1.726403,6.746337 -1.95327,6.005484 -3.458346,-1.137537 -0.696275,-7.713407 -1.833252,-10.994208 -2.308916,-3.710131 5.93704,-4.164951 3.518609,0.0063 -1.462376,6.166445 5.169629,-2.857523 6.19931,3.846079 z'/>
- <path class='logo'
- d='m 82.245738,22.378957 c -0.24581,2.448954 -9.386766,0.8867 -3.885979,2.877055 3.312576,-2.99157 5.250902,3.334514 0.482647,2.665545 -7.415384,1.492275 -7.823196,-11.597641 -0.275476,-10.032117 2.068161,0.391458 3.682204,2.408824 3.678808,4.489517 z m -3.414436,-0.578473 c -1.124703,-4.072004 -5.087405,2.125488 -0.316922,0.156453 z'/>
- <path class='logo'
- d='m 98.936899,27.222794 c -4.73541,2.718339 -3.1239,-3.406557 -3.92611,-6.050494 -4.66985,-1.438471 0.21621,6.932413 -3.41219,6.438039 -4.46096,1.160054 -0.22824,-5.774711 -3.31526,-6.700429 -3.410722,1.082173 1.04451,9.536575 -4.745091,6.372895 0.746632,-3.355214 -2.776394,-10.269232 3.034971,-9.038963 -0.058,2.544602 5.00686,-2.785359 6.00342,1.37844 3.42021,-4.316316 7.851251,0.524966 6.24018,4.690538 0.0379,0.969988 0.0954,1.940046 0.12008,2.909974 z'/>
- <path class='logo'
- d='m 110.47859,22.686058 c 0.91826,2.682088 0.13016,6.890551 -3.0725,4.397004 -1.63641,1.077877 -7.664291,0.541832 -7.09365,-4.114836 -0.907891,-4.692933 5.14729,-5.625578 7.24058,-4.40354 3.85932,-1.686263 3.13176,1.271515 2.92557,4.121372 z m -3.12695,0.0704 c -1.46278,-5.460062 -6.61615,2.5826 -1.08221,1.782003 0.70431,-0.272594 1.13111,-1.037444 1.08221,-1.782003 z'/>
- </a>
- </g>
- <g transform='translate(0,110)'>
- <!-- == Fk 'qrtz_blob_triggers_qrtz_blob_triggers_ibfk_1' == -->
- <path id='qrtz_blob_triggers_qrtz_blob_triggers_ibfk_1'
- onmouseover="hghl(['qrtz_blob_triggers_qrtz_blob_triggers_ibfk_1','ry.qrtz_blob_triggers.sched_name','ry.qrtz_blob_triggers.trigger_name','ry.qrtz_blob_triggers.trigger_group','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])"
- onmouseout="uhghl(['qrtz_blob_triggers_qrtz_blob_triggers_ibfk_1','ry.qrtz_blob_triggers.sched_name','ry.qrtz_blob_triggers.trigger_name','ry.qrtz_blob_triggers.trigger_group','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])"
- transform='translate(7,0)' class='scene' d='M 270 525 L 270,480'>
- <title>Fk qrtz_blob_triggers_ibfk_1
- qrtz_blob_triggers ref qrtz_triggers ( sched_name, trigger_name, trigger_group )</title>
- </path>
- <path transform='translate(7,0)' marker-start='url(#foot1)' marker-end='url(#arrow1)'
- d='M 270 525 L 270,480'></path>
- <text x='272' y='520' transform='rotate(270 272,520)' title='Fk qrtz_blob_triggers_ibfk_1
- qrtz_blob_triggers ref qrtz_triggers ( sched_name, trigger_name, trigger_group )' class='relName' style='fill:#5f789f'>
- sched_name,trigger_name,trigger_group
- </text>
- <!-- == Fk 'qrtz_cron_triggers_qrtz_cron_triggers_ibfk_1' == -->
- <path id='qrtz_cron_triggers_qrtz_cron_triggers_ibfk_1'
- onmouseover="hghl(['qrtz_cron_triggers_qrtz_cron_triggers_ibfk_1','ry.qrtz_cron_triggers.sched_name','ry.qrtz_cron_triggers.trigger_name','ry.qrtz_cron_triggers.trigger_group','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])"
- onmouseout="uhghl(['qrtz_cron_triggers_qrtz_cron_triggers_ibfk_1','ry.qrtz_cron_triggers.sched_name','ry.qrtz_cron_triggers.trigger_name','ry.qrtz_cron_triggers.trigger_group','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])"
- transform='translate(7,0)' class='scene'
- d='M 420 540 L 397,540 Q 390,540 390,532 L 390,472 Q 390,465 382,465 L 375,465'>
- <title>Fk qrtz_cron_triggers_ibfk_1
- qrtz_cron_triggers ref qrtz_triggers ( sched_name, trigger_name, trigger_group )</title>
- </path>
- <path transform='translate(7,0)' marker-start='url(#foot1)' marker-end='url(#arrow1)'
- d='M 420 540 L 397,540 Q 390,540 390,532 L 390,472 Q 390,465 382,465 L 375,465'></path>
- <text x='205' y='535' transform='rotate(0 205,535)' title='Fk qrtz_cron_triggers_ibfk_1
- qrtz_cron_triggers ref qrtz_triggers ( sched_name, trigger_name, trigger_group )' class='relName' style='fill:#5f789f'>
- sched_name,trigger_name,trigger_group
- </text>
- <!-- == Fk 'qrtz_simple_triggers_qrtz_simple_triggers_ibfk_1' == -->
- <path id='qrtz_simple_triggers_qrtz_simple_triggers_ibfk_1'
- onmouseover="hghl(['qrtz_simple_triggers_qrtz_simple_triggers_ibfk_1','ry.qrtz_simple_triggers.sched_name','ry.qrtz_simple_triggers.trigger_name','ry.qrtz_simple_triggers.trigger_group','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])"
- onmouseout="uhghl(['qrtz_simple_triggers_qrtz_simple_triggers_ibfk_1','ry.qrtz_simple_triggers.sched_name','ry.qrtz_simple_triggers.trigger_name','ry.qrtz_simple_triggers.trigger_group','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])"
- transform='translate(7,0)' class='scene'
- d='M 180 525 L 180,502 Q 180,495 187,495 L 277,495 Q 285,495 285,487 L 285,480'>
- <title>Fk qrtz_simple_triggers_ibfk_1
- qrtz_simple_triggers ref qrtz_triggers ( sched_name, trigger_name, trigger_group )</title>
- </path>
- <path transform='translate(7,0)' marker-start='url(#foot1)' marker-end='url(#arrow1)'
- d='M 180 525 L 180,502 Q 180,495 187,495 L 277,495 Q 285,495 285,487 L 285,480'></path>
- <text x='182' y='520' transform='rotate(270 182,520)' title='Fk qrtz_simple_triggers_ibfk_1
- qrtz_simple_triggers ref qrtz_triggers ( sched_name, trigger_name, trigger_group )' class='relName'
- style='fill:#5f789f'>sched_name,trigger_name,trigger_group
- </text>
- <!-- == Fk 'qrtz_simprop_triggers_qrtz_simprop_triggers_ibfk_1' == -->
- <path id='qrtz_simprop_triggers_qrtz_simprop_triggers_ibfk_1'
- onmouseover="hghl(['qrtz_simprop_triggers_qrtz_simprop_triggers_ibfk_1','ry.qrtz_simprop_triggers.sched_name','ry.qrtz_simprop_triggers.trigger_name','ry.qrtz_simprop_triggers.trigger_group','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])"
- onmouseout="uhghl(['qrtz_simprop_triggers_qrtz_simprop_triggers_ibfk_1','ry.qrtz_simprop_triggers.sched_name','ry.qrtz_simprop_triggers.trigger_name','ry.qrtz_simprop_triggers.trigger_group','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])"
- transform='translate(7,0)' class='scene' d='M 195 240 L 240,240'>
- <title>Fk qrtz_simprop_triggers_ibfk_1
- qrtz_simprop_triggers ref qrtz_triggers ( sched_name, trigger_name, trigger_group )</title>
- </path>
- <path transform='translate(7,0)' marker-start='url(#foot1)' marker-end='url(#arrow1)'
- d='M 195 240 L 240,240'></path>
- <text x='202' y='235' transform='rotate(0 202,235)' title='Fk qrtz_simprop_triggers_ibfk_1
- qrtz_simprop_triggers ref qrtz_triggers ( sched_name, trigger_name, trigger_group )' class='relName'
- style='fill:#5f789f'>sched_name,trigger_name,trigger_group
- </text>
- <!-- == Fk 'qrtz_triggers_qrtz_triggers_ibfk_1' == -->
- <path id='qrtz_triggers_qrtz_triggers_ibfk_1'
- onmouseover="hghl(['qrtz_triggers_qrtz_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.job_name','ry.qrtz_triggers.job_group','ry.qrtz_job_details.sched_name','ry.qrtz_job_details.job_name','ry.qrtz_job_details.job_group'])"
- onmouseout="uhghl(['qrtz_triggers_qrtz_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.job_name','ry.qrtz_triggers.job_group','ry.qrtz_job_details.sched_name','ry.qrtz_job_details.job_name','ry.qrtz_job_details.job_group'])"
- transform='translate(7,0)' class='scene' d='M 375 210 L 420,210'>
- <title>Fk qrtz_triggers_ibfk_1
- qrtz_triggers ref qrtz_job_details ( sched_name, job_name, job_group )</title>
- </path>
- <path transform='translate(7,0)' marker-start='url(#foot1p)' marker-end='url(#arrow1)'
- d='M 375 210 L 420,210'></path>
- <text x='382' y='205' transform='rotate(0 382,205)' title='Fk qrtz_triggers_ibfk_1
- qrtz_triggers ref qrtz_job_details ( sched_name, job_name, job_group )' class='relName' style='fill:#5f789f'>
- sched_name,job_name,job_group
- </text>
- <!-- == Table 'qrtz_blob_triggers' == -->
- <rect class='entity' x='255' y='533' width='120' height='105' rx='7' ry='7' style='stroke:none'/>
- <path d='M 255 559 L 255 540 Q 255 533 262 533 L 368 533 Q 375 533 375 540 L 375 559 L255 559 '
- style='fill:url(#tbg_bfd4f5);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='255' y='533' width='120' height='105' rx='7' ry='7'
- style='fill:none;stroke:#5f656e'/>
- <line class='delim' x1='255' y1='559' x2='375' y2='559' style='stroke:#5f656e'/>
- <line class='delim' x1='270' y1='559' x2='270' y2='638' style='stroke:#5f656e'/>
- <line class='delim' x1='364' y1='559' x2='364' y2='638' style='stroke:#5f656e'/>
- <a xlink:href='#qrtz_blob_triggers'>
- <text x='258' y='551'>qrtz_blob_triggers</text>
- <title>Table ry.qrtz_blob_triggers</title></a>
- <use id='nn' x='257' y='567' xlink:href='#nn'/>
- <a xlink:href='#qrtz_blob_triggers.sched_name'>
- <use id='pk' x='257' y='566' xlink:href='#pk'/>
- <title>Pk pk_qrtz_blob_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <a xlink:href='#qrtz_blob_triggers.sched_name'>
- <text id='ry.qrtz_blob_triggers.sched_name' x='273' y='576'
- onmouseover="hghl(['qrtz_blob_triggers_qrtz_blob_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])"
- onmouseout="uhghl(['qrtz_blob_triggers_qrtz_blob_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])">
- sched_name
- </text>
- <title>sched_name
- * varchar(120)</title></a>
- <a xlink:href='#qrtz_blob_triggers.sched_name'>
- <use id='fk' x='364' y='566' xlink:href='#fk'/>
- <title>References qrtz_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <use id='nn' x='257' y='582' xlink:href='#nn'/>
- <a xlink:href='#qrtz_blob_triggers.trigger_name'>
- <use id='pk' x='257' y='581' xlink:href='#pk'/>
- <title>Pk pk_qrtz_blob_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <a xlink:href='#qrtz_blob_triggers.trigger_name'>
- <text id='ry.qrtz_blob_triggers.trigger_name' x='273' y='591'
- onmouseover="hghl(['qrtz_blob_triggers_qrtz_blob_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])"
- onmouseout="uhghl(['qrtz_blob_triggers_qrtz_blob_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])">
- trigger_name
- </text>
- <title>trigger_name
- * varchar(200)</title></a>
- <a xlink:href='#qrtz_blob_triggers.trigger_name'>
- <use id='fk' x='364' y='581' xlink:href='#fk'/>
- <title>References qrtz_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <use id='nn' x='257' y='597' xlink:href='#nn'/>
- <a xlink:href='#qrtz_blob_triggers.trigger_group'>
- <use id='pk' x='257' y='596' xlink:href='#pk'/>
- <title>Pk pk_qrtz_blob_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <a xlink:href='#qrtz_blob_triggers.trigger_group'>
- <text id='ry.qrtz_blob_triggers.trigger_group' x='273' y='606'
- onmouseover="hghl(['qrtz_blob_triggers_qrtz_blob_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])"
- onmouseout="uhghl(['qrtz_blob_triggers_qrtz_blob_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])">
- trigger_group
- </text>
- <title>trigger_group
- * varchar(200)</title></a>
- <a xlink:href='#qrtz_blob_triggers.trigger_group'>
- <use id='fk' x='364' y='596' xlink:href='#fk'/>
- <title>References qrtz_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <a xlink:href='#qrtz_blob_triggers.blob_data'>
- <text id='ry.qrtz_blob_triggers.blob_data' x='273' y='621'>blob_data</text>
- <title>blob_data
- blob</title></a>
- <text x='372' y='618' text-anchor='end' class='colType'>~</text>
- <!-- == Table 'qrtz_calendars' == -->
- <rect class='entity' x='75' y='38' width='120' height='90' rx='7' ry='7' style='stroke:none'/>
- <path d='M 75 64 L 75 45 Q 75 38 82 38 L 188 38 Q 195 38 195 45 L 195 64 L75 64 '
- style='fill:url(#tbg_bfd4f5);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='75' y='38' width='120' height='90' rx='7' ry='7' style='fill:none;stroke:#5f656e'/>
- <line class='delim' x1='75' y1='64' x2='195' y2='64' style='stroke:#5f656e'/>
- <line class='delim' x1='90' y1='64' x2='90' y2='128' style='stroke:#5f656e'/>
- <line class='delim' x1='184' y1='64' x2='184' y2='128' style='stroke:#5f656e'/>
- <a xlink:href='#qrtz_calendars'>
- <text x='90' y='56'>qrtz_calendars</text>
- <title>Table ry.qrtz_calendars</title></a>
- <use id='nn' x='77' y='72' xlink:href='#nn'/>
- <a xlink:href='#qrtz_calendars.sched_name'>
- <use id='pk' x='77' y='71' xlink:href='#pk'/>
- <title>Pk pk_qrtz_calendars ( sched_name, calendar_name ) </title></a>
- <a xlink:href='#qrtz_calendars.sched_name'>
- <text id='ry.qrtz_calendars.sched_name' x='93' y='81'>sched_name</text>
- <title>sched_name
- * varchar(120)</title></a>
- <text x='192' y='78' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='77' y='87' xlink:href='#nn'/>
- <a xlink:href='#qrtz_calendars.calendar_name'>
- <use id='pk' x='77' y='86' xlink:href='#pk'/>
- <title>Pk pk_qrtz_calendars ( sched_name, calendar_name ) </title></a>
- <a xlink:href='#qrtz_calendars.calendar_name'>
- <text id='ry.qrtz_calendars.calendar_name' x='93' y='96'>calendar_name</text>
- <title>calendar_name
- * varchar(200)</title></a>
- <text x='192' y='93' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='77' y='102' xlink:href='#nn'/>
- <a xlink:href='#qrtz_calendars.calendar'>
- <text id='ry.qrtz_calendars.calendar' x='93' y='111'>calendar</text>
- <title>calendar
- * blob</title></a>
- <text x='192' y='108' text-anchor='end' class='colType'>~</text>
- <!-- == Table 'qrtz_cron_triggers' == -->
- <rect class='entity' x='435' y='533' width='135' height='120' rx='7' ry='7' style='stroke:none'/>
- <path d='M 435 559 L 435 540 Q 435 533 442 533 L 563 533 Q 570 533 570 540 L 570 559 L435 559 '
- style='fill:url(#tbg_bfd4f5);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='435' y='533' width='135' height='120' rx='7' ry='7'
- style='fill:none;stroke:#5f656e'/>
- <line class='delim' x1='435' y1='559' x2='570' y2='559' style='stroke:#5f656e'/>
- <line class='delim' x1='450' y1='559' x2='450' y2='653' style='stroke:#5f656e'/>
- <line class='delim' x1='559' y1='559' x2='559' y2='653' style='stroke:#5f656e'/>
- <a xlink:href='#qrtz_cron_triggers'>
- <text x='445' y='551'>qrtz_cron_triggers</text>
- <title>Table ry.qrtz_cron_triggers</title></a>
- <use id='nn' x='437' y='567' xlink:href='#nn'/>
- <a xlink:href='#qrtz_cron_triggers.sched_name'>
- <use id='pk' x='437' y='566' xlink:href='#pk'/>
- <title>Pk pk_qrtz_cron_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <a xlink:href='#qrtz_cron_triggers.sched_name'>
- <text id='ry.qrtz_cron_triggers.sched_name' x='453' y='576'
- onmouseover="hghl(['qrtz_cron_triggers_qrtz_cron_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])"
- onmouseout="uhghl(['qrtz_cron_triggers_qrtz_cron_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])">
- sched_name
- </text>
- <title>sched_name
- * varchar(120)</title></a>
- <a xlink:href='#qrtz_cron_triggers.sched_name'>
- <use id='fk' x='559' y='566' xlink:href='#fk'/>
- <title>References qrtz_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <use id='nn' x='437' y='582' xlink:href='#nn'/>
- <a xlink:href='#qrtz_cron_triggers.trigger_name'>
- <use id='pk' x='437' y='581' xlink:href='#pk'/>
- <title>Pk pk_qrtz_cron_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <a xlink:href='#qrtz_cron_triggers.trigger_name'>
- <text id='ry.qrtz_cron_triggers.trigger_name' x='453' y='591'
- onmouseover="hghl(['qrtz_cron_triggers_qrtz_cron_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])"
- onmouseout="uhghl(['qrtz_cron_triggers_qrtz_cron_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])">
- trigger_name
- </text>
- <title>trigger_name
- * varchar(200)</title></a>
- <a xlink:href='#qrtz_cron_triggers.trigger_name'>
- <use id='fk' x='559' y='581' xlink:href='#fk'/>
- <title>References qrtz_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <use id='nn' x='437' y='597' xlink:href='#nn'/>
- <a xlink:href='#qrtz_cron_triggers.trigger_group'>
- <use id='pk' x='437' y='596' xlink:href='#pk'/>
- <title>Pk pk_qrtz_cron_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <a xlink:href='#qrtz_cron_triggers.trigger_group'>
- <text id='ry.qrtz_cron_triggers.trigger_group' x='453' y='606'
- onmouseover="hghl(['qrtz_cron_triggers_qrtz_cron_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])"
- onmouseout="uhghl(['qrtz_cron_triggers_qrtz_cron_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])">
- trigger_group
- </text>
- <title>trigger_group
- * varchar(200)</title></a>
- <a xlink:href='#qrtz_cron_triggers.trigger_group'>
- <use id='fk' x='559' y='596' xlink:href='#fk'/>
- <title>References qrtz_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <use id='nn' x='437' y='612' xlink:href='#nn'/>
- <a xlink:href='#qrtz_cron_triggers.cron_expression'>
- <text id='ry.qrtz_cron_triggers.cron_expression' x='453' y='621'>cron_expression</text>
- <title>cron_expression
- * varchar(200)</title></a>
- <text x='567' y='618' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#qrtz_cron_triggers.time_zone_id'>
- <text id='ry.qrtz_cron_triggers.time_zone_id' x='453' y='636'>time_zone_id</text>
- <title>time_zone_id
- varchar(80)</title></a>
- <text x='567' y='633' text-anchor='end' class='colType'>t</text>
- <!-- == Table 'qrtz_job_details' == -->
- <rect class='entity' x='435' y='188' width='135' height='195' rx='7' ry='7' style='stroke:none'/>
- <path d='M 435 214 L 435 195 Q 435 188 442 188 L 563 188 Q 570 188 570 195 L 570 214 L435 214 '
- style='fill:url(#tbg_bfd4f5);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='435' y='188' width='135' height='195' rx='7' ry='7'
- style='fill:none;stroke:#5f656e'/>
- <line class='delim' x1='435' y1='214' x2='570' y2='214' style='stroke:#5f656e'/>
- <line class='delim' x1='450' y1='214' x2='450' y2='383' style='stroke:#5f656e'/>
- <line class='delim' x1='559' y1='214' x2='559' y2='383' style='stroke:#5f656e'/>
- <a xlink:href='#qrtz_job_details'>
- <text x='451' y='206'>qrtz_job_details</text>
- <title>Table ry.qrtz_job_details</title></a>
- <use id='nn' x='437' y='222' xlink:href='#nn'/>
- <a xlink:href='#qrtz_job_details.sched_name'>
- <use id='pk' x='437' y='221' xlink:href='#pk'/>
- <title>Pk pk_qrtz_job_details ( sched_name, job_name, job_group ) </title></a>
- <a xlink:href='#qrtz_job_details.sched_name'>
- <text id='ry.qrtz_job_details.sched_name' x='453' y='231'
- onmouseover="hghl(['qrtz_triggers_qrtz_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.job_name','ry.qrtz_triggers.job_group'])"
- onmouseout="uhghl(['qrtz_triggers_qrtz_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.job_name','ry.qrtz_triggers.job_group'])">
- sched_name
- </text>
- <title>sched_name
- * varchar(120)</title></a>
- <a xlink:href='#qrtz_job_details.sched_name'>
- <use id='ref' x='559' y='221' xlink:href='#ref'/>
- <title>Referred by qrtz_triggers ( sched_name, job_name, job_group ) </title></a>
- <use id='nn' x='437' y='237' xlink:href='#nn'/>
- <a xlink:href='#qrtz_job_details.job_name'>
- <use id='pk' x='437' y='236' xlink:href='#pk'/>
- <title>Pk pk_qrtz_job_details ( sched_name, job_name, job_group ) </title></a>
- <a xlink:href='#qrtz_job_details.job_name'>
- <text id='ry.qrtz_job_details.job_name' x='453' y='246'
- onmouseover="hghl(['qrtz_triggers_qrtz_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.job_name','ry.qrtz_triggers.job_group'])"
- onmouseout="uhghl(['qrtz_triggers_qrtz_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.job_name','ry.qrtz_triggers.job_group'])">
- job_name
- </text>
- <title>job_name
- * varchar(200)</title></a>
- <a xlink:href='#qrtz_job_details.job_name'>
- <use id='ref' x='559' y='236' xlink:href='#ref'/>
- <title>Referred by qrtz_triggers ( sched_name, job_name, job_group ) </title></a>
- <use id='nn' x='437' y='252' xlink:href='#nn'/>
- <a xlink:href='#qrtz_job_details.job_group'>
- <use id='pk' x='437' y='251' xlink:href='#pk'/>
- <title>Pk pk_qrtz_job_details ( sched_name, job_name, job_group ) </title></a>
- <a xlink:href='#qrtz_job_details.job_group'>
- <text id='ry.qrtz_job_details.job_group' x='453' y='261'
- onmouseover="hghl(['qrtz_triggers_qrtz_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.job_name','ry.qrtz_triggers.job_group'])"
- onmouseout="uhghl(['qrtz_triggers_qrtz_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.job_name','ry.qrtz_triggers.job_group'])">
- job_group
- </text>
- <title>job_group
- * varchar(200)</title></a>
- <a xlink:href='#qrtz_job_details.job_group'>
- <use id='ref' x='559' y='251' xlink:href='#ref'/>
- <title>Referred by qrtz_triggers ( sched_name, job_name, job_group ) </title></a>
- <a xlink:href='#qrtz_job_details.description'>
- <text id='ry.qrtz_job_details.description' x='453' y='276'>description</text>
- <title>description
- varchar(250)</title></a>
- <text x='567' y='273' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='437' y='282' xlink:href='#nn'/>
- <a xlink:href='#qrtz_job_details.job_class_name'>
- <text id='ry.qrtz_job_details.job_class_name' x='453' y='291'>job_class_name</text>
- <title>job_class_name
- * varchar(250)</title></a>
- <text x='567' y='288' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='437' y='297' xlink:href='#nn'/>
- <a xlink:href='#qrtz_job_details.is_durable'>
- <text id='ry.qrtz_job_details.is_durable' x='453' y='306'>is_durable</text>
- <title>is_durable
- * varchar(1)</title></a>
- <text x='567' y='303' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='437' y='312' xlink:href='#nn'/>
- <a xlink:href='#qrtz_job_details.is_nonconcurrent'>
- <text id='ry.qrtz_job_details.is_nonconcurrent' x='453' y='321'>is_nonconcurrent</text>
- <title>is_nonconcurrent
- * varchar(1)</title></a>
- <text x='567' y='318' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='437' y='327' xlink:href='#nn'/>
- <a xlink:href='#qrtz_job_details.is_update_data'>
- <text id='ry.qrtz_job_details.is_update_data' x='453' y='336'>is_update_data</text>
- <title>is_update_data
- * varchar(1)</title></a>
- <text x='567' y='333' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='437' y='342' xlink:href='#nn'/>
- <a xlink:href='#qrtz_job_details.requests_recovery'>
- <text id='ry.qrtz_job_details.requests_recovery' x='453' y='351'>requests_recovery</text>
- <title>requests_recovery
- * varchar(1)</title></a>
- <text x='567' y='348' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#qrtz_job_details.job_data'>
- <text id='ry.qrtz_job_details.job_data' x='453' y='366'>job_data</text>
- <title>job_data
- blob</title></a>
- <text x='567' y='363' text-anchor='end' class='colType'>~</text>
- <!-- == Table 'qrtz_locks' == -->
- <rect class='entity' x='255' y='53' width='105' height='75' rx='7' ry='7' style='stroke:none'/>
- <path d='M 255 79 L 255 60 Q 255 53 262 53 L 353 53 Q 360 53 360 60 L 360 79 L255 79 '
- style='fill:url(#tbg_bfd4f5);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='255' y='53' width='105' height='75' rx='7' ry='7' style='fill:none;stroke:#5f656e'/>
- <line class='delim' x1='255' y1='79' x2='360' y2='79' style='stroke:#5f656e'/>
- <line class='delim' x1='270' y1='79' x2='270' y2='128' style='stroke:#5f656e'/>
- <line class='delim' x1='349' y1='79' x2='349' y2='128' style='stroke:#5f656e'/>
- <a xlink:href='#qrtz_locks'>
- <text x='274' y='71'>qrtz_locks</text>
- <title>Table ry.qrtz_locks</title></a>
- <use id='nn' x='257' y='87' xlink:href='#nn'/>
- <a xlink:href='#qrtz_locks.sched_name'>
- <use id='pk' x='257' y='86' xlink:href='#pk'/>
- <title>Pk pk_qrtz_locks ( sched_name, lock_name ) </title></a>
- <a xlink:href='#qrtz_locks.sched_name'>
- <text id='ry.qrtz_locks.sched_name' x='273' y='96'>sched_name</text>
- <title>sched_name
- * varchar(120)</title></a>
- <text x='357' y='93' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='257' y='102' xlink:href='#nn'/>
- <a xlink:href='#qrtz_locks.lock_name'>
- <use id='pk' x='257' y='101' xlink:href='#pk'/>
- <title>Pk pk_qrtz_locks ( sched_name, lock_name ) </title></a>
- <a xlink:href='#qrtz_locks.lock_name'>
- <text id='ry.qrtz_locks.lock_name' x='273' y='111'>lock_name</text>
- <title>lock_name
- * varchar(40)</title></a>
- <text x='357' y='108' text-anchor='end' class='colType'>t</text>
- <!-- == Table 'qrtz_scheduler_state' == -->
- <rect class='entity' x='255' y='728' width='135' height='105' rx='7' ry='7' style='stroke:none'/>
- <path d='M 255 754 L 255 735 Q 255 728 262 728 L 383 728 Q 390 728 390 735 L 390 754 L255 754 '
- style='fill:url(#tbg_bfd4f5);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='255' y='728' width='135' height='105' rx='7' ry='7'
- style='fill:none;stroke:#5f656e'/>
- <line class='delim' x1='255' y1='754' x2='390' y2='754' style='stroke:#5f656e'/>
- <line class='delim' x1='270' y1='754' x2='270' y2='833' style='stroke:#5f656e'/>
- <line class='delim' x1='379' y1='754' x2='379' y2='833' style='stroke:#5f656e'/>
- <a xlink:href='#qrtz_scheduler_state'>
- <text x='259' y='746'>qrtz_scheduler_state</text>
- <title>Table ry.qrtz_scheduler_state</title></a>
- <use id='nn' x='257' y='762' xlink:href='#nn'/>
- <a xlink:href='#qrtz_scheduler_state.sched_name'>
- <use id='pk' x='257' y='761' xlink:href='#pk'/>
- <title>Pk pk_qrtz_scheduler_state ( sched_name, instance_name ) </title></a>
- <a xlink:href='#qrtz_scheduler_state.sched_name'>
- <text id='ry.qrtz_scheduler_state.sched_name' x='273' y='771'>sched_name</text>
- <title>sched_name
- * varchar(120)</title></a>
- <text x='387' y='768' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='257' y='777' xlink:href='#nn'/>
- <a xlink:href='#qrtz_scheduler_state.instance_name'>
- <use id='pk' x='257' y='776' xlink:href='#pk'/>
- <title>Pk pk_qrtz_scheduler_state ( sched_name, instance_name ) </title></a>
- <a xlink:href='#qrtz_scheduler_state.instance_name'>
- <text id='ry.qrtz_scheduler_state.instance_name' x='273' y='786'>instance_name</text>
- <title>instance_name
- * varchar(200)</title></a>
- <text x='387' y='783' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='257' y='792' xlink:href='#nn'/>
- <a xlink:href='#qrtz_scheduler_state.last_checkin_time'>
- <text id='ry.qrtz_scheduler_state.last_checkin_time' x='273' y='801'>last_checkin_time</text>
- <title>last_checkin_time
- * bigint</title></a>
- <text x='387' y='798' text-anchor='end' class='colType'>#</text>
- <use id='nn' x='257' y='807' xlink:href='#nn'/>
- <a xlink:href='#qrtz_scheduler_state.checkin_interval'>
- <text id='ry.qrtz_scheduler_state.checkin_interval' x='273' y='816'>checkin_interval</text>
- <title>checkin_interval
- * bigint</title></a>
- <text x='387' y='813' text-anchor='end' class='colType'>#</text>
- <!-- == Table 'qrtz_simple_triggers' == -->
- <rect class='entity' x='60' y='533' width='135' height='135' rx='7' ry='7' style='stroke:none'/>
- <path d='M 60 559 L 60 540 Q 60 533 67 533 L 188 533 Q 195 533 195 540 L 195 559 L60 559 '
- style='fill:url(#tbg_bfd4f5);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='60' y='533' width='135' height='135' rx='7' ry='7'
- style='fill:none;stroke:#5f656e'/>
- <line class='delim' x1='60' y1='559' x2='195' y2='559' style='stroke:#5f656e'/>
- <line class='delim' x1='75' y1='559' x2='75' y2='668' style='stroke:#5f656e'/>
- <line class='delim' x1='184' y1='559' x2='184' y2='668' style='stroke:#5f656e'/>
- <a xlink:href='#qrtz_simple_triggers'>
- <text x='64' y='551'>qrtz_simple_triggers</text>
- <title>Table ry.qrtz_simple_triggers</title></a>
- <use id='nn' x='62' y='567' xlink:href='#nn'/>
- <a xlink:href='#qrtz_simple_triggers.sched_name'>
- <use id='pk' x='62' y='566' xlink:href='#pk'/>
- <title>Pk pk_qrtz_simple_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <a xlink:href='#qrtz_simple_triggers.sched_name'>
- <text id='ry.qrtz_simple_triggers.sched_name' x='78' y='576'
- onmouseover="hghl(['qrtz_simple_triggers_qrtz_simple_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])"
- onmouseout="uhghl(['qrtz_simple_triggers_qrtz_simple_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])">
- sched_name
- </text>
- <title>sched_name
- * varchar(120)</title></a>
- <a xlink:href='#qrtz_simple_triggers.sched_name'>
- <use id='fk' x='184' y='566' xlink:href='#fk'/>
- <title>References qrtz_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <use id='nn' x='62' y='582' xlink:href='#nn'/>
- <a xlink:href='#qrtz_simple_triggers.trigger_name'>
- <use id='pk' x='62' y='581' xlink:href='#pk'/>
- <title>Pk pk_qrtz_simple_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <a xlink:href='#qrtz_simple_triggers.trigger_name'>
- <text id='ry.qrtz_simple_triggers.trigger_name' x='78' y='591'
- onmouseover="hghl(['qrtz_simple_triggers_qrtz_simple_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])"
- onmouseout="uhghl(['qrtz_simple_triggers_qrtz_simple_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])">
- trigger_name
- </text>
- <title>trigger_name
- * varchar(200)</title></a>
- <a xlink:href='#qrtz_simple_triggers.trigger_name'>
- <use id='fk' x='184' y='581' xlink:href='#fk'/>
- <title>References qrtz_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <use id='nn' x='62' y='597' xlink:href='#nn'/>
- <a xlink:href='#qrtz_simple_triggers.trigger_group'>
- <use id='pk' x='62' y='596' xlink:href='#pk'/>
- <title>Pk pk_qrtz_simple_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <a xlink:href='#qrtz_simple_triggers.trigger_group'>
- <text id='ry.qrtz_simple_triggers.trigger_group' x='78' y='606'
- onmouseover="hghl(['qrtz_simple_triggers_qrtz_simple_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])"
- onmouseout="uhghl(['qrtz_simple_triggers_qrtz_simple_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])">
- trigger_group
- </text>
- <title>trigger_group
- * varchar(200)</title></a>
- <a xlink:href='#qrtz_simple_triggers.trigger_group'>
- <use id='fk' x='184' y='596' xlink:href='#fk'/>
- <title>References qrtz_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <use id='nn' x='62' y='612' xlink:href='#nn'/>
- <a xlink:href='#qrtz_simple_triggers.repeat_count'>
- <text id='ry.qrtz_simple_triggers.repeat_count' x='78' y='621'>repeat_count</text>
- <title>repeat_count
- * bigint</title></a>
- <text x='192' y='618' text-anchor='end' class='colType'>#</text>
- <use id='nn' x='62' y='627' xlink:href='#nn'/>
- <a xlink:href='#qrtz_simple_triggers.repeat_interval'>
- <text id='ry.qrtz_simple_triggers.repeat_interval' x='78' y='636'>repeat_interval</text>
- <title>repeat_interval
- * bigint</title></a>
- <text x='192' y='633' text-anchor='end' class='colType'>#</text>
- <use id='nn' x='62' y='642' xlink:href='#nn'/>
- <a xlink:href='#qrtz_simple_triggers.times_triggered'>
- <text id='ry.qrtz_simple_triggers.times_triggered' x='78' y='651'>times_triggered</text>
- <title>times_triggered
- * bigint</title></a>
- <text x='192' y='648' text-anchor='end' class='colType'>#</text>
- <!-- == Table 'qrtz_simprop_triggers' == -->
- <rect class='entity' x='45' y='218' width='150' height='255' rx='7' ry='7' style='stroke:none'/>
- <path d='M 45 244 L 45 225 Q 45 218 52 218 L 188 218 Q 195 218 195 225 L 195 244 L45 244 '
- style='fill:url(#tbg_bfd4f5);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='45' y='218' width='150' height='255' rx='7' ry='7'
- style='fill:none;stroke:#5f656e'/>
- <line class='delim' x1='45' y1='244' x2='195' y2='244' style='stroke:#5f656e'/>
- <line class='delim' x1='60' y1='244' x2='60' y2='473' style='stroke:#5f656e'/>
- <line class='delim' x1='184' y1='244' x2='184' y2='473' style='stroke:#5f656e'/>
- <a xlink:href='#qrtz_simprop_triggers'>
- <text x='54' y='236'>qrtz_simprop_triggers</text>
- <title>Table ry.qrtz_simprop_triggers</title></a>
- <use id='nn' x='47' y='252' xlink:href='#nn'/>
- <a xlink:href='#qrtz_simprop_triggers.sched_name'>
- <use id='pk' x='47' y='251' xlink:href='#pk'/>
- <title>Pk pk_qrtz_simprop_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <a xlink:href='#qrtz_simprop_triggers.sched_name'>
- <text id='ry.qrtz_simprop_triggers.sched_name' x='63' y='261'
- onmouseover="hghl(['qrtz_simprop_triggers_qrtz_simprop_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])"
- onmouseout="uhghl(['qrtz_simprop_triggers_qrtz_simprop_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])">
- sched_name
- </text>
- <title>sched_name
- * varchar(120)</title></a>
- <a xlink:href='#qrtz_simprop_triggers.sched_name'>
- <use id='fk' x='184' y='251' xlink:href='#fk'/>
- <title>References qrtz_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <use id='nn' x='47' y='267' xlink:href='#nn'/>
- <a xlink:href='#qrtz_simprop_triggers.trigger_name'>
- <use id='pk' x='47' y='266' xlink:href='#pk'/>
- <title>Pk pk_qrtz_simprop_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <a xlink:href='#qrtz_simprop_triggers.trigger_name'>
- <text id='ry.qrtz_simprop_triggers.trigger_name' x='63' y='276'
- onmouseover="hghl(['qrtz_simprop_triggers_qrtz_simprop_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])"
- onmouseout="uhghl(['qrtz_simprop_triggers_qrtz_simprop_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])">
- trigger_name
- </text>
- <title>trigger_name
- * varchar(200)</title></a>
- <a xlink:href='#qrtz_simprop_triggers.trigger_name'>
- <use id='fk' x='184' y='266' xlink:href='#fk'/>
- <title>References qrtz_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <use id='nn' x='47' y='282' xlink:href='#nn'/>
- <a xlink:href='#qrtz_simprop_triggers.trigger_group'>
- <use id='pk' x='47' y='281' xlink:href='#pk'/>
- <title>Pk pk_qrtz_simprop_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <a xlink:href='#qrtz_simprop_triggers.trigger_group'>
- <text id='ry.qrtz_simprop_triggers.trigger_group' x='63' y='291'
- onmouseover="hghl(['qrtz_simprop_triggers_qrtz_simprop_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])"
- onmouseout="uhghl(['qrtz_simprop_triggers_qrtz_simprop_triggers_ibfk_1','ry.qrtz_triggers.sched_name','ry.qrtz_triggers.trigger_name','ry.qrtz_triggers.trigger_group'])">
- trigger_group
- </text>
- <title>trigger_group
- * varchar(200)</title></a>
- <a xlink:href='#qrtz_simprop_triggers.trigger_group'>
- <use id='fk' x='184' y='281' xlink:href='#fk'/>
- <title>References qrtz_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <a xlink:href='#qrtz_simprop_triggers.str_prop_1'>
- <text id='ry.qrtz_simprop_triggers.str_prop_1' x='63' y='306'>str_prop_1</text>
- <title>str_prop_1
- varchar(512)</title></a>
- <text x='192' y='303' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#qrtz_simprop_triggers.str_prop_2'>
- <text id='ry.qrtz_simprop_triggers.str_prop_2' x='63' y='321'>str_prop_2</text>
- <title>str_prop_2
- varchar(512)</title></a>
- <text x='192' y='318' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#qrtz_simprop_triggers.str_prop_3'>
- <text id='ry.qrtz_simprop_triggers.str_prop_3' x='63' y='336'>str_prop_3</text>
- <title>str_prop_3
- varchar(512)</title></a>
- <text x='192' y='333' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#qrtz_simprop_triggers.int_prop_1'>
- <text id='ry.qrtz_simprop_triggers.int_prop_1' x='63' y='351'>int_prop_1</text>
- <title>int_prop_1
- int</title></a>
- <text x='192' y='348' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#qrtz_simprop_triggers.int_prop_2'>
- <text id='ry.qrtz_simprop_triggers.int_prop_2' x='63' y='366'>int_prop_2</text>
- <title>int_prop_2
- int</title></a>
- <text x='192' y='363' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#qrtz_simprop_triggers.long_prop_1'>
- <text id='ry.qrtz_simprop_triggers.long_prop_1' x='63' y='381'>long_prop_1</text>
- <title>long_prop_1
- bigint</title></a>
- <text x='192' y='378' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#qrtz_simprop_triggers.long_prop_2'>
- <text id='ry.qrtz_simprop_triggers.long_prop_2' x='63' y='396'>long_prop_2</text>
- <title>long_prop_2
- bigint</title></a>
- <text x='192' y='393' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#qrtz_simprop_triggers.dec_prop_1'>
- <text id='ry.qrtz_simprop_triggers.dec_prop_1' x='63' y='411'>dec_prop_1</text>
- <title>dec_prop_1
- decimal(13,4)</title></a>
- <text x='192' y='408' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#qrtz_simprop_triggers.dec_prop_2'>
- <text id='ry.qrtz_simprop_triggers.dec_prop_2' x='63' y='426'>dec_prop_2</text>
- <title>dec_prop_2
- decimal(13,4)</title></a>
- <text x='192' y='423' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#qrtz_simprop_triggers.bool_prop_1'>
- <text id='ry.qrtz_simprop_triggers.bool_prop_1' x='63' y='441'>bool_prop_1</text>
- <title>bool_prop_1
- varchar(1)</title></a>
- <text x='192' y='438' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#qrtz_simprop_triggers.bool_prop_2'>
- <text id='ry.qrtz_simprop_triggers.bool_prop_2' x='63' y='456'>bool_prop_2</text>
- <title>bool_prop_2
- varchar(1)</title></a>
- <text x='192' y='453' text-anchor='end' class='colType'>t</text>
- <!-- == Table 'qrtz_triggers' == -->
- <rect class='entity' x='255' y='188' width='120' height='285' rx='7' ry='7' style='stroke:none'/>
- <path d='M 255 214 L 255 195 Q 255 188 262 188 L 368 188 Q 375 188 375 195 L 375 214 L255 214 '
- style='fill:url(#tbg_bfd4f5);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='255' y='188' width='120' height='285' rx='7' ry='7'
- style='fill:none;stroke:#5f656e'/>
- <line class='delim' x1='255' y1='214' x2='375' y2='214' style='stroke:#5f656e'/>
- <line class='delim' x1='270' y1='214' x2='270' y2='473' style='stroke:#5f656e'/>
- <line class='delim' x1='364' y1='214' x2='364' y2='473' style='stroke:#5f656e'/>
- <a xlink:href='#qrtz_triggers'>
- <text x='273' y='206'>qrtz_triggers</text>
- <title>Table ry.qrtz_triggers</title></a>
- <use id='nn' x='257' y='222' xlink:href='#nn'/>
- <a xlink:href='#qrtz_triggers.sched_name'>
- <use id='pk' x='257' y='221' xlink:href='#pk'/>
- <title>Pk pk_qrtz_triggers ( sched_name, trigger_name, trigger_group ) sched_name ( sched_name,
- job_name, job_group ) </title></a>
- <a xlink:href='#qrtz_triggers.sched_name'>
- <text id='ry.qrtz_triggers.sched_name' x='273' y='231'
- onmouseover="hghl(['qrtz_triggers_qrtz_triggers_ibfk_1','ry.qrtz_job_details.sched_name','ry.qrtz_job_details.job_name','ry.qrtz_job_details.job_group','qrtz_blob_triggers_qrtz_blob_triggers_ibfk_1','ry.qrtz_blob_triggers.sched_name','ry.qrtz_blob_triggers.trigger_name','ry.qrtz_blob_triggers.trigger_group','qrtz_cron_triggers_qrtz_cron_triggers_ibfk_1','ry.qrtz_cron_triggers.sched_name','ry.qrtz_cron_triggers.trigger_name','ry.qrtz_cron_triggers.trigger_group','qrtz_simple_triggers_qrtz_simple_triggers_ibfk_1','ry.qrtz_simple_triggers.sched_name','ry.qrtz_simple_triggers.trigger_name','ry.qrtz_simple_triggers.trigger_group','qrtz_simprop_triggers_qrtz_simprop_triggers_ibfk_1','ry.qrtz_simprop_triggers.sched_name','ry.qrtz_simprop_triggers.trigger_name','ry.qrtz_simprop_triggers.trigger_group'])"
- onmouseout="uhghl(['qrtz_triggers_qrtz_triggers_ibfk_1','ry.qrtz_job_details.sched_name','ry.qrtz_job_details.job_name','ry.qrtz_job_details.job_group','qrtz_blob_triggers_qrtz_blob_triggers_ibfk_1','ry.qrtz_blob_triggers.sched_name','ry.qrtz_blob_triggers.trigger_name','ry.qrtz_blob_triggers.trigger_group','qrtz_cron_triggers_qrtz_cron_triggers_ibfk_1','ry.qrtz_cron_triggers.sched_name','ry.qrtz_cron_triggers.trigger_name','ry.qrtz_cron_triggers.trigger_group','qrtz_simple_triggers_qrtz_simple_triggers_ibfk_1','ry.qrtz_simple_triggers.sched_name','ry.qrtz_simple_triggers.trigger_name','ry.qrtz_simple_triggers.trigger_group','qrtz_simprop_triggers_qrtz_simprop_triggers_ibfk_1','ry.qrtz_simprop_triggers.sched_name','ry.qrtz_simprop_triggers.trigger_name','ry.qrtz_simprop_triggers.trigger_group'])">
- sched_name
- </text>
- <title>sched_name
- * varchar(120)</title></a>
- <a xlink:href='#qrtz_triggers.sched_name'>
- <use id='fk' x='364' y='221' xlink:href='#fk'/>
- <title>References qrtz_job_details ( sched_name, job_name, job_group )
- Referred by qrtz_blob_triggers ( sched_name, trigger_name, trigger_group )
- Referred by qrtz_cron_triggers ( sched_name, trigger_name, trigger_group )
- Referred by qrtz_simple_triggers ( sched_name, trigger_name, trigger_group )
- Referred by qrtz_simprop_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <use id='nn' x='257' y='237' xlink:href='#nn'/>
- <a xlink:href='#qrtz_triggers.trigger_name'>
- <use id='pk' x='257' y='236' xlink:href='#pk'/>
- <title>Pk pk_qrtz_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <a xlink:href='#qrtz_triggers.trigger_name'>
- <text id='ry.qrtz_triggers.trigger_name' x='273' y='246'
- onmouseover="hghl(['qrtz_blob_triggers_qrtz_blob_triggers_ibfk_1','ry.qrtz_blob_triggers.sched_name','ry.qrtz_blob_triggers.trigger_name','ry.qrtz_blob_triggers.trigger_group','qrtz_cron_triggers_qrtz_cron_triggers_ibfk_1','ry.qrtz_cron_triggers.sched_name','ry.qrtz_cron_triggers.trigger_name','ry.qrtz_cron_triggers.trigger_group','qrtz_simple_triggers_qrtz_simple_triggers_ibfk_1','ry.qrtz_simple_triggers.sched_name','ry.qrtz_simple_triggers.trigger_name','ry.qrtz_simple_triggers.trigger_group','qrtz_simprop_triggers_qrtz_simprop_triggers_ibfk_1','ry.qrtz_simprop_triggers.sched_name','ry.qrtz_simprop_triggers.trigger_name','ry.qrtz_simprop_triggers.trigger_group'])"
- onmouseout="uhghl(['qrtz_blob_triggers_qrtz_blob_triggers_ibfk_1','ry.qrtz_blob_triggers.sched_name','ry.qrtz_blob_triggers.trigger_name','ry.qrtz_blob_triggers.trigger_group','qrtz_cron_triggers_qrtz_cron_triggers_ibfk_1','ry.qrtz_cron_triggers.sched_name','ry.qrtz_cron_triggers.trigger_name','ry.qrtz_cron_triggers.trigger_group','qrtz_simple_triggers_qrtz_simple_triggers_ibfk_1','ry.qrtz_simple_triggers.sched_name','ry.qrtz_simple_triggers.trigger_name','ry.qrtz_simple_triggers.trigger_group','qrtz_simprop_triggers_qrtz_simprop_triggers_ibfk_1','ry.qrtz_simprop_triggers.sched_name','ry.qrtz_simprop_triggers.trigger_name','ry.qrtz_simprop_triggers.trigger_group'])">
- trigger_name
- </text>
- <title>trigger_name
- * varchar(200)</title></a>
- <a xlink:href='#qrtz_triggers.trigger_name'>
- <use id='ref' x='364' y='236' xlink:href='#ref'/>
- <title>Referred by qrtz_blob_triggers ( sched_name, trigger_name, trigger_group )
- Referred by qrtz_cron_triggers ( sched_name, trigger_name, trigger_group )
- Referred by qrtz_simple_triggers ( sched_name, trigger_name, trigger_group )
- Referred by qrtz_simprop_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <use id='nn' x='257' y='252' xlink:href='#nn'/>
- <a xlink:href='#qrtz_triggers.trigger_group'>
- <use id='pk' x='257' y='251' xlink:href='#pk'/>
- <title>Pk pk_qrtz_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <a xlink:href='#qrtz_triggers.trigger_group'>
- <text id='ry.qrtz_triggers.trigger_group' x='273' y='261'
- onmouseover="hghl(['qrtz_blob_triggers_qrtz_blob_triggers_ibfk_1','ry.qrtz_blob_triggers.sched_name','ry.qrtz_blob_triggers.trigger_name','ry.qrtz_blob_triggers.trigger_group','qrtz_cron_triggers_qrtz_cron_triggers_ibfk_1','ry.qrtz_cron_triggers.sched_name','ry.qrtz_cron_triggers.trigger_name','ry.qrtz_cron_triggers.trigger_group','qrtz_simple_triggers_qrtz_simple_triggers_ibfk_1','ry.qrtz_simple_triggers.sched_name','ry.qrtz_simple_triggers.trigger_name','ry.qrtz_simple_triggers.trigger_group','qrtz_simprop_triggers_qrtz_simprop_triggers_ibfk_1','ry.qrtz_simprop_triggers.sched_name','ry.qrtz_simprop_triggers.trigger_name','ry.qrtz_simprop_triggers.trigger_group'])"
- onmouseout="uhghl(['qrtz_blob_triggers_qrtz_blob_triggers_ibfk_1','ry.qrtz_blob_triggers.sched_name','ry.qrtz_blob_triggers.trigger_name','ry.qrtz_blob_triggers.trigger_group','qrtz_cron_triggers_qrtz_cron_triggers_ibfk_1','ry.qrtz_cron_triggers.sched_name','ry.qrtz_cron_triggers.trigger_name','ry.qrtz_cron_triggers.trigger_group','qrtz_simple_triggers_qrtz_simple_triggers_ibfk_1','ry.qrtz_simple_triggers.sched_name','ry.qrtz_simple_triggers.trigger_name','ry.qrtz_simple_triggers.trigger_group','qrtz_simprop_triggers_qrtz_simprop_triggers_ibfk_1','ry.qrtz_simprop_triggers.sched_name','ry.qrtz_simprop_triggers.trigger_name','ry.qrtz_simprop_triggers.trigger_group'])">
- trigger_group
- </text>
- <title>trigger_group
- * varchar(200)</title></a>
- <a xlink:href='#qrtz_triggers.trigger_group'>
- <use id='ref' x='364' y='251' xlink:href='#ref'/>
- <title>Referred by qrtz_blob_triggers ( sched_name, trigger_name, trigger_group )
- Referred by qrtz_cron_triggers ( sched_name, trigger_name, trigger_group )
- Referred by qrtz_simple_triggers ( sched_name, trigger_name, trigger_group )
- Referred by qrtz_simprop_triggers ( sched_name, trigger_name, trigger_group ) </title></a>
- <use id='nn' x='257' y='267' xlink:href='#nn'/>
- <a xlink:href='#qrtz_triggers.job_name'>
- <use id='idx' x='257' y='266' xlink:href='#idx'/>
- <title>sched_name ( sched_name, job_name, job_group ) </title></a>
- <a xlink:href='#qrtz_triggers.job_name'>
- <text id='ry.qrtz_triggers.job_name' x='273' y='276'
- onmouseover="hghl(['qrtz_triggers_qrtz_triggers_ibfk_1','ry.qrtz_job_details.sched_name','ry.qrtz_job_details.job_name','ry.qrtz_job_details.job_group'])"
- onmouseout="uhghl(['qrtz_triggers_qrtz_triggers_ibfk_1','ry.qrtz_job_details.sched_name','ry.qrtz_job_details.job_name','ry.qrtz_job_details.job_group'])">
- job_name
- </text>
- <title>job_name
- * varchar(200)</title></a>
- <a xlink:href='#qrtz_triggers.job_name'>
- <use id='fk' x='364' y='266' xlink:href='#fk'/>
- <title>References qrtz_job_details ( sched_name, job_name, job_group ) </title></a>
- <use id='nn' x='257' y='282' xlink:href='#nn'/>
- <a xlink:href='#qrtz_triggers.job_group'>
- <use id='idx' x='257' y='281' xlink:href='#idx'/>
- <title>sched_name ( sched_name, job_name, job_group ) </title></a>
- <a xlink:href='#qrtz_triggers.job_group'>
- <text id='ry.qrtz_triggers.job_group' x='273' y='291'
- onmouseover="hghl(['qrtz_triggers_qrtz_triggers_ibfk_1','ry.qrtz_job_details.sched_name','ry.qrtz_job_details.job_name','ry.qrtz_job_details.job_group'])"
- onmouseout="uhghl(['qrtz_triggers_qrtz_triggers_ibfk_1','ry.qrtz_job_details.sched_name','ry.qrtz_job_details.job_name','ry.qrtz_job_details.job_group'])">
- job_group
- </text>
- <title>job_group
- * varchar(200)</title></a>
- <a xlink:href='#qrtz_triggers.job_group'>
- <use id='fk' x='364' y='281' xlink:href='#fk'/>
- <title>References qrtz_job_details ( sched_name, job_name, job_group ) </title></a>
- <a xlink:href='#qrtz_triggers.description'>
- <text id='ry.qrtz_triggers.description' x='273' y='306'>description</text>
- <title>description
- varchar(250)</title></a>
- <text x='372' y='303' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#qrtz_triggers.next_fire_time'>
- <text id='ry.qrtz_triggers.next_fire_time' x='273' y='321'>next_fire_time</text>
- <title>next_fire_time
- bigint</title></a>
- <text x='372' y='318' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#qrtz_triggers.prev_fire_time'>
- <text id='ry.qrtz_triggers.prev_fire_time' x='273' y='336'>prev_fire_time</text>
- <title>prev_fire_time
- bigint</title></a>
- <text x='372' y='333' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#qrtz_triggers.priority'>
- <text id='ry.qrtz_triggers.priority' x='273' y='351'>priority</text>
- <title>priority
- int</title></a>
- <text x='372' y='348' text-anchor='end' class='colType'>#</text>
- <use id='nn' x='257' y='357' xlink:href='#nn'/>
- <a xlink:href='#qrtz_triggers.trigger_state'>
- <text id='ry.qrtz_triggers.trigger_state' x='273' y='366'>trigger_state</text>
- <title>trigger_state
- * varchar(16)</title></a>
- <text x='372' y='363' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='257' y='372' xlink:href='#nn'/>
- <a xlink:href='#qrtz_triggers.trigger_type'>
- <text id='ry.qrtz_triggers.trigger_type' x='273' y='381'>trigger_type</text>
- <title>trigger_type
- * varchar(8)</title></a>
- <text x='372' y='378' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='257' y='387' xlink:href='#nn'/>
- <a xlink:href='#qrtz_triggers.start_time'>
- <text id='ry.qrtz_triggers.start_time' x='273' y='396'>start_time</text>
- <title>start_time
- * bigint</title></a>
- <text x='372' y='393' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#qrtz_triggers.end_time'>
- <text id='ry.qrtz_triggers.end_time' x='273' y='411'>end_time</text>
- <title>end_time
- bigint</title></a>
- <text x='372' y='408' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#qrtz_triggers.calendar_name'>
- <text id='ry.qrtz_triggers.calendar_name' x='273' y='426'>calendar_name</text>
- <title>calendar_name
- varchar(200)</title></a>
- <text x='372' y='423' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#qrtz_triggers.misfire_instr'>
- <text id='ry.qrtz_triggers.misfire_instr' x='273' y='441'>misfire_instr</text>
- <title>misfire_instr
- smallint</title></a>
- <text x='372' y='438' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#qrtz_triggers.job_data'>
- <text id='ry.qrtz_triggers.job_data' x='273' y='456'>job_data</text>
- <title>job_data
- blob</title></a>
- <text x='372' y='453' text-anchor='end' class='colType'>~</text>
- <!-- == Table 'sys_dict_data' == -->
- <rect class='entity' x='1170' y='38' width='105' height='210' rx='7' ry='7' style='stroke:none'/>
- <path d='M 1170 64 L 1170 45 Q 1170 38 1177 38 L 1268 38 Q 1275 38 1275 45 L 1275 64 L1170 64 '
- style='fill:url(#tbg_c8f5bf);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='1170' y='38' width='105' height='210' rx='7' ry='7'
- style='fill:none;stroke:#626e5f'/>
- <line class='delim' x1='1170' y1='64' x2='1275' y2='64' style='stroke:#626e5f'/>
- <line class='delim' x1='1185' y1='64' x2='1185' y2='248' style='stroke:#626e5f'/>
- <line class='delim' x1='1264' y1='64' x2='1264' y2='248' style='stroke:#626e5f'/>
- <a xlink:href='#sys_dict_data'>
- <text x='1180' y='56'>sys_dict_data</text>
- <title>Table ry.sys_dict_data</title></a>
- <use id='nn' x='1172' y='72' xlink:href='#nn'/>
- <a xlink:href='#sys_dict_data.dict_code'>
- <use id='pk' x='1172' y='71' xlink:href='#pk'/>
- <title>Pk pk_sys_dict_data ( dict_code ) </title></a>
- <a xlink:href='#sys_dict_data.dict_code'>
- <text id='ry.sys_dict_data.dict_code' x='1188' y='81'>dict_code</text>
- <title>dict_code
- * int
- 字典编码</title></a>
- <text x='1272' y='78' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_dict_data.dict_sort'>
- <text id='ry.sys_dict_data.dict_sort' x='1188' y='96'>dict_sort</text>
- <title>dict_sort
- int default 0
- 字典排序</title></a>
- <text x='1272' y='93' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_dict_data.dict_label'>
- <text id='ry.sys_dict_data.dict_label' x='1188' y='111'>dict_label</text>
- <title>dict_label
- varchar(100) default ''
- 字典标签</title></a>
- <text x='1272' y='108' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_dict_data.dict_value'>
- <text id='ry.sys_dict_data.dict_value' x='1188' y='126'>dict_value</text>
- <title>dict_value
- varchar(100) default ''
- 字典键值</title></a>
- <text x='1272' y='123' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_dict_data.dict_type'>
- <text id='ry.sys_dict_data.dict_type' x='1188' y='141'>dict_type</text>
- <title>dict_type
- varchar(100) default ''
- 字典类型</title></a>
- <text x='1272' y='138' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_dict_data.status'>
- <text id='ry.sys_dict_data.status' x='1188' y='156'>status</text>
- <title>status
- int default 0
- 状态(0正常 1禁用)</title></a>
- <text x='1272' y='153' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_dict_data.create_by'>
- <text id='ry.sys_dict_data.create_by' x='1188' y='171'>create_by</text>
- <title>create_by
- varchar(64) default ''
- 创建者</title></a>
- <text x='1272' y='168' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1172' y='177' xlink:href='#nn'/>
- <a xlink:href='#sys_dict_data.create_time'>
- <text id='ry.sys_dict_data.create_time' x='1188' y='186'>create_time</text>
- <title>create_time
- * timestamp default CURRENT_TIMESTAMP
- 创建时间</title></a>
- <text x='1272' y='183' text-anchor='end' class='colType'>d</text>
- <a xlink:href='#sys_dict_data.update_by'>
- <text id='ry.sys_dict_data.update_by' x='1188' y='201'>update_by</text>
- <title>update_by
- varchar(64) default ''
- 更新者</title></a>
- <text x='1272' y='198' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1172' y='207' xlink:href='#nn'/>
- <a xlink:href='#sys_dict_data.update_time'>
- <text id='ry.sys_dict_data.update_time' x='1188' y='216'>update_time</text>
- <title>update_time
- * timestamp default '0000-00-00 00:00:00'
- 更新时间</title></a>
- <text x='1272' y='213' text-anchor='end' class='colType'>d</text>
- <a xlink:href='#sys_dict_data.remark'>
- <text id='ry.sys_dict_data.remark' x='1188' y='231'>remark</text>
- <title>remark
- varchar(500) default ''
- 备注</title></a>
- <text x='1272' y='228' text-anchor='end' class='colType'>t</text>
- <!-- == Table 'sys_dict_type' == -->
- <rect class='entity' x='1005' y='38' width='105' height='180' rx='7' ry='7' style='stroke:none'/>
- <path d='M 1005 64 L 1005 45 Q 1005 38 1012 38 L 1103 38 Q 1110 38 1110 45 L 1110 64 L1005 64 '
- style='fill:url(#tbg_c8f5bf);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='1005' y='38' width='105' height='180' rx='7' ry='7'
- style='fill:none;stroke:#626e5f'/>
- <line class='delim' x1='1005' y1='64' x2='1110' y2='64' style='stroke:#626e5f'/>
- <line class='delim' x1='1020' y1='64' x2='1020' y2='218' style='stroke:#626e5f'/>
- <line class='delim' x1='1099' y1='64' x2='1099' y2='218' style='stroke:#626e5f'/>
- <a xlink:href='#sys_dict_type'>
- <text x='1015' y='56'>sys_dict_type</text>
- <title>Table ry.sys_dict_type</title></a>
- <use id='nn' x='1007' y='72' xlink:href='#nn'/>
- <a xlink:href='#sys_dict_type.dict_id'>
- <use id='pk' x='1007' y='71' xlink:href='#pk'/>
- <title>Pk pk_sys_dict_type ( dict_id ) </title></a>
- <a xlink:href='#sys_dict_type.dict_id'>
- <text id='ry.sys_dict_type.dict_id' x='1023' y='81'>dict_id</text>
- <title>dict_id
- * int
- 字典主键</title></a>
- <text x='1107' y='78' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_dict_type.dict_name'>
- <text id='ry.sys_dict_type.dict_name' x='1023' y='96'>dict_name</text>
- <title>dict_name
- varchar(100) default ''
- 字典名称</title></a>
- <text x='1107' y='93' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_dict_type.dict_type'>
- <use id='unq' x='1007' y='101' xlink:href='#unq'/>
- <title>Unq dict_type ( dict_type ) </title></a>
- <a xlink:href='#sys_dict_type.dict_type'>
- <text id='ry.sys_dict_type.dict_type' x='1023' y='111'>dict_type</text>
- <title>dict_type
- varchar(100) default ''
- 字典类型</title></a>
- <text x='1107' y='108' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_dict_type.status'>
- <text id='ry.sys_dict_type.status' x='1023' y='126'>status</text>
- <title>status
- int default 0
- 状态(0正常 1禁用)</title></a>
- <text x='1107' y='123' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_dict_type.create_by'>
- <text id='ry.sys_dict_type.create_by' x='1023' y='141'>create_by</text>
- <title>create_by
- varchar(64) default ''
- 创建者</title></a>
- <text x='1107' y='138' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1007' y='147' xlink:href='#nn'/>
- <a xlink:href='#sys_dict_type.create_time'>
- <text id='ry.sys_dict_type.create_time' x='1023' y='156'>create_time</text>
- <title>create_time
- * timestamp default CURRENT_TIMESTAMP
- 创建时间</title></a>
- <text x='1107' y='153' text-anchor='end' class='colType'>d</text>
- <a xlink:href='#sys_dict_type.update_by'>
- <text id='ry.sys_dict_type.update_by' x='1023' y='171'>update_by</text>
- <title>update_by
- varchar(64) default ''
- 更新者</title></a>
- <text x='1107' y='168' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1007' y='177' xlink:href='#nn'/>
- <a xlink:href='#sys_dict_type.update_time'>
- <text id='ry.sys_dict_type.update_time' x='1023' y='186'>update_time</text>
- <title>update_time
- * timestamp default '0000-00-00 00:00:00'
- 更新时间</title></a>
- <text x='1107' y='183' text-anchor='end' class='colType'>d</text>
- <a xlink:href='#sys_dict_type.remark'>
- <text id='ry.sys_dict_type.remark' x='1023' y='201'>remark</text>
- <title>remark
- varchar(500) default ''
- 备注</title></a>
- <text x='1107' y='198' text-anchor='end' class='colType'>t</text>
- <!-- == Table 'sys_job' == -->
- <rect class='entity' x='1545' y='38' width='135' height='225' rx='7' ry='7' style='stroke:none'/>
- <path d='M 1545 64 L 1545 45 Q 1545 38 1552 38 L 1673 38 Q 1680 38 1680 45 L 1680 64 L1545 64 '
- style='fill:url(#tbg_f5ddbf);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='1545' y='38' width='135' height='225' rx='7' ry='7'
- style='fill:none;stroke:#6e675f'/>
- <line class='delim' x1='1545' y1='64' x2='1680' y2='64' style='stroke:#6e675f'/>
- <line class='delim' x1='1560' y1='64' x2='1560' y2='263' style='stroke:#6e675f'/>
- <line class='delim' x1='1669' y1='64' x2='1669' y2='263' style='stroke:#6e675f'/>
- <a xlink:href='#sys_job'>
- <text x='1588' y='56'>sys_job</text>
- <title>Table ry.sys_job</title></a>
- <use id='nn' x='1547' y='72' xlink:href='#nn'/>
- <a xlink:href='#sys_job.job_id'>
- <use id='pk' x='1547' y='71' xlink:href='#pk'/>
- <title>Pk pk_sys_job ( job_id, job_name, job_group ) </title></a>
- <a xlink:href='#sys_job.job_id'>
- <text id='ry.sys_job.job_id' x='1563' y='81'>job_id</text>
- <title>job_id
- * int
- 任务ID</title></a>
- <text x='1677' y='78' text-anchor='end' class='colType'>#</text>
- <use id='nn' x='1547' y='87' xlink:href='#nn'/>
- <a xlink:href='#sys_job.job_name'>
- <use id='pk' x='1547' y='86' xlink:href='#pk'/>
- <title>Pk pk_sys_job ( job_id, job_name, job_group ) </title></a>
- <a xlink:href='#sys_job.job_name'>
- <text id='ry.sys_job.job_name' x='1563' y='96'>job_name</text>
- <title>job_name
- * varchar(64) default ''
- 任务名称</title></a>
- <text x='1677' y='93' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1547' y='102' xlink:href='#nn'/>
- <a xlink:href='#sys_job.job_group'>
- <use id='pk' x='1547' y='101' xlink:href='#pk'/>
- <title>Pk pk_sys_job ( job_id, job_name, job_group ) </title></a>
- <a xlink:href='#sys_job.job_group'>
- <text id='ry.sys_job.job_group' x='1563' y='111'>job_group</text>
- <title>job_group
- * varchar(64) default ''
- 任务组名</title></a>
- <text x='1677' y='108' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_job.method_name'>
- <text id='ry.sys_job.method_name' x='1563' y='126'>method_name</text>
- <title>method_name
- varchar(500) default ''
- 任务方法</title></a>
- <text x='1677' y='123' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_job.params'>
- <text id='ry.sys_job.params' x='1563' y='141'>params</text>
- <title>params
- varchar(200) default ''
- 方法参数</title></a>
- <text x='1677' y='138' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_job.cron_expression'>
- <text id='ry.sys_job.cron_expression' x='1563' y='156'>cron_expression</text>
- <title>cron_expression
- varchar(255) default ''
- cron执行表达式</title></a>
- <text x='1677' y='153' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_job.status'>
- <text id='ry.sys_job.status' x='1563' y='171'>status</text>
- <title>status
- int default 0
- 状态(0正常 1暂停)</title></a>
- <text x='1677' y='168' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_job.create_by'>
- <text id='ry.sys_job.create_by' x='1563' y='186'>create_by</text>
- <title>create_by
- varchar(64) default ''
- 创建者</title></a>
- <text x='1677' y='183' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1547' y='192' xlink:href='#nn'/>
- <a xlink:href='#sys_job.create_time'>
- <text id='ry.sys_job.create_time' x='1563' y='201'>create_time</text>
- <title>create_time
- * timestamp default CURRENT_TIMESTAMP
- 创建时间</title></a>
- <text x='1677' y='198' text-anchor='end' class='colType'>d</text>
- <a xlink:href='#sys_job.update_by'>
- <text id='ry.sys_job.update_by' x='1563' y='216'>update_by</text>
- <title>update_by
- varchar(64) default ''
- 更新者</title></a>
- <text x='1677' y='213' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1547' y='222' xlink:href='#nn'/>
- <a xlink:href='#sys_job.update_time'>
- <text id='ry.sys_job.update_time' x='1563' y='231'>update_time</text>
- <title>update_time
- * timestamp default '0000-00-00 00:00:00'
- 更新时间</title></a>
- <text x='1677' y='228' text-anchor='end' class='colType'>d</text>
- <a xlink:href='#sys_job.remark'>
- <text id='ry.sys_job.remark' x='1563' y='246'>remark</text>
- <title>remark
- varchar(500) default ''
- 备注信息</title></a>
- <text x='1677' y='243' text-anchor='end' class='colType'>t</text>
- <!-- == Table 'sys_job_log' == -->
- <rect class='entity' x='1365' y='38' width='120' height='180' rx='7' ry='7' style='stroke:none'/>
- <path d='M 1365 64 L 1365 45 Q 1365 38 1372 38 L 1478 38 Q 1485 38 1485 45 L 1485 64 L1365 64 '
- style='fill:url(#tbg_f5ddbf);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='1365' y='38' width='120' height='180' rx='7' ry='7'
- style='fill:none;stroke:#6e675f'/>
- <line class='delim' x1='1365' y1='64' x2='1485' y2='64' style='stroke:#6e675f'/>
- <line class='delim' x1='1380' y1='64' x2='1380' y2='218' style='stroke:#6e675f'/>
- <line class='delim' x1='1474' y1='64' x2='1474' y2='218' style='stroke:#6e675f'/>
- <a xlink:href='#sys_job_log'>
- <text x='1389' y='56'>sys_job_log</text>
- <title>Table ry.sys_job_log</title></a>
- <use id='nn' x='1367' y='72' xlink:href='#nn'/>
- <a xlink:href='#sys_job_log.job_log_id'>
- <use id='pk' x='1367' y='71' xlink:href='#pk'/>
- <title>Pk pk_sys_job_log ( job_log_id ) </title></a>
- <a xlink:href='#sys_job_log.job_log_id'>
- <text id='ry.sys_job_log.job_log_id' x='1383' y='81'>job_log_id</text>
- <title>job_log_id
- * int
- 任务日志ID</title></a>
- <text x='1482' y='78' text-anchor='end' class='colType'>#</text>
- <use id='nn' x='1367' y='87' xlink:href='#nn'/>
- <a xlink:href='#sys_job_log.job_name'>
- <text id='ry.sys_job_log.job_name' x='1383' y='96'>job_name</text>
- <title>job_name
- * varchar(64)
- 任务名称</title></a>
- <text x='1482' y='93' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1367' y='102' xlink:href='#nn'/>
- <a xlink:href='#sys_job_log.job_group'>
- <text id='ry.sys_job_log.job_group' x='1383' y='111'>job_group</text>
- <title>job_group
- * varchar(64)
- 任务组名</title></a>
- <text x='1482' y='108' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_job_log.method_name'>
- <text id='ry.sys_job_log.method_name' x='1383' y='126'>method_name</text>
- <title>method_name
- varchar(500)
- 任务方法</title></a>
- <text x='1482' y='123' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_job_log.params'>
- <text id='ry.sys_job_log.params' x='1383' y='141'>params</text>
- <title>params
- varchar(200) default ''
- 方法参数</title></a>
- <text x='1482' y='138' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_job_log.job_message'>
- <text id='ry.sys_job_log.job_message' x='1383' y='156'>job_message</text>
- <title>job_message
- varchar(500)
- 日志信息</title></a>
- <text x='1482' y='153' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_job_log.is_exception'>
- <text id='ry.sys_job_log.is_exception' x='1383' y='171'>is_exception</text>
- <title>is_exception
- int default 0
- 是否异常</title></a>
- <text x='1482' y='168' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_job_log.exception_info'>
- <text id='ry.sys_job_log.exception_info' x='1383' y='186'>exception_info</text>
- <title>exception_info
- text
- 异常信息</title></a>
- <text x='1482' y='183' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1367' y='192' xlink:href='#nn'/>
- <a xlink:href='#sys_job_log.create_time'>
- <text id='ry.sys_job_log.create_time' x='1383' y='201'>create_time</text>
- <title>create_time
- * timestamp default CURRENT_TIMESTAMP
- 创建时间</title></a>
- <text x='1482' y='198' text-anchor='end' class='colType'>d</text>
- <!-- == Table 'sys_logininfor' == -->
- <rect class='entity' x='1740' y='323' width='105' height='165' rx='7' ry='7' style='stroke:none'/>
- <path d='M 1740 349 L 1740 330 Q 1740 323 1747 323 L 1838 323 Q 1845 323 1845 330 L 1845 349 L1740 349 '
- style='fill:url(#tbg_f5ddbf);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='1740' y='323' width='105' height='165' rx='7' ry='7'
- style='fill:none;stroke:#6e675f'/>
- <line class='delim' x1='1740' y1='349' x2='1845' y2='349' style='stroke:#6e675f'/>
- <line class='delim' x1='1755' y1='349' x2='1755' y2='488' style='stroke:#6e675f'/>
- <line class='delim' x1='1834' y1='349' x2='1834' y2='488' style='stroke:#6e675f'/>
- <a xlink:href='#sys_logininfor'>
- <text x='1747' y='341'>sys_logininfor</text>
- <title>Table ry.sys_logininfor</title></a>
- <use id='nn' x='1742' y='357' xlink:href='#nn'/>
- <a xlink:href='#sys_logininfor.info_id'>
- <use id='pk' x='1742' y='356' xlink:href='#pk'/>
- <title>Pk pk_sys_logininfor ( info_id ) </title></a>
- <a xlink:href='#sys_logininfor.info_id'>
- <text id='ry.sys_logininfor.info_id' x='1758' y='366'>info_id</text>
- <title>info_id
- * int
- 访问ID</title></a>
- <text x='1842' y='363' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_logininfor.login_name'>
- <text id='ry.sys_logininfor.login_name' x='1758' y='381'>login_name</text>
- <title>login_name
- varchar(50) default ''
- 登录账号</title></a>
- <text x='1842' y='378' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_logininfor.ipaddr'>
- <text id='ry.sys_logininfor.ipaddr' x='1758' y='396'>ipaddr</text>
- <title>ipaddr
- varchar(50) default ''
- 登录IP地址</title></a>
- <text x='1842' y='393' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_logininfor.browser'>
- <text id='ry.sys_logininfor.browser' x='1758' y='411'>browser</text>
- <title>browser
- varchar(50) default ''
- 浏览器类型</title></a>
- <text x='1842' y='408' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_logininfor.os'>
- <text id='ry.sys_logininfor.os' x='1758' y='426'>os</text>
- <title>os
- varchar(50) default ''
- 操作系统</title></a>
- <text x='1842' y='423' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_logininfor.status'>
- <text id='ry.sys_logininfor.status' x='1758' y='441'>status</text>
- <title>status
- int default 0
- 登录状态 0成功 1失败</title></a>
- <text x='1842' y='438' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_logininfor.msg'>
- <text id='ry.sys_logininfor.msg' x='1758' y='456'>msg</text>
- <title>msg
- varchar(255) default ''
- 提示消息</title></a>
- <text x='1842' y='453' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1742' y='462' xlink:href='#nn'/>
- <a xlink:href='#sys_logininfor.login_time'>
- <text id='ry.sys_logininfor.login_time' x='1758' y='471'>login_time</text>
- <title>login_time
- * timestamp default CURRENT_TIMESTAMP
- 访问时间</title></a>
- <text x='1842' y='468' text-anchor='end' class='colType'>d</text>
- <!-- == Table 'sys_menu' == -->
- <rect class='entity' x='1380' y='323' width='105' height='255' rx='7' ry='7' style='stroke:none'/>
- <path d='M 1380 349 L 1380 330 Q 1380 323 1387 323 L 1478 323 Q 1485 323 1485 330 L 1485 349 L1380 349 '
- style='fill:url(#tbg_f5ddbf);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='1380' y='323' width='105' height='255' rx='7' ry='7'
- style='fill:none;stroke:#6e675f'/>
- <line class='delim' x1='1380' y1='349' x2='1485' y2='349' style='stroke:#6e675f'/>
- <line class='delim' x1='1395' y1='349' x2='1395' y2='578' style='stroke:#6e675f'/>
- <line class='delim' x1='1474' y1='349' x2='1474' y2='578' style='stroke:#6e675f'/>
- <a xlink:href='#sys_menu'>
- <text x='1405' y='341'>sys_menu</text>
- <title>Table ry.sys_menu</title></a>
- <use id='nn' x='1382' y='357' xlink:href='#nn'/>
- <a xlink:href='#sys_menu.menu_id'>
- <use id='pk' x='1382' y='356' xlink:href='#pk'/>
- <title>Pk pk_sys_menu ( menu_id ) </title></a>
- <a xlink:href='#sys_menu.menu_id'>
- <text id='ry.sys_menu.menu_id' x='1398' y='366'>menu_id</text>
- <title>menu_id
- * int
- 菜单ID</title></a>
- <text x='1482' y='363' text-anchor='end' class='colType'>#</text>
- <use id='nn' x='1382' y='372' xlink:href='#nn'/>
- <a xlink:href='#sys_menu.menu_name'>
- <text id='ry.sys_menu.menu_name' x='1398' y='381'>menu_name</text>
- <title>menu_name
- * varchar(50)
- 菜单名称</title></a>
- <text x='1482' y='378' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_menu.parent_id'>
- <text id='ry.sys_menu.parent_id' x='1398' y='396'>parent_id</text>
- <title>parent_id
- int default 0
- 父菜单ID</title></a>
- <text x='1482' y='393' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_menu.order_num'>
- <text id='ry.sys_menu.order_num' x='1398' y='411'>order_num</text>
- <title>order_num
- int
- 显示顺序</title></a>
- <text x='1482' y='408' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_menu.url'>
- <text id='ry.sys_menu.url' x='1398' y='426'>url</text>
- <title>url
- varchar(200) default ''
- 请求地址</title></a>
- <text x='1482' y='423' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_menu.menu_type'>
- <text id='ry.sys_menu.menu_type' x='1398' y='441'>menu_type</text>
- <title>menu_type
- char(1) default ''
- 类型:M目录,C菜单,F按钮</title></a>
- <text x='1482' y='438' text-anchor='end' class='colType'>c</text>
- <a xlink:href='#sys_menu.visible'>
- <text id='ry.sys_menu.visible' x='1398' y='456'>visible</text>
- <title>visible
- int default 0
- 菜单状态:0显示,1隐藏</title></a>
- <text x='1482' y='453' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_menu.perms'>
- <text id='ry.sys_menu.perms' x='1398' y='471'>perms</text>
- <title>perms
- varchar(100) default ''
- 权限标识</title></a>
- <text x='1482' y='468' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_menu.icon'>
- <text id='ry.sys_menu.icon' x='1398' y='486'>icon</text>
- <title>icon
- varchar(100) default ''
- 菜单图标</title></a>
- <text x='1482' y='483' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_menu.create_by'>
- <text id='ry.sys_menu.create_by' x='1398' y='501'>create_by</text>
- <title>create_by
- varchar(64) default ''
- 创建者</title></a>
- <text x='1482' y='498' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1382' y='507' xlink:href='#nn'/>
- <a xlink:href='#sys_menu.create_time'>
- <text id='ry.sys_menu.create_time' x='1398' y='516'>create_time</text>
- <title>create_time
- * timestamp default CURRENT_TIMESTAMP
- 创建时间</title></a>
- <text x='1482' y='513' text-anchor='end' class='colType'>d</text>
- <a xlink:href='#sys_menu.update_by'>
- <text id='ry.sys_menu.update_by' x='1398' y='531'>update_by</text>
- <title>update_by
- varchar(64) default ''
- 更新者</title></a>
- <text x='1482' y='528' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1382' y='537' xlink:href='#nn'/>
- <a xlink:href='#sys_menu.update_time'>
- <text id='ry.sys_menu.update_time' x='1398' y='546'>update_time</text>
- <title>update_time
- * timestamp default '0000-00-00 00:00:00'
- 更新时间</title></a>
- <text x='1482' y='543' text-anchor='end' class='colType'>d</text>
- <a xlink:href='#sys_menu.remark'>
- <text id='ry.sys_menu.remark' x='1398' y='561'>remark</text>
- <title>remark
- varchar(500) default ''
- 备注</title></a>
- <text x='1482' y='558' text-anchor='end' class='colType'>t</text>
- <!-- == Table 'sys_oper_log' == -->
- <rect class='entity' x='1005' y='278' width='105' height='240' rx='7' ry='7' style='stroke:none'/>
- <path d='M 1005 304 L 1005 285 Q 1005 278 1012 278 L 1103 278 Q 1110 278 1110 285 L 1110 304 L1005 304 '
- style='fill:url(#tbg_c8f5bf);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='1005' y='278' width='105' height='240' rx='7' ry='7'
- style='fill:none;stroke:#626e5f'/>
- <line class='delim' x1='1005' y1='304' x2='1110' y2='304' style='stroke:#626e5f'/>
- <line class='delim' x1='1020' y1='304' x2='1020' y2='518' style='stroke:#626e5f'/>
- <line class='delim' x1='1099' y1='304' x2='1099' y2='518' style='stroke:#626e5f'/>
- <a xlink:href='#sys_oper_log'>
- <text x='1018' y='296'>sys_oper_log</text>
- <title>Table ry.sys_oper_log</title></a>
- <use id='nn' x='1007' y='312' xlink:href='#nn'/>
- <a xlink:href='#sys_oper_log.oper_id'>
- <use id='pk' x='1007' y='311' xlink:href='#pk'/>
- <title>Pk pk_sys_oper_log ( oper_id ) </title></a>
- <a xlink:href='#sys_oper_log.oper_id'>
- <text id='ry.sys_oper_log.oper_id' x='1023' y='321'>oper_id</text>
- <title>oper_id
- * int
- 日志主键</title></a>
- <text x='1107' y='318' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_oper_log.title'>
- <text id='ry.sys_oper_log.title' x='1023' y='336'>title</text>
- <title>title
- varchar(50) default ''
- 模块标题</title></a>
- <text x='1107' y='333' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_oper_log.action'>
- <text id='ry.sys_oper_log.action' x='1023' y='351'>action</text>
- <title>action
- varchar(100) default ''
- 功能请求</title></a>
- <text x='1107' y='348' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_oper_log.method'>
- <text id='ry.sys_oper_log.method' x='1023' y='366'>method</text>
- <title>method
- varchar(100) default ''
- 方法名称</title></a>
- <text x='1107' y='363' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_oper_log.channel'>
- <text id='ry.sys_oper_log.channel' x='1023' y='381'>channel</text>
- <title>channel
- varchar(20) default ''
- 来源渠道</title></a>
- <text x='1107' y='378' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_oper_log.login_name'>
- <text id='ry.sys_oper_log.login_name' x='1023' y='396'>login_name</text>
- <title>login_name
- varchar(50) default ''
- 登录账号</title></a>
- <text x='1107' y='393' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_oper_log.dept_name'>
- <text id='ry.sys_oper_log.dept_name' x='1023' y='411'>dept_name</text>
- <title>dept_name
- varchar(50) default ''
- 部门名称</title></a>
- <text x='1107' y='408' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_oper_log.oper_url'>
- <text id='ry.sys_oper_log.oper_url' x='1023' y='426'>oper_url</text>
- <title>oper_url
- varchar(255) default ''
- 请求URL</title></a>
- <text x='1107' y='423' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_oper_log.oper_ip'>
- <text id='ry.sys_oper_log.oper_ip' x='1023' y='441'>oper_ip</text>
- <title>oper_ip
- varchar(30) default ''
- 主机地址</title></a>
- <text x='1107' y='438' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_oper_log.oper_param'>
- <text id='ry.sys_oper_log.oper_param' x='1023' y='456'>oper_param</text>
- <title>oper_param
- varchar(255) default ''
- 请求参数</title></a>
- <text x='1107' y='453' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_oper_log.status'>
- <text id='ry.sys_oper_log.status' x='1023' y='471'>status</text>
- <title>status
- int default 0
- 操作状态 0正常 1异常</title></a>
- <text x='1107' y='468' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_oper_log.error_msg'>
- <text id='ry.sys_oper_log.error_msg' x='1023' y='486'>error_msg</text>
- <title>error_msg
- varchar(2000) default ''
- 错误消息</title></a>
- <text x='1107' y='483' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1007' y='492' xlink:href='#nn'/>
- <a xlink:href='#sys_oper_log.oper_time'>
- <text id='ry.sys_oper_log.oper_time' x='1023' y='501'>oper_time</text>
- <title>oper_time
- * timestamp default CURRENT_TIMESTAMP
- 操作时间</title></a>
- <text x='1107' y='498' text-anchor='end' class='colType'>d</text>
- <!-- == Table 'sys_post' == -->
- <rect class='entity' x='1740' y='38' width='105' height='195' rx='7' ry='7' style='stroke:none'/>
- <path d='M 1740 64 L 1740 45 Q 1740 38 1747 38 L 1838 38 Q 1845 38 1845 45 L 1845 64 L1740 64 '
- style='fill:url(#tbg_f5ddbf);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='1740' y='38' width='105' height='195' rx='7' ry='7'
- style='fill:none;stroke:#6e675f'/>
- <line class='delim' x1='1740' y1='64' x2='1845' y2='64' style='stroke:#6e675f'/>
- <line class='delim' x1='1755' y1='64' x2='1755' y2='233' style='stroke:#6e675f'/>
- <line class='delim' x1='1834' y1='64' x2='1834' y2='233' style='stroke:#6e675f'/>
- <a xlink:href='#sys_post'>
- <text x='1765' y='56'>sys_post</text>
- <title>Table ry.sys_post</title></a>
- <use id='nn' x='1742' y='72' xlink:href='#nn'/>
- <a xlink:href='#sys_post.post_id'>
- <use id='pk' x='1742' y='71' xlink:href='#pk'/>
- <title>Pk pk_sys_post ( post_id ) </title></a>
- <a xlink:href='#sys_post.post_id'>
- <text id='ry.sys_post.post_id' x='1758' y='81'>post_id</text>
- <title>post_id
- * int
- 岗位ID</title></a>
- <text x='1842' y='78' text-anchor='end' class='colType'>#</text>
- <use id='nn' x='1742' y='87' xlink:href='#nn'/>
- <a xlink:href='#sys_post.post_code'>
- <text id='ry.sys_post.post_code' x='1758' y='96'>post_code</text>
- <title>post_code
- * varchar(64)
- 岗位编码</title></a>
- <text x='1842' y='93' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1742' y='102' xlink:href='#nn'/>
- <a xlink:href='#sys_post.post_name'>
- <text id='ry.sys_post.post_name' x='1758' y='111'>post_name</text>
- <title>post_name
- * varchar(100)
- 岗位名称</title></a>
- <text x='1842' y='108' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1742' y='117' xlink:href='#nn'/>
- <a xlink:href='#sys_post.post_sort'>
- <text id='ry.sys_post.post_sort' x='1758' y='126'>post_sort</text>
- <title>post_sort
- * int
- 显示顺序</title></a>
- <text x='1842' y='123' text-anchor='end' class='colType'>#</text>
- <use id='nn' x='1742' y='132' xlink:href='#nn'/>
- <a xlink:href='#sys_post.status'>
- <text id='ry.sys_post.status' x='1758' y='141'>status</text>
- <title>status
- * int
- 状态(0正常 1停用)</title></a>
- <text x='1842' y='138' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_post.create_by'>
- <text id='ry.sys_post.create_by' x='1758' y='156'>create_by</text>
- <title>create_by
- varchar(64) default ''
- 创建者</title></a>
- <text x='1842' y='153' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1742' y='162' xlink:href='#nn'/>
- <a xlink:href='#sys_post.create_time'>
- <text id='ry.sys_post.create_time' x='1758' y='171'>create_time</text>
- <title>create_time
- * timestamp default CURRENT_TIMESTAMP
- 创建时间</title></a>
- <text x='1842' y='168' text-anchor='end' class='colType'>d</text>
- <a xlink:href='#sys_post.update_by'>
- <text id='ry.sys_post.update_by' x='1758' y='186'>update_by</text>
- <title>update_by
- varchar(64) default ''
- 更新者</title></a>
- <text x='1842' y='183' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1742' y='192' xlink:href='#nn'/>
- <a xlink:href='#sys_post.update_time'>
- <text id='ry.sys_post.update_time' x='1758' y='201'>update_time</text>
- <title>update_time
- * timestamp default '0000-00-00 00:00:00'
- 更新时间</title></a>
- <text x='1842' y='198' text-anchor='end' class='colType'>d</text>
- <a xlink:href='#sys_post.remark'>
- <text id='ry.sys_post.remark' x='1758' y='216'>remark</text>
- <title>remark
- varchar(500) default ''
- 备注</title></a>
- <text x='1842' y='213' text-anchor='end' class='colType'>t</text>
- <!-- == Table 'sys_role' == -->
- <rect class='entity' x='1545' y='458' width='105' height='195' rx='7' ry='7' style='stroke:none'/>
- <path d='M 1545 484 L 1545 465 Q 1545 458 1552 458 L 1643 458 Q 1650 458 1650 465 L 1650 484 L1545 484 '
- style='fill:url(#tbg_f5ddbf);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='1545' y='458' width='105' height='195' rx='7' ry='7'
- style='fill:none;stroke:#6e675f'/>
- <line class='delim' x1='1545' y1='484' x2='1650' y2='484' style='stroke:#6e675f'/>
- <line class='delim' x1='1560' y1='484' x2='1560' y2='653' style='stroke:#6e675f'/>
- <line class='delim' x1='1639' y1='484' x2='1639' y2='653' style='stroke:#6e675f'/>
- <a xlink:href='#sys_role'>
- <text x='1570' y='476'>sys_role</text>
- <title>Table ry.sys_role</title></a>
- <use id='nn' x='1547' y='492' xlink:href='#nn'/>
- <a xlink:href='#sys_role.role_id'>
- <use id='pk' x='1547' y='491' xlink:href='#pk'/>
- <title>Pk pk_sys_role ( role_id ) </title></a>
- <a xlink:href='#sys_role.role_id'>
- <text id='ry.sys_role.role_id' x='1563' y='501'>role_id</text>
- <title>role_id
- * int
- 角色ID</title></a>
- <text x='1647' y='498' text-anchor='end' class='colType'>#</text>
- <use id='nn' x='1547' y='507' xlink:href='#nn'/>
- <a xlink:href='#sys_role.role_name'>
- <text id='ry.sys_role.role_name' x='1563' y='516'>role_name</text>
- <title>role_name
- * varchar(30)
- 角色名称</title></a>
- <text x='1647' y='513' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1547' y='522' xlink:href='#nn'/>
- <a xlink:href='#sys_role.role_key'>
- <text id='ry.sys_role.role_key' x='1563' y='531'>role_key</text>
- <title>role_key
- * varchar(100)
- 角色权限字符串</title></a>
- <text x='1647' y='528' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1547' y='537' xlink:href='#nn'/>
- <a xlink:href='#sys_role.role_sort'>
- <text id='ry.sys_role.role_sort' x='1563' y='546'>role_sort</text>
- <title>role_sort
- * int
- 显示顺序</title></a>
- <text x='1647' y='543' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_role.status'>
- <text id='ry.sys_role.status' x='1563' y='561'>status</text>
- <title>status
- int default 0
- 角色状态:0正常,1禁用</title></a>
- <text x='1647' y='558' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_role.create_by'>
- <text id='ry.sys_role.create_by' x='1563' y='576'>create_by</text>
- <title>create_by
- varchar(64) default ''
- 创建者</title></a>
- <text x='1647' y='573' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1547' y='582' xlink:href='#nn'/>
- <a xlink:href='#sys_role.create_time'>
- <text id='ry.sys_role.create_time' x='1563' y='591'>create_time</text>
- <title>create_time
- * timestamp default CURRENT_TIMESTAMP
- 创建时间</title></a>
- <text x='1647' y='588' text-anchor='end' class='colType'>d</text>
- <a xlink:href='#sys_role.update_by'>
- <text id='ry.sys_role.update_by' x='1563' y='606'>update_by</text>
- <title>update_by
- varchar(64) default ''
- 更新者</title></a>
- <text x='1647' y='603' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1547' y='612' xlink:href='#nn'/>
- <a xlink:href='#sys_role.update_time'>
- <text id='ry.sys_role.update_time' x='1563' y='621'>update_time</text>
- <title>update_time
- * timestamp default '0000-00-00 00:00:00'
- 更新时间</title></a>
- <text x='1647' y='618' text-anchor='end' class='colType'>d</text>
- <a xlink:href='#sys_role.remark'>
- <text id='ry.sys_role.remark' x='1563' y='636'>remark</text>
- <title>remark
- varchar(500) default ''
- 备注</title></a>
- <text x='1647' y='633' text-anchor='end' class='colType'>t</text>
- <!-- == Table 'sys_role_menu' == -->
- <rect class='entity' x='1545' y='323' width='90' height='75' rx='7' ry='7' style='stroke:none'/>
- <path d='M 1545 349 L 1545 330 Q 1545 323 1552 323 L 1628 323 Q 1635 323 1635 330 L 1635 349 L1545 349 '
- style='fill:url(#tbg_f5ddbf);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='1545' y='323' width='90' height='75' rx='7' ry='7'
- style='fill:none;stroke:#6e675f'/>
- <line class='delim' x1='1545' y1='349' x2='1635' y2='349' style='stroke:#6e675f'/>
- <line class='delim' x1='1560' y1='349' x2='1560' y2='398' style='stroke:#6e675f'/>
- <line class='delim' x1='1624' y1='349' x2='1624' y2='398' style='stroke:#6e675f'/>
- <a xlink:href='#sys_role_menu'>
- <text x='1548' y='341'>sys_role_menu</text>
- <title>Table ry.sys_role_menu</title></a>
- <use id='nn' x='1547' y='357' xlink:href='#nn'/>
- <a xlink:href='#sys_role_menu.role_id'>
- <use id='pk' x='1547' y='356' xlink:href='#pk'/>
- <title>Pk pk_sys_role_menu ( role_id, menu_id ) </title></a>
- <a xlink:href='#sys_role_menu.role_id'>
- <text id='ry.sys_role_menu.role_id' x='1563' y='366'>role_id</text>
- <title>role_id
- * int
- 角色ID</title></a>
- <text x='1632' y='363' text-anchor='end' class='colType'>#</text>
- <use id='nn' x='1547' y='372' xlink:href='#nn'/>
- <a xlink:href='#sys_role_menu.menu_id'>
- <use id='pk' x='1547' y='371' xlink:href='#pk'/>
- <title>Pk pk_sys_role_menu ( role_id, menu_id ) </title></a>
- <a xlink:href='#sys_role_menu.menu_id'>
- <text id='ry.sys_role_menu.menu_id' x='1563' y='381'>menu_id</text>
- <title>menu_id
- * int
- 菜单ID</title></a>
- <text x='1632' y='378' text-anchor='end' class='colType'>#</text>
- <!-- == Table 'sys_user' == -->
- <rect class='entity' x='690' y='83' width='105' height='270' rx='7' ry='7' style='stroke:none'/>
- <path d='M 690 109 L 690 90 Q 690 83 697 83 L 788 83 Q 795 83 795 90 L 795 109 L690 109 '
- style='fill:url(#tbg_c8f5bf);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='690' y='83' width='105' height='270' rx='7' ry='7'
- style='fill:none;stroke:#626e5f'/>
- <line class='delim' x1='690' y1='109' x2='795' y2='109' style='stroke:#626e5f'/>
- <line class='delim' x1='705' y1='109' x2='705' y2='353' style='stroke:#626e5f'/>
- <line class='delim' x1='784' y1='109' x2='784' y2='353' style='stroke:#626e5f'/>
- <a xlink:href='#sys_user'>
- <text x='715' y='101'>sys_user</text>
- <title>Table ry.sys_user</title></a>
- <use id='nn' x='692' y='117' xlink:href='#nn'/>
- <a xlink:href='#sys_user.user_id'>
- <use id='pk' x='692' y='116' xlink:href='#pk'/>
- <title>Pk pk_sys_user ( user_id ) </title></a>
- <a xlink:href='#sys_user.user_id'>
- <text id='ry.sys_user.user_id' x='708' y='126'>user_id</text>
- <title>user_id
- * int
- 用户ID</title></a>
- <text x='792' y='123' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_user.dept_id'>
- <text id='ry.sys_user.dept_id' x='708' y='141'>dept_id</text>
- <title>dept_id
- int
- 部门ID</title></a>
- <text x='792' y='138' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_user.login_name'>
- <text id='ry.sys_user.login_name' x='708' y='156'>login_name</text>
- <title>login_name
- varchar(30) default ''
- 登录账号</title></a>
- <text x='792' y='153' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_user.user_name'>
- <text id='ry.sys_user.user_name' x='708' y='171'>user_name</text>
- <title>user_name
- varchar(30) default ''
- 用户昵称</title></a>
- <text x='792' y='168' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_user.email'>
- <text id='ry.sys_user.email' x='708' y='186'>email</text>
- <title>email
- varchar(100) default ''
- 用户邮箱</title></a>
- <text x='792' y='183' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_user.phonenumber'>
- <text id='ry.sys_user.phonenumber' x='708' y='201'>phonenumber</text>
- <title>phonenumber
- varchar(20) default ''
- 手机号码</title></a>
- <text x='792' y='198' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_user.password'>
- <text id='ry.sys_user.password' x='708' y='216'>password</text>
- <title>password
- varchar(100) default ''
- 密码</title></a>
- <text x='792' y='213' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_user.salt'>
- <text id='ry.sys_user.salt' x='708' y='231'>salt</text>
- <title>salt
- varchar(100) default ''
- 盐加密</title></a>
- <text x='792' y='228' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_user.user_type'>
- <text id='ry.sys_user.user_type' x='708' y='246'>user_type</text>
- <title>user_type
- char(1) default 'N'
- 类型:Y默认用户,N非默认用户</title></a>
- <text x='792' y='243' text-anchor='end' class='colType'>c</text>
- <a xlink:href='#sys_user.status'>
- <text id='ry.sys_user.status' x='708' y='261'>status</text>
- <title>status
- int default 0
- 帐号状态:0正常,1禁用</title></a>
- <text x='792' y='258' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_user.refuse_des'>
- <text id='ry.sys_user.refuse_des' x='708' y='276'>refuse_des</text>
- <title>refuse_des
- varchar(500) default ''
- 拒绝登录描述</title></a>
- <text x='792' y='273' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_user.create_by'>
- <text id='ry.sys_user.create_by' x='708' y='291'>create_by</text>
- <title>create_by
- varchar(64) default ''
- 创建者</title></a>
- <text x='792' y='288' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='692' y='297' xlink:href='#nn'/>
- <a xlink:href='#sys_user.create_time'>
- <text id='ry.sys_user.create_time' x='708' y='306'>create_time</text>
- <title>create_time
- * timestamp default CURRENT_TIMESTAMP
- 创建时间</title></a>
- <text x='792' y='303' text-anchor='end' class='colType'>d</text>
- <a xlink:href='#sys_user.update_by'>
- <text id='ry.sys_user.update_by' x='708' y='321'>update_by</text>
- <title>update_by
- varchar(64) default ''
- 更新者</title></a>
- <text x='792' y='318' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='692' y='327' xlink:href='#nn'/>
- <a xlink:href='#sys_user.update_time'>
- <text id='ry.sys_user.update_time' x='708' y='336'>update_time</text>
- <title>update_time
- * timestamp default '0000-00-00 00:00:00'
- 更新时间</title></a>
- <text x='792' y='333' text-anchor='end' class='colType'>d</text>
- <!-- == Table 'sys_user_online' == -->
- <rect class='entity' x='660' y='413' width='135' height='195' rx='7' ry='7' style='stroke:none'/>
- <path d='M 660 439 L 660 420 Q 660 413 667 413 L 788 413 Q 795 413 795 420 L 795 439 L660 439 '
- style='fill:url(#tbg_c8f5bf);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='660' y='413' width='135' height='195' rx='7' ry='7'
- style='fill:none;stroke:#626e5f'/>
- <line class='delim' x1='660' y1='439' x2='795' y2='439' style='stroke:#626e5f'/>
- <line class='delim' x1='675' y1='439' x2='675' y2='608' style='stroke:#626e5f'/>
- <line class='delim' x1='784' y1='439' x2='784' y2='608' style='stroke:#626e5f'/>
- <a xlink:href='#sys_user_online'>
- <text x='679' y='431'>sys_user_online</text>
- <title>Table ry.sys_user_online</title></a>
- <use id='nn' x='662' y='447' xlink:href='#nn'/>
- <a xlink:href='#sys_user_online.sessionId'>
- <use id='pk' x='662' y='446' xlink:href='#pk'/>
- <title>Pk pk_sys_user_online ( sessionId ) </title></a>
- <a xlink:href='#sys_user_online.sessionId'>
- <text id='ry.sys_user_online.sessionId' x='678' y='456'>sessionId</text>
- <title>sessionId
- * varchar(50) default ''
- 用户会话id</title></a>
- <text x='792' y='453' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_user_online.login_name'>
- <text id='ry.sys_user_online.login_name' x='678' y='471'>login_name</text>
- <title>login_name
- varchar(50) default ''
- 登录账号</title></a>
- <text x='792' y='468' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_user_online.dept_name'>
- <text id='ry.sys_user_online.dept_name' x='678' y='486'>dept_name</text>
- <title>dept_name
- varchar(50) default ''
- 部门名称</title></a>
- <text x='792' y='483' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_user_online.ipaddr'>
- <text id='ry.sys_user_online.ipaddr' x='678' y='501'>ipaddr</text>
- <title>ipaddr
- varchar(50) default ''
- 登录IP地址</title></a>
- <text x='792' y='498' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_user_online.browser'>
- <text id='ry.sys_user_online.browser' x='678' y='516'>browser</text>
- <title>browser
- varchar(50) default ''
- 浏览器类型</title></a>
- <text x='792' y='513' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_user_online.os'>
- <text id='ry.sys_user_online.os' x='678' y='531'>os</text>
- <title>os
- varchar(50) default ''
- 操作系统</title></a>
- <text x='792' y='528' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_user_online.status'>
- <text id='ry.sys_user_online.status' x='678' y='546'>status</text>
- <title>status
- varchar(10) default ''
- 在线状态on_line在线off_line离线</title></a>
- <text x='792' y='543' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='662' y='552' xlink:href='#nn'/>
- <a xlink:href='#sys_user_online.start_timestamp'>
- <text id='ry.sys_user_online.start_timestamp' x='678' y='561'>start_timestamp</text>
- <title>start_timestamp
- * timestamp default CURRENT_TIMESTAMP
- session创建时间</title></a>
- <text x='792' y='558' text-anchor='end' class='colType'>d</text>
- <use id='nn' x='662' y='567' xlink:href='#nn'/>
- <a xlink:href='#sys_user_online.last_access_time'>
- <text id='ry.sys_user_online.last_access_time' x='678' y='576'>last_access_time</text>
- <title>last_access_time
- * timestamp default '0000-00-00 00:00:00'
- session最后访问时间</title></a>
- <text x='792' y='573' text-anchor='end' class='colType'>d</text>
- <a xlink:href='#sys_user_online.expire_time'>
- <text id='ry.sys_user_online.expire_time' x='678' y='591'>expire_time</text>
- <title>expire_time
- int default 0
- 超时时间,单位为分钟</title></a>
- <text x='792' y='588' text-anchor='end' class='colType'>#</text>
- <!-- == Table 'sys_user_post' == -->
- <rect class='entity' x='855' y='413' width='90' height='75' rx='7' ry='7' style='stroke:none'/>
- <path d='M 855 439 L 855 420 Q 855 413 862 413 L 938 413 Q 945 413 945 420 L 945 439 L855 439 '
- style='fill:url(#tbg_c8f5bf);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='855' y='413' width='90' height='75' rx='7' ry='7' style='fill:none;stroke:#626e5f'/>
- <line class='delim' x1='855' y1='439' x2='945' y2='439' style='stroke:#626e5f'/>
- <line class='delim' x1='870' y1='439' x2='870' y2='488' style='stroke:#626e5f'/>
- <line class='delim' x1='934' y1='439' x2='934' y2='488' style='stroke:#626e5f'/>
- <a xlink:href='#sys_user_post'>
- <text x='858' y='431'>sys_user_post</text>
- <title>Table ry.sys_user_post</title></a>
- <use id='nn' x='857' y='447' xlink:href='#nn'/>
- <a xlink:href='#sys_user_post.user_id'>
- <use id='pk' x='857' y='446' xlink:href='#pk'/>
- <title>Pk pk_sys_user_post ( user_id, post_id ) </title></a>
- <a xlink:href='#sys_user_post.user_id'>
- <text id='ry.sys_user_post.user_id' x='873' y='456'>user_id</text>
- <title>user_id
- * varchar(64)
- 用户ID</title></a>
- <text x='942' y='453' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='857' y='462' xlink:href='#nn'/>
- <a xlink:href='#sys_user_post.post_id'>
- <use id='pk' x='857' y='461' xlink:href='#pk'/>
- <title>Pk pk_sys_user_post ( user_id, post_id ) </title></a>
- <a xlink:href='#sys_user_post.post_id'>
- <text id='ry.sys_user_post.post_id' x='873' y='471'>post_id</text>
- <title>post_id
- * varchar(64)
- 岗位ID</title></a>
- <text x='942' y='468' text-anchor='end' class='colType'>t</text>
- <!-- == Table 'sys_user_role' == -->
- <rect class='entity' x='855' y='278' width='90' height='75' rx='7' ry='7' style='stroke:none'/>
- <path d='M 855 304 L 855 285 Q 855 278 862 278 L 938 278 Q 945 278 945 285 L 945 304 L855 304 '
- style='fill:url(#tbg_c8f5bf);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='855' y='278' width='90' height='75' rx='7' ry='7' style='fill:none;stroke:#626e5f'/>
- <line class='delim' x1='855' y1='304' x2='945' y2='304' style='stroke:#626e5f'/>
- <line class='delim' x1='870' y1='304' x2='870' y2='353' style='stroke:#626e5f'/>
- <line class='delim' x1='934' y1='304' x2='934' y2='353' style='stroke:#626e5f'/>
- <a xlink:href='#sys_user_role'>
- <text x='858' y='296'>sys_user_role</text>
- <title>Table ry.sys_user_role</title></a>
- <use id='nn' x='857' y='312' xlink:href='#nn'/>
- <a xlink:href='#sys_user_role.user_id'>
- <use id='pk' x='857' y='311' xlink:href='#pk'/>
- <title>Pk pk_sys_user_role ( user_id, role_id ) </title></a>
- <a xlink:href='#sys_user_role.user_id'>
- <text id='ry.sys_user_role.user_id' x='873' y='321'>user_id</text>
- <title>user_id
- * int
- 用户ID</title></a>
- <text x='942' y='318' text-anchor='end' class='colType'>#</text>
- <use id='nn' x='857' y='327' xlink:href='#nn'/>
- <a xlink:href='#sys_user_role.role_id'>
- <use id='pk' x='857' y='326' xlink:href='#pk'/>
- <title>Pk pk_sys_user_role ( user_id, role_id ) </title></a>
- <a xlink:href='#sys_user_role.role_id'>
- <text id='ry.sys_user_role.role_id' x='873' y='336'>role_id</text>
- <title>role_id
- * int
- 角色ID</title></a>
- <text x='942' y='333' text-anchor='end' class='colType'>#</text>
- <!-- == Table 'sys_dept' == -->
- <rect class='entity' x='645' y='713' width='105' height='225' rx='7' ry='7' style='stroke:none'/>
- <path d='M 645 739 L 645 720 Q 645 713 652 713 L 743 713 Q 750 713 750 720 L 750 739 L645 739 '
- style='fill:url(#tbg_bfbff5);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='645' y='713' width='105' height='225' rx='7' ry='7'
- style='fill:none;stroke:#5f5f6e'/>
- <line class='delim' x1='645' y1='739' x2='750' y2='739' style='stroke:#5f5f6e'/>
- <line class='delim' x1='660' y1='739' x2='660' y2='938' style='stroke:#5f5f6e'/>
- <line class='delim' x1='739' y1='739' x2='739' y2='938' style='stroke:#5f5f6e'/>
- <a xlink:href='#sys_dept'>
- <text x='670' y='731'>sys_dept</text>
- <title>Table ry.sys_dept</title></a>
- <use id='nn' x='647' y='747' xlink:href='#nn'/>
- <a xlink:href='#sys_dept.dept_id'>
- <use id='pk' x='647' y='746' xlink:href='#pk'/>
- <title>Pk pk_sys_dept ( dept_id ) </title></a>
- <a xlink:href='#sys_dept.dept_id'>
- <text id='ry.sys_dept.dept_id' x='663' y='756'>dept_id</text>
- <title>dept_id
- * int
- 部门id</title></a>
- <text x='747' y='753' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_dept.parent_id'>
- <text id='ry.sys_dept.parent_id' x='663' y='771'>parent_id</text>
- <title>parent_id
- int default 0
- 父部门id</title></a>
- <text x='747' y='768' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_dept.dept_name'>
- <text id='ry.sys_dept.dept_name' x='663' y='786'>dept_name</text>
- <title>dept_name
- varchar(30) default ''
- 部门名称</title></a>
- <text x='747' y='783' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_dept.order_num'>
- <text id='ry.sys_dept.order_num' x='663' y='801'>order_num</text>
- <title>order_num
- int default 0
- 显示顺序</title></a>
- <text x='747' y='798' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_dept.leader'>
- <text id='ry.sys_dept.leader' x='663' y='816'>leader</text>
- <title>leader
- varchar(20) default ''
- 负责人</title></a>
- <text x='747' y='813' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_dept.phone'>
- <text id='ry.sys_dept.phone' x='663' y='831'>phone</text>
- <title>phone
- varchar(20) default ''
- 联系电话</title></a>
- <text x='747' y='828' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_dept.email'>
- <text id='ry.sys_dept.email' x='663' y='846'>email</text>
- <title>email
- varchar(20) default ''
- 邮箱</title></a>
- <text x='747' y='843' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#sys_dept.status'>
- <text id='ry.sys_dept.status' x='663' y='861'>status</text>
- <title>status
- int default 0
- 部门状态:0正常,1停用</title></a>
- <text x='747' y='858' text-anchor='end' class='colType'>#</text>
- <a xlink:href='#sys_dept.create_by'>
- <text id='ry.sys_dept.create_by' x='663' y='876'>create_by</text>
- <title>create_by
- varchar(64) default ''
- 创建者</title></a>
- <text x='747' y='873' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='647' y='882' xlink:href='#nn'/>
- <a xlink:href='#sys_dept.create_time'>
- <text id='ry.sys_dept.create_time' x='663' y='891'>create_time</text>
- <title>create_time
- * timestamp default CURRENT_TIMESTAMP
- 创建时间</title></a>
- <text x='747' y='888' text-anchor='end' class='colType'>d</text>
- <a xlink:href='#sys_dept.update_by'>
- <text id='ry.sys_dept.update_by' x='663' y='906'>update_by</text>
- <title>update_by
- varchar(64) default ''
- 更新者</title></a>
- <text x='747' y='903' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='647' y='912' xlink:href='#nn'/>
- <a xlink:href='#sys_dept.update_time'>
- <text id='ry.sys_dept.update_time' x='663' y='921'>update_time</text>
- <title>update_time
- * timestamp default '0000-00-00 00:00:00'
- 更新时间</title></a>
- <text x='747' y='918' text-anchor='end' class='colType'>d</text>
- <!-- == Table 'qrtz_paused_trigger_grps' == -->
- <rect class='entity' x='1260' y='683' width='165' height='75' rx='7' ry='7' style='stroke:none'/>
- <path d='M 1260 709 L 1260 690 Q 1260 683 1267 683 L 1418 683 Q 1425 683 1425 690 L 1425 709 L1260 709 '
- style='fill:url(#tbg_bfbff5);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='1260' y='683' width='165' height='75' rx='7' ry='7'
- style='fill:none;stroke:#5f5f6e'/>
- <line class='delim' x1='1260' y1='709' x2='1425' y2='709' style='stroke:#5f5f6e'/>
- <line class='delim' x1='1275' y1='709' x2='1275' y2='758' style='stroke:#5f5f6e'/>
- <line class='delim' x1='1414' y1='709' x2='1414' y2='758' style='stroke:#5f5f6e'/>
- <a xlink:href='#qrtz_paused_trigger_grps'>
- <text x='1267' y='701'>qrtz_paused_trigger_grps</text>
- <title>Table ry.qrtz_paused_trigger_grps</title></a>
- <use id='nn' x='1262' y='717' xlink:href='#nn'/>
- <a xlink:href='#qrtz_paused_trigger_grps.sched_name'>
- <use id='pk' x='1262' y='716' xlink:href='#pk'/>
- <title>Pk pk_qrtz_paused_trigger_grps ( sched_name, trigger_group ) </title></a>
- <a xlink:href='#qrtz_paused_trigger_grps.sched_name'>
- <text id='ry.qrtz_paused_trigger_grps.sched_name' x='1278' y='726'>sched_name</text>
- <title>sched_name
- * varchar(120)</title></a>
- <text x='1422' y='723' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1262' y='732' xlink:href='#nn'/>
- <a xlink:href='#qrtz_paused_trigger_grps.trigger_group'>
- <use id='pk' x='1262' y='731' xlink:href='#pk'/>
- <title>Pk pk_qrtz_paused_trigger_grps ( sched_name, trigger_group ) </title></a>
- <a xlink:href='#qrtz_paused_trigger_grps.trigger_group'>
- <text id='ry.qrtz_paused_trigger_grps.trigger_group' x='1278' y='741'>trigger_group</text>
- <title>trigger_group
- * varchar(200)</title></a>
- <text x='1422' y='738' text-anchor='end' class='colType'>t</text>
- <!-- == Table 'qrtz_fired_triggers' == -->
- <rect class='entity' x='1035' y='668' width='135' height='240' rx='7' ry='7' style='stroke:none'/>
- <path d='M 1035 694 L 1035 675 Q 1035 668 1042 668 L 1163 668 Q 1170 668 1170 675 L 1170 694 L1035 694 '
- style='fill:url(#tbg_bfbff5);stroke:1;stroke-opacity:0.1;'/>
- <rect class='entity' x='1035' y='668' width='135' height='240' rx='7' ry='7'
- style='fill:none;stroke:#5f5f6e'/>
- <line class='delim' x1='1035' y1='694' x2='1170' y2='694' style='stroke:#5f5f6e'/>
- <line class='delim' x1='1050' y1='694' x2='1050' y2='908' style='stroke:#5f5f6e'/>
- <line class='delim' x1='1159' y1='694' x2='1159' y2='908' style='stroke:#5f5f6e'/>
- <a xlink:href='#qrtz_fired_triggers'>
- <text x='1042' y='686'>qrtz_fired_triggers</text>
- <title>Table ry.qrtz_fired_triggers</title></a>
- <use id='nn' x='1037' y='702' xlink:href='#nn'/>
- <a xlink:href='#qrtz_fired_triggers.sched_name'>
- <use id='pk' x='1037' y='701' xlink:href='#pk'/>
- <title>Pk pk_qrtz_fired_triggers ( sched_name, entry_id ) </title></a>
- <a xlink:href='#qrtz_fired_triggers.sched_name'>
- <text id='ry.qrtz_fired_triggers.sched_name' x='1053' y='711'>sched_name</text>
- <title>sched_name
- * varchar(120)</title></a>
- <text x='1167' y='708' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1037' y='717' xlink:href='#nn'/>
- <a xlink:href='#qrtz_fired_triggers.entry_id'>
- <use id='pk' x='1037' y='716' xlink:href='#pk'/>
- <title>Pk pk_qrtz_fired_triggers ( sched_name, entry_id ) </title></a>
- <a xlink:href='#qrtz_fired_triggers.entry_id'>
- <text id='ry.qrtz_fired_triggers.entry_id' x='1053' y='726'>entry_id</text>
- <title>entry_id
- * varchar(95)</title></a>
- <text x='1167' y='723' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1037' y='732' xlink:href='#nn'/>
- <a xlink:href='#qrtz_fired_triggers.trigger_name'>
- <text id='ry.qrtz_fired_triggers.trigger_name' x='1053' y='741'>trigger_name</text>
- <title>trigger_name
- * varchar(200)</title></a>
- <text x='1167' y='738' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1037' y='747' xlink:href='#nn'/>
- <a xlink:href='#qrtz_fired_triggers.trigger_group'>
- <text id='ry.qrtz_fired_triggers.trigger_group' x='1053' y='756'>trigger_group</text>
- <title>trigger_group
- * varchar(200)</title></a>
- <text x='1167' y='753' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1037' y='762' xlink:href='#nn'/>
- <a xlink:href='#qrtz_fired_triggers.instance_name'>
- <text id='ry.qrtz_fired_triggers.instance_name' x='1053' y='771'>instance_name</text>
- <title>instance_name
- * varchar(200)</title></a>
- <text x='1167' y='768' text-anchor='end' class='colType'>t</text>
- <use id='nn' x='1037' y='777' xlink:href='#nn'/>
- <a xlink:href='#qrtz_fired_triggers.fired_time'>
- <text id='ry.qrtz_fired_triggers.fired_time' x='1053' y='786'>fired_time</text>
- <title>fired_time
- * bigint</title></a>
- <text x='1167' y='783' text-anchor='end' class='colType'>#</text>
- <use id='nn' x='1037' y='792' xlink:href='#nn'/>
- <a xlink:href='#qrtz_fired_triggers.sched_time'>
- <text id='ry.qrtz_fired_triggers.sched_time' x='1053' y='801'>sched_time</text>
- <title>sched_time
- * bigint</title></a>
- <text x='1167' y='798' text-anchor='end' class='colType'>#</text>
- <use id='nn' x='1037' y='807' xlink:href='#nn'/>
- <a xlink:href='#qrtz_fired_triggers.priority'>
- <text id='ry.qrtz_fired_triggers.priority' x='1053' y='816'>priority</text>
- <title>priority
- * int</title></a>
- <text x='1167' y='813' text-anchor='end' class='colType'>#</text>
- <use id='nn' x='1037' y='822' xlink:href='#nn'/>
- <a xlink:href='#qrtz_fired_triggers.state'>
- <text id='ry.qrtz_fired_triggers.state' x='1053' y='831'>state</text>
- <title>state
- * varchar(16)</title></a>
- <text x='1167' y='828' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#qrtz_fired_triggers.job_name'>
- <text id='ry.qrtz_fired_triggers.job_name' x='1053' y='846'>job_name</text>
- <title>job_name
- varchar(200)</title></a>
- <text x='1167' y='843' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#qrtz_fired_triggers.job_group'>
- <text id='ry.qrtz_fired_triggers.job_group' x='1053' y='861'>job_group</text>
- <title>job_group
- varchar(200)</title></a>
- <text x='1167' y='858' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#qrtz_fired_triggers.is_nonconcurrent'>
- <text id='ry.qrtz_fired_triggers.is_nonconcurrent' x='1053' y='876'>is_nonconcurrent</text>
- <title>is_nonconcurrent
- varchar(1)</title></a>
- <text x='1167' y='873' text-anchor='end' class='colType'>t</text>
- <a xlink:href='#qrtz_fired_triggers.requests_recovery'>
- <text id='ry.qrtz_fired_triggers.requests_recovery' x='1053' y='891'>requests_recovery</text>
- <title>requests_recovery
- varchar(1)</title></a>
- <text x='1167' y='888' text-anchor='end' class='colType'>t</text>
- </g>
- </svg>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='qrtz_blob_triggers' onclick='window.scrollTo(60, 540);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table qrtz_blob_triggers</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- <svg width='14' height='14'>
- <use xlink:href='#fk'/>
- </svg>
- </td>
- <td><a name='qrtz_blob_triggers.sched_name'>sched_name</a></td>
- <td> varchar( 120 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- <svg width='14' height='14'>
- <use xlink:href='#fk'/>
- </svg>
- </td>
- <td><a name='qrtz_blob_triggers.trigger_name'>trigger_name</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- <svg width='14' height='14'>
- <use xlink:href='#fk'/>
- </svg>
- </td>
- <td><a name='qrtz_blob_triggers.trigger_group'>trigger_group</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_blob_triggers.blob_data'>blob_data</a></td>
- <td> blob</td>
- <td></td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_qrtz_blob_triggers</td>
- <td> ON sched_name, trigger_name, trigger_group</td>
- <td></td>
- </tr>
- <tr>
- <th colspan='4'>Foreign Keys</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#fk'/>
- </svg>
- </td>
- <td>qrtz_blob_triggers_ibfk_1</td>
- <td> ( sched_name, trigger_name, trigger_group ) ref <a href='#qrtz_triggers'>qrtz_triggers</a>
- (sched_name, trigger_name, trigger_group)
- </td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='qrtz_calendars' onclick='window.scrollTo(60, 45);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table qrtz_calendars</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='qrtz_calendars.sched_name'>sched_name</a></td>
- <td> varchar( 120 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='qrtz_calendars.calendar_name'>calendar_name</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='qrtz_calendars.calendar'>calendar</a></td>
- <td> blob</td>
- <td></td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_qrtz_calendars</td>
- <td> ON sched_name, calendar_name</td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='qrtz_cron_triggers' onclick='window.scrollTo(235, 540);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table qrtz_cron_triggers</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- <svg width='14' height='14'>
- <use xlink:href='#fk'/>
- </svg>
- </td>
- <td><a name='qrtz_cron_triggers.sched_name'>sched_name</a></td>
- <td> varchar( 120 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- <svg width='14' height='14'>
- <use xlink:href='#fk'/>
- </svg>
- </td>
- <td><a name='qrtz_cron_triggers.trigger_name'>trigger_name</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- <svg width='14' height='14'>
- <use xlink:href='#fk'/>
- </svg>
- </td>
- <td><a name='qrtz_cron_triggers.trigger_group'>trigger_group</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='qrtz_cron_triggers.cron_expression'>cron_expression</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_cron_triggers.time_zone_id'>time_zone_id</a></td>
- <td> varchar( 80 )</td>
- <td></td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_qrtz_cron_triggers</td>
- <td> ON sched_name, trigger_name, trigger_group</td>
- <td></td>
- </tr>
- <tr>
- <th colspan='4'>Foreign Keys</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#fk'/>
- </svg>
- </td>
- <td>qrtz_cron_triggers_ibfk_1</td>
- <td> ( sched_name, trigger_name, trigger_group ) ref <a href='#qrtz_triggers'>qrtz_triggers</a>
- (sched_name, trigger_name, trigger_group)
- </td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='qrtz_fired_triggers' onclick='window.scrollTo(835, 675);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table qrtz_fired_triggers</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='qrtz_fired_triggers.sched_name'>sched_name</a></td>
- <td> varchar( 120 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='qrtz_fired_triggers.entry_id'>entry_id</a></td>
- <td> varchar( 95 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='qrtz_fired_triggers.trigger_name'>trigger_name</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='qrtz_fired_triggers.trigger_group'>trigger_group</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='qrtz_fired_triggers.instance_name'>instance_name</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='qrtz_fired_triggers.fired_time'>fired_time</a></td>
- <td> bigint</td>
- <td></td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='qrtz_fired_triggers.sched_time'>sched_time</a></td>
- <td> bigint</td>
- <td></td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='qrtz_fired_triggers.priority'>priority</a></td>
- <td> int</td>
- <td></td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='qrtz_fired_triggers.state'>state</a></td>
- <td> varchar( 16 )</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_fired_triggers.job_name'>job_name</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_fired_triggers.job_group'>job_group</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_fired_triggers.is_nonconcurrent'>is_nonconcurrent</a></td>
- <td> varchar( 1 )</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_fired_triggers.requests_recovery'>requests_recovery</a></td>
- <td> varchar( 1 )</td>
- <td></td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_qrtz_fired_triggers</td>
- <td> ON sched_name, entry_id</td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='qrtz_job_details' onclick='window.scrollTo(235, 195);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table qrtz_job_details</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- <svg width='14' height='14'>
- <use xlink:href='#ref'/>
- </svg>
- </td>
- <td><a name='qrtz_job_details.sched_name'>sched_name</a></td>
- <td> varchar( 120 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- <svg width='14' height='14'>
- <use xlink:href='#ref'/>
- </svg>
- </td>
- <td><a name='qrtz_job_details.job_name'>job_name</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- <svg width='14' height='14'>
- <use xlink:href='#ref'/>
- </svg>
- </td>
- <td><a name='qrtz_job_details.job_group'>job_group</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_job_details.description'>description</a></td>
- <td> varchar( 250 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='qrtz_job_details.job_class_name'>job_class_name</a></td>
- <td> varchar( 250 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='qrtz_job_details.is_durable'>is_durable</a></td>
- <td> varchar( 1 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='qrtz_job_details.is_nonconcurrent'>is_nonconcurrent</a></td>
- <td> varchar( 1 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='qrtz_job_details.is_update_data'>is_update_data</a></td>
- <td> varchar( 1 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='qrtz_job_details.requests_recovery'>requests_recovery</a></td>
- <td> varchar( 1 )</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_job_details.job_data'>job_data</a></td>
- <td> blob</td>
- <td></td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_qrtz_job_details</td>
- <td> ON sched_name, job_name, job_group</td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='qrtz_locks' onclick='window.scrollTo(60, 60);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table qrtz_locks</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='qrtz_locks.sched_name'>sched_name</a></td>
- <td> varchar( 120 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='qrtz_locks.lock_name'>lock_name</a></td>
- <td> varchar( 40 )</td>
- <td></td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_qrtz_locks</td>
- <td> ON sched_name, lock_name</td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='qrtz_paused_trigger_grps' onclick='window.scrollTo(1060, 690);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table qrtz_paused_trigger_grps</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='qrtz_paused_trigger_grps.sched_name'>sched_name</a></td>
- <td> varchar( 120 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='qrtz_paused_trigger_grps.trigger_group'>trigger_group</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_qrtz_paused_trigger_grps</td>
- <td> ON sched_name, trigger_group</td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='qrtz_scheduler_state' onclick='window.scrollTo(60, 735);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table qrtz_scheduler_state</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='qrtz_scheduler_state.sched_name'>sched_name</a></td>
- <td> varchar( 120 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='qrtz_scheduler_state.instance_name'>instance_name</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='qrtz_scheduler_state.last_checkin_time'>last_checkin_time</a></td>
- <td> bigint</td>
- <td></td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='qrtz_scheduler_state.checkin_interval'>checkin_interval</a></td>
- <td> bigint</td>
- <td></td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_qrtz_scheduler_state</td>
- <td> ON sched_name, instance_name</td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='qrtz_simple_triggers' onclick='window.scrollTo(60, 540);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table qrtz_simple_triggers</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- <svg width='14' height='14'>
- <use xlink:href='#fk'/>
- </svg>
- </td>
- <td><a name='qrtz_simple_triggers.sched_name'>sched_name</a></td>
- <td> varchar( 120 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- <svg width='14' height='14'>
- <use xlink:href='#fk'/>
- </svg>
- </td>
- <td><a name='qrtz_simple_triggers.trigger_name'>trigger_name</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- <svg width='14' height='14'>
- <use xlink:href='#fk'/>
- </svg>
- </td>
- <td><a name='qrtz_simple_triggers.trigger_group'>trigger_group</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='qrtz_simple_triggers.repeat_count'>repeat_count</a></td>
- <td> bigint</td>
- <td></td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='qrtz_simple_triggers.repeat_interval'>repeat_interval</a></td>
- <td> bigint</td>
- <td></td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='qrtz_simple_triggers.times_triggered'>times_triggered</a></td>
- <td> bigint</td>
- <td></td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_qrtz_simple_triggers</td>
- <td> ON sched_name, trigger_name, trigger_group</td>
- <td></td>
- </tr>
- <tr>
- <th colspan='4'>Foreign Keys</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#fk'/>
- </svg>
- </td>
- <td>qrtz_simple_triggers_ibfk_1</td>
- <td> ( sched_name, trigger_name, trigger_group ) ref <a href='#qrtz_triggers'>qrtz_triggers</a>
- (sched_name, trigger_name, trigger_group)
- </td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='qrtz_simprop_triggers' onclick='window.scrollTo(60, 225);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table qrtz_simprop_triggers</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- <svg width='14' height='14'>
- <use xlink:href='#fk'/>
- </svg>
- </td>
- <td><a name='qrtz_simprop_triggers.sched_name'>sched_name</a></td>
- <td> varchar( 120 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- <svg width='14' height='14'>
- <use xlink:href='#fk'/>
- </svg>
- </td>
- <td><a name='qrtz_simprop_triggers.trigger_name'>trigger_name</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- <svg width='14' height='14'>
- <use xlink:href='#fk'/>
- </svg>
- </td>
- <td><a name='qrtz_simprop_triggers.trigger_group'>trigger_group</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_simprop_triggers.str_prop_1'>str_prop_1</a></td>
- <td> varchar( 512 )</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_simprop_triggers.str_prop_2'>str_prop_2</a></td>
- <td> varchar( 512 )</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_simprop_triggers.str_prop_3'>str_prop_3</a></td>
- <td> varchar( 512 )</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_simprop_triggers.int_prop_1'>int_prop_1</a></td>
- <td> int</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_simprop_triggers.int_prop_2'>int_prop_2</a></td>
- <td> int</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_simprop_triggers.long_prop_1'>long_prop_1</a></td>
- <td> bigint</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_simprop_triggers.long_prop_2'>long_prop_2</a></td>
- <td> bigint</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_simprop_triggers.dec_prop_1'>dec_prop_1</a></td>
- <td> decimal( 13, 4 )</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_simprop_triggers.dec_prop_2'>dec_prop_2</a></td>
- <td> decimal( 13, 4 )</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_simprop_triggers.bool_prop_1'>bool_prop_1</a></td>
- <td> varchar( 1 )</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_simprop_triggers.bool_prop_2'>bool_prop_2</a></td>
- <td> varchar( 1 )</td>
- <td></td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_qrtz_simprop_triggers</td>
- <td> ON sched_name, trigger_name, trigger_group</td>
- <td></td>
- </tr>
- <tr>
- <th colspan='4'>Foreign Keys</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#fk'/>
- </svg>
- </td>
- <td>qrtz_simprop_triggers_ibfk_1</td>
- <td> ( sched_name, trigger_name, trigger_group ) ref <a href='#qrtz_triggers'>qrtz_triggers</a>
- (sched_name, trigger_name, trigger_group)
- </td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='qrtz_triggers' onclick='window.scrollTo(60, 195);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table qrtz_triggers</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- <svg width='14' height='14'>
- <use xlink:href='#fk'/>
- </svg>
- </td>
- <td><a name='qrtz_triggers.sched_name'>sched_name</a></td>
- <td> varchar( 120 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- <svg width='14' height='14'>
- <use xlink:href='#ref'/>
- </svg>
- </td>
- <td><a name='qrtz_triggers.trigger_name'>trigger_name</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- <svg width='14' height='14'>
- <use xlink:href='#ref'/>
- </svg>
- </td>
- <td><a name='qrtz_triggers.trigger_group'>trigger_group</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#idx'/>
- </svg>
- <svg width='14' height='14'>
- <use xlink:href='#fk'/>
- </svg>
- </td>
- <td><a name='qrtz_triggers.job_name'>job_name</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#idx'/>
- </svg>
- <svg width='14' height='14'>
- <use xlink:href='#fk'/>
- </svg>
- </td>
- <td><a name='qrtz_triggers.job_group'>job_group</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_triggers.description'>description</a></td>
- <td> varchar( 250 )</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_triggers.next_fire_time'>next_fire_time</a></td>
- <td> bigint</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_triggers.prev_fire_time'>prev_fire_time</a></td>
- <td> bigint</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_triggers.priority'>priority</a></td>
- <td> int</td>
- <td></td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='qrtz_triggers.trigger_state'>trigger_state</a></td>
- <td> varchar( 16 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='qrtz_triggers.trigger_type'>trigger_type</a></td>
- <td> varchar( 8 )</td>
- <td></td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='qrtz_triggers.start_time'>start_time</a></td>
- <td> bigint</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_triggers.end_time'>end_time</a></td>
- <td> bigint</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_triggers.calendar_name'>calendar_name</a></td>
- <td> varchar( 200 )</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_triggers.misfire_instr'>misfire_instr</a></td>
- <td> smallint</td>
- <td></td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='qrtz_triggers.job_data'>job_data</a></td>
- <td> blob</td>
- <td></td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_qrtz_triggers</td>
- <td> ON sched_name, trigger_name, trigger_group</td>
- <td></td>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#idx'/>
- </svg>
- </td>
- <td>sched_name</td>
- <td> ON sched_name, job_name, job_group</td>
- <td></td>
- </tr>
- <tr>
- <th colspan='4'>Foreign Keys</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#fk'/>
- </svg>
- </td>
- <td>qrtz_triggers_ibfk_1</td>
- <td> ( sched_name, job_name, job_group ) ref <a href='#qrtz_job_details'>qrtz_job_details</a>
- (sched_name, job_name, job_group)
- </td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='sys_dept' onclick='window.scrollTo(445, 720);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table sys_dept</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='sys_dept.dept_id'>dept_id</a></td>
- <td> int AUTOINCREMENT</td>
- <td> 部门id</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_dept.parent_id'>parent_id</a></td>
- <td> int DEFAULT 0</td>
- <td> 父部门id</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_dept.dept_name'>dept_name</a></td>
- <td> varchar( 30 ) DEFAULT ''</td>
- <td> 部门名称</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_dept.order_num'>order_num</a></td>
- <td> int DEFAULT 0</td>
- <td> 显示顺序</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_dept.leader'>leader</a></td>
- <td> varchar( 20 ) DEFAULT ''</td>
- <td> 负责人</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_dept.phone'>phone</a></td>
- <td> varchar( 20 ) DEFAULT ''</td>
- <td> 联系电话</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_dept.email'>email</a></td>
- <td> varchar( 20 ) DEFAULT ''</td>
- <td> 邮箱</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_dept.status'>status</a></td>
- <td> int DEFAULT 0</td>
- <td> 部门状态:0正常,1停用</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_dept.create_by'>create_by</a></td>
- <td> varchar( 64 ) DEFAULT ''</td>
- <td> 创建者</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_dept.create_time'>create_time</a></td>
- <td> timestamp DEFAULT CURRENT_TIMESTAMP</td>
- <td> 创建时间</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_dept.update_by'>update_by</a></td>
- <td> varchar( 64 ) DEFAULT ''</td>
- <td> 更新者</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_dept.update_time'>update_time</a></td>
- <td> timestamp DEFAULT '0000-00-00 00:00:00'</td>
- <td> 更新时间</td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_sys_dept</td>
- <td> ON dept_id</td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='sys_dict_data' onclick='window.scrollTo(970, 45);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table sys_dict_data</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='sys_dict_data.dict_code'>dict_code</a></td>
- <td> int AUTOINCREMENT</td>
- <td> 字典编码</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_dict_data.dict_sort'>dict_sort</a></td>
- <td> int DEFAULT 0</td>
- <td> 字典排序</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_dict_data.dict_label'>dict_label</a></td>
- <td> varchar( 100 ) DEFAULT ''</td>
- <td> 字典标签</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_dict_data.dict_value'>dict_value</a></td>
- <td> varchar( 100 ) DEFAULT ''</td>
- <td> 字典键值</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_dict_data.dict_type'>dict_type</a></td>
- <td> varchar( 100 ) DEFAULT ''</td>
- <td> 字典类型</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_dict_data.status'>status</a></td>
- <td> int DEFAULT 0</td>
- <td> 状态(0正常 1禁用)</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_dict_data.create_by'>create_by</a></td>
- <td> varchar( 64 ) DEFAULT ''</td>
- <td> 创建者</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_dict_data.create_time'>create_time</a></td>
- <td> timestamp DEFAULT CURRENT_TIMESTAMP</td>
- <td> 创建时间</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_dict_data.update_by'>update_by</a></td>
- <td> varchar( 64 ) DEFAULT ''</td>
- <td> 更新者</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_dict_data.update_time'>update_time</a></td>
- <td> timestamp DEFAULT '0000-00-00 00:00:00'</td>
- <td> 更新时间</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_dict_data.remark'>remark</a></td>
- <td> varchar( 500 ) DEFAULT ''</td>
- <td> 备注</td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_sys_dict_data</td>
- <td> ON dict_code</td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='sys_dict_type' onclick='window.scrollTo(805, 45);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table sys_dict_type</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='sys_dict_type.dict_id'>dict_id</a></td>
- <td> int AUTOINCREMENT</td>
- <td> 字典主键</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_dict_type.dict_name'>dict_name</a></td>
- <td> varchar( 100 ) DEFAULT ''</td>
- <td> 字典名称</td>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#unq'/>
- </svg>
- </td>
- <td><a name='sys_dict_type.dict_type'>dict_type</a></td>
- <td> varchar( 100 ) DEFAULT ''</td>
- <td> 字典类型</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_dict_type.status'>status</a></td>
- <td> int DEFAULT 0</td>
- <td> 状态(0正常 1禁用)</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_dict_type.create_by'>create_by</a></td>
- <td> varchar( 64 ) DEFAULT ''</td>
- <td> 创建者</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_dict_type.create_time'>create_time</a></td>
- <td> timestamp DEFAULT CURRENT_TIMESTAMP</td>
- <td> 创建时间</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_dict_type.update_by'>update_by</a></td>
- <td> varchar( 64 ) DEFAULT ''</td>
- <td> 更新者</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_dict_type.update_time'>update_time</a></td>
- <td> timestamp DEFAULT '0000-00-00 00:00:00'</td>
- <td> 更新时间</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_dict_type.remark'>remark</a></td>
- <td> varchar( 500 ) DEFAULT ''</td>
- <td> 备注</td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_sys_dict_type</td>
- <td> ON dict_id</td>
- <td></td>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#unq'/>
- </svg>
- </td>
- <td>dict_type</td>
- <td> ON dict_type</td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='sys_job' onclick='window.scrollTo(1345, 45);return false;' style='cursor:pointer;'>
- <h4 class='card-title'>Table sys_job</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='sys_job.job_id'>job_id</a></td>
- <td> int AUTOINCREMENT</td>
- <td> 任务ID</td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='sys_job.job_name'>job_name</a></td>
- <td> varchar( 64 ) DEFAULT ''</td>
- <td> 任务名称</td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='sys_job.job_group'>job_group</a></td>
- <td> varchar( 64 ) DEFAULT ''</td>
- <td> 任务组名</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_job.method_name'>method_name</a></td>
- <td> varchar( 500 ) DEFAULT ''</td>
- <td> 任务方法</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_job.params'>params</a></td>
- <td> varchar( 200 ) DEFAULT ''</td>
- <td> 方法参数</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_job.cron_expression'>cron_expression</a></td>
- <td> varchar( 255 ) DEFAULT ''</td>
- <td> cron执行表达式</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_job.status'>status</a></td>
- <td> int DEFAULT 0</td>
- <td> 状态(0正常 1暂停)</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_job.create_by'>create_by</a></td>
- <td> varchar( 64 ) DEFAULT ''</td>
- <td> 创建者</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_job.create_time'>create_time</a></td>
- <td> timestamp DEFAULT CURRENT_TIMESTAMP</td>
- <td> 创建时间</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_job.update_by'>update_by</a></td>
- <td> varchar( 64 ) DEFAULT ''</td>
- <td> 更新者</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_job.update_time'>update_time</a></td>
- <td> timestamp DEFAULT '0000-00-00 00:00:00'</td>
- <td> 更新时间</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_job.remark'>remark</a></td>
- <td> varchar( 500 ) DEFAULT ''</td>
- <td> 备注信息</td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_sys_job</td>
- <td> ON job_id, job_name, job_group</td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='sys_job_log' onclick='window.scrollTo(1165, 45);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table sys_job_log</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='sys_job_log.job_log_id'>job_log_id</a></td>
- <td> int AUTOINCREMENT</td>
- <td> 任务日志ID</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_job_log.job_name'>job_name</a></td>
- <td> varchar( 64 )</td>
- <td> 任务名称</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_job_log.job_group'>job_group</a></td>
- <td> varchar( 64 )</td>
- <td> 任务组名</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_job_log.method_name'>method_name</a></td>
- <td> varchar( 500 )</td>
- <td> 任务方法</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_job_log.params'>params</a></td>
- <td> varchar( 200 ) DEFAULT ''</td>
- <td> 方法参数</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_job_log.job_message'>job_message</a></td>
- <td> varchar( 500 )</td>
- <td> 日志信息</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_job_log.is_exception'>is_exception</a></td>
- <td> int DEFAULT 0</td>
- <td> 是否异常</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_job_log.exception_info'>exception_info</a></td>
- <td> text</td>
- <td> 异常信息</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_job_log.create_time'>create_time</a></td>
- <td> timestamp DEFAULT CURRENT_TIMESTAMP</td>
- <td> 创建时间</td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_sys_job_log</td>
- <td> ON job_log_id</td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='sys_logininfor' onclick='window.scrollTo(1540, 330);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table sys_logininfor</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='sys_logininfor.info_id'>info_id</a></td>
- <td> int AUTOINCREMENT</td>
- <td> 访问ID</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_logininfor.login_name'>login_name</a></td>
- <td> varchar( 50 ) DEFAULT ''</td>
- <td> 登录账号</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_logininfor.ipaddr'>ipaddr</a></td>
- <td> varchar( 50 ) DEFAULT ''</td>
- <td> 登录IP地址</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_logininfor.browser'>browser</a></td>
- <td> varchar( 50 ) DEFAULT ''</td>
- <td> 浏览器类型</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_logininfor.os'>os</a></td>
- <td> varchar( 50 ) DEFAULT ''</td>
- <td> 操作系统</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_logininfor.status'>status</a></td>
- <td> int DEFAULT 0</td>
- <td> 登录状态 0成功 1失败</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_logininfor.msg'>msg</a></td>
- <td> varchar( 255 ) DEFAULT ''</td>
- <td> 提示消息</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_logininfor.login_time'>login_time</a></td>
- <td> timestamp DEFAULT CURRENT_TIMESTAMP</td>
- <td> 访问时间</td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_sys_logininfor</td>
- <td> ON info_id</td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='sys_menu' onclick='window.scrollTo(1180, 330);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table sys_menu</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='sys_menu.menu_id'>menu_id</a></td>
- <td> int AUTOINCREMENT</td>
- <td> 菜单ID</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_menu.menu_name'>menu_name</a></td>
- <td> varchar( 50 )</td>
- <td> 菜单名称</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_menu.parent_id'>parent_id</a></td>
- <td> int DEFAULT 0</td>
- <td> 父菜单ID</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_menu.order_num'>order_num</a></td>
- <td> int</td>
- <td> 显示顺序</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_menu.url'>url</a></td>
- <td> varchar( 200 ) DEFAULT ''</td>
- <td> 请求地址</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_menu.menu_type'>menu_type</a></td>
- <td> char( 1 ) DEFAULT ''</td>
- <td> 类型:M目录,C菜单,F按钮</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_menu.visible'>visible</a></td>
- <td> int DEFAULT 0</td>
- <td> 菜单状态:0显示,1隐藏</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_menu.perms'>perms</a></td>
- <td> varchar( 100 ) DEFAULT ''</td>
- <td> 权限标识</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_menu.icon'>icon</a></td>
- <td> varchar( 100 ) DEFAULT ''</td>
- <td> 菜单图标</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_menu.create_by'>create_by</a></td>
- <td> varchar( 64 ) DEFAULT ''</td>
- <td> 创建者</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_menu.create_time'>create_time</a></td>
- <td> timestamp DEFAULT CURRENT_TIMESTAMP</td>
- <td> 创建时间</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_menu.update_by'>update_by</a></td>
- <td> varchar( 64 ) DEFAULT ''</td>
- <td> 更新者</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_menu.update_time'>update_time</a></td>
- <td> timestamp DEFAULT '0000-00-00 00:00:00'</td>
- <td> 更新时间</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_menu.remark'>remark</a></td>
- <td> varchar( 500 ) DEFAULT ''</td>
- <td> 备注</td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_sys_menu</td>
- <td> ON menu_id</td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='sys_oper_log' onclick='window.scrollTo(805, 285);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table sys_oper_log</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='sys_oper_log.oper_id'>oper_id</a></td>
- <td> int AUTOINCREMENT</td>
- <td> 日志主键</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_oper_log.title'>title</a></td>
- <td> varchar( 50 ) DEFAULT ''</td>
- <td> 模块标题</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_oper_log.action'>action</a></td>
- <td> varchar( 100 ) DEFAULT ''</td>
- <td> 功能请求</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_oper_log.method'>method</a></td>
- <td> varchar( 100 ) DEFAULT ''</td>
- <td> 方法名称</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_oper_log.channel'>channel</a></td>
- <td> varchar( 20 ) DEFAULT ''</td>
- <td> 来源渠道</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_oper_log.login_name'>login_name</a></td>
- <td> varchar( 50 ) DEFAULT ''</td>
- <td> 登录账号</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_oper_log.dept_name'>dept_name</a></td>
- <td> varchar( 50 ) DEFAULT ''</td>
- <td> 部门名称</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_oper_log.oper_url'>oper_url</a></td>
- <td> varchar( 255 ) DEFAULT ''</td>
- <td> 请求URL</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_oper_log.oper_ip'>oper_ip</a></td>
- <td> varchar( 30 ) DEFAULT ''</td>
- <td> 主机地址</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_oper_log.oper_param'>oper_param</a></td>
- <td> varchar( 255 ) DEFAULT ''</td>
- <td> 请求参数</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_oper_log.status'>status</a></td>
- <td> int DEFAULT 0</td>
- <td> 操作状态 0正常 1异常</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_oper_log.error_msg'>error_msg</a></td>
- <td> varchar( 2000 ) DEFAULT ''</td>
- <td> 错误消息</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_oper_log.oper_time'>oper_time</a></td>
- <td> timestamp DEFAULT CURRENT_TIMESTAMP</td>
- <td> 操作时间</td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_sys_oper_log</td>
- <td> ON oper_id</td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='sys_post' onclick='window.scrollTo(1540, 45);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table sys_post</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='sys_post.post_id'>post_id</a></td>
- <td> int AUTOINCREMENT</td>
- <td> 岗位ID</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_post.post_code'>post_code</a></td>
- <td> varchar( 64 )</td>
- <td> 岗位编码</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_post.post_name'>post_name</a></td>
- <td> varchar( 100 )</td>
- <td> 岗位名称</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_post.post_sort'>post_sort</a></td>
- <td> int</td>
- <td> 显示顺序</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_post.status'>status</a></td>
- <td> int</td>
- <td> 状态(0正常 1停用)</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_post.create_by'>create_by</a></td>
- <td> varchar( 64 ) DEFAULT ''</td>
- <td> 创建者</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_post.create_time'>create_time</a></td>
- <td> timestamp DEFAULT CURRENT_TIMESTAMP</td>
- <td> 创建时间</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_post.update_by'>update_by</a></td>
- <td> varchar( 64 ) DEFAULT ''</td>
- <td> 更新者</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_post.update_time'>update_time</a></td>
- <td> timestamp DEFAULT '0000-00-00 00:00:00'</td>
- <td> 更新时间</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_post.remark'>remark</a></td>
- <td> varchar( 500 ) DEFAULT ''</td>
- <td> 备注</td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_sys_post</td>
- <td> ON post_id</td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='sys_role' onclick='window.scrollTo(1345, 465);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table sys_role</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='sys_role.role_id'>role_id</a></td>
- <td> int AUTOINCREMENT</td>
- <td> 角色ID</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_role.role_name'>role_name</a></td>
- <td> varchar( 30 )</td>
- <td> 角色名称</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_role.role_key'>role_key</a></td>
- <td> varchar( 100 )</td>
- <td> 角色权限字符串</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_role.role_sort'>role_sort</a></td>
- <td> int</td>
- <td> 显示顺序</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_role.status'>status</a></td>
- <td> int DEFAULT 0</td>
- <td> 角色状态:0正常,1禁用</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_role.create_by'>create_by</a></td>
- <td> varchar( 64 ) DEFAULT ''</td>
- <td> 创建者</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_role.create_time'>create_time</a></td>
- <td> timestamp DEFAULT CURRENT_TIMESTAMP</td>
- <td> 创建时间</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_role.update_by'>update_by</a></td>
- <td> varchar( 64 ) DEFAULT ''</td>
- <td> 更新者</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_role.update_time'>update_time</a></td>
- <td> timestamp DEFAULT '0000-00-00 00:00:00'</td>
- <td> 更新时间</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_role.remark'>remark</a></td>
- <td> varchar( 500 ) DEFAULT ''</td>
- <td> 备注</td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_sys_role</td>
- <td> ON role_id</td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='sys_role_menu' onclick='window.scrollTo(1345, 330);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table sys_role_menu</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='sys_role_menu.role_id'>role_id</a></td>
- <td> int</td>
- <td> 角色ID</td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='sys_role_menu.menu_id'>menu_id</a></td>
- <td> int</td>
- <td> 菜单ID</td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_sys_role_menu</td>
- <td> ON role_id, menu_id</td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='sys_user' onclick='window.scrollTo(490, 90);return false;' style='cursor:pointer;'>
- <h4 class='card-title'>Table sys_user</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='sys_user.user_id'>user_id</a></td>
- <td> int AUTOINCREMENT</td>
- <td> 用户ID</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_user.dept_id'>dept_id</a></td>
- <td> int</td>
- <td> 部门ID</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_user.login_name'>login_name</a></td>
- <td> varchar( 30 ) DEFAULT ''</td>
- <td> 登录账号</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_user.user_name'>user_name</a></td>
- <td> varchar( 30 ) DEFAULT ''</td>
- <td> 用户昵称</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_user.email'>email</a></td>
- <td> varchar( 100 ) DEFAULT ''</td>
- <td> 用户邮箱</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_user.phonenumber'>phonenumber</a></td>
- <td> varchar( 20 ) DEFAULT ''</td>
- <td> 手机号码</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_user.password'>password</a></td>
- <td> varchar( 100 ) DEFAULT ''</td>
- <td> 密码</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_user.salt'>salt</a></td>
- <td> varchar( 100 ) DEFAULT ''</td>
- <td> 盐加密</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_user.user_type'>user_type</a></td>
- <td> char( 1 ) DEFAULT 'N'</td>
- <td> 类型:Y默认用户,N非默认用户</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_user.status'>status</a></td>
- <td> int DEFAULT 0</td>
- <td> 帐号状态:0正常,1禁用</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_user.refuse_des'>refuse_des</a></td>
- <td> varchar( 500 ) DEFAULT ''</td>
- <td> 拒绝登录描述</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_user.create_by'>create_by</a></td>
- <td> varchar( 64 ) DEFAULT ''</td>
- <td> 创建者</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_user.create_time'>create_time</a></td>
- <td> timestamp DEFAULT CURRENT_TIMESTAMP</td>
- <td> 创建时间</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_user.update_by'>update_by</a></td>
- <td> varchar( 64 ) DEFAULT ''</td>
- <td> 更新者</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_user.update_time'>update_time</a></td>
- <td> timestamp DEFAULT '0000-00-00 00:00:00'</td>
- <td> 更新时间</td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_sys_user</td>
- <td> ON user_id</td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='sys_user_online' onclick='window.scrollTo(460, 420);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table sys_user_online</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='sys_user_online.sessionId'>sessionId</a></td>
- <td> varchar( 50 ) DEFAULT ''</td>
- <td> 用户会话id</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_user_online.login_name'>login_name</a></td>
- <td> varchar( 50 ) DEFAULT ''</td>
- <td> 登录账号</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_user_online.dept_name'>dept_name</a></td>
- <td> varchar( 50 ) DEFAULT ''</td>
- <td> 部门名称</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_user_online.ipaddr'>ipaddr</a></td>
- <td> varchar( 50 ) DEFAULT ''</td>
- <td> 登录IP地址</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_user_online.browser'>browser</a></td>
- <td> varchar( 50 ) DEFAULT ''</td>
- <td> 浏览器类型</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_user_online.os'>os</a></td>
- <td> varchar( 50 ) DEFAULT ''</td>
- <td> 操作系统</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_user_online.status'>status</a></td>
- <td> varchar( 10 ) DEFAULT ''</td>
- <td> 在线状态on_line在线off_line离线</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_user_online.start_timestamp'>start_timestsamp</a></td>
- <td> timestamp DEFAULT CURRENT_TIMESTAMP</td>
- <td> session创建时间</td>
- </tr>
- <tr>
- <td>*</td>
- <td><a name='sys_user_online.last_access_time'>last_access_time</a></td>
- <td> timestamp DEFAULT '0000-00-00 00:00:00'</td>
- <td> session最后访问时间</td>
- </tr>
- <tr>
- <td> </td>
- <td><a name='sys_user_online.expire_time'>expire_time</a></td>
- <td> int DEFAULT 0</td>
- <td> 超时时间,单位为分钟</td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_sys_user_online</td>
- <td> ON sessionId</td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='sys_user_post' onclick='window.scrollTo(655, 420);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table sys_user_post</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='sys_user_post.user_id'>user_id</a></td>
- <td> varchar( 64 )</td>
- <td> 用户ID</td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='sys_user_post.post_id'>post_id</a></td>
- <td> varchar( 64 )</td>
- <td> 岗位ID</td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_sys_user_post</td>
- <td> ON user_id, post_id</td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <br/><br/>
- <div class='card'>
- <div class='card-block'><a name='sys_user_role' onclick='window.scrollTo(655, 285);return false;'
- style='cursor:pointer;'><h4 class='card-title'>Table sys_user_role</h4></a>
- <table class='table-sm table-bordered'>
- <thead>
- <tr>
- <th>Indexes</th>
- <th>Field Name</th>
- <th>Data Type</th>
- <th>Description</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='sys_user_role.user_id'>user_id</a></td>
- <td> int</td>
- <td> 用户ID</td>
- </tr>
- <tr>
- <td>*
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td><a name='sys_user_role.role_id'>role_id</a></td>
- <td> int</td>
- <td> 角色ID</td>
- </tr>
- <tr>
- <th colspan='4'>Indexes</th>
- </tr>
- <tr>
- <td>
- <svg width='14' height='14'>
- <use xlink:href='#pk'/>
- </svg>
- </td>
- <td>pk_sys_user_role</td>
- <td> ON user_id, role_id</td>
- <td></td>
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <p align='right'><a href='https://www.dbschema.com' style='color:#aaa'>Powered by DbSchema</a></p></body>
- </html>
|