-
Notifications
You must be signed in to change notification settings - Fork 1
/
erd.dot
105 lines (105 loc) · 7.61 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
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
digraph ColaAquiApi {
rankdir = "LR";
ranksep = "0.5";
nodesep = "0.4";
pad = "0.4,0.4";
margin = "0,0";
concentrate = "true";
labelloc = "t";
fontsize = "13";
fontname = "Arial Bold";
splines = "spline";
node[ shape = "Mrecord" , fontsize = "10" , fontname = "Arial" , margin = "0.07,0.05" , penwidth = "1.0"];
edge[ fontname = "Arial" , fontsize = "7" , dir = "both" , arrowsize = "0.9" , penwidth = "1.0" , labelangle = "32" , labeldistance = "1.8"];
rankdir = "TB";
label = "ColaAquiApi domain model\n\n";
m_Address [label = <{<table border="0" align="center" cellspacing="0.5" cellpadding="0" width="134">
<tr><td align="center" valign="bottom" width="130"><font face="Arial Bold" point-size="11">Address</font></td></tr>
</table>
|
<table border="0" align="left" cellspacing="2" cellpadding="0" width="134">
<tr><td align="left" width="130" port="city">city <font face="Arial Italic" color="grey60">string ∗</font></td></tr>
<tr><td align="left" width="130" port="district">district <font face="Arial Italic" color="grey60">string ∗</font></td></tr>
<tr><td align="left" width="130" port="party_place_id">party_place_id <font face="Arial Italic" color="grey60">integer (8) ∗ FK</font></td></tr>
<tr><td align="left" width="130" port="place_number">place_number <font face="Arial Italic" color="grey60">string ∗</font></td></tr>
<tr><td align="left" width="130" port="postal_code">postal_code <font face="Arial Italic" color="grey60">string ∗</font></td></tr>
<tr><td align="left" width="130" port="street">street <font face="Arial Italic" color="grey60">string ∗</font></td></tr>
</table>
}>];
m_Checkin [label = <{<table border="0" align="center" cellspacing="0.5" cellpadding="0" width="134">
<tr><td align="center" valign="bottom" width="130"><font face="Arial Bold" point-size="11">Checkin</font></td></tr>
</table>
|
<table border="0" align="left" cellspacing="2" cellpadding="0" width="134">
<tr><td align="left" width="130" port="party_place_id">party_place_id <font face="Arial Italic" color="grey60">integer (8) FK</font></td></tr>
<tr><td align="left" width="130" port="partyer_id">partyer_id <font face="Arial Italic" color="grey60">integer (8) FK</font></td></tr>
</table>
}>];
m_PartyFeature [label = <{<table border="0" align="center" cellspacing="0.5" cellpadding="0" width="134">
<tr><td align="center" valign="bottom" width="130"><font face="Arial Bold" point-size="11">PartyFeature</font></td></tr>
</table>
|
<table border="0" align="left" cellspacing="2" cellpadding="0" width="134">
<tr><td align="left" width="130" port="available_tables">available_tables <font face="Arial Italic" color="grey60">boolean (0)</font></td></tr>
<tr><td align="left" width="130" port="completed">completed <font face="Arial Italic" color="grey60">boolean (0)</font></td></tr>
<tr><td align="left" width="130" port="party_place_id">party_place_id <font face="Arial Italic" color="grey60">integer (8) ∗ FK</font></td></tr>
<tr><td align="left" width="130" port="smoke_place">smoke_place <font face="Arial Italic" color="grey60">boolean (0)</font></td></tr>
</table>
}>];
m_PartyPlace [label = <{<table border="0" align="center" cellspacing="0.5" cellpadding="0" width="134">
<tr><td align="center" valign="bottom" width="130"><font face="Arial Bold" point-size="11">PartyPlace</font></td></tr>
</table>
|
<table border="0" align="left" cellspacing="2" cellpadding="0" width="134">
<tr><td align="left" width="130" port="cellphone">cellphone <font face="Arial Italic" color="grey60">string ∗</font></td></tr>
<tr><td align="left" width="130" port="cnpj">cnpj <font face="Arial Italic" color="grey60">string ∗ U</font></td></tr>
<tr><td align="left" width="130" port="main_contact">main_contact <font face="Arial Italic" color="grey60">string ∗</font></td></tr>
<tr><td align="left" width="130" port="name">name <font face="Arial Italic" color="grey60">string ∗</font></td></tr>
<tr><td align="left" width="130" port="phone">phone <font face="Arial Italic" color="grey60">string</font></td></tr>
<tr><td align="left" width="130" port="user_id">user_id <font face="Arial Italic" color="grey60">integer (8) FK</font></td></tr>
</table>
}>];
m_Partyer [label = <{<table border="0" align="center" cellspacing="0.5" cellpadding="0" width="134">
<tr><td align="center" valign="bottom" width="130"><font face="Arial Bold" point-size="11">Partyer</font></td></tr>
</table>
|
<table border="0" align="left" cellspacing="2" cellpadding="0" width="134">
<tr><td align="left" width="130" port="birth_date">birth_date <font face="Arial Italic" color="grey60">date ∗</font></td></tr>
<tr><td align="left" width="130" port="checkins_id">checkins_id <font face="Arial Italic" color="grey60">integer (8)</font></td></tr>
<tr><td align="left" width="130" port="gender">gender <font face="Arial Italic" color="grey60">string ∗</font></td></tr>
<tr><td align="left" width="130" port="name">name <font face="Arial Italic" color="grey60">string ∗</font></td></tr>
<tr><td align="left" width="130" port="user_id">user_id <font face="Arial Italic" color="grey60">integer (8) FK</font></td></tr>
</table>
}>];
m_Session [label = <{<table border="0" align="center" cellspacing="0.5" cellpadding="0" width="134">
<tr><td align="center" valign="bottom" width="130"><font face="Arial Bold" point-size="11">Session</font></td></tr>
</table>
|
<table border="0" align="left" cellspacing="2" cellpadding="0" width="134">
<tr><td align="left" width="130" port="last_used_at">last_used_at <font face="Arial Italic" color="grey60">datetime (6,0)</font></td></tr>
<tr><td align="left" width="130" port="session_id">session_id <font face="Arial Italic" color="grey60">integer</font></td></tr>
<tr><td align="left" width="130" port="status">status <font face="Arial Italic" color="grey60">boolean (0)</font></td></tr>
<tr><td align="left" width="130" port="token">token <font face="Arial Italic" color="grey60">string ∗ U</font></td></tr>
<tr><td align="left" width="130" port="user_id">user_id <font face="Arial Italic" color="grey60">integer (8) ∗ 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 Bold" 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="confirm_token">confirm_token <font face="Arial Italic" color="grey60">string</font></td></tr>
<tr><td align="left" width="130" port="email">email <font face="Arial Italic" color="grey60">string ∗ U</font></td></tr>
<tr><td align="left" width="130" port="email_confirmed">email_confirmed <font face="Arial Italic" color="grey60">boolean (0)</font></td></tr>
<tr><td align="left" width="130" port="password_digest">password_digest <font face="Arial Italic" color="grey60">string ∗</font></td></tr>
<tr><td align="left" width="130" port="user_type">user_type <font face="Arial Italic" color="grey60">string ∗</font></td></tr>
</table>
}>];
m_User -> m_Session [arrowhead = "normal", arrowtail = "none", weight = "2"];
m_User -> m_Partyer [arrowhead = "normal", arrowtail = "none", weight = "1"];
m_Partyer -> m_Checkin [arrowhead = "normal", arrowtail = "none", weight = "2"];
m_User -> m_PartyPlace [arrowhead = "normal", arrowtail = "none", weight = "1"];
m_PartyPlace -> m_Address [arrowhead = "none", arrowtail = "none", weight = "2"];
m_PartyPlace -> m_PartyFeature [arrowhead = "none", arrowtail = "none", weight = "2"];
m_PartyPlace -> m_Checkin [arrowhead = "normal", arrowtail = "none", weight = "2"];
}