123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255325632573258325932603261326232633264326532663267326832693270327132723273327432753276327732783279328032813282328332843285328632873288328932903291329232933294329532963297329832993300330133023303330433053306330733083309331033113312331333143315331633173318331933203321332233233324332533263327332833293330333133323333333433353336333733383339334033413342334333443345334633473348334933503351335233533354335533563357335833593360336133623363336433653366336733683369337033713372337333743375337633773378337933803381338233833384338533863387 |
- <?xml version="1.0" encoding="UTF-8"?>
- <diagram>
- <page_setting>
- <direction_horizontal>true</direction_horizontal>
- <scale>100</scale>
- <paper_size>A4 210 x 297 mm</paper_size>
- <top_margin>30</top_margin>
- <left_margin>30</left_margin>
- <bottom_margin>30</bottom_margin>
- <right_margin>30</right_margin>
- </page_setting>
- <category_index>0</category_index>
- <zoom>1.0</zoom>
- <x>0</x>
- <y>0</y>
- <default_color>
- <r>128</r>
- <g>128</g>
- <b>192</b>
- </default_color>
- <color>
- <r>255</r>
- <g>255</g>
- <b>255</b>
- </color>
- <font_name>宋体</font_name>
- <font_size>9</font_size>
- <settings>
- <database>PostgreSQL</database>
- <capital>true</capital>
- <table_style></table_style>
- <notation></notation>
- <notation_level>0</notation_level>
- <notation_expand_group>true</notation_expand_group>
- <view_mode>2</view_mode>
- <outline_view_mode>1</outline_view_mode>
- <view_order_by>0</view_order_by>
- <auto_ime_change>false</auto_ime_change>
- <validate_physical_name>true</validate_physical_name>
- <use_bezier_curve>false</use_bezier_curve>
- <suspend_validator>false</suspend_validator>
- <export_setting>
- <export_ddl_setting>
- <output_path>dbscript\init\system.sql</output_path>
- <encoding>UTF-8</encoding>
- <line_feed>CR+LF</line_feed>
- <is_open_after_saved>true</is_open_after_saved>
- <environment_id>0</environment_id>
- <category_id>null</category_id>
- <ddl_target>
- <create_comment>true</create_comment>
- <create_foreignKey>true</create_foreignKey>
- <create_index>true</create_index>
- <create_sequence>true</create_sequence>
- <create_table>true</create_table>
- <create_tablespace>true</create_tablespace>
- <create_trigger>true</create_trigger>
- <create_view>true</create_view>
- <drop_index>true</drop_index>
- <drop_sequence>true</drop_sequence>
- <drop_table>true</drop_table>
- <drop_tablespace>true</drop_tablespace>
- <drop_trigger>true</drop_trigger>
- <drop_view>true</drop_view>
- <inline_column_comment>true</inline_column_comment>
- <inline_table_comment>true</inline_table_comment>
- <comment_value_description>false</comment_value_description>
- <comment_value_logical_name>false</comment_value_logical_name>
- <comment_value_logical_name_description>true</comment_value_logical_name_description>
- <comment_replace_line_feed>true</comment_replace_line_feed>
- <comment_replace_string></comment_replace_string>
- </ddl_target>
- </export_ddl_setting>
- <export_excel_setting>
- <category_id>null</category_id>
- <output_path>C:\Users\Administrator\Desktop\sys_base.xls</output_path>
- <template></template>
- <template_path></template_path>
- <used_default_template_lang>en</used_default_template_lang>
- <image_output></image_output>
- <is_open_after_saved>true</is_open_after_saved>
- <is_put_diagram>true</is_put_diagram>
- <is_use_logical_name>true</is_use_logical_name>
- </export_excel_setting>
- <export_html_setting>
- <output_dir></output_dir>
- <with_category_image>true</with_category_image>
- <with_image>true</with_image>
- <is_open_after_saved>true</is_open_after_saved>
- </export_html_setting>
- <export_image_setting>
- <output_file_path></output_file_path>
- <category_dir_path></category_dir_path>
- <with_category_image>true</with_category_image>
- <is_open_after_saved>true</is_open_after_saved>
- </export_image_setting>
- <export_java_setting>
- <java_output></java_output>
- <package_name></package_name>
- <class_name_suffix></class_name_suffix>
- <src_file_encoding></src_file_encoding>
- <with_hibernate>false</with_hibernate>
- </export_java_setting>
- <export_testdata_setting>
- <file_encoding></file_encoding>
- <file_path></file_path>
- <format>0</format>
- </export_testdata_setting>
- </export_setting>
- <category_settings>
- <free_layout>false</free_layout>
- <show_referred_tables>false</show_referred_tables>
- <categories>
- </categories>
- </category_settings>
- <translation_settings>
- <use>false</use>
- <translations>
- </translations>
- </translation_settings>
- <model_properties>
- <id></id>
- <height>-1</height>
- <width>-1</width>
- <font_name>Microsoft YaHei UI</font_name>
- <font_size>9</font_size>
- <x>50</x>
- <y>50</y>
- <color>
- <r>255</r>
- <g>255</g>
- <b>255</b>
- </color>
- <connections>
- </connections>
- <display>false</display>
- <creation_date>2013-09-03 10:59:01</creation_date>
- <updated_date>2018-08-29 15:15:43</updated_date>
- <model_property>
- <name>项目名称</name>
- <value></value>
- </model_property>
- <model_property>
- <name>型号名称</name>
- <value></value>
- </model_property>
- <model_property>
- <name>版本</name>
- <value></value>
- </model_property>
- <model_property>
- <name>公司名称</name>
- <value></value>
- </model_property>
- <model_property>
- <name>作者</name>
- <value></value>
- </model_property>
- </model_properties>
- <table_properties>
- <schema></schema>
- <without_oids>true</without_oids>
- </table_properties>
- <environment_setting>
- <environment>
- <id>0</id>
- <name>默认</name>
- </environment>
- </environment_setting>
- </settings>
- <dictionary>
- <word>
- <id>0</id>
- <length>64</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>渠道编号</description>
- <logical_name>渠道编号</logical_name>
- <physical_name>channelNo</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>1</id>
- <length>64</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>功能分类id</description>
- <logical_name>分类名称</logical_name>
- <physical_name>className</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>2</id>
- <length>64</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description></description>
- <logical_name>IP地址</logical_name>
- <physical_name>clientip</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>3</id>
- <length>1024</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>描述信息 : 描述信息</description>
- <logical_name>描述信息 : 描述信息</logical_name>
- <physical_name>code_desc</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>4</id>
- <length>64</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>编码ID</description>
- <logical_name>编码ID</logical_name>
- <physical_name>CODE_ID</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>5</id>
- <length>128</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>编码名称 : 编码名称</description>
- <logical_name>编码名称 : 编码名称</logical_name>
- <physical_name>code_name</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>6</id>
- <length>null</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>顺序号</description>
- <logical_name>顺序号</logical_name>
- <physical_name>code_order</physical_name>
- <type>integer</type>
- </word>
- <word>
- <id>7</id>
- <length>64</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>类型编码 : 类型编码</description>
- <logical_name>类型编码 : 类型编码</logical_name>
- <physical_name>code_type</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>8</id>
- <length>128</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>编 码 值 : 编 码 值</description>
- <logical_name>编 码 值 : 编 码 值</logical_name>
- <physical_name>code_value</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>9</id>
- <length>256</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>登录URI</description>
- <logical_name>登录URI</logical_name>
- <physical_name>context</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>10</id>
- <length>256</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>0</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description></description>
- <logical_name>地址</logical_name>
- <physical_name>deptaddr</physical_name>
- <type>varchar(n)</type>
- </word>
- <word>
- <id>11</id>
- <length>32</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>机构编码</description>
- <logical_name>机构编码</logical_name>
- <physical_name>deptcode</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>12</id>
- <length>64</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>0</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description></description>
- <logical_name>联系人</logical_name>
- <physical_name>deptconn</physical_name>
- <type>varchar(n)</type>
- </word>
- <word>
- <id>13</id>
- <length>128</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>0</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description></description>
- <logical_name>机构名称</logical_name>
- <physical_name>deptname</physical_name>
- <type>varchar(n)</type>
- </word>
- <word>
- <id>14</id>
- <length>64</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>0</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description></description>
- <logical_name>电话</logical_name>
- <physical_name>depttell</physical_name>
- <type>varchar(n)</type>
- </word>
- <word>
- <id>15</id>
- <length>8</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>1公证处,0运营</description>
- <logical_name>机构类型</logical_name>
- <physical_name>depttype</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>16</id>
- <length>256</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>是否是登陆后才能显示</description>
- <logical_name>登陆标识</logical_name>
- <physical_name>flag</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>17</id>
- <length>2048</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>功能列表</description>
- <logical_name>功能列表</logical_name>
- <physical_name>funcIds</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>18</id>
- <length>256</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>功能描述</description>
- <logical_name>功能描述</logical_name>
- <physical_name>functionDesc</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>19</id>
- <length>64</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>功能id</description>
- <logical_name>功能id</logical_name>
- <physical_name>functionId</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>20</id>
- <length>128</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>功能名称</description>
- <logical_name>功能名称</logical_name>
- <physical_name>functionName</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>21</id>
- <length>32</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>唯一ID</description>
- <logical_name>ID</logical_name>
- <physical_name>ID</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>22</id>
- <length>64</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>主键</description>
- <logical_name>记录流水</logical_name>
- <physical_name>ID</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>23</id>
- <length>null</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>是否成功(0成功,1失败)</description>
- <logical_name>是否成功</logical_name>
- <physical_name>loginType</physical_name>
- <type>integer</type>
- </word>
- <word>
- <id>24</id>
- <length>128</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>菜单描述</description>
- <logical_name>菜单描述</logical_name>
- <physical_name>menuDesc</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>25</id>
- <length>64</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>菜单id</description>
- <logical_name>菜单id</logical_name>
- <physical_name>menuId</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>26</id>
- <length>2048</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>多个菜单id用,号分割</description>
- <logical_name>菜单列表</logical_name>
- <physical_name>menuIds</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>27</id>
- <length>256</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>菜单图片</description>
- <logical_name>菜单图片</logical_name>
- <physical_name>menuImage</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>28</id>
- <length>18</length>
- <decimal>2</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>菜单索引</description>
- <logical_name>菜单索引</logical_name>
- <physical_name>menuindex</physical_name>
- <type>decimal(p,s)</type>
- </word>
- <word>
- <id>29</id>
- <length>128</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>菜单名称</description>
- <logical_name>菜单名称</logical_name>
- <physical_name>menuname</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>30</id>
- <length>64</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>菜单父ID</description>
- <logical_name>菜单父ID</logical_name>
- <physical_name>menupid</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>31</id>
- <length>256</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>菜单地址</description>
- <logical_name>菜单地址</logical_name>
- <physical_name>menuurl</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>32</id>
- <length>128</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>名称</description>
- <logical_name>名称</logical_name>
- <physical_name>NAME</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>33</id>
- <length>64</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>昵称</description>
- <logical_name>昵称</logical_name>
- <physical_name>nickName</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>34</id>
- <length>64</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>通讯时间</description>
- <logical_name>通讯时间</logical_name>
- <physical_name>occurtime</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>35</id>
- <length>64</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>所属机构</description>
- <logical_name>所属机构</logical_name>
- <physical_name>orgName</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>36</id>
- <length>null</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>其它信息</description>
- <logical_name>其它信息</logical_name>
- <physical_name>otherdesc</physical_name>
- <type>text</type>
- </word>
- <word>
- <id>37</id>
- <length>32</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>上级机构</description>
- <logical_name>上级机构</logical_name>
- <physical_name>parent</physical_name>
- <type>varchar(n)</type>
- </word>
- <word>
- <id>38</id>
- <length>2048</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>0</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>备注</description>
- <logical_name>备注</logical_name>
- <physical_name>remarks</physical_name>
- <type>varchar(n)</type>
- </word>
- <word>
- <id>39</id>
- <length>256</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>角色描述</description>
- <logical_name>角色描述</logical_name>
- <physical_name>roleDesc</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>40</id>
- <length>64</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>角色ID</description>
- <logical_name>角色ID</logical_name>
- <physical_name>roleId</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>41</id>
- <length>null</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>角色ID列表</description>
- <logical_name>角色ID列表</logical_name>
- <physical_name>roleIds</physical_name>
- <type>text</type>
- </word>
- <word>
- <id>42</id>
- <length>64</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description></description>
- <logical_name>服务器IP</logical_name>
- <physical_name>serverip</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>43</id>
- <length>64</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>用户样式</description>
- <logical_name>用户样式</logical_name>
- <physical_name>styleName</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>44</id>
- <length>32</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>系统ID</description>
- <logical_name>系统ID</logical_name>
- <physical_name>SYSID</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>45</id>
- <length>256</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>描述</description>
- <logical_name>描述</logical_name>
- <physical_name>userDesc</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>46</id>
- <length>null</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>用户DN</description>
- <logical_name>用户DN</logical_name>
- <physical_name>userdn</physical_name>
- <type>text</type>
- </word>
- <word>
- <id>47</id>
- <length>null</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>需要证书</description>
- <logical_name>需要证书</logical_name>
- <physical_name>userdnflag</physical_name>
- <type>integer</type>
- </word>
- <word>
- <id>48</id>
- <length>128</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>邮箱</description>
- <logical_name>邮箱</logical_name>
- <physical_name>userEmail</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>49</id>
- <length>64</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description></description>
- <logical_name>人员ID</logical_name>
- <physical_name>userId</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>50</id>
- <length>64</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>用户编码</description>
- <logical_name>用户编码</logical_name>
- <physical_name>userId</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>51</id>
- <length>11</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>0</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description></description>
- <logical_name>手机</logical_name>
- <physical_name>userMobNub</physical_name>
- <type>varchar(n)</type>
- </word>
- <word>
- <id>52</id>
- <length>128</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>人员名称</description>
- <logical_name>人员名称</logical_name>
- <physical_name>userName</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>53</id>
- <length>1024</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>登录密码</description>
- <logical_name>登录密码</logical_name>
- <physical_name>userPwd</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>54</id>
- <length>2</length>
- <decimal>0</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>0,表示男1,表示女</description>
- <logical_name>人员性别</logical_name>
- <physical_name>userSex</physical_name>
- <type>decimal(p,s)</type>
- </word>
- <word>
- <id>55</id>
- <length>null</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>用户状态</description>
- <logical_name>用户状态</logical_name>
- <physical_name>userState</physical_name>
- <type>integer</type>
- </word>
- <word>
- <id>56</id>
- <length>128</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>电话</description>
- <logical_name>电话</logical_name>
- <physical_name>userTelNum</physical_name>
- <type>nvarchar(n)</type>
- </word>
- <word>
- <id>57</id>
- <length>null</length>
- <decimal>null</decimal>
- <array>false</array>
- <array_dimension>null</array_dimension>
- <unsigned>false</unsigned>
- <zerofill>false</zerofill>
- <binary>false</binary>
- <args></args>
- <char_semantics>false</char_semantics>
- <description>用户类型</description>
- <logical_name>用户类型</logical_name>
- <physical_name>userType</physical_name>
- <type>integer</type>
- </word>
- </dictionary>
- <tablespace_set>
- </tablespace_set>
- <contents>
- <table>
- <id>0</id>
- <height>116</height>
- <width>308</width>
- <font_name>宋体</font_name>
- <font_size>9</font_size>
- <x>425</x>
- <y>12</y>
- <color>
- <r>128</r>
- <g>128</g>
- <b>192</b>
- </color>
- <connections>
- </connections>
- <physical_name>SYS_FUNCTION</physical_name>
- <logical_name>功能信息表</logical_name>
- <description>功能信息表</description>
- <constraint></constraint>
- <primary_key_name></primary_key_name>
- <option></option>
- <columns>
- <normal_column>
- <word_id>19</word_id>
- <id>0</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>true</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>1</word_id>
- <id>1</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>20</word_id>
- <id>2</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>18</word_id>
- <id>3</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- </columns>
- <indexes>
- </indexes>
- <complex_unique_key_list>
- </complex_unique_key_list>
- <table_properties>
- <schema></schema>
- <without_oids>true</without_oids>
- </table_properties>
- </table>
- <table>
- <id>1</id>
- <height>206</height>
- <width>332</width>
- <font_name>Microsoft YaHei UI</font_name>
- <font_size>9</font_size>
- <x>51</x>
- <y>312</y>
- <color>
- <r>128</r>
- <g>128</g>
- <b>192</b>
- </color>
- <connections>
- </connections>
- <physical_name>sys_login</physical_name>
- <logical_name>登录日志</logical_name>
- <description>登录日志</description>
- <constraint></constraint>
- <primary_key_name></primary_key_name>
- <option></option>
- <columns>
- <normal_column>
- <word_id>22</word_id>
- <id>4</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>true</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>0</word_id>
- <id>5</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>23</word_id>
- <id>6</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>integer</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>50</word_id>
- <id>7</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>2</word_id>
- <id>8</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>42</word_id>
- <id>9</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>9</word_id>
- <id>10</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>34</word_id>
- <id>11</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>36</word_id>
- <id>12</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>text</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- </columns>
- <indexes>
- <inidex>
- <full_text>false</full_text>
- <non_unique>true</non_unique>
- <name>sys_login_index</name>
- <type></type>
- <description>登录信息索引</description>
- <columns>
- <column>
- <id>7</id>
- <desc>false</desc>
- </column>
- <column>
- <id>11</id>
- <desc>false</desc>
- </column>
- </columns>
- </inidex>
- </indexes>
- <complex_unique_key_list>
- </complex_unique_key_list>
- <table_properties>
- <schema></schema>
- <without_oids>true</without_oids>
- </table_properties>
- </table>
- <table>
- <id>2</id>
- <height>188</height>
- <width>308</width>
- <font_name>宋体</font_name>
- <font_size>9</font_size>
- <x>425</x>
- <y>146</y>
- <color>
- <r>128</r>
- <g>128</g>
- <b>192</b>
- </color>
- <connections>
- </connections>
- <physical_name>SYS_MENU</physical_name>
- <logical_name>菜单信息表</logical_name>
- <description>菜单信息表</description>
- <constraint></constraint>
- <primary_key_name></primary_key_name>
- <option></option>
- <columns>
- <normal_column>
- <word_id>25</word_id>
- <id>13</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>true</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>30</word_id>
- <id>14</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>29</word_id>
- <id>15</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>24</word_id>
- <id>16</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>31</word_id>
- <id>17</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>27</word_id>
- <id>18</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>16</word_id>
- <id>19</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>28</word_id>
- <id>20</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>decimal(p,s)</type>
- <constraint></constraint>
- <default_value>0</default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- </columns>
- <indexes>
- <inidex>
- <full_text>false</full_text>
- <non_unique>true</non_unique>
- <name>SYS_MENU_INDEX</name>
- <type>BTREE</type>
- <description>菜单索引</description>
- <columns>
- <column>
- <id>14</id>
- <desc>false</desc>
- </column>
- <column>
- <id>13</id>
- <desc>false</desc>
- </column>
- <column>
- <id>15</id>
- <desc>false</desc>
- </column>
- <column>
- <id>19</id>
- <desc>false</desc>
- </column>
- </columns>
- </inidex>
- </indexes>
- <complex_unique_key_list>
- </complex_unique_key_list>
- <table_properties>
- <schema></schema>
- <without_oids>true</without_oids>
- </table_properties>
- </table>
- <table>
- <id>3</id>
- <height>348</height>
- <width>313</width>
- <font_name>Tahoma</font_name>
- <font_size>9</font_size>
- <x>792</x>
- <y>170</y>
- <color>
- <r>128</r>
- <g>128</g>
- <b>192</b>
- </color>
- <connections>
- </connections>
- <physical_name>SYS_USER</physical_name>
- <logical_name>用户表</logical_name>
- <description>用户表</description>
- <constraint></constraint>
- <primary_key_name></primary_key_name>
- <option></option>
- <columns>
- <normal_column>
- <word_id>49</word_id>
- <id>21</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>true</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>57</word_id>
- <id>22</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>integer</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>35</word_id>
- <id>23</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>55</word_id>
- <id>24</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>integer</type>
- <constraint></constraint>
- <default_value>0</default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>53</word_id>
- <id>25</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>52</word_id>
- <id>26</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>46</word_id>
- <id>27</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>text</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>47</word_id>
- <id>28</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>integer</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>33</word_id>
- <id>29</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>54</word_id>
- <id>30</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>decimal(p,s)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>48</word_id>
- <id>31</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>56</word_id>
- <id>32</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>51</word_id>
- <id>33</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>varchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>41</word_id>
- <id>34</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>text</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>43</word_id>
- <id>35</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>45</word_id>
- <id>36</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- </columns>
- <indexes>
- <inidex>
- <full_text>false</full_text>
- <non_unique>true</non_unique>
- <name>sys_user_index</name>
- <type>BTREE</type>
- <description>用户表索引</description>
- <columns>
- <column>
- <id>22</id>
- <desc>false</desc>
- </column>
- <column>
- <id>26</id>
- <desc>false</desc>
- </column>
- <column>
- <id>25</id>
- <desc>false</desc>
- </column>
- <column>
- <id>29</id>
- <desc>false</desc>
- </column>
- </columns>
- </inidex>
- </indexes>
- <complex_unique_key_list>
- </complex_unique_key_list>
- <table_properties>
- <schema></schema>
- <without_oids>true</without_oids>
- </table_properties>
- </table>
- <table>
- <id>4</id>
- <height>170</height>
- <width>313</width>
- <font_name>Microsoft YaHei UI</font_name>
- <font_size>9</font_size>
- <x>425</x>
- <y>348</y>
- <color>
- <r>128</r>
- <g>128</g>
- <b>192</b>
- </color>
- <connections>
- </connections>
- <physical_name>sys_appcode</physical_name>
- <logical_name>标准数据类型</logical_name>
- <description>标准数据类型</description>
- <constraint></constraint>
- <primary_key_name></primary_key_name>
- <option></option>
- <columns>
- <normal_column>
- <word_id>4</word_id>
- <id>37</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>true</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>44</word_id>
- <id>38</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>7</word_id>
- <id>39</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>5</word_id>
- <id>40</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>8</word_id>
- <id>41</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>3</word_id>
- <id>42</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>6</word_id>
- <id>43</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>integer</type>
- <constraint></constraint>
- <default_value>0</default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- </columns>
- <indexes>
- <inidex>
- <full_text>false</full_text>
- <non_unique>true</non_unique>
- <name>sys_appcode_index</name>
- <type></type>
- <description>标准数据索引</description>
- <columns>
- <column>
- <id>38</id>
- <desc>false</desc>
- </column>
- <column>
- <id>39</id>
- <desc>false</desc>
- </column>
- <column>
- <id>41</id>
- <desc>false</desc>
- </column>
- </columns>
- </inidex>
- </indexes>
- <complex_unique_key_list>
- </complex_unique_key_list>
- <table_properties>
- <schema></schema>
- <without_oids>false</without_oids>
- </table_properties>
- </table>
- <table>
- <id>5</id>
- <height>135</height>
- <width>313</width>
- <font_name>宋体</font_name>
- <font_size>9</font_size>
- <x>792</x>
- <y>12</y>
- <color>
- <r>128</r>
- <g>128</g>
- <b>192</b>
- </color>
- <connections>
- </connections>
- <physical_name>SYS_ROLE</physical_name>
- <logical_name>角色信息表</logical_name>
- <description>角色信息表</description>
- <constraint></constraint>
- <primary_key_name></primary_key_name>
- <option></option>
- <columns>
- <normal_column>
- <word_id>40</word_id>
- <id>44</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>true</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>32</word_id>
- <id>45</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>17</word_id>
- <id>46</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>26</word_id>
- <id>47</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>39</word_id>
- <id>48</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- </columns>
- <indexes>
- <inidex>
- <full_text>false</full_text>
- <non_unique>true</non_unique>
- <name>SYS_ROLE_INDEX</name>
- <type>BTREE</type>
- <description>角色索引</description>
- <columns>
- <column>
- <id>44</id>
- <desc>false</desc>
- </column>
- <column>
- <id>46</id>
- <desc>false</desc>
- </column>
- <column>
- <id>47</id>
- <desc>false</desc>
- </column>
- </columns>
- </inidex>
- </indexes>
- <complex_unique_key_list>
- </complex_unique_key_list>
- <table_properties>
- <schema></schema>
- <without_oids>true</without_oids>
- </table_properties>
- </table>
- <table>
- <id>6</id>
- <height>206</height>
- <width>313</width>
- <font_name>微软雅黑</font_name>
- <font_size>9</font_size>
- <x>60</x>
- <y>12</y>
- <color>
- <r>128</r>
- <g>128</g>
- <b>192</b>
- </color>
- <connections>
- </connections>
- <physical_name>SYS_DEPARTMENT</physical_name>
- <logical_name>机构表</logical_name>
- <description>机构表</description>
- <constraint></constraint>
- <primary_key_name></primary_key_name>
- <option></option>
- <columns>
- <normal_column>
- <word_id>21</word_id>
- <id>49</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>true</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>11</word_id>
- <id>50</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>false</primary_key>
- <unique_key>true</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>13</word_id>
- <id>51</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>varchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>37</word_id>
- <id>52</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>varchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>15</word_id>
- <id>53</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>nvarchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>12</word_id>
- <id>54</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>varchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>10</word_id>
- <id>55</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>varchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>14</word_id>
- <id>56</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>varchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>true</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- <normal_column>
- <word_id>38</word_id>
- <id>57</id>
- <description></description>
- <unique_key_name></unique_key_name>
- <logical_name></logical_name>
- <physical_name></physical_name>
- <type>varchar(n)</type>
- <constraint></constraint>
- <default_value></default_value>
- <auto_increment>false</auto_increment>
- <foreign_key>false</foreign_key>
- <not_null>false</not_null>
- <primary_key>false</primary_key>
- <unique_key>false</unique_key>
- <character_set></character_set>
- <collation></collation>
- <sequence>
- <name></name>
- <schema></schema>
- <increment></increment>
- <min_value></min_value>
- <max_value></max_value>
- <start></start>
- <cache></cache>
- <nocache>false</nocache>
- <cycle>false</cycle>
- <order>false</order>
- <description></description>
- <data_type></data_type>
- <decimal_size>0</decimal_size>
- </sequence>
- </normal_column>
- </columns>
- <indexes>
- <inidex>
- <full_text>false</full_text>
- <non_unique>false</non_unique>
- <name>SYS_DEPARTMENT_INDEX</name>
- <type>BTREE</type>
- <description>机构索引</description>
- <columns>
- <column>
- <id>50</id>
- <desc>false</desc>
- </column>
- <column>
- <id>51</id>
- <desc>false</desc>
- </column>
- <column>
- <id>52</id>
- <desc>false</desc>
- </column>
- <column>
- <id>53</id>
- <desc>false</desc>
- </column>
- </columns>
- </inidex>
- </indexes>
- <complex_unique_key_list>
- </complex_unique_key_list>
- <table_properties>
- <schema></schema>
- <without_oids>true</without_oids>
- </table_properties>
- </table>
- </contents>
- <column_groups>
- </column_groups>
- <test_data_list>
- </test_data_list>
- <sequence_set>
- </sequence_set>
- <trigger_set>
- </trigger_set>
- <change_tracking_list>
- </change_tracking_list>
- </diagram>
|