데이터베이스

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
dmHW760tS52r9os6Tn-tqQ Kim, Hong-jŭk 김홍즉 Kyŏnggi w 鄭末男 Chŏng, Mal-nam 정말남 11/1915 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-11-01 1915 11 wife 부인 4097 경기도 Kim 김 Hong-jŭk 홍즉 NULL
DmEJvp6rQx2wd.LBvQeY8w Kim, Nŭng-yŏn 김능연 P’yŏnbuk w 崔三仙 Ch’oe, Sam-sŏn 최삼선 10/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-10-01 1913 10 wife 부인 4112 평안북도 Kim 김 Nŭng-yŏn 능연 NULL
dMDnu6k8RhCkyvIYEWVIBQ Pae, Kun-wŏn 배군원 Kyŏngbuk 3d 趙新浩 Cho, Sin-ho 조신호 02/1915 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-02-01 1915 2 daughter 셋째딸 4098 경상북도 Pae 배 Kun-wŏn 군원 NULL
dm-gxIb1RIiLZtLtA-EUuQ Song, Chae-sik 송재식 Seoul 宋在息 송재식 09/1921 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1921-09-01 1921 9 applicant 신청인 18 서울 Song 송 Chae-sik 재식 NULL
DLg6dCSGTu6xeE0JlsaVDQ Chŏng, Ki-un 정기운 Kangwŏn 1s 鄭長孫 Chŏng, Chang-son 정창선 06/1916 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1916-06-01 1916 6 son 아들 4100 강원도 Chŏng 정 Ki-un 기운 NULL
DK-xiHmoTB-AQj3VURKkSw Nam, Kyŏng-sik 남경식 Kyŏngnam w 李仁玉 Yi, In-ok 이인옥 10/1915 2025-03-02 00:00:00 jemulpo@cartoonfellow.org https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/zMlFsMEqSJ 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-10-01 1915 10 wife 부인 4096 경상남도 Nam 남 Kyŏng-sik 경식 NULL
DjoNrRgQT--geq8Sdx1g1w Kim, ?-sŏn 김?선 Kyŏngbuk w 楊南守 Yang, Nam-su 양남수 11/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-11-01 1916 11 wife 부인 4098 경상북도 Kim 김 ?-sŏn ?선 NULL
dIXYc6bQQIuvLMPvYsCMZg Kim, Ch’i-ok 김치옥 Chŏnnam w 崔三仙 Ch’oe, Sam-sŏn 최삼선 03/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-03-01 1914 3 wife 부인 4102 전라남도 Kim 김 Ch’i-ok 치옥 NULL
diqqrUP6SeyCUwG0xORkHw Kim, Tŏk-gi 김덕기 Kyŏnggi 金德基 김덕기 07/1923 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1923-07-01 1923 7 applicant 신청인 4097 경기도 Kim 김 Tŏk-gi 덕기 NULL
dHyfmy5URhu-0Gem5-DITg O, Kuk-Yŏng 오국영 P’yŏngan w 李斗喜 Yi, Tu-hŭi 이두희 01/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-01-01 1913 1 wife 부인 4111 평안도 O 오 Kuk-Yŏng 국영 NULL
dhiO3LihSmC1H6nQT7IXiQ Yi, Wŏn-sŏp 이원섭 Kyŏnggi w 盧元淑 No, Wŏn-suk 노원숙 07/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-07-01 1916 7 wife 부인 4097 경기도 Yi 이 Wŏn-sŏp 원섭 NULL
DgsjyPI4TeaUrDLvSE6-Qg Chŏng, Chi-yŏng 정지영 Hwanghae w 金磐石 Kim, Pan-sŏk 김판석 06/1914 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1914-06-01 1914 6 wife 부인 4099 황해도 Chŏng 정 Chi-yŏng 지영 NULL
Dgm6c64pTVqyzAr2b5fbkA Yi, Yŏng-sik 이영식 Kyŏngbuk w 鄭鳳是 Chŏng, Pong-si 정봉시 01/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-01-01 1914 1 wife 부인 4098 경상북도 Yi 이 Yŏng-sik 영식 NULL
dfSSlgElTIaB6w22e5wO8A Yi, Paek-yong 이백용 P’yŏngnam w 尹明愛 Yun, Myŏng-ae 윤명애 10/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-10-01 1916 10 wife 부인 4110 평안남도 Yi 이 Paek-yong 백용 NULL
dfnIUE8mRiiNeJS721UpmA Chŏng, Kwang-myŏng 정광명 Kyŏngnam w 金必順 Kim, P’il-sun 김필순 09/1918 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1918-09-01 1918 9 wife 부인 4096 경상남도 Chŏng 정 Kwang-myŏng 광명 NULL
dFcac5j7RzOiyCnEZjASew Paek, Yŏ-mun 백여문 P’yŏngan d 白允信 Paek, Yun-sin 백윤신 03/1913 2913.11.26 국민보에 언급 2025-04-14 00:00:00 jemulpo@cartoonfellow.org 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-03-01 1913 3 daughter 딸 4111 평안도 Paek 백 Yŏ-mun 여문 NULL
DFbzQ-w0SUC4m-tk6nAZpA Chŏn, Chong-sun 전종순 Hwanghae w 金 ? Kim 김 11/1916 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1916-11-01 1916 11 wife 부인 4099 황해도 Chŏn 전 Chong-sun 종순 NULL
dEuhvlA4SzmRxdZ6kgYsKw Yun, Sŏp 윤섭 Chŏlla w 朴鳳喜 Pak, Pong-hŭi 박봉희 05/1915 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-05-01 1915 5 wife 부인 4104 전라도 Yun 윤 Sŏp 섭 NULL
DEOzP-f8QpClb330ZQ1g9A Pak, Kyŏng-il 박경일 Seoul w 宋明子 Song, Myŏng-ja 송명자 10/1919 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1919-10-01 1919 10 wife 부인 18 서울 Pak 박 Kyŏng-il 경일 NULL
DeLJ1YmURlKP7wtz5kaRTg Kim, Kuk-sŏn 김국선 Kyŏngsang 金國善 09/1917 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1917-09-01 1917 9 applicant 신청인 4101 경상도 Kim 김 Kuk-sŏn 국선 ZXqXwrStRym2kSJSLViR9w