init
insert into address(id, city, created_at, updated_at) values(1, 'JONGNO_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(2, 'JUNG_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(3, 'YONGSAN_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(4, 'SEONGDONG_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(5, 'GWANGJIN_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(6, 'DONGDAEMUN_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(7, 'JUNGNANG_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(8, 'SEONGBUK_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(9, 'GANGBUK_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(10, 'DOBONG_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(11, 'NOWON_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(12, 'EUNPYEONG_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(13, 'SEODAEMUN_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(14, 'MAPO_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(15, 'YANGCHEON_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(16, 'GANGSEO_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(17, 'GURO_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(18, 'GEUMCHEON_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(19, 'YEONGDEUNGPO_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(20, 'DONGJAK_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(21, 'GWANAK_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(22, 'SEOCHO_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(23, 'GANGNAM_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(24, 'SONGPA_GU', now(), now());
insert into address(id, city, created_at, updated_at) values(25, 'GANGDONG_GU', now(), now());
insert into category(id, exercise, created_at, updated_at) values(1, 'SOCCER', now(), now());
insert into category(id, exercise, created_at, updated_at) values(2, 'BASKETBALL', now(), now());
insert into category(id, exercise, created_at, updated_at) values(3, 'TENNIS', now(), now());
insert into category(id, exercise, created_at, updated_at) values(4, 'RUNNING', now(), now());
insert into category(id, exercise, created_at, updated_at) values(5, 'HIKING', now(), now());
insert into category(id, exercise, created_at, updated_at) values(6, 'BICYCLE', now(), now());
insert into category(id, exercise, created_at, updated_at) values(7, 'CLIMBING', now(), now());
insert into category(id, exercise, created_at, updated_at) values(8, 'VOLLYBALL', now(), now());
insert into category(id, exercise, created_at, updated_at) values(9, 'BASEBALL', now(), now());
insert into category(id, exercise, created_at, updated_at) values(10, 'FUTSAL', now(), now());
insert into category(id, exercise, created_at, updated_at) values(11, 'BADMINTON', now(), now());
insert into category(id, exercise, created_at, updated_at) values(12, 'RUGBY', now(), now());
insert into category(id, exercise, created_at, updated_at) values(13, 'BOXING', now(), now());
insert into category(id, exercise, created_at, updated_at) values(14, 'ICE_HOKEY', now(), now());
insert into category(id, exercise, created_at, updated_at) values(15, 'GOLF', now(), now());
insert into category(id, exercise, created_at, updated_at) values(16, 'OTHERS', now(), now());
insert into tag(id, name, created_at, updated_at) values(1, 'TIGHT_USER', now(), now());
insert into tag(id, name, created_at, updated_at) values(2, 'FUN_USER', now(), now());
테스트용 데이터
User
| id |
accessToken |
status |
address |
category |
boardId |
reportId |
hiddenBoard |
bookMark |
| 1 |
accessToken1 |
ACTIVE |
1 |
[ 1 ] |
[ 1 ] |
1~9 |
[ 12 ] |
[1,2,3] |
| 2 |
accessToken2 |
ACTIVE |
1 |
[ 1,2 ] |
[ 2, 3 ] |
|
[ 11, 10 ] |
[3,4,5] |
| 3 |
accessToken3 |
ACTIVE |
1 |
[ 1,2 ] |
[ 4, 5, 6 ] |
|
[ 9 ] |
[3,4] |
| 4 |
accessToken4 |
ACTIVE |
1 |
[ 3,4,5 ] |
[ 7, 8, 9, 10 ] |
|
[ 8, 7 ] |
[1,3,5] |
| 5 |
accessToken5 |
ACTIVE |
1 |
[ 4,5,6 ] |
[ 11, 12, 13, 14 ] |
|
[ 6 ] |
[2,4] |
| 6 |
accessToken6 |
SUSPENDED |
1 |
[ 1,2 ] |
[ 15, 16 ] |
|
[ 5 ] |
[1,3] |
| 7 |
accessToken7 |
INACTIVE |
1 |
[ 3,4 ] |
[ 17 ] |
|
[ 4 ] |
[] |
Board
| id |
userId |
recruit_count |
applied user Id |
accepted user Id |
status |
| 1 |
1 |
2 |
[2, 3, 4] |
[2, 3] |
종료 |
| 2 |
2 |
2 |
[1, 3, 4, 5] |
[1,4] |
종료 |
| 3 |
2 |
2 |
[1, 2] |
[1, 2] |
종료 |
| 4 |
3 |
2 |
[1,2] |
[] |
진행중 |
| 5 |
3 |
2 |
[1,2,4] |
[2] |
진행중 |
| 6 |
3 |
2 |
[] |
[] |
진행중 |
| 7 |
4 |
2 |
[1] |
[1] |
취소 |
| 8 |
4 |
2 |
[] |
[] |
취소 |
| 9 |
4 |
3 |
[1,2,3] |
[1,2,3] |
모집완료 |
| 10 |
4 |
3 |
[1,2,3,5] |
[1,2,3] |
모집완료 |
| 11 |
5 |
3 |
[2,3,4] |
[] |
진행중 |
| 12 |
5 |
3 |
[2,3,4] |
[2,3,4] |
모집완료 |
| 13 |
5 |
3 |
[3,4,6] |
[3,4,6] |
종료 |
| 14 |
5 |
3 |
[1,2,3] |
[1,2,3] |
종료 |
| 15 |
6 |
3 |
[1,2] |
[] |
진행중 |
| 16 |
6 |
3 |
[] |
[] |
취소 |
| 17 |
7 |
3 |
[1,2,3] |
[3] |
진행중 |
insert into user(id, access_token, oauth_id, username, nickname, email, intro, status, address_id, suspended_day, created_at, updated_at) values(1, "accessToken1", "oauthId1", "박소연", "소연", "[email protected]", "안녕하세요1", "ACTIVE", 1, 0, now(), now());
insert into user(id, access_token, oauth_id, username, nickname, email, intro, status, address_id, suspended_day, created_at, updated_at) values(2, "accessToken2", "oauthId2", "김민호", "민호", "[email protected]", "안녕하세요2", "ACTIVE", 1, 0, now(), now());
insert into user(id, access_token, oauth_id, username, nickname, email, intro, status, address_id, suspended_day, created_at, updated_at) values(3, "accessToken3", "oauthId3", "박해민", "해민", "[email protected]", "안녕하세요3", "ACTIVE", 1, 0, now(), now());
insert into user(id, access_token, oauth_id, username, nickname, email, intro, status, address_id, suspended_day, created_at, updated_at) values(4, "accessToken4", "oauthId4", "원알렉스", "알렉스", "[email protected]", "안녕하세요4", "ACTIVE", 1, 0, now(), now());
insert into user(id, access_token, oauth_id, username, nickname, email, intro, status, address_id, suspended_day, created_at, updated_at) values(5, "accessToken5", "oauthId5", "김동환", "dongwhan", "[email protected]", "안녕하세요5", "ACTIVE", 2, 0, now(), now());
insert into user(id, access_token, oauth_id, username, nickname, email, intro, status, address_id, suspended_day, created_at, updated_at) values(6, "accessToken6", "oauthId6", "정예찬", "yc0191", "[email protected]", "안녕하세요6", "SUSPENDED", 2, 0, now(), now());
insert into user(id, access_token, oauth_id, username, nickname, email, intro, status, address_id, suspended_day, created_at, updated_at) values(7, "accessToken7", "oauthId7", "박다영", "DAUN11", "[email protected]", "안녕하세요7", "INACTIVE", 2, 0, now(), now());
insert into user_exercise(id, category_id, user_id, created_at, updated_at) values (1, 1, 1, now(), now());
insert into user_exercise(id, category_id, user_id, created_at, updated_at) values (2, 1, 2, now(), now());
insert into user_exercise(id, category_id, user_id, created_at, updated_at) values (3, 2, 2, now(), now());
insert into user_exercise(id, category_id, user_id, created_at, updated_at) values (4, 1, 3, now(), now());
insert into user_exercise(id, category_id, user_id, created_at, updated_at) values (5, 2, 3, now(), now());
insert into user_exercise(id, category_id, user_id, created_at, updated_at) values (6, 3, 4, now(), now());
insert into user_exercise(id, category_id, user_id, created_at, updated_at) values (7, 4, 4, now(), now());
insert into user_exercise(id, category_id, user_id, created_at, updated_at) values (8, 5, 4, now(), now());
insert into user_exercise(id, category_id, user_id, created_at, updated_at) values (9, 4, 5, now(), now());
insert into user_exercise(id, category_id, user_id, created_at, updated_at) values (10, 5, 5, now(), now());
insert into user_exercise(id, category_id, user_id, created_at, updated_at) values (11, 6, 5, now(), now());
insert into user_exercise(id, category_id, user_id, created_at, updated_at) values (12, 1, 6, now(), now());
insert into user_exercise(id, category_id, user_id, created_at, updated_at) values (13, 2, 6, now(), now());
insert into user_exercise(id, category_id, user_id, created_at, updated_at) values (14, 3, 7, now(), now());
insert into user_exercise(id, category_id, user_id, created_at, updated_at) values (15, 4, 7, now(), now());
insert into board (id, title, content, place, recruit_count, starts_at, status, address_id, category_id, tag_id, user_id, created_at, updated_at) values (1, "제목1", "내용1", "위치1", 2, "2019-10-18 18:02:17", 2, 1, 1, 1, 1, now(), now());
insert into board (id, title, content, place, recruit_count, starts_at, status, address_id, category_id, tag_id, user_id, created_at, updated_at) values (2, "제목2", "내용2", "위치2", 2, "2019-10-19 18:02:17", 2, 1, 1, 1, 2, now(), now());
insert into board (id, title, content, place, recruit_count, starts_at, status, address_id, category_id, tag_id, user_id, created_at, updated_at) values (3, "제목3", "농구", "위치3", 2, "2019-10-18 18:02:17", 2, 2, 2, 1, 2, now(), now());
insert into board (id, title, content, place, recruit_count, starts_at, status, address_id, category_id, tag_id, user_id, created_at, updated_at) values (4, "제목4", "농구", "위치4", 2, "2021-10-18 18:02:17", 0, 2, 2, 1, 3, now(), now());
insert into board (id, title, content, place, recruit_count, starts_at, status, address_id, category_id, tag_id, user_id, created_at, updated_at) values (5, "제목5", "축구", "위치5", 2, "2021-10-18 18:02:17", 0, 3, 3, 1, 3, now(), now());
insert into board (id, title, content, place, recruit_count, starts_at, status, address_id, category_id, tag_id, user_id, created_at, updated_at) values (6, "제목6", "축구 3명", "위치6", 2, "2021-10-18 18:02:17", 0, 3, 1, 1, 3, now(), now());
insert into board (id, title, content, place, recruit_count, starts_at, status, address_id, category_id, tag_id, user_id, created_at, updated_at) values (7, "제목7", "축구 13명", "위치7", 2, "2020-10-18 18:02:17", 3, 4, 1, 1, 4, now(), now());
insert into board (id, title, content, place, recruit_count, starts_at, status, address_id, category_id, tag_id, user_id, created_at, updated_at) values (8, "제목8", "야구", "위치8", 2, "2019-10-18 18:02:17", 3, 1, 4, 2, 4, now(), now());
insert into board (id, title, content, place, recruit_count, starts_at, status, address_id, category_id, tag_id, user_id, created_at, updated_at) values (9, "제목9", "야구", "위치9", 3, "2021-10-18 18:02:17", 1, 1, 4, 2, 4, now(), now());
insert into board (id, title, content, place, recruit_count, starts_at, status, address_id, category_id, tag_id, user_id, created_at, updated_at) values (10, "제목10", "테스트", "위치10", 3, "2021-10-18 18:02:17", 1, 5, 2, 1, 4, now(), now());
insert into board (id, title, content, place, recruit_count, starts_at, status, address_id, category_id, tag_id, user_id, created_at, updated_at) values (11, "제목11", "테스트", "위치11", 3, "2021-10-18 18:02:17", 0, 6, 3, 1, 5, now(), now());
insert into board (id, title, content, place, recruit_count, starts_at, status, address_id, category_id, tag_id, user_id, created_at, updated_at) values (12, "제목12", "테스트2", "위치12", 3, "2021-10-18 18:02:17", 1, 6, 1, 2, 5, now(), now());
insert into board (id, title, content, place, recruit_count, starts_at, status, address_id, category_id, tag_id, user_id, created_at, updated_at) values (13, "제목13", "테스트2", "위치12", 3, "2019-10-18 18:02:17", 2, 7, 1, 1, 5, now(), now());
insert into board (id, title, content, place, recruit_count, starts_at, status, address_id, category_id, tag_id, user_id, created_at, updated_at) values (14, "제목14", "테스트2", "위치12", 3, "2019-10-18 18:02:17", 2, 7, 2, 2, 5, now(), now());
insert into board (id, title, content, place, recruit_count, starts_at, status, address_id, category_id, tag_id, user_id, created_at, updated_at) values (15, "제목15", "테스트2", "위치12", 3, "2021-10-18 18:02:17", 0, 8, 2, 1, 6, now(), now());
insert into board (id, title, content, place, recruit_count, starts_at, status, address_id, category_id, tag_id, user_id, created_at, updated_at) values (16, "제목16", "테스트2", "위치12", 3, "2020-10-18 18:02:17", 3, 8, 1, 2, 6, now(), now());
insert into board (id, title, content, place, recruit_count, starts_at, status, address_id, category_id, tag_id, user_id, created_at, updated_at) values (17, "제목17", "테스트2", "위치12", 3, "2021-10-18 18:02:17", 0, 9, 1, 1, 7, now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(1, 1, 2, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(2, 1, 3, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(3, 1, 4, 'APPLIED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(4, 2, 1, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(5, 2, 3, 'APPLIED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(6, 2, 4, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(7, 2, 5, 'APPLIED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(8, 3, 1, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(9, 3, 2, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(10, 4, 1, 'APPLIED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(11, 4, 2, 'APPLIED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(12, 5, 1, 'APPLIED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(13, 5, 2, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(14, 5, 4, 'APPLIED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(15, 7, 1, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(16, 9, 1, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(17, 9, 2, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(18, 9, 3, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(19, 10, 1, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(20, 10, 2, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(21, 10, 3, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(22, 10, 5, 'APPLIED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(23, 11, 2, 'APPLIED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(24, 11, 3, 'APPLIED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(25, 11, 4, 'APPLIED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(26, 12, 2, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(27, 12, 3, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(28, 12, 4, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(29, 13, 3, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(30, 13, 4, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(31, 13, 6, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(32, 14, 1, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(33, 14, 2, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(34, 14, 3, 'APPROVED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(35, 15, 1, 'APPLIED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(36, 15, 2, 'APPLIED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(37, 17, 1, 'APPLIED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(38, 17, 2, 'APPLIED', now(), now());
insert into applied_user(id, board_id, user_id, status, created_at, updated_at) values(39, 17, 3, 'APPROVED', now(), now());
insert into hidden_board(id, user_id, board_id, created_at, updated_at) values(1, 1, 12, now(), now());
insert into hidden_board(id, user_id, board_id, created_at, updated_at) values(2, 2, 11, now(), now());
insert into hidden_board(id, user_id, board_id, created_at, updated_at) values(3, 2, 10, now(), now());
insert into hidden_board(id, user_id, board_id, created_at, updated_at) values(4, 3, 9, now(), now());
insert into hidden_board(id, user_id, board_id, created_at, updated_at) values(5, 4, 8, now(), now());
insert into hidden_board(id, user_id, board_id, created_at, updated_at) values(6, 4, 7, now(), now());
insert into hidden_board(id, user_id, board_id, created_at, updated_at) values(7, 5, 6, now(), now());
insert into hidden_board(id, user_id, board_id, created_at, updated_at) values(8, 6, 5, now(), now());
insert into hidden_board(id, user_id, board_id, created_at, updated_at) values(9, 7, 4, now(), now());
insert into book_mark(id, user_id, board_id, created_at, updated_at) values(1, 1, 1, now(), now());
insert into book_mark(id, user_id, board_id, created_at, updated_at) values(2, 1, 2, now(), now());
insert into book_mark(id, user_id, board_id, created_at, updated_at) values(3, 1, 3, now(), now());
insert into book_mark(id, user_id, board_id, created_at, updated_at) values(4, 2, 3, now(), now());
insert into book_mark(id, user_id, board_id, created_at, updated_at) values(5, 2, 4, now(), now());
insert into book_mark(id, user_id, board_id, created_at, updated_at) values(6, 2, 5, now(), now());
insert into book_mark(id, user_id, board_id, created_at, updated_at) values(7, 3, 3, now(), now());
insert into book_mark(id, user_id, board_id, created_at, updated_at) values(8, 3, 4, now(), now());
insert into book_mark(id, user_id, board_id, created_at, updated_at) values(9, 4, 1, now(), now());
insert into book_mark(id, user_id, board_id, created_at, updated_at) values(10, 4, 3, now(), now());
insert into book_mark(id, user_id, board_id, created_at, updated_at) values(11, 4, 5, now(), now());
insert into book_mark(id, user_id, board_id, created_at, updated_at) values(12, 5, 2, now(), now());
insert into book_mark(id, user_id, board_id, created_at, updated_at) values(13, 5, 4, now(), now());
insert into book_mark(id, user_id, board_id, created_at, updated_at) values(14, 6, 1, now(), now());
insert into book_mark(id, user_id, board_id, created_at, updated_at) values(15, 6, 3, now(), now());
insert into report(id, content, type, reported_id, reporter_id, created_at, updated_at) values (1, null, 1, 1, 2, now(), now());
insert into report(id, content, type, reported_id, reporter_id, created_at, updated_at) values (2, null, 2, 1, 3, now(), now());
insert into report(id, content, type, reported_id, reporter_id, created_at, updated_at) values (3, null, 2, 1, 3, now(), now());
insert into report(id, content, type, reported_id, reporter_id, created_at, updated_at) values (4, null, 3, 1, 4, now(), now());
insert into report(id, content, type, reported_id, reporter_id, created_at, updated_at) values (5, null, 3, 1, 4, now(), now());
insert into report(id, content, type, reported_id, reporter_id, created_at, updated_at) values (6, null, 4, 1, 4, now(), now());
insert into report(id, content, type, reported_id, reporter_id, created_at, updated_at) values (7, null, 4, 1, 5, now(), now());
insert into report(id, content, type, reported_id, reporter_id, created_at, updated_at) values (8, null, 4, 1, 6, now(), now());
insert into report(id, content, type, reported_id, reporter_id, created_at, updated_at) values (9, "테스트", 5, 1, 7, now(), now());
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(1, 1, 2, 1, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(2, 1, 3, 1, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(3, 1, 4, 1, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(4, 2, 1, 2, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(5, 2, 3, 2, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(6, 2, 4, 2, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(7, 2, 5, 2, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(8, 3, 1, 2, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(9, 3, 2, 2, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(10, 4, 1, 3, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(11, 4, 2, 3, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(12, 5, 1, 3, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(13, 5, 2, 3, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(14, 5, 4, 3, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(15, 7, 1, 4, 'INACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(16, 9, 1, 4, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(17, 9, 2, 4, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(18, 9, 3, 4, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(19, 10, 1, 4, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(20, 10, 2, 4, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(21, 10, 3, 4, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(22, 10, 5, 4, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(23, 11, 2, 5, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(24, 11, 3, 5, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(25, 11, 4, 5, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(26, 12, 2, 5, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(27, 12, 3, 5, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(28, 12, 4, 5, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(29, 13, 3, 5, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(30, 13, 4, 5, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(31, 13, 6, 5, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(32, 14, 1, 5, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(33, 14, 2, 5, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(34, 14, 3, 5, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(35, 15, 1, 6, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(36, 15, 2, 6, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(37, 17, 1, 7, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(38, 17, 2, 7, 'ACTIVE', now(), now(), false, false);
insert into chat_room(id, board_id, guest_id, host_id, status, created_at, updated_at, guest_exited, host_exited) values(39, 17, 3, 7, 'ACTIVE', now(), now(), false, false);
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(1, 1, 1, 2, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(2, 1, 1, 3, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(3, 1, 2, 1, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(4, 1, 2, 3, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(5, 1, 3, 1, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(6, 1, 3, 2, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(7, 2, 1, 2, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(8, 2, 1, 4, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(9, 2, 2, 1, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(10, 2, 2, 4, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(11, 2, 4, 1, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(12, 2, 4, 2, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(13, 3, 1, 2, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(14, 3, 1, 3, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(15, 3, 2, 1, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(16, 3, 2, 3, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(17, 3, 3, 1, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(18, 3, 3, 2, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(19, 7, 1, 4, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(20, 7, 4, 1, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(21, 13, 3, 4, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(22, 13, 3, 5, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(23, 13, 3, 6, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(24, 13, 4, 3, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(25, 13, 4, 5, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(26, 13, 4, 6, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(27, 13, 5, 3, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(28, 13, 5, 4, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(29, 13, 5, 6, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(30, 13, 6, 3, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(31, 13, 6, 4, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(32, 13, 6, 5, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(33, 14, 1, 2, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(34, 14, 1, 3, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(35, 14, 1, 5, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(36, 14, 2, 1, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(37, 14, 2, 3, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(38, 14, 2, 5, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(39, 14, 3, 1, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(40, 14, 3, 2, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(41, 14, 3, 5, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(42, 14, 5, 1, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(43, 14, 5, 2, false, false, now(), now());
insert into evaluation(id, board_id, evaluate_id, evaluated_id, is_like, is_dislike, created_at, updated_at) values(44, 14, 5, 3, false, false, now(), now());