-
Notifications
You must be signed in to change notification settings - Fork 0
/
database_representation.drawio
103 lines (103 loc) · 15.5 KB
/
database_representation.drawio
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
<mxfile host="Electron" modified="2023-07-26T21:07:06.670Z" agent="Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) draw.io/21.2.8 Chrome/114.0.5735.45 Electron/25.0.1 Safari/537.36" etag="H_TjMeyFQA411ju1Mbn5" version="21.2.8" type="device">
<diagram id="C5RBs43oDa-KdzZeNtuy" name="Page-1">
<mxGraphModel dx="880" dy="535" 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="WIyWlLk6GJQsqaUBKTNV-0" />
<mxCell id="WIyWlLk6GJQsqaUBKTNV-1" parent="WIyWlLk6GJQsqaUBKTNV-0" />
<mxCell id="MnDWyDg-Bo4ylCKECRaT-24" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.25;entryDx=0;entryDy=0;fontColor=#000000;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="MnDWyDg-Bo4ylCKECRaT-18" target="MnDWyDg-Bo4ylCKECRaT-20" edge="1">
<mxGeometry relative="1" as="geometry" />
</mxCell>
<mxCell id="MnDWyDg-Bo4ylCKECRaT-0" value="t_tracks" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=30;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;whiteSpace=wrap;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="89" y="250" width="140" height="120" as="geometry" />
</mxCell>
<mxCell id="iw2OcwuntOex66pEL4TZ-0" value="id&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <font color="#ffff00">PK</font> <font color="#cc00ff">AI</font>" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;" parent="MnDWyDg-Bo4ylCKECRaT-0" vertex="1">
<mxGeometry y="30" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="MnDWyDg-Bo4ylCKECRaT-1" value="file_path&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<font color="#ff0000">U&nbsp;</font><font color="#00ff00">NN</font>" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;" parent="MnDWyDg-Bo4ylCKECRaT-0" vertex="1">
<mxGeometry y="60" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="MnDWyDg-Bo4ylCKECRaT-18" value="<font color="#00ffff">parent_dir_id</font>" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;fontColor=#000000;" parent="MnDWyDg-Bo4ylCKECRaT-0" vertex="1">
<mxGeometry y="90" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="MnDWyDg-Bo4ylCKECRaT-5" value="<font color="#ffffff">t_albums</font>" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=30;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;whiteSpace=wrap;html=1;fontColor=#0000FF;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="559" y="315" width="140" height="120" as="geometry" />
</mxCell>
<mxCell id="iw2OcwuntOex66pEL4TZ-2" value="id&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <font color="#ffff00">PK</font> <font color="#cc00ff">AI</font>" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;" parent="MnDWyDg-Bo4ylCKECRaT-5" vertex="1">
<mxGeometry y="30" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="MnDWyDg-Bo4ylCKECRaT-6" value="<font color="#ffffff">name</font><font color="#000000">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </font><font color="#00ff00">NN</font>" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;fontColor=#0000FF;" parent="MnDWyDg-Bo4ylCKECRaT-5" vertex="1">
<mxGeometry y="60" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="MnDWyDg-Bo4ylCKECRaT-7" value="<font color="#00ffff">artist_id</font>" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;fontColor=#0000FF;" parent="MnDWyDg-Bo4ylCKECRaT-5" vertex="1">
<mxGeometry y="90" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="MnDWyDg-Bo4ylCKECRaT-10" value="<font color="#ffffff">t_artists</font>" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=30;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;whiteSpace=wrap;html=1;fontColor=#0000FF;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="289" y="330" width="140" height="90" as="geometry" />
</mxCell>
<mxCell id="iw2OcwuntOex66pEL4TZ-4" value="id&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <font color="#ffff00">PK</font> <font color="#cc00ff">AI</font>" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;" parent="MnDWyDg-Bo4ylCKECRaT-10" vertex="1">
<mxGeometry y="30" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="MnDWyDg-Bo4ylCKECRaT-11" value="<font color="#ffffff">name</font><font color="#000000">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</font><font color="#ff0000">U&nbsp;</font><font color="#00ff00">NN</font>" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;fontColor=#0000FF;" parent="MnDWyDg-Bo4ylCKECRaT-10" vertex="1">
<mxGeometry y="60" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="MnDWyDg-Bo4ylCKECRaT-14" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=1;exitY=0.5;exitDx=0;exitDy=0;fontColor=#000000;entryX=0.414;entryY=1.067;entryDx=0;entryDy=0;entryPerimeter=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="MnDWyDg-Bo4ylCKECRaT-9" target="MnDWyDg-Bo4ylCKECRaT-11" edge="1">
<mxGeometry relative="1" as="geometry">
<mxPoint x="290" y="355" as="targetPoint" />
<Array as="points">
<mxPoint x="347" y="545" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="MnDWyDg-Bo4ylCKECRaT-15" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=0;exitY=0.5;exitDx=0;exitDy=0;entryX=1;entryY=0.25;entryDx=0;entryDy=0;fontColor=#000000;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="MnDWyDg-Bo4ylCKECRaT-7" target="MnDWyDg-Bo4ylCKECRaT-10" edge="1">
<mxGeometry relative="1" as="geometry" />
</mxCell>
<mxCell id="MnDWyDg-Bo4ylCKECRaT-20" value="<font color="#ffffff">t_music_dirs</font>" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=30;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;whiteSpace=wrap;html=1;fontColor=#0000FF;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="299" y="210" width="140" height="90" as="geometry" />
</mxCell>
<mxCell id="iw2OcwuntOex66pEL4TZ-1" value="id&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <font color="#ffff00">PK</font> <font color="#cc00ff">AI</font>" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;" parent="MnDWyDg-Bo4ylCKECRaT-20" vertex="1">
<mxGeometry y="30" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="MnDWyDg-Bo4ylCKECRaT-21" value="<font color="#ffffff">path</font><font color="#000000">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</font><font color="#ff0000">U </font><font color="#00ff00">NN</font>" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;fontColor=#0000FF;" parent="MnDWyDg-Bo4ylCKECRaT-20" vertex="1">
<mxGeometry y="60" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="vxL_bxDXYX45139kfPrk-0" value="<font color="#ffffff">A -&gt; B: Table A has a <u style="">Foreign Key</u> that&nbsp;references table<br></font><font color="#ffff00">PK: Primary Key</font><br><font color="#ff0000">U: unique</font><br><font color="#00ffff">Blue rows: foreign key</font><br><font color="#00ff00">NN: Not Null<br></font><font color="#cc00ff">AI: Auto Increment</font><br><font color="#ffffff"><font style="font-size: 15px;">}</font> Composite constraint</font>" style="text;html=1;align=left;verticalAlign=middle;whiteSpace=wrap;rounded=0;strokeWidth=1;fillColor=none;strokeColor=#666666;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="20" y="20" width="320" height="110" as="geometry" />
</mxCell>
<mxCell id="3HBOodONZ7uTCCO6flhB-0" value="" style="shape=curlyBracket;whiteSpace=wrap;html=1;rounded=1;flipH=1;labelPosition=right;verticalLabelPosition=middle;align=left;verticalAlign=middle;size=0.5;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="699" y="385" width="20" height="50" as="geometry" />
</mxCell>
<mxCell id="3HBOodONZ7uTCCO6flhB-2" value="<font color="#ff0000">U</font>" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="719" y="395" width="20" height="30" as="geometry" />
</mxCell>
<mxCell id="7f8fim7yHH5pa0RV_fEL-7" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0.193;entryY=1;entryDx=0;entryDy=0;entryPerimeter=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="MnDWyDg-Bo4ylCKECRaT-3" target="MnDWyDg-Bo4ylCKECRaT-7" edge="1">
<mxGeometry relative="1" as="geometry">
<Array as="points">
<mxPoint x="586" y="575" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="7f8fim7yHH5pa0RV_fEL-8" value="t_tracks_metadata" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=30;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;whiteSpace=wrap;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="89" y="410" width="140" height="180" as="geometry" />
</mxCell>
<mxCell id="7f8fim7yHH5pa0RV_fEL-9" value="<font color="#00ffff">track_id</font><font color="#0000ff">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</font><font color="#ffff00">PK</font>" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;" parent="7f8fim7yHH5pa0RV_fEL-8" vertex="1">
<mxGeometry y="30" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="7f8fim7yHH5pa0RV_fEL-10" value="title&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <font color="#00ff00">NN</font>" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;" parent="7f8fim7yHH5pa0RV_fEL-8" vertex="1">
<mxGeometry y="60" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="7f8fim7yHH5pa0RV_fEL-11" value="track_num" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;" parent="7f8fim7yHH5pa0RV_fEL-8" vertex="1">
<mxGeometry y="90" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="MnDWyDg-Bo4ylCKECRaT-9" value="<font color="#00ffff">artist_id</font>" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;fontColor=#0000FF;" parent="7f8fim7yHH5pa0RV_fEL-8" vertex="1">
<mxGeometry y="120" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="MnDWyDg-Bo4ylCKECRaT-3" value="<font color="#00ffff">album_id</font>" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;" parent="7f8fim7yHH5pa0RV_fEL-8" vertex="1">
<mxGeometry y="150" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="7f8fim7yHH5pa0RV_fEL-12" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=0;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="7f8fim7yHH5pa0RV_fEL-9" target="MnDWyDg-Bo4ylCKECRaT-1" edge="1">
<mxGeometry relative="1" as="geometry" />
</mxCell>
</root>
</mxGraphModel>
</diagram>
</mxfile>