데이터베이스

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
JakJMpQ-QI6uar.T5bU7ow No, Chung-hyŏn 노중현 P’yŏngnam w 金慶福 Kim, Kyŏng-bok 김경복 08/1922 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1922-08-01 1922 8 wife 부인 4110 평안남도 No 노 Chung-hyŏn 중현 NULL
jaIbAH3ATByG8X4PiS.oTA An, Yŏng-ch’an 안영찬 P’yŏngan w 徐庚林 Sŏ, Kyŏng-rim 서경림 06/1913 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1913-06-01 1913 6 wife 부인 4111 평안도 An 안 Yŏng-ch’an 영찬 NULL
jabpzEbMTSefkii2HTSFIA Chin, Yŏng-sŏp 진영섭 Kyŏngnam 陳英燮 06/1922 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1922-06-01 1922 6 applicant 신청인 4096 경상남도 Chin 진 Yŏng-sŏp 영섭 NULL
J9orTacsRBmgZ3x39P5amA Pak, T’ae-gyun 박태균 Kyŏngnam w 金末順 Kim, Mal-sun 김말순 08/1923 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1923-08-01 1923 8 wife 부인 4096 경상남도 Pak 박 T’ae-gyun 태균 NULL
J9eAfidyQCadPheMz7jI7Q Yu, Kwang-ch’un 유광춘 Hwanghae 柳光春 유광춘 12/1914 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1914-12-01 1914 12 applicant 신청인 4099 황해도 Yu 유 Kwang-ch’un 광춘 DFu8R6JrTnyuqqepEHPLhg
J8gHx-GkSyyrivDi75etVw Kim, Paek-hwa 김백화 Kyŏnggi w 林小斤 Yim, So-gŭn 임소금 09/1917 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-09-01 1917 9 wife 부인 4097 경기도 Kim 김 Paek-hwa 백화 NULL
J8ghuDfGSEWffJduFM3gvw Kong, Ch’i-ro 공치로 Kyŏngnam w 玉金子 Ok, Kŭm-ja 옥금자 12/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-12-01 1913 12 wife 부인 4096 경상남도 Kong 공 Ch’i-ro 치로 NULL
j7QaTqUeTsuZh92aBXcYAw Pak, Yŏng-sil 박영실 Hamgyŏng 1s 朴基順 Pak, Ki-sun 박기순 03/1917 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-03-01 1917 3 son 아들 4106 함경도 Pak 박 Yŏng-sil 영실 NULL
j6TUa3YGRF-MVPHu1UHKHQ Yi, T’ae-jun 이태준 Kyŏnggi w 申桂春 Sin, Kye-ch’un 신계춘 09/1918 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1918-09-01 1918 9 wife 부인 4097 경기도 Yi 이 T’ae-jun 태준 NULL
J6fi32voRVK3Bw4VCxU21g Kim, Ch’un-hwa 김춘화 Kangwŏn 金春化 05/1921 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1921-05-01 1921 5 applicant 신청인 4100 강원도 Kim 김 Ch’un-hwa 춘화 CaEhlx-AS3CmPcXD.5xX7Q
J6.U1TadQsOVkcu.PGGYOA Ch’oe, Chun-yŏ 최준여 Kyŏngbuk daughter 張秀女 Chang, Su-nyŏ 장수녀 09/1914 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1914-09-01 1914 9 daughter 딸 4098 경상북도 Ch’oe 최 Chun-yŏ 준여 NULL
j5MI1r4EQUyYeONSeY-GOA Pak, Yang-u 박양우 Kyŏngnam w 張奉連 Chang, Pong-ryŏn 장봉련 07/1921 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1921-07-01 1921 7 wife 부인 4096 경상남도 Pak 박 Yang-u 양우 NULL
j4yFAojqSgmBJleh0uL0hQ No, Pong-u 노봉우 Kyŏngsang w 尹善義 Yun, Sŏn-ŭi 윤선의 05/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-05-01 1913 5 wife 부인 4101 경상도 No 노 Pong-u 봉우 NULL
J4ldX6YIROKN7DyNQp4c4A Yu, Sang-ho 유상련 Kyŏngnam w 李水命 Yi, Su-myŏng 이수명 08/1919 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1919-08-01 1919 8 wife 부인 4096 경상남도 Yu 유 Sang-ho 상련 NULL
j45CydCvQ.SozwmZZszqTQ Pak, In-su 박인소 Hamgyŏng 2s 金正煥 Kim, Chŏng-hwan 김정환 08/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-08-01 1914 8 son 둘째아들 4106 함경도 Pak 박 In-su 인소 NULL
j3RsRvWmR2mr3JeTJ9fXxQ Han, Sa-yong 한사용 Kyŏnggi 1s 韓巨福 Han, Kŏ-bok 한거복 12/1916 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1916-12-01 1916 12 son 아들 4097 경기도 Han 한 Sa-yong 사용 NULL
j34ja.Q7RZeI.W9cC5gpkQ Kim, Pong-gil 김봉길 Kyŏngnam w 李月伊 Yi, Wŏl-i 이월이 12/1918 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1918-12-01 1918 12 wife 부인 4096 경상남도 Kim 김 Pong-gil 봉길 NULL
j2nbTWflQ9y4C.8TIdZAkA Kim, Sŏk-gŭn 김석근 Kyŏngnam w 李念淑 Yi, Nyŏm-suk 이념숙 06/1922 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1922-06-01 1922 6 wife 부인 4096 경상남도 Kim 김 Sŏk-gŭn 석근 NULL
j0gp-orIS5GofObEXzfFBw ?, Ch’un-hwa 춘화 Hwanghae wife 黃敬 Hwang, Kyŏng 황경 07/1913 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1913-07-01 1913 7 wife 부인 4099 황해도 ? 춘 Ch’un-hwa 화 NULL
J09vnpSfS72wDJcXTWncCw Pak, Yu-gŭn 박유근 Chŏnnam w 金今伊 Kim, Kŭm-i 김금이 01/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-01-01 1913 1 wife 부인 4102 전라남도 Pak 박 Yu-gŭn 유근 NULL