-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathastandard.drawio
72 lines (72 loc) · 9.85 KB
/
astandard.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
<mxfile host="app.diagrams.net" modified="2022-06-28T06:47:34.263Z" agent="5.0 (X11)" etag="BK7ohKMQMCF6vCG2ueU5" version="20.0.2" type="github">
<diagram id="-qRK9zbMe1_bCioNVyJd" name="Page-1">
<mxGraphModel dx="796" dy="481" 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="2" value="Users" style="swimlane;fontStyle=0;align=center;verticalAlign=top;childLayout=stackLayout;horizontal=1;startSize=26;horizontalStack=0;resizeParent=1;resizeLast=0;collapsible=1;marginBottom=0;rounded=0;shadow=0;strokeWidth=1;" parent="1" vertex="1">
<mxGeometry x="50" y="520" width="260" height="430" as="geometry">
<mxRectangle x="340" y="380" width="170" height="26" as="alternateBounds" />
</mxGeometry>
</mxCell>
<mxCell id="3" value="id int [increment]" style="text;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" parent="2" vertex="1">
<mxGeometry y="26" width="260" height="26" as="geometry" />
</mxCell>
<mxCell id="4" value="email varchar [unique]" style="text;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" parent="2" vertex="1">
<mxGeometry y="52" width="260" height="26" as="geometry" />
</mxCell>
<mxCell id="5" value="is_verified boolean" style="text;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" parent="2" vertex="1">
<mxGeometry y="78" width="260" height="26" as="geometry" />
</mxCell>
<mxCell id="6" value="password varchar" style="text;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" parent="2" vertex="1">
<mxGeometry y="104" width="260" height="26" as="geometry" />
</mxCell>
<mxCell id="15" value="plainPassword varchar A NE PAS METTRE" style="text;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" parent="2" vertex="1">
<mxGeometry y="130" width="260" height="26" as="geometry" />
</mxCell>
<mxCell id="7" value="lastname varchar" style="text;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" parent="2" vertex="1">
<mxGeometry y="156" width="260" height="26" as="geometry" />
</mxCell>
<mxCell id="8" value="firstname varchar" style="text;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" parent="2" vertex="1">
<mxGeometry y="182" width="260" height="26" as="geometry" />
</mxCell>
<mxCell id="9" value="reset_token varchar" style="text;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" parent="2" vertex="1">
<mxGeometry y="208" width="260" height="26" as="geometry" />
</mxCell>
<mxCell id="10" value="address varchar" style="text;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" parent="2" vertex="1">
<mxGeometry y="234" width="260" height="26" as="geometry" />
</mxCell>
<mxCell id="11" value="zipcode varchar" style="text;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" parent="2" vertex="1">
<mxGeometry y="260" width="260" height="26" as="geometry" />
</mxCell>
<mxCell id="12" value="city varchar" style="text;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" parent="2" vertex="1">
<mxGeometry y="286" width="260" height="26" as="geometry" />
</mxCell>
<mxCell id="13" value="roles json" style="text;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" parent="2" vertex="1">
<mxGeometry y="312" width="260" height="26" as="geometry" />
</mxCell>
<mxCell id="14" value="created_at datetime" style="text;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" parent="2" vertex="1">
<mxGeometry y="338" width="260" height="26" as="geometry" />
</mxCell>
<mxCell id="BxFpbg7xEbmgNqYVwfvg-16" value="<div><font style="font-size: 18px;">ASSERT</font></div><div><font style="font-size: 18px;">String-&gt; </font><span id="LC25" class="line" lang="php"><span class="c1">#[Assert\NotBlank()]</span></span><br></div><pre class="code highlight" lang="php"><span id="LC26" class="line" lang="php"> <span class="c1">#[Assert\Length(min: 2, max: 50)]<br><br>INTEGER<br></span></span><span id="LC42" class="line" lang="php"> <span class="c1">#[Assert\Positive()]</span></span><br/><span id="LC43" class="line" lang="php"> <span class="c1">#[Assert\LessThan(51)]</span></span><br/><br><code><span class="c1">#[Assert\NotBlank()]</span></code><span id="LC26" class="line" lang="php"><span class="c1"></span></span><br><br><code><span class="c1">#[Assert\NotNull()]</span></code></pre>" style="text;html=1;resizable=0;autosize=1;align=center;verticalAlign=middle;points=[];fillColor=none;strokeColor=none;rounded=0;" parent="1" vertex="1">
<mxGeometry x="90" y="275" width="280" height="190" as="geometry" />
</mxCell>
<mxCell id="VnUUd5vd1G_Qq16Phxqx-16" value="UNE TABLE UNE MIGRATION" style="text;html=1;resizable=0;autosize=1;align=center;verticalAlign=middle;points=[];fillColor=none;strokeColor=none;rounded=0;" parent="1" vertex="1">
<mxGeometry x="480" y="300" width="180" height="20" as="geometry" />
</mxCell>
<mxCell id="szllkgV6eG0ymPAvgswJ-16" value="<div>PENSEZ AU SLUG</div><div>quand on veut cliquer sur un bouton URL <br></div><div><br></div>" style="text;html=1;resizable=0;autosize=1;align=center;verticalAlign=middle;points=[];fillColor=none;strokeColor=none;rounded=0;" parent="1" vertex="1">
<mxGeometry x="465" y="355" width="230" height="50" as="geometry" />
</mxCell>
<mxCell id="wmhnd3oU8wE847apBDxU-16" value="<div>ASSOCIATION</div><div><br></div><div>1:N <br></div><div>-&gt; Ajouter une clé étrangère à la relation côté N</div><div><br></div><div>N:M</div><div>Ajouter une table contenant les deux clés étrangères</div><div><br></div><div>1:1</div><div>Ajouter une clé étrangère à l'une des deux relations et <br></div><div>une contrainte d'unicité sur cette clé<br></div>" style="text;html=1;resizable=0;autosize=1;align=center;verticalAlign=middle;points=[];fillColor=none;strokeColor=none;rounded=0;" parent="1" vertex="1">
<mxGeometry x="360" y="440" width="300" height="160" as="geometry" />
</mxCell>
<mxCell id="wmhnd3oU8wE847apBDxU-17" value="<div>Note de clarification:</div><div>Entités:</div><div>-</div><div>-</div><div>Attributs:</div><div>-Entités 1 (unique, obligatoire</div><div>entier, float, chaîne)</div><div><br></div><div>Contraintes:</div><div><br></div><div>Fonctions :</div><div><br></div>" style="text;html=1;resizable=0;autosize=1;align=center;verticalAlign=middle;points=[];fillColor=none;strokeColor=none;rounded=0;fontSize=24;" parent="1" vertex="1">
<mxGeometry x="350" y="630" width="330" height="350" as="geometry" />
</mxCell>
<mxCell id="sRgHxq2oMYONRJ9w1YdB-18" value="<div>&lt;td&gt;</div><div>{% for section in lesson.sections %}</div><div>{{section.title}}</div><div>{% endfor %}</div><div>&lt;/td&gt;</div><div><br></div>" style="text;html=1;resizable=0;autosize=1;align=center;verticalAlign=middle;points=[];fillColor=none;strokeColor=none;rounded=0;" parent="1" vertex="1">
<mxGeometry x="520" y="140" width="200" height="90" as="geometry" />
</mxCell>
</root>
</mxGraphModel>
</diagram>
</mxfile>