-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathquery.sql
More file actions
69 lines (64 loc) · 18.6 KB
/
query.sql
File metadata and controls
69 lines (64 loc) · 18.6 KB
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
INSERT INTO trash (id, created_at, status, updated_at, latitude, longitude, place_info, road_addr) VALUES
(23, '2024-10-08 07:16:46.084095', 'ACTIVE', '2024-10-08 07:16:46.084095', 36.357132, 127.33366, '방앗간 앞 나무', '대전광역시 유성구 유성대로718번길 33'),
(24, '2024-10-08 07:16:46.084095', 'ACTIVE', '2024-10-08 07:16:46.084095', 36.357254, 127.335335, '유성농자재가게 앞', '대전광역시 유성구 유성대로720번길 60'),
(25, '2024-10-08 07:16:46.084095', 'ACTIVE', '2024-10-08 07:16:46.084095', 36.357464, 127.33868, '은실빌딩 앞', '대전광역시 유성구 온천서로 35-24'),
(26, '2024-10-08 07:16:46.084095', 'ACTIVE', '2024-10-08 07:16:46.084095', 36.358997, 127.33931, '장대동 7', '대전광역시 유성구 온천서로 53'),
(27, '2024-10-08 07:16:46.084095', 'ACTIVE', '2024-10-08 07:16:46.084095', 36.359417, 127.338585, '장대동 8', '대전광역시 유성구 문화원로14번길 52'),
(28, '2024-10-08 07:17:29.35832', 'ACTIVE', '2024-10-08 07:17:29.35832', 36.358665, 127.34596, '주차장 입구', '대전광역시 유성구 문화원로 90'),
(29, '2024-10-08 07:17:29.35832', 'ACTIVE', '2024-10-08 07:17:29.35832', 36.3594, 127.344666, '그랑펠피체 2,3동 앞/ 드라미아 건너편', '대전광역시 유성구 문화원로 77'),
(30, '2024-10-08 07:17:29.35832', 'ACTIVE', '2024-10-08 07:17:29.35832', 36.35892, 127.345604, 'Cu 앞', '대전광역시 유성구 문화원로 86'),
(31, '2024-10-08 07:17:29.35832', 'ACTIVE', '2024-10-08 07:17:29.35832', 36.358677, 127.345, '백만장자 앞', '대전광역시 유성구 온천북로13번길 40'),
(32, '2024-10-08 07:17:29.35832', 'ACTIVE', '2024-10-08 07:17:29.35832', 36.3583, 127.34494, '노랑통닭', '대전광역시 유성구 온천북로13번길 26'),
(33, '2024-10-08 07:17:29.35832', 'ACTIVE', '2024-10-08 07:17:29.35832', 36.35783, 127.34484, '정통집 주차장 앞', '대전광역시 유성구 온천북로13번길 14'),
(34, '2024-10-08 07:17:29.35832', 'ACTIVE', '2024-10-08 07:17:29.35832', 36.356907, 127.343346, '지마트 옆', '대전광역시 유성구 대학로 38'),
(35, '2024-10-08 07:17:29.35832', 'ACTIVE', '2024-10-08 07:17:29.35832', 36.357758, 127.34602, '엔젤타운 앞', '대전광역시 유성구 온천북로33번길 21-15'),
(36, '2024-10-08 07:17:29.35832', 'ACTIVE', '2024-10-08 07:17:29.35832', 36.357723, 127.34616, '명일시티 앞', '대전광역시 유성구 온천북로33번길 21-13'),
(37, '2024-10-08 07:17:29.35832', 'ACTIVE', '2024-10-08 07:17:29.35832', 36.357693, 127.346405, '벨포스토 앞', '대전광역시 유성구 온천북로33번길 21-9');
INSERT INTO report (id, created_at, status, updated_at, member_id, region_type, report_desc, report_img_url, report_type, road_addr) VALUES
(16, '2024-10-10 15:02:55.579501', 'DELETED', '2024-10-10 15:02:55.579501', 49, 'SEOUL', '쓰레기가 개많아요', 'https://plog-s3-bucket.s3.ap-northeast-2.amazonaws.com/reports/compressed_image_250279a9-8cd1-4142-a4f7-2fa4805b24e5.jpg', 'NOT_STARTED', '서울특별시 중구 세종대로 110 서울특별시청'),
(1, '2024-10-05 14:02:05.757837', 'DELETED', '2024-10-05 14:02:05.757837', 9, 'JEJU', '신고 설명2', 'https://plog-s3-bucket.s3.ap-northeast-2.amazonaws.com/reports/춘식이2_efb82d4b-e93c-4516-a3ba-9b6dafd0dd8b.jpeg', 'NOT_STARTED', '제주 천안시 서북구 401'),
(2, '2024-10-05 17:00:04.320024', 'DELETED', '2024-10-05 17:00:04.320024', 9, 'JEJU', '신고 설명2', 'https://plog-s3-bucket.s3.ap-northeast-2.amazonaws.com/reports/춘식이2_47bddb58-fb1a-45af-9c48-34886df8704f.jpeg', 'NOT_STARTED', '제주 천안시 서북구 401'),
(5, '2024-10-05 17:04:49.22514', 'DELETED', '2024-10-05 17:04:49.22514', 9, 'GYEONGGI', '신고 설명3', 'https://plog-s3-bucket.s3.ap-northeast-2.amazonaws.com/reports/춘식이2_00218ffb-ce82-46fe-a4ce-8a9f4a8ca08e.jpeg', 'NOT_STARTED', '경기도 수지구청역 스타벅스 앞'),
(6, '2024-10-05 17:05:24.847373', 'DELETED', '2024-10-05 17:10:22.985557', 9, 'SEOUL', '여기 구석에 쓰레기 많아요 주워가세요~', 'https://plog-s3-bucket.s3.ap-northeast-2.amazonaws.com/reports/춘식이1_5ac622bc-aec0-4f48-8119-eba1ad92b119.jpeg', 'NOT_STARTED', '서울특별시 노원구 공원 벤츠 옆'),
(7, '2024-10-08 19:23:59.358892', 'ACTIVE', '2024-10-08 19:23:59.358892', 44, 'GYEONGGI', '행리단길 쓰레기 장소', 'https://plog-s3-bucket.s3.ap-northeast-2.amazonaws.com/reports/수원 행궁동 행리단길2_bc2eba45-3233-42c1-84ba-bf9cd07abb43.jpg', 'IN_PROGRESS', '경기 수원시 팔달구 화서문로 43'),
(9, '2024-10-08 19:25:55.821498', 'ACTIVE', '2024-10-08 19:25:55.821498', 44, 'SEOUL', '명동 길거리 노점 일대에 쓰레기 쌓여 있어요.', 'https://plog-s3-bucket.s3.ap-northeast-2.amazonaws.com/reports/명동 길거리 노점 일대_ceef1e9c-a35c-487e-9746-fcf1644d709b.jpg', 'NOT_STARTED', '서울 중구 명동길 9'),
(10, '2024-10-09 03:10:13.398098', 'ACTIVE', '2024-10-09 03:10:13.398098', 44, 'SEOUL', '명동 길거리 노점 일대에 쓰레기 쌓여 있어요.', 'https://plog-s3-bucket.s3.ap-northeast-2.amazonaws.com/reports/명동 길거리 노점 일대_45f0b10d-28ed-4c06-b0d4-e8754735994e.jpg', 'NOT_STARTED', '서울 중구 명동길 9'),
(11, '2024-10-09 03:18:41.090112', 'ACTIVE', '2024-10-09 03:18:41.090112', 44, 'SEOUL', '명동 길거리 노점 일대에 쓰레기 쌓여 있어요.', 'https://plog-s3-bucket.s3.ap-northeast-2.amazonaws.com/reports/명동 길거리 노점 일대_be8ac52c-42df-4966-9875-545efedaa735.jpg', 'NOT_STARTED', '서울 중구 명동길 9'),
(17, '2024-10-10 15:32:27.239362', 'DELETED', '2024-10-10 15:33:20.730787', 49, 'SEOUL', '쓰레기가 좀 줄어들었어요', 'https://plog-s3-bucket.s3.ap-northeast-2.amazonaws.com/reports/compressed_image_06498cee-ee28-448d-af35-1368486f26e1.jpg', 'IN_PROGRESS', '서울특별시 중구 세종대로 110 서울특별시청'),
(15, '2024-10-09 03:48:28.20498', 'ACTIVE', '2024-10-09 03:54:17.342408', 44, 'GYEONGGI', '행리단길 이곳 쓰레기가 모여있어요', 'https://plog-s3-bucket.s3.ap-northeast-2.amazonaws.com/reports/수원 행궁동 행리단길2_67e12d0a-67fc-42c7-8ac9-d3787baa1c47.jpg', 'IN_PROGRESS', '경기 수원시 팔달구 화서문로 43'),
(8, '2024-10-08 19:24:29.36544', 'DELETED', '2024-10-08 19:47:26.458457', 44, 'GYEONGGI', '여기 구석에 쓰레기 많아요 주워가세요~', 'https://plog-s3-bucket.s3.ap-northeast-2.amazonaws.com/reports/수원 행궁동 행리단길2_52ba4ddd-92cc-4301-a4bc-ed12b0060cb8.jpg', 'DONE', 'https://plog-s3-bucket.s3.ap-northeast-2.amazonaws.com/reports/춘식이1_5ae15539-f564-4739-9eaa-b53e6053c4e7.jpeg'),
(18, '2024-10-10 15:34:43.797743', 'ACTIVE', '2024-10-10 15:34:43.797743', 49, 'SEOUL', '흑백요리사 맛집 티엔미미 꼭 가고 싶어요', 'https://plog-s3-bucket.s3.ap-northeast-2.amazonaws.com/reports/compressed_image_d5b5fb6c-bcbf-4035-9648-ea8c32847865.jpg', 'NOT_STARTED', '서울특별시 마포구 양화로 144 머큐어 앰버서더 호텔 4층'),
(19, '2024-10-10 15:39:47.575609', 'ACTIVE', '2024-10-10 15:39:47.575609', 49, 'GYEONGGI', '타코 냠', 'https://plog-s3-bucket.s3.ap-northeast-2.amazonaws.com/reports/compressed_image_c0099102-fd8d-401f-8582-7e4343ec9f2c.jpg', 'NOT_STARTED', '경기도 수원시 팔달구 인계로138번길 22 1층 감성타코 비스트로');
INSERT INTO member (id, created_at, status, updated_at, email, nickname, profile_image_url, social_login_id, social_login_type, reward_id) VALUES
(9, '2024-10-05 13:24:50.839886', 'DELETED', '2024-10-05 15:50:21.154222', 'hge020119@daum.net', 'khee2', 'https://plog-bucket.kr.object.ncloudstorage.com/profile/eddcec0d-7f58-4f70-885c-04c3b3192b95.png', '3645249151', 'KAKAO', 1),
(44, '2024-10-08 15:35:56.279594', 'ACTIVE', '2024-10-08 15:36:30.121246', '21keunghee@gmail.com', 'khee2', 'https://plog-bucket.kr.object.ncloudstorage.com/profile/a2a7a802-54a0-45b3-b1b2-50c2665b8c76.jpeg', '3738184464', 'KAKAO', 2),
(45, '2024-10-08 16:15:30.204739', 'DELETED', '2024-10-08 16:16:01.340443', 'hge020119@daum.net', 'goeun', 'https://plog-bucket.kr.object.ncloudstorage.com/profile/06c8324d-0c33-4931-9620-f50df01abc3e.jpg', '3645249151', 'KAKAO', 3),
(46, '2024-10-08 16:20:59.026019', 'ACTIVE', '2024-10-08 16:21:14.795571', 'sera1193@naver.com', 'goeun', 'https://plog-bucket.kr.object.ncloudstorage.com/profile/26d6713a-7f53-412e-98d6-a6baad9fffca.jpg', 'hIwxoEh4BvFkW5TbW9e8XBGU3-oOKEoCvir9P67Pthw', 'NAVER', 4),
(47, '2024-10-09 02:39:21.18483', 'DELETED', '2024-10-09 02:39:45.090242', 'hge020119@daum.net', 'goeun', 'https://plog-bucket.kr.object.ncloudstorage.com/profile/4e3769d1-25b1-4daa-b10e-e288be1b6b19.jpg', '3645249151', 'KAKAO', 5),
(48, '2024-10-09 03:06:00.317551', 'ACTIVE', '2024-10-09 03:17:50.721576', 'hge020119@daum.net', 'goeun', 'https://plog-bucket.kr.object.ncloudstorage.com/profile/04cd0a37-f9af-47f5-a7be-7c9cd8ed7170.jpg', '3645249151', 'KAKAO', 6),
(49, '2024-10-09 12:33:55.211553', 'ACTIVE', '2024-10-10 02:58:40.410546', 'gaeulzzang11@naver.com', '가을', 'https://plog-bucket.kr.object.ncloudstorage.com/profile/380b8761-db90-47eb-bdc6-a79e520ab435.jpg', 'Wdv2TrROw6Kjong9wADZcuW47AlBCv_3tcS0aYO7Ynw', 'NAVER', 7),
(50, '2024-10-10 02:01:09.757423', 'DELETED', '2024-10-10 12:54:29.944097', 'gaeulzzang@gmail.com', '가을', 'https://plog-bucket.kr.object.ncloudstorage.com/profile/6519d33d-2038-443f-a5ef-c48e2ae0c7ef.jpg', '3681301574', 'KAKAO', 8),
(51, '2024-10-10 13:14:13.068184', 'ACTIVE', '2024-10-10 13:14:13.068184', 'gaeulzzang@gmail.com', '', NULL, '3681301574', 'KAKAO', NULL),
(52, '2024-10-10 13:14:13.072893', 'ACTIVE', '2024-10-10 13:14:23.631914', 'gaeulzzang@gmail.com', '가을', 'https://plog-bucket.kr.object.ncloudstorage.com/profile/9cea8c36-4d4d-4aa7-b718-f44f5221dc69.jpg', '3681301574', 'KAKAO', 9);
INSERT INTO reward (id, created_at, status, updated_at, score) VALUES
(1, '2024-10-05 15:50:21.101696', 'DELETED', '2024-10-05 17:18:52.180106', 4),
(3, '2024-10-08 16:16:01.326929', 'DELETED', '2024-10-08 16:16:01.326929', 0),
(4, '2024-10-08 16:21:14.792377', 'ACTIVE', '2024-10-08 16:21:14.792377', 0),
(5, '2024-10-09 02:39:45.080021', 'DELETED', '2024-10-09 02:39:45.080021', 0),
(6, '2024-10-09 03:17:50.587736', 'ACTIVE', '2024-10-09 03:17:50.587736', 0),
(2, '2024-10-08 15:36:30.111338', 'ACTIVE', '2024-10-09 17:23:03.201487', 9),
(8, '2024-10-10 12:54:29.938328', 'DELETED', '2024-10-10 12:54:29.938328', 0),
(9, '2024-10-10 13:14:23.625982', 'ACTIVE', '2024-10-10 13:14:23.625982', 0),
(7, '2024-10-10 02:58:40.39317', 'ACTIVE', '2024-10-10 15:39:47.604766', 4);
INSERT INTO plogging (id, created_at, status, updated_at, end_road_addr, member_id, plogging_img_url, plogging_time, start_road_addr) VALUES
(1, '2024-10-05 16:51:54.512259', 'DELETED', '2024-10-05 16:51:54.512259', '서울특별시 용산구 효창원로 177-18', 9, 'https://plog-bucket.kr.object.ncloudstorage.com/plogging/79616f65-0bbc-4005-9075-dcbbe70fbd24.jpeg', '01:30:00', '서울특별시 용산구 청파로47길 100'),
(2, '2024-10-08 16:17:05.435232', 'DELETED', '2024-10-08 16:17:05.435232', '하계동', 45, 'https://plog-bucket.kr.object.ncloudstorage.com/plogging/dbcd7a5a-319c-4280-9639-4c650471b148.', '12:00:00', '노원구'),
(3, '2024-10-08 19:36:50.416238', 'ACTIVE', '2024-10-08 19:36:50.416238', '서울특별시 용산구 효창원로 177-18', 44, 'https://plog-bucket.kr.object.ncloudstorage.com/plogging/a9be1ddb-27a4-4a9a-ad9c-c6de8c178d3f.jpg', '01:30:00', '서울특별시 용산구 청파로47길 100'),
(4, '2024-10-09 02:40:37.170568', 'DELETED', '2024-10-09 02:40:37.170568', '하계동', 47, 'https://plog-bucket.kr.object.ncloudstorage.com/plogging/d209fe40-8d94-418f-b0d0-6cdc3515fb98.', '12:00:00', '노원구');
INSERT INTO bookmark (id, created_at, status, updated_at, bookmarked, member_id, report_id) VALUES
(1, '2024-10-05 17:12:50.580444', 'DELETED', '2024-10-05 17:13:32.058859', 't', 9, 1),
(2, '2024-10-05 17:13:37.105597', 'DELETED', '2024-10-05 17:13:37.105597', 't', 9, 6),
(4, '2024-10-08 19:29:38.897461', 'ACTIVE', '2024-10-08 19:29:38.897461', 't', 44, 9),
(3, '2024-10-08 19:28:54.222499', 'DELETED', '2024-10-08 19:28:54.222499', 't', 44, 8),
(5, '2024-10-09 03:53:15.803263', 'ACTIVE', '2024-10-09 06:22:05.170069', 't', 44, 15),
(6, '2024-10-10 13:59:12.902689', 'ACTIVE', '2024-10-10 14:00:51.577505', 'f', 52, 7);