Domů Procházet Nápověda
Přihlásit se
dk
/
kraken
rozštěpen z yanzheng/kraken
2
0
Rozštěpit 1
Soubory Úkoly 0 Pull Requesty 0
Strom: 30b9d478b2
Větve Značky
kraken
/
docs
/
UML
/
dbschema.svg

dbschema.svg 8.6 KB
Historie Surový

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109 
  1. <?xml version="1.0" encoding="UTF-8" standalone="no"?>
    2. 

  2. <!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN"
    3. 

  3.  "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
    4. 

  4. <!-- Generated by graphviz version 7.0.4 (20221203.1631)
    5. 

  5.  -->
    6. 

  6. <!-- Title: G Pages: 1 -->
    7. 

  7. <svg width="469pt" height="284pt"
    8. 

  8.  viewBox="0.00 0.00 469.00 284.00" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
    9. 

  9. <g id="graph0" class="graph" transform="scale(1 1) rotate(0) translate(4 280)">
    10. 

  10. <title>G</title>
    11. 

  11. <polygon fill="white" stroke="none" points="-4,4 -4,-280 465,-280 465,4 -4,4"/>
    12. 

  12. <!-- dailystats -->
    13. 

  13. <g id="node1" class="node">
    14. 

  14. <title>dailystats</title>
    15. 

  15. <text text-anchor="start" x="51" y="-35.4" font-family="Bitstream-Vera Sans" font-size="7.00">dailystats</text>
    16. 

  16. <polygon fill="none" stroke="black" points="9,-29 9,-31 129,-31 129,-29 9,-29"/>
    17. 

  17. <text text-anchor="start" x="11" y="-21.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; date : DATE</text>
    18. 

  18. <text text-anchor="start" x="11" y="-9.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; create_subject_num : INTEGER</text>
    19. 

  19. <polygon fill="none" stroke="black" points="8,-4 8,-44 130,-44 130,-4 8,-4"/>
    20. 

  20. </g>
    21. 

  21. <!-- fubopneumaticfinger -->
    22. 

  22. <g id="node2" class="node">
    23. 

  23. <title>fubopneumaticfinger</title>
    24. 

  24. <text text-anchor="start" x="31" y="-251.4" font-family="Bitstream-Vera Sans" font-size="7.00">fubopneumaticfinger</text>
    25. 

  25. <polygon fill="none" stroke="black" points="29,-245 29,-247 109,-247 109,-245 29,-245"/>
    26. 

  26. <text text-anchor="start" x="31" y="-237.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; id : INTEGER</text>
    27. 

  27. <text text-anchor="start" x="31" y="-225.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; train_id : INTEGER</text>
    28. 

  28. <polygon fill="none" stroke="black" points="28,-220 28,-260 110,-260 110,-220 28,-220"/>
    29. 

  29. </g>
    30. 

  30. <!-- train -->
    31. 

  31. <g id="node3" class="node">
    32. 

  32. <title>train</title>
    33. 

  33. <text text-anchor="start" x="234" y="-263.4" font-family="Bitstream-Vera Sans" font-size="7.00">train</text>
    34. 

  34. <polygon fill="none" stroke="black" points="183,-257 183,-259 303,-259 303,-257 183,-257"/>
    35. 

  35. <text text-anchor="start" x="185" y="-249.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; id : INTEGER</text>
    36. 

  36. <text text-anchor="start" x="185" y="-237.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; position : VARCHAR</text>
    37. 

  37. <text text-anchor="start" x="185" y="-225.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; rank : VARCHAR</text>
    38. 

  38. <text text-anchor="start" x="185" y="-213.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; trial_num : INTEGER</text>
    39. 

  39. <text text-anchor="start" x="185" y="-201.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; start_time : DATETIME</text>
    40. 

  40. <text text-anchor="start" x="185" y="-189.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; end_time : DATETIME</text>
    41. 

  41. <text text-anchor="start" x="185" y="-177.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; grade : VARCHAR(2)</text>
    42. 

  42. <text text-anchor="start" x="185" y="-165.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; consume_time : INTEGER</text>
    43. 

  43. <text text-anchor="start" x="185" y="-153.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; accuracy : FLOAT</text>
    44. 

  44. <text text-anchor="start" x="185" y="-141.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; train_status : INTEGER</text>
    45. 

  45. <text text-anchor="start" x="185" y="-129.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; eeg_device : VARCHAR(5)</text>
    46. 

  46. <text text-anchor="start" x="185" y="-117.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; owner_id : INTEGER</text>
    47. 

  47. <text text-anchor="start" x="185" y="-105.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; medical_certificate : VARCHAR</text>
    48. 

  48. <polygon fill="none" stroke="black" points="182,-100 182,-272 304,-272 304,-100 182,-100"/>
    49. 

  49. </g>
    50. 

  50. <!-- fubopneumaticfinger&#45;&gt;train -->
    51. 

  51. <g id="edge1" class="edge">
    52. 

  52. <title>fubopneumaticfinger&#45;&gt;train</title>
    53. 

  53. <path fill="none" stroke="black" d="M117.91,-224.96C132.72,-220.31 149.43,-215.06 165.66,-209.97"/>
    54. 

  54. <ellipse fill="none" stroke="black" cx="169.81" cy="-208.67" rx="4" ry="4"/>
    55. 

  55. <text text-anchor="middle" x="166.1" y="-201.72" font-family="Bitstream-Vera Sans" font-size="7.00">+ id</text>
    56. 

  56. <text text-anchor="middle" x="136.41" y="-219.36" font-family="Bitstream-Vera Sans" font-size="7.00">+ train_id</text>
    57. 

  57. </g>
    58. 

  58. <!-- subject -->
    59. 

  59. <g id="node4" class="node">
    60. 

  60. <title>subject</title>
    61. 

  61. <text text-anchor="start" x="391" y="-251.4" font-family="Bitstream-Vera Sans" font-size="7.00">subject</text>
    62. 

  62. <polygon fill="none" stroke="black" points="357.5,-245 357.5,-247 452.5,-247 452.5,-245 357.5,-245"/>
    63. 

  63. <text text-anchor="start" x="359.5" y="-237.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; id : VARCHAR(32)</text>
    64. 

  64. <text text-anchor="start" x="359.5" y="-225.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; id_card : VARCHAR</text>
    65. 

  65. <text text-anchor="start" x="359.5" y="-213.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; name : VARCHAR</text>
    66. 

  66. <text text-anchor="start" x="359.5" y="-201.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; gender : VARCHAR</text>
    67. 

  67. <text text-anchor="start" x="359.5" y="-189.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; birthday : DATE</text>
    68. 

  68. <text text-anchor="start" x="359.5" y="-177.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; create_time : DATETIME</text>
    69. 

  69. <text text-anchor="start" x="359.5" y="-165.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; left_hand : BOOLEAN</text>
    70. 

  70. <text text-anchor="start" x="359.5" y="-153.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; right_hand : BOOLEAN</text>
    71. 

  71. <text text-anchor="start" x="359.5" y="-141.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; left_leg : BOOLEAN</text>
    72. 

  72. <text text-anchor="start" x="359.5" y="-129.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; right_leg : BOOLEAN</text>
    73. 

  73. <text text-anchor="start" x="359.5" y="-117.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; remarks : VARCHAR</text>
    74. 

  74. <polygon fill="none" stroke="black" points="356,-112 356,-260 453,-260 453,-112 356,-112"/>
    75. 

  75. </g>
    76. 

  76. <!-- train&#45;&gt;subject -->
    77. 

  77. <g id="edge2" class="edge">
    78. 

  78. <title>train&#45;&gt;subject</title>
    79. 

  79. <path fill="none" stroke="black" d="M311.64,-186C320.81,-186 330.2,-186 339.31,-186"/>
    80. 

  80. <ellipse fill="none" stroke="black" cx="343.8" cy="-186" rx="4" ry="4"/>
    81. 

  81. <text text-anchor="middle" x="340.3" y="-188.4" font-family="Bitstream-Vera Sans" font-size="7.00">+ id</text>
    82. 

  82. <text text-anchor="middle" x="332.14" y="-180.4" font-family="Bitstream-Vera Sans" font-size="7.00">+ owner_id</text>
    83. 

  83. </g>
    84. 

  84. <!-- handperipheral -->
    85. 

  85. <g id="node5" class="node">
    86. 

  86. <title>handperipheral</title>
    87. 

  87. <text text-anchor="start" x="41.5" y="-185.4" font-family="Bitstream-Vera Sans" font-size="7.00">handperipheral</text>
    88. 

  88. <polygon fill="none" stroke="black" points="22,-179 22,-181 117,-181 117,-179 22,-179"/>
    89. 

  89. <text text-anchor="start" x="24" y="-171.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; id : INTEGER</text>
    90. 

  90. <text text-anchor="start" x="24" y="-159.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; hand_select : INTEGER</text>
    91. 

  91. <text text-anchor="start" x="24" y="-147.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; thumb : INTEGER</text>
    92. 

  92. <text text-anchor="start" x="24" y="-135.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; index_finger : INTEGER</text>
    93. 

  93. <text text-anchor="start" x="24" y="-123.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; middle_finger : INTEGER</text>
    94. 

  94. <text text-anchor="start" x="24" y="-111.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; ring_finger : INTEGER</text>
    95. 

  95. <text text-anchor="start" x="24" y="-99.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; little_finger : INTEGER</text>
    96. 

  96. <text text-anchor="start" x="24" y="-87.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; duration : INTEGER</text>
    97. 

  97. <text text-anchor="start" x="24" y="-75.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; train_id : INTEGER</text>
    98. 

  98. <polygon fill="none" stroke="black" points="20.5,-70 20.5,-194 117.5,-194 117.5,-70 20.5,-70"/>
    99. 

  99. </g>
    100. 

  100. <!-- handperipheral&#45;&gt;train -->
    101. 

  101. <g id="edge3" class="edge">
    102. 

  102. <title>handperipheral&#45;&gt;train</title>
    103. 

  103. <path fill="none" stroke="black" d="M125.37,-149.38C138.22,-153.42 152.12,-157.78 165.69,-162.04"/>
    104. 

  104. <ellipse fill="none" stroke="black" cx="169.79" cy="-163.33" rx="4" ry="4"/>
    105. 

  105. <text text-anchor="middle" x="166.09" y="-159.08" font-family="Bitstream-Vera Sans" font-size="7.00">+ id</text>
    106. 

  106. <text text-anchor="middle" x="143.87" y="-143.78" font-family="Bitstream-Vera Sans" font-size="7.00">+ train_id</text>
    107. 

  107. </g>
    108. 

  108. </g>
    109. 

  109. </svg>
    110.