Home Explore Help
Register Sign In
didong
/
owl-admin
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 1dc6cedad5
Branches Tags
owl-admin
/
doc
/
系统设计
/
数据库设计
/
物理模型
/
数据库设计过程规划.html

数据库设计过程规划.html 29 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499 
  1. <!DOCTYPE html><html><head>
    2. 

  2.       <title>数据库设计过程规划</title>
    3. 

  3.       <meta charset="utf-8">
    4. 

  4.       <meta name="viewport" content="width=device-width, initial-scale=1.0">
    5. 

  5.       
    6. 

  6.       <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/katex@0.16.11/dist/katex.min.css">
    7. 

  7.       
    8. 

  8.       
    9. 

  9.       
    10. 

  10.       
    11. 

  11.       
    12. 

  12.       <style>
    13. 

  13.       pre{font-family:Menlo,Monaco,Consolas,'Courier New',monospace;direction:ltr;text-align:left;white-space:pre;word-spacing:normal;word-break:normal;padding:1em;margin:.5em 0;overflow:auto;line-height:1.5;tab-size:4;hyphens:none;color:#555;background-color:#f0f0f0!important;border:#d6d6d6;border-radius:3px}pre[class*=language-]{padding:1em}code[class*=language-] .token.cdata,code[class*=language-] .token.comment,code[class*=language-] .token.doctype,code[class*=language-] .token.prolog,pre[class*=language-] .token.cdata,pre[class*=language-] .token.comment,pre[class*=language-] .token.doctype,pre[class*=language-] .token.prolog{color:#998;font-style:italic}code[class*=language-] .token.punctuation,pre[class*=language-] .token.punctuation{color:#920b2d}code[class*=language-] .namespace,pre[class*=language-] .namespace{opacity:.7}code[class*=language-] .token.property,pre[class*=language-] .token.property{font-weight:700;color:#333}code[class*=language-] .token.boolean,code[class*=language-] .token.function-name,code[class*=language-] .token.number,pre[class*=language-] .token.boolean,pre[class*=language-] .token.function-name,pre[class*=language-] .token.number{color:#d14}code[class*=language-] .token.tag,pre[class*=language-] .token.tag{color:#d14}code[class*=language-] .token.symbol,pre[class*=language-] .token.symbol{color:#990073}code[class*=language-] .token.selector,pre[class*=language-] .token.selector{color:teal}code[class*=language-] .token.attr-name,pre[class*=language-] .token.attr-name{color:#458;font-weight:700}code[class*=language-] .token.string,pre[class*=language-] .token.string{color:#d14}code[class*=language-] .token.char,pre[class*=language-] .token.char{color:#606aa1}code[class*=language-] .token.url,pre[class*=language-] .token.url{color:#888}code[class*=language-] .token.atrule,code[class*=language-] .token.attr-value,code[class*=language-] .token.keyword,pre[class*=language-] .token.atrule,pre[class*=language-] .token.attr-value,pre[class*=language-] .token.keyword{color:#222;font-weight:700}code[class*=language-] .token.function,pre[class*=language-] .token.function{color:#900}code[class*=language-] .token.class-name,pre[class*=language-] .token.class-name{text-decoration:underline;color:#606aa1}code[class*=language-] .token.variable,pre[class*=language-] .token.variable{color:teal}code[class*=language-] .token.bold,code[class*=language-] .token.important,pre[class*=language-] .token.bold,pre[class*=language-] .token.important{font-weight:700}code[class*=language-] .token.italic,pre[class*=language-] .token.italic{font-style:italic}code[class*=language-] .token.entity,pre[class*=language-] .token.entity{cursor:help}pre[data-line]{position:relative;padding:1em 0 1em 3em}pre[data-line] .line-highlight-wrapper{position:absolute;top:0;left:0;background-color:transparent;display:block;width:100%}pre[data-line] .line-highlight{position:absolute;left:0;right:0;padding:inherit 0;margin-top:1em;background:hsla(24,20%,50%,.08);background:linear-gradient(to right,hsla(24,20%,50%,.1) 70%,hsla(24,20%,50%,0));pointer-events:none;line-height:inherit;white-space:pre}pre[data-line] .line-highlight:before,pre[data-line] .line-highlight[data-end]:after{content:attr(data-start);position:absolute;top:.4em;left:.6em;min-width:1em;padding:0 .5em;background-color:hsla(24,20%,50%,.4);color:#f4f1ef;font:bold 65%/1.5 sans-serif;text-align:center;vertical-align:.3em;border-radius:999px;text-shadow:none;box-shadow:0 1px #fff}pre[data-line] .line-highlight[data-end]:after{content:attr(data-end);top:auto;bottom:.4em}html body{font-family:'Helvetica Neue',Helvetica,'Segoe UI',Arial,freesans,sans-serif;font-size:16px;line-height:1.6;color:#555;background-color:#fff;overflow:initial;box-sizing:border-box;word-wrap:break-word}html body>:first-child{margin-top:0}html body h1,html body h2,html body h3,html body h4,html body h5,html body h6{line-height:1.2;margin-top:1em;margin-bottom:16px;color:#030303}html body h1{font-size:2.25em;font-weight:300;padding-bottom:.3em}html body h2{font-size:1.75em;font-weight:400;padding-bottom:.3em}html body h3{font-size:1.5em;font-weight:500}html body h4{font-size:1.25em;font-weight:600}html body h5{font-size:1.1em;font-weight:600}html body h6{font-size:1em;font-weight:600}html body h1,html body h2,html body h3,html body h4,html body h5{font-weight:600}html body h5{font-size:1em}html body h6{color:#7e7e7e}html body strong{color:#030303}html body del{color:#7e7e7e}html body a:not([href]){color:inherit;text-decoration:none}html body a{color:#08c;text-decoration:none}html body a:hover{color:#00a3f5;text-decoration:none}html body img{max-width:100%}html body>p{margin-top:0;margin-bottom:16px;word-wrap:break-word}html body>ol,html body>ul{margin-bottom:16px}html body ol,html body ul{padding-left:2em}html body ol.no-list,html body ul.no-list{padding:0;list-style-type:none}html body ol ol,html body ol ul,html body ul ol,html body ul ul{margin-top:0;margin-bottom:0}html body li{margin-bottom:0}html body li.task-list-item{list-style:none}html body li>p{margin-top:0;margin-bottom:0}html body .task-list-item-checkbox{margin:0 .2em .25em -1.8em;vertical-align:middle}html body .task-list-item-checkbox:hover{cursor:pointer}html body blockquote{margin:16px 0;font-size:inherit;padding:0 15px;color:#7e7e7e;background-color:#f0f0f0;border-left:4px solid #d6d6d6}html body blockquote>:first-child{margin-top:0}html body blockquote>:last-child{margin-bottom:0}html body hr{height:4px;margin:32px 0;background-color:#d6d6d6;border:0 none}html body table{margin:10px 0 15px 0;border-collapse:collapse;border-spacing:0;display:block;width:100%;overflow:auto;word-break:normal;word-break:keep-all}html body table th{font-weight:700;color:#030303}html body table td,html body table th{border:1px solid #d6d6d6;padding:6px 13px}html body dl{padding:0}html body dl dt{padding:0;margin-top:16px;font-size:1em;font-style:italic;font-weight:700}html body dl dd{padding:0 16px;margin-bottom:16px}html body code{font-family:Menlo,Monaco,Consolas,'Courier New',monospace;font-size:.85em;color:#030303;background-color:#f0f0f0;border-radius:3px;padding:.2em 0}html body code::after,html body code::before{letter-spacing:-.2em;content:'\00a0'}html body pre>code{padding:0;margin:0;word-break:normal;white-space:pre;background:0 0;border:0}html body .highlight{margin-bottom:16px}html body .highlight pre,html body pre{padding:1em;overflow:auto;line-height:1.45;border:#d6d6d6;border-radius:3px}html body .highlight pre{margin-bottom:0;word-break:normal}html body pre code,html body pre tt{display:inline;max-width:initial;padding:0;margin:0;overflow:initial;line-height:inherit;word-wrap:normal;background-color:transparent;border:0}html body pre code:after,html body pre code:before,html body pre tt:after,html body pre tt:before{content:normal}html body blockquote,html body dl,html body ol,html body p,html body pre,html body ul{margin-top:0;margin-bottom:16px}html body kbd{color:#030303;border:1px solid #d6d6d6;border-bottom:2px solid #c7c7c7;padding:2px 4px;background-color:#f0f0f0;border-radius:3px}@media print{html body{background-color:#fff}html body h1,html body h2,html body h3,html body h4,html body h5,html body h6{color:#030303;page-break-after:avoid}html body blockquote{color:#7e7e7e}html body pre{page-break-inside:avoid}html body table{display:table}html body img{display:block;max-width:100%;max-height:100%}html body code,html body pre{word-wrap:break-word;white-space:pre}}.markdown-preview{width:100%;height:100%;box-sizing:border-box}.markdown-preview ul{list-style:disc}.markdown-preview ul ul{list-style:circle}.markdown-preview ul ul ul{list-style:square}.markdown-preview ol{list-style:decimal}.markdown-preview ol ol,.markdown-preview ul ol{list-style-type:lower-roman}.markdown-preview ol ol ol,.markdown-preview ol ul ol,.markdown-preview ul ol ol,.markdown-preview ul ul ol{list-style-type:lower-alpha}.markdown-preview .newpage,.markdown-preview .pagebreak{page-break-before:always}.markdown-preview pre.line-numbers{position:relative;padding-left:3.8em;counter-reset:linenumber}.markdown-preview pre.line-numbers>code{position:relative}.markdown-preview pre.line-numbers .line-numbers-rows{position:absolute;pointer-events:none;top:1em;font-size:100%;left:0;width:3em;letter-spacing:-1px;border-right:1px solid #999;-webkit-user-select:none;-moz-user-select:none;-ms-user-select:none;user-select:none}.markdown-preview pre.line-numbers .line-numbers-rows>span{pointer-events:none;display:block;counter-increment:linenumber}.markdown-preview pre.line-numbers .line-numbers-rows>span:before{content:counter(linenumber);color:#999;display:block;padding-right:.8em;text-align:right}.markdown-preview .mathjax-exps .MathJax_Display{text-align:center!important}.markdown-preview:not([data-for=preview]) .code-chunk .code-chunk-btn-group{display:none}.markdown-preview:not([data-for=preview]) .code-chunk .status{display:none}.markdown-preview:not([data-for=preview]) .code-chunk .output-div{margin-bottom:16px}.markdown-preview .md-toc{padding:0}.markdown-preview .md-toc .md-toc-link-wrapper .md-toc-link{display:inline;padding:.25rem 0}.markdown-preview .md-toc .md-toc-link-wrapper .md-toc-link div,.markdown-preview .md-toc .md-toc-link-wrapper .md-toc-link p{display:inline}.markdown-preview .md-toc .md-toc-link-wrapper.highlighted .md-toc-link{font-weight:800}.scrollbar-style::-webkit-scrollbar{width:8px}.scrollbar-style::-webkit-scrollbar-track{border-radius:10px;background-color:transparent}.scrollbar-style::-webkit-scrollbar-thumb{border-radius:5px;background-color:rgba(150,150,150,.66);border:4px solid rgba(150,150,150,.66);background-clip:content-box}html body[for=html-export]:not([data-presentation-mode]){position:relative;width:100%;height:100%;top:0;left:0;margin:0;padding:0;overflow:auto}html body[for=html-export]:not([data-presentation-mode]) .markdown-preview{position:relative;top:0;min-height:100vh}@media screen and (min-width:914px){html body[for=html-export]:not([data-presentation-mode]) .markdown-preview{padding:2em calc(50% - 457px + 2em)}}@media screen and (max-width:914px){html body[for=html-export]:not([data-presentation-mode]) .markdown-preview{padding:2em}}@media screen and (max-width:450px){html body[for=html-export]:not([data-presentation-mode]) .markdown-preview{font-size:14px!important;padding:1em}}@media print{html body[for=html-export]:not([data-presentation-mode]) #sidebar-toc-btn{display:none}}html body[for=html-export]:not([data-presentation-mode]) #sidebar-toc-btn{position:fixed;bottom:8px;left:8px;font-size:28px;cursor:pointer;color:inherit;z-index:99;width:32px;text-align:center;opacity:.4}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] #sidebar-toc-btn{opacity:1}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc{position:fixed;top:0;left:0;width:300px;height:100%;padding:32px 0 48px 0;font-size:14px;box-shadow:0 0 4px rgba(150,150,150,.33);box-sizing:border-box;overflow:auto;background-color:inherit}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc::-webkit-scrollbar{width:8px}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc::-webkit-scrollbar-track{border-radius:10px;background-color:transparent}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc::-webkit-scrollbar-thumb{border-radius:5px;background-color:rgba(150,150,150,.66);border:4px solid rgba(150,150,150,.66);background-clip:content-box}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc a{text-decoration:none}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc .md-toc{padding:0 16px}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc .md-toc .md-toc-link-wrapper .md-toc-link{display:inline;padding:.25rem 0}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc .md-toc .md-toc-link-wrapper .md-toc-link div,html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc .md-toc .md-toc-link-wrapper .md-toc-link p{display:inline}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc .md-toc .md-toc-link-wrapper.highlighted .md-toc-link{font-weight:800}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .markdown-preview{left:300px;width:calc(100% - 300px);padding:2em calc(50% - 457px - 300px / 2);margin:0;box-sizing:border-box}@media screen and (max-width:1274px){html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .markdown-preview{padding:2em}}@media screen and (max-width:450px){html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .markdown-preview{width:100%}}html body[for=html-export]:not([data-presentation-mode]):not([html-show-sidebar-toc]) .markdown-preview{left:50%;transform:translateX(-50%)}html body[for=html-export]:not([data-presentation-mode]):not([html-show-sidebar-toc]) .md-sidebar-toc{display:none}
    14. 

  14. /* Please visit the URL below for more information: */
    15. 

  15. /*   https://shd101wyy.github.io/markdown-preview-enhanced/#/customize-css */
    16. 

  16. 

  17.       </style>
    18. 

  18.       <!-- The content below will be included at the end of the <head> element. --><script type="text/javascript">
    19. 

  19.   document.addEventListener("DOMContentLoaded", function () {
    20. 

  20.     // your code here
    21. 

  21.   });
    22. 

  22. </script></head><body for="html-export">
    23. 

  23.     
    24. 

  24.     
    25. 

  25.       <div class="crossnote markdown-preview  ">
    26. 

  26.       
    27. 

  27. <h1 id="数据库设计过程规划">数据库设计过程规划 </h1>
    28. 

  28. <h2 id="工具">工具： </h2>
    29. 

  29. <ul>
    30. 

  30. <li>itbuilder</li>
    31. 

  31. <li>pdmaner</li>
    32. 

  32. </ul>
    33. 

  33. <h2 id="mysql-8-到-php-8-数据类型对照表">MySQL 8 到 PHP 8 数据类型对照表 </h2>
    34. 

  34. <table>
    35. 

  35. <thead>
    36. 

  36. <tr>
    37. 

  37. <th>MySQL 数据类型</th>
    38. 

  38. <th>PHP 数据类型</th>
    39. 

  39. <th>说明</th>
    40. 

  40. </tr>
    41. 

  41. </thead>
    42. 

  42. <tbody>
    43. 

  43. <tr>
    44. 

  44. <td>TINYINT</td>
    45. 

  45. <td>int</td>
    46. 

  46. <td>小整数值，范围：-128 到 127</td>
    47. 

  47. </tr>
    48. 

  48. <tr>
    49. 

  49. <td>SMALLINT</td>
    50. 

  50. <td>int</td>
    51. 

  51. <td>小整数值，范围：-32768 到 32767</td>
    52. 

  52. </tr>
    53. 

  53. <tr>
    54. 

  54. <td>MEDIUMINT</td>
    55. 

  55. <td>int</td>
    56. 

  56. <td>中等大小整数值，范围：-8388608 到 8388607</td>
    57. 

  57. </tr>
    58. 

  58. <tr>
    59. 

  59. <td>INT</td>
    60. 

  60. <td>int</td>
    61. 

  61. <td>标准整数值，范围：-2147483648 到 2147483647</td>
    62. 

  62. </tr>
    63. 

  63. <tr>
    64. 

  64. <td>BIGINT</td>
    65. 

  65. <td>int/string</td>
    66. 

  66. <td>大整数值，范围：-9223372036854775808 到 9223372036854775807</td>
    67. 

  67. </tr>
    68. 

  68. <tr>
    69. 

  69. <td>FLOAT</td>
    70. 

  70. <td>float</td>
    71. 

  71. <td>单精度浮点数</td>
    72. 

  72. </tr>
    73. 

  73. <tr>
    74. 

  74. <td>DOUBLE</td>
    75. 

  75. <td>float</td>
    76. 

  76. <td>双精度浮点数</td>
    77. 

  77. </tr>
    78. 

  78. <tr>
    79. 

  79. <td>DECIMAL</td>
    80. 

  80. <td>string</td>
    81. 

  81. <td>定点数</td>
    82. 

  82. </tr>
    83. 

  83. <tr>
    84. 

  84. <td>DATE</td>
    85. 

  85. <td>string</td>
    86. 

  86. <td>日期值，格式：YYYY-MM-DD</td>
    87. 

  87. </tr>
    88. 

  88. <tr>
    89. 

  89. <td>DATETIME</td>
    90. 

  90. <td>string</td>
    91. 

  91. <td>日期和时间值，格式：YYYY-MM-DD HH:MM:SS</td>
    92. 

  92. </tr>
    93. 

  93. <tr>
    94. 

  94. <td>TIMESTAMP</td>
    95. 

  95. <td>string</td>
    96. 

  96. <td>时间戳，格式：YYYY-MM-DD HH:MM:SS</td>
    97. 

  97. </tr>
    98. 

  98. <tr>
    99. 

  99. <td>TIME</td>
    100. 

  100. <td>string</td>
    101. 

  101. <td>时间值，格式：HH:MM:SS</td>
    102. 

  102. </tr>
    103. 

  103. <tr>
    104. 

  104. <td>YEAR</td>
    105. 

  105. <td>int</td>
    106. 

  106. <td>年份值，范围：1901 到 2155</td>
    107. 

  107. </tr>
    108. 

  108. <tr>
    109. 

  109. <td>CHAR</td>
    110. 

  110. <td>string</td>
    111. 

  111. <td>定长字符串</td>
    112. 

  112. </tr>
    113. 

  113. <tr>
    114. 

  114. <td>VARCHAR</td>
    115. 

  115. <td>string</td>
    116. 

  116. <td>变长字符串</td>
    117. 

  117. </tr>
    118. 

  118. <tr>
    119. 

  119. <td>BINARY</td>
    120. 

  120. <td>string</td>
    121. 

  121. <td>定长二进制数据</td>
    122. 

  122. </tr>
    123. 

  123. <tr>
    124. 

  124. <td>VARBINARY</td>
    125. 

  125. <td>string</td>
    126. 

  126. <td>变长二进制数据</td>
    127. 

  127. </tr>
    128. 

  128. <tr>
    129. 

  129. <td>TINYBLOB</td>
    130. 

  130. <td>string</td>
    131. 

  131. <td>不超过 255 个字符的二进制数据</td>
    132. 

  132. </tr>
    133. 

  133. <tr>
    134. 

  134. <td>BLOB</td>
    135. 

  135. <td>string</td>
    136. 

  136. <td>不超过 65535 个字符的二进制数据</td>
    137. 

  137. </tr>
    138. 

  138. <tr>
    139. 

  139. <td>MEDIUMBLOB</td>
    140. 

  140. <td>string</td>
    141. 

  141. <td>不超过 16777215 个字符的二进制数据</td>
    142. 

  142. </tr>
    143. 

  143. <tr>
    144. 

  144. <td>LONGBLOB</td>
    145. 

  145. <td>string</td>
    146. 

  146. <td>不超过 4294967295 个字符的二进制数据</td>
    147. 

  147. </tr>
    148. 

  148. <tr>
    149. 

  149. <td>TINYTEXT</td>
    150. 

  150. <td>string</td>
    151. 

  151. <td>短文本字符串，不超过 255 个字符</td>
    152. 

  152. </tr>
    153. 

  153. <tr>
    154. 

  154. <td>TEXT</td>
    155. 

  155. <td>string</td>
    156. 

  156. <td>文本字符串，不超过 65535 个字符</td>
    157. 

  157. </tr>
    158. 

  158. <tr>
    159. 

  159. <td>MEDIUMTEXT</td>
    160. 

  160. <td>string</td>
    161. 

  161. <td>中等长度文本字符串，不超过 16777215 个字符</td>
    162. 

  162. </tr>
    163. 

  163. <tr>
    164. 

  164. <td>LONGTEXT</td>
    165. 

  165. <td>string</td>
    166. 

  166. <td>长文本字符串，不超过 4294967295 个字符</td>
    167. 

  167. </tr>
    168. 

  168. <tr>
    169. 

  169. <td>ENUM</td>
    170. 

  170. <td>string</td>
    171. 

  171. <td>枚举类型</td>
    172. 

  172. </tr>
    173. 

  173. <tr>
    174. 

  174. <td>SET</td>
    175. 

  175. <td>string</td>
    176. 

  176. <td>集合类型</td>
    177. 

  177. </tr>
    178. 

  178. <tr>
    179. 

  179. <td>JSON</td>
    180. 

  180. <td>array/object</td>
    181. 

  181. <td>JSON 格式数据，映射为 PHP 数组或对象</td>
    182. 

  182. </tr>
    183. 

  183. <tr>
    184. 

  184. <td>BOOL</td>
    185. 

  185. <td>bool</td>
    186. 

  186. <td>布尔值，通常用 0 和 1 表示</td>
    187. 

  187. </tr>
    188. 

  188. <tr>
    189. 

  189. <td>GEOMETRY</td>
    190. 

  190. <td>string</td>
    191. 

  191. <td>几何数据类型</td>
    192. 

  192. </tr>
    193. 

  193. <tr>
    194. 

  194. <td>POINT</td>
    195. 

  195. <td>string</td>
    196. 

  196. <td>点类型</td>
    197. 

  197. </tr>
    198. 

  198. <tr>
    199. 

  199. <td>LINESTRING</td>
    200. 

  200. <td>string</td>
    201. 

  201. <td>线串类型</td>
    202. 

  202. </tr>
    203. 

  203. <tr>
    204. 

  204. <td>POLYGON</td>
    205. 

  205. <td>string</td>
    206. 

  206. <td>多边形类型</td>
    207. 

  207. </tr>
    208. 

  208. <tr>
    209. 

  209. <td>MULTIPOINT</td>
    210. 

  210. <td>string</td>
    211. 

  211. <td>多点类型</td>
    212. 

  212. </tr>
    213. 

  213. <tr>
    214. 

  214. <td>MULTILINESTRING</td>
    215. 

  215. <td>string</td>
    216. 

  216. <td>多线串类型</td>
    217. 

  217. </tr>
    218. 

  218. <tr>
    219. 

  219. <td>MULTIPOLYGON</td>
    220. 

  220. <td>string</td>
    221. 

  221. <td>多多边形类型</td>
    222. 

  222. </tr>
    223. 

  223. <tr>
    224. 

  224. <td>GEOMETRYCOLLECTION</td>
    225. 

  225. <td>string</td>
    226. 

  226. <td>几何集合类型</td>
    227. 

  227. </tr>
    228. 

  228. </tbody>
    229. 

  229. </table>
    230. 

  230. <h2 id="参考">参考： </h2>
    231. 

  231. <ul>
    232. 

  232. <li>UI 图</li>
    233. 

  233. <li>程序需求和概要设计文档（含流程图）</li>
    234. 

  234. <li>老数据库</li>
    235. 

  235. <li>购买的代码数据库</li>
    236. 

  236. </ul>
    237. 

  237. <h2 id="字段命名前缀">字段命名前缀 </h2>
    238. 

  238. <ul>
    239. 

  239. <li>图片：img_</li>
    240. 

  240. <li>状态：status_</li>
    241. 

  241. <li>价格：PRICE_</li>
    242. 

  242. <li>日期： 所有都后缀_time</li>
    243. 

  243. <li>数据库关键词、php 关键词、js 关键词，后缀: _KW</li>
    244. 

  244. <li>外键命名规则： simple 表名_ID</li>
    245. 

  245. </ul>
    246. 

  246. <blockquote>
    247. 

  247. <p>多个单词情况倒序命名</p>
    248. 

  248. </blockquote>
    249. 

  249. <h2 id="设计步骤规划">设计步骤规划 </h2>
    250. 

  250. <blockquote>
    251. 

  251. <p>业务部门人员全程参与，提出修改意见，参与评审？</p>
    252. 

  252. </blockquote>
    253. 

  253. <ol start="0">
    254. 

  254. <li>建立英汉对照字典，用于统一业务名词的中英文命名？</li>
    255. 

  255. <li>导入刘数据库，精简 [x]</li>
    256. 

  256. <li>用 pdmaner 参考 UI 图逆向设计，设计到概念模型、逻辑模型为止，不扩展</li>
    257. 

  257. <li>参考做了一半的程序详细设计文档，进行查漏补缺（验证），不扩展</li>
    258. 

  258. <li>参考购买的代码数据库，进行对比，找出不合理之处，进行优化，做加法</li>
    259. 

  259. <li>分析业务中所有需要记录日志或审计的地方，统一建表</li>
    260. 

  260. <li>用 itbuilder 进行快速将概念模型转换为物理模型，进行优化和扩展、字段翻译、字段精度（类型、长度）等，生成物理模型 DDL 并建库</li>
    261. 

  261. <li>生成数据库文档和数据字典文档</li>
    262. 

  262. <li>评审，交付下一开发环节</li>
    263. 

  263. </ol>
    264. 

  264. <h2 id="设计注意事项">设计注意事项 </h2>
    265. 

  265. <ul>
    266. 

  266. <li>表名、字段名必须使用小写字母，禁止使用大写字母</li>
    267. 

  267. <li>表名、字段名必须使用下划线分割单词，禁止使用驼峰命名</li>
    268. 

  268. <li>表名、字段名禁止使用中文</li>
    269. 

  269. <li>表名、字段名禁止使用特殊字符</li>
    270. 

  270. <li>表名、字段名禁止使用保留字</li>
    271. 

  271. <li>表名、字段名禁止使用 mysql 保留字</li>
    272. 

  272. <li>表名、字段名禁止使用 php 保留字</li>
    273. 

  273. <li>遵守数据库设计范式：
    274. 

  274. <ul>
    275. 

  275. <li>1NF：字段不可分割</li>
    276. 

  276. <li>2NF：每个非主键字段都依赖于主键</li>
    277. 

  277. <li>3NF：每个非主键字段都不依赖于其他非主键字段</li>
    278. 

  278. <li>BCNF：每个决定因素都包含主键</li>
    279. 

  279. <li>4NF：消除多值依赖</li>
    280. 

  280. <li>5NF：消除传递依赖</li>
    281. 

  281. </ul>
    282. 

  282. </li>
    283. 

  283. </ul>
    284. 

  284. <h2 id="后续过程">后续过程 </h2>
    285. 

  285. <ol>
    286. 

  286. <li>程序设计文档，参考数据库进行修改</li>
    287. 

  287. <li>通过 dcat admin 生成基础管理后台 controller、model、service 代码，通过 ai 调优后台界面</li>
    288. 

  288. <li>输入程序设计文档、数据库设计文档，通过 ai 生成接口的逻辑代码，测试代码</li>
    289. 

  289. <li>联调测试，优化代码</li>
    290. 

  290. <li>上线测试</li>
    291. 

  291. </ol>
    292. 

  292. <h2 id="php-后台相关表-todolist">php 后台相关表 todolist </h2>
    293. 

  293. <ol>
    294. 

  294. <li>overtrue/laravel-socialite
    295. 

  295. <ul>
    296. 

  296. <li>social_providers</li>
    297. 

  297. </ul>
    298. 

  298. </li>
    299. 

  299. <li>平台设置存储到.env 配置文件中
    300. 

  300. <ul>
    301. 

  301. <li>当新建租户时，将配置文件中的平台设置导入到租户的配置表中</li>
    302. 

  302. </ul>
    303. 

  303. </li>
    304. 

  304. </ol>
    305. 

  305. <h2 id="php-后台程序详细设计文档-todolist">php 后台程序详细设计文档 todolist </h2>
    306. 

  306. <ol>
    307. 

  307. <li>分帐需要、a、b 表，</li>
    308. 

  308. </ol>
    309. 

  309. <h2 id="ui-修改-todolist">UI 修改 todolist </h2>
    310. 

  310. <h3 id="技师端">技师端 </h3>
    311. 

  311. <ul>
    312. 

  312. <li>技师端首页
    313. 

  313. <ul>
    314. 

  314. <li>header
    315. 

  315. <ul>
    316. 

  316. <li>去掉“位置”显示</li>
    317. 

  317. </ul>
    318. 

  318. </li>
    319. 

  319. <li>接单设置
    320. 

  320. <ul>
    321. 

  321. <li>增加“位置”显示</li>
    322. 

  322. </ul>
    323. 

  323. </li>
    324. 

  324. <li>个人信息板块
    325. 

  325. <ul>
    326. 

  326. <li>增加：待认证状态，以及对应的提示</li>
    327. 

  327. <li>点击“待认证状态”或通过其他形式进入认证页面，补充认证需要的信息提交申请</li>
    328. 

  328. <li>如果是审核过了，但未认证，则显示“去认证”。</li>
    329. 

  329. <li>以审核通过的信息为主，点击个人修改，如果有申请修改的记录正在审核，则提示她，你有一条记录正在审核，下面的信息还是审核过的信息，假如他继续修改通过的信息，则会提示，你有一条审核信息正在审核。</li>
    330. 

  330. <li>“个人主页“干掉</li>
    331. 

  331. </ul>
    332. 

  332. </li>
    333. 

  333. <li>项目设置
    334. 

  334. <ul>
    335. 

  335. <li>设置表单下面，增加“重置默认设置”按钮</li>
    336. 

  336. </ul>
    337. 

  337. </li>
    338. 

  338. <li>我的订单板块，去掉。tabbar，抢单和订单列表显示数量角标</li>
    339. 

  339. </ul>
    340. 

  340. </li>
    341. 

  341. <li>订单列表
    342. 

  342. <ul>
    343. 

  343. <li>改名为“任务列表”</li>
    344. 

  344. </ul>
    345. 

  345. </li>
    346. 

  346. <li>抢单内容要与任务列表内容、风格一致</li>
    347. 

  347. </ul>
    348. 

  348. <h3 id="订单">订单 </h3>
    349. 

  349. <ul>
    350. 

  350. <li>字段：订单编号，会员编号，技师编号，项目编号，订单状态，订单类型，订单金额(车费+服务费+打赏金额+余额抵扣金额-优惠金额)，支付金额，余额抵扣金额，车费，服务费，打赏金额，优惠金额，订单时间，订单地址，订单经纬度，订单地址编码，订单备注，创建时间，更新时间</li>
    351. 

  351. </ul>
    352. 

  352. <h3 id="订单项目快照">订单项目快照 </h3>
    353. 

  353. <ul>
    354. 

  354. <li>字段：订单编号，项目</li>
    355. 

  355. </ul>
    356. 

  356. <h3 id="订单服务">订单服务 </h3>
    357. 

  357. <ul>
    358. 

  358. <li>字段：订单编号，技师编号，订单状态(创建、接单、出发、到达、开始服务、服务结束、撤离)，经纬度，地址，图片，创建时间，更新时间</li>
    359. 

  359. </ul>
    360. 

  360. <h3 id="订单分帐">订单分帐 </h3>
    361. 

  361. <ul>
    362. 

  362. <li>字段：订单编号，分润类型(用户一级邀请人、用户二级邀请人、技师、平台、代理、技师邀请人)，分润账户类型(用户、技师、平台、代理)，分润账户编号，参与分润金额，分润金额，分润比例，分润时间，创建时间，更新时间</li>
    363. 

  363. </ul>
    364. 

  364. <h3 id="钱包">钱包 </h3>
    365. 

  365. <ul>
    366. 

  366. <li>字段：账户类型(用户、技师、平台、代理)，账户编号，类型(消费、退款、充值、提现、扣除、赠送)，类型订单编号(订单编号、退款编号、充值编号、提现编号)，钱包余额，冻结金额（充值金额），出入金额，手续费，状态(成功，失败)，备注，通过时间，创建时间，更新时间</li>
    367. 

  367. </ul>
    368. 

  368. <h3 id="提现记录">提现记录 </h3>
    369. 

  369. <ul>
    370. 

  370. <li>字段：提现编号，账户类型(用户、技师、平台、代理)，账户编号，提现金额，提现手续费，提现状态，提现时间，创建时间，更新时间</li>
    371. 

  371. </ul>
    372. 

  372. <p>车费需要提点 10%<br>
    373. 

  373. 小费需要提点 50%<br>
    374. 

  374. 服务费平台提点 50% - 40%(根据技师等级)</p>
    375. 

  375. <h2 id="后台设计-生成-sql-cursor-规则配置">后台设计 生成 sql cursor 规则配置 </h2>
    376. 

  376. <pre data-role="codeBlock" data-info="" class="language-text"><code>Always respond in 中文
    377. 

  377. 生成统计sql时，请按照以下要求生成：
    378. 

  378. 1. 数据库采用的是：mysql8
    379. 

  379. 2. 所有注释请使用块注释
    380. 

  380. 3. 查询的每一个列都不要用AS改名，后面都要有中文块注释
    381. 

  381. 4. 查询关联的每一个表改别名时不要使用数据库关键字，后面都要有中文块注释
    382. 

  382. 5. 用查询因子化语法生成统计sql
    383. 

  383. 6. 生成统计sql时，发现不明确的表、字段，请一个一个的告知我，我一个一个的跟您确认，确认后您重新生成统计sql
    384. 

  384. 

  385. </code></pre>
    386. 

  386.       </div>
    387. 

  387.       <div class="md-sidebar-toc">
    388. 

  388. <div class="md-toc">
    389. 

  389. <details style="padding:0;;padding-left:0px;" open="">
    390. 

  390.         <summary class="md-toc-link-wrapper">
    391. 

  391.           <a href="#数据库设计过程规划" class="md-toc-link"><p>数据库设计过程规划</p>
    392. 

  392. </a>
    393. 

  393.           </summary>
    394. 

  394.         <div>
    395. 

  395.           <div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
    396. 

  396.           <a href="#工具" class="md-toc-link">
    397. 

  397.             <p>工具：</p>
    398. 

  398. 

  399.           </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
    400. 

  400.           <a href="#mysql-8-到-php-8-数据类型对照表" class="md-toc-link">
    401. 

  401.             <p>MySQL 8 到 PHP 8 数据类型对照表</p>
    402. 

  402. 

  403.           </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
    404. 

  404.           <a href="#参考" class="md-toc-link">
    405. 

  405.             <p>参考：</p>
    406. 

  406. 

  407.           </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
    408. 

  408.           <a href="#字段命名前缀" class="md-toc-link">
    409. 

  409.             <p>字段命名前缀</p>
    410. 

  410. 

  411.           </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
    412. 

  412.           <a href="#设计步骤规划" class="md-toc-link">
    413. 

  413.             <p>设计步骤规划</p>
    414. 

  414. 

  415.           </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
    416. 

  416.           <a href="#设计注意事项" class="md-toc-link">
    417. 

  417.             <p>设计注意事项</p>
    418. 

  418. 

  419.           </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
    420. 

  420.           <a href="#后续过程" class="md-toc-link">
    421. 

  421.             <p>后续过程</p>
    422. 

  422. 

  423.           </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
    424. 

  424.           <a href="#php-后台相关表-todolist" class="md-toc-link">
    425. 

  425.             <p>php 后台相关表 todolist</p>
    426. 

  426. 

  427.           </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
    428. 

  428.           <a href="#php-后台程序详细设计文档-todolist" class="md-toc-link">
    429. 

  429.             <p>php 后台程序详细设计文档 todolist</p>
    430. 

  430. 

  431.           </a></div><details style="padding:0;;padding-left:24px;" open="">
    432. 

  432.         <summary class="md-toc-link-wrapper">
    433. 

  433.           <a href="#ui-修改-todolist" class="md-toc-link"><p>UI 修改 todolist</p>
    434. 

  434. </a>
    435. 

  435.           </summary>
    436. 

  436.         <div>
    437. 

  437.           <div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
    438. 

  438.           <a href="#技师端" class="md-toc-link">
    439. 

  439.             <p>技师端</p>
    440. 

  440. 

  441.           </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
    442. 

  442.           <a href="#订单" class="md-toc-link">
    443. 

  443.             <p>订单</p>
    444. 

  444. 

  445.           </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
    446. 

  446.           <a href="#订单项目快照" class="md-toc-link">
    447. 

  447.             <p>订单项目快照</p>
    448. 

  448. 

  449.           </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
    450. 

  450.           <a href="#订单服务" class="md-toc-link">
    451. 

  451.             <p>订单服务</p>
    452. 

  452. 

  453.           </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
    454. 

  454.           <a href="#订单分帐" class="md-toc-link">
    455. 

  455.             <p>订单分帐</p>
    456. 

  456. 

  457.           </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
    458. 

  458.           <a href="#钱包" class="md-toc-link">
    459. 

  459.             <p>钱包</p>
    460. 

  460. 

  461.           </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
    462. 

  462.           <a href="#提现记录" class="md-toc-link">
    463. 

  463.             <p>提现记录</p>
    464. 

  464. 

  465.           </a></div>
    466. 

  466.         </div>
    467. 

  467.       </details>
    468. 

  468.     <div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
    469. 

  469.           <a href="#后台设计-生成-sql-cursor-规则配置" class="md-toc-link">
    470. 

  470.             <p>后台设计 生成 sql cursor 规则配置</p>
    471. 

  471. 

  472.           </a></div>
    473. 

  473.         </div>
    474. 

  474.       </details>
    475. 

  475.     
    476. 

  476. </div>
    477. 

  477. </div>
    478. 

  478.       <a id="sidebar-toc-btn">≡</a>
    479. 

  479.     
    480. 

  480.     
    481. 

  481.     
    482. 

  482.     
    483. 

  483.     
    484. 

  484.     
    485. 

  485. <script>
    486. 

  486. document.body.setAttribute('html-show-sidebar-toc', true)
    487. 

  487. var sidebarTOCBtn = document.getElementById('sidebar-toc-btn')
    488. 

  488. sidebarTOCBtn.addEventListener('click', function(event) {
    489. 

  489.   event.stopPropagation()
    490. 

  490.   if (document.body.hasAttribute('html-show-sidebar-toc')) {
    491. 

  491.     document.body.removeAttribute('html-show-sidebar-toc')
    492. 

  492.   } else {
    493. 

  493.     document.body.setAttribute('html-show-sidebar-toc', true)
    494. 

  494.   }
    495. 

  495. })
    496. 

  496. </script>
    497. 

  497.       
    498. 

  498.   
    499. 

  499.     </body></html>
    500.