Register
Login
Resources
Docs Blog Datasets Glossary Case Studies Tutorials & Webinars
Product
Data Engine LLMs Platform Enterprise
Pricing Explore
Connect to our Discord channel

goodreads.puml 2.5 KB

You have to be logged in to leave a comment. Sign In
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
  1. @startuml
  2. title GoodReads Data
  3. skinparam linetype ortho
  4. !include theme.iuml
  5. entity isbn_id {
  6. isbn_id
  7. --
  8. isbn
  9. }
  10. entity isbn_cluster {
  11. cluster
  12. --
  13. isbn_id
  14. }
  15. isbn_id -|{ isbn_cluster
  16. entity raw_book {
  17. gr_book_rid
  18. --
  19. gr_book_data
  20. }
  21. entity raw_work {
  22. gr_work_rid
  23. --
  24. gr_work_data
  25. }
  26. /'
  27. entity raw_author {
  28. gr_author_rid
  29. --
  30. gr_author_data
  31. }
  32. entity raw_series {
  33. gr_series_rid
  34. --
  35. gr_series_data
  36. }
  37. '/
  38. entity raw_book_genres {
  39. gr_book_genres_rid
  40. --
  41. gr_book_genres_data
  42. }
  43. entity raw_interaction {
  44. gr_interaction_rid
  45. --
  46. gr_interaction_data
  47. }
  48. entity work_ids <<derived>> {
  49. gr_work_rid
  50. --
  51. gr_work_id
  52. }
  53. raw_work <.. work_ids
  54. raw_work ||--|| work_ids
  55. entity book_ids <<derived>> {
  56. gr_book_rid
  57. --
  58. gr_work_id
  59. # gr_book_id
  60. gr_asin
  61. gr_isbn
  62. gr_isbn13
  63. }
  64. raw_book <.. book_ids
  65. raw_book ||--|| book_ids
  66. work_ids -{ book_ids
  67. entity book_isbn <<derived>> {
  68. --
  69. gr_book_id
  70. isbn_id
  71. book_code
  72. }
  73. book_ids <.. book_isbn
  74. book_ids ||--|{ book_isbn
  75. book_isbn - isbn_id
  76. entity book_genres <<derived>> {
  77. --
  78. gr_book_rid
  79. gr_book_id
  80. genre
  81. score
  82. }
  83. raw_book_genres <.. book_genres
  84. book_ids ||-|{ book_genres
  85. entity work_title <<derived>> {
  86. gr_work_rid
  87. --
  88. gr_work_id
  89. work_itle
  90. }
  91. raw_work <.. work_title
  92. work_ids ||--o| work_title
  93. 'work_title |o-|| work_ids
  94. entity work_pub_date <<derived>> {
  95. gr_work_rid
  96. --
  97. gr_work_id
  98. pub_year
  99. pub_month
  100. pub_day
  101. pub_date
  102. }
  103. raw_work <.. work_pub_date
  104. work_pub_date |o-|| work_ids
  105. entity book_pub_date <<derived>> {
  106. gr_book_rid
  107. --
  108. gr_book_id
  109. pub_year
  110. pub_month
  111. pub_day
  112. pub_date
  113. }
  114. raw_book <.. book_pub_date
  115. book_pub_date |o-|| book_ids
  116. entity user_ids <<derived>> {
  117. gr_user_rid
  118. --
  119. gr_user_id
  120. }
  121. raw_interaction <.. user_ids
  122. entity interaction <<derived>> {
  123. gr_interaction_rid
  124. --
  125. gr_book_id
  126. gr_user_rid
  127. rating
  128. is_read
  129. date_add
  130. date_updated
  131. }
  132. raw_interaction <.. interaction
  133. raw_interaction ||--|| interaction
  134. book_ids --{ interaction
  135. interaction }-- user_ids
  136. entity rating <<derived>> {
  137. user_id : gr_user_rid
  138. book_id : cluster
  139. rating
  140. last_rating
  141. timestamp
  142. nratings
  143. }
  144. interaction <.. rating
  145. user_ids }- rating
  146. entity add_action <<derived>> {
  147. user_id : gr_user_rid
  148. book_id : cluster
  149. first_time
  150. last_time
  151. nactions
  152. }
  153. interaction <.. add_action
  154. user_ids }- add_action
  155. entity book_cluster {
  156. gr_book_id
  157. --
  158. cluster
  159. }
  160. book_ids ||-|| book_cluster
  161. @enduml
Tip!

Press p or to see the previous file or, n or to see the next file

Comments

Loading...