Seed Data | Notion

# CHURCH
INSERT INTO `into-the-heaven`.church (id, name, location, number, homepage_url, description, created_at, updated_at, deleted_at) VALUES ('28e469aa-674c-4517-9280-2d7c7f8a4524', '성실장로교회', '서울특별시 강북구 노해로 50', '02-998-9988', null, null, '2025-07-14 01:03:01', '2025-07-14 01:03:01', null);
INSERT INTO `into-the-heaven`.church (id, name, location, number, homepage_url, description, created_at, updated_at, deleted_at) VALUES ('87e613cc-a3ac-4529-84f1-624889f9ee22', '번동제일교회', '서울특별시 강북구 덕릉로40다길 13', '02-985-2411', '<http://www.bundong.com/Include/index.html>', null, '2025-07-14 01:03:01', '2025-07-14 01:03:01', null);

# CHURCH_MEMBER
INSERT INTO `into-the-heaven`.church_member (id, church_id, member_id, role, created_at, updated_at, deleted_at) VALUES ('17dae0a8-ebb5-4357-a1d6-92ab71427a71', '28e469aa-674c-4517-9280-2d7c7f8a4524', '6f33d359-bc2c-42cd-b875-12937bee989f', 'MEMBER', '2025-08-01 13:20:17', '2025-08-01 13:20:17', null);
INSERT INTO `into-the-heaven`.church_member (id, church_id, member_id, role, created_at, updated_at, deleted_at) VALUES ('c66701ab-f0fe-47d7-9c1a-753984439f5a', '87e613cc-a3ac-4529-84f1-624889f9ee22', '6f33d359-bc2c-42cd-b875-12937bee989f', 'MEMBER', '2025-08-01 13:20:17', '2025-08-01 13:20:17', null);

# GATHERING
INSERT INTO `into-the-heaven`.gathering (id, group_id, name, date, started_at, ended_at, place, photo_url, description, leader_comment, admin_comment, created_at, updated_at, deleted_at) VALUES ('c37c2d6b-5af4-4b45-b146-1d34dda3fe2a', '6f29f33a-3b80-4495-8d08-32fbb5303c82', '25년 07월 2주차', '2025-07-13', '2025-07-13 15:00:00', '2025-07-13 17:00:00', '헤븐 창가방', null, '특이사항 없음', null, null, '2025-07-16 13:15:48', '2025-07-18 13:10:31', null);
INSERT INTO `into-the-heaven`.gathering (id, group_id, name, date, started_at, ended_at, place, photo_url, description, leader_comment, admin_comment, created_at, updated_at, deleted_at) VALUES ('dde003de-49a0-40d4-b928-de9beb35869e', '6f29f33a-3b80-4495-8d08-32fbb5303c82', '25년 07월 3주차', '2025-07-20', '2025-07-20 15:00:00', '2025-07-20 17:00:00', '헤븐 창가방', null, '특이사항 없음', null, null, '2025-07-16 13:17:19', '2025-07-16 13:17:19', null);

# GATHERING_MEMBER
INSERT INTO `into-the-heaven`.gathering_member (id, gathering_id, group_member_id, worship_attendance, gathering_attendance, story, created_at, updated_at, deleted_at) VALUES ('c8453b0e-0bb1-40a8-b107-71e28fbe1267', 'c37c2d6b-5af4-4b45-b146-1d34dda3fe2a', '055522d7-cb9e-497e-a3bc-87ce8cce5cf6', 0, 0, null, '2025-07-16 13:15:48', '2025-07-18 13:10:31', null);
INSERT INTO `into-the-heaven`.gathering_member (id, gathering_id, group_member_id, worship_attendance, gathering_attendance, story, created_at, updated_at, deleted_at) VALUES ('dd9a287e-f77b-4284-a2e5-0ee14ab320ba', 'c37c2d6b-5af4-4b45-b146-1d34dda3fe2a', 'ccf48ed3-fa83-4fb0-9bfd-535334da68f1', 1, 1, '어플만드느라 점심시간에 바빠요.', '2025-07-16 13:15:48', '2025-07-18 13:10:31', null);
INSERT INTO `into-the-heaven`.gathering_member (id, gathering_id, group_member_id, worship_attendance, gathering_attendance, story, created_at, updated_at, deleted_at) VALUES ('e3c6e52b-f4df-492b-aa58-02a815aefb1f', 'c37c2d6b-5af4-4b45-b146-1d34dda3fe2a', '4b1545c5-8795-48d5-a41d-aa7f2b895f97', 0, 0, null, '2025-07-16 13:15:48', '2025-07-18 13:10:31', null);
INSERT INTO `into-the-heaven`.gathering_member (id, gathering_id, group_member_id, worship_attendance, gathering_attendance, story, created_at, updated_at, deleted_at) VALUES ('f4ecd400-0061-49c3-bd64-021160a87d10', 'c37c2d6b-5af4-4b45-b146-1d34dda3fe2a', '79a2823e-0655-4d51-b698-bb771a7003ba', 0, 0, null, '2025-07-16 13:15:48', '2025-07-18 13:10:31', null);

# GROUP
INSERT INTO `into-the-heaven`.`group` (id, church_id, name, description, start_date, end_date, created_at, updated_at, deleted_at) VALUES ('23555b7b-e292-45b5-85c8-3b73ae3eb3ee', '87e613cc-a3ac-4529-84f1-624889f9ee22', '쉐카이나', null, '2025-01-01', '2025-12-31', '2025-07-14 04:04:02', '2025-07-14 04:04:02', null);
INSERT INTO `into-the-heaven`.`group` (id, church_id, name, description, start_date, end_date, created_at, updated_at, deleted_at) VALUES ('6f29f33a-3b80-4495-8d08-32fbb5303c82', '87e613cc-a3ac-4529-84f1-624889f9ee22', '지은셀', null, '2025-01-01', '2025-12-31', '2025-07-14 04:04:02', '2025-07-14 04:04:02', null);

# GROUP_MEMBER
INSERT INTO `into-the-heaven`.group_member (id, group_id, member_id, role, created_at, updated_at, deleted_at) VALUES ('0062541b-7f40-418f-98e0-61b7f90913dd', '23555b7b-e292-45b5-85c8-3b73ae3eb3ee', 'd3713132-c3e0-474b-ad2a-bc7b2292bcaf', 'MEMBER', '2025-07-14 04:05:48', '2025-07-14 04:05:48', null);
INSERT INTO `into-the-heaven`.group_member (id, group_id, member_id, role, created_at, updated_at, deleted_at) VALUES ('055522d7-cb9e-497e-a3bc-87ce8cce5cf6', '6f29f33a-3b80-4495-8d08-32fbb5303c82', 'ce6df3bb-9310-48a5-a6b3-478726cd972f', 'MEMBER', '2025-07-14 04:05:04', '2025-07-14 04:05:04', null);
INSERT INTO `into-the-heaven`.group_member (id, group_id, member_id, role, created_at, updated_at, deleted_at) VALUES ('4b1545c5-8795-48d5-a41d-aa7f2b895f97', '6f29f33a-3b80-4495-8d08-32fbb5303c82', '55eb328f-26da-400d-97e1-817bd101028f', 'LEADER', '2025-07-14 04:05:04', '2025-07-14 04:05:04', null);
INSERT INTO `into-the-heaven`.group_member (id, group_id, member_id, role, created_at, updated_at, deleted_at) VALUES ('79a2823e-0655-4d51-b698-bb771a7003ba', '6f29f33a-3b80-4495-8d08-32fbb5303c82', 'd3713132-c3e0-474b-ad2a-bc7b2292bcaf', 'MEMBER', '2025-07-14 04:05:04', '2025-07-14 04:05:04', null);
INSERT INTO `into-the-heaven`.group_member (id, group_id, member_id, role, created_at, updated_at, deleted_at) VALUES ('a5e0269c-3fed-4132-bd31-6027be494805', '23555b7b-e292-45b5-85c8-3b73ae3eb3ee', '8c3f8354-eb66-4b29-b8d7-e4cfd1f31d3e', 'LEADER', '2025-07-14 04:05:48', '2025-07-14 04:05:48', null);
INSERT INTO `into-the-heaven`.group_member (id, group_id, member_id, role, created_at, updated_at, deleted_at) VALUES ('ae78f2f5-2c78-445f-b4d7-4a1c58b0fd5d', '23555b7b-e292-45b5-85c8-3b73ae3eb3ee', '6f33d359-bc2c-42cd-b875-12937bee989f', 'MEMBER', '2025-07-14 04:05:48', '2025-07-14 04:05:48', null);
INSERT INTO `into-the-heaven`.group_member (id, group_id, member_id, role, created_at, updated_at, deleted_at) VALUES ('bfdf512d-9474-4636-bcf1-c13a65f2229b', '23555b7b-e292-45b5-85c8-3b73ae3eb3ee', 'f135c175-78dc-4046-a478-698786d708c0', 'MEMBER', '2025-07-14 04:05:48', '2025-07-14 04:05:48', null);
INSERT INTO `into-the-heaven`.group_member (id, group_id, member_id, role, created_at, updated_at, deleted_at) VALUES ('ccf48ed3-fa83-4fb0-9bfd-535334da68f1', '6f29f33a-3b80-4495-8d08-32fbb5303c82', '6f33d359-bc2c-42cd-b875-12937bee989f', 'MEMBER', '2025-07-14 04:05:04', '2025-07-14 04:05:04', null);

# MEMBER
INSERT INTO `into-the-heaven`.member (id, name, email, password, sex, birthday, phone, profile_url, address, description, created_at, updated_at, deleted_at) VALUES ('55eb328f-26da-400d-97e1-817bd101028f', '한지은', '[email protected]', '$2a$10$J3KYKsXie3SQfGaZ8zOhbuw4oGJ1RbbDHkx6wvV3wdkuUTHffbFkO', 'F', '2000-01-01', '01012345678', null, null, null, '2025-07-14 13:02:51', '2025-07-14 13:02:51', null);
INSERT INTO `into-the-heaven`.member (id, name, email, password, sex, birthday, phone, profile_url, address, description, created_at, updated_at, deleted_at) VALUES ('6f33d359-bc2c-42cd-b875-12937bee989f', '김창수', '[email protected]', '$2a$10$OguGeeGBH8iTHxW/G8e3neteA9dLY59k.0lL5R7f5m98SaVbUWSKi', 'M', '1991-09-16', '01088831954', null, null, null, '2025-07-14 10:01:36', '2025-07-14 10:01:36', null);
INSERT INTO `into-the-heaven`.member (id, name, email, password, sex, birthday, phone, profile_url, address, description, created_at, updated_at, deleted_at) VALUES ('8c3f8354-eb66-4b29-b8d7-e4cfd1f31d3e', '조민채', '[email protected]', '$2a$10$AJWMQPS7W/A1nI2g1joobOvUaGO7DPTt3cxfFXxgW0pLre6C8iF6m', 'F', '2000-01-01', '01012345678', null, null, null, '2025-07-14 13:02:58', '2025-07-14 13:02:58', null);
INSERT INTO `into-the-heaven`.member (id, name, email, password, sex, birthday, phone, profile_url, address, description, created_at, updated_at, deleted_at) VALUES ('8c476f43-0f18-45f3-ad78-b7e9f8a71974', '박나래', '[email protected]', '$2a$10$Q1wJY5fvEvj3PY9TVQs6sOdemRnA4qD5.wAI5og5Ir8x/eak/S5ni', 'F', '1990-02-01', '01062090667', null, null, null, '2025-07-14 10:01:39', '2025-07-14 10:01:39', null);
INSERT INTO `into-the-heaven`.member (id, name, email, password, sex, birthday, phone, profile_url, address, description, created_at, updated_at, deleted_at) VALUES ('ce6df3bb-9310-48a5-a6b3-478726cd972f', '석지원', '[email protected]', '$2a$10$XDdGxYoFS7iPPPOXGfeSd.heuWYDS8QoTRWRcRl096id0jI8PQHZy', 'F', '2000-01-01', '01012345678', null, null, null, '2025-07-14 13:02:54', '2025-07-14 13:02:54', null);
INSERT INTO `into-the-heaven`.member (id, name, email, password, sex, birthday, phone, profile_url, address, description, created_at, updated_at, deleted_at) VALUES ('d3713132-c3e0-474b-ad2a-bc7b2292bcaf', '이종탄', '[email protected]', '$2a$10$SndidR.vR/aJsFcP8v.y9uD.pwTCU5pOQ.nhWxOQ9QnUtzzPSdzMm', 'M', '2000-01-01', '01012345678', null, null, null, '2025-07-14 13:02:56', '2025-07-14 13:02:56', null);
INSERT INTO `into-the-heaven`.member (id, name, email, password, sex, birthday, phone, profile_url, address, description, created_at, updated_at, deleted_at) VALUES ('f135c175-78dc-4046-a478-698786d708c0', '김홍석', '[email protected]', '$2a$10$JqO3ZglEMaVELveDBus7NeZFU/NQ3lYZgSJ0kDxJM9qqvfuC2094y', 'M', '2000-01-01', '01012345678', null, null, null, '2025-07-14 13:03:00', '2025-07-14 13:03:00', null);

# PRAYER
INSERT INTO `into-the-heaven`.prayer (id, gathering_member_id, member_id, prayer_request, is_answered, description, created_at, updated_at, deleted_at) VALUES ('780dc8ab-c4e2-4d99-b536-ccec7afee41d', 'dd9a287e-f77b-4284-a2e5-0ee14ab320ba', '6f33d359-bc2c-42cd-b875-12937bee989f', '하나님만 의지하게 해주세요.', 0, '세상의 기준에 따라가는 자신을 발견', '2025-07-18 13:10:31', '2025-07-18 13:10:31', null);
INSERT INTO `into-the-heaven`.prayer (id, gathering_member_id, member_id, prayer_request, is_answered, description, created_at, updated_at, deleted_at) VALUES ('ec4143f1-eff9-43c1-ad15-891a5a4509af', 'dd9a287e-f77b-4284-a2e5-0ee14ab320ba', '6f33d359-bc2c-42cd-b875-12937bee989f', '가정의 평화', 0, '항상 그렇듯 가정의 평화를 위하여', '2025-07-18 13:10:31', '2025-07-18 13:10:31', null);

# Query
select g2.name                 as 셀이름,
       g.name                  as 소모임,
       m.name                  as 셀원이름,
       gm.worship_attendance   as 예배참석여부,
       gm.gathering_attendance as 소모임참석여부,
       gm.story                as 특이사항,
       p.prayer_request        as 기도제목,
       p.description           as 기도제목설명
from gathering g
         join gathering_member gm on g.id = gm.gathering_id
         join group_member gm2 on gm.group_member_id = gm2.id
         join member m on gm2.member_id = m.id
         join `group` g2 on gm2.group_id = g2.id
         left join prayer p on gm.id = p.gathering_member_id
where gathering_id = 'c37c2d6b-5af4-4b45-b146-1d34dda3fe2a';