-
Notifications
You must be signed in to change notification settings - Fork 2
DB 구조
soyeon Park edited this page Dec 14, 2020
·
34 revisions
- address
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());
- category
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());
- tag
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());
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 ] | [] |
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] | 진행중 |
- user
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());
- user_exercise
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());
- board
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());
- applied_user
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());
- hidden_board
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());
- bookmark
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());
- report
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());
- chat_room
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);
- evaluation
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());