jeesite.erm 132 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082308330843085308630873088308930903091309230933094309530963097309830993100310131023103310431053106310731083109311031113112311331143115311631173118311931203121312231233124312531263127312831293130313131323133313431353136313731383139314031413142314331443145314631473148314931503151315231533154315531563157315831593160316131623163316431653166316731683169317031713172317331743175317631773178317931803181318231833184318531863187318831893190319131923193319431953196319731983199320032013202320332043205320632073208320932103211321232133214321532163217321832193220322132223223322432253226322732283229323032313232323332343235323632373238323932403241324232433244324532463247324832493250325132523253325432553256325732583259326032613262326332643265326632673268326932703271327232733274327532763277327832793280328132823283328432853286328732883289329032913292329332943295329632973298329933003301330233033304330533063307330833093310331133123313331433153316331733183319332033213322332333243325332633273328332933303331333233333334333533363337333833393340334133423343334433453346334733483349335033513352335333543355335633573358335933603361336233633364336533663367336833693370337133723373337433753376337733783379338033813382338333843385338633873388338933903391339233933394339533963397339833993400340134023403340434053406340734083409341034113412341334143415341634173418341934203421342234233424342534263427342834293430343134323433343434353436343734383439344034413442344334443445344634473448344934503451345234533454345534563457345834593460346134623463346434653466346734683469347034713472347334743475347634773478347934803481348234833484348534863487348834893490349134923493349434953496349734983499350035013502350335043505350635073508350935103511351235133514351535163517351835193520352135223523352435253526352735283529353035313532353335343535353635373538353935403541354235433544354535463547354835493550355135523553355435553556355735583559356035613562356335643565356635673568356935703571357235733574357535763577357835793580358135823583358435853586358735883589359035913592359335943595359635973598359936003601360236033604360536063607360836093610361136123613361436153616361736183619362036213622362336243625362636273628362936303631363236333634363536363637363836393640364136423643364436453646364736483649365036513652365336543655365636573658365936603661366236633664366536663667366836693670367136723673367436753676367736783679368036813682368336843685368636873688368936903691369236933694369536963697369836993700370137023703370437053706370737083709371037113712371337143715371637173718371937203721372237233724372537263727372837293730373137323733373437353736373737383739374037413742374337443745374637473748374937503751375237533754375537563757375837593760376137623763376437653766376737683769377037713772377337743775377637773778377937803781378237833784378537863787378837893790379137923793379437953796379737983799380038013802380338043805380638073808380938103811381238133814381538163817381838193820382138223823382438253826382738283829383038313832383338343835383638373838383938403841384238433844384538463847384838493850385138523853385438553856385738583859386038613862386338643865386638673868386938703871387238733874387538763877387838793880388138823883388438853886388738883889389038913892389338943895389638973898389939003901390239033904390539063907390839093910391139123913391439153916391739183919392039213922392339243925392639273928392939303931393239333934393539363937393839393940394139423943394439453946394739483949395039513952395339543955395639573958395939603961396239633964396539663967396839693970397139723973397439753976397739783979398039813982398339843985398639873988398939903991399239933994399539963997399839994000400140024003400440054006400740084009401040114012401340144015401640174018401940204021402240234024402540264027402840294030403140324033403440354036403740384039404040414042404340444045404640474048404940504051405240534054405540564057405840594060406140624063406440654066406740684069407040714072407340744075407640774078407940804081408240834084408540864087408840894090409140924093409440954096409740984099410041014102410341044105410641074108410941104111411241134114411541164117411841194120412141224123412441254126412741284129413041314132413341344135413641374138413941404141414241434144414541464147414841494150415141524153415441554156415741584159416041614162416341644165416641674168416941704171417241734174417541764177417841794180418141824183418441854186418741884189419041914192419341944195419641974198419942004201420242034204420542064207420842094210421142124213421442154216421742184219422042214222422342244225422642274228422942304231423242334234423542364237423842394240424142424243424442454246424742484249425042514252425342544255425642574258425942604261426242634264426542664267426842694270427142724273427442754276427742784279428042814282428342844285428642874288428942904291429242934294429542964297429842994300430143024303430443054306430743084309431043114312431343144315431643174318431943204321432243234324432543264327432843294330433143324333433443354336433743384339434043414342434343444345434643474348434943504351435243534354435543564357435843594360436143624363436443654366436743684369437043714372437343744375437643774378437943804381438243834384438543864387438843894390439143924393439443954396439743984399440044014402440344044405440644074408440944104411441244134414441544164417441844194420442144224423442444254426442744284429443044314432443344344435443644374438443944404441444244434444444544464447444844494450445144524453445444554456445744584459446044614462446344644465446644674468446944704471447244734474447544764477447844794480448144824483448444854486448744884489449044914492449344944495449644974498449945004501450245034504450545064507450845094510451145124513451445154516451745184519452045214522452345244525452645274528452945304531453245334534453545364537453845394540454145424543454445454546454745484549455045514552455345544555455645574558455945604561456245634564456545664567456845694570457145724573457445754576457745784579458045814582458345844585458645874588458945904591459245934594459545964597459845994600460146024603460446054606460746084609461046114612461346144615461646174618461946204621462246234624462546264627462846294630463146324633463446354636463746384639464046414642464346444645464646474648464946504651465246534654465546564657465846594660466146624663466446654666466746684669467046714672467346744675467646774678467946804681468246834684468546864687468846894690469146924693469446954696469746984699470047014702470347044705470647074708470947104711471247134714471547164717471847194720472147224723472447254726472747284729473047314732473347344735473647374738473947404741474247434744474547464747474847494750475147524753475447554756475747584759476047614762476347644765
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <diagram>
  3. <dbsetting>
  4. <dbsystem>MySQL</dbsystem>
  5. <server>localhost</server>
  6. <port>3306</port>
  7. <database>jeesite</database>
  8. <user>root</user>
  9. <password>123456</password>
  10. <use_default_driver>true</use_default_driver>
  11. <url>jdbc:mysql://localhost:3306/jeesite</url>
  12. <driver_class_name>com.mysql.jdbc.Driver</driver_class_name>
  13. </dbsetting>
  14. <page_setting>
  15. <direction_horizontal>true</direction_horizontal>
  16. <scale>100</scale>
  17. <paper_size>A4 210 x 297 mm</paper_size>
  18. <top_margin>30</top_margin>
  19. <left_margin>30</left_margin>
  20. <bottom_margin>30</bottom_margin>
  21. <right_margin>30</right_margin>
  22. </page_setting>
  23. <category_index>0</category_index>
  24. <zoom>1.0</zoom>
  25. <x>452</x>
  26. <y>505</y>
  27. <default_color>
  28. <r>128</r>
  29. <g>128</g>
  30. <b>192</b>
  31. </default_color>
  32. <color>
  33. <r>255</r>
  34. <g>255</g>
  35. <b>255</b>
  36. </color>
  37. <font_name>Segoe UI</font_name>
  38. <font_size>9</font_size>
  39. <settings>
  40. <database>Oracle</database>
  41. <capital>false</capital>
  42. <table_style></table_style>
  43. <notation>IE</notation>
  44. <notation_level>0</notation_level>
  45. <notation_expand_group>true</notation_expand_group>
  46. <view_mode>2</view_mode>
  47. <outline_view_mode>2</outline_view_mode>
  48. <view_order_by>1</view_order_by>
  49. <auto_ime_change>false</auto_ime_change>
  50. <validate_physical_name>true</validate_physical_name>
  51. <use_bezier_curve>false</use_bezier_curve>
  52. <suspend_validator>false</suspend_validator>
  53. <export_setting>
  54. <export_ddl_setting>
  55. <output_path>db\sys\jeesite_oracle.sql</output_path>
  56. <encoding>UTF-8</encoding>
  57. <is_open_after_saved>true</is_open_after_saved>
  58. <environment_id>0</environment_id>
  59. <category_id>null</category_id>
  60. <ddl_target>
  61. <create_comment>false</create_comment>
  62. <create_foreignKey>false</create_foreignKey>
  63. <create_index>true</create_index>
  64. <create_sequence>false</create_sequence>
  65. <create_table>true</create_table>
  66. <create_tablespace>false</create_tablespace>
  67. <create_trigger>false</create_trigger>
  68. <create_view>true</create_view>
  69. <drop_index>true</drop_index>
  70. <drop_sequence>false</drop_sequence>
  71. <drop_table>true</drop_table>
  72. <drop_tablespace>false</drop_tablespace>
  73. <drop_trigger>false</drop_trigger>
  74. <drop_view>false</drop_view>
  75. <inline_column_comment>false</inline_column_comment>
  76. <inline_table_comment>true</inline_table_comment>
  77. <comment_value_description>false</comment_value_description>
  78. <comment_value_logical_name>true</comment_value_logical_name>
  79. <comment_value_logical_name_description>false</comment_value_logical_name_description>
  80. <comment_replace_line_feed>false</comment_replace_line_feed>
  81. <comment_replace_string></comment_replace_string>
  82. </ddl_target>
  83. </export_ddl_setting>
  84. <export_excel_setting>
  85. <category_id>null</category_id>
  86. <output_path></output_path>
  87. <template></template>
  88. <template_path></template_path>
  89. <used_default_template_lang></used_default_template_lang>
  90. <image_output></image_output>
  91. <is_open_after_saved>true</is_open_after_saved>
  92. <is_put_diagram>true</is_put_diagram>
  93. <is_use_logical_name>true</is_use_logical_name>
  94. </export_excel_setting>
  95. <export_html_setting>
  96. <output_dir></output_dir>
  97. <with_category_image>true</with_category_image>
  98. <with_image>true</with_image>
  99. <is_open_after_saved>true</is_open_after_saved>
  100. </export_html_setting>
  101. <export_image_setting>
  102. <output_file_path></output_file_path>
  103. <category_dir_path></category_dir_path>
  104. <with_category_image>true</with_category_image>
  105. <is_open_after_saved>true</is_open_after_saved>
  106. </export_image_setting>
  107. <export_java_setting>
  108. <java_output></java_output>
  109. <package_name></package_name>
  110. <class_name_suffix></class_name_suffix>
  111. <src_file_encoding></src_file_encoding>
  112. <with_hibernate>false</with_hibernate>
  113. </export_java_setting>
  114. <export_testdata_setting>
  115. <file_encoding></file_encoding>
  116. <file_path></file_path>
  117. <format>0</format>
  118. </export_testdata_setting>
  119. </export_setting>
  120. <category_settings>
  121. <free_layout>false</free_layout>
  122. <show_referred_tables>true</show_referred_tables>
  123. <categories>
  124. </categories>
  125. </category_settings>
  126. <translation_settings>
  127. <use>false</use>
  128. <translations>
  129. </translations>
  130. </translation_settings>
  131. <model_properties>
  132. <id></id>
  133. <height>-1</height>
  134. <width>-1</width>
  135. <font_name>Segoe UI</font_name>
  136. <font_size>9</font_size>
  137. <x>47</x>
  138. <y>298</y>
  139. <color>
  140. <r>255</r>
  141. <g>255</g>
  142. <b>255</b>
  143. </color>
  144. <connections>
  145. </connections>
  146. <display>false</display>
  147. <creation_date>2013-04-23 21:13:37</creation_date>
  148. <updated_date>2014-11-07 21:19:06</updated_date>
  149. <model_property>
  150. <name>Project Name</name>
  151. <value>JeeSite</value>
  152. </model_property>
  153. <model_property>
  154. <name>Model Name</name>
  155. <value>SYS、CMS</value>
  156. </model_property>
  157. <model_property>
  158. <name>Version</name>
  159. <value>V1.0</value>
  160. </model_property>
  161. <model_property>
  162. <name>Compnay</name>
  163. <value>ThinkGem</value>
  164. </model_property>
  165. <model_property>
  166. <name>Author</name>
  167. <value>ThinkGem</value>
  168. </model_property>
  169. </model_properties>
  170. <table_properties>
  171. <schema></schema>
  172. </table_properties>
  173. <environment_setting>
  174. <environment>
  175. <id>0</id>
  176. <name>Default</name>
  177. </environment>
  178. </environment_setting>
  179. </settings>
  180. <dictionary>
  181. <word>
  182. <id>0</id>
  183. <length>255</length>
  184. <decimal>null</decimal>
  185. <array>false</array>
  186. <array_dimension>null</array_dimension>
  187. <unsigned>false</unsigned>
  188. <zerofill>false</zerofill>
  189. <binary>false</binary>
  190. <args></args>
  191. <description>联系地址</description>
  192. <logical_name>联系地址</logical_name>
  193. <physical_name>address</physical_name>
  194. <type>nvarchar(n)</type>
  195. </word>
  196. <word>
  197. <id>1</id>
  198. <length>100</length>
  199. <decimal>null</decimal>
  200. <array>false</array>
  201. <array_dimension>null</array_dimension>
  202. <unsigned>false</unsigned>
  203. <zerofill>false</zerofill>
  204. <binary>false</binary>
  205. <args></args>
  206. <description>区域编码</description>
  207. <logical_name>区域编码</logical_name>
  208. <physical_name>code</physical_name>
  209. <type>varchar(n)</type>
  210. </word>
  211. <word>
  212. <id>2</id>
  213. <length>64</length>
  214. <decimal>null</decimal>
  215. <array>false</array>
  216. <array_dimension>null</array_dimension>
  217. <unsigned>false</unsigned>
  218. <zerofill>false</zerofill>
  219. <binary>false</binary>
  220. <args></args>
  221. <description>创建者</description>
  222. <logical_name>创建者</logical_name>
  223. <physical_name>create_by</physical_name>
  224. <type>varchar(n)</type>
  225. </word>
  226. <word>
  227. <id>3</id>
  228. <length>null</length>
  229. <decimal>null</decimal>
  230. <array>false</array>
  231. <array_dimension>null</array_dimension>
  232. <unsigned>false</unsigned>
  233. <zerofill>false</zerofill>
  234. <binary>false</binary>
  235. <args></args>
  236. <description>创建时间</description>
  237. <logical_name>创建时间</logical_name>
  238. <physical_name>create_date</physical_name>
  239. <type>datetime</type>
  240. </word>
  241. <word>
  242. <id>4</id>
  243. <length>1</length>
  244. <decimal>null</decimal>
  245. <array>false</array>
  246. <array_dimension>null</array_dimension>
  247. <unsigned>false</unsigned>
  248. <zerofill>false</zerofill>
  249. <binary>false</binary>
  250. <args></args>
  251. <description>数据范围(0:所有数据;1:所在公司及以下数据;2:所在公司数据;3:所在部门及以下数据;4:所在部门数据;8:仅本人数据;9:按明细设置)</description>
  252. <logical_name>数据范围</logical_name>
  253. <physical_name>data_scope</physical_name>
  254. <type>character(n)</type>
  255. </word>
  256. <word>
  257. <id>5</id>
  258. <length>1</length>
  259. <decimal>null</decimal>
  260. <array>false</array>
  261. <array_dimension>null</array_dimension>
  262. <unsigned>false</unsigned>
  263. <zerofill>false</zerofill>
  264. <binary>false</binary>
  265. <args></args>
  266. <description>删除标记(0:正常;1:删除)</description>
  267. <logical_name>删除标记</logical_name>
  268. <physical_name>del_flag</physical_name>
  269. <type>character(n)</type>
  270. </word>
  271. <word>
  272. <id>6</id>
  273. <length>64</length>
  274. <decimal>null</decimal>
  275. <array>false</array>
  276. <array_dimension>null</array_dimension>
  277. <unsigned>false</unsigned>
  278. <zerofill>false</zerofill>
  279. <binary>false</binary>
  280. <args></args>
  281. <description></description>
  282. <logical_name>副负责人</logical_name>
  283. <physical_name>DEPUTY_PERSON</physical_name>
  284. <type>varchar(n)</type>
  285. </word>
  286. <word>
  287. <id>7</id>
  288. <length>100</length>
  289. <decimal>null</decimal>
  290. <array>false</array>
  291. <array_dimension>null</array_dimension>
  292. <unsigned>false</unsigned>
  293. <zerofill>false</zerofill>
  294. <binary>false</binary>
  295. <args></args>
  296. <description>描述</description>
  297. <logical_name>描述</logical_name>
  298. <physical_name>description</physical_name>
  299. <type>nvarchar(n)</type>
  300. </word>
  301. <word>
  302. <id>8</id>
  303. <length>200</length>
  304. <decimal>null</decimal>
  305. <array>false</array>
  306. <array_dimension>null</array_dimension>
  307. <unsigned>false</unsigned>
  308. <zerofill>false</zerofill>
  309. <binary>false</binary>
  310. <args></args>
  311. <description>邮箱</description>
  312. <logical_name>邮箱</logical_name>
  313. <physical_name>email</physical_name>
  314. <type>nvarchar(n)</type>
  315. </word>
  316. <word>
  317. <id>9</id>
  318. <length>255</length>
  319. <decimal>null</decimal>
  320. <array>false</array>
  321. <array_dimension>null</array_dimension>
  322. <unsigned>false</unsigned>
  323. <zerofill>false</zerofill>
  324. <binary>false</binary>
  325. <args></args>
  326. <description>英文名称</description>
  327. <logical_name>英文名称</logical_name>
  328. <physical_name>enname</physical_name>
  329. <type>varchar(n)</type>
  330. </word>
  331. <word>
  332. <id>10</id>
  333. <length>null</length>
  334. <decimal>null</decimal>
  335. <array>false</array>
  336. <array_dimension>null</array_dimension>
  337. <unsigned>false</unsigned>
  338. <zerofill>false</zerofill>
  339. <binary>false</binary>
  340. <args></args>
  341. <description>异常信息</description>
  342. <logical_name>异常信息</logical_name>
  343. <physical_name>exception</physical_name>
  344. <type>text</type>
  345. </word>
  346. <word>
  347. <id>11</id>
  348. <length>200</length>
  349. <decimal>null</decimal>
  350. <array>false</array>
  351. <array_dimension>null</array_dimension>
  352. <unsigned>false</unsigned>
  353. <zerofill>false</zerofill>
  354. <binary>false</binary>
  355. <args></args>
  356. <description>传真</description>
  357. <logical_name>传真</logical_name>
  358. <physical_name>fax</physical_name>
  359. <type>nvarchar(n)</type>
  360. </word>
  361. <word>
  362. <id>12</id>
  363. <length>1</length>
  364. <decimal>null</decimal>
  365. <array>false</array>
  366. <array_dimension>null</array_dimension>
  367. <unsigned>false</unsigned>
  368. <zerofill>false</zerofill>
  369. <binary>false</binary>
  370. <args></args>
  371. <description>机构等级(1:一级;2:二级;3:三级;4:四级)</description>
  372. <logical_name>机构等级</logical_name>
  373. <physical_name>grade</physical_name>
  374. <type>character(n)</type>
  375. </word>
  376. <word>
  377. <id>13</id>
  378. <length>2000</length>
  379. <decimal>null</decimal>
  380. <array>false</array>
  381. <array_dimension>null</array_dimension>
  382. <unsigned>false</unsigned>
  383. <zerofill>false</zerofill>
  384. <binary>false</binary>
  385. <args></args>
  386. <description>链接</description>
  387. <logical_name>链接</logical_name>
  388. <physical_name>href</physical_name>
  389. <type>varchar(n)</type>
  390. </word>
  391. <word>
  392. <id>14</id>
  393. <length>100</length>
  394. <decimal>null</decimal>
  395. <array>false</array>
  396. <array_dimension>null</array_dimension>
  397. <unsigned>false</unsigned>
  398. <zerofill>false</zerofill>
  399. <binary>false</binary>
  400. <args></args>
  401. <description>图标</description>
  402. <logical_name>图标</logical_name>
  403. <physical_name>icon</physical_name>
  404. <type>varchar(n)</type>
  405. </word>
  406. <word>
  407. <id>15</id>
  408. <length>64</length>
  409. <decimal>null</decimal>
  410. <array>false</array>
  411. <array_dimension>null</array_dimension>
  412. <unsigned>false</unsigned>
  413. <zerofill>false</zerofill>
  414. <binary>false</binary>
  415. <args></args>
  416. <description>编号</description>
  417. <logical_name>编号</logical_name>
  418. <physical_name>id</physical_name>
  419. <type>varchar(n)</type>
  420. </word>
  421. <word>
  422. <id>16</id>
  423. <length>1</length>
  424. <decimal>null</decimal>
  425. <array>false</array>
  426. <array_dimension>null</array_dimension>
  427. <unsigned>false</unsigned>
  428. <zerofill>false</zerofill>
  429. <binary>false</binary>
  430. <args></args>
  431. <description>是否在菜单中显示(1:显示;0:不显示)</description>
  432. <logical_name>是否在菜单中显示</logical_name>
  433. <physical_name>is_show</physical_name>
  434. <type>character(n)</type>
  435. </word>
  436. <word>
  437. <id>17</id>
  438. <length>64</length>
  439. <decimal>null</decimal>
  440. <array>false</array>
  441. <array_dimension>null</array_dimension>
  442. <unsigned>false</unsigned>
  443. <zerofill>false</zerofill>
  444. <binary>false</binary>
  445. <args></args>
  446. <description></description>
  447. <logical_name>是否系统数据</logical_name>
  448. <physical_name>is_sys</physical_name>
  449. <type>varchar(n)</type>
  450. </word>
  451. <word>
  452. <id>18</id>
  453. <length>100</length>
  454. <decimal>null</decimal>
  455. <array>false</array>
  456. <array_dimension>null</array_dimension>
  457. <unsigned>false</unsigned>
  458. <zerofill>false</zerofill>
  459. <binary>false</binary>
  460. <args></args>
  461. <description>标签名</description>
  462. <logical_name>标签名</logical_name>
  463. <physical_name>label</physical_name>
  464. <type>varchar(n)</type>
  465. </word>
  466. <word>
  467. <id>19</id>
  468. <length>null</length>
  469. <decimal>null</decimal>
  470. <array>false</array>
  471. <array_dimension>null</array_dimension>
  472. <unsigned>false</unsigned>
  473. <zerofill>false</zerofill>
  474. <binary>false</binary>
  475. <args></args>
  476. <description>最后登陆时间</description>
  477. <logical_name>最后登陆时间</logical_name>
  478. <physical_name>login_date</physical_name>
  479. <type>datetime</type>
  480. </word>
  481. <word>
  482. <id>20</id>
  483. <length>64</length>
  484. <decimal>null</decimal>
  485. <array>false</array>
  486. <array_dimension>null</array_dimension>
  487. <unsigned>false</unsigned>
  488. <zerofill>false</zerofill>
  489. <binary>false</binary>
  490. <args></args>
  491. <description></description>
  492. <logical_name>是否可登录</logical_name>
  493. <physical_name>login_flag</physical_name>
  494. <type>varchar(n)</type>
  495. </word>
  496. <word>
  497. <id>21</id>
  498. <length>100</length>
  499. <decimal>null</decimal>
  500. <array>false</array>
  501. <array_dimension>null</array_dimension>
  502. <unsigned>false</unsigned>
  503. <zerofill>false</zerofill>
  504. <binary>false</binary>
  505. <args></args>
  506. <description>最后登陆IP</description>
  507. <logical_name>最后登陆IP</logical_name>
  508. <physical_name>login_ip</physical_name>
  509. <type>varchar(n)</type>
  510. </word>
  511. <word>
  512. <id>22</id>
  513. <length>100</length>
  514. <decimal>null</decimal>
  515. <array>false</array>
  516. <array_dimension>null</array_dimension>
  517. <unsigned>false</unsigned>
  518. <zerofill>false</zerofill>
  519. <binary>false</binary>
  520. <args></args>
  521. <description>登录名</description>
  522. <logical_name>登录名</logical_name>
  523. <physical_name>login_name</physical_name>
  524. <type>varchar(n)</type>
  525. </word>
  526. <word>
  527. <id>23</id>
  528. <length>100</length>
  529. <decimal>null</decimal>
  530. <array>false</array>
  531. <array_dimension>null</array_dimension>
  532. <unsigned>false</unsigned>
  533. <zerofill>false</zerofill>
  534. <binary>false</binary>
  535. <args></args>
  536. <description>负责人</description>
  537. <logical_name>负责人</logical_name>
  538. <physical_name>master</physical_name>
  539. <type>nvarchar(n)</type>
  540. </word>
  541. <word>
  542. <id>24</id>
  543. <length>5</length>
  544. <decimal>null</decimal>
  545. <array>false</array>
  546. <array_dimension>null</array_dimension>
  547. <unsigned>false</unsigned>
  548. <zerofill>false</zerofill>
  549. <binary>false</binary>
  550. <args></args>
  551. <description>操作方式</description>
  552. <logical_name>操作方式</logical_name>
  553. <physical_name>method</physical_name>
  554. <type>varchar(n)</type>
  555. </word>
  556. <word>
  557. <id>25</id>
  558. <length>200</length>
  559. <decimal>null</decimal>
  560. <array>false</array>
  561. <array_dimension>null</array_dimension>
  562. <unsigned>false</unsigned>
  563. <zerofill>false</zerofill>
  564. <binary>false</binary>
  565. <args></args>
  566. <description>手机</description>
  567. <logical_name>手机</logical_name>
  568. <physical_name>mobile</physical_name>
  569. <type>varchar(n)</type>
  570. </word>
  571. <word>
  572. <id>26</id>
  573. <length>100</length>
  574. <decimal>null</decimal>
  575. <array>false</array>
  576. <array_dimension>null</array_dimension>
  577. <unsigned>false</unsigned>
  578. <zerofill>false</zerofill>
  579. <binary>false</binary>
  580. <args></args>
  581. <description>名称</description>
  582. <logical_name>名称</logical_name>
  583. <physical_name>name</physical_name>
  584. <type>nvarchar(n)</type>
  585. </word>
  586. <word>
  587. <id>27</id>
  588. <length>100</length>
  589. <decimal>null</decimal>
  590. <array>false</array>
  591. <array_dimension>null</array_dimension>
  592. <unsigned>false</unsigned>
  593. <zerofill>false</zerofill>
  594. <binary>false</binary>
  595. <args></args>
  596. <description>姓名</description>
  597. <logical_name>姓名</logical_name>
  598. <physical_name>name</physical_name>
  599. <type>nvarchar(n)</type>
  600. </word>
  601. <word>
  602. <id>28</id>
  603. <length>100</length>
  604. <decimal>null</decimal>
  605. <array>false</array>
  606. <array_dimension>null</array_dimension>
  607. <unsigned>false</unsigned>
  608. <zerofill>false</zerofill>
  609. <binary>false</binary>
  610. <args></args>
  611. <description>角色名称</description>
  612. <logical_name>角色名称</logical_name>
  613. <physical_name>name</physical_name>
  614. <type>nvarchar(n)</type>
  615. </word>
  616. <word>
  617. <id>29</id>
  618. <length>100</length>
  619. <decimal>null</decimal>
  620. <array>false</array>
  621. <array_dimension>null</array_dimension>
  622. <unsigned>false</unsigned>
  623. <zerofill>false</zerofill>
  624. <binary>false</binary>
  625. <args></args>
  626. <description>工号</description>
  627. <logical_name>工号</logical_name>
  628. <physical_name>no</physical_name>
  629. <type>varchar(n)</type>
  630. </word>
  631. <word>
  632. <id>30</id>
  633. <length>64</length>
  634. <decimal>null</decimal>
  635. <array>false</array>
  636. <array_dimension>null</array_dimension>
  637. <unsigned>false</unsigned>
  638. <zerofill>false</zerofill>
  639. <binary>false</binary>
  640. <args></args>
  641. <description>归属机构</description>
  642. <logical_name>归属机构</logical_name>
  643. <physical_name>office_id</physical_name>
  644. <type>varchar(n)</type>
  645. </word>
  646. <word>
  647. <id>31</id>
  648. <length>null</length>
  649. <decimal>null</decimal>
  650. <array>false</array>
  651. <array_dimension>null</array_dimension>
  652. <unsigned>false</unsigned>
  653. <zerofill>false</zerofill>
  654. <binary>false</binary>
  655. <args></args>
  656. <description>操作提交的数据</description>
  657. <logical_name>操作提交的数据</logical_name>
  658. <physical_name>params</physical_name>
  659. <type>text</type>
  660. </word>
  661. <word>
  662. <id>32</id>
  663. <length>64</length>
  664. <decimal>null</decimal>
  665. <array>false</array>
  666. <array_dimension>null</array_dimension>
  667. <unsigned>false</unsigned>
  668. <zerofill>false</zerofill>
  669. <binary>false</binary>
  670. <args></args>
  671. <description>父级编号</description>
  672. <logical_name>父级编号</logical_name>
  673. <physical_name>parent_id</physical_name>
  674. <type>varchar(n)</type>
  675. </word>
  676. <word>
  677. <id>33</id>
  678. <length>64</length>
  679. <decimal>null</decimal>
  680. <array>false</array>
  681. <array_dimension>null</array_dimension>
  682. <unsigned>false</unsigned>
  683. <zerofill>false</zerofill>
  684. <binary>false</binary>
  685. <args></args>
  686. <description>父级编号</description>
  687. <logical_name>父级编号</logical_name>
  688. <physical_name>parent_id</physical_name>
  689. <type>varchar(n)</type>
  690. </word>
  691. <word>
  692. <id>34</id>
  693. <length>2000</length>
  694. <decimal>null</decimal>
  695. <array>false</array>
  696. <array_dimension>null</array_dimension>
  697. <unsigned>false</unsigned>
  698. <zerofill>false</zerofill>
  699. <binary>false</binary>
  700. <args></args>
  701. <description>所有父级编号</description>
  702. <logical_name>所有父级编号</logical_name>
  703. <physical_name>parent_ids</physical_name>
  704. <type>varchar(n)</type>
  705. </word>
  706. <word>
  707. <id>35</id>
  708. <length>100</length>
  709. <decimal>null</decimal>
  710. <array>false</array>
  711. <array_dimension>null</array_dimension>
  712. <unsigned>false</unsigned>
  713. <zerofill>false</zerofill>
  714. <binary>false</binary>
  715. <args></args>
  716. <description>密码</description>
  717. <logical_name>密码</logical_name>
  718. <physical_name>password</physical_name>
  719. <type>varchar(n)</type>
  720. </word>
  721. <word>
  722. <id>36</id>
  723. <length>200</length>
  724. <decimal>null</decimal>
  725. <array>false</array>
  726. <array_dimension>null</array_dimension>
  727. <unsigned>false</unsigned>
  728. <zerofill>false</zerofill>
  729. <binary>false</binary>
  730. <args></args>
  731. <description>权限标识</description>
  732. <logical_name>权限标识</logical_name>
  733. <physical_name>permission</physical_name>
  734. <type>varchar(n)</type>
  735. </word>
  736. <word>
  737. <id>37</id>
  738. <length>200</length>
  739. <decimal>null</decimal>
  740. <array>false</array>
  741. <array_dimension>null</array_dimension>
  742. <unsigned>false</unsigned>
  743. <zerofill>false</zerofill>
  744. <binary>false</binary>
  745. <args></args>
  746. <description>电话</description>
  747. <logical_name>电话</logical_name>
  748. <physical_name>phone</physical_name>
  749. <type>nvarchar(n)</type>
  750. </word>
  751. <word>
  752. <id>38</id>
  753. <length>200</length>
  754. <decimal>null</decimal>
  755. <array>false</array>
  756. <array_dimension>null</array_dimension>
  757. <unsigned>false</unsigned>
  758. <zerofill>false</zerofill>
  759. <binary>false</binary>
  760. <args></args>
  761. <description>电话</description>
  762. <logical_name>电话</logical_name>
  763. <physical_name>phone</physical_name>
  764. <type>varchar(n)</type>
  765. </word>
  766. <word>
  767. <id>39</id>
  768. <length>1000</length>
  769. <decimal>null</decimal>
  770. <array>false</array>
  771. <array_dimension>null</array_dimension>
  772. <unsigned>false</unsigned>
  773. <zerofill>false</zerofill>
  774. <binary>false</binary>
  775. <args></args>
  776. <description></description>
  777. <logical_name>用户头像</logical_name>
  778. <physical_name>photo</physical_name>
  779. <type>varchar(n)</type>
  780. </word>
  781. <word>
  782. <id>40</id>
  783. <length>64</length>
  784. <decimal>null</decimal>
  785. <array>false</array>
  786. <array_dimension>null</array_dimension>
  787. <unsigned>false</unsigned>
  788. <zerofill>false</zerofill>
  789. <binary>false</binary>
  790. <args></args>
  791. <description></description>
  792. <logical_name>主负责人</logical_name>
  793. <physical_name>PRIMARY_PERSON</physical_name>
  794. <type>varchar(n)</type>
  795. </word>
  796. <word>
  797. <id>41</id>
  798. <length>255</length>
  799. <decimal>null</decimal>
  800. <array>false</array>
  801. <array_dimension>null</array_dimension>
  802. <unsigned>false</unsigned>
  803. <zerofill>false</zerofill>
  804. <binary>false</binary>
  805. <args></args>
  806. <description>备注信息</description>
  807. <logical_name>备注信息</logical_name>
  808. <physical_name>remarks</physical_name>
  809. <type>nvarchar(n)</type>
  810. </word>
  811. <word>
  812. <id>42</id>
  813. <length>255</length>
  814. <decimal>null</decimal>
  815. <array>false</array>
  816. <array_dimension>null</array_dimension>
  817. <unsigned>false</unsigned>
  818. <zerofill>false</zerofill>
  819. <binary>false</binary>
  820. <args></args>
  821. <description>操作IP地址</description>
  822. <logical_name>操作IP地址</logical_name>
  823. <physical_name>remote_addr</physical_name>
  824. <type>varchar(n)</type>
  825. </word>
  826. <word>
  827. <id>43</id>
  828. <length>255</length>
  829. <decimal>null</decimal>
  830. <array>false</array>
  831. <array_dimension>null</array_dimension>
  832. <unsigned>false</unsigned>
  833. <zerofill>false</zerofill>
  834. <binary>false</binary>
  835. <args></args>
  836. <description>请求URI</description>
  837. <logical_name>请求URI</logical_name>
  838. <physical_name>request_uri</physical_name>
  839. <type>varchar(n)</type>
  840. </word>
  841. <word>
  842. <id>44</id>
  843. <length>255</length>
  844. <decimal>null</decimal>
  845. <array>false</array>
  846. <array_dimension>null</array_dimension>
  847. <unsigned>false</unsigned>
  848. <zerofill>false</zerofill>
  849. <binary>false</binary>
  850. <args></args>
  851. <description>角色类型</description>
  852. <logical_name>角色类型</logical_name>
  853. <physical_name>role_type</physical_name>
  854. <type>varchar(n)</type>
  855. </word>
  856. <word>
  857. <id>45</id>
  858. <length>10</length>
  859. <decimal>0</decimal>
  860. <array>false</array>
  861. <array_dimension>null</array_dimension>
  862. <unsigned>false</unsigned>
  863. <zerofill>false</zerofill>
  864. <binary>false</binary>
  865. <args></args>
  866. <description>排序</description>
  867. <logical_name>排序</logical_name>
  868. <physical_name>sort</physical_name>
  869. <type>decimal(p,s)</type>
  870. </word>
  871. <word>
  872. <id>46</id>
  873. <length>10</length>
  874. <decimal>0</decimal>
  875. <array>false</array>
  876. <array_dimension>null</array_dimension>
  877. <unsigned>false</unsigned>
  878. <zerofill>false</zerofill>
  879. <binary>false</binary>
  880. <args></args>
  881. <description>排序(升序)</description>
  882. <logical_name>排序(升序)</logical_name>
  883. <physical_name>sort</physical_name>
  884. <type>decimal(p,s)</type>
  885. </word>
  886. <word>
  887. <id>47</id>
  888. <length>20</length>
  889. <decimal>null</decimal>
  890. <array>false</array>
  891. <array_dimension>null</array_dimension>
  892. <unsigned>false</unsigned>
  893. <zerofill>false</zerofill>
  894. <binary>false</binary>
  895. <args></args>
  896. <description>目标(mainFrame、 _blank、_self、_parent、_top)</description>
  897. <logical_name>目标</logical_name>
  898. <physical_name>target</physical_name>
  899. <type>varchar(n)</type>
  900. </word>
  901. <word>
  902. <id>48</id>
  903. <length>500</length>
  904. <decimal>null</decimal>
  905. <array>false</array>
  906. <array_dimension>null</array_dimension>
  907. <unsigned>false</unsigned>
  908. <zerofill>false</zerofill>
  909. <binary>false</binary>
  910. <args></args>
  911. <description></description>
  912. <logical_name>日志标题</logical_name>
  913. <physical_name>title</physical_name>
  914. <type>nvarchar(n)</type>
  915. </word>
  916. <word>
  917. <id>49</id>
  918. <length>1</length>
  919. <decimal>null</decimal>
  920. <array>false</array>
  921. <array_dimension>null</array_dimension>
  922. <unsigned>false</unsigned>
  923. <zerofill>false</zerofill>
  924. <binary>false</binary>
  925. <args></args>
  926. <description>区域类型(1:国家;2:省份、直辖市;3:地市;4:区县)</description>
  927. <logical_name>区域类型</logical_name>
  928. <physical_name>type</physical_name>
  929. <type>character(n)</type>
  930. </word>
  931. <word>
  932. <id>50</id>
  933. <length>1</length>
  934. <decimal>null</decimal>
  935. <array>false</array>
  936. <array_dimension>null</array_dimension>
  937. <unsigned>false</unsigned>
  938. <zerofill>false</zerofill>
  939. <binary>false</binary>
  940. <args></args>
  941. <description>日志类型(1:接入日志;2:异常日志)</description>
  942. <logical_name>日志类型</logical_name>
  943. <physical_name>type</physical_name>
  944. <type>character(n)</type>
  945. </word>
  946. <word>
  947. <id>51</id>
  948. <length>1</length>
  949. <decimal>null</decimal>
  950. <array>false</array>
  951. <array_dimension>null</array_dimension>
  952. <unsigned>false</unsigned>
  953. <zerofill>false</zerofill>
  954. <binary>false</binary>
  955. <args></args>
  956. <description>机构类型(1:公司;2:部门;3:小组)</description>
  957. <logical_name>机构类型</logical_name>
  958. <physical_name>type</physical_name>
  959. <type>character(n)</type>
  960. </word>
  961. <word>
  962. <id>52</id>
  963. <length>100</length>
  964. <decimal>null</decimal>
  965. <array>false</array>
  966. <array_dimension>null</array_dimension>
  967. <unsigned>false</unsigned>
  968. <zerofill>false</zerofill>
  969. <binary>false</binary>
  970. <args></args>
  971. <description>类型</description>
  972. <logical_name>类型</logical_name>
  973. <physical_name>type</physical_name>
  974. <type>varchar(n)</type>
  975. </word>
  976. <word>
  977. <id>53</id>
  978. <length>64</length>
  979. <decimal>null</decimal>
  980. <array>false</array>
  981. <array_dimension>null</array_dimension>
  982. <unsigned>false</unsigned>
  983. <zerofill>false</zerofill>
  984. <binary>false</binary>
  985. <args></args>
  986. <description>更新者</description>
  987. <logical_name>更新者</logical_name>
  988. <physical_name>update_by</physical_name>
  989. <type>varchar(n)</type>
  990. </word>
  991. <word>
  992. <id>54</id>
  993. <length>null</length>
  994. <decimal>null</decimal>
  995. <array>false</array>
  996. <array_dimension>null</array_dimension>
  997. <unsigned>false</unsigned>
  998. <zerofill>false</zerofill>
  999. <binary>false</binary>
  1000. <args></args>
  1001. <description>更新时间</description>
  1002. <logical_name>更新时间</logical_name>
  1003. <physical_name>update_date</physical_name>
  1004. <type>datetime</type>
  1005. </word>
  1006. <word>
  1007. <id>55</id>
  1008. <length>64</length>
  1009. <decimal>null</decimal>
  1010. <array>false</array>
  1011. <array_dimension>null</array_dimension>
  1012. <unsigned>false</unsigned>
  1013. <zerofill>false</zerofill>
  1014. <binary>false</binary>
  1015. <args></args>
  1016. <description></description>
  1017. <logical_name>是否可用</logical_name>
  1018. <physical_name>useable</physical_name>
  1019. <type>varchar(n)</type>
  1020. </word>
  1021. <word>
  1022. <id>56</id>
  1023. <length>64</length>
  1024. <decimal>null</decimal>
  1025. <array>false</array>
  1026. <array_dimension>null</array_dimension>
  1027. <unsigned>false</unsigned>
  1028. <zerofill>false</zerofill>
  1029. <binary>false</binary>
  1030. <args></args>
  1031. <description></description>
  1032. <logical_name>是否启用</logical_name>
  1033. <physical_name>USEABLE</physical_name>
  1034. <type>varchar(n)</type>
  1035. </word>
  1036. <word>
  1037. <id>57</id>
  1038. <length>255</length>
  1039. <decimal>null</decimal>
  1040. <array>false</array>
  1041. <array_dimension>null</array_dimension>
  1042. <unsigned>false</unsigned>
  1043. <zerofill>false</zerofill>
  1044. <binary>false</binary>
  1045. <args></args>
  1046. <description>用户代理</description>
  1047. <logical_name>用户代理</logical_name>
  1048. <physical_name>user_agent</physical_name>
  1049. <type>varchar(n)</type>
  1050. </word>
  1051. <word>
  1052. <id>58</id>
  1053. <length>1</length>
  1054. <decimal>null</decimal>
  1055. <array>false</array>
  1056. <array_dimension>null</array_dimension>
  1057. <unsigned>false</unsigned>
  1058. <zerofill>false</zerofill>
  1059. <binary>false</binary>
  1060. <args></args>
  1061. <description>用户类型</description>
  1062. <logical_name>用户类型</logical_name>
  1063. <physical_name>user_type</physical_name>
  1064. <type>character(n)</type>
  1065. </word>
  1066. <word>
  1067. <id>59</id>
  1068. <length>100</length>
  1069. <decimal>null</decimal>
  1070. <array>false</array>
  1071. <array_dimension>null</array_dimension>
  1072. <unsigned>false</unsigned>
  1073. <zerofill>false</zerofill>
  1074. <binary>false</binary>
  1075. <args></args>
  1076. <description>数据值</description>
  1077. <logical_name>数据值</logical_name>
  1078. <physical_name>value</physical_name>
  1079. <type>varchar(n)</type>
  1080. </word>
  1081. <word>
  1082. <id>60</id>
  1083. <length>100</length>
  1084. <decimal>null</decimal>
  1085. <array>false</array>
  1086. <array_dimension>null</array_dimension>
  1087. <unsigned>false</unsigned>
  1088. <zerofill>false</zerofill>
  1089. <binary>false</binary>
  1090. <args></args>
  1091. <description>邮政编码</description>
  1092. <logical_name>邮政编码</logical_name>
  1093. <physical_name>zip_code</physical_name>
  1094. <type>varchar(n)</type>
  1095. </word>
  1096. </dictionary>
  1097. <tablespace_set>
  1098. </tablespace_set>
  1099. <contents>
  1100. <table>
  1101. <id>0</id>
  1102. <height>-1</height>
  1103. <width>-1</width>
  1104. <font_name>Segoe UI</font_name>
  1105. <font_size>9</font_size>
  1106. <x>392</x>
  1107. <y>676</y>
  1108. <color>
  1109. <r>128</r>
  1110. <g>128</g>
  1111. <b>192</b>
  1112. </color>
  1113. <connections>
  1114. <relation>
  1115. <id>0</id>
  1116. <source>9</source>
  1117. <target>0</target>
  1118. <source_xp>-1</source_xp>
  1119. <source_yp>-1</source_yp>
  1120. <target_xp>-1</target_xp>
  1121. <target_yp>-1</target_yp>
  1122. <color>
  1123. <r>0</r>
  1124. <g>0</g>
  1125. <b>0</b>
  1126. </color>
  1127. <child_cardinality>1..n</child_cardinality>
  1128. <parent_cardinality>1</parent_cardinality>
  1129. <reference_for_pk>true</reference_for_pk>
  1130. <name></name>
  1131. <on_delete_action>RESTRICT</on_delete_action>
  1132. <on_update_action>RESTRICT</on_update_action>
  1133. <referenced_column>null</referenced_column>
  1134. <referenced_complex_unique_key>null</referenced_complex_unique_key>
  1135. </relation>
  1136. <relation>
  1137. <id>1</id>
  1138. <source>8</source>
  1139. <target>0</target>
  1140. <source_xp>-1</source_xp>
  1141. <source_yp>-1</source_yp>
  1142. <target_xp>-1</target_xp>
  1143. <target_yp>-1</target_yp>
  1144. <color>
  1145. <r>0</r>
  1146. <g>0</g>
  1147. <b>0</b>
  1148. </color>
  1149. <child_cardinality>1..n</child_cardinality>
  1150. <parent_cardinality>1</parent_cardinality>
  1151. <reference_for_pk>true</reference_for_pk>
  1152. <name></name>
  1153. <on_delete_action>RESTRICT</on_delete_action>
  1154. <on_update_action>RESTRICT</on_update_action>
  1155. <referenced_column>null</referenced_column>
  1156. <referenced_complex_unique_key>null</referenced_complex_unique_key>
  1157. </relation>
  1158. </connections>
  1159. <physical_name>sys_role_office</physical_name>
  1160. <logical_name>角色-机构</logical_name>
  1161. <description>角色-机构</description>
  1162. <constraint></constraint>
  1163. <primary_key_name></primary_key_name>
  1164. <option></option>
  1165. <columns>
  1166. <normal_column>
  1167. <id>10</id>
  1168. <referenced_column>45</referenced_column>
  1169. <relation>1</relation>
  1170. <description>角色编号</description>
  1171. <unique_key_name></unique_key_name>
  1172. <logical_name>角色编号</logical_name>
  1173. <physical_name>role_id</physical_name>
  1174. <type>varchar(n)</type>
  1175. <constraint></constraint>
  1176. <default_value></default_value>
  1177. <auto_increment>false</auto_increment>
  1178. <foreign_key>true</foreign_key>
  1179. <not_null>true</not_null>
  1180. <primary_key>true</primary_key>
  1181. <unique_key>false</unique_key>
  1182. <character_set></character_set>
  1183. <collation></collation>
  1184. <sequence>
  1185. <name></name>
  1186. <schema></schema>
  1187. <increment></increment>
  1188. <min_value></min_value>
  1189. <max_value></max_value>
  1190. <start></start>
  1191. <cache></cache>
  1192. <nocache>false</nocache>
  1193. <cycle>false</cycle>
  1194. <order>false</order>
  1195. <description></description>
  1196. <data_type></data_type>
  1197. <decimal_size>0</decimal_size>
  1198. </sequence>
  1199. </normal_column>
  1200. <normal_column>
  1201. <id>11</id>
  1202. <referenced_column>53</referenced_column>
  1203. <relation>0</relation>
  1204. <description>机构编号</description>
  1205. <unique_key_name></unique_key_name>
  1206. <logical_name>机构编号</logical_name>
  1207. <physical_name>office_id</physical_name>
  1208. <type>varchar(n)</type>
  1209. <constraint></constraint>
  1210. <default_value></default_value>
  1211. <auto_increment>false</auto_increment>
  1212. <foreign_key>true</foreign_key>
  1213. <not_null>true</not_null>
  1214. <primary_key>true</primary_key>
  1215. <unique_key>false</unique_key>
  1216. <character_set></character_set>
  1217. <collation></collation>
  1218. <sequence>
  1219. <name></name>
  1220. <schema></schema>
  1221. <increment></increment>
  1222. <min_value></min_value>
  1223. <max_value></max_value>
  1224. <start></start>
  1225. <cache></cache>
  1226. <nocache>false</nocache>
  1227. <cycle>false</cycle>
  1228. <order>false</order>
  1229. <description></description>
  1230. <data_type></data_type>
  1231. <decimal_size>0</decimal_size>
  1232. </sequence>
  1233. </normal_column>
  1234. </columns>
  1235. <indexes>
  1236. </indexes>
  1237. <complex_unique_key_list>
  1238. </complex_unique_key_list>
  1239. <table_properties>
  1240. <schema></schema>
  1241. </table_properties>
  1242. </table>
  1243. <table>
  1244. <id>1</id>
  1245. <height>-1</height>
  1246. <width>-1</width>
  1247. <font_name>Segoe UI</font_name>
  1248. <font_size>9</font_size>
  1249. <x>396</x>
  1250. <y>529</y>
  1251. <color>
  1252. <r>128</r>
  1253. <g>128</g>
  1254. <b>192</b>
  1255. </color>
  1256. <connections>
  1257. <relation>
  1258. <id>2</id>
  1259. <source>8</source>
  1260. <target>1</target>
  1261. <source_xp>-1</source_xp>
  1262. <source_yp>-1</source_yp>
  1263. <target_xp>-1</target_xp>
  1264. <target_yp>-1</target_yp>
  1265. <color>
  1266. <r>0</r>
  1267. <g>0</g>
  1268. <b>0</b>
  1269. </color>
  1270. <child_cardinality>1..n</child_cardinality>
  1271. <parent_cardinality>1</parent_cardinality>
  1272. <reference_for_pk>true</reference_for_pk>
  1273. <name></name>
  1274. <on_delete_action>RESTRICT</on_delete_action>
  1275. <on_update_action>RESTRICT</on_update_action>
  1276. <referenced_column>null</referenced_column>
  1277. <referenced_complex_unique_key>null</referenced_complex_unique_key>
  1278. </relation>
  1279. <relation>
  1280. <id>3</id>
  1281. <source>10</source>
  1282. <target>1</target>
  1283. <source_xp>-1</source_xp>
  1284. <source_yp>-1</source_yp>
  1285. <target_xp>-1</target_xp>
  1286. <target_yp>-1</target_yp>
  1287. <color>
  1288. <r>0</r>
  1289. <g>0</g>
  1290. <b>0</b>
  1291. </color>
  1292. <child_cardinality>1..n</child_cardinality>
  1293. <parent_cardinality>1</parent_cardinality>
  1294. <reference_for_pk>true</reference_for_pk>
  1295. <name></name>
  1296. <on_delete_action>RESTRICT</on_delete_action>
  1297. <on_update_action>RESTRICT</on_update_action>
  1298. <referenced_column>null</referenced_column>
  1299. <referenced_complex_unique_key>null</referenced_complex_unique_key>
  1300. </relation>
  1301. </connections>
  1302. <physical_name>sys_user_role</physical_name>
  1303. <logical_name>用户-角色</logical_name>
  1304. <description>用户-角色</description>
  1305. <constraint></constraint>
  1306. <primary_key_name></primary_key_name>
  1307. <option></option>
  1308. <columns>
  1309. <normal_column>
  1310. <id>12</id>
  1311. <referenced_column>67</referenced_column>
  1312. <relation>3</relation>
  1313. <description>用户编号</description>
  1314. <unique_key_name></unique_key_name>
  1315. <logical_name>用户编号</logical_name>
  1316. <physical_name>user_id</physical_name>
  1317. <type>varchar(n)</type>
  1318. <constraint></constraint>
  1319. <default_value></default_value>
  1320. <auto_increment>false</auto_increment>
  1321. <foreign_key>true</foreign_key>
  1322. <not_null>true</not_null>
  1323. <primary_key>true</primary_key>
  1324. <unique_key>false</unique_key>
  1325. <character_set></character_set>
  1326. <collation></collation>
  1327. <sequence>
  1328. <name></name>
  1329. <schema></schema>
  1330. <increment></increment>
  1331. <min_value></min_value>
  1332. <max_value></max_value>
  1333. <start></start>
  1334. <cache></cache>
  1335. <nocache>false</nocache>
  1336. <cycle>false</cycle>
  1337. <order>false</order>
  1338. <description></description>
  1339. <data_type></data_type>
  1340. <decimal_size>0</decimal_size>
  1341. </sequence>
  1342. </normal_column>
  1343. <normal_column>
  1344. <id>13</id>
  1345. <referenced_column>45</referenced_column>
  1346. <relation>2</relation>
  1347. <description>角色编号</description>
  1348. <unique_key_name></unique_key_name>
  1349. <logical_name>角色编号</logical_name>
  1350. <physical_name>role_id</physical_name>
  1351. <type>varchar(n)</type>
  1352. <constraint></constraint>
  1353. <default_value></default_value>
  1354. <auto_increment>false</auto_increment>
  1355. <foreign_key>true</foreign_key>
  1356. <not_null>true</not_null>
  1357. <primary_key>true</primary_key>
  1358. <unique_key>false</unique_key>
  1359. <character_set></character_set>
  1360. <collation></collation>
  1361. <sequence>
  1362. <name></name>
  1363. <schema></schema>
  1364. <increment></increment>
  1365. <min_value></min_value>
  1366. <max_value></max_value>
  1367. <start></start>
  1368. <cache></cache>
  1369. <nocache>false</nocache>
  1370. <cycle>false</cycle>
  1371. <order>false</order>
  1372. <description></description>
  1373. <data_type></data_type>
  1374. <decimal_size>0</decimal_size>
  1375. </sequence>
  1376. </normal_column>
  1377. </columns>
  1378. <indexes>
  1379. </indexes>
  1380. <complex_unique_key_list>
  1381. </complex_unique_key_list>
  1382. <table_properties>
  1383. <schema></schema>
  1384. </table_properties>
  1385. </table>
  1386. <table>
  1387. <id>2</id>
  1388. <height>-1</height>
  1389. <width>-1</width>
  1390. <font_name>Segoe UI</font_name>
  1391. <font_size>9</font_size>
  1392. <x>723</x>
  1393. <y>440</y>
  1394. <color>
  1395. <r>128</r>
  1396. <g>128</g>
  1397. <b>192</b>
  1398. </color>
  1399. <connections>
  1400. <relation>
  1401. <id>4</id>
  1402. <source>4</source>
  1403. <target>2</target>
  1404. <source_xp>-1</source_xp>
  1405. <source_yp>-1</source_yp>
  1406. <target_xp>-1</target_xp>
  1407. <target_yp>-1</target_yp>
  1408. <color>
  1409. <r>0</r>
  1410. <g>0</g>
  1411. <b>0</b>
  1412. </color>
  1413. <child_cardinality>1..n</child_cardinality>
  1414. <parent_cardinality>1</parent_cardinality>
  1415. <reference_for_pk>true</reference_for_pk>
  1416. <name></name>
  1417. <on_delete_action>RESTRICT</on_delete_action>
  1418. <on_update_action>RESTRICT</on_update_action>
  1419. <referenced_column>null</referenced_column>
  1420. <referenced_complex_unique_key>null</referenced_complex_unique_key>
  1421. </relation>
  1422. <relation>
  1423. <id>5</id>
  1424. <source>8</source>
  1425. <target>2</target>
  1426. <source_xp>-1</source_xp>
  1427. <source_yp>-1</source_yp>
  1428. <target_xp>-1</target_xp>
  1429. <target_yp>-1</target_yp>
  1430. <color>
  1431. <r>0</r>
  1432. <g>0</g>
  1433. <b>0</b>
  1434. </color>
  1435. <child_cardinality>1..n</child_cardinality>
  1436. <parent_cardinality>1</parent_cardinality>
  1437. <reference_for_pk>true</reference_for_pk>
  1438. <name></name>
  1439. <on_delete_action>RESTRICT</on_delete_action>
  1440. <on_update_action>RESTRICT</on_update_action>
  1441. <referenced_column>null</referenced_column>
  1442. <referenced_complex_unique_key>null</referenced_complex_unique_key>
  1443. </relation>
  1444. </connections>
  1445. <physical_name>sys_role_menu</physical_name>
  1446. <logical_name>角色-菜单</logical_name>
  1447. <description>角色-菜单</description>
  1448. <constraint></constraint>
  1449. <primary_key_name></primary_key_name>
  1450. <option></option>
  1451. <columns>
  1452. <normal_column>
  1453. <id>14</id>
  1454. <referenced_column>45</referenced_column>
  1455. <relation>5</relation>
  1456. <description>角色编号</description>
  1457. <unique_key_name></unique_key_name>
  1458. <logical_name>角色编号</logical_name>
  1459. <physical_name>role_id</physical_name>
  1460. <type>varchar(n)</type>
  1461. <constraint></constraint>
  1462. <default_value></default_value>
  1463. <auto_increment>false</auto_increment>
  1464. <foreign_key>true</foreign_key>
  1465. <not_null>true</not_null>
  1466. <primary_key>true</primary_key>
  1467. <unique_key>false</unique_key>
  1468. <character_set></character_set>
  1469. <collation></collation>
  1470. <sequence>
  1471. <name></name>
  1472. <schema></schema>
  1473. <increment></increment>
  1474. <min_value></min_value>
  1475. <max_value></max_value>
  1476. <start></start>
  1477. <cache></cache>
  1478. <nocache>false</nocache>
  1479. <cycle>false</cycle>
  1480. <order>false</order>
  1481. <description></description>
  1482. <data_type></data_type>
  1483. <decimal_size>0</decimal_size>
  1484. </sequence>
  1485. </normal_column>
  1486. <normal_column>
  1487. <id>15</id>
  1488. <referenced_column>19</referenced_column>
  1489. <relation>4</relation>
  1490. <description>菜单编号</description>
  1491. <unique_key_name></unique_key_name>
  1492. <logical_name>菜单编号</logical_name>
  1493. <physical_name>menu_id</physical_name>
  1494. <type>varchar(n)</type>
  1495. <constraint></constraint>
  1496. <default_value></default_value>
  1497. <auto_increment>false</auto_increment>
  1498. <foreign_key>true</foreign_key>
  1499. <not_null>true</not_null>
  1500. <primary_key>true</primary_key>
  1501. <unique_key>false</unique_key>
  1502. <character_set></character_set>
  1503. <collation></collation>
  1504. <sequence>
  1505. <name></name>
  1506. <schema></schema>
  1507. <increment></increment>
  1508. <min_value></min_value>
  1509. <max_value></max_value>
  1510. <start></start>
  1511. <cache></cache>
  1512. <nocache>false</nocache>
  1513. <cycle>false</cycle>
  1514. <order>false</order>
  1515. <description></description>
  1516. <data_type></data_type>
  1517. <decimal_size>0</decimal_size>
  1518. </sequence>
  1519. </normal_column>
  1520. </columns>
  1521. <indexes>
  1522. </indexes>
  1523. <complex_unique_key_list>
  1524. </complex_unique_key_list>
  1525. <table_properties>
  1526. <schema></schema>
  1527. </table_properties>
  1528. </table>
  1529. <table>
  1530. <id>3</id>
  1531. <height>-1</height>
  1532. <width>-1</width>
  1533. <font_name>Segoe UI</font_name>
  1534. <font_size>9</font_size>
  1535. <x>32</x>
  1536. <y>29</y>
  1537. <color>
  1538. <r>128</r>
  1539. <g>128</g>
  1540. <b>192</b>
  1541. </color>
  1542. <connections>
  1543. </connections>
  1544. <physical_name>sys_area</physical_name>
  1545. <logical_name>区域表</logical_name>
  1546. <description>区域表</description>
  1547. <constraint></constraint>
  1548. <primary_key_name></primary_key_name>
  1549. <option></option>
  1550. <columns>
  1551. <normal_column>
  1552. <word_id>15</word_id>
  1553. <id>16</id>
  1554. <description></description>
  1555. <unique_key_name></unique_key_name>
  1556. <logical_name></logical_name>
  1557. <physical_name></physical_name>
  1558. <type>varchar(n)</type>
  1559. <constraint></constraint>
  1560. <default_value></default_value>
  1561. <auto_increment>false</auto_increment>
  1562. <foreign_key>false</foreign_key>
  1563. <not_null>true</not_null>
  1564. <primary_key>true</primary_key>
  1565. <unique_key>false</unique_key>
  1566. <character_set></character_set>
  1567. <collation></collation>
  1568. <sequence>
  1569. <name></name>
  1570. <schema></schema>
  1571. <increment></increment>
  1572. <min_value></min_value>
  1573. <max_value></max_value>
  1574. <start></start>
  1575. <cache></cache>
  1576. <nocache>false</nocache>
  1577. <cycle>false</cycle>
  1578. <order>false</order>
  1579. <description></description>
  1580. <data_type></data_type>
  1581. <decimal_size>0</decimal_size>
  1582. </sequence>
  1583. </normal_column>
  1584. <column_group>1</column_group>
  1585. <normal_column>
  1586. <word_id>1</word_id>
  1587. <id>17</id>
  1588. <description></description>
  1589. <unique_key_name></unique_key_name>
  1590. <logical_name></logical_name>
  1591. <physical_name></physical_name>
  1592. <type>varchar(n)</type>
  1593. <constraint></constraint>
  1594. <default_value></default_value>
  1595. <auto_increment>false</auto_increment>
  1596. <foreign_key>false</foreign_key>
  1597. <not_null>false</not_null>
  1598. <primary_key>false</primary_key>
  1599. <unique_key>false</unique_key>
  1600. <character_set></character_set>
  1601. <collation></collation>
  1602. <sequence>
  1603. <name></name>
  1604. <schema></schema>
  1605. <increment></increment>
  1606. <min_value></min_value>
  1607. <max_value></max_value>
  1608. <start></start>
  1609. <cache></cache>
  1610. <nocache>false</nocache>
  1611. <cycle>false</cycle>
  1612. <order>false</order>
  1613. <description></description>
  1614. <data_type></data_type>
  1615. <decimal_size>0</decimal_size>
  1616. </sequence>
  1617. </normal_column>
  1618. <normal_column>
  1619. <word_id>49</word_id>
  1620. <id>18</id>
  1621. <description></description>
  1622. <unique_key_name></unique_key_name>
  1623. <logical_name></logical_name>
  1624. <physical_name></physical_name>
  1625. <type>character(n)</type>
  1626. <constraint></constraint>
  1627. <default_value></default_value>
  1628. <auto_increment>false</auto_increment>
  1629. <foreign_key>false</foreign_key>
  1630. <not_null>false</not_null>
  1631. <primary_key>false</primary_key>
  1632. <unique_key>false</unique_key>
  1633. <character_set></character_set>
  1634. <collation></collation>
  1635. <sequence>
  1636. <name></name>
  1637. <schema></schema>
  1638. <increment></increment>
  1639. <min_value></min_value>
  1640. <max_value></max_value>
  1641. <start></start>
  1642. <cache></cache>
  1643. <nocache>false</nocache>
  1644. <cycle>false</cycle>
  1645. <order>false</order>
  1646. <description></description>
  1647. <data_type></data_type>
  1648. <decimal_size>0</decimal_size>
  1649. </sequence>
  1650. </normal_column>
  1651. <column_group>0</column_group>
  1652. </columns>
  1653. <indexes>
  1654. <inidex>
  1655. <full_text>false</full_text>
  1656. <non_unique>true</non_unique>
  1657. <name>sys_area_parent_id</name>
  1658. <type></type>
  1659. <description></description>
  1660. <columns>
  1661. <column>
  1662. <id>6</id>
  1663. <desc>false</desc>
  1664. </column>
  1665. </columns>
  1666. </inidex>
  1667. <inidex>
  1668. <full_text>false</full_text>
  1669. <non_unique>true</non_unique>
  1670. <name>sys_area_parent_ids</name>
  1671. <type></type>
  1672. <description></description>
  1673. <columns>
  1674. <column>
  1675. <id>7</id>
  1676. <desc>false</desc>
  1677. </column>
  1678. </columns>
  1679. </inidex>
  1680. <inidex>
  1681. <full_text>false</full_text>
  1682. <non_unique>true</non_unique>
  1683. <name>sys_area_del_flag</name>
  1684. <type></type>
  1685. <description></description>
  1686. <columns>
  1687. <column>
  1688. <id>5</id>
  1689. <desc>false</desc>
  1690. </column>
  1691. </columns>
  1692. </inidex>
  1693. </indexes>
  1694. <complex_unique_key_list>
  1695. </complex_unique_key_list>
  1696. <table_properties>
  1697. <schema></schema>
  1698. </table_properties>
  1699. </table>
  1700. <table>
  1701. <id>4</id>
  1702. <height>-1</height>
  1703. <width>-1</width>
  1704. <font_name>Segoe UI</font_name>
  1705. <font_size>9</font_size>
  1706. <x>697</x>
  1707. <y>28</y>
  1708. <color>
  1709. <r>128</r>
  1710. <g>128</g>
  1711. <b>192</b>
  1712. </color>
  1713. <connections>
  1714. </connections>
  1715. <physical_name>sys_menu</physical_name>
  1716. <logical_name>菜单表</logical_name>
  1717. <description>菜单表</description>
  1718. <constraint></constraint>
  1719. <primary_key_name></primary_key_name>
  1720. <option></option>
  1721. <columns>
  1722. <normal_column>
  1723. <word_id>15</word_id>
  1724. <id>19</id>
  1725. <description></description>
  1726. <unique_key_name></unique_key_name>
  1727. <logical_name></logical_name>
  1728. <physical_name></physical_name>
  1729. <type>varchar(n)</type>
  1730. <constraint></constraint>
  1731. <default_value></default_value>
  1732. <auto_increment>false</auto_increment>
  1733. <foreign_key>false</foreign_key>
  1734. <not_null>true</not_null>
  1735. <primary_key>true</primary_key>
  1736. <unique_key>false</unique_key>
  1737. <character_set></character_set>
  1738. <collation></collation>
  1739. <sequence>
  1740. <name></name>
  1741. <schema></schema>
  1742. <increment></increment>
  1743. <min_value></min_value>
  1744. <max_value></max_value>
  1745. <start></start>
  1746. <cache></cache>
  1747. <nocache>false</nocache>
  1748. <cycle>false</cycle>
  1749. <order>false</order>
  1750. <description></description>
  1751. <data_type></data_type>
  1752. <decimal_size>0</decimal_size>
  1753. </sequence>
  1754. </normal_column>
  1755. <column_group>1</column_group>
  1756. <normal_column>
  1757. <word_id>13</word_id>
  1758. <id>20</id>
  1759. <description></description>
  1760. <unique_key_name></unique_key_name>
  1761. <logical_name></logical_name>
  1762. <physical_name></physical_name>
  1763. <type>varchar(n)</type>
  1764. <constraint></constraint>
  1765. <default_value></default_value>
  1766. <auto_increment>false</auto_increment>
  1767. <foreign_key>false</foreign_key>
  1768. <not_null>false</not_null>
  1769. <primary_key>false</primary_key>
  1770. <unique_key>false</unique_key>
  1771. <character_set></character_set>
  1772. <collation></collation>
  1773. <sequence>
  1774. <name></name>
  1775. <schema></schema>
  1776. <increment></increment>
  1777. <min_value></min_value>
  1778. <max_value></max_value>
  1779. <start></start>
  1780. <cache></cache>
  1781. <nocache>false</nocache>
  1782. <cycle>false</cycle>
  1783. <order>false</order>
  1784. <description></description>
  1785. <data_type></data_type>
  1786. <decimal_size>0</decimal_size>
  1787. </sequence>
  1788. </normal_column>
  1789. <normal_column>
  1790. <word_id>47</word_id>
  1791. <id>21</id>
  1792. <description></description>
  1793. <unique_key_name></unique_key_name>
  1794. <logical_name></logical_name>
  1795. <physical_name></physical_name>
  1796. <type>varchar(n)</type>
  1797. <constraint></constraint>
  1798. <default_value></default_value>
  1799. <auto_increment>false</auto_increment>
  1800. <foreign_key>false</foreign_key>
  1801. <not_null>false</not_null>
  1802. <primary_key>false</primary_key>
  1803. <unique_key>false</unique_key>
  1804. <character_set></character_set>
  1805. <collation></collation>
  1806. <sequence>
  1807. <name></name>
  1808. <schema></schema>
  1809. <increment></increment>
  1810. <min_value></min_value>
  1811. <max_value></max_value>
  1812. <start></start>
  1813. <cache></cache>
  1814. <nocache>false</nocache>
  1815. <cycle>false</cycle>
  1816. <order>false</order>
  1817. <description></description>
  1818. <data_type></data_type>
  1819. <decimal_size>0</decimal_size>
  1820. </sequence>
  1821. </normal_column>
  1822. <normal_column>
  1823. <word_id>14</word_id>
  1824. <id>22</id>
  1825. <description></description>
  1826. <unique_key_name></unique_key_name>
  1827. <logical_name></logical_name>
  1828. <physical_name></physical_name>
  1829. <type>varchar(n)</type>
  1830. <constraint></constraint>
  1831. <default_value></default_value>
  1832. <auto_increment>false</auto_increment>
  1833. <foreign_key>false</foreign_key>
  1834. <not_null>false</not_null>
  1835. <primary_key>false</primary_key>
  1836. <unique_key>false</unique_key>
  1837. <character_set></character_set>
  1838. <collation></collation>
  1839. <sequence>
  1840. <name></name>
  1841. <schema></schema>
  1842. <increment></increment>
  1843. <min_value></min_value>
  1844. <max_value></max_value>
  1845. <start></start>
  1846. <cache></cache>
  1847. <nocache>false</nocache>
  1848. <cycle>false</cycle>
  1849. <order>false</order>
  1850. <description></description>
  1851. <data_type></data_type>
  1852. <decimal_size>0</decimal_size>
  1853. </sequence>
  1854. </normal_column>
  1855. <normal_column>
  1856. <word_id>16</word_id>
  1857. <id>23</id>
  1858. <description></description>
  1859. <unique_key_name></unique_key_name>
  1860. <logical_name></logical_name>
  1861. <physical_name></physical_name>
  1862. <type>character(n)</type>
  1863. <constraint></constraint>
  1864. <default_value></default_value>
  1865. <auto_increment>false</auto_increment>
  1866. <foreign_key>false</foreign_key>
  1867. <not_null>true</not_null>
  1868. <primary_key>false</primary_key>
  1869. <unique_key>false</unique_key>
  1870. <character_set></character_set>
  1871. <collation></collation>
  1872. <sequence>
  1873. <name></name>
  1874. <schema></schema>
  1875. <increment></increment>
  1876. <min_value></min_value>
  1877. <max_value></max_value>
  1878. <start></start>
  1879. <cache></cache>
  1880. <nocache>false</nocache>
  1881. <cycle>false</cycle>
  1882. <order>false</order>
  1883. <description></description>
  1884. <data_type></data_type>
  1885. <decimal_size>0</decimal_size>
  1886. </sequence>
  1887. </normal_column>
  1888. <normal_column>
  1889. <word_id>36</word_id>
  1890. <id>24</id>
  1891. <description></description>
  1892. <unique_key_name></unique_key_name>
  1893. <logical_name></logical_name>
  1894. <physical_name></physical_name>
  1895. <type>varchar(n)</type>
  1896. <constraint></constraint>
  1897. <default_value></default_value>
  1898. <auto_increment>false</auto_increment>
  1899. <foreign_key>false</foreign_key>
  1900. <not_null>false</not_null>
  1901. <primary_key>false</primary_key>
  1902. <unique_key>false</unique_key>
  1903. <character_set></character_set>
  1904. <collation></collation>
  1905. <sequence>
  1906. <name></name>
  1907. <schema></schema>
  1908. <increment></increment>
  1909. <min_value></min_value>
  1910. <max_value></max_value>
  1911. <start></start>
  1912. <cache></cache>
  1913. <nocache>false</nocache>
  1914. <cycle>false</cycle>
  1915. <order>false</order>
  1916. <description></description>
  1917. <data_type></data_type>
  1918. <decimal_size>0</decimal_size>
  1919. </sequence>
  1920. </normal_column>
  1921. <column_group>0</column_group>
  1922. </columns>
  1923. <indexes>
  1924. <inidex>
  1925. <full_text>false</full_text>
  1926. <non_unique>true</non_unique>
  1927. <name>sys_menu_parent_id</name>
  1928. <type></type>
  1929. <description></description>
  1930. <columns>
  1931. <column>
  1932. <id>6</id>
  1933. <desc>false</desc>
  1934. </column>
  1935. </columns>
  1936. </inidex>
  1937. <inidex>
  1938. <full_text>false</full_text>
  1939. <non_unique>true</non_unique>
  1940. <name>sys_menu_parent_ids</name>
  1941. <type></type>
  1942. <description></description>
  1943. <columns>
  1944. <column>
  1945. <id>7</id>
  1946. <desc>false</desc>
  1947. </column>
  1948. </columns>
  1949. </inidex>
  1950. <inidex>
  1951. <full_text>false</full_text>
  1952. <non_unique>true</non_unique>
  1953. <name>sys_menu_del_flag</name>
  1954. <type></type>
  1955. <description></description>
  1956. <columns>
  1957. <column>
  1958. <id>5</id>
  1959. <desc>false</desc>
  1960. </column>
  1961. </columns>
  1962. </inidex>
  1963. </indexes>
  1964. <complex_unique_key_list>
  1965. </complex_unique_key_list>
  1966. <table_properties>
  1967. <schema></schema>
  1968. </table_properties>
  1969. </table>
  1970. <table>
  1971. <id>5</id>
  1972. <height>-1</height>
  1973. <width>-1</width>
  1974. <font_name>Segoe UI</font_name>
  1975. <font_size>9</font_size>
  1976. <x>1025</x>
  1977. <y>26</y>
  1978. <color>
  1979. <r>128</r>
  1980. <g>128</g>
  1981. <b>192</b>
  1982. </color>
  1983. <connections>
  1984. </connections>
  1985. <physical_name>sys_dict</physical_name>
  1986. <logical_name>字典表</logical_name>
  1987. <description>字典表</description>
  1988. <constraint></constraint>
  1989. <primary_key_name></primary_key_name>
  1990. <option></option>
  1991. <columns>
  1992. <normal_column>
  1993. <word_id>15</word_id>
  1994. <id>25</id>
  1995. <description></description>
  1996. <unique_key_name></unique_key_name>
  1997. <logical_name></logical_name>
  1998. <physical_name></physical_name>
  1999. <type>varchar(n)</type>
  2000. <constraint></constraint>
  2001. <default_value></default_value>
  2002. <auto_increment>false</auto_increment>
  2003. <foreign_key>false</foreign_key>
  2004. <not_null>true</not_null>
  2005. <primary_key>true</primary_key>
  2006. <unique_key>false</unique_key>
  2007. <character_set></character_set>
  2008. <collation></collation>
  2009. <sequence>
  2010. <name></name>
  2011. <schema></schema>
  2012. <increment></increment>
  2013. <min_value></min_value>
  2014. <max_value></max_value>
  2015. <start></start>
  2016. <cache></cache>
  2017. <nocache>false</nocache>
  2018. <cycle>false</cycle>
  2019. <order>false</order>
  2020. <description></description>
  2021. <data_type></data_type>
  2022. <decimal_size>0</decimal_size>
  2023. </sequence>
  2024. </normal_column>
  2025. <normal_column>
  2026. <word_id>59</word_id>
  2027. <id>26</id>
  2028. <description></description>
  2029. <unique_key_name></unique_key_name>
  2030. <logical_name></logical_name>
  2031. <physical_name></physical_name>
  2032. <type>varchar(n)</type>
  2033. <constraint></constraint>
  2034. <default_value></default_value>
  2035. <auto_increment>false</auto_increment>
  2036. <foreign_key>false</foreign_key>
  2037. <not_null>true</not_null>
  2038. <primary_key>false</primary_key>
  2039. <unique_key>false</unique_key>
  2040. <character_set></character_set>
  2041. <collation></collation>
  2042. <sequence>
  2043. <name></name>
  2044. <schema></schema>
  2045. <increment></increment>
  2046. <min_value></min_value>
  2047. <max_value></max_value>
  2048. <start></start>
  2049. <cache></cache>
  2050. <nocache>false</nocache>
  2051. <cycle>false</cycle>
  2052. <order>false</order>
  2053. <description></description>
  2054. <data_type></data_type>
  2055. <decimal_size>0</decimal_size>
  2056. </sequence>
  2057. </normal_column>
  2058. <normal_column>
  2059. <word_id>18</word_id>
  2060. <id>27</id>
  2061. <description></description>
  2062. <unique_key_name></unique_key_name>
  2063. <logical_name></logical_name>
  2064. <physical_name></physical_name>
  2065. <type>varchar(n)</type>
  2066. <constraint></constraint>
  2067. <default_value></default_value>
  2068. <auto_increment>false</auto_increment>
  2069. <foreign_key>false</foreign_key>
  2070. <not_null>true</not_null>
  2071. <primary_key>false</primary_key>
  2072. <unique_key>false</unique_key>
  2073. <character_set></character_set>
  2074. <collation></collation>
  2075. <sequence>
  2076. <name></name>
  2077. <schema></schema>
  2078. <increment></increment>
  2079. <min_value></min_value>
  2080. <max_value></max_value>
  2081. <start></start>
  2082. <cache></cache>
  2083. <nocache>false</nocache>
  2084. <cycle>false</cycle>
  2085. <order>false</order>
  2086. <description></description>
  2087. <data_type></data_type>
  2088. <decimal_size>0</decimal_size>
  2089. </sequence>
  2090. </normal_column>
  2091. <normal_column>
  2092. <word_id>52</word_id>
  2093. <id>28</id>
  2094. <description></description>
  2095. <unique_key_name></unique_key_name>
  2096. <logical_name></logical_name>
  2097. <physical_name></physical_name>
  2098. <type>varchar(n)</type>
  2099. <constraint></constraint>
  2100. <default_value></default_value>
  2101. <auto_increment>false</auto_increment>
  2102. <foreign_key>false</foreign_key>
  2103. <not_null>true</not_null>
  2104. <primary_key>false</primary_key>
  2105. <unique_key>false</unique_key>
  2106. <character_set></character_set>
  2107. <collation></collation>
  2108. <sequence>
  2109. <name></name>
  2110. <schema></schema>
  2111. <increment></increment>
  2112. <min_value></min_value>
  2113. <max_value></max_value>
  2114. <start></start>
  2115. <cache></cache>
  2116. <nocache>false</nocache>
  2117. <cycle>false</cycle>
  2118. <order>false</order>
  2119. <description></description>
  2120. <data_type></data_type>
  2121. <decimal_size>0</decimal_size>
  2122. </sequence>
  2123. </normal_column>
  2124. <normal_column>
  2125. <word_id>7</word_id>
  2126. <id>29</id>
  2127. <description></description>
  2128. <unique_key_name></unique_key_name>
  2129. <logical_name></logical_name>
  2130. <physical_name></physical_name>
  2131. <type>nvarchar(n)</type>
  2132. <constraint></constraint>
  2133. <default_value></default_value>
  2134. <auto_increment>false</auto_increment>
  2135. <foreign_key>false</foreign_key>
  2136. <not_null>true</not_null>
  2137. <primary_key>false</primary_key>
  2138. <unique_key>false</unique_key>
  2139. <character_set></character_set>
  2140. <collation></collation>
  2141. <sequence>
  2142. <name></name>
  2143. <schema></schema>
  2144. <increment></increment>
  2145. <min_value></min_value>
  2146. <max_value></max_value>
  2147. <start></start>
  2148. <cache></cache>
  2149. <nocache>false</nocache>
  2150. <cycle>false</cycle>
  2151. <order>false</order>
  2152. <description></description>
  2153. <data_type></data_type>
  2154. <decimal_size>0</decimal_size>
  2155. </sequence>
  2156. </normal_column>
  2157. <normal_column>
  2158. <word_id>46</word_id>
  2159. <id>30</id>
  2160. <description></description>
  2161. <unique_key_name></unique_key_name>
  2162. <logical_name></logical_name>
  2163. <physical_name></physical_name>
  2164. <type>decimal(p,s)</type>
  2165. <constraint></constraint>
  2166. <default_value></default_value>
  2167. <auto_increment>false</auto_increment>
  2168. <foreign_key>false</foreign_key>
  2169. <not_null>true</not_null>
  2170. <primary_key>false</primary_key>
  2171. <unique_key>false</unique_key>
  2172. <character_set></character_set>
  2173. <collation></collation>
  2174. <sequence>
  2175. <name></name>
  2176. <schema></schema>
  2177. <increment></increment>
  2178. <min_value></min_value>
  2179. <max_value></max_value>
  2180. <start></start>
  2181. <cache></cache>
  2182. <nocache>false</nocache>
  2183. <cycle>false</cycle>
  2184. <order>false</order>
  2185. <description></description>
  2186. <data_type></data_type>
  2187. <decimal_size>0</decimal_size>
  2188. </sequence>
  2189. </normal_column>
  2190. <normal_column>
  2191. <word_id>33</word_id>
  2192. <id>31</id>
  2193. <description></description>
  2194. <unique_key_name></unique_key_name>
  2195. <logical_name></logical_name>
  2196. <physical_name></physical_name>
  2197. <type>varchar(n)</type>
  2198. <constraint></constraint>
  2199. <default_value>0</default_value>
  2200. <auto_increment>false</auto_increment>
  2201. <foreign_key>false</foreign_key>
  2202. <not_null>false</not_null>
  2203. <primary_key>false</primary_key>
  2204. <unique_key>false</unique_key>
  2205. <character_set></character_set>
  2206. <collation></collation>
  2207. <sequence>
  2208. <name></name>
  2209. <schema></schema>
  2210. <increment></increment>
  2211. <min_value></min_value>
  2212. <max_value></max_value>
  2213. <start></start>
  2214. <cache></cache>
  2215. <nocache>false</nocache>
  2216. <cycle>false</cycle>
  2217. <order>false</order>
  2218. <description></description>
  2219. <data_type></data_type>
  2220. <decimal_size>0</decimal_size>
  2221. </sequence>
  2222. </normal_column>
  2223. <column_group>0</column_group>
  2224. </columns>
  2225. <indexes>
  2226. <inidex>
  2227. <full_text>false</full_text>
  2228. <non_unique>true</non_unique>
  2229. <name>sys_dict_value</name>
  2230. <type></type>
  2231. <description></description>
  2232. <columns>
  2233. <column>
  2234. <id>26</id>
  2235. <desc>false</desc>
  2236. </column>
  2237. </columns>
  2238. </inidex>
  2239. <inidex>
  2240. <full_text>false</full_text>
  2241. <non_unique>true</non_unique>
  2242. <name>sys_dict_label</name>
  2243. <type></type>
  2244. <description></description>
  2245. <columns>
  2246. <column>
  2247. <id>27</id>
  2248. <desc>false</desc>
  2249. </column>
  2250. </columns>
  2251. </inidex>
  2252. <inidex>
  2253. <full_text>false</full_text>
  2254. <non_unique>true</non_unique>
  2255. <name>sys_dict_del_flag</name>
  2256. <type></type>
  2257. <description></description>
  2258. <columns>
  2259. <column>
  2260. <id>5</id>
  2261. <desc>false</desc>
  2262. </column>
  2263. </columns>
  2264. </inidex>
  2265. </indexes>
  2266. <complex_unique_key_list>
  2267. </complex_unique_key_list>
  2268. <table_properties>
  2269. <schema></schema>
  2270. </table_properties>
  2271. </table>
  2272. <table>
  2273. <id>6</id>
  2274. <height>-1</height>
  2275. <width>-1</width>
  2276. <font_name>Segoe UI</font_name>
  2277. <font_size>9</font_size>
  2278. <x>1026</x>
  2279. <y>369</y>
  2280. <color>
  2281. <r>128</r>
  2282. <g>128</g>
  2283. <b>192</b>
  2284. </color>
  2285. <connections>
  2286. </connections>
  2287. <physical_name>sys_mdict</physical_name>
  2288. <logical_name>多级字典表</logical_name>
  2289. <description>多级字典表</description>
  2290. <constraint></constraint>
  2291. <primary_key_name></primary_key_name>
  2292. <option></option>
  2293. <columns>
  2294. <normal_column>
  2295. <word_id>15</word_id>
  2296. <id>32</id>
  2297. <description></description>
  2298. <unique_key_name></unique_key_name>
  2299. <logical_name></logical_name>
  2300. <physical_name></physical_name>
  2301. <type>varchar(n)</type>
  2302. <constraint></constraint>
  2303. <default_value></default_value>
  2304. <auto_increment>false</auto_increment>
  2305. <foreign_key>false</foreign_key>
  2306. <not_null>true</not_null>
  2307. <primary_key>true</primary_key>
  2308. <unique_key>false</unique_key>
  2309. <character_set></character_set>
  2310. <collation></collation>
  2311. <sequence>
  2312. <name></name>
  2313. <schema></schema>
  2314. <increment></increment>
  2315. <min_value></min_value>
  2316. <max_value></max_value>
  2317. <start></start>
  2318. <cache></cache>
  2319. <nocache>false</nocache>
  2320. <cycle>false</cycle>
  2321. <order>false</order>
  2322. <description></description>
  2323. <data_type></data_type>
  2324. <decimal_size>0</decimal_size>
  2325. </sequence>
  2326. </normal_column>
  2327. <column_group>1</column_group>
  2328. <normal_column>
  2329. <word_id>7</word_id>
  2330. <id>33</id>
  2331. <description></description>
  2332. <unique_key_name></unique_key_name>
  2333. <logical_name></logical_name>
  2334. <physical_name></physical_name>
  2335. <type>nvarchar(n)</type>
  2336. <constraint></constraint>
  2337. <default_value></default_value>
  2338. <auto_increment>false</auto_increment>
  2339. <foreign_key>false</foreign_key>
  2340. <not_null>false</not_null>
  2341. <primary_key>false</primary_key>
  2342. <unique_key>false</unique_key>
  2343. <character_set></character_set>
  2344. <collation></collation>
  2345. <sequence>
  2346. <name></name>
  2347. <schema></schema>
  2348. <increment></increment>
  2349. <min_value></min_value>
  2350. <max_value></max_value>
  2351. <start></start>
  2352. <cache></cache>
  2353. <nocache>false</nocache>
  2354. <cycle>false</cycle>
  2355. <order>false</order>
  2356. <description></description>
  2357. <data_type></data_type>
  2358. <decimal_size>0</decimal_size>
  2359. </sequence>
  2360. </normal_column>
  2361. <column_group>0</column_group>
  2362. </columns>
  2363. <indexes>
  2364. <inidex>
  2365. <full_text>false</full_text>
  2366. <non_unique>true</non_unique>
  2367. <name>sys_mdict_parent_id</name>
  2368. <type></type>
  2369. <description></description>
  2370. <columns>
  2371. <column>
  2372. <id>6</id>
  2373. <desc>false</desc>
  2374. </column>
  2375. </columns>
  2376. </inidex>
  2377. <inidex>
  2378. <full_text>false</full_text>
  2379. <non_unique>true</non_unique>
  2380. <name>sys_mdict_parent_ids</name>
  2381. <type></type>
  2382. <description></description>
  2383. <columns>
  2384. <column>
  2385. <id>7</id>
  2386. <desc>false</desc>
  2387. </column>
  2388. </columns>
  2389. </inidex>
  2390. <inidex>
  2391. <full_text>false</full_text>
  2392. <non_unique>true</non_unique>
  2393. <name>sys_mdict_del_flag</name>
  2394. <type></type>
  2395. <description></description>
  2396. <columns>
  2397. <column>
  2398. <id>5</id>
  2399. <desc>false</desc>
  2400. </column>
  2401. </columns>
  2402. </inidex>
  2403. </indexes>
  2404. <complex_unique_key_list>
  2405. </complex_unique_key_list>
  2406. <table_properties>
  2407. <schema></schema>
  2408. </table_properties>
  2409. </table>
  2410. <table>
  2411. <id>7</id>
  2412. <height>275</height>
  2413. <width>278</width>
  2414. <font_name>微软雅黑</font_name>
  2415. <font_size>9</font_size>
  2416. <x>1026</x>
  2417. <y>695</y>
  2418. <color>
  2419. <r>128</r>
  2420. <g>128</g>
  2421. <b>192</b>
  2422. </color>
  2423. <connections>
  2424. </connections>
  2425. <physical_name>sys_log</physical_name>
  2426. <logical_name>日志表</logical_name>
  2427. <description>日志表</description>
  2428. <constraint></constraint>
  2429. <primary_key_name></primary_key_name>
  2430. <option></option>
  2431. <columns>
  2432. <normal_column>
  2433. <word_id>15</word_id>
  2434. <id>34</id>
  2435. <description></description>
  2436. <unique_key_name></unique_key_name>
  2437. <logical_name></logical_name>
  2438. <physical_name></physical_name>
  2439. <type>varchar(n)</type>
  2440. <constraint></constraint>
  2441. <default_value></default_value>
  2442. <auto_increment>true</auto_increment>
  2443. <foreign_key>false</foreign_key>
  2444. <not_null>true</not_null>
  2445. <primary_key>true</primary_key>
  2446. <unique_key>false</unique_key>
  2447. <character_set></character_set>
  2448. <collation></collation>
  2449. <sequence>
  2450. <name></name>
  2451. <schema></schema>
  2452. <increment></increment>
  2453. <min_value></min_value>
  2454. <max_value></max_value>
  2455. <start></start>
  2456. <cache></cache>
  2457. <nocache>false</nocache>
  2458. <cycle>false</cycle>
  2459. <order>false</order>
  2460. <description></description>
  2461. <data_type></data_type>
  2462. <decimal_size>0</decimal_size>
  2463. </sequence>
  2464. </normal_column>
  2465. <normal_column>
  2466. <word_id>50</word_id>
  2467. <id>35</id>
  2468. <description></description>
  2469. <unique_key_name></unique_key_name>
  2470. <logical_name></logical_name>
  2471. <physical_name></physical_name>
  2472. <type>character(n)</type>
  2473. <constraint></constraint>
  2474. <default_value>1</default_value>
  2475. <auto_increment>false</auto_increment>
  2476. <foreign_key>false</foreign_key>
  2477. <not_null>false</not_null>
  2478. <primary_key>false</primary_key>
  2479. <unique_key>false</unique_key>
  2480. <character_set></character_set>
  2481. <collation></collation>
  2482. <sequence>
  2483. <name></name>
  2484. <schema></schema>
  2485. <increment></increment>
  2486. <min_value></min_value>
  2487. <max_value></max_value>
  2488. <start></start>
  2489. <cache></cache>
  2490. <nocache>false</nocache>
  2491. <cycle>false</cycle>
  2492. <order>false</order>
  2493. <description></description>
  2494. <data_type></data_type>
  2495. <decimal_size>0</decimal_size>
  2496. </sequence>
  2497. </normal_column>
  2498. <normal_column>
  2499. <word_id>48</word_id>
  2500. <id>36</id>
  2501. <description></description>
  2502. <unique_key_name></unique_key_name>
  2503. <logical_name></logical_name>
  2504. <physical_name></physical_name>
  2505. <type>nvarchar(n)</type>
  2506. <constraint></constraint>
  2507. <default_value></default_value>
  2508. <auto_increment>false</auto_increment>
  2509. <foreign_key>false</foreign_key>
  2510. <not_null>false</not_null>
  2511. <primary_key>false</primary_key>
  2512. <unique_key>false</unique_key>
  2513. <character_set></character_set>
  2514. <collation></collation>
  2515. <sequence>
  2516. <name></name>
  2517. <schema></schema>
  2518. <increment></increment>
  2519. <min_value></min_value>
  2520. <max_value></max_value>
  2521. <start></start>
  2522. <cache></cache>
  2523. <nocache>false</nocache>
  2524. <cycle>false</cycle>
  2525. <order>false</order>
  2526. <description></description>
  2527. <data_type></data_type>
  2528. <decimal_size>0</decimal_size>
  2529. </sequence>
  2530. </normal_column>
  2531. <normal_column>
  2532. <word_id>2</word_id>
  2533. <id>37</id>
  2534. <description></description>
  2535. <unique_key_name></unique_key_name>
  2536. <logical_name></logical_name>
  2537. <physical_name></physical_name>
  2538. <type>varchar(n)</type>
  2539. <constraint></constraint>
  2540. <default_value></default_value>
  2541. <auto_increment>false</auto_increment>
  2542. <foreign_key>false</foreign_key>
  2543. <not_null>false</not_null>
  2544. <primary_key>false</primary_key>
  2545. <unique_key>false</unique_key>
  2546. <character_set></character_set>
  2547. <collation></collation>
  2548. <sequence>
  2549. <name></name>
  2550. <schema></schema>
  2551. <increment></increment>
  2552. <min_value></min_value>
  2553. <max_value></max_value>
  2554. <start></start>
  2555. <cache></cache>
  2556. <nocache>false</nocache>
  2557. <cycle>false</cycle>
  2558. <order>false</order>
  2559. <description></description>
  2560. <data_type></data_type>
  2561. <decimal_size>0</decimal_size>
  2562. </sequence>
  2563. </normal_column>
  2564. <normal_column>
  2565. <word_id>3</word_id>
  2566. <id>38</id>
  2567. <description></description>
  2568. <unique_key_name></unique_key_name>
  2569. <logical_name></logical_name>
  2570. <physical_name></physical_name>
  2571. <type>datetime</type>
  2572. <constraint></constraint>
  2573. <default_value></default_value>
  2574. <auto_increment>false</auto_increment>
  2575. <foreign_key>false</foreign_key>
  2576. <not_null>false</not_null>
  2577. <primary_key>false</primary_key>
  2578. <unique_key>false</unique_key>
  2579. <character_set></character_set>
  2580. <collation></collation>
  2581. <sequence>
  2582. <name></name>
  2583. <schema></schema>
  2584. <increment></increment>
  2585. <min_value></min_value>
  2586. <max_value></max_value>
  2587. <start></start>
  2588. <cache></cache>
  2589. <nocache>false</nocache>
  2590. <cycle>false</cycle>
  2591. <order>false</order>
  2592. <description></description>
  2593. <data_type></data_type>
  2594. <decimal_size>0</decimal_size>
  2595. </sequence>
  2596. </normal_column>
  2597. <normal_column>
  2598. <word_id>42</word_id>
  2599. <id>39</id>
  2600. <description></description>
  2601. <unique_key_name></unique_key_name>
  2602. <logical_name></logical_name>
  2603. <physical_name></physical_name>
  2604. <type>varchar(n)</type>
  2605. <constraint></constraint>
  2606. <default_value></default_value>
  2607. <auto_increment>false</auto_increment>
  2608. <foreign_key>false</foreign_key>
  2609. <not_null>false</not_null>
  2610. <primary_key>false</primary_key>
  2611. <unique_key>false</unique_key>
  2612. <character_set></character_set>
  2613. <collation></collation>
  2614. <sequence>
  2615. <name></name>
  2616. <schema></schema>
  2617. <increment></increment>
  2618. <min_value></min_value>
  2619. <max_value></max_value>
  2620. <start></start>
  2621. <cache></cache>
  2622. <nocache>false</nocache>
  2623. <cycle>false</cycle>
  2624. <order>false</order>
  2625. <description></description>
  2626. <data_type></data_type>
  2627. <decimal_size>0</decimal_size>
  2628. </sequence>
  2629. </normal_column>
  2630. <normal_column>
  2631. <word_id>57</word_id>
  2632. <id>40</id>
  2633. <description></description>
  2634. <unique_key_name></unique_key_name>
  2635. <logical_name></logical_name>
  2636. <physical_name></physical_name>
  2637. <type>varchar(n)</type>
  2638. <constraint></constraint>
  2639. <default_value></default_value>
  2640. <auto_increment>false</auto_increment>
  2641. <foreign_key>false</foreign_key>
  2642. <not_null>false</not_null>
  2643. <primary_key>false</primary_key>
  2644. <unique_key>false</unique_key>
  2645. <character_set></character_set>
  2646. <collation></collation>
  2647. <sequence>
  2648. <name></name>
  2649. <schema></schema>
  2650. <increment></increment>
  2651. <min_value></min_value>
  2652. <max_value></max_value>
  2653. <start></start>
  2654. <cache></cache>
  2655. <nocache>false</nocache>
  2656. <cycle>false</cycle>
  2657. <order>false</order>
  2658. <description></description>
  2659. <data_type></data_type>
  2660. <decimal_size>0</decimal_size>
  2661. </sequence>
  2662. </normal_column>
  2663. <normal_column>
  2664. <word_id>43</word_id>
  2665. <id>41</id>
  2666. <description></description>
  2667. <unique_key_name></unique_key_name>
  2668. <logical_name></logical_name>
  2669. <physical_name></physical_name>
  2670. <type>varchar(n)</type>
  2671. <constraint></constraint>
  2672. <default_value></default_value>
  2673. <auto_increment>false</auto_increment>
  2674. <foreign_key>false</foreign_key>
  2675. <not_null>false</not_null>
  2676. <primary_key>false</primary_key>
  2677. <unique_key>false</unique_key>
  2678. <character_set></character_set>
  2679. <collation></collation>
  2680. <sequence>
  2681. <name></name>
  2682. <schema></schema>
  2683. <increment></increment>
  2684. <min_value></min_value>
  2685. <max_value></max_value>
  2686. <start></start>
  2687. <cache></cache>
  2688. <nocache>false</nocache>
  2689. <cycle>false</cycle>
  2690. <order>false</order>
  2691. <description></description>
  2692. <data_type></data_type>
  2693. <decimal_size>0</decimal_size>
  2694. </sequence>
  2695. </normal_column>
  2696. <normal_column>
  2697. <word_id>24</word_id>
  2698. <id>42</id>
  2699. <description></description>
  2700. <unique_key_name></unique_key_name>
  2701. <logical_name></logical_name>
  2702. <physical_name></physical_name>
  2703. <type>varchar(n)</type>
  2704. <constraint></constraint>
  2705. <default_value></default_value>
  2706. <auto_increment>false</auto_increment>
  2707. <foreign_key>false</foreign_key>
  2708. <not_null>false</not_null>
  2709. <primary_key>false</primary_key>
  2710. <unique_key>false</unique_key>
  2711. <character_set></character_set>
  2712. <collation></collation>
  2713. <sequence>
  2714. <name></name>
  2715. <schema></schema>
  2716. <increment></increment>
  2717. <min_value></min_value>
  2718. <max_value></max_value>
  2719. <start></start>
  2720. <cache></cache>
  2721. <nocache>false</nocache>
  2722. <cycle>false</cycle>
  2723. <order>false</order>
  2724. <description></description>
  2725. <data_type></data_type>
  2726. <decimal_size>0</decimal_size>
  2727. </sequence>
  2728. </normal_column>
  2729. <normal_column>
  2730. <word_id>31</word_id>
  2731. <id>43</id>
  2732. <description></description>
  2733. <unique_key_name></unique_key_name>
  2734. <logical_name></logical_name>
  2735. <physical_name></physical_name>
  2736. <type>text</type>
  2737. <constraint></constraint>
  2738. <default_value></default_value>
  2739. <auto_increment>false</auto_increment>
  2740. <foreign_key>false</foreign_key>
  2741. <not_null>false</not_null>
  2742. <primary_key>false</primary_key>
  2743. <unique_key>false</unique_key>
  2744. <character_set></character_set>
  2745. <collation></collation>
  2746. <sequence>
  2747. <name></name>
  2748. <schema></schema>
  2749. <increment></increment>
  2750. <min_value></min_value>
  2751. <max_value></max_value>
  2752. <start></start>
  2753. <cache></cache>
  2754. <nocache>false</nocache>
  2755. <cycle>false</cycle>
  2756. <order>false</order>
  2757. <description></description>
  2758. <data_type></data_type>
  2759. <decimal_size>0</decimal_size>
  2760. </sequence>
  2761. </normal_column>
  2762. <normal_column>
  2763. <word_id>10</word_id>
  2764. <id>44</id>
  2765. <description></description>
  2766. <unique_key_name></unique_key_name>
  2767. <logical_name></logical_name>
  2768. <physical_name></physical_name>
  2769. <type>text</type>
  2770. <constraint></constraint>
  2771. <default_value></default_value>
  2772. <auto_increment>false</auto_increment>
  2773. <foreign_key>false</foreign_key>
  2774. <not_null>false</not_null>
  2775. <primary_key>false</primary_key>
  2776. <unique_key>false</unique_key>
  2777. <character_set></character_set>
  2778. <collation></collation>
  2779. <sequence>
  2780. <name></name>
  2781. <schema></schema>
  2782. <increment></increment>
  2783. <min_value></min_value>
  2784. <max_value></max_value>
  2785. <start></start>
  2786. <cache></cache>
  2787. <nocache>false</nocache>
  2788. <cycle>false</cycle>
  2789. <order>false</order>
  2790. <description></description>
  2791. <data_type></data_type>
  2792. <decimal_size>0</decimal_size>
  2793. </sequence>
  2794. </normal_column>
  2795. </columns>
  2796. <indexes>
  2797. <inidex>
  2798. <full_text>false</full_text>
  2799. <non_unique>true</non_unique>
  2800. <name>sys_log_create_by</name>
  2801. <type></type>
  2802. <description></description>
  2803. <columns>
  2804. <column>
  2805. <id>37</id>
  2806. <desc>false</desc>
  2807. </column>
  2808. </columns>
  2809. </inidex>
  2810. <inidex>
  2811. <full_text>false</full_text>
  2812. <non_unique>true</non_unique>
  2813. <name>sys_log_request_uri</name>
  2814. <type></type>
  2815. <description></description>
  2816. <columns>
  2817. <column>
  2818. <id>41</id>
  2819. <desc>false</desc>
  2820. </column>
  2821. </columns>
  2822. </inidex>
  2823. <inidex>
  2824. <full_text>false</full_text>
  2825. <non_unique>true</non_unique>
  2826. <name>sys_log_type</name>
  2827. <type></type>
  2828. <description></description>
  2829. <columns>
  2830. <column>
  2831. <id>35</id>
  2832. <desc>false</desc>
  2833. </column>
  2834. </columns>
  2835. </inidex>
  2836. <inidex>
  2837. <full_text>false</full_text>
  2838. <non_unique>true</non_unique>
  2839. <name>sys_log_create_date</name>
  2840. <type></type>
  2841. <description></description>
  2842. <columns>
  2843. <column>
  2844. <id>38</id>
  2845. <desc>false</desc>
  2846. </column>
  2847. </columns>
  2848. </inidex>
  2849. </indexes>
  2850. <complex_unique_key_list>
  2851. </complex_unique_key_list>
  2852. <table_properties>
  2853. <schema></schema>
  2854. </table_properties>
  2855. </table>
  2856. <table>
  2857. <id>8</id>
  2858. <height>-1</height>
  2859. <width>-1</width>
  2860. <font_name>Segoe UI</font_name>
  2861. <font_size>9</font_size>
  2862. <x>716</x>
  2863. <y>559</y>
  2864. <color>
  2865. <r>128</r>
  2866. <g>128</g>
  2867. <b>192</b>
  2868. </color>
  2869. <connections>
  2870. </connections>
  2871. <physical_name>sys_role</physical_name>
  2872. <logical_name>角色表</logical_name>
  2873. <description>角色表</description>
  2874. <constraint></constraint>
  2875. <primary_key_name></primary_key_name>
  2876. <option></option>
  2877. <columns>
  2878. <normal_column>
  2879. <word_id>15</word_id>
  2880. <id>45</id>
  2881. <description></description>
  2882. <unique_key_name></unique_key_name>
  2883. <logical_name></logical_name>
  2884. <physical_name></physical_name>
  2885. <type>varchar(n)</type>
  2886. <constraint></constraint>
  2887. <default_value></default_value>
  2888. <auto_increment>false</auto_increment>
  2889. <foreign_key>false</foreign_key>
  2890. <not_null>true</not_null>
  2891. <primary_key>true</primary_key>
  2892. <unique_key>false</unique_key>
  2893. <character_set></character_set>
  2894. <collation></collation>
  2895. <sequence>
  2896. <name></name>
  2897. <schema></schema>
  2898. <increment></increment>
  2899. <min_value></min_value>
  2900. <max_value></max_value>
  2901. <start></start>
  2902. <cache></cache>
  2903. <nocache>false</nocache>
  2904. <cycle>false</cycle>
  2905. <order>false</order>
  2906. <description></description>
  2907. <data_type></data_type>
  2908. <decimal_size>0</decimal_size>
  2909. </sequence>
  2910. </normal_column>
  2911. <normal_column>
  2912. <word_id>30</word_id>
  2913. <id>46</id>
  2914. <description></description>
  2915. <unique_key_name></unique_key_name>
  2916. <logical_name></logical_name>
  2917. <physical_name></physical_name>
  2918. <type>varchar(n)</type>
  2919. <constraint></constraint>
  2920. <default_value></default_value>
  2921. <auto_increment>false</auto_increment>
  2922. <foreign_key>false</foreign_key>
  2923. <not_null>false</not_null>
  2924. <primary_key>false</primary_key>
  2925. <unique_key>false</unique_key>
  2926. <character_set></character_set>
  2927. <collation></collation>
  2928. <sequence>
  2929. <name></name>
  2930. <schema></schema>
  2931. <increment></increment>
  2932. <min_value></min_value>
  2933. <max_value></max_value>
  2934. <start></start>
  2935. <cache></cache>
  2936. <nocache>false</nocache>
  2937. <cycle>false</cycle>
  2938. <order>false</order>
  2939. <description></description>
  2940. <data_type></data_type>
  2941. <decimal_size>0</decimal_size>
  2942. </sequence>
  2943. </normal_column>
  2944. <normal_column>
  2945. <word_id>28</word_id>
  2946. <id>47</id>
  2947. <description></description>
  2948. <unique_key_name></unique_key_name>
  2949. <logical_name></logical_name>
  2950. <physical_name></physical_name>
  2951. <type>nvarchar(n)</type>
  2952. <constraint></constraint>
  2953. <default_value></default_value>
  2954. <auto_increment>false</auto_increment>
  2955. <foreign_key>false</foreign_key>
  2956. <not_null>true</not_null>
  2957. <primary_key>false</primary_key>
  2958. <unique_key>false</unique_key>
  2959. <character_set></character_set>
  2960. <collation></collation>
  2961. <sequence>
  2962. <name></name>
  2963. <schema></schema>
  2964. <increment></increment>
  2965. <min_value></min_value>
  2966. <max_value></max_value>
  2967. <start></start>
  2968. <cache></cache>
  2969. <nocache>false</nocache>
  2970. <cycle>false</cycle>
  2971. <order>false</order>
  2972. <description></description>
  2973. <data_type></data_type>
  2974. <decimal_size>0</decimal_size>
  2975. </sequence>
  2976. </normal_column>
  2977. <normal_column>
  2978. <word_id>9</word_id>
  2979. <id>48</id>
  2980. <description></description>
  2981. <unique_key_name></unique_key_name>
  2982. <logical_name></logical_name>
  2983. <physical_name></physical_name>
  2984. <type>varchar(n)</type>
  2985. <constraint></constraint>
  2986. <default_value></default_value>
  2987. <auto_increment>false</auto_increment>
  2988. <foreign_key>false</foreign_key>
  2989. <not_null>false</not_null>
  2990. <primary_key>false</primary_key>
  2991. <unique_key>false</unique_key>
  2992. <character_set></character_set>
  2993. <collation></collation>
  2994. <sequence>
  2995. <name></name>
  2996. <schema></schema>
  2997. <increment></increment>
  2998. <min_value></min_value>
  2999. <max_value></max_value>
  3000. <start></start>
  3001. <cache></cache>
  3002. <nocache>false</nocache>
  3003. <cycle>false</cycle>
  3004. <order>false</order>
  3005. <description></description>
  3006. <data_type></data_type>
  3007. <decimal_size>0</decimal_size>
  3008. </sequence>
  3009. </normal_column>
  3010. <normal_column>
  3011. <word_id>44</word_id>
  3012. <id>49</id>
  3013. <description></description>
  3014. <unique_key_name></unique_key_name>
  3015. <logical_name></logical_name>
  3016. <physical_name></physical_name>
  3017. <type>varchar(n)</type>
  3018. <constraint></constraint>
  3019. <default_value></default_value>
  3020. <auto_increment>false</auto_increment>
  3021. <foreign_key>false</foreign_key>
  3022. <not_null>false</not_null>
  3023. <primary_key>false</primary_key>
  3024. <unique_key>false</unique_key>
  3025. <character_set></character_set>
  3026. <collation></collation>
  3027. <sequence>
  3028. <name></name>
  3029. <schema></schema>
  3030. <increment></increment>
  3031. <min_value></min_value>
  3032. <max_value></max_value>
  3033. <start></start>
  3034. <cache></cache>
  3035. <nocache>false</nocache>
  3036. <cycle>false</cycle>
  3037. <order>false</order>
  3038. <description></description>
  3039. <data_type></data_type>
  3040. <decimal_size>0</decimal_size>
  3041. </sequence>
  3042. </normal_column>
  3043. <normal_column>
  3044. <word_id>4</word_id>
  3045. <id>50</id>
  3046. <description></description>
  3047. <unique_key_name></unique_key_name>
  3048. <logical_name></logical_name>
  3049. <physical_name></physical_name>
  3050. <type>character(n)</type>
  3051. <constraint></constraint>
  3052. <default_value></default_value>
  3053. <auto_increment>false</auto_increment>
  3054. <foreign_key>false</foreign_key>
  3055. <not_null>false</not_null>
  3056. <primary_key>false</primary_key>
  3057. <unique_key>false</unique_key>
  3058. <character_set></character_set>
  3059. <collation></collation>
  3060. <sequence>
  3061. <name></name>
  3062. <schema></schema>
  3063. <increment></increment>
  3064. <min_value></min_value>
  3065. <max_value></max_value>
  3066. <start></start>
  3067. <cache></cache>
  3068. <nocache>false</nocache>
  3069. <cycle>false</cycle>
  3070. <order>false</order>
  3071. <description></description>
  3072. <data_type></data_type>
  3073. <decimal_size>0</decimal_size>
  3074. </sequence>
  3075. </normal_column>
  3076. <normal_column>
  3077. <word_id>17</word_id>
  3078. <id>51</id>
  3079. <description></description>
  3080. <unique_key_name></unique_key_name>
  3081. <logical_name></logical_name>
  3082. <physical_name></physical_name>
  3083. <type>varchar(n)</type>
  3084. <constraint></constraint>
  3085. <default_value></default_value>
  3086. <auto_increment>false</auto_increment>
  3087. <foreign_key>false</foreign_key>
  3088. <not_null>false</not_null>
  3089. <primary_key>false</primary_key>
  3090. <unique_key>false</unique_key>
  3091. <character_set></character_set>
  3092. <collation></collation>
  3093. <sequence>
  3094. <name></name>
  3095. <schema></schema>
  3096. <increment></increment>
  3097. <min_value></min_value>
  3098. <max_value></max_value>
  3099. <start></start>
  3100. <cache></cache>
  3101. <nocache>false</nocache>
  3102. <cycle>false</cycle>
  3103. <order>false</order>
  3104. <description></description>
  3105. <data_type></data_type>
  3106. <decimal_size>0</decimal_size>
  3107. </sequence>
  3108. </normal_column>
  3109. <normal_column>
  3110. <word_id>55</word_id>
  3111. <id>52</id>
  3112. <description></description>
  3113. <unique_key_name></unique_key_name>
  3114. <logical_name></logical_name>
  3115. <physical_name></physical_name>
  3116. <type>varchar(n)</type>
  3117. <constraint></constraint>
  3118. <default_value></default_value>
  3119. <auto_increment>false</auto_increment>
  3120. <foreign_key>false</foreign_key>
  3121. <not_null>false</not_null>
  3122. <primary_key>false</primary_key>
  3123. <unique_key>false</unique_key>
  3124. <character_set></character_set>
  3125. <collation></collation>
  3126. <sequence>
  3127. <name></name>
  3128. <schema></schema>
  3129. <increment></increment>
  3130. <min_value></min_value>
  3131. <max_value></max_value>
  3132. <start></start>
  3133. <cache></cache>
  3134. <nocache>false</nocache>
  3135. <cycle>false</cycle>
  3136. <order>false</order>
  3137. <description></description>
  3138. <data_type></data_type>
  3139. <decimal_size>0</decimal_size>
  3140. </sequence>
  3141. </normal_column>
  3142. <column_group>0</column_group>
  3143. </columns>
  3144. <indexes>
  3145. <inidex>
  3146. <full_text>false</full_text>
  3147. <non_unique>true</non_unique>
  3148. <name>sys_role_del_flag</name>
  3149. <type></type>
  3150. <description></description>
  3151. <columns>
  3152. <column>
  3153. <id>5</id>
  3154. <desc>false</desc>
  3155. </column>
  3156. </columns>
  3157. </inidex>
  3158. <inidex>
  3159. <full_text>false</full_text>
  3160. <non_unique>true</non_unique>
  3161. <name>sys_role_enname</name>
  3162. <type></type>
  3163. <description></description>
  3164. <columns>
  3165. <column>
  3166. <id>48</id>
  3167. <desc>false</desc>
  3168. </column>
  3169. </columns>
  3170. </inidex>
  3171. </indexes>
  3172. <complex_unique_key_list>
  3173. </complex_unique_key_list>
  3174. <table_properties>
  3175. <schema></schema>
  3176. </table_properties>
  3177. </table>
  3178. <table>
  3179. <id>9</id>
  3180. <height>-1</height>
  3181. <width>-1</width>
  3182. <font_name>Segoe UI</font_name>
  3183. <font_size>9</font_size>
  3184. <x>30</x>
  3185. <y>373</y>
  3186. <color>
  3187. <r>128</r>
  3188. <g>128</g>
  3189. <b>192</b>
  3190. </color>
  3191. <connections>
  3192. <relation>
  3193. <id>6</id>
  3194. <source>3</source>
  3195. <target>9</target>
  3196. <source_xp>-1</source_xp>
  3197. <source_yp>-1</source_yp>
  3198. <target_xp>-1</target_xp>
  3199. <target_yp>-1</target_yp>
  3200. <color>
  3201. <r>0</r>
  3202. <g>0</g>
  3203. <b>0</b>
  3204. </color>
  3205. <child_cardinality>1..n</child_cardinality>
  3206. <parent_cardinality>1</parent_cardinality>
  3207. <reference_for_pk>true</reference_for_pk>
  3208. <name></name>
  3209. <on_delete_action>RESTRICT</on_delete_action>
  3210. <on_update_action>RESTRICT</on_update_action>
  3211. <referenced_column>null</referenced_column>
  3212. <referenced_complex_unique_key>null</referenced_complex_unique_key>
  3213. </relation>
  3214. </connections>
  3215. <physical_name>sys_office</physical_name>
  3216. <logical_name>机构表</logical_name>
  3217. <description>部门表</description>
  3218. <constraint></constraint>
  3219. <primary_key_name></primary_key_name>
  3220. <option></option>
  3221. <columns>
  3222. <normal_column>
  3223. <word_id>15</word_id>
  3224. <id>53</id>
  3225. <description></description>
  3226. <unique_key_name></unique_key_name>
  3227. <logical_name></logical_name>
  3228. <physical_name></physical_name>
  3229. <type>varchar(n)</type>
  3230. <constraint></constraint>
  3231. <default_value></default_value>
  3232. <auto_increment>false</auto_increment>
  3233. <foreign_key>false</foreign_key>
  3234. <not_null>true</not_null>
  3235. <primary_key>true</primary_key>
  3236. <unique_key>false</unique_key>
  3237. <character_set></character_set>
  3238. <collation></collation>
  3239. <sequence>
  3240. <name></name>
  3241. <schema></schema>
  3242. <increment></increment>
  3243. <min_value></min_value>
  3244. <max_value></max_value>
  3245. <start></start>
  3246. <cache></cache>
  3247. <nocache>false</nocache>
  3248. <cycle>false</cycle>
  3249. <order>false</order>
  3250. <description></description>
  3251. <data_type></data_type>
  3252. <decimal_size>0</decimal_size>
  3253. </sequence>
  3254. </normal_column>
  3255. <column_group>1</column_group>
  3256. <normal_column>
  3257. <id>54</id>
  3258. <referenced_column>16</referenced_column>
  3259. <relation>6</relation>
  3260. <description>归属区域</description>
  3261. <unique_key_name></unique_key_name>
  3262. <logical_name>归属区域</logical_name>
  3263. <physical_name>area_id</physical_name>
  3264. <type>varchar(n)</type>
  3265. <constraint></constraint>
  3266. <default_value></default_value>
  3267. <auto_increment>false</auto_increment>
  3268. <foreign_key>true</foreign_key>
  3269. <not_null>true</not_null>
  3270. <primary_key>false</primary_key>
  3271. <unique_key>false</unique_key>
  3272. <character_set></character_set>
  3273. <collation></collation>
  3274. <sequence>
  3275. <name></name>
  3276. <schema></schema>
  3277. <increment></increment>
  3278. <min_value></min_value>
  3279. <max_value></max_value>
  3280. <start></start>
  3281. <cache></cache>
  3282. <nocache>false</nocache>
  3283. <cycle>false</cycle>
  3284. <order>false</order>
  3285. <description></description>
  3286. <data_type></data_type>
  3287. <decimal_size>0</decimal_size>
  3288. </sequence>
  3289. </normal_column>
  3290. <normal_column>
  3291. <word_id>1</word_id>
  3292. <id>55</id>
  3293. <description></description>
  3294. <unique_key_name></unique_key_name>
  3295. <logical_name></logical_name>
  3296. <physical_name></physical_name>
  3297. <type>varchar(n)</type>
  3298. <constraint></constraint>
  3299. <default_value></default_value>
  3300. <auto_increment>false</auto_increment>
  3301. <foreign_key>false</foreign_key>
  3302. <not_null>false</not_null>
  3303. <primary_key>false</primary_key>
  3304. <unique_key>false</unique_key>
  3305. <character_set></character_set>
  3306. <collation></collation>
  3307. <sequence>
  3308. <name></name>
  3309. <schema></schema>
  3310. <increment></increment>
  3311. <min_value></min_value>
  3312. <max_value></max_value>
  3313. <start></start>
  3314. <cache></cache>
  3315. <nocache>false</nocache>
  3316. <cycle>false</cycle>
  3317. <order>false</order>
  3318. <description></description>
  3319. <data_type></data_type>
  3320. <decimal_size>0</decimal_size>
  3321. </sequence>
  3322. </normal_column>
  3323. <normal_column>
  3324. <word_id>51</word_id>
  3325. <id>56</id>
  3326. <description></description>
  3327. <unique_key_name></unique_key_name>
  3328. <logical_name></logical_name>
  3329. <physical_name></physical_name>
  3330. <type>character(n)</type>
  3331. <constraint></constraint>
  3332. <default_value></default_value>
  3333. <auto_increment>false</auto_increment>
  3334. <foreign_key>false</foreign_key>
  3335. <not_null>true</not_null>
  3336. <primary_key>false</primary_key>
  3337. <unique_key>false</unique_key>
  3338. <character_set></character_set>
  3339. <collation></collation>
  3340. <sequence>
  3341. <name></name>
  3342. <schema></schema>
  3343. <increment></increment>
  3344. <min_value></min_value>
  3345. <max_value></max_value>
  3346. <start></start>
  3347. <cache></cache>
  3348. <nocache>false</nocache>
  3349. <cycle>false</cycle>
  3350. <order>false</order>
  3351. <description></description>
  3352. <data_type></data_type>
  3353. <decimal_size>0</decimal_size>
  3354. </sequence>
  3355. </normal_column>
  3356. <normal_column>
  3357. <word_id>12</word_id>
  3358. <id>57</id>
  3359. <description></description>
  3360. <unique_key_name></unique_key_name>
  3361. <logical_name></logical_name>
  3362. <physical_name></physical_name>
  3363. <type>character(n)</type>
  3364. <constraint></constraint>
  3365. <default_value></default_value>
  3366. <auto_increment>false</auto_increment>
  3367. <foreign_key>false</foreign_key>
  3368. <not_null>true</not_null>
  3369. <primary_key>false</primary_key>
  3370. <unique_key>false</unique_key>
  3371. <character_set></character_set>
  3372. <collation></collation>
  3373. <sequence>
  3374. <name></name>
  3375. <schema></schema>
  3376. <increment></increment>
  3377. <min_value></min_value>
  3378. <max_value></max_value>
  3379. <start></start>
  3380. <cache></cache>
  3381. <nocache>false</nocache>
  3382. <cycle>false</cycle>
  3383. <order>false</order>
  3384. <description></description>
  3385. <data_type></data_type>
  3386. <decimal_size>0</decimal_size>
  3387. </sequence>
  3388. </normal_column>
  3389. <normal_column>
  3390. <word_id>0</word_id>
  3391. <id>58</id>
  3392. <description></description>
  3393. <unique_key_name></unique_key_name>
  3394. <logical_name></logical_name>
  3395. <physical_name></physical_name>
  3396. <type>nvarchar(n)</type>
  3397. <constraint></constraint>
  3398. <default_value></default_value>
  3399. <auto_increment>false</auto_increment>
  3400. <foreign_key>false</foreign_key>
  3401. <not_null>false</not_null>
  3402. <primary_key>false</primary_key>
  3403. <unique_key>false</unique_key>
  3404. <character_set></character_set>
  3405. <collation></collation>
  3406. <sequence>
  3407. <name></name>
  3408. <schema></schema>
  3409. <increment></increment>
  3410. <min_value></min_value>
  3411. <max_value></max_value>
  3412. <start></start>
  3413. <cache></cache>
  3414. <nocache>false</nocache>
  3415. <cycle>false</cycle>
  3416. <order>false</order>
  3417. <description></description>
  3418. <data_type></data_type>
  3419. <decimal_size>0</decimal_size>
  3420. </sequence>
  3421. </normal_column>
  3422. <normal_column>
  3423. <word_id>60</word_id>
  3424. <id>59</id>
  3425. <description></description>
  3426. <unique_key_name></unique_key_name>
  3427. <logical_name></logical_name>
  3428. <physical_name></physical_name>
  3429. <type>varchar(n)</type>
  3430. <constraint></constraint>
  3431. <default_value></default_value>
  3432. <auto_increment>false</auto_increment>
  3433. <foreign_key>false</foreign_key>
  3434. <not_null>false</not_null>
  3435. <primary_key>false</primary_key>
  3436. <unique_key>false</unique_key>
  3437. <character_set></character_set>
  3438. <collation></collation>
  3439. <sequence>
  3440. <name></name>
  3441. <schema></schema>
  3442. <increment></increment>
  3443. <min_value></min_value>
  3444. <max_value></max_value>
  3445. <start></start>
  3446. <cache></cache>
  3447. <nocache>false</nocache>
  3448. <cycle>false</cycle>
  3449. <order>false</order>
  3450. <description></description>
  3451. <data_type></data_type>
  3452. <decimal_size>0</decimal_size>
  3453. </sequence>
  3454. </normal_column>
  3455. <normal_column>
  3456. <word_id>23</word_id>
  3457. <id>60</id>
  3458. <description></description>
  3459. <unique_key_name></unique_key_name>
  3460. <logical_name></logical_name>
  3461. <physical_name></physical_name>
  3462. <type>nvarchar(n)</type>
  3463. <constraint></constraint>
  3464. <default_value></default_value>
  3465. <auto_increment>false</auto_increment>
  3466. <foreign_key>false</foreign_key>
  3467. <not_null>false</not_null>
  3468. <primary_key>false</primary_key>
  3469. <unique_key>false</unique_key>
  3470. <character_set></character_set>
  3471. <collation></collation>
  3472. <sequence>
  3473. <name></name>
  3474. <schema></schema>
  3475. <increment></increment>
  3476. <min_value></min_value>
  3477. <max_value></max_value>
  3478. <start></start>
  3479. <cache></cache>
  3480. <nocache>false</nocache>
  3481. <cycle>false</cycle>
  3482. <order>false</order>
  3483. <description></description>
  3484. <data_type></data_type>
  3485. <decimal_size>0</decimal_size>
  3486. </sequence>
  3487. </normal_column>
  3488. <normal_column>
  3489. <word_id>37</word_id>
  3490. <id>61</id>
  3491. <description></description>
  3492. <unique_key_name></unique_key_name>
  3493. <logical_name></logical_name>
  3494. <physical_name></physical_name>
  3495. <type>nvarchar(n)</type>
  3496. <constraint></constraint>
  3497. <default_value></default_value>
  3498. <auto_increment>false</auto_increment>
  3499. <foreign_key>false</foreign_key>
  3500. <not_null>false</not_null>
  3501. <primary_key>false</primary_key>
  3502. <unique_key>false</unique_key>
  3503. <character_set></character_set>
  3504. <collation></collation>
  3505. <sequence>
  3506. <name></name>
  3507. <schema></schema>
  3508. <increment></increment>
  3509. <min_value></min_value>
  3510. <max_value></max_value>
  3511. <start></start>
  3512. <cache></cache>
  3513. <nocache>false</nocache>
  3514. <cycle>false</cycle>
  3515. <order>false</order>
  3516. <description></description>
  3517. <data_type></data_type>
  3518. <decimal_size>0</decimal_size>
  3519. </sequence>
  3520. </normal_column>
  3521. <normal_column>
  3522. <word_id>11</word_id>
  3523. <id>62</id>
  3524. <description></description>
  3525. <unique_key_name></unique_key_name>
  3526. <logical_name></logical_name>
  3527. <physical_name></physical_name>
  3528. <type>nvarchar(n)</type>
  3529. <constraint></constraint>
  3530. <default_value></default_value>
  3531. <auto_increment>false</auto_increment>
  3532. <foreign_key>false</foreign_key>
  3533. <not_null>false</not_null>
  3534. <primary_key>false</primary_key>
  3535. <unique_key>false</unique_key>
  3536. <character_set></character_set>
  3537. <collation></collation>
  3538. <sequence>
  3539. <name></name>
  3540. <schema></schema>
  3541. <increment></increment>
  3542. <min_value></min_value>
  3543. <max_value></max_value>
  3544. <start></start>
  3545. <cache></cache>
  3546. <nocache>false</nocache>
  3547. <cycle>false</cycle>
  3548. <order>false</order>
  3549. <description></description>
  3550. <data_type></data_type>
  3551. <decimal_size>0</decimal_size>
  3552. </sequence>
  3553. </normal_column>
  3554. <normal_column>
  3555. <word_id>8</word_id>
  3556. <id>63</id>
  3557. <description></description>
  3558. <unique_key_name></unique_key_name>
  3559. <logical_name></logical_name>
  3560. <physical_name></physical_name>
  3561. <type>nvarchar(n)</type>
  3562. <constraint></constraint>
  3563. <default_value></default_value>
  3564. <auto_increment>false</auto_increment>
  3565. <foreign_key>false</foreign_key>
  3566. <not_null>false</not_null>
  3567. <primary_key>false</primary_key>
  3568. <unique_key>false</unique_key>
  3569. <character_set></character_set>
  3570. <collation></collation>
  3571. <sequence>
  3572. <name></name>
  3573. <schema></schema>
  3574. <increment></increment>
  3575. <min_value></min_value>
  3576. <max_value></max_value>
  3577. <start></start>
  3578. <cache></cache>
  3579. <nocache>false</nocache>
  3580. <cycle>false</cycle>
  3581. <order>false</order>
  3582. <description></description>
  3583. <data_type></data_type>
  3584. <decimal_size>0</decimal_size>
  3585. </sequence>
  3586. </normal_column>
  3587. <normal_column>
  3588. <word_id>56</word_id>
  3589. <id>64</id>
  3590. <description></description>
  3591. <unique_key_name></unique_key_name>
  3592. <logical_name></logical_name>
  3593. <physical_name></physical_name>
  3594. <type>varchar(n)</type>
  3595. <constraint></constraint>
  3596. <default_value></default_value>
  3597. <auto_increment>false</auto_increment>
  3598. <foreign_key>false</foreign_key>
  3599. <not_null>false</not_null>
  3600. <primary_key>false</primary_key>
  3601. <unique_key>false</unique_key>
  3602. <character_set></character_set>
  3603. <collation></collation>
  3604. <sequence>
  3605. <name></name>
  3606. <schema></schema>
  3607. <increment></increment>
  3608. <min_value></min_value>
  3609. <max_value></max_value>
  3610. <start></start>
  3611. <cache></cache>
  3612. <nocache>false</nocache>
  3613. <cycle>false</cycle>
  3614. <order>false</order>
  3615. <description></description>
  3616. <data_type></data_type>
  3617. <decimal_size>0</decimal_size>
  3618. </sequence>
  3619. </normal_column>
  3620. <normal_column>
  3621. <word_id>40</word_id>
  3622. <id>65</id>
  3623. <description></description>
  3624. <unique_key_name></unique_key_name>
  3625. <logical_name></logical_name>
  3626. <physical_name></physical_name>
  3627. <type>varchar(n)</type>
  3628. <constraint></constraint>
  3629. <default_value></default_value>
  3630. <auto_increment>false</auto_increment>
  3631. <foreign_key>false</foreign_key>
  3632. <not_null>false</not_null>
  3633. <primary_key>false</primary_key>
  3634. <unique_key>false</unique_key>
  3635. <character_set></character_set>
  3636. <collation></collation>
  3637. <sequence>
  3638. <name></name>
  3639. <schema></schema>
  3640. <increment></increment>
  3641. <min_value></min_value>
  3642. <max_value></max_value>
  3643. <start></start>
  3644. <cache></cache>
  3645. <nocache>false</nocache>
  3646. <cycle>false</cycle>
  3647. <order>false</order>
  3648. <description></description>
  3649. <data_type></data_type>
  3650. <decimal_size>0</decimal_size>
  3651. </sequence>
  3652. </normal_column>
  3653. <normal_column>
  3654. <word_id>6</word_id>
  3655. <id>66</id>
  3656. <description></description>
  3657. <unique_key_name></unique_key_name>
  3658. <logical_name></logical_name>
  3659. <physical_name></physical_name>
  3660. <type>varchar(n)</type>
  3661. <constraint></constraint>
  3662. <default_value></default_value>
  3663. <auto_increment>false</auto_increment>
  3664. <foreign_key>false</foreign_key>
  3665. <not_null>false</not_null>
  3666. <primary_key>false</primary_key>
  3667. <unique_key>false</unique_key>
  3668. <character_set></character_set>
  3669. <collation></collation>
  3670. <sequence>
  3671. <name></name>
  3672. <schema></schema>
  3673. <increment></increment>
  3674. <min_value></min_value>
  3675. <max_value></max_value>
  3676. <start></start>
  3677. <cache></cache>
  3678. <nocache>false</nocache>
  3679. <cycle>false</cycle>
  3680. <order>false</order>
  3681. <description></description>
  3682. <data_type></data_type>
  3683. <decimal_size>0</decimal_size>
  3684. </sequence>
  3685. </normal_column>
  3686. <column_group>0</column_group>
  3687. </columns>
  3688. <indexes>
  3689. <inidex>
  3690. <full_text>false</full_text>
  3691. <non_unique>true</non_unique>
  3692. <name>sys_office_parent_id</name>
  3693. <type></type>
  3694. <description></description>
  3695. <columns>
  3696. <column>
  3697. <id>6</id>
  3698. <desc>false</desc>
  3699. </column>
  3700. </columns>
  3701. </inidex>
  3702. <inidex>
  3703. <full_text>false</full_text>
  3704. <non_unique>true</non_unique>
  3705. <name>sys_office_parent_ids</name>
  3706. <type></type>
  3707. <description></description>
  3708. <columns>
  3709. <column>
  3710. <id>7</id>
  3711. <desc>false</desc>
  3712. </column>
  3713. </columns>
  3714. </inidex>
  3715. <inidex>
  3716. <full_text>false</full_text>
  3717. <non_unique>true</non_unique>
  3718. <name>sys_office_del_flag</name>
  3719. <type></type>
  3720. <description></description>
  3721. <columns>
  3722. <column>
  3723. <id>5</id>
  3724. <desc>false</desc>
  3725. </column>
  3726. </columns>
  3727. </inidex>
  3728. <inidex>
  3729. <full_text>false</full_text>
  3730. <non_unique>true</non_unique>
  3731. <name>sys_office_type</name>
  3732. <type></type>
  3733. <description></description>
  3734. <columns>
  3735. <column>
  3736. <id>56</id>
  3737. <desc>false</desc>
  3738. </column>
  3739. </columns>
  3740. </inidex>
  3741. </indexes>
  3742. <complex_unique_key_list>
  3743. </complex_unique_key_list>
  3744. <table_properties>
  3745. <schema></schema>
  3746. </table_properties>
  3747. </table>
  3748. <table>
  3749. <id>10</id>
  3750. <height>-1</height>
  3751. <width>-1</width>
  3752. <font_name>Segoe UI</font_name>
  3753. <font_size>9</font_size>
  3754. <x>372</x>
  3755. <y>27</y>
  3756. <color>
  3757. <r>128</r>
  3758. <g>128</g>
  3759. <b>192</b>
  3760. </color>
  3761. <connections>
  3762. <relation>
  3763. <id>7</id>
  3764. <source>9</source>
  3765. <target>10</target>
  3766. <source_xp>-1</source_xp>
  3767. <source_yp>-1</source_yp>
  3768. <target_xp>-1</target_xp>
  3769. <target_yp>-1</target_yp>
  3770. <color>
  3771. <r>0</r>
  3772. <g>0</g>
  3773. <b>0</b>
  3774. </color>
  3775. <child_cardinality>1..n</child_cardinality>
  3776. <parent_cardinality>1</parent_cardinality>
  3777. <reference_for_pk>true</reference_for_pk>
  3778. <name></name>
  3779. <on_delete_action>RESTRICT</on_delete_action>
  3780. <on_update_action>RESTRICT</on_update_action>
  3781. <referenced_column>null</referenced_column>
  3782. <referenced_complex_unique_key>null</referenced_complex_unique_key>
  3783. </relation>
  3784. <relation>
  3785. <id>8</id>
  3786. <source>9</source>
  3787. <target>10</target>
  3788. <source_xp>-1</source_xp>
  3789. <source_yp>-1</source_yp>
  3790. <target_xp>-1</target_xp>
  3791. <target_yp>-1</target_yp>
  3792. <bendpoint>
  3793. <relative>false</relative>
  3794. <x>344</x>
  3795. <y>327</y>
  3796. </bendpoint>
  3797. <color>
  3798. <r>0</r>
  3799. <g>0</g>
  3800. <b>0</b>
  3801. </color>
  3802. <child_cardinality>1..n</child_cardinality>
  3803. <parent_cardinality>1</parent_cardinality>
  3804. <reference_for_pk>true</reference_for_pk>
  3805. <name></name>
  3806. <on_delete_action>RESTRICT</on_delete_action>
  3807. <on_update_action>RESTRICT</on_update_action>
  3808. <referenced_column>null</referenced_column>
  3809. <referenced_complex_unique_key>null</referenced_complex_unique_key>
  3810. </relation>
  3811. </connections>
  3812. <physical_name>sys_user</physical_name>
  3813. <logical_name>用户表</logical_name>
  3814. <description>用户表</description>
  3815. <constraint></constraint>
  3816. <primary_key_name></primary_key_name>
  3817. <option></option>
  3818. <columns>
  3819. <normal_column>
  3820. <word_id>15</word_id>
  3821. <id>67</id>
  3822. <description></description>
  3823. <unique_key_name></unique_key_name>
  3824. <logical_name></logical_name>
  3825. <physical_name></physical_name>
  3826. <type>varchar(n)</type>
  3827. <constraint></constraint>
  3828. <default_value></default_value>
  3829. <auto_increment>false</auto_increment>
  3830. <foreign_key>false</foreign_key>
  3831. <not_null>true</not_null>
  3832. <primary_key>true</primary_key>
  3833. <unique_key>false</unique_key>
  3834. <character_set></character_set>
  3835. <collation></collation>
  3836. <sequence>
  3837. <name></name>
  3838. <schema></schema>
  3839. <increment></increment>
  3840. <min_value></min_value>
  3841. <max_value></max_value>
  3842. <start></start>
  3843. <cache></cache>
  3844. <nocache>false</nocache>
  3845. <cycle>false</cycle>
  3846. <order>false</order>
  3847. <description></description>
  3848. <data_type></data_type>
  3849. <decimal_size>0</decimal_size>
  3850. </sequence>
  3851. </normal_column>
  3852. <normal_column>
  3853. <id>68</id>
  3854. <referenced_column>53</referenced_column>
  3855. <relation>7</relation>
  3856. <description>归属公司</description>
  3857. <unique_key_name></unique_key_name>
  3858. <logical_name>归属公司</logical_name>
  3859. <physical_name>company_id</physical_name>
  3860. <type>varchar(n)</type>
  3861. <constraint></constraint>
  3862. <default_value></default_value>
  3863. <auto_increment>false</auto_increment>
  3864. <foreign_key>true</foreign_key>
  3865. <not_null>true</not_null>
  3866. <primary_key>false</primary_key>
  3867. <unique_key>false</unique_key>
  3868. <character_set></character_set>
  3869. <collation></collation>
  3870. <sequence>
  3871. <name></name>
  3872. <schema></schema>
  3873. <increment></increment>
  3874. <min_value></min_value>
  3875. <max_value></max_value>
  3876. <start></start>
  3877. <cache></cache>
  3878. <nocache>false</nocache>
  3879. <cycle>false</cycle>
  3880. <order>false</order>
  3881. <description></description>
  3882. <data_type></data_type>
  3883. <decimal_size>0</decimal_size>
  3884. </sequence>
  3885. </normal_column>
  3886. <normal_column>
  3887. <id>69</id>
  3888. <referenced_column>53</referenced_column>
  3889. <relation>8</relation>
  3890. <description>归属部门</description>
  3891. <unique_key_name></unique_key_name>
  3892. <logical_name>归属部门</logical_name>
  3893. <physical_name>office_id</physical_name>
  3894. <type>varchar(n)</type>
  3895. <constraint></constraint>
  3896. <default_value></default_value>
  3897. <auto_increment>false</auto_increment>
  3898. <foreign_key>true</foreign_key>
  3899. <not_null>true</not_null>
  3900. <primary_key>false</primary_key>
  3901. <unique_key>false</unique_key>
  3902. <character_set></character_set>
  3903. <collation></collation>
  3904. <sequence>
  3905. <name></name>
  3906. <schema></schema>
  3907. <increment></increment>
  3908. <min_value></min_value>
  3909. <max_value></max_value>
  3910. <start></start>
  3911. <cache></cache>
  3912. <nocache>false</nocache>
  3913. <cycle>false</cycle>
  3914. <order>false</order>
  3915. <description></description>
  3916. <data_type></data_type>
  3917. <decimal_size>0</decimal_size>
  3918. </sequence>
  3919. </normal_column>
  3920. <normal_column>
  3921. <word_id>22</word_id>
  3922. <id>70</id>
  3923. <description></description>
  3924. <unique_key_name></unique_key_name>
  3925. <logical_name></logical_name>
  3926. <physical_name></physical_name>
  3927. <type>varchar(n)</type>
  3928. <constraint></constraint>
  3929. <default_value></default_value>
  3930. <auto_increment>false</auto_increment>
  3931. <foreign_key>false</foreign_key>
  3932. <not_null>true</not_null>
  3933. <primary_key>false</primary_key>
  3934. <unique_key>false</unique_key>
  3935. <character_set></character_set>
  3936. <collation></collation>
  3937. <sequence>
  3938. <name></name>
  3939. <schema></schema>
  3940. <increment></increment>
  3941. <min_value></min_value>
  3942. <max_value></max_value>
  3943. <start></start>
  3944. <cache></cache>
  3945. <nocache>false</nocache>
  3946. <cycle>false</cycle>
  3947. <order>false</order>
  3948. <description></description>
  3949. <data_type></data_type>
  3950. <decimal_size>0</decimal_size>
  3951. </sequence>
  3952. </normal_column>
  3953. <normal_column>
  3954. <word_id>35</word_id>
  3955. <id>71</id>
  3956. <description></description>
  3957. <unique_key_name></unique_key_name>
  3958. <logical_name></logical_name>
  3959. <physical_name></physical_name>
  3960. <type>varchar(n)</type>
  3961. <constraint></constraint>
  3962. <default_value></default_value>
  3963. <auto_increment>false</auto_increment>
  3964. <foreign_key>false</foreign_key>
  3965. <not_null>true</not_null>
  3966. <primary_key>false</primary_key>
  3967. <unique_key>false</unique_key>
  3968. <character_set></character_set>
  3969. <collation></collation>
  3970. <sequence>
  3971. <name></name>
  3972. <schema></schema>
  3973. <increment></increment>
  3974. <min_value></min_value>
  3975. <max_value></max_value>
  3976. <start></start>
  3977. <cache></cache>
  3978. <nocache>false</nocache>
  3979. <cycle>false</cycle>
  3980. <order>false</order>
  3981. <description></description>
  3982. <data_type></data_type>
  3983. <decimal_size>0</decimal_size>
  3984. </sequence>
  3985. </normal_column>
  3986. <normal_column>
  3987. <word_id>29</word_id>
  3988. <id>72</id>
  3989. <description></description>
  3990. <unique_key_name></unique_key_name>
  3991. <logical_name></logical_name>
  3992. <physical_name></physical_name>
  3993. <type>varchar(n)</type>
  3994. <constraint></constraint>
  3995. <default_value></default_value>
  3996. <auto_increment>false</auto_increment>
  3997. <foreign_key>false</foreign_key>
  3998. <not_null>false</not_null>
  3999. <primary_key>false</primary_key>
  4000. <unique_key>false</unique_key>
  4001. <character_set></character_set>
  4002. <collation></collation>
  4003. <sequence>
  4004. <name></name>
  4005. <schema></schema>
  4006. <increment></increment>
  4007. <min_value></min_value>
  4008. <max_value></max_value>
  4009. <start></start>
  4010. <cache></cache>
  4011. <nocache>false</nocache>
  4012. <cycle>false</cycle>
  4013. <order>false</order>
  4014. <description></description>
  4015. <data_type></data_type>
  4016. <decimal_size>0</decimal_size>
  4017. </sequence>
  4018. </normal_column>
  4019. <normal_column>
  4020. <word_id>27</word_id>
  4021. <id>73</id>
  4022. <description></description>
  4023. <unique_key_name></unique_key_name>
  4024. <logical_name></logical_name>
  4025. <physical_name></physical_name>
  4026. <type>nvarchar(n)</type>
  4027. <constraint></constraint>
  4028. <default_value></default_value>
  4029. <auto_increment>false</auto_increment>
  4030. <foreign_key>false</foreign_key>
  4031. <not_null>true</not_null>
  4032. <primary_key>false</primary_key>
  4033. <unique_key>false</unique_key>
  4034. <character_set></character_set>
  4035. <collation></collation>
  4036. <sequence>
  4037. <name></name>
  4038. <schema></schema>
  4039. <increment></increment>
  4040. <min_value></min_value>
  4041. <max_value></max_value>
  4042. <start></start>
  4043. <cache></cache>
  4044. <nocache>false</nocache>
  4045. <cycle>false</cycle>
  4046. <order>false</order>
  4047. <description></description>
  4048. <data_type></data_type>
  4049. <decimal_size>0</decimal_size>
  4050. </sequence>
  4051. </normal_column>
  4052. <normal_column>
  4053. <word_id>8</word_id>
  4054. <id>74</id>
  4055. <description></description>
  4056. <unique_key_name></unique_key_name>
  4057. <logical_name></logical_name>
  4058. <physical_name></physical_name>
  4059. <type>nvarchar(n)</type>
  4060. <constraint></constraint>
  4061. <default_value></default_value>
  4062. <auto_increment>false</auto_increment>
  4063. <foreign_key>false</foreign_key>
  4064. <not_null>false</not_null>
  4065. <primary_key>false</primary_key>
  4066. <unique_key>false</unique_key>
  4067. <character_set></character_set>
  4068. <collation></collation>
  4069. <sequence>
  4070. <name></name>
  4071. <schema></schema>
  4072. <increment></increment>
  4073. <min_value></min_value>
  4074. <max_value></max_value>
  4075. <start></start>
  4076. <cache></cache>
  4077. <nocache>false</nocache>
  4078. <cycle>false</cycle>
  4079. <order>false</order>
  4080. <description></description>
  4081. <data_type></data_type>
  4082. <decimal_size>0</decimal_size>
  4083. </sequence>
  4084. </normal_column>
  4085. <normal_column>
  4086. <word_id>38</word_id>
  4087. <id>75</id>
  4088. <description></description>
  4089. <unique_key_name></unique_key_name>
  4090. <logical_name></logical_name>
  4091. <physical_name></physical_name>
  4092. <type>varchar(n)</type>
  4093. <constraint></constraint>
  4094. <default_value></default_value>
  4095. <auto_increment>false</auto_increment>
  4096. <foreign_key>false</foreign_key>
  4097. <not_null>false</not_null>
  4098. <primary_key>false</primary_key>
  4099. <unique_key>false</unique_key>
  4100. <character_set></character_set>
  4101. <collation></collation>
  4102. <sequence>
  4103. <name></name>
  4104. <schema></schema>
  4105. <increment></increment>
  4106. <min_value></min_value>
  4107. <max_value></max_value>
  4108. <start></start>
  4109. <cache></cache>
  4110. <nocache>false</nocache>
  4111. <cycle>false</cycle>
  4112. <order>false</order>
  4113. <description></description>
  4114. <data_type></data_type>
  4115. <decimal_size>0</decimal_size>
  4116. </sequence>
  4117. </normal_column>
  4118. <normal_column>
  4119. <word_id>25</word_id>
  4120. <id>76</id>
  4121. <description></description>
  4122. <unique_key_name></unique_key_name>
  4123. <logical_name></logical_name>
  4124. <physical_name></physical_name>
  4125. <type>varchar(n)</type>
  4126. <constraint></constraint>
  4127. <default_value></default_value>
  4128. <auto_increment>false</auto_increment>
  4129. <foreign_key>false</foreign_key>
  4130. <not_null>false</not_null>
  4131. <primary_key>false</primary_key>
  4132. <unique_key>false</unique_key>
  4133. <character_set></character_set>
  4134. <collation></collation>
  4135. <sequence>
  4136. <name></name>
  4137. <schema></schema>
  4138. <increment></increment>
  4139. <min_value></min_value>
  4140. <max_value></max_value>
  4141. <start></start>
  4142. <cache></cache>
  4143. <nocache>false</nocache>
  4144. <cycle>false</cycle>
  4145. <order>false</order>
  4146. <description></description>
  4147. <data_type></data_type>
  4148. <decimal_size>0</decimal_size>
  4149. </sequence>
  4150. </normal_column>
  4151. <normal_column>
  4152. <word_id>58</word_id>
  4153. <id>77</id>
  4154. <description></description>
  4155. <unique_key_name></unique_key_name>
  4156. <logical_name></logical_name>
  4157. <physical_name></physical_name>
  4158. <type>character(n)</type>
  4159. <constraint></constraint>
  4160. <default_value></default_value>
  4161. <auto_increment>false</auto_increment>
  4162. <foreign_key>false</foreign_key>
  4163. <not_null>false</not_null>
  4164. <primary_key>false</primary_key>
  4165. <unique_key>false</unique_key>
  4166. <character_set></character_set>
  4167. <collation></collation>
  4168. <sequence>
  4169. <name></name>
  4170. <schema></schema>
  4171. <increment></increment>
  4172. <min_value></min_value>
  4173. <max_value></max_value>
  4174. <start></start>
  4175. <cache></cache>
  4176. <nocache>false</nocache>
  4177. <cycle>false</cycle>
  4178. <order>false</order>
  4179. <description></description>
  4180. <data_type></data_type>
  4181. <decimal_size>0</decimal_size>
  4182. </sequence>
  4183. </normal_column>
  4184. <normal_column>
  4185. <word_id>39</word_id>
  4186. <id>78</id>
  4187. <description></description>
  4188. <unique_key_name></unique_key_name>
  4189. <logical_name></logical_name>
  4190. <physical_name></physical_name>
  4191. <type>varchar(n)</type>
  4192. <constraint></constraint>
  4193. <default_value></default_value>
  4194. <auto_increment>false</auto_increment>
  4195. <foreign_key>false</foreign_key>
  4196. <not_null>false</not_null>
  4197. <primary_key>false</primary_key>
  4198. <unique_key>false</unique_key>
  4199. <character_set></character_set>
  4200. <collation></collation>
  4201. <sequence>
  4202. <name></name>
  4203. <schema></schema>
  4204. <increment></increment>
  4205. <min_value></min_value>
  4206. <max_value></max_value>
  4207. <start></start>
  4208. <cache></cache>
  4209. <nocache>false</nocache>
  4210. <cycle>false</cycle>
  4211. <order>false</order>
  4212. <description></description>
  4213. <data_type></data_type>
  4214. <decimal_size>0</decimal_size>
  4215. </sequence>
  4216. </normal_column>
  4217. <normal_column>
  4218. <word_id>21</word_id>
  4219. <id>79</id>
  4220. <description></description>
  4221. <unique_key_name></unique_key_name>
  4222. <logical_name></logical_name>
  4223. <physical_name></physical_name>
  4224. <type>varchar(n)</type>
  4225. <constraint></constraint>
  4226. <default_value></default_value>
  4227. <auto_increment>false</auto_increment>
  4228. <foreign_key>false</foreign_key>
  4229. <not_null>false</not_null>
  4230. <primary_key>false</primary_key>
  4231. <unique_key>false</unique_key>
  4232. <character_set></character_set>
  4233. <collation></collation>
  4234. <sequence>
  4235. <name></name>
  4236. <schema></schema>
  4237. <increment></increment>
  4238. <min_value></min_value>
  4239. <max_value></max_value>
  4240. <start></start>
  4241. <cache></cache>
  4242. <nocache>false</nocache>
  4243. <cycle>false</cycle>
  4244. <order>false</order>
  4245. <description></description>
  4246. <data_type></data_type>
  4247. <decimal_size>0</decimal_size>
  4248. </sequence>
  4249. </normal_column>
  4250. <normal_column>
  4251. <word_id>19</word_id>
  4252. <id>80</id>
  4253. <description></description>
  4254. <unique_key_name></unique_key_name>
  4255. <logical_name></logical_name>
  4256. <physical_name></physical_name>
  4257. <type>datetime</type>
  4258. <constraint></constraint>
  4259. <default_value></default_value>
  4260. <auto_increment>false</auto_increment>
  4261. <foreign_key>false</foreign_key>
  4262. <not_null>false</not_null>
  4263. <primary_key>false</primary_key>
  4264. <unique_key>false</unique_key>
  4265. <character_set></character_set>
  4266. <collation></collation>
  4267. <sequence>
  4268. <name></name>
  4269. <schema></schema>
  4270. <increment></increment>
  4271. <min_value></min_value>
  4272. <max_value></max_value>
  4273. <start></start>
  4274. <cache></cache>
  4275. <nocache>false</nocache>
  4276. <cycle>false</cycle>
  4277. <order>false</order>
  4278. <description></description>
  4279. <data_type></data_type>
  4280. <decimal_size>0</decimal_size>
  4281. </sequence>
  4282. </normal_column>
  4283. <normal_column>
  4284. <word_id>20</word_id>
  4285. <id>81</id>
  4286. <description></description>
  4287. <unique_key_name></unique_key_name>
  4288. <logical_name></logical_name>
  4289. <physical_name></physical_name>
  4290. <type>varchar(n)</type>
  4291. <constraint></constraint>
  4292. <default_value></default_value>
  4293. <auto_increment>false</auto_increment>
  4294. <foreign_key>false</foreign_key>
  4295. <not_null>false</not_null>
  4296. <primary_key>false</primary_key>
  4297. <unique_key>false</unique_key>
  4298. <character_set></character_set>
  4299. <collation></collation>
  4300. <sequence>
  4301. <name></name>
  4302. <schema></schema>
  4303. <increment></increment>
  4304. <min_value></min_value>
  4305. <max_value></max_value>
  4306. <start></start>
  4307. <cache></cache>
  4308. <nocache>false</nocache>
  4309. <cycle>false</cycle>
  4310. <order>false</order>
  4311. <description></description>
  4312. <data_type></data_type>
  4313. <decimal_size>0</decimal_size>
  4314. </sequence>
  4315. </normal_column>
  4316. <column_group>0</column_group>
  4317. </columns>
  4318. <indexes>
  4319. <inidex>
  4320. <full_text>false</full_text>
  4321. <non_unique>true</non_unique>
  4322. <name>sys_user_office_id</name>
  4323. <type></type>
  4324. <description></description>
  4325. <columns>
  4326. <column>
  4327. <id>69</id>
  4328. <desc>false</desc>
  4329. </column>
  4330. </columns>
  4331. </inidex>
  4332. <inidex>
  4333. <full_text>false</full_text>
  4334. <non_unique>true</non_unique>
  4335. <name>sys_user_login_name</name>
  4336. <type></type>
  4337. <description></description>
  4338. <columns>
  4339. <column>
  4340. <id>70</id>
  4341. <desc>false</desc>
  4342. </column>
  4343. </columns>
  4344. </inidex>
  4345. <inidex>
  4346. <full_text>false</full_text>
  4347. <non_unique>true</non_unique>
  4348. <name>sys_user_company_id</name>
  4349. <type></type>
  4350. <description></description>
  4351. <columns>
  4352. <column>
  4353. <id>68</id>
  4354. <desc>false</desc>
  4355. </column>
  4356. </columns>
  4357. </inidex>
  4358. <inidex>
  4359. <full_text>false</full_text>
  4360. <non_unique>true</non_unique>
  4361. <name>sys_user_update_date</name>
  4362. <type></type>
  4363. <description></description>
  4364. <columns>
  4365. <column>
  4366. <id>3</id>
  4367. <desc>false</desc>
  4368. </column>
  4369. </columns>
  4370. </inidex>
  4371. <inidex>
  4372. <full_text>false</full_text>
  4373. <non_unique>true</non_unique>
  4374. <name>sys_user_del_flag</name>
  4375. <type></type>
  4376. <description></description>
  4377. <columns>
  4378. <column>
  4379. <id>5</id>
  4380. <desc>false</desc>
  4381. </column>
  4382. </columns>
  4383. </inidex>
  4384. </indexes>
  4385. <complex_unique_key_list>
  4386. </complex_unique_key_list>
  4387. <table_properties>
  4388. <schema></schema>
  4389. </table_properties>
  4390. </table>
  4391. </contents>
  4392. <column_groups>
  4393. <column_group>
  4394. <id>0</id>
  4395. <group_name>common</group_name>
  4396. <columns>
  4397. <normal_column>
  4398. <word_id>2</word_id>
  4399. <id>0</id>
  4400. <description></description>
  4401. <unique_key_name></unique_key_name>
  4402. <logical_name></logical_name>
  4403. <physical_name></physical_name>
  4404. <type>varchar(n)</type>
  4405. <constraint></constraint>
  4406. <default_value></default_value>
  4407. <auto_increment>false</auto_increment>
  4408. <foreign_key>false</foreign_key>
  4409. <not_null>true</not_null>
  4410. <primary_key>false</primary_key>
  4411. <unique_key>false</unique_key>
  4412. <character_set></character_set>
  4413. <collation></collation>
  4414. <sequence>
  4415. <name></name>
  4416. <schema></schema>
  4417. <increment></increment>
  4418. <min_value></min_value>
  4419. <max_value></max_value>
  4420. <start></start>
  4421. <cache></cache>
  4422. <nocache>false</nocache>
  4423. <cycle>false</cycle>
  4424. <order>false</order>
  4425. <description></description>
  4426. <data_type></data_type>
  4427. <decimal_size>0</decimal_size>
  4428. </sequence>
  4429. </normal_column>
  4430. <normal_column>
  4431. <word_id>3</word_id>
  4432. <id>1</id>
  4433. <description></description>
  4434. <unique_key_name></unique_key_name>
  4435. <logical_name></logical_name>
  4436. <physical_name></physical_name>
  4437. <type>datetime</type>
  4438. <constraint></constraint>
  4439. <default_value></default_value>
  4440. <auto_increment>false</auto_increment>
  4441. <foreign_key>false</foreign_key>
  4442. <not_null>true</not_null>
  4443. <primary_key>false</primary_key>
  4444. <unique_key>false</unique_key>
  4445. <character_set></character_set>
  4446. <collation></collation>
  4447. <sequence>
  4448. <name></name>
  4449. <schema></schema>
  4450. <increment></increment>
  4451. <min_value></min_value>
  4452. <max_value></max_value>
  4453. <start></start>
  4454. <cache></cache>
  4455. <nocache>false</nocache>
  4456. <cycle>false</cycle>
  4457. <order>false</order>
  4458. <description></description>
  4459. <data_type></data_type>
  4460. <decimal_size>0</decimal_size>
  4461. </sequence>
  4462. </normal_column>
  4463. <normal_column>
  4464. <word_id>53</word_id>
  4465. <id>2</id>
  4466. <description></description>
  4467. <unique_key_name></unique_key_name>
  4468. <logical_name></logical_name>
  4469. <physical_name></physical_name>
  4470. <type>varchar(n)</type>
  4471. <constraint></constraint>
  4472. <default_value></default_value>
  4473. <auto_increment>false</auto_increment>
  4474. <foreign_key>false</foreign_key>
  4475. <not_null>true</not_null>
  4476. <primary_key>false</primary_key>
  4477. <unique_key>false</unique_key>
  4478. <character_set></character_set>
  4479. <collation></collation>
  4480. <sequence>
  4481. <name></name>
  4482. <schema></schema>
  4483. <increment></increment>
  4484. <min_value></min_value>
  4485. <max_value></max_value>
  4486. <start></start>
  4487. <cache></cache>
  4488. <nocache>false</nocache>
  4489. <cycle>false</cycle>
  4490. <order>false</order>
  4491. <description></description>
  4492. <data_type></data_type>
  4493. <decimal_size>0</decimal_size>
  4494. </sequence>
  4495. </normal_column>
  4496. <normal_column>
  4497. <word_id>54</word_id>
  4498. <id>3</id>
  4499. <description></description>
  4500. <unique_key_name></unique_key_name>
  4501. <logical_name></logical_name>
  4502. <physical_name></physical_name>
  4503. <type>datetime</type>
  4504. <constraint></constraint>
  4505. <default_value></default_value>
  4506. <auto_increment>false</auto_increment>
  4507. <foreign_key>false</foreign_key>
  4508. <not_null>true</not_null>
  4509. <primary_key>false</primary_key>
  4510. <unique_key>false</unique_key>
  4511. <character_set></character_set>
  4512. <collation></collation>
  4513. <sequence>
  4514. <name></name>
  4515. <schema></schema>
  4516. <increment></increment>
  4517. <min_value></min_value>
  4518. <max_value></max_value>
  4519. <start></start>
  4520. <cache></cache>
  4521. <nocache>false</nocache>
  4522. <cycle>false</cycle>
  4523. <order>false</order>
  4524. <description></description>
  4525. <data_type></data_type>
  4526. <decimal_size>0</decimal_size>
  4527. </sequence>
  4528. </normal_column>
  4529. <normal_column>
  4530. <word_id>41</word_id>
  4531. <id>4</id>
  4532. <description></description>
  4533. <unique_key_name></unique_key_name>
  4534. <logical_name></logical_name>
  4535. <physical_name></physical_name>
  4536. <type>nvarchar(n)</type>
  4537. <constraint></constraint>
  4538. <default_value></default_value>
  4539. <auto_increment>false</auto_increment>
  4540. <foreign_key>false</foreign_key>
  4541. <not_null>false</not_null>
  4542. <primary_key>false</primary_key>
  4543. <unique_key>false</unique_key>
  4544. <character_set></character_set>
  4545. <collation></collation>
  4546. <sequence>
  4547. <name></name>
  4548. <schema></schema>
  4549. <increment></increment>
  4550. <min_value></min_value>
  4551. <max_value></max_value>
  4552. <start></start>
  4553. <cache></cache>
  4554. <nocache>false</nocache>
  4555. <cycle>false</cycle>
  4556. <order>false</order>
  4557. <description></description>
  4558. <data_type></data_type>
  4559. <decimal_size>0</decimal_size>
  4560. </sequence>
  4561. </normal_column>
  4562. <normal_column>
  4563. <word_id>5</word_id>
  4564. <id>5</id>
  4565. <description></description>
  4566. <unique_key_name></unique_key_name>
  4567. <logical_name></logical_name>
  4568. <physical_name></physical_name>
  4569. <type>character(n)</type>
  4570. <constraint></constraint>
  4571. <default_value>0</default_value>
  4572. <auto_increment>false</auto_increment>
  4573. <foreign_key>false</foreign_key>
  4574. <not_null>true</not_null>
  4575. <primary_key>false</primary_key>
  4576. <unique_key>false</unique_key>
  4577. <character_set></character_set>
  4578. <collation></collation>
  4579. <sequence>
  4580. <name></name>
  4581. <schema></schema>
  4582. <increment></increment>
  4583. <min_value></min_value>
  4584. <max_value></max_value>
  4585. <start></start>
  4586. <cache></cache>
  4587. <nocache>false</nocache>
  4588. <cycle>false</cycle>
  4589. <order>false</order>
  4590. <description></description>
  4591. <data_type></data_type>
  4592. <decimal_size>0</decimal_size>
  4593. </sequence>
  4594. </normal_column>
  4595. </columns>
  4596. </column_group>
  4597. <column_group>
  4598. <id>1</id>
  4599. <group_name>tree_fild</group_name>
  4600. <columns>
  4601. <normal_column>
  4602. <word_id>32</word_id>
  4603. <id>6</id>
  4604. <description></description>
  4605. <unique_key_name></unique_key_name>
  4606. <logical_name></logical_name>
  4607. <physical_name></physical_name>
  4608. <type>varchar(n)</type>
  4609. <constraint></constraint>
  4610. <default_value></default_value>
  4611. <auto_increment>false</auto_increment>
  4612. <foreign_key>false</foreign_key>
  4613. <not_null>true</not_null>
  4614. <primary_key>false</primary_key>
  4615. <unique_key>false</unique_key>
  4616. <character_set></character_set>
  4617. <collation></collation>
  4618. <sequence>
  4619. <name></name>
  4620. <schema></schema>
  4621. <increment></increment>
  4622. <min_value></min_value>
  4623. <max_value></max_value>
  4624. <start></start>
  4625. <cache></cache>
  4626. <nocache>false</nocache>
  4627. <cycle>false</cycle>
  4628. <order>false</order>
  4629. <description></description>
  4630. <data_type></data_type>
  4631. <decimal_size>0</decimal_size>
  4632. </sequence>
  4633. </normal_column>
  4634. <normal_column>
  4635. <word_id>34</word_id>
  4636. <id>7</id>
  4637. <description></description>
  4638. <unique_key_name></unique_key_name>
  4639. <logical_name></logical_name>
  4640. <physical_name></physical_name>
  4641. <type>varchar(n)</type>
  4642. <constraint></constraint>
  4643. <default_value></default_value>
  4644. <auto_increment>false</auto_increment>
  4645. <foreign_key>false</foreign_key>
  4646. <not_null>true</not_null>
  4647. <primary_key>false</primary_key>
  4648. <unique_key>false</unique_key>
  4649. <character_set></character_set>
  4650. <collation></collation>
  4651. <sequence>
  4652. <name></name>
  4653. <schema></schema>
  4654. <increment></increment>
  4655. <min_value></min_value>
  4656. <max_value></max_value>
  4657. <start></start>
  4658. <cache></cache>
  4659. <nocache>false</nocache>
  4660. <cycle>false</cycle>
  4661. <order>false</order>
  4662. <description></description>
  4663. <data_type></data_type>
  4664. <decimal_size>0</decimal_size>
  4665. </sequence>
  4666. </normal_column>
  4667. <normal_column>
  4668. <word_id>26</word_id>
  4669. <id>8</id>
  4670. <description></description>
  4671. <unique_key_name></unique_key_name>
  4672. <logical_name></logical_name>
  4673. <physical_name></physical_name>
  4674. <type>nvarchar(n)</type>
  4675. <constraint></constraint>
  4676. <default_value></default_value>
  4677. <auto_increment>false</auto_increment>
  4678. <foreign_key>false</foreign_key>
  4679. <not_null>true</not_null>
  4680. <primary_key>false</primary_key>
  4681. <unique_key>false</unique_key>
  4682. <character_set></character_set>
  4683. <collation></collation>
  4684. <sequence>
  4685. <name></name>
  4686. <schema></schema>
  4687. <increment></increment>
  4688. <min_value></min_value>
  4689. <max_value></max_value>
  4690. <start></start>
  4691. <cache></cache>
  4692. <nocache>false</nocache>
  4693. <cycle>false</cycle>
  4694. <order>false</order>
  4695. <description></description>
  4696. <data_type></data_type>
  4697. <decimal_size>0</decimal_size>
  4698. </sequence>
  4699. </normal_column>
  4700. <normal_column>
  4701. <word_id>45</word_id>
  4702. <id>9</id>
  4703. <description></description>
  4704. <unique_key_name></unique_key_name>
  4705. <logical_name></logical_name>
  4706. <physical_name></physical_name>
  4707. <type>decimal(p,s)</type>
  4708. <constraint></constraint>
  4709. <default_value></default_value>
  4710. <auto_increment>false</auto_increment>
  4711. <foreign_key>false</foreign_key>
  4712. <not_null>true</not_null>
  4713. <primary_key>false</primary_key>
  4714. <unique_key>false</unique_key>
  4715. <character_set></character_set>
  4716. <collation></collation>
  4717. <sequence>
  4718. <name></name>
  4719. <schema></schema>
  4720. <increment></increment>
  4721. <min_value></min_value>
  4722. <max_value></max_value>
  4723. <start></start>
  4724. <cache></cache>
  4725. <nocache>false</nocache>
  4726. <cycle>false</cycle>
  4727. <order>false</order>
  4728. <description></description>
  4729. <data_type></data_type>
  4730. <decimal_size>0</decimal_size>
  4731. </sequence>
  4732. </normal_column>
  4733. </columns>
  4734. </column_group>
  4735. </column_groups>
  4736. <test_data_list>
  4737. </test_data_list>
  4738. <sequence_set>
  4739. <sequence>
  4740. <name>SEQ_sys_log_id</name>
  4741. <schema></schema>
  4742. <increment>1</increment>
  4743. <min_value></min_value>
  4744. <max_value></max_value>
  4745. <start>1</start>
  4746. <cache></cache>
  4747. <nocache>false</nocache>
  4748. <cycle>false</cycle>
  4749. <order>false</order>
  4750. <description></description>
  4751. <data_type></data_type>
  4752. <decimal_size>0</decimal_size>
  4753. </sequence>
  4754. </sequence_set>
  4755. <trigger_set>
  4756. <trigger>
  4757. <name>TRI_sys_log_id</name>
  4758. <schema></schema>
  4759. <sql>BEFORE INSERT ON sys_log&#x0D;&#x0A;FOR EACH ROW&#x0D;&#x0A;BEGIN&#x0D;&#x0A;&#x09;SELECT SEQ_sys_log_id.nextval&#x0D;&#x0A;&#x09;INTO :new.id&#x0D;&#x0A;&#x09;FROM dual;&#x0D;&#x0A;END</sql>
  4760. <description></description>
  4761. </trigger>
  4762. </trigger_set>
  4763. <change_tracking_list>
  4764. </change_tracking_list>
  4765. </diagram>