데이터베이스

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
BMzhocqbRlKr-jCacLa8WA Ch’oe, Sun-i 최순이 Kyŏngnam w 金英乃 Kim, Yŏng-nae 김영내 01/1917 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1917-01-01 1917 1 wife 부인 4096 경상남도 Ch’oe 최 Sun-i 순이 NULL
bMy8lsnYS4CiyNhcv83ykA Yi, To-myŏng 이도명 Kyŏngsang w 金順伊 Kim, Sun-i 김순이 06/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-06-01 1913 6 wife 부인 4101 경상도 Yi 이 To-myŏng 도명 NULL
bMHwByMXSkS-R9VwO.rsbQ Sŏ, Sŏng-baek 서성백 P’yŏngbuk w 金末順 Kim, Mal-sun 김말순 03/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-03-01 1916 3 wife 부인 4112 평안북도 Sŏ 서 Sŏng-baek 성백 NULL
bLxMpnYfQWqAojXbJH1aaQ Kim, Myŏng-sun 김명순 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 김 Myŏng-sun 명순 a.tPiqDkeTfqYNZBy3y.kQA
BKXeiEHETPuTfcMh.H-L0w Ha, Su-il 하수일 Kyŏngnam w 方盡介 Pang, Jin-gae 방진계 06/1916 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1916-06-01 1916 6 wife 부인 4096 경상남도 Ha 하 Su-il 수일 NULL
BK3SZzmLQu-Rgzzgq4psbw Kim, In-sik 김인식 Kyŏngnam w 孫小南 Son, So-nam 손소남 09/1918 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1918-09-01 1918 9 wife 부인 4096 경상남도 Kim 김 In-sik 인식 NULL
BIjA.fh.Ty-i8AwfSQlXPA Sŏnu, Ki-ch’an 선우기찬 P’yŏngan w 劉福男 Yu, Pok-nam 유복남 03/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-03-01 1913 3 wife 부인 4111 평안도 Sŏnu 선 Ki-ch’an 우기찬 NULL
BiDfdnHxThWLB-4ZXf9YQQ Paek, Sŏng-mun 백성문 Kyŏngnam w 裵桂順 Pae, Kye-sun 배계순 09/1920 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1920-09-01 1920 9 wife 부인 4096 경상남도 Paek 백 Sŏng-mun 성문 NULL
bhdHmoGrQHKqkFybYJwRJA Yi, Ki-yŏng 이기영 Inch’ŏn 03/1921 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1921-03-01 1921 3 applicant 신청인 NULL NULL Yi 이 Ki-yŏng 기영 2s.7Ytr1RoKMPrR6d9fOGQ
bGQTnO2CQROxeP2MUsAuNA Son, Chŏng-hyŏn 손정현 P’yŏngnam 孫正玄 손정현 09/1920 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1920-09-01 1920 9 applicant 신청인 4110 평안남도 Son 손 Chŏng-hyŏn 정현 NULL
bgK4bPHZTEyovqRe6XBh0Q Pak, Se-in 박세인 Hwanghae 1s 朴福成 Pak, Pok-sŏng 박복성 10/1915 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-10-01 1915 10 son 아들 4099 황해도 Pak 박 Se-in 세인 NULL
bF2edzGvTq-O55TPcG774A Pak, Man-gil 박만길 Kyŏngnam w 金新連 Kim, Sin-ryŏn 김신련 05/1918 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1918-05-01 1918 5 wife 부인 4096 경상남도 Pak 박 Man-gil 만길 NULL
bEPe9CskSoOX7tLFW4wN1g Chin, Chŏng-bŏm 진정범 Kyŏngnam w 王佳午 Wang, Ka-o 왕가오 02/1919 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1919-02-01 1919 2 wife 부인 4096 경상남도 Chin 진 Chŏng-bŏm 정범 NULL
bEI2SAN2R2qriKhpgFqpvw Pak, Rae-hyŏng 박래형 Kyŏnggi w 趙寬善 Cho, Kwan-sŏn 조관선 02/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-02-01 1914 2 wife 부인 4097 경기도 Pak 박 Rae-hyŏng 래형 NULL
beAWgAynTci2CRodRw8ZLA Hyŏn, Ch’ang-hun 현창훈 P’yŏngnam 玄昌勳 05/1918 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1918-05-01 1918 5 applicant 신청인 4110 평안남도 Hyŏn 현 Ch’ang-hun 창훈 kBNPCYcRSOOqnG37uw4sxQ
BDYcAh3zRfmE6fz80NW7SQ Chŏng, Kuk-hyŏn 정국현 P’yŏngnam w 李鳳島 Yi, Pong-do 이봉도 10/1916 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1916-10-01 1916 10 wife 부인 4110 평안남도 Chŏng 정 Kuk-hyŏn 국현 NULL
BcdCmG7QTga7OvfnpVwcMA Chin, Ch’ang-su 진창수 Kyŏnggi s 陳氏 Chin 진 01/1913 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1913-01-01 1913 1 son 아들 4097 경기도 Chin 진 Ch’ang-su 창수 NULL
bBGIcVJuQPSz-tnasbWCjA Han, Sŏng-bŏm 한성범 Kyŏnggi 韓聖範 12/1914 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1914-12-01 1914 12 applicant 신청인 4097 경기도 Han 한 Sŏng-bŏm 성범 NULL
bbeaeI3HQjmcIMYQRYO6RA Chŏng, Un-gyŏng 정운경 Seoul 鄭雲慶 04/1917 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:47 1917-04-01 1917 4 applicant 신청인 18 서울 Chŏng 정 Un-gyŏng 운경 ipsFK1fMQLm4pC5bkeyCPw
Bb1PCc8KT5CcPpQj90HCkA Kim, Sŏng-gwŏn 김성권 P’yŏngnam w 朴今節 Pak, Kŭm-jŏl 박금절 10/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-10-01 1916 10 wife 부인 4110 평안남도 Kim 김 Sŏng-gwŏn 성권 NULL