質問編集履歴

4

INSERT文(10行のみ抜粋)を追加しました。

2019/11/16 02:12

投稿

退会済みユーザー
test CHANGED
@@ -1 +1 @@
1
- PostgreSQL "似ている"ユーザーを探したい
1
+ PostgreSQL Yelpで"似ている"ユーザーを探したい
test CHANGED
@@ -14,7 +14,9 @@
14
14
 
15
15
 
16
16
 
17
- テーブルは全部で4つで
17
+ テーブルは全部で4つです。
18
+
19
+
18
20
 
19
21
  ```
20
22
 
@@ -38,11 +40,9 @@
38
40
 
39
41
  ```
40
42
 
43
+
44
+
41
- それぞれのテーブルの中身は以下の通りです。
45
+ それぞれのテーブルのCREATE文は以下の通りです。
42
-
43
-
44
-
45
- - businessテーブル
46
46
 
47
47
 
48
48
 
@@ -84,166 +84,234 @@
84
84
 
85
85
  CREATE UNIQUE INDEX business_pkey ON business(business_id text_ops);
86
86
 
87
+
88
+
89
+
90
+
91
+
92
+
93
+ -- Table Definition ----------------------------------------------
94
+
95
+
96
+
97
+ CREATE TABLE review (
98
+
99
+ review_id character varying(30) PRIMARY KEY,
100
+
101
+ business_id character varying(30),
102
+
103
+ user_id character varying(30),
104
+
105
+ stars smallint,
106
+
107
+ review_date date,
108
+
109
+ review_text text,
110
+
111
+ useful_votes integer,
112
+
113
+ funny_votes integer,
114
+
115
+ cool_votes integer
116
+
117
+ );
118
+
119
+
120
+
121
+ -- Indices -------------------------------------------------------
122
+
123
+
124
+
125
+ CREATE UNIQUE INDEX review_pkey ON review(review_id text_ops);
126
+
127
+ CREATE INDEX review_bus_id ON review(business_id text_ops);
128
+
129
+ CREATE INDEX review_user_id ON review(user_id text_ops);
130
+
131
+
132
+
133
+
134
+
135
+
136
+
137
+ -- Table Definition ----------------------------------------------
138
+
139
+
140
+
141
+ CREATE TABLE tip (
142
+
143
+ tip_text text,
144
+
145
+ tip_date date,
146
+
147
+ likes integer,
148
+
149
+ business_id character varying(30),
150
+
151
+ user_id character varying(30)
152
+
153
+ );
154
+
155
+
156
+
157
+ -- Indices -------------------------------------------------------
158
+
159
+
160
+
161
+ CREATE INDEX tip_bus_id ON tip(business_id text_ops);
162
+
163
+ CREATE INDEX tip_user_id ON tip(user_id text_ops);
164
+
165
+
166
+
167
+
168
+
169
+
170
+
171
+ -- Table Definition ----------------------------------------------
172
+
173
+
174
+
175
+ CREATE TABLE users (
176
+
177
+ user_id character varying(30) PRIMARY KEY,
178
+
179
+ name character varying(150),
180
+
181
+ yelping_since date,
182
+
183
+ useful_votes integer,
184
+
185
+ funny_votes integer,
186
+
187
+ cool_votes integer
188
+
189
+ );
190
+
191
+
192
+
193
+ -- Indices -------------------------------------------------------
194
+
195
+
196
+
197
+ CREATE UNIQUE INDEX users_pkey ON users(user_id text_ops);
198
+
87
199
  ```
88
200
 
89
201
 
90
202
 
91
- ![business_table](8edf7270c95fd5e8ad96f53bab61ae71.png)
203
+ INSERT文の内、10行を抜粋したものは以下になります。
92
-
93
-
94
-
95
-
96
-
97
-
98
-
99
- - reviewテーブル
100
204
 
101
205
 
102
206
 
103
207
  ```PostgreSQL
104
208
 
105
- -- Table Definition ----------------------------------------------
106
-
107
-
108
-
109
- CREATE TABLE review (
110
-
111
- review_id character varying(30) PRIMARY KEY,
112
-
113
- business_id character varying(30),
114
-
115
- user_id character varying(30),
116
-
117
- stars smallint,
118
-
119
- review_date date,
120
-
121
- review_text text,
122
-
123
- useful_votes integer,
124
-
125
- funny_votes integer,
126
-
127
- cool_votes integer
128
-
129
- );
130
-
131
-
132
-
133
- -- Indices -------------------------------------------------------
134
-
135
-
136
-
137
- CREATE UNIQUE INDEX review_pkey ON review(review_id text_ops);
138
-
139
- CREATE INDEX review_bus_id ON review(business_id text_ops);
140
-
141
- CREATE INDEX review_user_id ON review(user_id text_ops);
209
+ insert into business
210
+
211
+ values
212
+
213
+ ('-000aQFeK6tqVLndf7xORg', 'CoolCatAutoRepair', '', '6348N27thAve', 'Phoenix', 'AZ', '85017', '33.531105', '-112.11761', 'TRUE'),
214
+
215
+ ('0010xnFOCyJZeMAuTtiv5w', 'HennaShoppe', '', '7235E1stAve', 'Scottsdale', 'AZ', '85251', '33.49402', '-111.92512', 'TRUE'),
216
+
217
+ ('001jVKJHdhU2z_m9xTgOrg', 'AgaveChiropractic', '', '3040N44thSt,Ste3', 'Phoenix', 'AZ', '85018', '33.483635', '-111.98701', 'TRUE'),
218
+
219
+ ('002Gv4JE2bAfXkGJVM1IQw', 'AirgunsofArizona', '', '1970WElliotRd,Ste109', 'Gilbert', 'AZ', '85233', '33.35031', '-111.83239', 'TRUE'),
220
+
221
+ ('002ISUJGzG_5ejVrIqsPFA', 'SalonAtmosphere', 'Dormont', '3000WLibertyAve', 'Pittsburgh', 'PA', '15216', '40.393173', '-80.03695', 'TRUE'),
222
+
223
+ ('003b6f4PdppnakGqwo0fUQ', 'SolaSalon', 'Southwest', '7355SBuffalo,SteD', 'LasVegas', 'NV', '89113', '36.05418', '-115.262375', 'TRUE'),
224
+
225
+ ('003QzJjq0FYALjyFxKT2tA', 'HarbourBar', '', '1-3Sandside', 'Scarborough', 'NYK', 'YO111PE', '54.283997', '-0.39249977', 'TRUE'),
226
+
227
+ ('003wb6vvUFyNgDfD-2dPcw', 'AlterReality', '', '15601DetroitAve', 'Lakewood', 'OH', '44107', '41.48493', '-81.806206', 'TRUE'),
228
+
229
+ ('0044Q4cVBcHBgXPmhGgtcQ', 'TheKingsLanding', '', '5946MainStreet', 'Whitchurch-Stouffville', 'ON', 'L4A3A1', '43.969337', '-79.256386', 'TRUE'),
230
+
231
+ ('005XmZKuJZuNbl5tGXc5SA', 'TonyRomas', 'Downtown', '620ESaharaAve', 'LasVegas', 'NV', '89104', '36.14431', '-115.14569', 'FALSE');
232
+
233
+
234
+
235
+ insert into review
236
+
237
+ values
238
+
239
+ ('0005v4K5iZM3QAfImf_Ugw', 'hH74Tvfd-nzqT6jKDerMTw', 'S63nehkM27Zr77YxN2bA0Q', '1', '2016-08-11', 'ImsoupsetIwontevenreturnwithmyteenageboys.', '0', '0', '0'),
240
+
241
+ ('0006hhVjawuXu097INsiIw', '9CyNha8NE-7HEgjvUZFmnQ', 'TNLPYG78zJjjZPYTyeOZyA', '4', '2010-12-11', 'Youwillhaveagreattime!', '4', '0', '2'),
242
+
243
+ ('0008P7Cb7U-dpPchjamFWw', '-od707p4FHGul0gte29AoQ', 'XtJbDZODXi3mXHLoScGtwg', '5', '2015-09-11', 'ThepancakeistheyummiestIveeverhadandImdefinitelygoingback.', '2', '1', '1'),
244
+
245
+ ('0008uFuu1Sr5yqXeDN8RFw', 'Jb_QTIjDm5zbfrdk11R4fg', 'NaZVUOzqk5b-l0mlki-9Og', '5', '2016-09-10', 'Hadleftoverforthenextdayanditwasevengoodcold.', '2', '0', '1'),
246
+
247
+ ('0008zUEB-cuVAR4JZhXwlg', '5MPAZiYotUqgxkbXYY0c_Q', '1_qcKXfm8H8zecygxHjeWw', '2', '2014-02-20', 'Theyhadtherightidea!', '7', '2', '1'),
248
+
249
+ ('000AYfflyggMLAtTR6zdaA', 'taTF-fXetRbziIl80xPFjw', 'J-yULQA56PXaphJNA1RKGQ', '1', '2010-03-09', 'Einmalundniemehr...', '0', '0', '0'),
250
+
251
+ ('000BqmhDAkCYVa_MfJntpg', '-PfcLYFMW9ZXc1DEWSqw-g', 'gTlDDzDEHyDQ6iwjNhpI6A', '5', '2013-01-12', 'Andtheyofferedanaccommodationforourdisabledsonwithoutouraskingforit,whichwasverykind.Wellbebackagainsoon.', '1', '0', '0'),
252
+
253
+ ('000dJwYh7sr5xnsTFNlP5g', '7fzppFRWw-GyPVKqNlC5Eg', 'O7ZvoH_ONGNKbXvHDSZlwg', '1', '2017-10-09', 'Yapaquelesigonoregreso.,', '1', '0', '0'),
254
+
255
+ ('000DSSWY_UiSSdm2V4yJUQ', 'o9XzWtzTuV2X9fyYevXmkw', 'CESgogUugOYph4p12qvzFg', '4', '2016-07-01', 'Thewashroomwastinybutsqueakyclean.', '3', '1', '3'),
256
+
257
+ ('0-00GgzKPd9ik-X_6r4lBg', 'Oy_5I50HRZ1vXA5bnTPjHg', 'RxFxenmxZ_NUvSdkwPcY4Q', '5', '2013-11-21', 'Awesomeplace!', '3', '1', '1');
258
+
259
+
260
+
261
+ insert into tip
262
+
263
+ values
264
+
265
+ ('Greatbreakfastlargeportionsandfriendlywaitress.Ihighlyrecommendit', '2015-08-12', '0', 'jH19V2I9fIslnNhDzPmdkA', 'ZcLKXikTHYOnYt5VYRO5sg'),
266
+
267
+ ('Niceplace.Greatstaff.Afixtureinthetownshipforever', '2014-06-20', '0', 'dAa0hB2yrnHzVmsCkN4YvQ', 'oaYhjqBbh18ZhU0bpyzSuw'),
268
+
269
+ ('Happyhour5-7Monday-Friday', '2016-10-12', '0', 'dAa0hB2yrnHzVmsCkN4YvQ', 'ulQ8Nyj7jCUR8M83SUMoRQ'),
270
+
271
+ ('Parkingisapremium,keepcircling,youwilleventuallyfindagreatspot', '2017-01-28', '0', 'ESzO3Av0b1_TzKOiqzbQYQ', 'ulQ8Nyj7jCUR8M83SUMoRQ'),
272
+
273
+ ('Homemadepastaisthebestinthearea', '2017-02-25', '0', 'k7WRPbDd7rztjHcGGkEjlw', 'ulQ8Nyj7jCUR8M83SUMoRQ'),
274
+
275
+ ('Excellentservice,staffisdressedprofessionally,polite,mannered,andwelltrained', '2017-04-08', '0', 'k7WRPbDd7rztjHcGGkEjlw', 'ulQ8Nyj7jCUR8M83SUMoRQ'),
276
+
277
+ ('ComeearlyonSundaystoavoidtherush', '2016-07-03', '0', 'SqW3igh1_Png336VIb5DUA', 'ulQ8Nyj7jCUR8M83SUMoRQ'),
278
+
279
+ ('Lovetheirsoup!', '2016-01-07', '0', 'KNpcPGqDORDdvtekXd348w', 'ulQ8Nyj7jCUR8M83SUMoRQ'),
280
+
281
+ ('Soupsarefantastic!', '2016-05-22', '0', 'KNpcPGqDORDdvtekXd348w', 'ulQ8Nyj7jCUR8M83SUMoRQ'),
282
+
283
+ ('Thursdaynightis$5burgernight', '2016-06-09', '0', 'KNpcPGqDORDdvtekXd348w', 'ulQ8Nyj7jCUR8M83SUMoRQ');
284
+
285
+
286
+
287
+ insert into users
288
+
289
+ values
290
+
291
+ ('000AJVuwnwpGL8hHQUVLYg', 'Randy', '2013-04-21', '1', '0', '0'),
292
+
293
+ ('000JFML-9-W2-TGBTS0oaA', 'Deshone', '2014-07-01', '0', '0', '0'),
294
+
295
+ ('000JgS1HGrjvIxCn-BrpSw', 'Teresa', '2014-09-28', '0', '0', '0'),
296
+
297
+ ('000M3Xl73OIPztL97c3FSg', 'Todd', '2012-02-10', '0', '1', '0'),
298
+
299
+ ('000tGHVWdNNkjLk_jWJX5w', 'Megan', '2014-09-01', '0', '0', '0'),
300
+
301
+ ('000TZpy1bjaDzwMIaZxmlw', 'Jen', '2015-02-01', '0', '0', '0'),
302
+
303
+ ('-0012EkX22eeb2AiW_RkcQ', 'Jake', '2013-11-17', '0', '0', '0'),
304
+
305
+ ('0012OgDoCUa0o2icjVgwmg', 'Andrew', '2010-04-25', '30', '15', '27'),
306
+
307
+ ('0017YLRTmdhG5m8qggAlPw', 'Edward', '2008-03-14', '1', '0', '0'),
308
+
309
+ ('0019WdoIywMw3imBqtSZgg', 'Caitlin', '2015-07-27', '0', '0', '0');
142
310
 
143
311
  ```
144
312
 
145
313
 
146
314
 
147
- ![review_table](64026089ae4ce2f04c693a51de65959c.png)
148
-
149
-
150
-
151
-
152
-
153
-
154
-
155
- - tipテーブル
156
-
157
-
158
-
159
- ```PosrgreSQL
160
-
161
- -- Table Definition ----------------------------------------------
162
-
163
-
164
-
165
- CREATE TABLE tip (
166
-
167
- tip_text text,
168
-
169
- tip_date date,
170
-
171
- likes integer,
172
-
173
- business_id character varying(30),
174
-
175
- user_id character varying(30)
176
-
177
- );
178
-
179
-
180
-
181
- -- Indices -------------------------------------------------------
182
-
183
-
184
-
185
- CREATE INDEX tip_bus_id ON tip(business_id text_ops);
186
-
187
- CREATE INDEX tip_user_id ON tip(user_id text_ops);
188
-
189
- ```
190
-
191
-
192
-
193
- ![tip_table](a96b019c6eac11e82bec924a3a840aa4.png)
194
-
195
-
196
-
197
-
198
-
199
-
200
-
201
- - usersテーブル
202
-
203
-
204
-
205
- ```PostgreSQL
206
-
207
- -- Table Definition ----------------------------------------------
208
-
209
-
210
-
211
- CREATE TABLE users (
212
-
213
- user_id character varying(30) PRIMARY KEY,
214
-
215
- name character varying(150),
216
-
217
- yelping_since date,
218
-
219
- useful_votes integer,
220
-
221
- funny_votes integer,
222
-
223
- cool_votes integer
224
-
225
- );
226
-
227
-
228
-
229
- -- Indices -------------------------------------------------------
230
-
231
-
232
-
233
- CREATE UNIQUE INDEX users_pkey ON users(user_id text_ops);
234
-
235
- ```
236
-
237
-
238
-
239
- ![users_table](d0c9045f905b9089157f9016b0c827e5.png)
240
-
241
-
242
-
243
-
244
-
245
-
246
-
247
315
  #### 条件
248
316
 
249
317
 

3

条件の説明に例を追加しました。

2019/11/16 02:12

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -6,7 +6,9 @@
6
6
 
7
7
 
8
8
 
9
+ Yelpとは、アメリカ版の食べログ+ホットペッパービューティーみたいなアプリです。いろんな分野の口コミレビューアプリになります。
10
+
9
- Yelpのデータセットを多少加工したデータセットを使っております。(以下のURLは加工前のデータセットです。)
11
+ 今回はそのYelpのデータセットを多少加工したデータセットを使っております。(以下のURLは加工前のデータセットです。)
10
12
 
11
13
  [Yelp Dataset](https://www.yelp.com/dataset/documentation/main)
12
14
 
@@ -252,6 +254,24 @@
252
254
 
253
255
 
254
256
 
257
+ 例えば、Aさん(user_id=a)とBさん(user_id=b)がいて、reviewテーブルに、
258
+
259
+ (user_id=a, business_id=1234)
260
+
261
+ (user_id=b, business_id=1234)
262
+
263
+ というタプルがあれば、一つ"似ている"ということになります。さらに、tipテーブルに、
264
+
265
+ (user_id=a, business_id=XXX)
266
+
267
+ (user_id=b, business_id=XXX)
268
+
269
+ もあるとすると、2つ"似ている"ということになります。
270
+
271
+ この"似ている"数が、最も多いユーザーのペアを一つ探したいです。要するに、Yelpで同じ場所を訪れる傾向のあるユーザーを見つけたいです。
272
+
273
+
274
+
255
275
  ### 試したこと
256
276
 
257
277
 

2

テーブルの定義の確認をCREATE文にし、中身をスクショで載せました。

2019/11/16 00:41

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -6,13 +6,13 @@
6
6
 
7
7
 
8
8
 
9
- Yelpのデータセットを多少修正したデータセットを使っております。(以下のURLは加工前のデータセットです。)
9
+ Yelpのデータセットを多少加工したデータセットを使っております。(以下のURLは加工前のデータセットです。)
10
10
 
11
11
  [Yelp Dataset](https://www.yelp.com/dataset/documentation/main)
12
12
 
13
13
 
14
14
 
15
- テーブルは全部で4つで、(今回はbusinessテーブルは使わないかもしれませんが、、)
15
+ テーブルは全部で4つで、
16
16
 
17
17
  ```
18
18
 
@@ -38,141 +38,207 @@
38
38
 
39
39
  それぞれのテーブルの中身は以下の通りです。
40
40
 
41
- ```
42
-
43
- yelp=> \d business
44
-
45
- Table "public.business"
46
-
47
- Column | Type | Collation | Nullable | Default
48
-
49
- --------------+------------------------+-----------+----------+---------
50
-
51
- business_id | character varying(30) | | not null |
52
-
53
- name | character varying(150) | | not null |
54
-
55
- neighborhood | character varying(100) | | |
56
-
57
- address | character varying(200) | | |
58
-
59
- city | character varying(100) | | |
60
-
61
- state | character(3) | | |
62
-
63
- postal_code | character(10) | | |
64
-
65
- latitude | real | | |
66
-
67
- longitude | real | | |
68
-
69
- is_open | boolean | | |
70
-
71
- Indexes:
72
-
73
- "business_pkey" PRIMARY KEY, btree (business_id)
74
-
75
- ```
76
-
77
-
78
-
79
- ```
80
-
81
- yelp=> \d review
82
-
83
- Table "public.review"
84
-
85
- Column | Type | Collation | Nullable | Default
86
-
87
- --------------+-----------------------+-----------+----------+---------
88
-
89
- review_id | character varying(30) | | not null |
90
-
91
- business_id | character varying(30) | | |
92
-
93
- user_id | character varying(30) | | |
94
-
95
- stars | smallint | | |
96
-
97
- review_date | date | | |
98
-
99
- review_text | text | | |
100
-
101
- useful_votes | integer | | |
102
-
103
- funny_votes | integer | | |
104
-
105
- cool_votes | integer | | |
106
-
107
- Indexes:
108
-
109
- "review_pkey" PRIMARY KEY, btree (review_id)
110
-
111
- "review_bus_id" btree (business_id)
112
-
113
- "review_user_id" btree (user_id)
114
-
115
- ```
116
-
117
-
118
-
119
- ```
120
-
121
- yelp=> \d tip
122
-
123
- Table "public.tip"
124
-
125
- Column | Type | Collation | Nullable | Default
126
-
127
- -------------+-----------------------+-----------+----------+---------
128
-
129
- tip_text | text | | |
130
-
131
- tip_date | date | | |
132
-
133
- likes | integer | | |
134
-
135
- business_id | character varying(30) | | |
136
-
137
- user_id | character varying(30) | | |
138
-
139
- Indexes:
140
-
141
- "tip_bus_id" btree (business_id)
142
-
143
- "tip_user_id" btree (user_id)
144
-
145
- ```
146
-
147
-
148
-
149
- ```
150
-
151
- yelp=> \d users
152
-
153
- Table "public.users"
154
-
155
- Column | Type | Collation | Nullable | Default
156
-
157
- ---------------+------------------------+-----------+----------+---------
158
-
159
- user_id | character varying(30) | | not null |
160
-
161
- name | character varying(150) | | |
162
-
163
- yelping_since | date | | |
164
-
165
- useful_votes | integer | | |
166
-
167
- funny_votes | integer | | |
168
-
169
- cool_votes | integer | | |
170
-
171
- Indexes:
172
-
173
- "users_pkey" PRIMARY KEY, btree (user_id)
174
-
175
- ```
41
+
42
+
43
+ - businessテーブル
44
+
45
+
46
+
47
+ ```PostgreSQL
48
+
49
+ -- Table Definition ----------------------------------------------
50
+
51
+
52
+
53
+ CREATE TABLE business (
54
+
55
+ business_id character varying(30) PRIMARY KEY,
56
+
57
+ name character varying(150) NOT NULL,
58
+
59
+ neighborhood character varying(100),
60
+
61
+ address character varying(200),
62
+
63
+ city character varying(100),
64
+
65
+ state character(3),
66
+
67
+ postal_code character(10),
68
+
69
+ latitude real,
70
+
71
+ longitude real,
72
+
73
+ is_open boolean
74
+
75
+ );
76
+
77
+
78
+
79
+ -- Indices -------------------------------------------------------
80
+
81
+
82
+
83
+ CREATE UNIQUE INDEX business_pkey ON business(business_id text_ops);
84
+
85
+ ```
86
+
87
+
88
+
89
+ ![business_table](8edf7270c95fd5e8ad96f53bab61ae71.png)
90
+
91
+
92
+
93
+
94
+
95
+
96
+
97
+ - reviewテーブル
98
+
99
+
100
+
101
+ ```PostgreSQL
102
+
103
+ -- Table Definition ----------------------------------------------
104
+
105
+
106
+
107
+ CREATE TABLE review (
108
+
109
+ review_id character varying(30) PRIMARY KEY,
110
+
111
+ business_id character varying(30),
112
+
113
+ user_id character varying(30),
114
+
115
+ stars smallint,
116
+
117
+ review_date date,
118
+
119
+ review_text text,
120
+
121
+ useful_votes integer,
122
+
123
+ funny_votes integer,
124
+
125
+ cool_votes integer
126
+
127
+ );
128
+
129
+
130
+
131
+ -- Indices -------------------------------------------------------
132
+
133
+
134
+
135
+ CREATE UNIQUE INDEX review_pkey ON review(review_id text_ops);
136
+
137
+ CREATE INDEX review_bus_id ON review(business_id text_ops);
138
+
139
+ CREATE INDEX review_user_id ON review(user_id text_ops);
140
+
141
+ ```
142
+
143
+
144
+
145
+ ![review_table](64026089ae4ce2f04c693a51de65959c.png)
146
+
147
+
148
+
149
+
150
+
151
+
152
+
153
+ - tipテーブル
154
+
155
+
156
+
157
+ ```PosrgreSQL
158
+
159
+ -- Table Definition ----------------------------------------------
160
+
161
+
162
+
163
+ CREATE TABLE tip (
164
+
165
+ tip_text text,
166
+
167
+ tip_date date,
168
+
169
+ likes integer,
170
+
171
+ business_id character varying(30),
172
+
173
+ user_id character varying(30)
174
+
175
+ );
176
+
177
+
178
+
179
+ -- Indices -------------------------------------------------------
180
+
181
+
182
+
183
+ CREATE INDEX tip_bus_id ON tip(business_id text_ops);
184
+
185
+ CREATE INDEX tip_user_id ON tip(user_id text_ops);
186
+
187
+ ```
188
+
189
+
190
+
191
+ ![tip_table](a96b019c6eac11e82bec924a3a840aa4.png)
192
+
193
+
194
+
195
+
196
+
197
+
198
+
199
+ - usersテーブル
200
+
201
+
202
+
203
+ ```PostgreSQL
204
+
205
+ -- Table Definition ----------------------------------------------
206
+
207
+
208
+
209
+ CREATE TABLE users (
210
+
211
+ user_id character varying(30) PRIMARY KEY,
212
+
213
+ name character varying(150),
214
+
215
+ yelping_since date,
216
+
217
+ useful_votes integer,
218
+
219
+ funny_votes integer,
220
+
221
+ cool_votes integer
222
+
223
+ );
224
+
225
+
226
+
227
+ -- Indices -------------------------------------------------------
228
+
229
+
230
+
231
+ CREATE UNIQUE INDEX users_pkey ON users(user_id text_ops);
232
+
233
+ ```
234
+
235
+
236
+
237
+ ![users_table](d0c9045f905b9089157f9016b0c827e5.png)
238
+
239
+
240
+
241
+
176
242
 
177
243
 
178
244
 

1

リンクを修正しました。

2019/11/16 00:24

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -8,7 +8,7 @@
8
8
 
9
9
  Yelpのデータセットを多少修正したデータセットを使っております。(以下のURLは加工前のデータセットです。)
10
10
 
11
- https://www.yelp.com/dataset/documentation/main
11
+ [Yelp Dataset](https://www.yelp.com/dataset/documentation/main)
12
12
 
13
13
 
14
14