데이터베이스

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
foNaqi4FRmqqrD8iD6.Y1A Yim, Sŭng-rok 임순문 P’yŏngnam w 金順化 Kim, Sun-hwa 김순화 09/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-09-01 1916 9 wife 부인 4110 평안남도 Yim 임 Sŭng-rok 순문 NULL
foDlrDJxSX2i5sNyxvRpEg Kim, Sŏng-ch’un 김성춘 Hwanghae 金成春 김성춘 08/1912 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1912-08-01 1912 8 applicant 신청인 4099 황해도 Kim 김 Sŏng-ch’un 성춘 3nY3f1hKTwWfpXjnW6dGqw
FnSo0VEeRgarXueHfAnT-g Chŏng, Pong-ch’un 정봉춘 Kyŏngsang w 崔於辰 Ch’oe, Ŏ-jin 최어진 08/1914 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1914-08-01 1914 8 wife 부인 4101 경상도 Chŏng 정 Pong-ch’un 봉춘 NULL
FNB-4cegTQC0EZCGcnYDng Ch’oe, Chun-yŏ 최준여 Kyŏngbuk w 文成眞 Mun, Sŏng-jin 문성진 12/1916 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1916-12-01 1916 12 wife 부인 4098 경상북도 Ch’oe 최 Chun-yŏ 준여 NULL
FlNIRlSETDyunZpSeHSl9w O, Ch’un-? 오춘? Hwanghae w 林德順 Yim, Tŏk-sun 임덕순 05/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-05-01 1913 5 wife 부인 4099 황해도 O 오 Ch’un-? 춘? NULL
FJzRFqeuRaSIiy6bqO8Z9Q Kim, Hong-sun 김홍순 P’yŏngbuk w 朴元俊 Pak, Wŏn-jun 박원준 07/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-07-01 1913 7 wife 부인 4112 평안북도 Kim 김 Hong-sun 홍순 NULL
Fji4fhtzRfm03jKK-iLmww Yi, Wŏn-sŏn 이원선 Kyŏnggi w 田末善 Chŏn, Mal-sŏn 田말선 07/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-07-01 1914 7 wife 부인 4097 경기도 Yi 이 Wŏn-sŏn 원선 NULL
fi2Fh.pFR6ya4.U9OQDkpg Song, Hyŏng-baek 송형백 Kyŏngsang w 金福得 Kim, Pok-dŭk 김복득 09/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-09-01 1913 9 wife 부인 4101 경상도 Song 송 Hyŏng-baek 형백 NULL
fGxOAhDaRuG4CehA0nmtpA Han, Il-sŭng 한일승 P’yŏngnam 韓日昇 01/1921 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:47 1921-01-01 1921 1 applicant 신청인 4110 평안남도 Han 한 Il-sŭng 일승 iz31S.3PRpq2AMZ5AK28yA
FGVybB7xRR6drMwcVau0eg Yu, Ch’un-gwan 유춘관 Kyŏnggi w 田壽鄕 Chŏn, Su-hyang 田수향 09/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-09-01 1913 9 wife 부인 4097 경기도 Yu 유 Ch’un-gwan 춘관 NULL
fFwLSCUBTWG7exkvUmFsSg Yi, Chŏm-ung? 이점웅? Kyŏnggi 02/1919 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1919-02-01 1919 2 applicant 신청인 4097 경기도 Yi 이 Chŏm-ung? 점웅? NULL
FfrJQ.QiRvyC-icnoxK1zA Yun, Pong-ju 윤봉주 Hamnam s 尹金釗 Yun, Kŭm-soe 윤금조 09/1912 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1912-09-01 1912 9 son 아들 4103 함경남도 Yun 윤 Pong-ju 봉주 NULL
Ffe.u4Q5QpuQfo6iKe07yQ Song, Sŏk-hwa 송석화 P’yŏngbuk 宋錫化 송석화 12/1917 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-12-01 1917 12 applicant 신청인 4112 평안북도 Song 송 Sŏk-hwa 석화 NULL
FF5ham1VQzabG2eHX5yXfA Kim, Pong-hak 김봉학 P’yŏngnam w 高男伊 Ko, Nam-i 고남이 02/1917 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-02-01 1917 2 wife 부인 4110 평안남도 Kim 김 Pong-hak 봉학 NULL
FEJix5.JQSCDvipc9J631A Pak, Pok-su 박복수 Chŏnnam w 李淑伊 Yi, Suk-i 이숙이 01/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-01-01 1914 1 wife 부인 4102 전라남도 Pak 박 Pok-su 복수 NULL
fEB-GkkeSBW7HMso4jic5A Han, Sŏn-bok 한선복 Ch’ungbuk w 孔於眞 Kong, Ŏ-jin 공지인 03/1916 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1916-03-01 1916 3 wife 부인 938 충청북도 Han 한 Sŏn-bok 선복 NULL
fdvB56YhTjaUhdXTVJxXGw Ch’oe, Sŏn-yŏ 최선여 Kyŏngnam 崔先汝 03/1924 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:47 1924-03-01 1924 3 applicant 신청인 4096 경상남도 Ch’oe 최 Sŏn-yŏ 선여 RGJ5Z6DPQveBVjy0-9BaTA
FDUeaWaXQzq4abz7CUlYEw Kim, Sang-jun 김상준 Kyŏngsang w 成善伊 Sŏng, Sŏn-i 성선이 12/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-12-01 1916 12 wife 부인 4101 경상도 Kim 김 Sang-jun 상준 NULL
fD6weILKT4mzDRqqwIeMLQ Pak, Pong-t’aek 박봉택 Kyŏnggi w 金奎龍 Kim, Kyu-yong 김규용 02/1917 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-02-01 1917 2 wife 부인 4097 경기도 Pak 박 Pong-t’aek 봉택 NULL
fcGA-P4fQ1SK0czGdkdepw Kim, Yŏng-bong 김영봉 Kyŏnggi w 楊氏 Yang 양씨 08/1912 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1912-08-01 1912 8 wife 부인 4097 경기도 Kim 김 Yŏng-bong 영봉 NULL