Home Explore Help
Sign In
DricomDragon
/
SquadComposer
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
SquadComposer
/
doc
/
entity-relation-diagram.drawio

entity-relation-diagram.drawio 13 KB
Permalink History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152 
  1. <mxfile host="Electron" modified="2024-09-09T15:39:37.735Z" 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="9gHxe6F6dL04HJqYRCir" version="24.6.4" type="device">
    2. 

  2.   <diagram id="R2lEEEUBdFMjLlhIrx00" name="Page-1">
    3. 

  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. 

  4.       <root>
    5. 

  5.         <mxCell id="0" />
    6. 

  6.         <mxCell id="1" parent="0" />
    7. 

  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. 

  8.           <mxGeometry width="100" height="100" relative="1" as="geometry">
    9. 

  9.             <mxPoint x="340" y="720" as="sourcePoint" />
    10. 

  10.             <mxPoint x="440" y="620" as="targetPoint" />
    11. 

  11.           </mxGeometry>
    12. 

  12.         </mxCell>
    13. 

  13.         <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">
    14. 

  14.           <mxGeometry x="450" y="120" width="250" height="280" as="geometry" />
    15. 

  15.         </mxCell>
    16. 

  16.         <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">
    17. 

  17.           <mxGeometry y="30" width="250" height="30" as="geometry" />
    18. 

  18.         </mxCell>
    19. 

  19.         <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">
    20. 

  20.           <mxGeometry width="30" height="30" as="geometry">
    21. 

  21.             <mxRectangle width="30" height="30" as="alternateBounds" />
    22. 

  22.           </mxGeometry>
    23. 

  23.         </mxCell>
    24. 

  24.         <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">
    25. 

  25.           <mxGeometry x="30" width="220" height="30" as="geometry">
    26. 

  26.             <mxRectangle width="220" height="30" as="alternateBounds" />
    27. 

  27.           </mxGeometry>
    28. 

  28.         </mxCell>
    29. 

  29.         <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">
    30. 

  30.           <mxGeometry y="60" width="250" height="30" as="geometry" />
    31. 

  31.         </mxCell>
    32. 

  32.         <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">
    33. 

  33.           <mxGeometry width="30" height="30" as="geometry">
    34. 

  34.             <mxRectangle width="30" height="30" as="alternateBounds" />
    35. 

  35.           </mxGeometry>
    36. 

  36.         </mxCell>
    37. 

  37.         <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">
    38. 

  38.           <mxGeometry x="30" width="220" height="30" as="geometry">
    39. 

  39.             <mxRectangle width="220" height="30" as="alternateBounds" />
    40. 

  40.           </mxGeometry>
    41. 

  41.         </mxCell>
    42. 

  42.         <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">
    43. 

  43.           <mxGeometry y="90" width="250" height="30" as="geometry" />
    44. 

  44.         </mxCell>
    45. 

  45.         <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">
    46. 

  46.           <mxGeometry width="30" height="30" as="geometry">
    47. 

  47.             <mxRectangle width="30" height="30" as="alternateBounds" />
    48. 

  48.           </mxGeometry>
    49. 

  49.         </mxCell>
    50. 

  50.         <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">
    51. 

  51.           <mxGeometry x="30" width="220" height="30" as="geometry">
    52. 

  52.             <mxRectangle width="220" height="30" as="alternateBounds" />
    53. 

  53.           </mxGeometry>
    54. 

  54.         </mxCell>
    55. 

  55.         <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;" parent="C-vyLk0tnHw3VtMMgP7b-2" vertex="1">
    56. 

  56.           <mxGeometry y="120" width="250" height="30" as="geometry" />
    57. 

  57.         </mxCell>
    58. 

  58.         <mxCell id="vGfOE6fh8Fkg2EA02DIV-8" value="" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;" parent="vGfOE6fh8Fkg2EA02DIV-7" vertex="1">
    59. 

  59.           <mxGeometry width="30" height="30" as="geometry">
    60. 

  60.             <mxRectangle width="30" height="30" as="alternateBounds" />
    61. 

  61.           </mxGeometry>
    62. 

  62.         </mxCell>
    63. 

  63.         <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;" parent="vGfOE6fh8Fkg2EA02DIV-7" vertex="1">
    64. 

  64.           <mxGeometry x="30" width="220" height="30" as="geometry">
    65. 

  65.             <mxRectangle width="220" height="30" as="alternateBounds" />
    66. 

  66.           </mxGeometry>
    67. 

  67.         </mxCell>
    68. 

  68.         <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;" parent="C-vyLk0tnHw3VtMMgP7b-2" vertex="1">
    69. 

  69.           <mxGeometry y="150" width="250" height="30" as="geometry" />
    70. 

  70.         </mxCell>
    71. 

  71.         <mxCell id="vGfOE6fh8Fkg2EA02DIV-11" value="" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;" parent="vGfOE6fh8Fkg2EA02DIV-10" vertex="1">
    72. 

  72.           <mxGeometry width="30" height="30" as="geometry">
    73. 

  73.             <mxRectangle width="30" height="30" as="alternateBounds" />
    74. 

  74.           </mxGeometry>
    75. 

  75.         </mxCell>
    76. 

  76.         <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;" parent="vGfOE6fh8Fkg2EA02DIV-10" vertex="1">
    77. 

  77.           <mxGeometry x="30" width="220" height="30" as="geometry">
    78. 

  78.             <mxRectangle width="220" height="30" as="alternateBounds" />
    79. 

  79.           </mxGeometry>
    80. 

  80.         </mxCell>
    81. 

  81.         <mxCell id="Tb8xqYRGo6f0FsYqac5e-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-2">
    82. 

  82.           <mxGeometry y="180" width="250" height="30" as="geometry" />
    83. 

  83.         </mxCell>
    84. 

  84.         <mxCell id="Tb8xqYRGo6f0FsYqac5e-2" value="" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;" vertex="1" parent="Tb8xqYRGo6f0FsYqac5e-1">
    85. 

  85.           <mxGeometry width="30" height="30" as="geometry">
    86. 

  86.             <mxRectangle width="30" height="30" as="alternateBounds" />
    87. 

  87.           </mxGeometry>
    88. 

  88.         </mxCell>
    89. 

  89.         <mxCell id="Tb8xqYRGo6f0FsYqac5e-3" value="mech_1_id" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;" vertex="1" parent="Tb8xqYRGo6f0FsYqac5e-1">
    90. 

  90.           <mxGeometry x="30" width="220" height="30" as="geometry">
    91. 

  91.             <mxRectangle width="220" height="30" as="alternateBounds" />
    92. 

  92.           </mxGeometry>
    93. 

  93.         </mxCell>
    94. 

  94.         <mxCell id="Tb8xqYRGo6f0FsYqac5e-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">
    95. 

  95.           <mxGeometry y="210" width="250" height="30" as="geometry" />
    96. 

  96.         </mxCell>
    97. 

  97.         <mxCell id="Tb8xqYRGo6f0FsYqac5e-8" value="" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;" vertex="1" parent="Tb8xqYRGo6f0FsYqac5e-7">
    98. 

  98.           <mxGeometry width="30" height="30" as="geometry">
    99. 

  99.             <mxRectangle width="30" height="30" as="alternateBounds" />
    100. 

  100.           </mxGeometry>
    101. 

  101.         </mxCell>
    102. 

  102.         <mxCell id="Tb8xqYRGo6f0FsYqac5e-9" value="mech_2_id" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;" vertex="1" parent="Tb8xqYRGo6f0FsYqac5e-7">
    103. 

  103.           <mxGeometry x="30" width="220" height="30" as="geometry">
    104. 

  104.             <mxRectangle width="220" height="30" as="alternateBounds" />
    105. 

  105.           </mxGeometry>
    106. 

  106.         </mxCell>
    107. 

  107.         <mxCell id="Tb8xqYRGo6f0FsYqac5e-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">
    108. 

  108.           <mxGeometry y="240" width="250" height="30" as="geometry" />
    109. 

  109.         </mxCell>
    110. 

  110.         <mxCell id="Tb8xqYRGo6f0FsYqac5e-11" value="" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;" vertex="1" parent="Tb8xqYRGo6f0FsYqac5e-10">
    111. 

  111.           <mxGeometry width="30" height="30" as="geometry">
    112. 

  112.             <mxRectangle width="30" height="30" as="alternateBounds" />
    113. 

  113.           </mxGeometry>
    114. 

  114.         </mxCell>
    115. 

  115.         <mxCell id="Tb8xqYRGo6f0FsYqac5e-12" value="mech_1_id" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;" vertex="1" parent="Tb8xqYRGo6f0FsYqac5e-10">
    116. 

  116.           <mxGeometry x="30" width="220" height="30" as="geometry">
    117. 

  117.             <mxRectangle width="220" height="30" as="alternateBounds" />
    118. 

  118.           </mxGeometry>
    119. 

  119.         </mxCell>
    120. 

  120.         <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">
    121. 

  121.           <mxGeometry x="120" y="120" width="250" height="100" as="geometry" />
    122. 

  122.         </mxCell>
    123. 

  123.         <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">
    124. 

  124.           <mxGeometry y="30" width="250" height="30" as="geometry" />
    125. 

  125.         </mxCell>
    126. 

  126.         <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">
    127. 

  127.           <mxGeometry width="30" height="30" as="geometry">
    128. 

  128.             <mxRectangle width="30" height="30" as="alternateBounds" />
    129. 

  129.           </mxGeometry>
    130. 

  130.         </mxCell>
    131. 

  131.         <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">
    132. 

  132.           <mxGeometry x="30" width="220" height="30" as="geometry">
    133. 

  133.             <mxRectangle width="220" height="30" as="alternateBounds" />
    134. 

  134.           </mxGeometry>
    135. 

  135.         </mxCell>
    136. 

  136.         <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">
    137. 

  137.           <mxGeometry y="60" width="250" height="30" as="geometry" />
    138. 

  138.         </mxCell>
    139. 

  139.         <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">
    140. 

  140.           <mxGeometry width="30" height="30" as="geometry">
    141. 

  141.             <mxRectangle width="30" height="30" as="alternateBounds" />
    142. 

  142.           </mxGeometry>
    143. 

  143.         </mxCell>
    144. 

  144.         <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">
    145. 

  145.           <mxGeometry x="30" width="220" height="30" as="geometry">
    146. 

  146.             <mxRectangle width="220" height="30" as="alternateBounds" />
    147. 

  147.           </mxGeometry>
    148. 

  148.         </mxCell>
    149. 

  149.       </root>
    150. 

  150.     </mxGraphModel>
    151. 

  151.   </diagram>
    152. 

  152. </mxfile>
    153.