데이터베이스

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
grsxH0CWSzmY6yOVmH6g0Q Min, Ŭi-kyŏng 민의경 Kyŏnggi w 梁? 惠 Yang, ?-hye 梁?惠 08/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-08-01 1913 8 wife 부인 4097 경기도 Min 민 Ŭi-kyŏng 의경 NULL
GRKi-2aBQAOkwUMQIoA3Sw Kim, P’il-sŏ 김필서 Ch’ungch’ŏng w 田溶 Chŏn, Yong-san 田용 09/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-09-01 1913 9 wife 부인 4114 충청도 Kim 김 P’il-sŏ 필서 NULL
GqVWInakSIeKmy2s1v0PWQ Pyŏn, Ch’o-sŏng 변초성 Kyŏngnam w 盧貞玉 No, Chŏng-ok 노정옥 04/1920 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1920-04-01 1920 4 wife 부인 4096 경상남도 Pyŏn 변 Ch’o-sŏng 초성 NULL
gPpV1bAcQguI51r.70oCHw Kim, Sŏng-yun 김성윤 Kyŏnggi d 金氏 Kim 김씨 01/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-01-01 1913 1 daughter 딸 4097 경기도 Kim 김 Sŏng-yun 성윤 NULL
gpPsuKCyS3WH8VZ-mZ.DCQ Kang, Sang-baek 강상백 Hwanghae 姜相白 07/1915 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-07-01 1915 7 applicant 신청인 4099 황해도 Kang 강 Sang-baek 상백 NULL
Gp9Xa4QaR06-01ahHwiBoQ Yi, U-jong 이우종 Seoul 1s 李圭東 Yi, Kyu-dong 이규동 12/1917 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-12-01 1917 12 son 아들 18 서울 Yi 이 U-jong 우종 NULL
gOoUSnfGRQ-BJNhhd4cNIw Hwang, Yong-dŏk 황용덕 Kyŏngnam w 李順伊 Yi, Sun-i 이순이 08/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-08-01 1916 8 wife 부인 4096 경상남도 Hwang 황 Yong-dŏk 용덕 NULL
gNfl45vWSxyPX9dMKZ95Bg Chŏn, Kyŏng-ŏk 전경억 Kyŏngnam w 秋福金 Ch’u, Pok-gŭm 추복금 09/1923 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1923-09-01 1923 9 wife 부인 4096 경상남도 Chŏn 전 Kyŏng-ŏk 경억 NULL
GMy3.mEaTnuNksTOYyBo8Q Chŏn, Kyŏng-jun 전경준 Kyŏngnam w 廉鳳善 Yŏm, Pong-sŏn 염봉선 02/1914 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1914-02-01 1914 2 wife 부인 4096 경상남도 Chŏn 전 Kyŏng-jun 경준 NULL
GMPwPR3zQaS7daIraGtvsA Yi, Kŭn-bok 이근복 Kyŏnggi w 金必順 Kim, P’il-sun 김필순 03/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-03-01 1916 3 wife 부인 4097 경기도 Yi 이 Kŭn-bok 근복 NULL
gmGpGrBeRCGFQ9y3DvsNiA Son, Tŏk-sin 손덕신 P’yŏngnam 孫德信 손덕신 02/1919 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1919-02-01 1919 2 applicant 신청인 4110 평안남도 Son 손 Tŏk-sin 덕신 kSxwQU.cRdWLI-p7kdsRbw
GM50gcKRR9ipXPykHlmtlQ Kim, Ŭng-gu 김응구 Kyŏnggi 金應九 김응구 01/1922 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1922-01-01 1922 1 applicant 신청인 4097 경기도 Kim 김 Ŭng-gu 응구 0dfXmJWSQ.uycZ6RDbmP6g
glxI9.IITGmWd7JUrKI9cw Kim, Hak-do 김학도 Kyŏngnam w 李賢卿 Yi, Hyŏn-gyŏng 이현경 08/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-08-01 1913 8 wife 부인 4096 경상남도 Kim 김 Hak-do 학도 NULL
gLFAYIYPTHq16wwIEjhXIw Sŏ, Kuk-hyŏn 서국현 Ch’ungch ng w 李福守 Yi, Pok-su 이복수 05/1917 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-05-01 1917 5 wife 부인 4114 충청도 Sŏ 서 Kuk-hyŏn 국현 NULL
gkuNn9LbRm-x1iRCCV7gDg Ch’oe, Sŏng-mun 최성문 Kangwŏn w 王妙蓮 Wang, Myo-ryŏn 왕묘련 10/1916 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1916-10-01 1916 10 wife 부인 4100 강원도 Ch’oe 최 Sŏng-mun 성문 NULL
gKJN754TQsCRXBrlx7DU2w Chŏng, Ae-yŏng 정애영 P’yŏngnam 鄭愛榮 03/1918 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1918-03-01 1918 3 applicant 신청인 4110 평안남도 Chŏng 정 Ae-yŏng 애영 NULL
gK3EO.HQRC6qYrBaPDCT2w Yi, Chŏng-man 이정만 Hamnam s 李正萬 Yi, Paek-bong 이백봉 03/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-03-01 1914 3 son 아들 4103 함경남도 Yi 이 Chŏng-man 정만 NULL
gJot5rA3SWmOW4PP3Qmzbg An, Wŏn-gyu 안원규 Kyŏnggi w 李正聖 Yi, Chŏng-sŏng 이정송 06/1918 2025-04-21 00:00:00 portlet@daum.net 이정성 안원규 2025-09-14 05:57:41 2025-12-06 10:59:08 1918-06-01 1918 6 wife 부인 4097 경기도 An 안 Wŏn-gyu 원규 NULL
GjHKQ78HStGymyTII3Dhrw Pak, Hyo-byŏng 박효병 P’yŏngnam w 金淑勇 Kim, Suk-nyŏ 김숙용 03/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-03-01 1916 3 wife 부인 4110 평안남도 Pak 박 Hyo-byŏng 효병 NULL
GIBS4KxXS4-JEiOLIF.SvQ Pak, Yang-suk 박양숙 Kyŏngnam 朴楊淑 박양숙 03/1916 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-03-01 1916 3 applicant 신청인 4096 경상남도 Pak 박 Yang-suk 양숙 NULL