SoftToolsProj/GameStore_Database_Schema_Updated.drawio at main · PrimalDirect/SoftToolsProj · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
<mxfile host="app.diagrams.net" agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36" version="28.2.9">
  <diagram name="Page-1" id="xJWfFCYsSXk8RoKF-vKM">
    <mxGraphModel dx="273" dy="527" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0">
      <root>
        <mxCell id="0" />
        <mxCell id="1" parent="0" />
        <mxCell id="Vr_0xIymuRDsBlOeYywe-6" value="" style="group" parent="1" vertex="1" connectable="0">
          <mxGeometry x="319" y="70" width="190" height="140" as="geometry" />
        </mxCell>
        <mxCell id="Vr_0xIymuRDsBlOeYywe-2" value="&lt;div style=&quot;background-color: rgb(255, 255, 254); font-weight: normal; line-height: 16px; white-space: pre;&quot;&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px;&quot; face=&quot;Courier New&quot;&gt;&lt;span&gt;- TransID&amp;nbsp;INT&lt;/span&gt;&lt;span&gt;*&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px;&quot; face=&quot;Courier New&quot;&gt;&lt;span&gt;- CustomerID&amp;nbsp;&lt;/span&gt;&lt;span&gt;&lt;font&gt;INT&lt;/font&gt;&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px;&quot; face=&quot;Courier New&quot;&gt;&lt;span&gt;- CashSpent&amp;nbsp;DECIMAL&lt;/span&gt;&lt;span&gt;(&lt;/span&gt;&lt;span&gt;4&lt;/span&gt;&lt;span&gt;,&lt;/span&gt;&lt;span&gt;2&lt;/span&gt;&lt;span&gt;)&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px;&quot; face=&quot;Courier New&quot;&gt;&lt;span&gt;- PurchaseDate&amp;nbsp;DATE&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;font style=&quot;font-size: 10px;&quot; face=&quot;Courier New&quot;&gt;Foreign Key: CustomerID&lt;/font&gt;&lt;/div&gt;" style="rounded=0;whiteSpace=wrap;html=1;align=left;" parent="Vr_0xIymuRDsBlOeYywe-6" vertex="1">
          <mxGeometry y="30" width="190" height="90" as="geometry" />
        </mxCell>
        <mxCell id="Vr_0xIymuRDsBlOeYywe-4" value="CustomerTransactions" style="rounded=0;whiteSpace=wrap;html=1;" parent="Vr_0xIymuRDsBlOeYywe-6" vertex="1">
          <mxGeometry width="190" height="30" as="geometry" />
        </mxCell>
        <mxCell id="Vr_0xIymuRDsBlOeYywe-18" value="" style="group" parent="1" vertex="1" connectable="0">
          <mxGeometry x="330" y="300" width="190" height="210" as="geometry" />
        </mxCell>
        <mxCell id="Vr_0xIymuRDsBlOeYywe-19" value="&lt;div style=&quot;background-color: rgb(255, 255, 254); font-family: Consolas, &amp;quot;Courier New&amp;quot;, monospace; font-weight: normal; line-height: 16px; white-space: pre;&quot;&gt;&lt;div style=&quot;&quot;&gt;&lt;div style=&quot;background-color: rgb(255, 255, 254); line-height: 16px;&quot;&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot;&gt;- CustomerID&amp;nbsp;INT*&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot;&gt;- Forename&amp;nbsp;VARCHAR(&lt;span&gt;30&lt;/span&gt;)&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot;&gt;- &lt;/font&gt;&lt;font style=&quot;font-size: 10px;&quot;&gt;Surname&amp;nbsp;VARCHAR(30)&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px;&quot;&gt;- EmailAddress&amp;nbsp;VARCHAR(&lt;span&gt;30&lt;/span&gt;)&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font&gt;&lt;font style=&quot;&quot;&gt;- &lt;/font&gt;&lt;font style=&quot;font-size: 10px;&quot;&gt;CustPassword&amp;nbsp;VARCHAR(&lt;span&gt;30&lt;/span&gt;)&lt;/font&gt;&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px;&quot;&gt;- PhoneNo&amp;nbsp;&lt;span&gt;VARCHAR&lt;/span&gt;(&lt;span&gt;15&lt;/span&gt;)&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot;&gt;- StorageUsed&amp;nbsp;&lt;/font&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot;&gt;DECIMAL(&lt;span style=&quot;color: rgb(0, 114, 0);&quot;&gt;4&lt;/span&gt;,&lt;span style=&quot;color: rgb(0, 114, 0);&quot;&gt;2&lt;/span&gt;)&lt;/font&gt;&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot;&gt;- AvailableStorage&amp;nbsp;&lt;/font&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot;&gt;DECIMAL(&lt;span style=&quot;color: rgb(0, 114, 0);&quot;&gt;4&lt;/span&gt;,&lt;span style=&quot;color: rgb(0, 114, 0);&quot;&gt;2&lt;/span&gt;)&lt;/font&gt;&lt;/font&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;" style="rounded=0;whiteSpace=wrap;html=1;align=left;" parent="Vr_0xIymuRDsBlOeYywe-18" vertex="1">
          <mxGeometry y="45" width="190" height="165" as="geometry" />
        </mxCell>
        <mxCell id="Vr_0xIymuRDsBlOeYywe-20" value="CustomerAccount" style="rounded=0;whiteSpace=wrap;html=1;" parent="Vr_0xIymuRDsBlOeYywe-18" vertex="1">
          <mxGeometry y="10" width="190" height="35" as="geometry" />
        </mxCell>
        <mxCell id="Vr_0xIymuRDsBlOeYywe-21" value="" style="group" parent="1" vertex="1" connectable="0">
          <mxGeometry x="50" y="60" width="280" height="140" as="geometry" />
        </mxCell>
        <mxCell id="Vr_0xIymuRDsBlOeYywe-22" value="&lt;div style=&quot;background-color: rgb(255, 255, 254); font-weight: normal; line-height: 16px; white-space: pre;&quot;&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot; face=&quot;Courier New&quot;&gt;&lt;span&gt;- StaffID&amp;nbsp;&lt;/span&gt;&lt;span&gt;&lt;font&gt;INT&lt;/font&gt;&lt;/span&gt;&lt;span&gt;*&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot; face=&quot;Courier New&quot;&gt;&lt;font style=&quot;&quot;&gt;&lt;span&gt;- &lt;/span&gt;&lt;/font&gt;&lt;span style=&quot;background-color: rgb(255, 255, 254);&quot;&gt;Forename&amp;nbsp;VARCHAR(&lt;/span&gt;&lt;span style=&quot;background-color: rgb(255, 255, 254);&quot;&gt;30&lt;/span&gt;&lt;span style=&quot;background-color: rgb(255, 255, 254);&quot;&gt;)&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;background-color: rgb(255, 255, 254); line-height: 16px;&quot;&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot; face=&quot;Courier New&quot;&gt;- Surname&amp;nbsp;VARCHAR(&lt;span&gt;30&lt;/span&gt;)&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot; face=&quot;Courier New&quot;&gt;- EmailAddress&amp;nbsp;VARCHAR(&lt;span&gt;30&lt;/span&gt;)&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot; face=&quot;Courier New&quot;&gt;- StaffPassword&amp;nbsp;VARCHAR(&lt;span&gt;30&lt;/span&gt;)&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot; face=&quot;Courier New&quot;&gt;&lt;font&gt;- PhoneNo&amp;nbsp;&lt;/font&gt;&lt;font&gt;VARCHAR&lt;/font&gt;&lt;font&gt;(&lt;/font&gt;&lt;span&gt;15&lt;/span&gt;&lt;font&gt;)&lt;/font&gt;&lt;/font&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;" style="rounded=0;whiteSpace=wrap;html=1;align=left;" parent="Vr_0xIymuRDsBlOeYywe-21" vertex="1">
          <mxGeometry y="30" width="190" height="110" as="geometry" />
        </mxCell>
        <mxCell id="Vr_0xIymuRDsBlOeYywe-23" value="StaffAccount" style="rounded=0;whiteSpace=wrap;html=1;" parent="Vr_0xIymuRDsBlOeYywe-21" vertex="1">
          <mxGeometry width="190" height="30" as="geometry" />
        </mxCell>
        <mxCell id="9-DgmwWwfBlEnTAG9W8t-7" value="1" style="text;html=1;whiteSpace=wrap;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;rounded=0;" parent="Vr_0xIymuRDsBlOeYywe-21" vertex="1">
          <mxGeometry x="180" y="60" width="60" height="30" as="geometry" />
        </mxCell>
        <mxCell id="9-DgmwWwfBlEnTAG9W8t-6" value="0..*" style="text;html=1;whiteSpace=wrap;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;rounded=0;" parent="Vr_0xIymuRDsBlOeYywe-21" vertex="1">
          <mxGeometry x="220" y="90" width="60" height="30" as="geometry" />
        </mxCell>
        <mxCell id="9-DgmwWwfBlEnTAG9W8t-5" value="Has" style="text;html=1;whiteSpace=wrap;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;rounded=0;" parent="Vr_0xIymuRDsBlOeYywe-21" vertex="1">
          <mxGeometry x="190" y="90" width="60" height="30" as="geometry" />
        </mxCell>
        <mxCell id="Vr_0xIymuRDsBlOeYywe-25" value="" style="endArrow=classic;html=1;rounded=0;" parent="1" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="400" y="310" as="sourcePoint" />
            <mxPoint x="400" y="200" as="targetPoint" />
          </mxGeometry>
        </mxCell>
        <mxCell id="Vr_0xIymuRDsBlOeYywe-26" value="" style="endArrow=classic;html=1;rounded=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;" parent="1" source="Vr_0xIymuRDsBlOeYywe-22" target="Vr_0xIymuRDsBlOeYywe-2" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="250" y="150" as="sourcePoint" />
            <mxPoint x="310" y="150" as="targetPoint" />
          </mxGeometry>
        </mxCell>
        <mxCell id="Vr_0xIymuRDsBlOeYywe-28" value="" style="group" parent="1" vertex="1" connectable="0">
          <mxGeometry x="600" y="60" width="200" height="370" as="geometry" />
        </mxCell>
        <mxCell id="Vr_0xIymuRDsBlOeYywe-12" value="" style="group" parent="Vr_0xIymuRDsBlOeYywe-28" vertex="1" connectable="0">
          <mxGeometry width="190" height="140" as="geometry" />
        </mxCell>
        <mxCell id="Vr_0xIymuRDsBlOeYywe-13" value="&lt;div style=&quot;background-color: rgb(255, 255, 254); font-weight: normal; line-height: 16px; white-space: pre;&quot;&gt;&lt;div style=&quot;&quot;&gt;&lt;div style=&quot;background-color: rgb(255, 255, 254); line-height: 16px;&quot;&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot; face=&quot;Courier New&quot;&gt;- PurchaseID&amp;nbsp;INT*&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot; face=&quot;Courier New&quot;&gt;- GameID&amp;nbsp;INT&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot; face=&quot;Courier New&quot;&gt;- TotalPriceSpent&amp;nbsp;&lt;span&gt;DECIMAL&lt;/span&gt;(5,&lt;span&gt;2&lt;/span&gt;)&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot; face=&quot;Courier New&quot;&gt;Foreign Key: GameID&lt;/font&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;" style="rounded=0;whiteSpace=wrap;html=1;align=left;" parent="Vr_0xIymuRDsBlOeYywe-12" vertex="1">
          <mxGeometry y="30" width="190" height="80" as="geometry" />
        </mxCell>
        <mxCell id="Vr_0xIymuRDsBlOeYywe-14" value="PurchasedGames" style="rounded=0;whiteSpace=wrap;html=1;" parent="Vr_0xIymuRDsBlOeYywe-12" vertex="1">
          <mxGeometry width="190" height="30" as="geometry" />
        </mxCell>
        <mxCell id="Vr_0xIymuRDsBlOeYywe-27" value="" style="group" parent="Vr_0xIymuRDsBlOeYywe-28" vertex="1" connectable="0">
          <mxGeometry x="10" y="140" width="190" height="230" as="geometry" />
        </mxCell>
        <mxCell id="Vr_0xIymuRDsBlOeYywe-8" value="" style="group" parent="Vr_0xIymuRDsBlOeYywe-27" vertex="1" connectable="0">
          <mxGeometry y="70" width="190" height="160" as="geometry" />
        </mxCell>
        <mxCell id="Vr_0xIymuRDsBlOeYywe-3" value="&lt;div style=&quot;background-color: rgb(255, 255, 254); line-height: 16px; white-space: pre;&quot;&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot; face=&quot;Courier New&quot;&gt;&lt;font style=&quot;&quot;&gt;- GameID&amp;nbsp;&lt;/font&gt;&lt;font style=&quot;&quot;&gt;INT&lt;/font&gt;&lt;font style=&quot;&quot;&gt;*&lt;/font&gt;&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot; face=&quot;Courier New&quot;&gt;- GameName&amp;nbsp;VARCHAR(&lt;span&gt;255&lt;/span&gt;)&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot; face=&quot;Courier New&quot;&gt;- GameDescription&amp;nbsp;VARCHAR(&lt;span&gt;255&lt;/span&gt;)&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot; face=&quot;Courier New&quot;&gt;- GameGenre&amp;nbsp;VARCHAR(&lt;span&gt;30&lt;/span&gt;)&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot; face=&quot;Courier New&quot;&gt;- GameStorage&amp;nbsp;&lt;span&gt;DECIMAL&lt;/span&gt;(&lt;span&gt;4&lt;/span&gt;,&lt;span&gt;2&lt;/span&gt;)&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot; face=&quot;Courier New&quot;&gt;- GameBuyPrice&amp;nbsp;&lt;span&gt;DECIMAL&lt;/span&gt;(&lt;span&gt;3&lt;/span&gt;,&lt;span&gt;2&lt;/span&gt;)&lt;/font&gt;&lt;/div&gt;&lt;div style=&quot;&quot;&gt;&lt;font style=&quot;font-size: 10px; color: rgb(0, 0, 0);&quot; face=&quot;Courier New&quot;&gt;- GameBoxArt&amp;nbsp;VARBINARY(MAX)&lt;/font&gt;&lt;/div&gt;&lt;/div&gt;" style="rounded=0;whiteSpace=wrap;html=1;align=left;" parent="Vr_0xIymuRDsBlOeYywe-8" vertex="1">
          <mxGeometry y="32" width="190" height="128" as="geometry" />
        </mxCell>
        <mxCell id="Vr_0xIymuRDsBlOeYywe-5" value="VideoGames" style="rounded=0;whiteSpace=wrap;html=1;" parent="Vr_0xIymuRDsBlOeYywe-8" vertex="1">
          <mxGeometry width="190" height="32" as="geometry" />
        </mxCell>
        <mxCell id="9-DgmwWwfBlEnTAG9W8t-2" value="0..*" style="text;html=1;whiteSpace=wrap;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;rounded=0;" parent="Vr_0xIymuRDsBlOeYywe-27" vertex="1">
          <mxGeometry x="30" width="60" height="30" as="geometry" />
        </mxCell>
        <mxCell id="9-DgmwWwfBlEnTAG9W8t-1" value="1" style="text;html=1;whiteSpace=wrap;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;rounded=0;" parent="Vr_0xIymuRDsBlOeYywe-27" vertex="1">
          <mxGeometry x="70" y="40" width="60" height="30" as="geometry" />
        </mxCell>
        <mxCell id="9-DgmwWwfBlEnTAG9W8t-10" value="Can become" style="text;html=1;whiteSpace=wrap;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;rounded=0;labelBackgroundColor=default;" parent="Vr_0xIymuRDsBlOeYywe-27" vertex="1">
          <mxGeometry x="90" y="20" width="80" height="20" as="geometry" />
        </mxCell>
        <mxCell id="Vr_0xIymuRDsBlOeYywe-24" value="" style="endArrow=classic;html=1;rounded=0;" parent="Vr_0xIymuRDsBlOeYywe-27" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="90" y="70" as="sourcePoint" />
            <mxPoint x="90" y="-30" as="targetPoint" />
          </mxGeometry>
        </mxCell>
        <mxCell id="9-DgmwWwfBlEnTAG9W8t-3" value="1" style="text;html=1;whiteSpace=wrap;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;rounded=0;" parent="1" vertex="1">
          <mxGeometry x="400" y="280" width="60" height="30" as="geometry" />
        </mxCell>
        <mxCell id="9-DgmwWwfBlEnTAG9W8t-4" value="0..*" style="text;html=1;whiteSpace=wrap;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;rounded=0;" parent="1" vertex="1">
          <mxGeometry x="400" y="200" width="60" height="30" as="geometry" />
        </mxCell>
        <mxCell id="9-DgmwWwfBlEnTAG9W8t-9" value="Has&amp;nbsp;" style="text;html=1;whiteSpace=wrap;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;rounded=0;" parent="1" vertex="1">
          <mxGeometry x="420" y="250" width="60" height="30" as="geometry" />
        </mxCell>
      </root>
    </mxGraphModel>
  </diagram>
</mxfile>