zheng.svg 34 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328
  1. <?xml version="1.0" encoding="UTF-8" standalone="no" ?>
  2. <!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN" "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
  3. <svg width="311mm" xmlns="http://www.w3.org/2000/svg" height="142mm" version="1.1" viewBox="0 0 1176 539" xmlns:xlink="http://www.w3.org/1999/xlink">
  4. <polyline fill="none" points="844,147 844,331" stroke="#0080c0" stroke-width="1"/>
  5. <polygon fill="#0080c0" points="844,331 841,318 847,318" stroke="#0080c0" stroke-width="1" stroke-linejoin="miter"/>
  6. <polyline fill="none" points="551,399 584,399" stroke="#0080c0" stroke-width="1"/>
  7. <polygon fill="#0080c0" points="584,399 571,402 571,396" stroke="#0080c0" stroke-width="1" stroke-linejoin="miter"/>
  8. <polyline fill="none" points="325,412 290,412" stroke="#0080c0" stroke-width="1"/>
  9. <polygon fill="#0080c0" points="290,412 303,409 303,415" stroke="#0080c0" stroke-width="1" stroke-linejoin="miter"/>
  10. <polyline fill="none" points="381,237 381,160" stroke="#0080c0" stroke-width="1"/>
  11. <polygon fill="#0080c0" points="381,160 384,174 378,174" stroke="#0080c0" stroke-width="1" stroke-linejoin="miter"/>
  12. <polyline fill="none" points="282,291 282,358" stroke="#0080c0" stroke-width="1"/>
  13. <polygon fill="#0080c0" points="282,358 279,345 285,345" stroke="#0080c0" stroke-width="1" stroke-linejoin="miter"/>
  14. <polyline fill="none" points="478,239 478,160" stroke="#0080c0" stroke-width="1"/>
  15. <polygon fill="#0080c0" points="478,160 481,174 475,174" stroke="#0080c0" stroke-width="1" stroke-linejoin="miter"/>
  16. <polyline fill="none" points="626,292 626,331" stroke="#0080c0" stroke-width="1"/>
  17. <polygon fill="#0080c0" points="626,331 623,318 629,318" stroke="#0080c0" stroke-width="1" stroke-linejoin="miter"/>
  18. <polyline fill="none" points="174,56 174,96" stroke="#0080c0" stroke-width="1"/>
  19. <polygon fill="#0080c0" points="174,96 171,83 177,83" stroke="#0080c0" stroke-width="1" stroke-linejoin="miter"/>
  20. <polyline fill="none" points="1097,29 1097,13 1168,13 1168,60 1123,60" stroke="#0080c0" stroke-width="1"/>
  21. <polygon fill="#0080c0" points="1123,60 1136,57 1136,63" stroke="#0080c0" stroke-width="1" stroke-linejoin="miter"/>
  22. <polyline fill="none" points="598,31 598,11 673,11 673,63 629,63" stroke="#0080c0" stroke-width="1"/>
  23. <polygon fill="#0080c0" points="629,63 642,60 642,66" stroke="#0080c0" stroke-width="1" stroke-linejoin="miter"/>
  24. <rect x="78" y="2" fill="#ffffff" width="0" height="0" stroke="none" stroke-width="0"/>
  25. <defs>
  26. <linearGradient id="Gradient1" x1="0%" x2="100%" y1="0%" y2="100%" gradientUnits="objectBoundingBox">
  27. <stop offset="5%" stop-color="#ffffff"/>
  28. <stop offset="95%" stop-color="#b2d6fc"/>
  29. </linearGradient>
  30. </defs>
  31. <rect x="78" y="2" fill="url(#Gradient1)" width="198" height="54" stroke="#0080c0" stroke-width="1"/>
  32. <text x="177" y="12" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-anchor="middle">test_book 书</text>
  33. <line x1="78" x2="276" y1="17" y2="17" stroke="#0080c0" stroke-width="1"/>
  34. <text x="83" y="27" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">book_id</text>
  35. <text x="83" y="38" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">user_id</text>
  36. <text x="83" y="49" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">name</text>
  37. <text x="126" y="27" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">int(10)</text>
  38. <text x="126" y="38" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">int(10)</text>
  39. <text x="126" y="49" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">varchar(45)</text>
  40. <text x="189" y="27" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">编号</text>
  41. <text x="189" y="38" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">用户编号</text>
  42. <text x="189" y="49" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">书名</text>
  43. <text x="237" y="27" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">&lt;pk&gt;</text>
  44. <text x="237" y="38" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">&lt;ak,fk&gt;</text>
  45. <rect x="584" y="331" fill="#ffffff" width="0" height="0" stroke="none" stroke-width="0"/>
  46. <defs>
  47. <linearGradient id="Gradient2" x1="0%" x2="100%" y1="0%" y2="100%" gradientUnits="objectBoundingBox">
  48. <stop offset="5%" stop-color="#ffffff"/>
  49. <stop offset="95%" stop-color="#b2d6fc"/>
  50. </linearGradient>
  51. </defs>
  52. <rect x="584" y="331" fill="url(#Gradient2)" width="519" height="206" stroke="#0080c0" stroke-width="1"/>
  53. <text x="843" y="341" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-anchor="middle">cms_article 文章表</text>
  54. <line x1="584" x2="1103" y1="346" y2="346" stroke="#0080c0" stroke-width="1"/>
  55. <text x="589" y="356" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">article_id</text>
  56. <text x="589" y="367" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">title</text>
  57. <text x="589" y="378" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">author</text>
  58. <text x="589" y="389" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">fromurl</text>
  59. <text x="589" y="400" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">image</text>
  60. <text x="589" y="411" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">keywords</text>
  61. <text x="589" y="422" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">description</text>
  62. <text x="589" y="433" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">type</text>
  63. <text x="589" y="444" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">allowcomments</text>
  64. <text x="589" y="455" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">status</text>
  65. <text x="589" y="466" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">content</text>
  66. <text x="589" y="477" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">user_id</text>
  67. <text x="589" y="488" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">up</text>
  68. <text x="589" y="499" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">down</text>
  69. <text x="589" y="510" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">readnumber</text>
  70. <text x="589" y="521" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">ctime</text>
  71. <text x="589" y="532" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">orders</text>
  72. <text x="662" y="356" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">int(10)</text>
  73. <text x="662" y="367" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">varchar(200)</text>
  74. <text x="662" y="378" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">varchar(50)</text>
  75. <text x="662" y="389" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">varchar(300)</text>
  76. <text x="662" y="400" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">varchar(300)</text>
  77. <text x="662" y="411" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">varchar(100)</text>
  78. <text x="662" y="422" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">varchar(500)</text>
  79. <text x="662" y="433" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">tinyint(4)</text>
  80. <text x="662" y="444" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">tinyint(4)</text>
  81. <text x="662" y="455" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">tinyint(4)</text>
  82. <text x="662" y="466" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">mediumtext</text>
  83. <text x="662" y="477" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">int(10)</text>
  84. <text x="662" y="488" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">int(10)</text>
  85. <text x="662" y="499" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">int(10)</text>
  86. <text x="662" y="510" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">int(10)</text>
  87. <text x="662" y="521" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">bigint(20)</text>
  88. <text x="662" y="532" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">bigint(20)</text>
  89. <text x="730" y="356" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">编号</text>
  90. <text x="730" y="367" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">文章标题</text>
  91. <text x="730" y="378" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">文章原作者</text>
  92. <text x="730" y="389" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">转载来源网址</text>
  93. <text x="730" y="400" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">封面图</text>
  94. <text x="730" y="411" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">关键字</text>
  95. <text x="730" y="422" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">简介</text>
  96. <text x="730" y="433" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">类型(1:普通,2:热门...)</text>
  97. <text x="730" y="444" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">是否允许评论(0:不允许,1:允许)</text>
  98. <text x="730" y="455" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">状态(-1:审核不通过回收站,0:刚发布未审核,1:已审核公开,2:已审核个人)</text>
  99. <text x="730" y="466" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">内容</text>
  100. <text x="730" y="477" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">发布人id</text>
  101. <text x="730" y="488" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">顶</text>
  102. <text x="730" y="499" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">踩</text>
  103. <text x="730" y="510" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">阅读数量</text>
  104. <text x="730" y="521" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">创建时间</text>
  105. <text x="730" y="532" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">排序</text>
  106. <text x="1068" y="356" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">&lt;pk&gt;</text>
  107. <text x="1068" y="532" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">&lt;ak&gt;</text>
  108. <rect x="459" y="239" fill="#ffffff" width="0" height="0" stroke="none" stroke-width="0"/>
  109. <defs>
  110. <linearGradient id="Gradient3" x1="0%" x2="100%" y1="0%" y2="100%" gradientUnits="objectBoundingBox">
  111. <stop offset="5%" stop-color="#ffffff"/>
  112. <stop offset="95%" stop-color="#c0c0c0"/>
  113. </linearGradient>
  114. </defs>
  115. <rect x="459" y="239" fill="url(#Gradient3)" width="251" height="53" stroke="#0080c0" stroke-width="1"/>
  116. <text x="584" y="249" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-anchor="middle">cms_article_category 文章类目关联表</text>
  117. <line x1="459" x2="710" y1="254" y2="254" stroke="#0080c0" stroke-width="1"/>
  118. <text x="463" y="264" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">article_category_id</text>
  119. <text x="463" y="275" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">article_id</text>
  120. <text x="463" y="286" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">category_id</text>
  121. <text x="566" y="264" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">int(10)</text>
  122. <text x="566" y="275" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">int(10)</text>
  123. <text x="566" y="286" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">int(10)</text>
  124. <text x="609" y="264" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">编号</text>
  125. <text x="609" y="275" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">文章编号</text>
  126. <text x="609" y="286" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">类目编号</text>
  127. <text x="657" y="264" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">&lt;pk&gt;</text>
  128. <text x="657" y="275" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">&lt;ak1,fk2&gt;</text>
  129. <text x="657" y="286" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">&lt;ak2,fk1&gt;</text>
  130. <rect x="325" y="372" fill="#ffffff" width="0" height="0" stroke="none" stroke-width="0"/>
  131. <defs>
  132. <linearGradient id="Gradient4" x1="0%" x2="100%" y1="0%" y2="100%" gradientUnits="objectBoundingBox">
  133. <stop offset="5%" stop-color="#ffffff"/>
  134. <stop offset="95%" stop-color="#c0c0c0"/>
  135. </linearGradient>
  136. </defs>
  137. <rect x="325" y="372" fill="url(#Gradient4)" width="226" height="54" stroke="#0080c0" stroke-width="1"/>
  138. <text x="438" y="382" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-anchor="middle">cms_article_tag 文章标签关联表</text>
  139. <line x1="325" x2="551" y1="387" y2="387" stroke="#0080c0" stroke-width="1"/>
  140. <text x="330" y="397" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">article_tag_id</text>
  141. <text x="330" y="408" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">article_id</text>
  142. <text x="330" y="419" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">tag_id</text>
  143. <text x="408" y="397" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">int(10)</text>
  144. <text x="408" y="408" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">int(10)</text>
  145. <text x="408" y="419" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">int(10)</text>
  146. <text x="451" y="397" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">编号</text>
  147. <text x="451" y="408" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">文章编号</text>
  148. <text x="451" y="419" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">标签编号</text>
  149. <text x="499" y="397" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">&lt;pk&gt;</text>
  150. <text x="499" y="408" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">&lt;ak1,fk1&gt;</text>
  151. <text x="499" y="419" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">&lt;ak2,fk2&gt;</text>
  152. <rect x="326" y="31" fill="#ffffff" width="0" height="0" stroke="none" stroke-width="0"/>
  153. <defs>
  154. <linearGradient id="Gradient5" x1="0%" x2="100%" y1="0%" y2="100%" gradientUnits="objectBoundingBox">
  155. <stop offset="5%" stop-color="#ffffff"/>
  156. <stop offset="95%" stop-color="#b2d6fc"/>
  157. </linearGradient>
  158. </defs>
  159. <rect x="326" y="31" fill="url(#Gradient5)" width="303" height="129" stroke="#0080c0" stroke-width="1"/>
  160. <text x="477" y="41" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-anchor="middle">cms_category 类目表</text>
  161. <line x1="326" x2="629" y1="46" y2="46" stroke="#0080c0" stroke-width="1"/>
  162. <text x="331" y="56" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">category_id</text>
  163. <text x="331" y="67" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">pid</text>
  164. <text x="331" y="78" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">level</text>
  165. <text x="331" y="89" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">name</text>
  166. <text x="331" y="100" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">description</text>
  167. <text x="331" y="111" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">icon</text>
  168. <text x="331" y="122" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">type</text>
  169. <text x="331" y="133" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">alias</text>
  170. <text x="331" y="144" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">ctime</text>
  171. <text x="331" y="155" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">orders</text>
  172. <text x="394" y="56" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">int(10)</text>
  173. <text x="394" y="67" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">int(10)</text>
  174. <text x="394" y="78" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">tinyint(3)</text>
  175. <text x="394" y="89" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">varchar(20)</text>
  176. <text x="394" y="100" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">varchar(200)</text>
  177. <text x="394" y="111" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">varchar(50)</text>
  178. <text x="394" y="122" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">tinyint(3)</text>
  179. <text x="394" y="133" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">varchar(20)</text>
  180. <text x="394" y="144" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">bigint(20)</text>
  181. <text x="394" y="155" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">bigint(255)</text>
  182. <text x="462" y="56" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">编号</text>
  183. <text x="462" y="67" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">上级编号</text>
  184. <text x="462" y="78" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">层级</text>
  185. <text x="462" y="89" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">名称</text>
  186. <text x="462" y="100" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">描述</text>
  187. <text x="462" y="111" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">图标</text>
  188. <text x="462" y="122" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">类型(1:普通,2:热门...)</text>
  189. <text x="462" y="133" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">别名</text>
  190. <text x="462" y="144" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">创建时间</text>
  191. <text x="462" y="155" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">排序</text>
  192. <text x="580" y="56" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">&lt;pk&gt;</text>
  193. <text x="580" y="67" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">&lt;ak2,fk&gt;</text>
  194. <text x="580" y="78" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">&lt;ak4&gt;</text>
  195. <text x="580" y="133" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">&lt;ak3&gt;</text>
  196. <text x="580" y="155" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">&lt;ak1&gt;</text>
  197. <rect x="198" y="237" fill="#ffffff" width="0" height="0" stroke="none" stroke-width="0"/>
  198. <defs>
  199. <linearGradient id="Gradient6" x1="0%" x2="100%" y1="0%" y2="100%" gradientUnits="objectBoundingBox">
  200. <stop offset="5%" stop-color="#ffffff"/>
  201. <stop offset="95%" stop-color="#c0c0c0"/>
  202. </linearGradient>
  203. </defs>
  204. <rect x="198" y="237" fill="url(#Gradient6)" width="231" height="54" stroke="#0080c0" stroke-width="1"/>
  205. <text x="313" y="247" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-anchor="middle">cms_category_tag 类目标签关联表</text>
  206. <line x1="198" x2="429" y1="252" y2="252" stroke="#0080c0" stroke-width="1"/>
  207. <text x="203" y="262" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">category_tag_id</text>
  208. <text x="203" y="273" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">category_id</text>
  209. <text x="203" y="284" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">tag_id</text>
  210. <text x="286" y="262" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">int(10)</text>
  211. <text x="286" y="273" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">int(10)</text>
  212. <text x="286" y="284" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">int(10)</text>
  213. <text x="329" y="262" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">编号</text>
  214. <text x="329" y="273" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">类目编号</text>
  215. <text x="329" y="284" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">标签编号</text>
  216. <text x="377" y="262" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">&lt;pk&gt;</text>
  217. <text x="377" y="273" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">&lt;ak2,fk1&gt;</text>
  218. <text x="377" y="284" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">&lt;ak1,fk2&gt;</text>
  219. <rect x="727" y="29" fill="#ffffff" width="0" height="0" stroke="none" stroke-width="0"/>
  220. <defs>
  221. <linearGradient id="Gradient7" x1="0%" x2="100%" y1="0%" y2="100%" gradientUnits="objectBoundingBox">
  222. <stop offset="5%" stop-color="#ffffff"/>
  223. <stop offset="95%" stop-color="#b2d6fc"/>
  224. </linearGradient>
  225. </defs>
  226. <rect x="727" y="29" fill="url(#Gradient7)" width="396" height="118" stroke="#0080c0" stroke-width="1"/>
  227. <text x="925" y="39" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-anchor="middle">cms_comment 评论表</text>
  228. <line x1="727" x2="1123" y1="44" y2="44" stroke="#0080c0" stroke-width="1"/>
  229. <text x="731" y="54" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">comment_id</text>
  230. <text x="731" y="65" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">pid</text>
  231. <text x="731" y="76" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">article_id</text>
  232. <text x="731" y="87" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">user_id</text>
  233. <text x="731" y="98" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">content</text>
  234. <text x="731" y="109" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">status</text>
  235. <text x="731" y="120" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">ip</text>
  236. <text x="731" y="131" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">agent</text>
  237. <text x="731" y="142" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">ctime</text>
  238. <text x="789" y="54" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">int(10)</text>
  239. <text x="789" y="65" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">int(10)</text>
  240. <text x="789" y="76" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">int(10)</text>
  241. <text x="789" y="87" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">int(10)</text>
  242. <text x="789" y="98" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">text</text>
  243. <text x="789" y="109" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">tinyint(4)</text>
  244. <text x="789" y="120" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">varchar(30)</text>
  245. <text x="789" y="131" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">varchar(200)</text>
  246. <text x="789" y="142" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">bigint(20)</text>
  247. <text x="857" y="54" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">编号</text>
  248. <text x="857" y="65" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">回复楼中楼编号回复楼中楼编号</text>
  249. <text x="857" y="76" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">文章编号</text>
  250. <text x="857" y="87" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">用户编号</text>
  251. <text x="857" y="98" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">评论内容</text>
  252. <text x="857" y="109" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">状态(-1:审核不通过,0:未审核,1:已审核通过)</text>
  253. <text x="857" y="120" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">评论人ip地址</text>
  254. <text x="857" y="131" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">评论人终端信息</text>
  255. <text x="857" y="142" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">创建时间</text>
  256. <text x="1070" y="54" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">&lt;pk&gt;</text>
  257. <text x="1070" y="65" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">&lt;fk2&gt;</text>
  258. <text x="1070" y="76" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">&lt;ak,fk1&gt;</text>
  259. <rect x="2" y="358" fill="#ffffff" width="0" height="0" stroke="none" stroke-width="0"/>
  260. <defs>
  261. <linearGradient id="Gradient8" x1="0%" x2="100%" y1="0%" y2="100%" gradientUnits="objectBoundingBox">
  262. <stop offset="5%" stop-color="#ffffff"/>
  263. <stop offset="95%" stop-color="#b2d6fc"/>
  264. </linearGradient>
  265. </defs>
  266. <rect x="2" y="358" fill="url(#Gradient8)" width="288" height="107" stroke="#0080c0" stroke-width="1"/>
  267. <text x="146" y="368" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-anchor="middle">cms_tag 标签表</text>
  268. <line x1="2" x2="290" y1="373" y2="373" stroke="#0080c0" stroke-width="1"/>
  269. <text x="7" y="383" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">tag_id</text>
  270. <text x="7" y="394" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">name</text>
  271. <text x="7" y="405" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">description</text>
  272. <text x="7" y="416" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">icon</text>
  273. <text x="7" y="427" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">type</text>
  274. <text x="7" y="438" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">alias</text>
  275. <text x="7" y="449" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">ctime</text>
  276. <text x="7" y="460" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">orders</text>
  277. <text x="70" y="383" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">int(10)</text>
  278. <text x="70" y="394" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">varchar(20)</text>
  279. <text x="70" y="405" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">varchar(200)</text>
  280. <text x="70" y="416" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">varchar(50)</text>
  281. <text x="70" y="427" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">tinyint(4)</text>
  282. <text x="70" y="438" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">varchar(20)</text>
  283. <text x="70" y="449" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">bigint(20)</text>
  284. <text x="70" y="460" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">bigint(20)</text>
  285. <text x="138" y="383" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">编号</text>
  286. <text x="138" y="394" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">名称</text>
  287. <text x="138" y="405" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">描述</text>
  288. <text x="138" y="416" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">图标</text>
  289. <text x="138" y="427" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">类型(1:普通,2:热门...)</text>
  290. <text x="138" y="438" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">别名</text>
  291. <text x="138" y="449" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">创建时间</text>
  292. <text x="138" y="460" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">排序</text>
  293. <text x="256" y="383" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">&lt;pk&gt;</text>
  294. <text x="256" y="438" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">&lt;ak2&gt;</text>
  295. <text x="256" y="460" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">&lt;ak1&gt;</text>
  296. <rect x="79" y="96" fill="#ffffff" width="0" height="0" stroke="none" stroke-width="0"/>
  297. <defs>
  298. <linearGradient id="Gradient9" x1="0%" x2="100%" y1="0%" y2="100%" gradientUnits="objectBoundingBox">
  299. <stop offset="5%" stop-color="#ffffff"/>
  300. <stop offset="95%" stop-color="#b2d6fc"/>
  301. </linearGradient>
  302. </defs>
  303. <rect x="79" y="96" fill="url(#Gradient9)" width="190" height="96" stroke="#0080c0" stroke-width="1"/>
  304. <text x="174" y="106" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-anchor="middle">test_user 用户</text>
  305. <line x1="79" x2="269" y1="111" y2="111" stroke="#0080c0" stroke-width="1"/>
  306. <text x="84" y="121" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">user_id</text>
  307. <text x="84" y="132" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">username</text>
  308. <text x="84" y="143" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">password</text>
  309. <text x="84" y="154" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">nickname</text>
  310. <text x="84" y="165" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">sex</text>
  311. <text x="84" y="176" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">ctime</text>
  312. <text x="84" y="187" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">content</text>
  313. <text x="132" y="121" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">int(10)</text>
  314. <text x="132" y="132" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">varchar(32)</text>
  315. <text x="132" y="143" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">varchar(32)</text>
  316. <text x="132" y="154" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">varchar(32)</text>
  317. <text x="132" y="165" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">int(11)</text>
  318. <text x="132" y="176" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">bigint(20)</text>
  319. <text x="132" y="187" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">text</text>
  320. <text x="195" y="121" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">编号</text>
  321. <text x="195" y="132" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">账号</text>
  322. <text x="195" y="143" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">密码</text>
  323. <text x="195" y="154" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">昵称</text>
  324. <text x="195" y="165" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">性别</text>
  325. <text x="195" y="176" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">创建时间</text>
  326. <text x="195" y="187" fill="#000000" font-size="10" font-family="'Arial Unicode MS','新宋体'">备注</text>
  327. <text x="243" y="121" fill="#ff0000" font-size="10" font-family="'Arial Unicode MS','新宋体'" text-decoration="underline">&lt;pk&gt;</text>
  328. </svg>