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
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
|
- <?xml version="1.0" encoding="UTF-8" standalone="no"?><svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" contentScriptType="application/ecmascript" contentStyleType="text/css" height="713px" preserveAspectRatio="none" style="width:915px;height:713px;" version="1.1" viewBox="0 0 915 713" width="915px" zoomAndPan="magnify"><defs><filter height="300%" id="fd07sfxkvmohr" width="300%" x="-1" y="-1"><feGaussianBlur result="blurOut" stdDeviation="2.0"/><feColorMatrix in="blurOut" result="blurOut2" type="matrix" values="0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 .4 0"/><feOffset dx="4.0" dy="4.0" in="blurOut2" result="blurOut3"/><feBlend in="SourceGraphic" in2="blurOut3" mode="normal"/></filter></defs><g><text fill="#000000" font-family="sans-serif" font-size="18" lengthAdjust="spacingAndGlyphs" textLength="139" x="392" y="18.6855">GoodReads Data</text><!--MD5=[6c6b3aaf420271ef2abb87aa755b195f]
- class isbn_id--><rect fill="#FFFFFF" filter="url(#fd07sfxkvmohr)" height="68.7656" id="isbn_id" style="stroke: #7253ED; stroke-width: 1.5;" width="47" x="686" y="400.6406"/><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="41" x="689" y="418.0977">isbn_id</text><line style="stroke: #7253ED; stroke-width: 1.5;" x1="687" x2="732" y1="425.7344" y2="425.7344"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="34" x="692" y="441.1533">isbn_id</text><line style="stroke: #7253ED; stroke-width: 1.0;" x1="687" x2="732" y1="447.5703" y2="447.5703"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="20" x="692" y="462.9893">isbn</text><!--MD5=[74cc8024e60fab674a41ae0c7b76879d]
- class isbn_cluster--><rect fill="#FFFFFF" filter="url(#fd07sfxkvmohr)" height="68.7656" id="isbn_cluster" style="stroke: #7253ED; stroke-width: 1.5;" width="74" x="768.5" y="400.6406"/><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="68" x="771.5" y="418.0977">isbn_cluster</text><line style="stroke: #7253ED; stroke-width: 1.5;" x1="769.5" x2="841.5" y1="425.7344" y2="425.7344"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="33" x="774.5" y="441.1533">cluster</text><line style="stroke: #7253ED; stroke-width: 1.0;" x1="769.5" x2="841.5" y1="447.5703" y2="447.5703"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="34" x="774.5" y="462.9893">isbn_id</text><!--MD5=[415123ad967c7c405bea6f0246de33f5]
- class raw_book--><rect fill="#FFFFFF" filter="url(#fd07sfxkvmohr)" height="68.7656" id="raw_book" style="stroke: #7253ED; stroke-width: 1.5;" width="78" x="579.5" y="30.6406"/><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="54" x="591.5" y="48.0977">raw_book</text><line style="stroke: #7253ED; stroke-width: 1.5;" x1="580.5" x2="656.5" y1="55.7344" y2="55.7344"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="57" x="585.5" y="71.1533">gr_book_rid</text><line style="stroke: #7253ED; stroke-width: 1.0;" x1="580.5" x2="656.5" y1="77.5703" y2="77.5703"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="66" x="585.5" y="92.9893">gr_book_data</text><!--MD5=[ed164f6408ca00ccead55c5ee1adb652]
- class raw_work--><rect fill="#FFFFFF" filter="url(#fd07sfxkvmohr)" height="68.7656" id="raw_work" style="stroke: #7253ED; stroke-width: 1.5;" width="80" x="45.5" y="30.6406"/><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="53" x="59" y="48.0977">raw_work</text><line style="stroke: #7253ED; stroke-width: 1.5;" x1="46.5" x2="124.5" y1="55.7344" y2="55.7344"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="59" x="51.5" y="71.1533">gr_work_rid</text><line style="stroke: #7253ED; stroke-width: 1.0;" x1="46.5" x2="124.5" y1="77.5703" y2="77.5703"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="68" x="51.5" y="92.9893">gr_work_data</text><!--MD5=[9bbd1b7f37a525cc08a85513d14cb883]
- class raw_book_genres--><rect fill="#FFFFFF" filter="url(#fd07sfxkvmohr)" height="68.7656" id="raw_book_genres" style="stroke: #7253ED; stroke-width: 1.5;" width="118" x="786.5" y="30.6406"/><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="100" x="795.5" y="48.0977">raw_book_genres</text><line style="stroke: #7253ED; stroke-width: 1.5;" x1="787.5" x2="903.5" y1="55.7344" y2="55.7344"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="97" x="792.5" y="71.1533">gr_book_genres_rid</text><line style="stroke: #7253ED; stroke-width: 1.0;" x1="787.5" x2="903.5" y1="77.5703" y2="77.5703"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="106" x="792.5" y="92.9893">gr_book_genres_data</text><!--MD5=[b2910436a5a59b5015a21ff9eb41c0e8]
- class raw_interaction--><rect fill="#FFFFFF" filter="url(#fd07sfxkvmohr)" height="68.7656" id="raw_interaction" style="stroke: #7253ED; stroke-width: 1.5;" width="105" x="310" y="194.6406"/><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="84" x="320.5" y="212.0977">raw_interaction</text><line style="stroke: #7253ED; stroke-width: 1.5;" x1="311" x2="414" y1="219.7344" y2="219.7344"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="84" x="316" y="235.1533">gr_interaction_rid</text><line style="stroke: #7253ED; stroke-width: 1.0;" x1="311" x2="414" y1="241.5703" y2="241.5703"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="93" x="316" y="256.9893">gr_interaction_data</text><!--MD5=[b781041c31f14b6772e71d4f4b3459c0]
- class work_ids--><rect fill="#F5F6FA" filter="url(#fd07sfxkvmohr)" height="83.8594" id="work_ids" style="stroke: #7253ED; stroke-width: 1.5;" width="71" x="6" y="187.1406"/><text fill="#000000" font-family="sans-serif" font-size="12" font-style="italic" lengthAdjust="spacingAndGlyphs" textLength="55" x="14" y="204.5977">«derived»</text><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="50" x="16.5" y="219.6914">work_ids</text><line style="stroke: #7253ED; stroke-width: 1.5;" x1="7" x2="76" y1="227.3281" y2="227.3281"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="59" x="12" y="242.7471">gr_work_rid</text><line style="stroke: #7253ED; stroke-width: 1.0;" x1="7" x2="76" y1="249.1641" y2="249.1641"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="55" x="12" y="264.583">gr_work_id</text><!--MD5=[c1208943dce532f8f45f1fac6e2c404a]
- class book_ids--><rect fill="#F5F6FA" filter="url(#fd07sfxkvmohr)" height="139.2031" id="book_ids" style="stroke: #7253ED; stroke-width: 1.5;" width="81" x="578" y="159.6406"/><text fill="#000000" font-family="sans-serif" font-size="12" font-style="italic" lengthAdjust="spacingAndGlyphs" textLength="55" x="591" y="177.0977">«derived»</text><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="51" x="593" y="192.1914">book_ids</text><line style="stroke: #7253ED; stroke-width: 1.5;" x1="579" x2="658" y1="199.8281" y2="199.8281"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="57" x="584" y="215.2471">gr_book_rid</text><line style="stroke: #7253ED; stroke-width: 1.0;" x1="579" x2="658" y1="221.6641" y2="221.6641"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="55" x="598" y="237.083">gr_work_id</text><polygon fill="none" points="589,241.5,593,245.5,589,249.5,585,245.5" style="stroke: #B38D22; stroke-width: 1.0;"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="53" x="598" y="250.9189">gr_book_id</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="36" x="598" y="264.7549">gr_asin</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="36" x="598" y="278.5908">gr_isbn</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="48" x="598" y="292.4268">gr_isbn13</text><!--MD5=[fcfcc3758cbdf4eb3a16b55990c822f8]
- class book_isbn--><rect fill="#F5F6FA" filter="url(#fd07sfxkvmohr)" height="97.6953" id="book_isbn" style="stroke: #7253ED; stroke-width: 1.5;" width="65" x="586" y="386.1406"/><text fill="#000000" font-family="sans-serif" font-size="12" font-style="italic" lengthAdjust="spacingAndGlyphs" textLength="55" x="591" y="403.5977">«derived»</text><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="58" x="589.5" y="418.6914">book_isbn</text><line style="stroke: #7253ED; stroke-width: 1.5;" x1="587" x2="650" y1="426.3281" y2="426.3281"/><line style="stroke: #7253ED; stroke-width: 1.0;" x1="587" x2="650" y1="434.3281" y2="434.3281"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="53" x="592" y="449.7471">gr_book_id</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="34" x="592" y="463.583">isbn_id</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="53" x="592" y="477.4189">book_code</text><!--MD5=[27909fe156ffdf724518b6fbb93b1b18]
- class book_genres--><rect fill="#F5F6FA" filter="url(#fd07sfxkvmohr)" height="111.5313" id="book_genres" style="stroke: #7253ED; stroke-width: 1.5;" width="79" x="806" y="173.1406"/><text fill="#000000" font-family="sans-serif" font-size="12" font-style="italic" lengthAdjust="spacingAndGlyphs" textLength="55" x="818" y="190.5977">«derived»</text><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="73" x="809" y="205.6914">book_genres</text><line style="stroke: #7253ED; stroke-width: 1.5;" x1="807" x2="884" y1="213.3281" y2="213.3281"/><line style="stroke: #7253ED; stroke-width: 1.0;" x1="807" x2="884" y1="221.3281" y2="221.3281"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="57" x="812" y="236.7471">gr_book_rid</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="53" x="812" y="250.583">gr_book_id</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="28" x="812" y="264.4189">genre</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="28" x="812" y="278.2549">score</text><!--MD5=[3f0410370673b85f64c2be2251db956f]
- class work_title--><rect fill="#F5F6FA" filter="url(#fd07sfxkvmohr)" height="97.6953" id="work_title" style="stroke: #7253ED; stroke-width: 1.5;" width="71" x="51" y="386.1406"/><text fill="#000000" font-family="sans-serif" font-size="12" font-style="italic" lengthAdjust="spacingAndGlyphs" textLength="55" x="59" y="403.5977">«derived»</text><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="52" x="60.5" y="418.6914">work_title</text><line style="stroke: #7253ED; stroke-width: 1.5;" x1="52" x2="121" y1="426.3281" y2="426.3281"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="59" x="57" y="441.7471">gr_work_rid</text><line style="stroke: #7253ED; stroke-width: 1.0;" x1="52" x2="121" y1="448.1641" y2="448.1641"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="55" x="57" y="463.583">gr_work_id</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="44" x="57" y="477.4189">work_itle</text><!--MD5=[6a6ce171915f6ec26364f073dc894b59]
- class work_pub_date--><rect fill="#F5F6FA" filter="url(#fd07sfxkvmohr)" height="139.2031" id="work_pub_date" style="stroke: #7253ED; stroke-width: 1.5;" width="91" x="184" y="159.6406"/><text fill="#000000" font-family="sans-serif" font-size="12" font-style="italic" lengthAdjust="spacingAndGlyphs" textLength="55" x="202" y="177.0977">«derived»</text><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="85" x="187" y="192.1914">work_pub_date</text><line style="stroke: #7253ED; stroke-width: 1.5;" x1="185" x2="274" y1="199.8281" y2="199.8281"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="59" x="190" y="215.2471">gr_work_rid</text><line style="stroke: #7253ED; stroke-width: 1.0;" x1="185" x2="274" y1="221.6641" y2="221.6641"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="55" x="190" y="237.083">gr_work_id</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="46" x="190" y="250.9189">pub_year</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="53" x="190" y="264.7549">pub_month</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="42" x="190" y="278.5908">pub_day</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="45" x="190" y="292.4268">pub_date</text><!--MD5=[46b32ce629b39c3a106c8f3ad71aed90]
- class book_pub_date--><rect fill="#F5F6FA" filter="url(#fd07sfxkvmohr)" height="139.2031" id="book_pub_date" style="stroke: #7253ED; stroke-width: 1.5;" width="92" x="450.5" y="159.6406"/><text fill="#000000" font-family="sans-serif" font-size="12" font-style="italic" lengthAdjust="spacingAndGlyphs" textLength="55" x="469" y="177.0977">«derived»</text><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="86" x="453.5" y="192.1914">book_pub_date</text><line style="stroke: #7253ED; stroke-width: 1.5;" x1="451.5" x2="541.5" y1="199.8281" y2="199.8281"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="57" x="456.5" y="215.2471">gr_book_rid</text><line style="stroke: #7253ED; stroke-width: 1.0;" x1="451.5" x2="541.5" y1="221.6641" y2="221.6641"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="53" x="456.5" y="237.083">gr_book_id</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="46" x="456.5" y="250.9189">pub_year</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="53" x="456.5" y="264.7549">pub_month</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="42" x="456.5" y="278.5908">pub_day</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="45" x="456.5" y="292.4268">pub_date</text><!--MD5=[6c5f76190100f321fda0b0763835a669]
- class user_ids--><rect fill="#F5F6FA" filter="url(#fd07sfxkvmohr)" height="83.8594" id="user_ids" style="stroke: #7253ED; stroke-width: 1.5;" width="68" x="265.5" y="595.1406"/><text fill="#000000" font-family="sans-serif" font-size="12" font-style="italic" lengthAdjust="spacingAndGlyphs" textLength="55" x="272" y="612.5977">«derived»</text><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="49" x="275" y="627.6914">user_ids</text><line style="stroke: #7253ED; stroke-width: 1.5;" x1="266.5" x2="332.5" y1="635.3281" y2="635.3281"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="56" x="271.5" y="650.7471">gr_user_rid</text><line style="stroke: #7253ED; stroke-width: 1.0;" x1="266.5" x2="332.5" y1="657.1641" y2="657.1641"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="52" x="271.5" y="672.583">gr_user_id</text><!--MD5=[4efca44161d4247202deaa979ff90fdb]
- class interaction--><rect fill="#F5F6FA" filter="url(#fd07sfxkvmohr)" height="153.0391" id="interaction" style="stroke: #7253ED; stroke-width: 1.5;" width="96" x="370.5" y="358.6406"/><text fill="#000000" font-family="sans-serif" font-size="12" font-style="italic" lengthAdjust="spacingAndGlyphs" textLength="55" x="391" y="376.0977">«derived»</text><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="57" x="390" y="391.1914">interaction</text><line style="stroke: #7253ED; stroke-width: 1.5;" x1="371.5" x2="465.5" y1="398.8281" y2="398.8281"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="84" x="376.5" y="414.2471">gr_interaction_rid</text><line style="stroke: #7253ED; stroke-width: 1.0;" x1="371.5" x2="465.5" y1="420.6641" y2="420.6641"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="53" x="376.5" y="436.083">gr_book_id</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="56" x="376.5" y="449.9189">gr_user_rid</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="27" x="376.5" y="463.7549">rating</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="36" x="376.5" y="477.5908">is_read</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="45" x="376.5" y="491.4268">date_add</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="66" x="376.5" y="505.2627">date_updated</text><!--MD5=[2eac969dd808a5f35f2990cb5d945bb2]
- class rating--><rect fill="#F5F6FA" filter="url(#fd07sfxkvmohr)" height="131.2031" id="rating" style="stroke: #7253ED; stroke-width: 1.5;" width="113" x="517" y="571.6406"/><text fill="#000000" font-family="sans-serif" font-size="12" font-style="italic" lengthAdjust="spacingAndGlyphs" textLength="55" x="546" y="589.0977">«derived»</text><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="31" x="558" y="604.1914">rating</text><line style="stroke: #7253ED; stroke-width: 1.5;" x1="518" x2="629" y1="611.8281" y2="611.8281"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="101" x="523" y="627.2471">user_id : gr_user_rid</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="79" x="523" y="641.083">book_id : cluster</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="27" x="523" y="654.9189">rating</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="50" x="523" y="668.7549">last_rating</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="48" x="523" y="682.5908">timestamp</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="39" x="523" y="696.4268">nratings</text><!--MD5=[81d7fe74b9f0a787ef9c5c080a006fb2]
- class add_action--><rect fill="#F5F6FA" filter="url(#fd07sfxkvmohr)" height="117.3672" id="add_action" style="stroke: #7253ED; stroke-width: 1.5;" width="113" x="369" y="578.6406"/><text fill="#000000" font-family="sans-serif" font-size="12" font-style="italic" lengthAdjust="spacingAndGlyphs" textLength="55" x="398" y="596.0977">«derived»</text><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="61" x="395" y="611.1914">add_action</text><line style="stroke: #7253ED; stroke-width: 1.5;" x1="370" x2="481" y1="618.8281" y2="618.8281"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="101" x="375" y="634.2471">user_id : gr_user_rid</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="79" x="375" y="648.083">book_id : cluster</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="44" x="375" y="661.9189">first_time</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="42" x="375" y="675.7549">last_time</text><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="41" x="375" y="689.5908">nactions</text><!--MD5=[5157b17b2d97c4b13e7a7d5c7e3e7d7e]
- class book_cluster--><rect fill="#FFFFFF" filter="url(#fd07sfxkvmohr)" height="68.7656" id="book_cluster" style="stroke: #7253ED; stroke-width: 1.5;" width="77" x="694" y="194.6406"/><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="71" x="697" y="212.0977">book_cluster</text><line style="stroke: #7253ED; stroke-width: 1.5;" x1="695" x2="770" y1="219.7344" y2="219.7344"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="53" x="700" y="235.1533">gr_book_id</text><line style="stroke: #7253ED; stroke-width: 1.0;" x1="695" x2="770" y1="241.5703" y2="241.5703"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="33" x="700" y="256.9893">cluster</text><!--MD5=[e51701f3dcee832d2377b4f7148e538d]
- link isbn_id to isbn_cluster--><path d="M733.23,435.6406 C733.23,435.6406 760.219,435.6406 760.219,435.6406 " fill="none" id="isbn_id->isbn_cluster" style="stroke: #27262B; stroke-width: 1.0;"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="760.219" x2="768.219" y1="435.6406" y2="429.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="760.219" x2="768.219" y1="435.6406" y2="441.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="760.219" x2="768.219" y1="435.6406" y2="435.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="758.219" x2="758.219" y1="431.6406" y2="439.6406"/><!--MD5=[dc3ebd1fdc3e09e8a27c981f7e1f79a6]
- reverse link raw_work to work_ids--><path d="M56,104.9206 C56,104.9206 56,187.1396 56,187.1396 " fill="none" id="raw_work<-work_ids" style="stroke: #27262B; stroke-width: 1.0; stroke-dasharray: 7.0,7.0;"/><polygon fill="#27262B" points="56,99.9206,52,108.9206,56,104.9206,60,108.9206,56,99.9206" style="stroke: #27262B; stroke-width: 1.0;"/><!--MD5=[45992304211fccd9568e28a0b4ea0ee9]
- link raw_work to work_ids--><path d="M66.5,106.9206 C66.5,106.9206 66.5,180.1396 66.5,180.1396 " fill="none" id="raw_work-work_ids" style="stroke: #27262B; stroke-width: 1.0;"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="70.5" x2="62.5" y1="183.1396" y2="183.1396"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="70.5" x2="62.5" y1="180.1396" y2="180.1396"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="66.5" x2="66.5" y1="179.1396" y2="187.1396"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="62.5" x2="70.5" y1="103.9206" y2="103.9206"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="62.5" x2="70.5" y1="106.9206" y2="106.9206"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="66.5" x2="66.5" y1="107.9206" y2="99.9206"/><!--MD5=[8992ee73c30338af700a8ba006cf3611]
- reverse link raw_book to book_ids--><path d="M605.5,104.9206 C605.5,104.9206 605.5,159.6266 605.5,159.6266 " fill="none" id="raw_book<-book_ids" style="stroke: #27262B; stroke-width: 1.0; stroke-dasharray: 7.0,7.0;"/><polygon fill="#27262B" points="605.5,99.9206,601.5,108.9206,605.5,104.9206,609.5,108.9206,605.5,99.9206" style="stroke: #27262B; stroke-width: 1.0;"/><!--MD5=[af58cdb2e044dbd1a577d5d5b36a8286]
- link raw_book to book_ids--><path d="M631.5,106.9206 C631.5,106.9206 631.5,152.6266 631.5,152.6266 " fill="none" id="raw_book-book_ids" style="stroke: #27262B; stroke-width: 1.0;"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="635.5" x2="627.5" y1="155.6266" y2="155.6266"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="635.5" x2="627.5" y1="152.6266" y2="152.6266"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="631.5" x2="631.5" y1="151.6266" y2="159.6266"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="627.5" x2="635.5" y1="103.9206" y2="103.9206"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="627.5" x2="635.5" y1="106.9206" y2="106.9206"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="631.5" x2="631.5" y1="107.9206" y2="99.9206"/><!--MD5=[f98f8fbbd7cf69e9e7819059eff61827]
- link work_ids to book_ids--><path d="M68.3333,271.3376 C68.3333,298.4566 68.3333,328.6406 68.3333,328.6406 C68.3333,328.6406 580.667,328.6406 580.667,328.6406 C580.667,328.6406 580.667,306.7876 580.667,306.7876 " fill="none" id="work_ids->book_ids" style="stroke: #27262B; stroke-width: 1.0;"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="580.667" x2="572.667" y1="306.7876" y2="298.7876"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="580.667" x2="588.667" y1="306.7876" y2="298.7876"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="580.667" x2="580.667" y1="306.7876" y2="298.7876"/><!--MD5=[e572979941754be82ae0c3b92f6415b3]
- reverse link book_ids to book_isbn--><path d="M607.667,303.8826 C607.667,303.8826 607.667,385.9536 607.667,385.9536 " fill="none" id="book_ids<-book_isbn" style="stroke: #27262B; stroke-width: 1.0; stroke-dasharray: 7.0,7.0;"/><polygon fill="#27262B" points="607.667,298.8826,603.667,307.8826,607.667,303.8826,611.667,307.8826,607.667,298.8826" style="stroke: #27262B; stroke-width: 1.0;"/><!--MD5=[05ecb93f908e9330ef32fcd8d0d4ed90]
- link book_ids to book_isbn--><path d="M629.333,306.8826 C629.333,306.8826 629.333,377.9536 629.333,377.9536 " fill="none" id="book_ids-book_isbn" style="stroke: #27262B; stroke-width: 1.0;"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="629.333" x2="635.333" y1="377.9536" y2="385.9536"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="629.333" x2="623.333" y1="377.9536" y2="385.9536"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="629.333" x2="629.333" y1="377.9536" y2="385.9536"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="633.333" x2="625.333" y1="375.9536" y2="375.9536"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="625.333" x2="633.333" y1="302.8826" y2="302.8826"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="625.333" x2="633.333" y1="305.8826" y2="305.8826"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="629.333" x2="629.333" y1="306.8826" y2="298.8826"/><!--MD5=[9b513c75b4696189fbd73eaf797696b0]
- link book_isbn to isbn_id--><path d="M651.096,435.6406 C662.622,435.6406 675.352,435.6406 685.977,435.6406 " fill="none" id="book_isbn-isbn_id" style="stroke: #27262B; stroke-width: 1.0;"/><!--MD5=[bc665d5738a1f7f3f9556842e33d5cee]
- reverse link raw_book_genres to book_genres--><path d="M845.5,104.9206 C845.5,104.9206 845.5,173.1166 845.5,173.1166 " fill="none" id="raw_book_genres<-book_genres" style="stroke: #27262B; stroke-width: 1.0; stroke-dasharray: 7.0,7.0;"/><polygon fill="#27262B" points="845.5,99.9206,841.5,108.9206,845.5,104.9206,849.5,108.9206,845.5,99.9206" style="stroke: #27262B; stroke-width: 1.0;"/><!--MD5=[ef090fca76f75d6d651f72abe0a6d889]
- link book_ids to book_genres--><path d="M667.083,274.6406 C667.083,274.6406 797.649,274.6406 797.649,274.6406 " fill="none" id="book_ids-book_genres" style="stroke: #27262B; stroke-width: 1.0;"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="797.649" x2="805.649" y1="274.6406" y2="268.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="797.649" x2="805.649" y1="274.6406" y2="280.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="797.649" x2="805.649" y1="274.6406" y2="274.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="795.649" x2="795.649" y1="270.6406" y2="278.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="663.083" x2="663.083" y1="278.6406" y2="270.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="666.083" x2="666.083" y1="278.6406" y2="270.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="667.083" x2="659.083" y1="274.6406" y2="274.6406"/><!--MD5=[c33a38ffa59f27d4d198ab0f0caaa632]
- reverse link raw_work to work_title--><path d="M92,104.9496 C92,104.9496 92,385.9126 92,385.9126 " fill="none" id="raw_work<-work_title" style="stroke: #27262B; stroke-width: 1.0; stroke-dasharray: 7.0,7.0;"/><polygon fill="#27262B" points="92,99.9496,88,108.9496,92,104.9496,96,108.9496,92,99.9496" style="stroke: #27262B; stroke-width: 1.0;"/><!--MD5=[55bd0e4d9d328607ee495e22b9fd9265]
- link work_ids to work_title--><path d="M59.6667,279.3246 C59.6667,279.3246 59.6667,378.1346 59.6667,378.1346 " fill="none" id="work_ids-work_title" style="stroke: #27262B; stroke-width: 1.0;"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="59.6667" x2="59.6667" y1="375.1346" y2="386.1346"/><ellipse cx="59.6667" cy="375.1346" fill="none" rx="4" ry="4" style="stroke: #27262B; stroke-width: 1.0;"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="63.6667" x2="55.6667" y1="382.1346" y2="382.1346"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="55.6667" x2="63.6667" y1="275.3246" y2="275.3246"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="55.6667" x2="63.6667" y1="278.3246" y2="278.3246"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="59.6667" x2="59.6667" y1="279.3246" y2="271.3246"/><!--MD5=[eaa7032aee4cb92d4a5d42a4d67a005d]
- reverse link raw_work to work_pub_date--><path d="M107,104.7686 C107,104.7686 107,173.6406 107,173.6406 C107,173.6406 149.057,173.6406 183.886,173.6406 " fill="none" id="raw_work<-work_pub_date" style="stroke: #27262B; stroke-width: 1.0; stroke-dasharray: 7.0,7.0;"/><polygon fill="#27262B" points="107,99.7686,103,108.7686,107,104.7686,111,108.7686,107,99.7686" style="stroke: #27262B; stroke-width: 1.0;"/><!--MD5=[9b819d001635477e00c3a10a4d70c0b6]
- link work_pub_date to work_ids--><path d="M175.99,229.6406 C175.99,229.6406 85.1861,229.6406 85.1861,229.6406 " fill="none" id="work_pub_date-work_ids" style="stroke: #27262B; stroke-width: 1.0;"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="81.1861" x2="81.1861" y1="233.6406" y2="225.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="84.1861" x2="84.1861" y1="233.6406" y2="225.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="85.1861" x2="77.1861" y1="229.6406" y2="229.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="172.99" x2="183.99" y1="229.6406" y2="229.6406"/><ellipse cx="172.99" cy="229.6406" fill="none" rx="4" ry="4" style="stroke: #27262B; stroke-width: 1.0;"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="179.99" x2="179.99" y1="225.6406" y2="233.6406"/><!--MD5=[fbbad742fad3cf0f042cd5319e9de83d]
- reverse link raw_book to book_pub_date--><path d="M574.227,65.6406 C574.227,65.6406 496.5,65.6406 496.5,65.6406 C496.5,65.6406 496.5,114.8886 496.5,159.3276 " fill="none" id="raw_book<-book_pub_date" style="stroke: #27262B; stroke-width: 1.0; stroke-dasharray: 7.0,7.0;"/><polygon fill="#27262B" points="579.227,65.6406,570.227,61.6406,574.227,65.6406,570.227,69.6406,579.227,65.6406" style="stroke: #27262B; stroke-width: 1.0;"/><!--MD5=[db69aa54006da0804c18f170db66fd3f]
- link book_pub_date to book_ids--><path d="M550.623,229.6406 C550.623,229.6406 569.913,229.6406 569.913,229.6406 " fill="none" id="book_pub_date-book_ids" style="stroke: #27262B; stroke-width: 1.0;"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="573.913" x2="573.913" y1="225.6406" y2="233.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="570.913" x2="570.913" y1="225.6406" y2="233.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="569.913" x2="577.913" y1="229.6406" y2="229.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="553.623" x2="542.623" y1="229.6406" y2="229.6406"/><ellipse cx="553.623" cy="229.6406" fill="none" rx="4" ry="4" style="stroke: #27262B; stroke-width: 1.0;"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="546.623" x2="546.623" y1="233.6406" y2="225.6406"/><!--MD5=[a818bf71f069cb72caddf871946a7a54]
- reverse link raw_interaction to user_ids--><path d="M315.875,268.9266 C315.875,268.9266 315.875,594.9156 315.875,594.9156 " fill="none" id="raw_interaction<-user_ids" style="stroke: #27262B; stroke-width: 1.0; stroke-dasharray: 7.0,7.0;"/><polygon fill="#27262B" points="315.875,263.9266,311.875,272.9266,315.875,268.9266,319.875,272.9266,315.875,263.9266" style="stroke: #27262B; stroke-width: 1.0;"/><!--MD5=[c0d60d999d769eb6726465ea8ab70942]
- reverse link raw_interaction to interaction--><path d="M385.333,269.0856 C385.333,269.0856 385.333,358.5006 385.333,358.5006 " fill="none" id="raw_interaction<-interaction" style="stroke: #27262B; stroke-width: 1.0; stroke-dasharray: 7.0,7.0;"/><polygon fill="#27262B" points="385.333,264.0856,381.333,273.0856,385.333,269.0856,389.333,273.0856,385.333,264.0856" style="stroke: #27262B; stroke-width: 1.0;"/><!--MD5=[488e37f340487b030b7ef66357cc1bbd]
- link raw_interaction to interaction--><path d="M400.167,271.0856 C400.167,271.0856 400.167,351.5006 400.167,351.5006 " fill="none" id="raw_interaction-interaction" style="stroke: #27262B; stroke-width: 1.0;"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="404.167" x2="396.167" y1="354.5006" y2="354.5006"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="404.167" x2="396.167" y1="351.5006" y2="351.5006"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="400.167" x2="400.167" y1="350.5006" y2="358.5006"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="396.167" x2="404.167" y1="268.0856" y2="268.0856"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="396.167" x2="404.167" y1="271.0856" y2="271.0856"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="400.167" x2="400.167" y1="272.0856" y2="264.0856"/><!--MD5=[fdcd0acbe5b923acd8a4f848b6914949]
- link book_ids to interaction--><path d="M583.333,298.7886 C583.333,335.3506 583.333,372.6406 583.333,372.6406 C583.333,372.6406 474.62,372.6406 474.62,372.6406 " fill="none" id="book_ids->interaction" style="stroke: #27262B; stroke-width: 1.0;"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="474.62" x2="466.62" y1="372.6406" y2="380.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="474.62" x2="466.62" y1="372.6406" y2="364.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="474.62" x2="466.62" y1="372.6406" y2="372.6406"/><!--MD5=[7122d2ee4ea425b9977fe35aeee2a233]
- reverse link interaction to user_ids--><path d="M362.408,498.6406 C362.408,498.6406 321.75,498.6406 321.75,498.6406 C321.75,498.6406 321.75,554.1036 321.75,594.8336 " fill="none" id="interaction<-user_ids" style="stroke: #27262B; stroke-width: 1.0;"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="362.408" x2="370.408" y1="498.6406" y2="490.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="362.408" x2="370.408" y1="498.6406" y2="506.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="362.408" x2="370.408" y1="498.6406" y2="498.6406"/><!--MD5=[249e310d077320fc7dfdc4dd4536c770]
- reverse link interaction to rating--><path d="M471.649,498.6406 C471.649,498.6406 529.75,498.6406 529.75,498.6406 C529.75,498.6406 529.75,535.7426 529.75,571.5406 " fill="none" id="interaction<-rating" style="stroke: #27262B; stroke-width: 1.0; stroke-dasharray: 7.0,7.0;"/><polygon fill="#27262B" points="466.649,498.6406,475.649,502.6406,471.649,498.6406,475.649,494.6406,466.649,498.6406" style="stroke: #27262B; stroke-width: 1.0;"/><!--MD5=[40b8c93613b569c267b836f18b561cd3]
- reverse link user_ids to rating--><path d="M327.625,587.0996 C327.625,587.0996 327.625,575.6406 327.625,575.6406 C327.625,575.6406 444.17,575.6406 516.783,575.6406 " fill="none" id="user_ids<-rating" style="stroke: #27262B; stroke-width: 1.0;"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="327.625" x2="335.625" y1="587.0996" y2="595.0996"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="327.625" x2="319.625" y1="587.0996" y2="595.0996"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="327.625" x2="327.625" y1="587.0996" y2="595.0996"/><!--MD5=[15944eb74aedc4f6a77281df2e0a8196]
- reverse link interaction to add_action--><path d="M418.5,516.7966 C418.5,516.7966 418.5,578.4686 418.5,578.4686 " fill="none" id="interaction<-add_action" style="stroke: #27262B; stroke-width: 1.0; stroke-dasharray: 7.0,7.0;"/><polygon fill="#27262B" points="418.5,511.7966,414.5,520.7966,418.5,516.7966,422.5,520.7966,418.5,511.7966" style="stroke: #27262B; stroke-width: 1.0;"/><!--MD5=[4afc68420f0e1e14c5c60dcde37b6e52]
- reverse link user_ids to add_action--><path d="M341.597,637.6406 C341.597,637.6406 368.551,637.6406 368.551,637.6406 " fill="none" id="user_ids<-add_action" style="stroke: #27262B; stroke-width: 1.0;"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="341.597" x2="333.597" y1="637.6406" y2="645.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="341.597" x2="333.597" y1="637.6406" y2="629.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="341.597" x2="333.597" y1="637.6406" y2="637.6406"/><!--MD5=[8d4b8b6fafa1a0e435f23da9cb40ce69]
- link book_ids to book_cluster--><path d="M666.013,229.6406 C666.013,229.6406 686.646,229.6406 686.646,229.6406 " fill="none" id="book_ids-book_cluster" style="stroke: #27262B; stroke-width: 1.0;"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="689.646" x2="689.646" y1="225.6406" y2="233.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="686.646" x2="686.646" y1="225.6406" y2="233.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="685.646" x2="693.646" y1="229.6406" y2="229.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="663.013" x2="663.013" y1="233.6406" y2="225.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="666.013" x2="666.013" y1="233.6406" y2="225.6406"/><line style="stroke: #27262B; stroke-width: 1.0;" x1="667.013" x2="659.013" y1="229.6406" y2="229.6406"/><!--MD5=[37b5b1940a19eca4221b1cf099ea115d]
- @startuml
- title GoodReads Data
- skinparam linetype ortho
- skinparam class {
- BackgroundColor white
- BackgroundColor<<derived>> #f5f6fa
- ArrowColor #27262b
- BorderColor #7253ed
- }
- hide empty members
- hide circle
- entity isbn_id {
- isbn_id
- - -
- isbn
- }
- entity isbn_cluster {
- cluster
- - -
- isbn_id
- }
- isbn_id -|{ isbn_cluster
- entity raw_book {
- gr_book_rid
- - -
- gr_book_data
- }
- entity raw_work {
- gr_work_rid
- - -
- gr_work_data
- }
- entity raw_book_genres {
- gr_book_genres_rid
- - -
- gr_book_genres_data
- }
- entity raw_interaction {
- gr_interaction_rid
- - -
- gr_interaction_data
- }
- entity work_ids <<derived>> {
- gr_work_rid
- - -
- gr_work_id
- }
- raw_work <.. work_ids
- raw_work ||- -|| work_ids
- entity book_ids <<derived>> {
- gr_book_rid
- - -
- gr_work_id
- # gr_book_id
- gr_asin
- gr_isbn
- gr_isbn13
- }
- raw_book <.. book_ids
- raw_book ||- -|| book_ids
- work_ids -{ book_ids
- entity book_isbn <<derived>> {
- - -
- gr_book_id
- isbn_id
- book_code
- }
- book_ids <.. book_isbn
- book_ids ||- -|{ book_isbn
- book_isbn - isbn_id
- entity book_genres <<derived>> {
- - -
- gr_book_rid
- gr_book_id
- genre
- score
- }
- raw_book_genres <.. book_genres
- book_ids ||-|{ book_genres
- entity work_title <<derived>> {
- gr_work_rid
- - -
- gr_work_id
- work_itle
- }
- raw_work <.. work_title
- work_ids ||- -o| work_title
- entity work_pub_date <<derived>> {
- gr_work_rid
- - -
- gr_work_id
- pub_year
- pub_month
- pub_day
- pub_date
- }
- raw_work <.. work_pub_date
- work_pub_date |o-|| work_ids
- entity book_pub_date <<derived>> {
- gr_book_rid
- - -
- gr_book_id
- pub_year
- pub_month
- pub_day
- pub_date
- }
- raw_book <.. book_pub_date
- book_pub_date |o-|| book_ids
- entity user_ids <<derived>> {
- gr_user_rid
- - -
- gr_user_id
- }
- raw_interaction <.. user_ids
- entity interaction <<derived>> {
- gr_interaction_rid
- - -
- gr_book_id
- gr_user_rid
- rating
- is_read
- date_add
- date_updated
- }
- raw_interaction <.. interaction
- raw_interaction ||- -|| interaction
- book_ids - -{ interaction
- interaction }- - user_ids
- entity rating <<derived>> {
- user_id : gr_user_rid
- book_id : cluster
- rating
- last_rating
- timestamp
- nratings
- }
- interaction <.. rating
- user_ids }- rating
- entity add_action <<derived>> {
- user_id : gr_user_rid
- book_id : cluster
- first_time
- last_time
- nactions
- }
- interaction <.. add_action
- user_ids }- add_action
- entity book_cluster {
- gr_book_id
- - -
- cluster
- }
- book_ids ||-|| book_cluster
- @enduml
- PlantUML version 1.2020.05(Thu Mar 19 15:17:32 MDT 2020)
- (GPL source distribution)
- Java Runtime: OpenJDK Runtime Environment
- JVM: OpenJDK 64-Bit Server VM
- Java Version: 14+36-1461
- Operating System: Windows 10
- Default Encoding: Cp1252
- Language: en
- Country: US
- --></g></svg>
|