Dean
/
Bookdata-tools
mirror of https://github.com/BoiseState/bookdata-tools


  
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-&gt;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&lt;-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&lt;-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-&gt;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&lt;-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&lt;-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&lt;-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&lt;-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&lt;-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&lt;-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&lt;-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-&gt;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&lt;-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&lt;-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&lt;-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&lt;-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&lt;-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>