데이터베이스

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
lvaoEcFhRY-ifGIB0oEx8g Song, Ch’un-sik 송춘식 Hwanghae 宋春植 송춘식 05/1918 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1918-05-01 1918 5 applicant 신청인 4099 황해도 Song 송 Ch’un-sik 춘식 lrQxJe8RTaO03bfaUkixZQ
LUgtOw4-Qb-uCYJHO.FCwA An, Chae-bong 안재봉 Kangwŏn w 金氏 Kim 김 01/1913 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1913-01-01 1913 1 wife 부인 4100 강원도 An 안 Chae-bong 재봉 NULL
lTYfMY32SBSJchAqRcK.Cg Chi, Sŏng-ch’un 지성춘 Hwanghae 池成春 2/1919 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1919-02-01 1919 2 applicant 신청인 4099 황해도 Chi 지 Sŏng-ch’un 성춘 NULL
lTS7dcHGQ7qCZ70G0JZH6g Son, Tŏk-in 손덕인 P’yŏngnam 孫德仁 손덕인 02/1919 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1919-02-01 1919 2 applicant 신청인 4110 평안남도 Son 손 Tŏk-in 덕인 NULL
lsNlmQuDRr225wvzS.uXbA Han, Kyŏng-sŏn 한경선 Kyŏnggi 韓慶善 01/1921 Re 장남 한영교,1차대전때 전사 2025-03-10 00:00:00 jemulpo@cartoonfellow.org https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/CrpC29ro6Y 2025-09-14 05:57:41 2025-12-06 10:59:47 1921-01-01 1921 1 applicant 신청인 4097 경기도 Han 한 Kyŏng-sŏn 경선 mFhbYnoGREGktSaOCNgfrw
lRjzsXS5TGaiJXO2F37sLQ No, Sŏk-bong 노석봉 Kyŏngnam w 金宗秀 Kim, Chong-su 김종수 10/1918 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1918-10-01 1918 10 wife 부인 4096 경상남도 No 노 Sŏk-bong 석봉 NULL
LQNUA-t1RXiQlinWqFj7lg Kim, Sŏn-nyŏ 김선용 Kyŏnggi 金善勇 김선용 07/1914 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-07-01 1914 7 applicant 신청인 4097 경기도 Kim 김 Sŏn-nyŏ 선용 NULL
lQFVsSoBQhOTjtE-zJrFHA Sŏ, U-il 서우일 Kyŏngnam w 金在善 Kim, Chae-sŏn 김재선 04/1922 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1922-04-01 1922 4 wife 부인 4096 경상남도 Sŏ 서 U-il 우일 NULL
lPYtNSWYSnWQOasSQZj8og Sim, Ŭn-baek 심은백 Kyŏngbuk 沈殷伯 심은백 11/1917 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-11-01 1917 11 applicant 신청인 4098 경상북도 Sim 심 Ŭn-baek 은백 NULL
lpfOqTqHRv-FYiG-EjINzg Yun, Ki-bŏp 윤조법 Kangwŏn 尹磯法 윤지법 06/1915 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-06-01 1915 6 applicant 신청인 4100 강원도 Yun 윤 Ki-bŏp 조법 NULL
LotTw5KJSfG3ICMZ2Or8KA Yi, O-wŏn 이오원 Kyŏngbuk w 金命南 Kim, Myŏng-nam 김명남 11/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-11-01 1916 11 wife 부인 4098 경상북도 Yi 이 O-wŏn 오원 NULL
LoQ7UYEsSqCmOmWF4CWepQ Pak, Kwan-du 박관두 P’yŏngnam 朴寬斗 박관두 02/1923 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1923-02-01 1923 2 applicant 신청인 4110 평안남도 Pak 박 Kwan-du 관두 NULL
lNZl2KITSyudjENufOPNiw Yu, Mun-ch’an 유문찬 Kyŏngnam 兪文贊 유문찬 03/1916 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1916-03-01 1916 3 applicant 신청인 4096 경상남도 Yu 유 Mun-ch’an 문찬 7P.3ADnaSYeW2cW9nGHPrw
lNTBqKPdRha3Pob3HWNeMA Kim, Ch’ul-sun 김철순 Chŏnnam w 采順伊 Ch’ae, Sun-i 채순이 02/1915 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-02-01 1915 2 wife 부인 4102 전라남도 Kim 김 Ch’ul-sun 철순 NULL
lMQahpalRbalGJwvy0JNKA Ch’oe, Po-ra 최보라 Hwanghae 崔保羅 02/1919 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1919-02-01 1919 2 applicant 신청인 4099 황해도 Ch’oe 최 Po-ra 보라 NULL
lLi1TT0oSAGOVInz3.a53A Pak, Rae-sŏn 박래선 Hwanghae 朴來善 박래선 03/1919 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1919-03-01 1919 3 applicant 신청인 4099 황해도 Pak 박 Rae-sŏn 래선 NULL
lLBMXPw6R2Gt0Z5.WeanaA Kim, Chae-uk 김재욱 P’yŏngnam w 金性義 Kim, Sŏng-ŭi 김성의 05/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-05-01 1914 5 wife 부인 4110 평안남도 Kim 김 Chae-uk 재욱 NULL
lKKGy-APRTK7.yKG-Bjf0Q Yi, Ho-guk 이호국 P’yŏngan w 金宗禮 Kim, Chong-rye 김종례 08/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-08-01 1914 8 wife 부인 4111 평안도 Yi 이 Ho-guk 호국 NULL
LKBGumTrQky-UOwSGoljig Ch’oe, Pyŏng-suk 최병숙 Kyŏngnam 崔柄淑 10/1917 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1917-10-01 1917 10 applicant 신청인 4096 경상남도 Ch’oe 최 Pyŏng-suk 병숙 NULL
lJmaTrquRVuu9CKDZiW02w Sŏ, Kuk-hyŏn 서국현 Kyŏngnam 徐國鉉 서국현 03/1921 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1921-03-01 1921 3 applicant 신청인 4096 경상남도 Sŏ 서 Kuk-hyŏn 국현 NULL