데이터베이스

K이민사 아카이브

archive_picturebrides

사진신부 · 1,933개 행 · 33개 컬럼

새 레코드 CRUD 관리

컬럼 구조

id varchar(50) passport_applicant varchar(200) korean_name varchar(100) residence varchar(200) relation varchar(50) companion_chinese_name varchar(100) passport_name varchar(200) companion_korean_name varchar(100) date_issued varchar(50) note text additional_memo text auto_update_date datetime auto_last_editor varchar(100) image_passport_owner varchar(500) image_passport_companion varchar(500) image_reference varchar(500) tag_first varchar(100) tag_second varchar(100) tag_third varchar(100) created_at timestamp updated_at timestamp date_issued_parsed date issue_year int issue_month int relation_type varchar(20) relation_korean varchar(20) place_id int residence_korean varchar(100) surname_english varchar(50) surname_korean varchar(20) given_name_english varchar(100) given_name_korean varchar(50) ship_person_id varchar(50)
id passport_applicant korean_name residence relation companion_chinese_name passport_name companion_korean_name date_issued note additional_memo auto_update_date auto_last_editor image_passport_owner image_passport_companion image_reference tag_first tag_second tag_third created_at updated_at date_issued_parsed issue_year issue_month relation_type relation_korean place_id residence_korean surname_english surname_korean given_name_english given_name_korean ship_person_id
19LgTwa7TTClnvjJZMX6fQ Han, Ch’i-bin 한치빈 P’yŏngnam w 李末淑 Yi, Mal-suk 이말숙 07/1915 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1915-07-01 1915 7 wife 부인 4110 평안남도 Han 한 Ch’i-bin 치빈 NULL
18cI7PvGTMWVeGhBjMa5Tg Song, Chin-hŏn 송진헌 Seoul 宋晋憲 송진헌 01/1915 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-01-01 1915 1 applicant 신청인 18 서울 Song 송 Chin-hŏn 진헌 NULL
14mAQwunQ-SHnWoElwNfvw Chang, Ŭng-o 장의오 Kyŏngbuk 05/1918 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1918-05-01 1918 5 applicant 신청인 4098 경상북도 Chang 장 Ŭng-o 의오 NULL
11HuMH3QTk2m59qLFQqqlg Yi, Hŭi-gyŏng 이희일 P’yŏngnam w 洪ポプ Hong Po-ra 홍포프 10/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-10-01 1916 10 wife 부인 4110 평안남도 Yi 이 Hŭi-gyŏng 희일 NULL
1-uDxsa-S6OwLbVO3RQzjA Pak, Chong-un 박종운 Kyŏnggi w 李義在 Yi, Ŭi-jae 이의재 09/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-09-01 1913 9 wife 부인 4097 경기도 Pak 박 Chong-un 종운 NULL
0zJN3PZ-QPqkRL3o27v0.A Kim, Yong-sŏk 김용석 P’yŏngnam w 金右蓮 Kim, U-ryŏn 김우련 01/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-01-01 1914 1 wife 부인 4110 평안남도 Kim 김 Yong-sŏk 용석 NULL
0YN-hsUlSnOmQKXG-i5-1A Yun, Tu-hwan 윤두환 Kyŏnggi w 洪玉子 Hong, Ok-ja 홍옥자 02/1917 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-02-01 1917 2 wife 부인 4097 경기도 Yun 윤 Tu-hwan 두환 NULL
0yJZHSP5TOKjDVoGZ59Igg Kim, Kwan-do 김관도 Hamnam 金寬道 10/1920 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1920-10-01 1920 10 applicant 신청인 4103 함경남도 Kim 김 Kwan-do 관도 ThKYxZN1Ta66JUU6JYi9-Q
0XlBmJ.HShGvTbu.sM3zNA Kim, Kwang-sŏn 김광선 Kyŏngnam 金廣善 06/1923 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1923-06-01 1923 6 applicant 신청인 4096 경상남도 Kim 김 Kwang-sŏn 광선 4Sm0OcOrSMe07cuG0.u-Rg
0SACO3CqSou3FtzBiVl6pg Ch’oe, Ch’ŏn-kwi 조천기 Kyŏnggi w 金馬利亞 Kim, Maria 김조매리 04/1912 여권기록오기,1916년 사망 2025-03-28 00:00:00 jemulpo@cartoonfellow.org https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/8t3u2idaLo 조천기 2025-09-14 05:57:41 2025-12-06 10:59:08 1912-04-01 1912 4 wife 부인 4097 경기도 Ch’oe 조 Ch’ŏn-kwi 천기 NULL
0Rv3kzHWQIOjVzreZFkVKw Hwang, Yun-jik 황윤직 Hamgyŏng w 趙敬愛 Cho, Kyŏng-ae 조경애 07/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-07-01 1913 7 wife 부인 4106 함경도 Hwang 황 Yun-jik 윤직 NULL
0PwNKZhCRpy2bWrymGcoUA Mun, Yong-yŏn 문용연 P’yŏngnam 文龍淵 문용연 06/1921 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1921-06-01 1921 6 applicant 신청인 4110 평안남도 Mun 문 Yong-yŏn 용연 NULL
0pfUIOptSYm9hVv2WUoMzw Han, Hak-sin 한학신 Kyŏnggi w 李明念 Yi, Myŏng-nyŏm 이명념 11/1915 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1915-11-01 1915 11 wife 부인 4097 경기도 Han 한 Hak-sin 학신 NULL
0Pf320W7QxqWk9Fy6gQJXQ Yang, Sŏng-hak 양성학 Hamnam w 金守然 Kim, Su-yŏn 김수연 06/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-06-01 1916 6 wife 부인 4103 함경남도 Yang 양 Sŏng-hak 성학 NULL
0NFGjA8RRK-qDOmoBq19MQ Song, Chin-hong 송진홍 Hwanghae w 金弼順 Kim, P’il-sun 김필순 04/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-04-01 1914 4 wife 부인 4099 황해도 Song 송 Chin-hong 진홍 NULL
0nfDh.BnR26gXjeB.9CH7Q Kim, Wŏn-sŏ 김원서 Kyŏngsang w 金於晋 Kim, Ŏ-jin 김어진 08/1915 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-08-01 1915 8 wife 부인 4101 경상도 Kim 김 Wŏn-sŏ 원서 NULL
0LQBi.QgQkeSIhSHn6GltA Yun, Ki-bŏp 윤조법 Kangwŏn w 許氏 Hŏ 허씨 10/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-10-01 1914 10 wife 부인 4100 강원도 Yun 윤 Ki-bŏp 조법 NULL
0Lp6RitTT3uNtKEoWB0JVg Kim, Ae-hong 김애홍 Kyŏngnam 金愛洪 04/1922 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1922-04-01 1922 4 applicant 신청인 4096 경상남도 Kim 김 Ae-hong 애홍 NULL
0LOG.HdHRMahHNskW2YLBg Pak, Pong-jo 박봉조 Kyŏngnam 朱末順 Chu, Mal-sun 주말순 06/1920 NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1920-06-01 1920 6 applicant 신청인 4096 경상남도 Pak 박 Pong-jo 봉조 smn35Qp6ShisanyG5.zoRA
0lcJaWn.RcWVK.KsxeFAXA O, Yong-un 오용운 P’yŏngnam w 劉昌善 Yu, Ch’ang-sŏn 유창선 12/1920 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1920-12-01 1920 12 wife 부인 4110 평안남도 O 오 Yong-un 용운 NULL