-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy patherd.dot
78 lines (78 loc) · 4.65 KB
/
erd.dot
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
digraph FoodPictures {
rankdir = "LR";
ranksep = "0.5";
nodesep = "0.4";
pad = "0.4,0.4";
margin = "0,0";
concentrate = "true";
labelloc = "t";
fontsize = "13";
fontname = "Arial BoldMT";
splines = "spline";
node[ shape = "Mrecord" , fontsize = "10" , fontname = "ArialMT" , margin = "0.07,0.05" , penwidth = "1.0"];
edge[ fontname = "ArialMT" , fontsize = "7" , dir = "both" , arrowsize = "0.9" , penwidth = "1.0" , labelangle = "32" , labeldistance = "1.8"];
rankdir = "TB";
label = "FoodPictures domain model\n\n";
m_Category [label = <{<table border="0" align="center" cellspacing="0.5" cellpadding="0" width="134">
<tr><td align="center" valign="bottom" width="130"><font face="Arial BoldMT" point-size="11">Category</font></td></tr>
</table>
|
<table border="0" align="left" cellspacing="2" cellpadding="0" width="134">
<tr><td align="left" width="130" port="name">name <font face="Arial ItalicMT" color="grey60">string</font></td></tr>
</table>
}>];
m_Comment [label = <{<table border="0" align="center" cellspacing="0.5" cellpadding="0" width="134">
<tr><td align="center" valign="bottom" width="130"><font face="Arial BoldMT" point-size="11">Comment</font></td></tr>
</table>
|
<table border="0" align="left" cellspacing="2" cellpadding="0" width="134">
<tr><td align="left" width="130" port="post_id">post_id <font face="Arial ItalicMT" color="grey60">integer FK</font></td></tr>
<tr><td align="left" width="130" port="text">text <font face="Arial ItalicMT" color="grey60">text</font></td></tr>
<tr><td align="left" width="130" port="user_id">user_id <font face="Arial ItalicMT" color="grey60">integer FK</font></td></tr>
</table>
}>];
m_Like [label = <{<table border="0" align="center" cellspacing="0.5" cellpadding="0" width="134">
<tr><td align="center" valign="bottom" width="130"><font face="Arial BoldMT" point-size="11">Like</font></td></tr>
</table>
|
<table border="0" align="left" cellspacing="2" cellpadding="0" width="134">
<tr><td align="left" width="130" port="post_id">post_id <font face="Arial ItalicMT" color="grey60">integer ∗ FK</font></td></tr>
<tr><td align="left" width="130" port="user_id">user_id <font face="Arial ItalicMT" color="grey60">integer ∗ FK</font></td></tr>
</table>
}>];
m_Post [label = <{<table border="0" align="center" cellspacing="0.5" cellpadding="0" width="134">
<tr><td align="center" valign="bottom" width="130"><font face="Arial BoldMT" point-size="11">Post</font></td></tr>
</table>
|
<table border="0" align="left" cellspacing="2" cellpadding="0" width="134">
<tr><td align="left" width="130" port="image">image <font face="Arial ItalicMT" color="grey60">string ∗</font></td></tr>
<tr><td align="left" width="130" port="name">name <font face="Arial ItalicMT" color="grey60">string ∗</font></td></tr>
<tr><td align="left" width="130" port="user_id">user_id <font face="Arial ItalicMT" color="grey60">integer FK</font></td></tr>
</table>
}>];
m_PostCategoryRelation [label = <{<table border="0" align="center" cellspacing="0.5" cellpadding="0" width="134">
<tr><td align="center" valign="bottom" width="130"><font face="Arial BoldMT" point-size="11">PostCategoryRelation</font></td></tr>
</table>
|
<table border="0" align="left" cellspacing="2" cellpadding="0" width="134">
<tr><td align="left" width="130" port="category_id">category_id <font face="Arial ItalicMT" color="grey60">integer FK</font></td></tr>
<tr><td align="left" width="130" port="post_id">post_id <font face="Arial ItalicMT" color="grey60">integer FK</font></td></tr>
</table>
}>];
m_User [label = <{<table border="0" align="center" cellspacing="0.5" cellpadding="0" width="134">
<tr><td align="center" valign="bottom" width="130"><font face="Arial BoldMT" point-size="11">User</font></td></tr>
</table>
|
<table border="0" align="left" cellspacing="2" cellpadding="0" width="134">
<tr><td align="left" width="130" port="email">email <font face="Arial ItalicMT" color="grey60">string ∗ U</font></td></tr>
<tr><td align="left" width="130" port="encrypted_password">encrypted_password <font face="Arial ItalicMT" color="grey60">string ∗</font></td></tr>
</table>
}>];
m_User -> m_Post [arrowhead = "normal", arrowtail = "none", weight = "2"];
m_User -> m_Like [arrowhead = "normal", arrowtail = "none", weight = "2"];
m_User -> m_Comment [arrowhead = "normal", arrowtail = "none", weight = "2"];
m_Category -> m_PostCategoryRelation [arrowhead = "normal", arrowtail = "none", weight = "2"];
m_Post -> m_Comment [arrowhead = "normal", arrowtail = "none", weight = "2"];
m_Post -> m_Like [arrowhead = "normal", arrowtail = "none", weight = "2"];
m_Post -> m_PostCategoryRelation [arrowhead = "normal", arrowtail = "none", weight = "2"];
}