-
Notifications
You must be signed in to change notification settings - Fork 2
Expand file tree
/
Copy pathERD.drawio
More file actions
28 lines (28 loc) · 2.82 KB
/
ERD.drawio
File metadata and controls
28 lines (28 loc) · 2.82 KB
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
<mxfile host="65bd71144e">
<diagram id="BjO8PmjP9vLV3g4-xzOb" name="Page-1">
<mxGraphModel dx="587" dy="394" 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">
<root>
<mxCell id="0"/>
<mxCell id="1" parent="0"/>
<mxCell id="51" value="users" style="swimlane;childLayout=stackLayout;horizontal=1;startSize=30;horizontalStack=0;rounded=1;fontSize=14;fontStyle=0;strokeWidth=2;resizeParent=0;resizeLast=1;shadow=0;dashed=0;align=center;" vertex="1" parent="1">
<mxGeometry x="40" y="40" width="160" height="180" as="geometry"/>
</mxCell>
<mxCell id="52" value="userId: integer, username: string, password: string, email: string, posts: [{ postId: integer ("FK" of post by user) }] " style="align=left;strokeColor=none;fillColor=none;spacingLeft=4;fontSize=12;verticalAlign=top;resizable=0;rotatable=0;part=1;" vertex="1" parent="51">
<mxGeometry y="30" width="160" height="150" as="geometry"/>
</mxCell>
<mxCell id="55" value="posts" style="swimlane;childLayout=stackLayout;horizontal=1;startSize=30;horizontalStack=0;rounded=1;fontSize=14;fontStyle=0;strokeWidth=2;resizeParent=0;resizeLast=1;shadow=0;dashed=0;align=center;" vertex="1" parent="1">
<mxGeometry x="320" y="40" width="210" height="250" as="geometry"/>
</mxCell>
<mxCell id="56" value="postId: integer, userId: integer ("FK" of user that made the post), isReview: boolean, postTitle: string, postBody: string, taggedGame: integer, rating: integer, imageUrl: string, comments: [{ userId: integer ("FK" of user who made the comment), body: string }] " style="align=left;strokeColor=none;fillColor=none;spacingLeft=4;fontSize=12;verticalAlign=top;resizable=0;rotatable=0;part=1;" vertex="1" parent="55">
<mxGeometry y="30" width="210" height="220" as="geometry"/>
</mxCell>
<mxCell id="57" value="" style="edgeStyle=entityRelationEdgeStyle;fontSize=12;html=1;endArrow=ERoneToMany;" edge="1" parent="1" source="52" target="56">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="220" y="240" as="sourcePoint"/>
<mxPoint x="320" y="140" as="targetPoint"/>
</mxGeometry>
</mxCell>
</root>
</mxGraphModel>
</diagram>
</mxfile>