entity-relation-diagram.drawio 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187
  1. <mxfile host="Electron" modified="2024-08-11T08:11:24.031Z" agent="Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) draw.io/24.6.4 Chrome/124.0.6367.207 Electron/30.0.6 Safari/537.36" etag="f3Lce4ihHKwavLah3tvR" version="24.6.4" type="device">
  2. <diagram id="R2lEEEUBdFMjLlhIrx00" name="Page-1">
  3. <mxGraphModel dx="1434" dy="883" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="850" pageHeight="1100" math="0" shadow="0" extFonts="Permanent Marker^https://fonts.googleapis.com/css?family=Permanent+Marker">
  4. <root>
  5. <mxCell id="0" />
  6. <mxCell id="1" parent="0" />
  7. <mxCell id="C-vyLk0tnHw3VtMMgP7b-1" value="" style="edgeStyle=entityRelationEdgeStyle;endArrow=ERzeroToMany;startArrow=ERone;endFill=1;startFill=0;" parent="1" source="C-vyLk0tnHw3VtMMgP7b-24" target="C-vyLk0tnHw3VtMMgP7b-6" edge="1">
  8. <mxGeometry width="100" height="100" relative="1" as="geometry">
  9. <mxPoint x="340" y="720" as="sourcePoint" />
  10. <mxPoint x="440" y="620" as="targetPoint" />
  11. </mxGeometry>
  12. </mxCell>
  13. <mxCell id="C-vyLk0tnHw3VtMMgP7b-12" value="" style="edgeStyle=entityRelationEdgeStyle;endArrow=ERzeroToMany;startArrow=ERone;endFill=1;startFill=0;" parent="1" source="C-vyLk0tnHw3VtMMgP7b-3" target="C-vyLk0tnHw3VtMMgP7b-17" edge="1">
  14. <mxGeometry width="100" height="100" relative="1" as="geometry">
  15. <mxPoint x="400" y="180" as="sourcePoint" />
  16. <mxPoint x="460" y="205" as="targetPoint" />
  17. </mxGeometry>
  18. </mxCell>
  19. <mxCell id="C-vyLk0tnHw3VtMMgP7b-2" value="Squad" style="shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;" parent="1" vertex="1">
  20. <mxGeometry x="450" y="120" width="250" height="190" as="geometry" />
  21. </mxCell>
  22. <mxCell id="C-vyLk0tnHw3VtMMgP7b-3" value="" style="shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;" parent="C-vyLk0tnHw3VtMMgP7b-2" vertex="1">
  23. <mxGeometry y="30" width="250" height="30" as="geometry" />
  24. </mxCell>
  25. <mxCell id="C-vyLk0tnHw3VtMMgP7b-4" value="PK" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;" parent="C-vyLk0tnHw3VtMMgP7b-3" vertex="1">
  26. <mxGeometry width="30" height="30" as="geometry">
  27. <mxRectangle width="30" height="30" as="alternateBounds" />
  28. </mxGeometry>
  29. </mxCell>
  30. <mxCell id="C-vyLk0tnHw3VtMMgP7b-5" value="id int NOT NULL " style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;" parent="C-vyLk0tnHw3VtMMgP7b-3" vertex="1">
  31. <mxGeometry x="30" width="220" height="30" as="geometry">
  32. <mxRectangle width="220" height="30" as="alternateBounds" />
  33. </mxGeometry>
  34. </mxCell>
  35. <mxCell id="C-vyLk0tnHw3VtMMgP7b-6" value="" style="shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="C-vyLk0tnHw3VtMMgP7b-2" vertex="1">
  36. <mxGeometry y="60" width="250" height="30" as="geometry" />
  37. </mxCell>
  38. <mxCell id="C-vyLk0tnHw3VtMMgP7b-7" value="FK1" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;" parent="C-vyLk0tnHw3VtMMgP7b-6" vertex="1">
  39. <mxGeometry width="30" height="30" as="geometry">
  40. <mxRectangle width="30" height="30" as="alternateBounds" />
  41. </mxGeometry>
  42. </mxCell>
  43. <mxCell id="C-vyLk0tnHw3VtMMgP7b-8" value="player_id int NOT NULL" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;" parent="C-vyLk0tnHw3VtMMgP7b-6" vertex="1">
  44. <mxGeometry x="30" width="220" height="30" as="geometry">
  45. <mxRectangle width="220" height="30" as="alternateBounds" />
  46. </mxGeometry>
  47. </mxCell>
  48. <mxCell id="C-vyLk0tnHw3VtMMgP7b-9" value="" style="shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="C-vyLk0tnHw3VtMMgP7b-2" vertex="1">
  49. <mxGeometry y="90" width="250" height="30" as="geometry" />
  50. </mxCell>
  51. <mxCell id="C-vyLk0tnHw3VtMMgP7b-10" value="" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;" parent="C-vyLk0tnHw3VtMMgP7b-9" vertex="1">
  52. <mxGeometry width="30" height="30" as="geometry">
  53. <mxRectangle width="30" height="30" as="alternateBounds" />
  54. </mxGeometry>
  55. </mxCell>
  56. <mxCell id="C-vyLk0tnHw3VtMMgP7b-11" value="creation_date date NOT NULL" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;" parent="C-vyLk0tnHw3VtMMgP7b-9" vertex="1">
  57. <mxGeometry x="30" width="220" height="30" as="geometry">
  58. <mxRectangle width="220" height="30" as="alternateBounds" />
  59. </mxGeometry>
  60. </mxCell>
  61. <mxCell id="vGfOE6fh8Fkg2EA02DIV-7" value="" style="shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" vertex="1" parent="C-vyLk0tnHw3VtMMgP7b-2">
  62. <mxGeometry y="120" width="250" height="30" as="geometry" />
  63. </mxCell>
  64. <mxCell id="vGfOE6fh8Fkg2EA02DIV-8" value="" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;" vertex="1" parent="vGfOE6fh8Fkg2EA02DIV-7">
  65. <mxGeometry width="30" height="30" as="geometry">
  66. <mxRectangle width="30" height="30" as="alternateBounds" />
  67. </mxGeometry>
  68. </mxCell>
  69. <mxCell id="vGfOE6fh8Fkg2EA02DIV-9" value="name varchar NOT NULL" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;" vertex="1" parent="vGfOE6fh8Fkg2EA02DIV-7">
  70. <mxGeometry x="30" width="220" height="30" as="geometry">
  71. <mxRectangle width="220" height="30" as="alternateBounds" />
  72. </mxGeometry>
  73. </mxCell>
  74. <mxCell id="vGfOE6fh8Fkg2EA02DIV-10" value="" style="shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" vertex="1" parent="C-vyLk0tnHw3VtMMgP7b-2">
  75. <mxGeometry y="150" width="250" height="30" as="geometry" />
  76. </mxCell>
  77. <mxCell id="vGfOE6fh8Fkg2EA02DIV-11" value="" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;" vertex="1" parent="vGfOE6fh8Fkg2EA02DIV-10">
  78. <mxGeometry width="30" height="30" as="geometry">
  79. <mxRectangle width="30" height="30" as="alternateBounds" />
  80. </mxGeometry>
  81. </mxCell>
  82. <mxCell id="vGfOE6fh8Fkg2EA02DIV-12" value="comment text" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;" vertex="1" parent="vGfOE6fh8Fkg2EA02DIV-10">
  83. <mxGeometry x="30" width="220" height="30" as="geometry">
  84. <mxRectangle width="220" height="30" as="alternateBounds" />
  85. </mxGeometry>
  86. </mxCell>
  87. <mxCell id="C-vyLk0tnHw3VtMMgP7b-13" value="Mech" style="shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;" parent="1" vertex="1">
  88. <mxGeometry x="450" y="320" width="250" height="190" as="geometry" />
  89. </mxCell>
  90. <mxCell id="C-vyLk0tnHw3VtMMgP7b-14" value="" style="shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;" parent="C-vyLk0tnHw3VtMMgP7b-13" vertex="1">
  91. <mxGeometry y="30" width="250" height="30" as="geometry" />
  92. </mxCell>
  93. <mxCell id="C-vyLk0tnHw3VtMMgP7b-15" value="PK" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;" parent="C-vyLk0tnHw3VtMMgP7b-14" vertex="1">
  94. <mxGeometry width="30" height="30" as="geometry">
  95. <mxRectangle width="30" height="30" as="alternateBounds" />
  96. </mxGeometry>
  97. </mxCell>
  98. <mxCell id="C-vyLk0tnHw3VtMMgP7b-16" value="id int NOT NULL " style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;" parent="C-vyLk0tnHw3VtMMgP7b-14" vertex="1">
  99. <mxGeometry x="30" width="220" height="30" as="geometry">
  100. <mxRectangle width="220" height="30" as="alternateBounds" />
  101. </mxGeometry>
  102. </mxCell>
  103. <mxCell id="C-vyLk0tnHw3VtMMgP7b-17" value="" style="shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="C-vyLk0tnHw3VtMMgP7b-13" vertex="1">
  104. <mxGeometry y="60" width="250" height="30" as="geometry" />
  105. </mxCell>
  106. <mxCell id="C-vyLk0tnHw3VtMMgP7b-18" value="FK1" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;" parent="C-vyLk0tnHw3VtMMgP7b-17" vertex="1">
  107. <mxGeometry width="30" height="30" as="geometry">
  108. <mxRectangle width="30" height="30" as="alternateBounds" />
  109. </mxGeometry>
  110. </mxCell>
  111. <mxCell id="C-vyLk0tnHw3VtMMgP7b-19" value="squad_id int NOT NULL" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;" parent="C-vyLk0tnHw3VtMMgP7b-17" vertex="1">
  112. <mxGeometry x="30" width="220" height="30" as="geometry">
  113. <mxRectangle width="220" height="30" as="alternateBounds" />
  114. </mxGeometry>
  115. </mxCell>
  116. <mxCell id="C-vyLk0tnHw3VtMMgP7b-20" value="" style="shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="C-vyLk0tnHw3VtMMgP7b-13" vertex="1">
  117. <mxGeometry y="90" width="250" height="30" as="geometry" />
  118. </mxCell>
  119. <mxCell id="C-vyLk0tnHw3VtMMgP7b-21" value="" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;" parent="C-vyLk0tnHw3VtMMgP7b-20" vertex="1">
  120. <mxGeometry width="30" height="30" as="geometry">
  121. <mxRectangle width="30" height="30" as="alternateBounds" />
  122. </mxGeometry>
  123. </mxCell>
  124. <mxCell id="C-vyLk0tnHw3VtMMgP7b-22" value="name varchar NOT NULL" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;" parent="C-vyLk0tnHw3VtMMgP7b-20" vertex="1">
  125. <mxGeometry x="30" width="220" height="30" as="geometry">
  126. <mxRectangle width="220" height="30" as="alternateBounds" />
  127. </mxGeometry>
  128. </mxCell>
  129. <mxCell id="vGfOE6fh8Fkg2EA02DIV-1" value="" style="shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" vertex="1" parent="C-vyLk0tnHw3VtMMgP7b-13">
  130. <mxGeometry y="120" width="250" height="30" as="geometry" />
  131. </mxCell>
  132. <mxCell id="vGfOE6fh8Fkg2EA02DIV-2" value="" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;" vertex="1" parent="vGfOE6fh8Fkg2EA02DIV-1">
  133. <mxGeometry width="30" height="30" as="geometry">
  134. <mxRectangle width="30" height="30" as="alternateBounds" />
  135. </mxGeometry>
  136. </mxCell>
  137. <mxCell id="vGfOE6fh8Fkg2EA02DIV-3" value="class varchar NOT NULL" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;" vertex="1" parent="vGfOE6fh8Fkg2EA02DIV-1">
  138. <mxGeometry x="30" width="220" height="30" as="geometry">
  139. <mxRectangle width="220" height="30" as="alternateBounds" />
  140. </mxGeometry>
  141. </mxCell>
  142. <mxCell id="vGfOE6fh8Fkg2EA02DIV-4" value="" style="shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" vertex="1" parent="C-vyLk0tnHw3VtMMgP7b-13">
  143. <mxGeometry y="150" width="250" height="30" as="geometry" />
  144. </mxCell>
  145. <mxCell id="vGfOE6fh8Fkg2EA02DIV-5" value="" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;" vertex="1" parent="vGfOE6fh8Fkg2EA02DIV-4">
  146. <mxGeometry width="30" height="30" as="geometry">
  147. <mxRectangle width="30" height="30" as="alternateBounds" />
  148. </mxGeometry>
  149. </mxCell>
  150. <mxCell id="vGfOE6fh8Fkg2EA02DIV-6" value="resistance int NOT NULL default 3" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;" vertex="1" parent="vGfOE6fh8Fkg2EA02DIV-4">
  151. <mxGeometry x="30" width="220" height="30" as="geometry">
  152. <mxRectangle width="220" height="30" as="alternateBounds" />
  153. </mxGeometry>
  154. </mxCell>
  155. <mxCell id="C-vyLk0tnHw3VtMMgP7b-23" value="Player" style="shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;" parent="1" vertex="1">
  156. <mxGeometry x="120" y="120" width="250" height="100" as="geometry" />
  157. </mxCell>
  158. <mxCell id="C-vyLk0tnHw3VtMMgP7b-24" value="" style="shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;" parent="C-vyLk0tnHw3VtMMgP7b-23" vertex="1">
  159. <mxGeometry y="30" width="250" height="30" as="geometry" />
  160. </mxCell>
  161. <mxCell id="C-vyLk0tnHw3VtMMgP7b-25" value="PK" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;" parent="C-vyLk0tnHw3VtMMgP7b-24" vertex="1">
  162. <mxGeometry width="30" height="30" as="geometry">
  163. <mxRectangle width="30" height="30" as="alternateBounds" />
  164. </mxGeometry>
  165. </mxCell>
  166. <mxCell id="C-vyLk0tnHw3VtMMgP7b-26" value="id int NOT NULL " style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;" parent="C-vyLk0tnHw3VtMMgP7b-24" vertex="1">
  167. <mxGeometry x="30" width="220" height="30" as="geometry">
  168. <mxRectangle width="220" height="30" as="alternateBounds" />
  169. </mxGeometry>
  170. </mxCell>
  171. <mxCell id="C-vyLk0tnHw3VtMMgP7b-27" value="" style="shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="C-vyLk0tnHw3VtMMgP7b-23" vertex="1">
  172. <mxGeometry y="60" width="250" height="30" as="geometry" />
  173. </mxCell>
  174. <mxCell id="C-vyLk0tnHw3VtMMgP7b-28" value="" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;" parent="C-vyLk0tnHw3VtMMgP7b-27" vertex="1">
  175. <mxGeometry width="30" height="30" as="geometry">
  176. <mxRectangle width="30" height="30" as="alternateBounds" />
  177. </mxGeometry>
  178. </mxCell>
  179. <mxCell id="C-vyLk0tnHw3VtMMgP7b-29" value="name char(50) NOT NULL" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;" parent="C-vyLk0tnHw3VtMMgP7b-27" vertex="1">
  180. <mxGeometry x="30" width="220" height="30" as="geometry">
  181. <mxRectangle width="220" height="30" as="alternateBounds" />
  182. </mxGeometry>
  183. </mxCell>
  184. </root>
  185. </mxGraphModel>
  186. </diagram>
  187. </mxfile>