데이터베이스

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
6nBg.VIPR1iyZo.LyVVOmA Chang, Pong-hŭi 장봉희 P’yŏngan w 裵明 Pae, Myŏng-dong 배명동 02/1913 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1913-02-01 1913 2 wife 부인 4111 평안도 Chang 장 Pong-hŭi 봉희 NULL
6NAuVdiuSeWAzc4Xn9xkMg Pak, Chong-wŏn 박종원 P’yŏngnam 朴鍾源 박종원 07/1922 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1922-07-01 1922 7 applicant 신청인 4110 평안남도 Pak 박 Chong-wŏn 종원 fVJZ0RB8RYSu9W.DKv7hAw
6lvAYJ6FQCyZG5oThvRHmg Hwang, Ŭi-jung 황의중 Chŏnnam 1d 黃正禮 Hwang, Chŏng-rye 황정례 04/1917 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-04-01 1917 4 daughter 딸 4102 전라남도 Hwang 황 Ŭi-jung 의중 NULL
6kv99fYySGa53FzpnsEHRA Yim, Kwang-muk 임규석 Hwanghae 林光默 임광묵 08/1922 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1922-08-01 1922 8 applicant 신청인 4099 황해도 Yim 임 Kwang-muk 규석 NULL
6gssHfx8RSahFGvA6RuzgA Han, Yŏng-suk 한영숙 Hamnam 韓永淑 09/1922 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1922-09-01 1922 9 applicant 신청인 4103 함경남도 Han 한 Yŏng-suk 영숙 rZM8Kw3BSkqnlQmCml73ZQ
6dU1q8A1Sh2L4sN3wxSkAQ Chin, Tŭk-sŏn 진덕선 Kyŏngnam 陳得善 02/1923 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1923-02-01 1923 2 applicant 신청인 4096 경상남도 Chin 진 Tŭk-sŏn 덕선 NULL
6ckkGaBwSKCNu3P.uiWYFw Kim, Kyŏng-un 김경운 Hwanghae w 趙敬蘭 Cho, Kyŏng-ran 조경란 04/1915 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-04-01 1915 4 wife 부인 4099 황해도 Kim 김 Kyŏng-un 경운 NULL
6CcLT0d8TQuCc8tsPnb4Xg Kim, Un-hak 김운학 Kyŏngnam w 權順任 Kwŏn, Sun-im 권순임 08/1922 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1922-08-01 1922 8 wife 부인 4096 경상남도 Kim 김 Un-hak 운학 NULL
6c7eEWNERtSaeTnYnUFZVA Kil, Ch’an-rok 길찬록 P’yŏngnam w 千年喜 Ch’ŏn, Nyŏn-hŭi 전년희 10/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-10-01 1914 10 wife 부인 4110 평안남도 Kil 길 Ch’an-rok 찬록 NULL
6BzMsXx6QaGGXAimud.o2w No, Hŭi-gyŏm 노희경 Hwanghae w 池英凞 Chi, Yŏng-hŭi 지영희 07/1912 본명은 노희찬, 여권 스펠잉이 오류,지영희의 남편 2025-07-10 00:00:00 jemulpo@cartoonfellow.org 로희창 2025-09-14 05:57:42 2025-12-06 10:59:08 1912-07-01 1912 7 wife 부인 4099 황해도 No 노 Hŭi-gyŏm 희경 NULL
6BhXVacTSC2DVm-895oroA Kim, Kyŏng-sŏ 김경서 Kyŏngbuk w 南文順 Nam, Mun-sun 남문순 01/1917 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-01-01 1917 1 wife 부인 4098 경상북도 Kim 김 Kyŏng-sŏ 경서 NULL
6877ROknTkesVPKghhYFcw Mun, Yong-sŏp 문용섭 Kyŏngnam w 朴爲南 Pak, Wi-nam 박위남 07/1919 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1919-07-01 1919 7 wife 부인 4096 경상남도 Mun 문 Yong-sŏp 용섭 NULL
67ZL7M3LRnaO8BulGjeHTg Kang, Tae-sun 강대순 Kyŏnggi w 權泰安 Kwŏn, T’ae-an 권태안 05/1922 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1922-05-01 1922 5 wife 부인 4097 경기도 Kang 강 Tae-sun 대순 NULL
64zsPnZ4Q.ijWQPq4PMAAA O, Wan-gon 오완곤 Kyŏngnam 吳完坤 오완곤 04/1923 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1923-04-01 1923 4 applicant 신청인 4096 경상남도 O 오 Wan-gon 완곤 NULL
62XjqVcnSeyy9U70Vm3HiA Kang, Sun-man 강순만 Hamnam w 金音田 Kim, Ŭm-jŏn 김음전 07/1917 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-07-01 1917 7 wife 부인 4103 함경남도 Kang 강 Sun-man 순만 NULL
60XljoJUSrmvl-yN1v8QKw U, Chŏng-jo 우정조 Hwanghae w 홍봉련 Hong, Pong-yŏn 홍봉련 06/1913 실제 이름 홍봉윤 2025-03-02 00:00:00 jemulpo@cartoonfellow.org https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/QIghi1eSpJ 우정조 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-06-01 1913 6 wife 부인 4099 황해도 U 우 Chŏng-jo 정조 NULL
5ZS.QAQDQIScSgoH-5LTjA Yu, Ae-ra 유애라 P’yŏngsŏng 兪愛羅 유애라 10/1922 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1922-10-01 1922 10 applicant 신청인 NULL NULL Yu 유 Ae-ra 애라 NULL
5ZM33TPIRpGJ2H5IBH.Z3g Han, Yŏn-sun 한연순 Seoul 韓淵巡 07/1919 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1919-07-01 1919 7 applicant 신청인 18 서울 Han 한 Yŏn-sun 연순 NULL
5yNeD63RTtyMCy3K0Kxyvg Yi, Chu-ji 이주지 Kyŏngnam 08/1920 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1920-08-01 1920 8 applicant 신청인 4096 경상남도 Yi 이 Chu-ji 주지 NULL
5xLWfq7RTCa0aeMtn7fIiA Yun, Pyŏng-hŭi 윤병희 Hamgyŏng d 尹晏娜 Yun, An-na 윤안나 05/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-05-01 1914 5 daughter 딸 4106 함경도 Yun 윤 Pyŏng-hŭi 병희 NULL