jeesite.erm 67 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <diagram>
  3. <dbsetting>
  4. <dbsystem>MySQL</dbsystem>
  5. <server>localhost</server>
  6. <port>3306</port>
  7. <database>jeesite</database>
  8. <user>root</user>
  9. <password>123456</password>
  10. <use_default_driver>true</use_default_driver>
  11. <url>jdbc:mysql://localhost:3306/jeesite</url>
  12. <driver_class_name>com.mysql.jdbc.Driver</driver_class_name>
  13. </dbsetting>
  14. <page_setting>
  15. <direction_horizontal>true</direction_horizontal>
  16. <scale>100</scale>
  17. <paper_size>A4 210 x 297 mm</paper_size>
  18. <top_margin>30</top_margin>
  19. <left_margin>30</left_margin>
  20. <bottom_margin>30</bottom_margin>
  21. <right_margin>30</right_margin>
  22. </page_setting>
  23. <category_index>0</category_index>
  24. <zoom>1.0</zoom>
  25. <x>0</x>
  26. <y>21</y>
  27. <default_color>
  28. <r>128</r>
  29. <g>128</g>
  30. <b>192</b>
  31. </default_color>
  32. <color>
  33. <r>255</r>
  34. <g>255</g>
  35. <b>255</b>
  36. </color>
  37. <font_name></font_name>
  38. <font_size>9</font_size>
  39. <settings>
  40. <database>Oracle</database>
  41. <capital>false</capital>
  42. <table_style></table_style>
  43. <notation>IE</notation>
  44. <notation_level>0</notation_level>
  45. <notation_expand_group>true</notation_expand_group>
  46. <view_mode>2</view_mode>
  47. <outline_view_mode>2</outline_view_mode>
  48. <view_order_by>1</view_order_by>
  49. <auto_ime_change>false</auto_ime_change>
  50. <validate_physical_name>true</validate_physical_name>
  51. <use_bezier_curve>false</use_bezier_curve>
  52. <suspend_validator>false</suspend_validator>
  53. <export_setting>
  54. <category_name_to_export>All</category_name_to_export>
  55. <ddl_output>D:\GitHub\jeesite\db\gen\jeesite_oracle.sql</ddl_output>
  56. <excel_output>D:\GitHub\jeesite\jeesite\db\gen\jeesite-gen.xls</excel_output>
  57. <excel_template>Default(English)</excel_template>
  58. <image_output>D:\GitHub\jeesite\jeesite\db\gen\jeesite-gen.png</image_output>
  59. <put_diagram_on_excel>false</put_diagram_on_excel>
  60. <use_logical_name_as_sheet>false</use_logical_name_as_sheet>
  61. <open_after_saved>false</open_after_saved>
  62. <create_comment>true</create_comment>
  63. <create_foreignKey>false</create_foreignKey>
  64. <create_index>true</create_index>
  65. <create_sequence>true</create_sequence>
  66. <create_table>true</create_table>
  67. <create_tablespace>false</create_tablespace>
  68. <create_trigger>false</create_trigger>
  69. <create_view>true</create_view>
  70. <drop_index>false</drop_index>
  71. <drop_sequence>false</drop_sequence>
  72. <drop_table>true</drop_table>
  73. <drop_tablespace>false</drop_tablespace>
  74. <drop_trigger>false</drop_trigger>
  75. <drop_view>true</drop_view>
  76. <inline_column_comment>false</inline_column_comment>
  77. <inline_table_comment>false</inline_table_comment>
  78. <comment_value_description>true</comment_value_description>
  79. <comment_value_logical_name>false</comment_value_logical_name>
  80. <comment_value_logical_name_description>false</comment_value_logical_name_description>
  81. <comment_replace_line_feed>false</comment_replace_line_feed>
  82. <comment_replace_string></comment_replace_string>
  83. <export_java_setting>
  84. <java_output>D:\GitHub\jeesite\db\gen</java_output>
  85. <package_name></package_name>
  86. <class_name_suffix></class_name_suffix>
  87. <src_file_encoding>UTF-8</src_file_encoding>
  88. <with_hibernate>false</with_hibernate>
  89. </export_java_setting>
  90. <export_testdata_setting>
  91. <file_encoding></file_encoding>
  92. <file_path></file_path>
  93. <format>0</format>
  94. </export_testdata_setting>
  95. </export_setting>
  96. <category_settings>
  97. <free_layout>false</free_layout>
  98. <show_referred_tables>true</show_referred_tables>
  99. <categories>
  100. </categories>
  101. </category_settings>
  102. <translation_settings>
  103. <use>false</use>
  104. <translations>
  105. </translations>
  106. </translation_settings>
  107. <model_properties>
  108. <id></id>
  109. <height>-1</height>
  110. <width>-1</width>
  111. <font_name>Microsoft YaHei UI</font_name>
  112. <font_size>9</font_size>
  113. <x>47</x>
  114. <y>298</y>
  115. <color>
  116. <r>255</r>
  117. <g>255</g>
  118. <b>255</b>
  119. </color>
  120. <connections>
  121. </connections>
  122. <display>false</display>
  123. <creation_date>2013-04-23 21:13:37</creation_date>
  124. <updated_date>2014-04-08 10:48:46</updated_date>
  125. <model_property>
  126. <name>Project Name</name>
  127. <value>JeeSite</value>
  128. </model_property>
  129. <model_property>
  130. <name>Model Name</name>
  131. <value>SYS、CMS</value>
  132. </model_property>
  133. <model_property>
  134. <name>Version</name>
  135. <value>V1.0</value>
  136. </model_property>
  137. <model_property>
  138. <name>Compnay</name>
  139. <value>ThinkGem</value>
  140. </model_property>
  141. <model_property>
  142. <name>Author</name>
  143. <value>ThinkGem</value>
  144. </model_property>
  145. </model_properties>
  146. <table_properties>
  147. <schema></schema>
  148. </table_properties>
  149. <environment_setting>
  150. <environment>
  151. <id>0</id>
  152. <name>Default</name>
  153. </environment>
  154. </environment_setting>
  155. </settings>
  156. <dictionary>
  157. <word>
  158. <id>0</id>
  159. <length>2000</length>
  160. <decimal>null</decimal>
  161. <array>false</array>
  162. <array_dimension>null</array_dimension>
  163. <unsigned>false</unsigned>
  164. <args></args>
  165. <description>分类</description>
  166. <logical_name>分类</logical_name>
  167. <physical_name>category</physical_name>
  168. <type>varchar(n)</type>
  169. </word>
  170. <word>
  171. <id>1</id>
  172. <length>100</length>
  173. <decimal>null</decimal>
  174. <array>false</array>
  175. <array_dimension>null</array_dimension>
  176. <unsigned>false</unsigned>
  177. <args></args>
  178. <description>实体类名称</description>
  179. <logical_name>实体类名称</logical_name>
  180. <physical_name>class_name</physical_name>
  181. <type>varchar(n)</type>
  182. </word>
  183. <word>
  184. <id>2</id>
  185. <length>500</length>
  186. <decimal>null</decimal>
  187. <array>false</array>
  188. <array_dimension>null</array_dimension>
  189. <unsigned>false</unsigned>
  190. <args></args>
  191. <description>描述</description>
  192. <logical_name>描述</logical_name>
  193. <physical_name>comments</physical_name>
  194. <type>nvarchar(n)</type>
  195. </word>
  196. <word>
  197. <id>3</id>
  198. <length>null</length>
  199. <decimal>null</decimal>
  200. <array>false</array>
  201. <array_dimension>null</array_dimension>
  202. <unsigned>false</unsigned>
  203. <args></args>
  204. <description>内容</description>
  205. <logical_name>内容</logical_name>
  206. <physical_name>content</physical_name>
  207. <type>text</type>
  208. </word>
  209. <word>
  210. <id>4</id>
  211. <length>64</length>
  212. <decimal>null</decimal>
  213. <array>false</array>
  214. <array_dimension>null</array_dimension>
  215. <unsigned>false</unsigned>
  216. <args></args>
  217. <description>创建者</description>
  218. <logical_name>创建者</logical_name>
  219. <physical_name>create_by</physical_name>
  220. <type>varchar(n)</type>
  221. </word>
  222. <word>
  223. <id>5</id>
  224. <length>null</length>
  225. <decimal>null</decimal>
  226. <array>false</array>
  227. <array_dimension>null</array_dimension>
  228. <unsigned>false</unsigned>
  229. <args></args>
  230. <description>创建时间</description>
  231. <logical_name>创建时间</logical_name>
  232. <physical_name>create_date</physical_name>
  233. <type>datetime</type>
  234. </word>
  235. <word>
  236. <id>6</id>
  237. <length>1</length>
  238. <decimal>null</decimal>
  239. <array>false</array>
  240. <array_dimension>null</array_dimension>
  241. <unsigned>false</unsigned>
  242. <args></args>
  243. <description>删除标记(0:正常;1:删除)</description>
  244. <logical_name>删除标记</logical_name>
  245. <physical_name>del_flag</physical_name>
  246. <type>character(n)</type>
  247. </word>
  248. <word>
  249. <id>7</id>
  250. <length>200</length>
  251. <decimal>null</decimal>
  252. <array>false</array>
  253. <array_dimension>null</array_dimension>
  254. <unsigned>false</unsigned>
  255. <args></args>
  256. <description>字典类型</description>
  257. <logical_name>字典类型</logical_name>
  258. <physical_name>dict_type</physical_name>
  259. <type>varchar(n)</type>
  260. </word>
  261. <word>
  262. <id>8</id>
  263. <length>200</length>
  264. <decimal>null</decimal>
  265. <array>false</array>
  266. <array_dimension>null</array_dimension>
  267. <unsigned>false</unsigned>
  268. <args></args>
  269. <description>生成文件名</description>
  270. <logical_name>生成文件名</logical_name>
  271. <physical_name>file_name</physical_name>
  272. <type>varchar(n)</type>
  273. </word>
  274. <word>
  275. <id>9</id>
  276. <length>500</length>
  277. <decimal>null</decimal>
  278. <array>false</array>
  279. <array_dimension>null</array_dimension>
  280. <unsigned>false</unsigned>
  281. <args></args>
  282. <description>生成文件路径</description>
  283. <logical_name>生成文件路径</logical_name>
  284. <physical_name>file_path</physical_name>
  285. <type>varchar(n)</type>
  286. </word>
  287. <word>
  288. <id>10</id>
  289. <length>100</length>
  290. <decimal>null</decimal>
  291. <array>false</array>
  292. <array_dimension>null</array_dimension>
  293. <unsigned>false</unsigned>
  294. <args></args>
  295. <description>生成功能作者</description>
  296. <logical_name>生成功能作者</logical_name>
  297. <physical_name>function_author</physical_name>
  298. <type>nvarchar(n)</type>
  299. </word>
  300. <word>
  301. <id>11</id>
  302. <length>500</length>
  303. <decimal>null</decimal>
  304. <array>false</array>
  305. <array_dimension>null</array_dimension>
  306. <unsigned>false</unsigned>
  307. <args></args>
  308. <description>生成功能名</description>
  309. <logical_name>生成功能名</logical_name>
  310. <physical_name>function_name</physical_name>
  311. <type>nvarchar(n)</type>
  312. </word>
  313. <word>
  314. <id>12</id>
  315. <length>100</length>
  316. <decimal>null</decimal>
  317. <array>false</array>
  318. <array_dimension>null</array_dimension>
  319. <unsigned>false</unsigned>
  320. <args></args>
  321. <description>生成功能名(简写)</description>
  322. <logical_name>生成功能名(简写)</logical_name>
  323. <physical_name>function_name_simple</physical_name>
  324. <type>nvarchar(n)</type>
  325. </word>
  326. <word>
  327. <id>13</id>
  328. <length>200</length>
  329. <decimal>null</decimal>
  330. <array>false</array>
  331. <array_dimension>null</array_dimension>
  332. <unsigned>false</unsigned>
  333. <args></args>
  334. <description>生成表编号</description>
  335. <logical_name>生成表编号</logical_name>
  336. <physical_name>gen_table_id</physical_name>
  337. <type>varchar(n)</type>
  338. </word>
  339. <word>
  340. <id>14</id>
  341. <length>64</length>
  342. <decimal>null</decimal>
  343. <array>false</array>
  344. <array_dimension>null</array_dimension>
  345. <unsigned>false</unsigned>
  346. <args></args>
  347. <description>编号</description>
  348. <logical_name>编号</logical_name>
  349. <physical_name>id</physical_name>
  350. <type>varchar(n)</type>
  351. </word>
  352. <word>
  353. <id>15</id>
  354. <length>1</length>
  355. <decimal>null</decimal>
  356. <array>false</array>
  357. <array_dimension>null</array_dimension>
  358. <unsigned>false</unsigned>
  359. <args></args>
  360. <description>是否编辑字段</description>
  361. <logical_name>是否编辑字段</logical_name>
  362. <physical_name>is_edit</physical_name>
  363. <type>character(n)</type>
  364. </word>
  365. <word>
  366. <id>16</id>
  367. <length>1</length>
  368. <decimal>null</decimal>
  369. <array>false</array>
  370. <array_dimension>null</array_dimension>
  371. <unsigned>false</unsigned>
  372. <args></args>
  373. <description>是否为插入字段</description>
  374. <logical_name>是否为插入字段</logical_name>
  375. <physical_name>is_insert</physical_name>
  376. <type>character(n)</type>
  377. </word>
  378. <word>
  379. <id>17</id>
  380. <length>1</length>
  381. <decimal>null</decimal>
  382. <array>false</array>
  383. <array_dimension>null</array_dimension>
  384. <unsigned>false</unsigned>
  385. <args></args>
  386. <description>是否列表字段</description>
  387. <logical_name>是否列表字段</logical_name>
  388. <physical_name>is_list</physical_name>
  389. <type>character(n)</type>
  390. </word>
  391. <word>
  392. <id>18</id>
  393. <length>1</length>
  394. <decimal>null</decimal>
  395. <array>false</array>
  396. <array_dimension>null</array_dimension>
  397. <unsigned>false</unsigned>
  398. <args></args>
  399. <description>是否可为空</description>
  400. <logical_name>是否可为空</logical_name>
  401. <physical_name>is_null</physical_name>
  402. <type>character(n)</type>
  403. </word>
  404. <word>
  405. <id>19</id>
  406. <length>1</length>
  407. <decimal>null</decimal>
  408. <array>false</array>
  409. <array_dimension>null</array_dimension>
  410. <unsigned>false</unsigned>
  411. <args></args>
  412. <description>是否主键</description>
  413. <logical_name>是否主键</logical_name>
  414. <physical_name>is_pk</physical_name>
  415. <type>character(n)</type>
  416. </word>
  417. <word>
  418. <id>20</id>
  419. <length>1</length>
  420. <decimal>null</decimal>
  421. <array>false</array>
  422. <array_dimension>null</array_dimension>
  423. <unsigned>false</unsigned>
  424. <args></args>
  425. <description>是否查询字段</description>
  426. <logical_name>是否查询字段</logical_name>
  427. <physical_name>is_query</physical_name>
  428. <type>character(n)</type>
  429. </word>
  430. <word>
  431. <id>21</id>
  432. <length>200</length>
  433. <decimal>null</decimal>
  434. <array>false</array>
  435. <array_dimension>null</array_dimension>
  436. <unsigned>false</unsigned>
  437. <args></args>
  438. <description>JAVA字段名</description>
  439. <logical_name>JAVA字段名</logical_name>
  440. <physical_name>java_field</physical_name>
  441. <type>varchar(n)</type>
  442. </word>
  443. <word>
  444. <id>22</id>
  445. <length>500</length>
  446. <decimal>null</decimal>
  447. <array>false</array>
  448. <array_dimension>null</array_dimension>
  449. <unsigned>false</unsigned>
  450. <args></args>
  451. <description>JAVA类型</description>
  452. <logical_name>JAVA类型</logical_name>
  453. <physical_name>java_type</physical_name>
  454. <type>varchar(n)</type>
  455. </word>
  456. <word>
  457. <id>23</id>
  458. <length>100</length>
  459. <decimal>null</decimal>
  460. <array>false</array>
  461. <array_dimension>null</array_dimension>
  462. <unsigned>false</unsigned>
  463. <args></args>
  464. <description>列的数据类型的字节长度</description>
  465. <logical_name>JDBC类型</logical_name>
  466. <physical_name>jdbc_type</physical_name>
  467. <type>varchar(n)</type>
  468. </word>
  469. <word>
  470. <id>24</id>
  471. <length>30</length>
  472. <decimal>null</decimal>
  473. <array>false</array>
  474. <array_dimension>null</array_dimension>
  475. <unsigned>false</unsigned>
  476. <args></args>
  477. <description>生成模块名</description>
  478. <logical_name>生成模块名</logical_name>
  479. <physical_name>module_name</physical_name>
  480. <type>varchar(n)</type>
  481. </word>
  482. <word>
  483. <id>25</id>
  484. <length>200</length>
  485. <decimal>null</decimal>
  486. <array>false</array>
  487. <array_dimension>null</array_dimension>
  488. <unsigned>false</unsigned>
  489. <args></args>
  490. <description>名称</description>
  491. <logical_name>名称</logical_name>
  492. <physical_name>name</physical_name>
  493. <type>nvarchar(n)</type>
  494. </word>
  495. <word>
  496. <id>26</id>
  497. <length>500</length>
  498. <decimal>null</decimal>
  499. <array>false</array>
  500. <array_dimension>null</array_dimension>
  501. <unsigned>false</unsigned>
  502. <args></args>
  503. <description>生成包路径</description>
  504. <logical_name>生成包路径</logical_name>
  505. <physical_name>package_name</physical_name>
  506. <type>varchar(n)</type>
  507. </word>
  508. <word>
  509. <id>27</id>
  510. <length>200</length>
  511. <decimal>null</decimal>
  512. <array>false</array>
  513. <array_dimension>null</array_dimension>
  514. <unsigned>false</unsigned>
  515. <args></args>
  516. <description>关联父表</description>
  517. <logical_name>关联父表</logical_name>
  518. <physical_name>parent_table</physical_name>
  519. <type>varchar(n)</type>
  520. </word>
  521. <word>
  522. <id>28</id>
  523. <length>100</length>
  524. <decimal>null</decimal>
  525. <array>false</array>
  526. <array_dimension>null</array_dimension>
  527. <unsigned>false</unsigned>
  528. <args></args>
  529. <description>关联父表外键</description>
  530. <logical_name>关联父表外键</logical_name>
  531. <physical_name>parent_table_fk</physical_name>
  532. <type>varchar(n)</type>
  533. </word>
  534. <word>
  535. <id>29</id>
  536. <length>200</length>
  537. <decimal>null</decimal>
  538. <array>false</array>
  539. <array_dimension>null</array_dimension>
  540. <unsigned>false</unsigned>
  541. <args></args>
  542. <description>查询方式(等于、不等于、大于、小于、范围、左LIKE、右LIKE、左右LIKE)</description>
  543. <logical_name>查询方式</logical_name>
  544. <physical_name>query_type</physical_name>
  545. <type>varchar(n)</type>
  546. </word>
  547. <word>
  548. <id>30</id>
  549. <length>255</length>
  550. <decimal>null</decimal>
  551. <array>false</array>
  552. <array_dimension>null</array_dimension>
  553. <unsigned>false</unsigned>
  554. <args></args>
  555. <description>备注信息</description>
  556. <logical_name>备注信息</logical_name>
  557. <physical_name>remarks</physical_name>
  558. <type>nvarchar(n)</type>
  559. </word>
  560. <word>
  561. <id>31</id>
  562. <length>2000</length>
  563. <decimal>null</decimal>
  564. <array>false</array>
  565. <array_dimension>null</array_dimension>
  566. <unsigned>false</unsigned>
  567. <args></args>
  568. <description>其它设置(扩展字段JSON)</description>
  569. <logical_name>其它设置</logical_name>
  570. <physical_name>settings</physical_name>
  571. <type>nvarchar(n)</type>
  572. </word>
  573. <word>
  574. <id>32</id>
  575. <length>200</length>
  576. <decimal>null</decimal>
  577. <array>false</array>
  578. <array_dimension>null</array_dimension>
  579. <unsigned>false</unsigned>
  580. <args></args>
  581. <description>字段生成方案(文本框、文本域、下拉框、复选框、单选框、字典选择、人员选择、部门选择、区域选择)</description>
  582. <logical_name>显示类型</logical_name>
  583. <physical_name>show_type</physical_name>
  584. <type>varchar(n)</type>
  585. </word>
  586. <word>
  587. <id>33</id>
  588. <length>null</length>
  589. <decimal>null</decimal>
  590. <array>false</array>
  591. <array_dimension>null</array_dimension>
  592. <unsigned>false</unsigned>
  593. <args></args>
  594. <description>排序(升序)</description>
  595. <logical_name>排序(升序)</logical_name>
  596. <physical_name>sort</physical_name>
  597. <type>decimal</type>
  598. </word>
  599. <word>
  600. <id>34</id>
  601. <length>30</length>
  602. <decimal>null</decimal>
  603. <array>false</array>
  604. <array_dimension>null</array_dimension>
  605. <unsigned>false</unsigned>
  606. <args></args>
  607. <description>生成子模块名</description>
  608. <logical_name>生成子模块名</logical_name>
  609. <physical_name>sub_module_name</physical_name>
  610. <type>varchar(n)</type>
  611. </word>
  612. <word>
  613. <id>35</id>
  614. <length>64</length>
  615. <decimal>null</decimal>
  616. <array>false</array>
  617. <array_dimension>null</array_dimension>
  618. <unsigned>false</unsigned>
  619. <args></args>
  620. <description>更新者</description>
  621. <logical_name>更新者</logical_name>
  622. <physical_name>update_by</physical_name>
  623. <type>varchar(n)</type>
  624. </word>
  625. <word>
  626. <id>36</id>
  627. <length>null</length>
  628. <decimal>null</decimal>
  629. <array>false</array>
  630. <array_dimension>null</array_dimension>
  631. <unsigned>false</unsigned>
  632. <args></args>
  633. <description>更新时间</description>
  634. <logical_name>更新时间</logical_name>
  635. <physical_name>update_date</physical_name>
  636. <type>datetime</type>
  637. </word>
  638. </dictionary>
  639. <tablespace_set>
  640. </tablespace_set>
  641. <contents>
  642. <table>
  643. <id>0</id>
  644. <height>317</height>
  645. <width>275</width>
  646. <font_name>Segoe UI</font_name>
  647. <font_size>9</font_size>
  648. <x>43</x>
  649. <y>44</y>
  650. <color>
  651. <r>128</r>
  652. <g>128</g>
  653. <b>192</b>
  654. </color>
  655. <connections>
  656. </connections>
  657. <physical_name>gen_table</physical_name>
  658. <logical_name>业务表</logical_name>
  659. <description>业务表</description>
  660. <constraint></constraint>
  661. <primary_key_name></primary_key_name>
  662. <option></option>
  663. <columns>
  664. <normal_column>
  665. <word_id>14</word_id>
  666. <id>6</id>
  667. <description></description>
  668. <unique_key_name></unique_key_name>
  669. <logical_name></logical_name>
  670. <physical_name></physical_name>
  671. <type>varchar(n)</type>
  672. <constraint></constraint>
  673. <default_value></default_value>
  674. <auto_increment>false</auto_increment>
  675. <foreign_key>false</foreign_key>
  676. <not_null>true</not_null>
  677. <primary_key>true</primary_key>
  678. <unique_key>false</unique_key>
  679. <character_set></character_set>
  680. <collation></collation>
  681. <sequence>
  682. <name></name>
  683. <schema></schema>
  684. <increment></increment>
  685. <min_value></min_value>
  686. <max_value></max_value>
  687. <start></start>
  688. <cache></cache>
  689. <cycle>false</cycle>
  690. <order>false</order>
  691. <description></description>
  692. <data_type></data_type>
  693. <decimal_size>0</decimal_size>
  694. </sequence>
  695. </normal_column>
  696. <normal_column>
  697. <word_id>25</word_id>
  698. <id>7</id>
  699. <description></description>
  700. <unique_key_name></unique_key_name>
  701. <logical_name></logical_name>
  702. <physical_name></physical_name>
  703. <type>nvarchar(n)</type>
  704. <constraint></constraint>
  705. <default_value></default_value>
  706. <auto_increment>false</auto_increment>
  707. <foreign_key>false</foreign_key>
  708. <not_null>false</not_null>
  709. <primary_key>false</primary_key>
  710. <unique_key>false</unique_key>
  711. <character_set></character_set>
  712. <collation></collation>
  713. <sequence>
  714. <name></name>
  715. <schema></schema>
  716. <increment></increment>
  717. <min_value></min_value>
  718. <max_value></max_value>
  719. <start></start>
  720. <cache></cache>
  721. <cycle>false</cycle>
  722. <order>false</order>
  723. <description></description>
  724. <data_type></data_type>
  725. <decimal_size>0</decimal_size>
  726. </sequence>
  727. </normal_column>
  728. <normal_column>
  729. <word_id>2</word_id>
  730. <id>8</id>
  731. <description></description>
  732. <unique_key_name></unique_key_name>
  733. <logical_name></logical_name>
  734. <physical_name></physical_name>
  735. <type>nvarchar(n)</type>
  736. <constraint></constraint>
  737. <default_value></default_value>
  738. <auto_increment>false</auto_increment>
  739. <foreign_key>false</foreign_key>
  740. <not_null>false</not_null>
  741. <primary_key>false</primary_key>
  742. <unique_key>false</unique_key>
  743. <character_set></character_set>
  744. <collation></collation>
  745. <sequence>
  746. <name></name>
  747. <schema></schema>
  748. <increment></increment>
  749. <min_value></min_value>
  750. <max_value></max_value>
  751. <start></start>
  752. <cache></cache>
  753. <cycle>false</cycle>
  754. <order>false</order>
  755. <description></description>
  756. <data_type></data_type>
  757. <decimal_size>0</decimal_size>
  758. </sequence>
  759. </normal_column>
  760. <normal_column>
  761. <word_id>1</word_id>
  762. <id>9</id>
  763. <description></description>
  764. <unique_key_name></unique_key_name>
  765. <logical_name></logical_name>
  766. <physical_name></physical_name>
  767. <type>varchar(n)</type>
  768. <constraint></constraint>
  769. <default_value></default_value>
  770. <auto_increment>false</auto_increment>
  771. <foreign_key>false</foreign_key>
  772. <not_null>false</not_null>
  773. <primary_key>false</primary_key>
  774. <unique_key>false</unique_key>
  775. <character_set></character_set>
  776. <collation></collation>
  777. <sequence>
  778. <name></name>
  779. <schema></schema>
  780. <increment></increment>
  781. <min_value></min_value>
  782. <max_value></max_value>
  783. <start></start>
  784. <cache></cache>
  785. <cycle>false</cycle>
  786. <order>false</order>
  787. <description></description>
  788. <data_type></data_type>
  789. <decimal_size>0</decimal_size>
  790. </sequence>
  791. </normal_column>
  792. <normal_column>
  793. <word_id>27</word_id>
  794. <id>10</id>
  795. <description></description>
  796. <unique_key_name></unique_key_name>
  797. <logical_name></logical_name>
  798. <physical_name></physical_name>
  799. <type>varchar(n)</type>
  800. <constraint></constraint>
  801. <default_value></default_value>
  802. <auto_increment>false</auto_increment>
  803. <foreign_key>false</foreign_key>
  804. <not_null>false</not_null>
  805. <primary_key>false</primary_key>
  806. <unique_key>false</unique_key>
  807. <character_set></character_set>
  808. <collation></collation>
  809. <sequence>
  810. <name></name>
  811. <schema></schema>
  812. <increment></increment>
  813. <min_value></min_value>
  814. <max_value></max_value>
  815. <start></start>
  816. <cache></cache>
  817. <cycle>false</cycle>
  818. <order>false</order>
  819. <description></description>
  820. <data_type></data_type>
  821. <decimal_size>0</decimal_size>
  822. </sequence>
  823. </normal_column>
  824. <normal_column>
  825. <word_id>28</word_id>
  826. <id>11</id>
  827. <description></description>
  828. <unique_key_name></unique_key_name>
  829. <logical_name></logical_name>
  830. <physical_name></physical_name>
  831. <type>varchar(n)</type>
  832. <constraint></constraint>
  833. <default_value></default_value>
  834. <auto_increment>false</auto_increment>
  835. <foreign_key>false</foreign_key>
  836. <not_null>false</not_null>
  837. <primary_key>false</primary_key>
  838. <unique_key>false</unique_key>
  839. <character_set></character_set>
  840. <collation></collation>
  841. <sequence>
  842. <name></name>
  843. <schema></schema>
  844. <increment></increment>
  845. <min_value></min_value>
  846. <max_value></max_value>
  847. <start></start>
  848. <cache></cache>
  849. <cycle>false</cycle>
  850. <order>false</order>
  851. <description></description>
  852. <data_type></data_type>
  853. <decimal_size>0</decimal_size>
  854. </sequence>
  855. </normal_column>
  856. <column_group>0</column_group>
  857. </columns>
  858. <indexes>
  859. <inidex>
  860. <full_text>false</full_text>
  861. <non_unique>true</non_unique>
  862. <name>gen_table_name</name>
  863. <type></type>
  864. <description></description>
  865. <columns>
  866. <column>
  867. <id>7</id>
  868. <desc>false</desc>
  869. </column>
  870. </columns>
  871. </inidex>
  872. <inidex>
  873. <full_text>false</full_text>
  874. <non_unique>true</non_unique>
  875. <name>gen_table_del_flag</name>
  876. <type></type>
  877. <description></description>
  878. <columns>
  879. <column>
  880. <id>5</id>
  881. <desc>false</desc>
  882. </column>
  883. </columns>
  884. </inidex>
  885. </indexes>
  886. <complex_unique_key_list>
  887. </complex_unique_key_list>
  888. <table_properties>
  889. <schema></schema>
  890. </table_properties>
  891. </table>
  892. <table>
  893. <id>1</id>
  894. <height>443</height>
  895. <width>235</width>
  896. <font_name>Segoe UI</font_name>
  897. <font_size>9</font_size>
  898. <x>374</x>
  899. <y>41</y>
  900. <color>
  901. <r>128</r>
  902. <g>128</g>
  903. <b>192</b>
  904. </color>
  905. <connections>
  906. <relation>
  907. <id>0</id>
  908. <source>0</source>
  909. <target>1</target>
  910. <child_cardinality>1..n</child_cardinality>
  911. <parent_cardinality>1</parent_cardinality>
  912. <reference_for_pk>true</reference_for_pk>
  913. <name></name>
  914. <on_delete_action>RESTRICT</on_delete_action>
  915. <on_update_action>RESTRICT</on_update_action>
  916. <source_xp>-1</source_xp>
  917. <source_yp>-1</source_yp>
  918. <target_xp>-1</target_xp>
  919. <target_yp>-1</target_yp>
  920. <referenced_column>null</referenced_column>
  921. <referenced_complex_unique_key>null</referenced_complex_unique_key>
  922. </relation>
  923. </connections>
  924. <physical_name>gen_table_column</physical_name>
  925. <logical_name>业务表字段</logical_name>
  926. <description>业务表字段</description>
  927. <constraint></constraint>
  928. <primary_key_name></primary_key_name>
  929. <option></option>
  930. <columns>
  931. <normal_column>
  932. <word_id>14</word_id>
  933. <id>12</id>
  934. <description></description>
  935. <unique_key_name></unique_key_name>
  936. <logical_name></logical_name>
  937. <physical_name></physical_name>
  938. <type>varchar(n)</type>
  939. <constraint></constraint>
  940. <default_value></default_value>
  941. <auto_increment>false</auto_increment>
  942. <foreign_key>false</foreign_key>
  943. <not_null>true</not_null>
  944. <primary_key>true</primary_key>
  945. <unique_key>false</unique_key>
  946. <character_set></character_set>
  947. <collation></collation>
  948. <sequence>
  949. <name></name>
  950. <schema></schema>
  951. <increment></increment>
  952. <min_value></min_value>
  953. <max_value></max_value>
  954. <start></start>
  955. <cache></cache>
  956. <cycle>false</cycle>
  957. <order>false</order>
  958. <description></description>
  959. <data_type></data_type>
  960. <decimal_size>0</decimal_size>
  961. </sequence>
  962. </normal_column>
  963. <normal_column>
  964. <id>13</id>
  965. <referenced_column>6</referenced_column>
  966. <relation>0</relation>
  967. <description>归属表编号</description>
  968. <unique_key_name></unique_key_name>
  969. <logical_name>归属表编号</logical_name>
  970. <physical_name>gen_table_id</physical_name>
  971. <type>varchar(n)</type>
  972. <constraint></constraint>
  973. <default_value></default_value>
  974. <auto_increment>false</auto_increment>
  975. <foreign_key>true</foreign_key>
  976. <not_null>false</not_null>
  977. <primary_key>false</primary_key>
  978. <unique_key>false</unique_key>
  979. <character_set></character_set>
  980. <collation></collation>
  981. <sequence>
  982. <name></name>
  983. <schema></schema>
  984. <increment></increment>
  985. <min_value></min_value>
  986. <max_value></max_value>
  987. <start></start>
  988. <cache></cache>
  989. <cycle>false</cycle>
  990. <order>false</order>
  991. <description></description>
  992. <data_type></data_type>
  993. <decimal_size>0</decimal_size>
  994. </sequence>
  995. </normal_column>
  996. <normal_column>
  997. <word_id>25</word_id>
  998. <id>14</id>
  999. <description></description>
  1000. <unique_key_name></unique_key_name>
  1001. <logical_name></logical_name>
  1002. <physical_name></physical_name>
  1003. <type>nvarchar(n)</type>
  1004. <constraint></constraint>
  1005. <default_value></default_value>
  1006. <auto_increment>false</auto_increment>
  1007. <foreign_key>false</foreign_key>
  1008. <not_null>false</not_null>
  1009. <primary_key>false</primary_key>
  1010. <unique_key>false</unique_key>
  1011. <character_set></character_set>
  1012. <collation></collation>
  1013. <sequence>
  1014. <name></name>
  1015. <schema></schema>
  1016. <increment></increment>
  1017. <min_value></min_value>
  1018. <max_value></max_value>
  1019. <start></start>
  1020. <cache></cache>
  1021. <cycle>false</cycle>
  1022. <order>false</order>
  1023. <description></description>
  1024. <data_type></data_type>
  1025. <decimal_size>0</decimal_size>
  1026. </sequence>
  1027. </normal_column>
  1028. <normal_column>
  1029. <word_id>2</word_id>
  1030. <id>15</id>
  1031. <description></description>
  1032. <unique_key_name></unique_key_name>
  1033. <logical_name></logical_name>
  1034. <physical_name></physical_name>
  1035. <type>nvarchar(n)</type>
  1036. <constraint></constraint>
  1037. <default_value></default_value>
  1038. <auto_increment>false</auto_increment>
  1039. <foreign_key>false</foreign_key>
  1040. <not_null>false</not_null>
  1041. <primary_key>false</primary_key>
  1042. <unique_key>false</unique_key>
  1043. <character_set></character_set>
  1044. <collation></collation>
  1045. <sequence>
  1046. <name></name>
  1047. <schema></schema>
  1048. <increment></increment>
  1049. <min_value></min_value>
  1050. <max_value></max_value>
  1051. <start></start>
  1052. <cache></cache>
  1053. <cycle>false</cycle>
  1054. <order>false</order>
  1055. <description></description>
  1056. <data_type></data_type>
  1057. <decimal_size>0</decimal_size>
  1058. </sequence>
  1059. </normal_column>
  1060. <normal_column>
  1061. <word_id>23</word_id>
  1062. <id>16</id>
  1063. <description></description>
  1064. <unique_key_name></unique_key_name>
  1065. <logical_name></logical_name>
  1066. <physical_name></physical_name>
  1067. <type>varchar(n)</type>
  1068. <constraint></constraint>
  1069. <default_value></default_value>
  1070. <auto_increment>false</auto_increment>
  1071. <foreign_key>false</foreign_key>
  1072. <not_null>false</not_null>
  1073. <primary_key>false</primary_key>
  1074. <unique_key>false</unique_key>
  1075. <character_set></character_set>
  1076. <collation></collation>
  1077. <sequence>
  1078. <name></name>
  1079. <schema></schema>
  1080. <increment></increment>
  1081. <min_value></min_value>
  1082. <max_value></max_value>
  1083. <start></start>
  1084. <cache></cache>
  1085. <cycle>false</cycle>
  1086. <order>false</order>
  1087. <description></description>
  1088. <data_type></data_type>
  1089. <decimal_size>0</decimal_size>
  1090. </sequence>
  1091. </normal_column>
  1092. <normal_column>
  1093. <word_id>22</word_id>
  1094. <id>17</id>
  1095. <description></description>
  1096. <unique_key_name></unique_key_name>
  1097. <logical_name></logical_name>
  1098. <physical_name></physical_name>
  1099. <type>varchar(n)</type>
  1100. <constraint></constraint>
  1101. <default_value></default_value>
  1102. <auto_increment>false</auto_increment>
  1103. <foreign_key>false</foreign_key>
  1104. <not_null>false</not_null>
  1105. <primary_key>false</primary_key>
  1106. <unique_key>false</unique_key>
  1107. <character_set></character_set>
  1108. <collation></collation>
  1109. <sequence>
  1110. <name></name>
  1111. <schema></schema>
  1112. <increment></increment>
  1113. <min_value></min_value>
  1114. <max_value></max_value>
  1115. <start></start>
  1116. <cache></cache>
  1117. <cycle>false</cycle>
  1118. <order>false</order>
  1119. <description></description>
  1120. <data_type></data_type>
  1121. <decimal_size>0</decimal_size>
  1122. </sequence>
  1123. </normal_column>
  1124. <normal_column>
  1125. <word_id>21</word_id>
  1126. <id>18</id>
  1127. <description></description>
  1128. <unique_key_name></unique_key_name>
  1129. <logical_name></logical_name>
  1130. <physical_name></physical_name>
  1131. <type>varchar(n)</type>
  1132. <constraint></constraint>
  1133. <default_value></default_value>
  1134. <auto_increment>false</auto_increment>
  1135. <foreign_key>false</foreign_key>
  1136. <not_null>false</not_null>
  1137. <primary_key>false</primary_key>
  1138. <unique_key>false</unique_key>
  1139. <character_set></character_set>
  1140. <collation></collation>
  1141. <sequence>
  1142. <name></name>
  1143. <schema></schema>
  1144. <increment></increment>
  1145. <min_value></min_value>
  1146. <max_value></max_value>
  1147. <start></start>
  1148. <cache></cache>
  1149. <cycle>false</cycle>
  1150. <order>false</order>
  1151. <description></description>
  1152. <data_type></data_type>
  1153. <decimal_size>0</decimal_size>
  1154. </sequence>
  1155. </normal_column>
  1156. <normal_column>
  1157. <word_id>19</word_id>
  1158. <id>19</id>
  1159. <description></description>
  1160. <unique_key_name></unique_key_name>
  1161. <logical_name></logical_name>
  1162. <physical_name></physical_name>
  1163. <type>character(n)</type>
  1164. <constraint></constraint>
  1165. <default_value></default_value>
  1166. <auto_increment>false</auto_increment>
  1167. <foreign_key>false</foreign_key>
  1168. <not_null>false</not_null>
  1169. <primary_key>false</primary_key>
  1170. <unique_key>false</unique_key>
  1171. <character_set></character_set>
  1172. <collation></collation>
  1173. <sequence>
  1174. <name></name>
  1175. <schema></schema>
  1176. <increment></increment>
  1177. <min_value></min_value>
  1178. <max_value></max_value>
  1179. <start></start>
  1180. <cache></cache>
  1181. <cycle>false</cycle>
  1182. <order>false</order>
  1183. <description></description>
  1184. <data_type></data_type>
  1185. <decimal_size>0</decimal_size>
  1186. </sequence>
  1187. </normal_column>
  1188. <normal_column>
  1189. <word_id>18</word_id>
  1190. <id>20</id>
  1191. <description></description>
  1192. <unique_key_name></unique_key_name>
  1193. <logical_name></logical_name>
  1194. <physical_name></physical_name>
  1195. <type>character(n)</type>
  1196. <constraint></constraint>
  1197. <default_value></default_value>
  1198. <auto_increment>false</auto_increment>
  1199. <foreign_key>false</foreign_key>
  1200. <not_null>false</not_null>
  1201. <primary_key>false</primary_key>
  1202. <unique_key>false</unique_key>
  1203. <character_set></character_set>
  1204. <collation></collation>
  1205. <sequence>
  1206. <name></name>
  1207. <schema></schema>
  1208. <increment></increment>
  1209. <min_value></min_value>
  1210. <max_value></max_value>
  1211. <start></start>
  1212. <cache></cache>
  1213. <cycle>false</cycle>
  1214. <order>false</order>
  1215. <description></description>
  1216. <data_type></data_type>
  1217. <decimal_size>0</decimal_size>
  1218. </sequence>
  1219. </normal_column>
  1220. <normal_column>
  1221. <word_id>16</word_id>
  1222. <id>21</id>
  1223. <description></description>
  1224. <unique_key_name></unique_key_name>
  1225. <logical_name></logical_name>
  1226. <physical_name></physical_name>
  1227. <type>character(n)</type>
  1228. <constraint></constraint>
  1229. <default_value></default_value>
  1230. <auto_increment>false</auto_increment>
  1231. <foreign_key>false</foreign_key>
  1232. <not_null>false</not_null>
  1233. <primary_key>false</primary_key>
  1234. <unique_key>false</unique_key>
  1235. <character_set></character_set>
  1236. <collation></collation>
  1237. <sequence>
  1238. <name></name>
  1239. <schema></schema>
  1240. <increment></increment>
  1241. <min_value></min_value>
  1242. <max_value></max_value>
  1243. <start></start>
  1244. <cache></cache>
  1245. <cycle>false</cycle>
  1246. <order>false</order>
  1247. <description></description>
  1248. <data_type></data_type>
  1249. <decimal_size>0</decimal_size>
  1250. </sequence>
  1251. </normal_column>
  1252. <normal_column>
  1253. <word_id>15</word_id>
  1254. <id>22</id>
  1255. <description></description>
  1256. <unique_key_name></unique_key_name>
  1257. <logical_name></logical_name>
  1258. <physical_name></physical_name>
  1259. <type>character(n)</type>
  1260. <constraint></constraint>
  1261. <default_value></default_value>
  1262. <auto_increment>false</auto_increment>
  1263. <foreign_key>false</foreign_key>
  1264. <not_null>false</not_null>
  1265. <primary_key>false</primary_key>
  1266. <unique_key>false</unique_key>
  1267. <character_set></character_set>
  1268. <collation></collation>
  1269. <sequence>
  1270. <name></name>
  1271. <schema></schema>
  1272. <increment></increment>
  1273. <min_value></min_value>
  1274. <max_value></max_value>
  1275. <start></start>
  1276. <cache></cache>
  1277. <cycle>false</cycle>
  1278. <order>false</order>
  1279. <description></description>
  1280. <data_type></data_type>
  1281. <decimal_size>0</decimal_size>
  1282. </sequence>
  1283. </normal_column>
  1284. <normal_column>
  1285. <word_id>17</word_id>
  1286. <id>23</id>
  1287. <description></description>
  1288. <unique_key_name></unique_key_name>
  1289. <logical_name></logical_name>
  1290. <physical_name></physical_name>
  1291. <type>character(n)</type>
  1292. <constraint></constraint>
  1293. <default_value></default_value>
  1294. <auto_increment>false</auto_increment>
  1295. <foreign_key>false</foreign_key>
  1296. <not_null>false</not_null>
  1297. <primary_key>false</primary_key>
  1298. <unique_key>false</unique_key>
  1299. <character_set></character_set>
  1300. <collation></collation>
  1301. <sequence>
  1302. <name></name>
  1303. <schema></schema>
  1304. <increment></increment>
  1305. <min_value></min_value>
  1306. <max_value></max_value>
  1307. <start></start>
  1308. <cache></cache>
  1309. <cycle>false</cycle>
  1310. <order>false</order>
  1311. <description></description>
  1312. <data_type></data_type>
  1313. <decimal_size>0</decimal_size>
  1314. </sequence>
  1315. </normal_column>
  1316. <normal_column>
  1317. <word_id>20</word_id>
  1318. <id>24</id>
  1319. <description></description>
  1320. <unique_key_name></unique_key_name>
  1321. <logical_name></logical_name>
  1322. <physical_name></physical_name>
  1323. <type>character(n)</type>
  1324. <constraint></constraint>
  1325. <default_value></default_value>
  1326. <auto_increment>false</auto_increment>
  1327. <foreign_key>false</foreign_key>
  1328. <not_null>false</not_null>
  1329. <primary_key>false</primary_key>
  1330. <unique_key>false</unique_key>
  1331. <character_set></character_set>
  1332. <collation></collation>
  1333. <sequence>
  1334. <name></name>
  1335. <schema></schema>
  1336. <increment></increment>
  1337. <min_value></min_value>
  1338. <max_value></max_value>
  1339. <start></start>
  1340. <cache></cache>
  1341. <cycle>false</cycle>
  1342. <order>false</order>
  1343. <description></description>
  1344. <data_type></data_type>
  1345. <decimal_size>0</decimal_size>
  1346. </sequence>
  1347. </normal_column>
  1348. <normal_column>
  1349. <word_id>29</word_id>
  1350. <id>25</id>
  1351. <description></description>
  1352. <unique_key_name></unique_key_name>
  1353. <logical_name></logical_name>
  1354. <physical_name></physical_name>
  1355. <type>varchar(n)</type>
  1356. <constraint></constraint>
  1357. <default_value></default_value>
  1358. <auto_increment>false</auto_increment>
  1359. <foreign_key>false</foreign_key>
  1360. <not_null>false</not_null>
  1361. <primary_key>false</primary_key>
  1362. <unique_key>false</unique_key>
  1363. <character_set></character_set>
  1364. <collation></collation>
  1365. <sequence>
  1366. <name></name>
  1367. <schema></schema>
  1368. <increment></increment>
  1369. <min_value></min_value>
  1370. <max_value></max_value>
  1371. <start></start>
  1372. <cache></cache>
  1373. <cycle>false</cycle>
  1374. <order>false</order>
  1375. <description></description>
  1376. <data_type></data_type>
  1377. <decimal_size>0</decimal_size>
  1378. </sequence>
  1379. </normal_column>
  1380. <normal_column>
  1381. <word_id>32</word_id>
  1382. <id>26</id>
  1383. <description></description>
  1384. <unique_key_name></unique_key_name>
  1385. <logical_name></logical_name>
  1386. <physical_name></physical_name>
  1387. <type>varchar(n)</type>
  1388. <constraint></constraint>
  1389. <default_value></default_value>
  1390. <auto_increment>false</auto_increment>
  1391. <foreign_key>false</foreign_key>
  1392. <not_null>false</not_null>
  1393. <primary_key>false</primary_key>
  1394. <unique_key>false</unique_key>
  1395. <character_set></character_set>
  1396. <collation></collation>
  1397. <sequence>
  1398. <name></name>
  1399. <schema></schema>
  1400. <increment></increment>
  1401. <min_value></min_value>
  1402. <max_value></max_value>
  1403. <start></start>
  1404. <cache></cache>
  1405. <cycle>false</cycle>
  1406. <order>false</order>
  1407. <description></description>
  1408. <data_type></data_type>
  1409. <decimal_size>0</decimal_size>
  1410. </sequence>
  1411. </normal_column>
  1412. <normal_column>
  1413. <word_id>7</word_id>
  1414. <id>27</id>
  1415. <description></description>
  1416. <unique_key_name></unique_key_name>
  1417. <logical_name></logical_name>
  1418. <physical_name></physical_name>
  1419. <type>varchar(n)</type>
  1420. <constraint></constraint>
  1421. <default_value></default_value>
  1422. <auto_increment>false</auto_increment>
  1423. <foreign_key>false</foreign_key>
  1424. <not_null>false</not_null>
  1425. <primary_key>false</primary_key>
  1426. <unique_key>false</unique_key>
  1427. <character_set></character_set>
  1428. <collation></collation>
  1429. <sequence>
  1430. <name></name>
  1431. <schema></schema>
  1432. <increment></increment>
  1433. <min_value></min_value>
  1434. <max_value></max_value>
  1435. <start></start>
  1436. <cache></cache>
  1437. <cycle>false</cycle>
  1438. <order>false</order>
  1439. <description></description>
  1440. <data_type></data_type>
  1441. <decimal_size>0</decimal_size>
  1442. </sequence>
  1443. </normal_column>
  1444. <normal_column>
  1445. <word_id>31</word_id>
  1446. <id>28</id>
  1447. <description></description>
  1448. <unique_key_name></unique_key_name>
  1449. <logical_name></logical_name>
  1450. <physical_name></physical_name>
  1451. <type>nvarchar(n)</type>
  1452. <constraint></constraint>
  1453. <default_value></default_value>
  1454. <auto_increment>false</auto_increment>
  1455. <foreign_key>false</foreign_key>
  1456. <not_null>false</not_null>
  1457. <primary_key>false</primary_key>
  1458. <unique_key>false</unique_key>
  1459. <character_set></character_set>
  1460. <collation></collation>
  1461. <sequence>
  1462. <name></name>
  1463. <schema></schema>
  1464. <increment></increment>
  1465. <min_value></min_value>
  1466. <max_value></max_value>
  1467. <start></start>
  1468. <cache></cache>
  1469. <cycle>false</cycle>
  1470. <order>false</order>
  1471. <description></description>
  1472. <data_type></data_type>
  1473. <decimal_size>0</decimal_size>
  1474. </sequence>
  1475. </normal_column>
  1476. <normal_column>
  1477. <word_id>33</word_id>
  1478. <id>29</id>
  1479. <description></description>
  1480. <unique_key_name></unique_key_name>
  1481. <logical_name></logical_name>
  1482. <physical_name></physical_name>
  1483. <type>decimal</type>
  1484. <constraint></constraint>
  1485. <default_value></default_value>
  1486. <auto_increment>false</auto_increment>
  1487. <foreign_key>false</foreign_key>
  1488. <not_null>false</not_null>
  1489. <primary_key>false</primary_key>
  1490. <unique_key>false</unique_key>
  1491. <character_set></character_set>
  1492. <collation></collation>
  1493. <sequence>
  1494. <name></name>
  1495. <schema></schema>
  1496. <increment></increment>
  1497. <min_value></min_value>
  1498. <max_value></max_value>
  1499. <start></start>
  1500. <cache></cache>
  1501. <cycle>false</cycle>
  1502. <order>false</order>
  1503. <description></description>
  1504. <data_type></data_type>
  1505. <decimal_size>0</decimal_size>
  1506. </sequence>
  1507. </normal_column>
  1508. <column_group>0</column_group>
  1509. </columns>
  1510. <indexes>
  1511. <inidex>
  1512. <full_text>false</full_text>
  1513. <non_unique>true</non_unique>
  1514. <name>gen_table_column_table_id</name>
  1515. <type></type>
  1516. <description></description>
  1517. <columns>
  1518. <column>
  1519. <id>13</id>
  1520. <desc>false</desc>
  1521. </column>
  1522. </columns>
  1523. </inidex>
  1524. <inidex>
  1525. <full_text>false</full_text>
  1526. <non_unique>true</non_unique>
  1527. <name>gen_table_column_name</name>
  1528. <type></type>
  1529. <description></description>
  1530. <columns>
  1531. <column>
  1532. <id>14</id>
  1533. <desc>false</desc>
  1534. </column>
  1535. </columns>
  1536. </inidex>
  1537. <inidex>
  1538. <full_text>false</full_text>
  1539. <non_unique>true</non_unique>
  1540. <name>gen_table_column_sort</name>
  1541. <type></type>
  1542. <description></description>
  1543. <columns>
  1544. <column>
  1545. <id>29</id>
  1546. <desc>false</desc>
  1547. </column>
  1548. </columns>
  1549. </inidex>
  1550. <inidex>
  1551. <full_text>false</full_text>
  1552. <non_unique>true</non_unique>
  1553. <name>gen_table_column_del_flag</name>
  1554. <type></type>
  1555. <description></description>
  1556. <columns>
  1557. <column>
  1558. <id>5</id>
  1559. <desc>false</desc>
  1560. </column>
  1561. </columns>
  1562. </inidex>
  1563. </indexes>
  1564. <complex_unique_key_list>
  1565. </complex_unique_key_list>
  1566. <table_properties>
  1567. <schema></schema>
  1568. </table_properties>
  1569. </table>
  1570. <table>
  1571. <id>2</id>
  1572. <height>380</height>
  1573. <width>370</width>
  1574. <font_name>Segoe UI</font_name>
  1575. <font_size>9</font_size>
  1576. <x>671</x>
  1577. <y>40</y>
  1578. <color>
  1579. <r>128</r>
  1580. <g>128</g>
  1581. <b>192</b>
  1582. </color>
  1583. <connections>
  1584. </connections>
  1585. <physical_name>gen_scheme</physical_name>
  1586. <logical_name>生成方案</logical_name>
  1587. <description>生成方案</description>
  1588. <constraint></constraint>
  1589. <primary_key_name></primary_key_name>
  1590. <option></option>
  1591. <columns>
  1592. <normal_column>
  1593. <word_id>14</word_id>
  1594. <id>30</id>
  1595. <description></description>
  1596. <unique_key_name></unique_key_name>
  1597. <logical_name></logical_name>
  1598. <physical_name></physical_name>
  1599. <type>varchar(n)</type>
  1600. <constraint></constraint>
  1601. <default_value></default_value>
  1602. <auto_increment>false</auto_increment>
  1603. <foreign_key>false</foreign_key>
  1604. <not_null>true</not_null>
  1605. <primary_key>true</primary_key>
  1606. <unique_key>false</unique_key>
  1607. <character_set></character_set>
  1608. <collation></collation>
  1609. <sequence>
  1610. <name></name>
  1611. <schema></schema>
  1612. <increment></increment>
  1613. <min_value></min_value>
  1614. <max_value></max_value>
  1615. <start></start>
  1616. <cache></cache>
  1617. <cycle>false</cycle>
  1618. <order>false</order>
  1619. <description></description>
  1620. <data_type></data_type>
  1621. <decimal_size>0</decimal_size>
  1622. </sequence>
  1623. </normal_column>
  1624. <normal_column>
  1625. <word_id>25</word_id>
  1626. <id>31</id>
  1627. <description></description>
  1628. <unique_key_name></unique_key_name>
  1629. <logical_name></logical_name>
  1630. <physical_name></physical_name>
  1631. <type>nvarchar(n)</type>
  1632. <constraint></constraint>
  1633. <default_value></default_value>
  1634. <auto_increment>false</auto_increment>
  1635. <foreign_key>false</foreign_key>
  1636. <not_null>false</not_null>
  1637. <primary_key>false</primary_key>
  1638. <unique_key>false</unique_key>
  1639. <character_set></character_set>
  1640. <collation></collation>
  1641. <sequence>
  1642. <name></name>
  1643. <schema></schema>
  1644. <increment></increment>
  1645. <min_value></min_value>
  1646. <max_value></max_value>
  1647. <start></start>
  1648. <cache></cache>
  1649. <cycle>false</cycle>
  1650. <order>false</order>
  1651. <description></description>
  1652. <data_type></data_type>
  1653. <decimal_size>0</decimal_size>
  1654. </sequence>
  1655. </normal_column>
  1656. <normal_column>
  1657. <word_id>0</word_id>
  1658. <id>32</id>
  1659. <description></description>
  1660. <unique_key_name></unique_key_name>
  1661. <logical_name></logical_name>
  1662. <physical_name></physical_name>
  1663. <type>varchar(n)</type>
  1664. <constraint></constraint>
  1665. <default_value></default_value>
  1666. <auto_increment>false</auto_increment>
  1667. <foreign_key>false</foreign_key>
  1668. <not_null>false</not_null>
  1669. <primary_key>false</primary_key>
  1670. <unique_key>false</unique_key>
  1671. <character_set></character_set>
  1672. <collation></collation>
  1673. <sequence>
  1674. <name></name>
  1675. <schema></schema>
  1676. <increment></increment>
  1677. <min_value></min_value>
  1678. <max_value></max_value>
  1679. <start></start>
  1680. <cache></cache>
  1681. <cycle>false</cycle>
  1682. <order>false</order>
  1683. <description></description>
  1684. <data_type></data_type>
  1685. <decimal_size>0</decimal_size>
  1686. </sequence>
  1687. </normal_column>
  1688. <normal_column>
  1689. <word_id>26</word_id>
  1690. <id>33</id>
  1691. <description></description>
  1692. <unique_key_name></unique_key_name>
  1693. <logical_name></logical_name>
  1694. <physical_name></physical_name>
  1695. <type>varchar(n)</type>
  1696. <constraint></constraint>
  1697. <default_value></default_value>
  1698. <auto_increment>false</auto_increment>
  1699. <foreign_key>false</foreign_key>
  1700. <not_null>false</not_null>
  1701. <primary_key>false</primary_key>
  1702. <unique_key>false</unique_key>
  1703. <character_set></character_set>
  1704. <collation></collation>
  1705. <sequence>
  1706. <name></name>
  1707. <schema></schema>
  1708. <increment></increment>
  1709. <min_value></min_value>
  1710. <max_value></max_value>
  1711. <start></start>
  1712. <cache></cache>
  1713. <cycle>false</cycle>
  1714. <order>false</order>
  1715. <description></description>
  1716. <data_type></data_type>
  1717. <decimal_size>0</decimal_size>
  1718. </sequence>
  1719. </normal_column>
  1720. <normal_column>
  1721. <word_id>24</word_id>
  1722. <id>34</id>
  1723. <description></description>
  1724. <unique_key_name></unique_key_name>
  1725. <logical_name></logical_name>
  1726. <physical_name></physical_name>
  1727. <type>varchar(n)</type>
  1728. <constraint></constraint>
  1729. <default_value></default_value>
  1730. <auto_increment>false</auto_increment>
  1731. <foreign_key>false</foreign_key>
  1732. <not_null>false</not_null>
  1733. <primary_key>false</primary_key>
  1734. <unique_key>false</unique_key>
  1735. <character_set></character_set>
  1736. <collation></collation>
  1737. <sequence>
  1738. <name></name>
  1739. <schema></schema>
  1740. <increment></increment>
  1741. <min_value></min_value>
  1742. <max_value></max_value>
  1743. <start></start>
  1744. <cache></cache>
  1745. <cycle>false</cycle>
  1746. <order>false</order>
  1747. <description></description>
  1748. <data_type></data_type>
  1749. <decimal_size>0</decimal_size>
  1750. </sequence>
  1751. </normal_column>
  1752. <normal_column>
  1753. <word_id>34</word_id>
  1754. <id>35</id>
  1755. <description></description>
  1756. <unique_key_name></unique_key_name>
  1757. <logical_name></logical_name>
  1758. <physical_name></physical_name>
  1759. <type>varchar(n)</type>
  1760. <constraint></constraint>
  1761. <default_value></default_value>
  1762. <auto_increment>false</auto_increment>
  1763. <foreign_key>false</foreign_key>
  1764. <not_null>false</not_null>
  1765. <primary_key>false</primary_key>
  1766. <unique_key>false</unique_key>
  1767. <character_set></character_set>
  1768. <collation></collation>
  1769. <sequence>
  1770. <name></name>
  1771. <schema></schema>
  1772. <increment></increment>
  1773. <min_value></min_value>
  1774. <max_value></max_value>
  1775. <start></start>
  1776. <cache></cache>
  1777. <cycle>false</cycle>
  1778. <order>false</order>
  1779. <description></description>
  1780. <data_type></data_type>
  1781. <decimal_size>0</decimal_size>
  1782. </sequence>
  1783. </normal_column>
  1784. <normal_column>
  1785. <word_id>11</word_id>
  1786. <id>36</id>
  1787. <description></description>
  1788. <unique_key_name></unique_key_name>
  1789. <logical_name></logical_name>
  1790. <physical_name></physical_name>
  1791. <type>nvarchar(n)</type>
  1792. <constraint></constraint>
  1793. <default_value></default_value>
  1794. <auto_increment>false</auto_increment>
  1795. <foreign_key>false</foreign_key>
  1796. <not_null>false</not_null>
  1797. <primary_key>false</primary_key>
  1798. <unique_key>false</unique_key>
  1799. <character_set></character_set>
  1800. <collation></collation>
  1801. <sequence>
  1802. <name></name>
  1803. <schema></schema>
  1804. <increment></increment>
  1805. <min_value></min_value>
  1806. <max_value></max_value>
  1807. <start></start>
  1808. <cache></cache>
  1809. <cycle>false</cycle>
  1810. <order>false</order>
  1811. <description></description>
  1812. <data_type></data_type>
  1813. <decimal_size>0</decimal_size>
  1814. </sequence>
  1815. </normal_column>
  1816. <normal_column>
  1817. <word_id>12</word_id>
  1818. <id>37</id>
  1819. <description></description>
  1820. <unique_key_name></unique_key_name>
  1821. <logical_name></logical_name>
  1822. <physical_name></physical_name>
  1823. <type>nvarchar(n)</type>
  1824. <constraint></constraint>
  1825. <default_value></default_value>
  1826. <auto_increment>false</auto_increment>
  1827. <foreign_key>false</foreign_key>
  1828. <not_null>false</not_null>
  1829. <primary_key>false</primary_key>
  1830. <unique_key>false</unique_key>
  1831. <character_set></character_set>
  1832. <collation></collation>
  1833. <sequence>
  1834. <name></name>
  1835. <schema></schema>
  1836. <increment></increment>
  1837. <min_value></min_value>
  1838. <max_value></max_value>
  1839. <start></start>
  1840. <cache></cache>
  1841. <cycle>false</cycle>
  1842. <order>false</order>
  1843. <description></description>
  1844. <data_type></data_type>
  1845. <decimal_size>0</decimal_size>
  1846. </sequence>
  1847. </normal_column>
  1848. <normal_column>
  1849. <word_id>10</word_id>
  1850. <id>38</id>
  1851. <description></description>
  1852. <unique_key_name></unique_key_name>
  1853. <logical_name></logical_name>
  1854. <physical_name></physical_name>
  1855. <type>nvarchar(n)</type>
  1856. <constraint></constraint>
  1857. <default_value></default_value>
  1858. <auto_increment>false</auto_increment>
  1859. <foreign_key>false</foreign_key>
  1860. <not_null>false</not_null>
  1861. <primary_key>false</primary_key>
  1862. <unique_key>false</unique_key>
  1863. <character_set></character_set>
  1864. <collation></collation>
  1865. <sequence>
  1866. <name></name>
  1867. <schema></schema>
  1868. <increment></increment>
  1869. <min_value></min_value>
  1870. <max_value></max_value>
  1871. <start></start>
  1872. <cache></cache>
  1873. <cycle>false</cycle>
  1874. <order>false</order>
  1875. <description></description>
  1876. <data_type></data_type>
  1877. <decimal_size>0</decimal_size>
  1878. </sequence>
  1879. </normal_column>
  1880. <normal_column>
  1881. <word_id>13</word_id>
  1882. <id>39</id>
  1883. <description></description>
  1884. <unique_key_name></unique_key_name>
  1885. <logical_name></logical_name>
  1886. <physical_name></physical_name>
  1887. <type>varchar(n)</type>
  1888. <constraint></constraint>
  1889. <default_value></default_value>
  1890. <auto_increment>false</auto_increment>
  1891. <foreign_key>false</foreign_key>
  1892. <not_null>false</not_null>
  1893. <primary_key>false</primary_key>
  1894. <unique_key>false</unique_key>
  1895. <character_set></character_set>
  1896. <collation></collation>
  1897. <sequence>
  1898. <name></name>
  1899. <schema></schema>
  1900. <increment></increment>
  1901. <min_value></min_value>
  1902. <max_value></max_value>
  1903. <start></start>
  1904. <cache></cache>
  1905. <cycle>false</cycle>
  1906. <order>false</order>
  1907. <description></description>
  1908. <data_type></data_type>
  1909. <decimal_size>0</decimal_size>
  1910. </sequence>
  1911. </normal_column>
  1912. <column_group>0</column_group>
  1913. </columns>
  1914. <indexes>
  1915. <inidex>
  1916. <full_text>false</full_text>
  1917. <non_unique>true</non_unique>
  1918. <name>gen_scheme_del_flag</name>
  1919. <type></type>
  1920. <description></description>
  1921. <columns>
  1922. <column>
  1923. <id>5</id>
  1924. <desc>false</desc>
  1925. </column>
  1926. </columns>
  1927. </inidex>
  1928. </indexes>
  1929. <complex_unique_key_list>
  1930. </complex_unique_key_list>
  1931. <table_properties>
  1932. <schema></schema>
  1933. </table_properties>
  1934. </table>
  1935. <table>
  1936. <id>3</id>
  1937. <height>296</height>
  1938. <width>252</width>
  1939. <font_name>Segoe UI</font_name>
  1940. <font_size>9</font_size>
  1941. <x>45</x>
  1942. <y>406</y>
  1943. <color>
  1944. <r>128</r>
  1945. <g>128</g>
  1946. <b>192</b>
  1947. </color>
  1948. <connections>
  1949. </connections>
  1950. <physical_name>gen_template</physical_name>
  1951. <logical_name>代码模板表</logical_name>
  1952. <description>代码模板表</description>
  1953. <constraint></constraint>
  1954. <primary_key_name></primary_key_name>
  1955. <option></option>
  1956. <columns>
  1957. <normal_column>
  1958. <word_id>14</word_id>
  1959. <id>40</id>
  1960. <description></description>
  1961. <unique_key_name></unique_key_name>
  1962. <logical_name></logical_name>
  1963. <physical_name></physical_name>
  1964. <type>varchar(n)</type>
  1965. <constraint></constraint>
  1966. <default_value></default_value>
  1967. <auto_increment>false</auto_increment>
  1968. <foreign_key>false</foreign_key>
  1969. <not_null>true</not_null>
  1970. <primary_key>true</primary_key>
  1971. <unique_key>false</unique_key>
  1972. <character_set></character_set>
  1973. <collation></collation>
  1974. <sequence>
  1975. <name></name>
  1976. <schema></schema>
  1977. <increment></increment>
  1978. <min_value></min_value>
  1979. <max_value></max_value>
  1980. <start></start>
  1981. <cache></cache>
  1982. <cycle>false</cycle>
  1983. <order>false</order>
  1984. <description></description>
  1985. <data_type></data_type>
  1986. <decimal_size>0</decimal_size>
  1987. </sequence>
  1988. </normal_column>
  1989. <normal_column>
  1990. <word_id>25</word_id>
  1991. <id>41</id>
  1992. <description></description>
  1993. <unique_key_name></unique_key_name>
  1994. <logical_name></logical_name>
  1995. <physical_name></physical_name>
  1996. <type>nvarchar(n)</type>
  1997. <constraint></constraint>
  1998. <default_value></default_value>
  1999. <auto_increment>false</auto_increment>
  2000. <foreign_key>false</foreign_key>
  2001. <not_null>false</not_null>
  2002. <primary_key>false</primary_key>
  2003. <unique_key>false</unique_key>
  2004. <character_set></character_set>
  2005. <collation></collation>
  2006. <sequence>
  2007. <name></name>
  2008. <schema></schema>
  2009. <increment></increment>
  2010. <min_value></min_value>
  2011. <max_value></max_value>
  2012. <start></start>
  2013. <cache></cache>
  2014. <cycle>false</cycle>
  2015. <order>false</order>
  2016. <description></description>
  2017. <data_type></data_type>
  2018. <decimal_size>0</decimal_size>
  2019. </sequence>
  2020. </normal_column>
  2021. <normal_column>
  2022. <word_id>0</word_id>
  2023. <id>42</id>
  2024. <description></description>
  2025. <unique_key_name></unique_key_name>
  2026. <logical_name></logical_name>
  2027. <physical_name></physical_name>
  2028. <type>varchar(n)</type>
  2029. <constraint></constraint>
  2030. <default_value></default_value>
  2031. <auto_increment>false</auto_increment>
  2032. <foreign_key>false</foreign_key>
  2033. <not_null>false</not_null>
  2034. <primary_key>false</primary_key>
  2035. <unique_key>false</unique_key>
  2036. <character_set></character_set>
  2037. <collation></collation>
  2038. <sequence>
  2039. <name></name>
  2040. <schema></schema>
  2041. <increment></increment>
  2042. <min_value></min_value>
  2043. <max_value></max_value>
  2044. <start></start>
  2045. <cache></cache>
  2046. <cycle>false</cycle>
  2047. <order>false</order>
  2048. <description></description>
  2049. <data_type></data_type>
  2050. <decimal_size>0</decimal_size>
  2051. </sequence>
  2052. </normal_column>
  2053. <normal_column>
  2054. <word_id>9</word_id>
  2055. <id>43</id>
  2056. <description></description>
  2057. <unique_key_name></unique_key_name>
  2058. <logical_name></logical_name>
  2059. <physical_name></physical_name>
  2060. <type>varchar(n)</type>
  2061. <constraint></constraint>
  2062. <default_value></default_value>
  2063. <auto_increment>false</auto_increment>
  2064. <foreign_key>false</foreign_key>
  2065. <not_null>false</not_null>
  2066. <primary_key>false</primary_key>
  2067. <unique_key>false</unique_key>
  2068. <character_set></character_set>
  2069. <collation></collation>
  2070. <sequence>
  2071. <name></name>
  2072. <schema></schema>
  2073. <increment></increment>
  2074. <min_value></min_value>
  2075. <max_value></max_value>
  2076. <start></start>
  2077. <cache></cache>
  2078. <cycle>false</cycle>
  2079. <order>false</order>
  2080. <description></description>
  2081. <data_type></data_type>
  2082. <decimal_size>0</decimal_size>
  2083. </sequence>
  2084. </normal_column>
  2085. <normal_column>
  2086. <word_id>8</word_id>
  2087. <id>44</id>
  2088. <description></description>
  2089. <unique_key_name></unique_key_name>
  2090. <logical_name></logical_name>
  2091. <physical_name></physical_name>
  2092. <type>varchar(n)</type>
  2093. <constraint></constraint>
  2094. <default_value></default_value>
  2095. <auto_increment>false</auto_increment>
  2096. <foreign_key>false</foreign_key>
  2097. <not_null>false</not_null>
  2098. <primary_key>false</primary_key>
  2099. <unique_key>false</unique_key>
  2100. <character_set></character_set>
  2101. <collation></collation>
  2102. <sequence>
  2103. <name></name>
  2104. <schema></schema>
  2105. <increment></increment>
  2106. <min_value></min_value>
  2107. <max_value></max_value>
  2108. <start></start>
  2109. <cache></cache>
  2110. <cycle>false</cycle>
  2111. <order>false</order>
  2112. <description></description>
  2113. <data_type></data_type>
  2114. <decimal_size>0</decimal_size>
  2115. </sequence>
  2116. </normal_column>
  2117. <normal_column>
  2118. <word_id>3</word_id>
  2119. <id>45</id>
  2120. <description></description>
  2121. <unique_key_name></unique_key_name>
  2122. <logical_name></logical_name>
  2123. <physical_name></physical_name>
  2124. <type>text</type>
  2125. <constraint></constraint>
  2126. <default_value></default_value>
  2127. <auto_increment>false</auto_increment>
  2128. <foreign_key>false</foreign_key>
  2129. <not_null>false</not_null>
  2130. <primary_key>false</primary_key>
  2131. <unique_key>false</unique_key>
  2132. <character_set></character_set>
  2133. <collation></collation>
  2134. <sequence>
  2135. <name></name>
  2136. <schema></schema>
  2137. <increment></increment>
  2138. <min_value></min_value>
  2139. <max_value></max_value>
  2140. <start></start>
  2141. <cache></cache>
  2142. <cycle>false</cycle>
  2143. <order>false</order>
  2144. <description></description>
  2145. <data_type></data_type>
  2146. <decimal_size>0</decimal_size>
  2147. </sequence>
  2148. </normal_column>
  2149. <column_group>0</column_group>
  2150. </columns>
  2151. <indexes>
  2152. <inidex>
  2153. <full_text>false</full_text>
  2154. <non_unique>true</non_unique>
  2155. <name>gen_template_del_falg</name>
  2156. <type></type>
  2157. <description></description>
  2158. <columns>
  2159. <column>
  2160. <id>5</id>
  2161. <desc>false</desc>
  2162. </column>
  2163. </columns>
  2164. </inidex>
  2165. </indexes>
  2166. <complex_unique_key_list>
  2167. </complex_unique_key_list>
  2168. <table_properties>
  2169. <schema></schema>
  2170. </table_properties>
  2171. </table>
  2172. </contents>
  2173. <column_groups>
  2174. <column_group>
  2175. <id>0</id>
  2176. <group_name>common</group_name>
  2177. <columns>
  2178. <normal_column>
  2179. <word_id>4</word_id>
  2180. <id>0</id>
  2181. <description></description>
  2182. <unique_key_name></unique_key_name>
  2183. <logical_name></logical_name>
  2184. <physical_name></physical_name>
  2185. <type>varchar(n)</type>
  2186. <constraint></constraint>
  2187. <default_value></default_value>
  2188. <auto_increment>false</auto_increment>
  2189. <foreign_key>false</foreign_key>
  2190. <not_null>false</not_null>
  2191. <primary_key>false</primary_key>
  2192. <unique_key>false</unique_key>
  2193. <character_set></character_set>
  2194. <collation></collation>
  2195. <sequence>
  2196. <name></name>
  2197. <schema></schema>
  2198. <increment></increment>
  2199. <min_value></min_value>
  2200. <max_value></max_value>
  2201. <start></start>
  2202. <cache></cache>
  2203. <cycle>false</cycle>
  2204. <order>false</order>
  2205. <description></description>
  2206. <data_type></data_type>
  2207. <decimal_size>0</decimal_size>
  2208. </sequence>
  2209. </normal_column>
  2210. <normal_column>
  2211. <word_id>5</word_id>
  2212. <id>1</id>
  2213. <description></description>
  2214. <unique_key_name></unique_key_name>
  2215. <logical_name></logical_name>
  2216. <physical_name></physical_name>
  2217. <type>datetime</type>
  2218. <constraint></constraint>
  2219. <default_value></default_value>
  2220. <auto_increment>false</auto_increment>
  2221. <foreign_key>false</foreign_key>
  2222. <not_null>false</not_null>
  2223. <primary_key>false</primary_key>
  2224. <unique_key>false</unique_key>
  2225. <character_set></character_set>
  2226. <collation></collation>
  2227. <sequence>
  2228. <name></name>
  2229. <schema></schema>
  2230. <increment></increment>
  2231. <min_value></min_value>
  2232. <max_value></max_value>
  2233. <start></start>
  2234. <cache></cache>
  2235. <cycle>false</cycle>
  2236. <order>false</order>
  2237. <description></description>
  2238. <data_type></data_type>
  2239. <decimal_size>0</decimal_size>
  2240. </sequence>
  2241. </normal_column>
  2242. <normal_column>
  2243. <word_id>35</word_id>
  2244. <id>2</id>
  2245. <description></description>
  2246. <unique_key_name></unique_key_name>
  2247. <logical_name></logical_name>
  2248. <physical_name></physical_name>
  2249. <type>varchar(n)</type>
  2250. <constraint></constraint>
  2251. <default_value></default_value>
  2252. <auto_increment>false</auto_increment>
  2253. <foreign_key>false</foreign_key>
  2254. <not_null>false</not_null>
  2255. <primary_key>false</primary_key>
  2256. <unique_key>false</unique_key>
  2257. <character_set></character_set>
  2258. <collation></collation>
  2259. <sequence>
  2260. <name></name>
  2261. <schema></schema>
  2262. <increment></increment>
  2263. <min_value></min_value>
  2264. <max_value></max_value>
  2265. <start></start>
  2266. <cache></cache>
  2267. <cycle>false</cycle>
  2268. <order>false</order>
  2269. <description></description>
  2270. <data_type></data_type>
  2271. <decimal_size>0</decimal_size>
  2272. </sequence>
  2273. </normal_column>
  2274. <normal_column>
  2275. <word_id>36</word_id>
  2276. <id>3</id>
  2277. <description></description>
  2278. <unique_key_name></unique_key_name>
  2279. <logical_name></logical_name>
  2280. <physical_name></physical_name>
  2281. <type>datetime</type>
  2282. <constraint></constraint>
  2283. <default_value></default_value>
  2284. <auto_increment>false</auto_increment>
  2285. <foreign_key>false</foreign_key>
  2286. <not_null>false</not_null>
  2287. <primary_key>false</primary_key>
  2288. <unique_key>false</unique_key>
  2289. <character_set></character_set>
  2290. <collation></collation>
  2291. <sequence>
  2292. <name></name>
  2293. <schema></schema>
  2294. <increment></increment>
  2295. <min_value></min_value>
  2296. <max_value></max_value>
  2297. <start></start>
  2298. <cache></cache>
  2299. <cycle>false</cycle>
  2300. <order>false</order>
  2301. <description></description>
  2302. <data_type></data_type>
  2303. <decimal_size>0</decimal_size>
  2304. </sequence>
  2305. </normal_column>
  2306. <normal_column>
  2307. <word_id>30</word_id>
  2308. <id>4</id>
  2309. <description></description>
  2310. <unique_key_name></unique_key_name>
  2311. <logical_name></logical_name>
  2312. <physical_name></physical_name>
  2313. <type>nvarchar(n)</type>
  2314. <constraint></constraint>
  2315. <default_value></default_value>
  2316. <auto_increment>false</auto_increment>
  2317. <foreign_key>false</foreign_key>
  2318. <not_null>false</not_null>
  2319. <primary_key>false</primary_key>
  2320. <unique_key>false</unique_key>
  2321. <character_set></character_set>
  2322. <collation></collation>
  2323. <sequence>
  2324. <name></name>
  2325. <schema></schema>
  2326. <increment></increment>
  2327. <min_value></min_value>
  2328. <max_value></max_value>
  2329. <start></start>
  2330. <cache></cache>
  2331. <cycle>false</cycle>
  2332. <order>false</order>
  2333. <description></description>
  2334. <data_type></data_type>
  2335. <decimal_size>0</decimal_size>
  2336. </sequence>
  2337. </normal_column>
  2338. <normal_column>
  2339. <word_id>6</word_id>
  2340. <id>5</id>
  2341. <description></description>
  2342. <unique_key_name></unique_key_name>
  2343. <logical_name></logical_name>
  2344. <physical_name></physical_name>
  2345. <type>character(n)</type>
  2346. <constraint></constraint>
  2347. <default_value>0</default_value>
  2348. <auto_increment>false</auto_increment>
  2349. <foreign_key>false</foreign_key>
  2350. <not_null>true</not_null>
  2351. <primary_key>false</primary_key>
  2352. <unique_key>false</unique_key>
  2353. <character_set></character_set>
  2354. <collation></collation>
  2355. <sequence>
  2356. <name></name>
  2357. <schema></schema>
  2358. <increment></increment>
  2359. <min_value></min_value>
  2360. <max_value></max_value>
  2361. <start></start>
  2362. <cache></cache>
  2363. <cycle>false</cycle>
  2364. <order>false</order>
  2365. <description></description>
  2366. <data_type></data_type>
  2367. <decimal_size>0</decimal_size>
  2368. </sequence>
  2369. </normal_column>
  2370. </columns>
  2371. </column_group>
  2372. </column_groups>
  2373. <test_data_list>
  2374. </test_data_list>
  2375. <sequence_set>
  2376. </sequence_set>
  2377. <trigger_set>
  2378. </trigger_set>
  2379. <change_tracking_list>
  2380. </change_tracking_list>
  2381. </diagram>