-
Notifications
You must be signed in to change notification settings - Fork 14
/
ddl.sql
417 lines (384 loc) · 11.3 KB
/
ddl.sql
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
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
create table board
(
board_seq bigint auto_increment
primary key,
created_at datetime(6) null,
updated_at datetime(6) null,
content varchar(255) null,
title varchar(255) null
);
create table club
(
seq bigint auto_increment
primary key,
created_at datetime null,
updated_at datetime null,
description text null,
maximum_number bigint not null,
name varchar(255) null,
main_image_url varchar(511) null
)
collate=utf8mb4_unicode_ci;
create table hibernate_sequence
(
next_val bigint null
)
collate=utf8mb4_unicode_ci;
create table interest_group
(
seq bigint auto_increment
primary key,
created_at datetime null,
updated_at datetime null,
name varchar(255) null
)
collate=utf8mb4_unicode_ci;
create table interest
(
seq bigint auto_increment
primary key,
created_at datetime null,
updated_at datetime null,
name varchar(255) null,
interest_group_seq bigint null,
sequence bigint not null,
constraint FK641m4p065t2ymbn5txsbsm1as
foreign key (interest_group_seq) references interest_group (seq)
)
collate=utf8mb4_unicode_ci;
create table club_interest
(
seq bigint auto_increment
primary key,
created_at datetime null,
updated_at datetime null,
priority bigint not null,
club_seq bigint null,
interest_seq bigint null,
constraint FKc1wkvxn6t5pfb2fv9mn91s6un
foreign key (club_seq) references club (seq),
constraint FKpibb4vu42tncr81neqhfidtss
foreign key (interest_seq) references interest (seq)
)
collate=utf8mb4_unicode_ci;
create table region
(
seq bigint auto_increment
primary key,
created_at datetime null,
updated_at datetime null,
level bigint not null,
name varchar(255) null,
super_region_root varchar(255) null,
super_region_seq bigint null
)
collate=utf8mb4_unicode_ci;
create table club_region
(
seq bigint auto_increment
primary key,
created_at datetime null,
updated_at datetime null,
priority bigint not null,
club_seq bigint null,
region_seq bigint null,
constraint FK6ndg1ekavq86qj6y34sbwh5ys
foreign key (region_seq) references region (seq),
constraint FKb3bf99jys98t6ii8juav9kid4
foreign key (club_seq) references club (seq)
)
collate=utf8mb4_unicode_ci;
create index FKg4jeiuwjkv7phuycq163lnba4
on club_region (region_seq);
create index FKh608kxmggam08l91vexbyhim
on club_region (club_seq);
create table role_group
(
seq bigint auto_increment
primary key,
created_at datetime null,
updated_at datetime null,
name varchar(255) null,
role_type varchar(255) null
)
collate=utf8mb4_unicode_ci;
create table role
(
seq bigint auto_increment
primary key,
created_at datetime null,
updated_at datetime null,
name varchar(255) null,
role_group_seq bigint null,
level int not null,
constraint FKtptev34twpe5lbnkr1plcx3kx
foreign key (role_group_seq) references role_group (seq)
)
collate=utf8mb4_unicode_ci;
create table user
(
seq bigint auto_increment
primary key,
created_at datetime null,
updated_at datetime null,
access_token varchar(255) null,
refresh_token varchar(255) null,
user_id varchar(255) null,
user_type varchar(255) null,
birthday date null,
profile_image_link varchar(255) null,
user_name varchar(255) null,
is_registered bit not null
)
collate=utf8mb4_unicode_ci;
create table club_user
(
seq bigint auto_increment
primary key,
created_at datetime null,
updated_at datetime null,
club_seq bigint null,
user_seq bigint null,
is_liked tinyint(1) default 0 null,
constraint FK62ekt7c05ms3q5j80ouk1b4ot
foreign key (club_seq) references club (seq),
constraint FKogm3lyntcwe641wcd3lb2m9pt
foreign key (user_seq) references user (seq)
)
collate=utf8mb4_unicode_ci;
create table club_album
(
seq bigint auto_increment
primary key,
created_at datetime null,
updated_at datetime null,
title varchar(100) null,
file_name varchar(200) null,
delete_flag bit null,
img_url varchar(400) null,
club_seq bigint null,
club_user_seq bigint null,
constraint FKef2hv0dli9ku7wdui5luxekrq
foreign key (club_seq) references club (seq),
constraint FKq0ssx32vp8htq3kngistkpxi0
foreign key (club_user_seq) references club_user (seq)
);
create table club_album_comment
(
seq bigint auto_increment
primary key,
parent_comment_seq bigint null,
updated_at datetime null,
club_user_seq bigint null,
content varchar(400) null,
created_at datetime null,
club_album_seq bigint null,
depth bigint null,
constraint FK3uebctrsu98a5nptfiyk8gho4
foreign key (club_album_seq) references club_album (seq),
constraint FKjtn6sar92g2n836r0erpe8dnr
foreign key (club_user_seq) references club_user (seq),
constraint FKpbhpgmk6o38qv9i4iha1ldgsi
foreign key (parent_comment_seq) references club_album_comment (seq)
);
create table club_album_like
(
seq bigint auto_increment
primary key,
created_at datetime null,
updated_At datetime null,
club_album_seq bigint null,
club_user_seq bigint null,
constraint FK4s523umaiic8ecnexigps9xpk
foreign key (club_user_seq) references club_user (seq),
constraint FKhpo3h1ufutngf8vwvlsxxt64o
foreign key (club_album_seq) references club_album (seq)
);
create table club_board
(
seq bigint auto_increment
primary key,
club_seq bigint null,
updated_at datetime null,
content varchar(255) null,
delete_flag bit not null,
notification_flag bit not null,
title varchar(255) null,
top_fixed_flag bit not null,
club_user_seq bigint null,
title_img_seq bigint null,
created_at datetime null,
category int null,
constraint FKhjgbcrv2i19rtlf77ydmh2hdd
foreign key (club_user_seq) references club_user (seq),
constraint FKmqpw1u0yrl7sura39i7c51fsv
foreign key (club_seq) references club (seq)
)
collate=utf8mb4_unicode_ci;
create table board_comment
(
seq bigint auto_increment
primary key,
created_at datetime(6) null,
updated_at datetime(6) null,
content varchar(255) null,
delete_flag bit not null,
depth bigint not null,
club_board_seq bigint null,
club_user_seq bigint null,
parent_comment_seq bigint null,
constraint FK97sbraq8i5of5ww49rgkyieyd
foreign key (club_board_seq) references club_board (seq),
constraint FKec2gq9fb858uvrd2t8i62nao7
foreign key (parent_comment_seq) references board_comment (seq),
constraint FKr5289may1w0hsacsbr3me6pis
foreign key (club_user_seq) references club_user (seq)
);
create index FK2s30dsmnxi4scxwmai0wwbepf
on club_board (title_img_seq);
create table club_board_comment
(
seq bigint auto_increment
primary key,
created_at datetime(6) null,
updated_at datetime(6) null,
content varchar(255) null,
delete_flag bit not null,
depth bigint not null,
club_board_seq bigint null,
club_user_seq bigint null,
parent_comment_seq bigint null,
constraint FKbcj4qn1c83supq54dxbdd6tj9
foreign key (club_user_seq) references club_user (seq),
constraint FKkspr6a9verlqi2992tm2yfgjw
foreign key (club_board_seq) references club_board (seq),
constraint FKo8912766p9cx76wx9uhbkw7fl
foreign key (parent_comment_seq) references club_board_comment (seq)
);
create table club_board_img
(
seq bigint auto_increment
primary key,
img_name varchar(50) null,
img_url varchar(400) null,
club_board_seq bigint not null,
updated_at datetime null,
delete_flag bit not null,
created_at datetime null,
constraint FKdih47mhn3tw2r6qrw26aa2xgg
foreign key (club_board_seq) references club_board (seq)
)
collate=utf8mb4_unicode_ci;
create table club_board_like
(
seq bigint auto_increment
primary key,
created_at datetime(6) null,
updated_at datetime(6) null,
club_board_seq bigint null,
club_user_seq bigint null,
constraint FKcxek9ktisuvs49wcj0t6rehb1
foreign key (club_board_seq) references club_board (seq),
constraint FKsiurgq3qpo6fbtjmu2tt2op26
foreign key (club_user_seq) references club_user (seq)
);
create table club_user_role
(
seq bigint auto_increment
primary key,
created_at datetime null,
updated_at datetime null,
club_user_seq bigint null,
role_seq bigint null,
constraint FK16v81lw0qtbwmgowrvv9kj4f1
foreign key (role_seq) references role (seq),
constraint FK77aw8u5rqnqkfulcg7dmx8k18
foreign key (club_user_seq) references club_user (seq)
)
collate=utf8mb4_unicode_ci;
create table meeting
(
seq bigint auto_increment
primary key,
created_at datetime null,
updated_at datetime null,
content varchar(255) null,
delete_flag bit not null,
end_timestamp datetime null,
start_timestamp datetime null,
title varchar(255) null,
club_seq bigint null,
maximum_number bigint null,
reg_club_user_seq bigint not null,
region varchar(1000) null,
regionURL varchar(1000) null,
cost int null,
constraint FK2p2i0pqotdrunkgkl7659d5eo
foreign key (club_seq) references club (seq),
constraint FKcyexdmtpr4eo3y0s90p8tkpv6
foreign key (reg_club_user_seq) references club_user (seq)
)
collate=utf8mb4_unicode_ci;
create table meeting_application
(
seq bigint auto_increment
primary key,
created_at datetime null,
updated_at datetime null,
delete_flag bit not null,
club_user_seq bigint null,
meeting_seq bigint null,
constraint FKhwprcrvbgy23n70k3b0aosubw
foreign key (club_user_seq) references club_user (seq),
constraint FKr5unea7i15x7rw67f8httpt2d
foreign key (meeting_seq) references meeting (seq)
)
collate=utf8mb4_unicode_ci;
create table user_interest
(
seq bigint auto_increment
primary key,
created_at datetime null,
updated_at datetime null,
priority bigint not null,
interest_seq bigint null,
user_seq bigint null,
constraint FK8bkdvsxu32diislo8ebrskqek
foreign key (interest_seq) references interest (seq),
constraint FK9ry12q7d032bpt5dpq7jgtkoh
foreign key (user_seq) references user (seq)
)
collate=utf8mb4_unicode_ci;
create index FK2ouj0bgl46rx54qjkm9950rka
on user_interest (interest_seq);
create table user_region
(
seq bigint auto_increment
primary key,
created_at datetime null,
updated_at datetime null,
priority bigint not null,
region_seq bigint null,
user_seq bigint null,
constraint FKt14k0fdc7622mujq7jitu3w4x
foreign key (region_seq) references region (seq),
constraint FKtrn222rvy23garm4l4i409jda
foreign key (user_seq) references user (seq)
)
collate=utf8mb4_unicode_ci;
create index FKloot64u32vp2nink5mce5l69
on user_region (region_seq);
create index FKslxw1alk86h74pd0rcspfuy6v
on user_region (user_seq);
create table user_role
(
seq bigint auto_increment
primary key,
created_at datetime null,
updated_at datetime null,
role_name varchar(255) null,
user_seq bigint null
)
collate=utf8mb4_unicode_ci;
create index FKiy9g0hyj33rambfmatd6e1h2n
on user_role (user_seq);