데이터베이스

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
mkhmuFysQp-KeoFaOEndkw An, Chae-sik 안재식 Kyŏnggi 12/1921 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1921-12-01 1921 12 applicant 신청인 4097 경기도 An 안 Chae-sik 재식 NULL
mkdEANj.QqmMuEugb.t0sQ Chŏng, To-wŏn 정도원 Hwanghae 2d 鄭墨蟾 Chŏng, Muk-sŏm 정묵섬 11/1914 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1914-11-01 1914 11 daughter 둘째딸 4099 황해도 Chŏng 정 To-wŏn 도원 NULL
MJy4b4iJTTuips.cdxTBBA Kim, In-guk 김인국 P’yŏngnam w 孫德蓮 Son, Tŏk-ryŏn 손덕련 03/1917 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-03-01 1917 3 wife 부인 4110 평안남도 Kim 김 In-guk 인국 NULL
mJSG43cRSVmDWwSoPtHfNg Kang, Chin-guk 강진국 P’yŏngbuk 康鎭國 08/1915 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1915-08-01 1915 8 applicant 신청인 4112 평안북도 Kang 강 Chin-guk 진국 F7vHSSgYTlu5B7MVCEbDpg
mizFoS9vQ5iWFJYacxRV.g Pak, Mun-bŏm 박문범 Pusan 朴文範 박문범 01/1922 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1922-01-01 1922 1 applicant 신청인 4108 부산 Pak 박 Mun-bŏm 문범 NULL
mICFzaefQga.m3RQxYbOCA Ch’oe, Un-sŏn 최운선 Chŏnnam w 劉福得 Yu, Pok-dŭk 07/1915 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1915-07-01 1915 7 wife 부인 4102 전라남도 Ch’oe 최 Un-sŏn 운선 NULL
MHZpO5LWRy660uAsU.27Mw Chŏng, Nok-su 정록수 Seoul 鄭錄壽 07/1917 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1917-07-01 1917 7 applicant 신청인 18 서울 Chŏng 정 Nok-su 록수 NULL
mhwQJWtmSeiEbhpkRWV8vg Yim, Se-sŏng 임세성 Kangwŏn m 金氏 Kim 김씨 04/1912 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1912-04-01 1912 4 mother 어머니 4100 강원도 Yim 임 Se-sŏng 세성 NULL
MhdOPm8IRy2NYFlA2h7lSQ Yi, Yong-in 이용인 P’yŏngnam w 金貞淑 Kim, Chŏng-suk 김정숙 08/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-08-01 1916 8 wife 부인 4110 평안남도 Yi 이 Yong-in 용인 NULL
mh6d-ouySxSVqdmwsvHkfA Pak, Yu-gŭn 박유근 Chŏnnam w 吳淑伊 O, 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 박 Yu-gŭn 유근 NULL
mGtalV3XRHScFzMU4ANsdg Cho, Sŏk-jin 조석진 康泳福 Kang, Yŏng-bok 강영복 09/1912 NULL 2025-09-14 05:57:41 2025-12-06 10:59:47 1912-09-01 1912 9 applicant 신청인 NULL NULL Cho 조 Sŏk-jin 석진 a-fbdpAIhThiNGsJq10-l6g
mGgpkVf0SM2ApG9SDkoTWQ Pak, Pok-su 박복수 Kyŏnggi w 金又順 Kim, U-sun 김우순 09/1917 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-09-01 1917 9 wife 부인 4097 경기도 Pak 박 Pok-su 복수 NULL
mgdVREeNSpKQN50svomKVA Hwang, Tae-nam 황대남 Kyŏnggi w 姜鳳熙 Kang, Pong-hŭi 강봉희 10/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-10-01 1913 10 wife 부인 4097 경기도 Hwang 황 Tae-nam 대남 NULL
mg6L7IxLRoqvX6.O44ApFQ Kim, Pong-su 김봉수 Ch’ungch’ŏng w 崔順伊 Ch’oe, Sun-i 최순이 05/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-05-01 1913 5 wife 부인 4114 충청도 Kim 김 Pong-su 봉수 NULL
mFnWXbUgQlu-mIl.Q.IWBw Pak, Ŭi-gŭn 박의근 Kyŏngnam 朴宜根 박이근 10/1913 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1913-10-01 1913 10 applicant 신청인 4096 경상남도 Pak 박 Ŭi-gŭn 의근 f-kY65UWS7-86JPBNZWRRA
Mf9DM4sbSy29O9.pvN8YGw Ŏm, Si-an 엄시문 Kyŏngnam w 金順年 Kim, Sun-nyŏn 김순년 03/1918 2025-07-13 00:00:00 portlet@daum.net 엄시문,김순연,김순년 2025-09-14 05:57:42 2025-12-06 10:59:08 1918-03-01 1918 3 wife 부인 4096 경상남도 Ŏm 엄 Si-an 시문 NULL
Mf7YwmMZQjewNAb6sPiUoQ Kim, Tal-sam 김달삼 P’yŏngnam w 李氏 Yi 이씨 01/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-01-01 1913 1 wife 부인 4110 평안남도 Kim 김 Tal-sam 달삼 NULL
mElquE9RTqevq6HKuJNZyQ Ch’oe, Se-yŏng 최세영 Hwanghae 崔世英 09/1916 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1916-09-01 1916 9 applicant 신청인 4099 황해도 Ch’oe 최 Se-yŏng 세영 NULL
mEc5t8WeT1uN8qqmUEPnAQ Kim, Pong-sŏk 김봉석 Chŏnnam w 金福連 Kim, Pok-yŏn 김복련 06/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-06-01 1913 6 wife 부인 4102 전라남도 Kim 김 Pong-sŏk 봉석 NULL
mDOpaZZjTJOFNgGRSMQcsg Kim, Ki-sun 김기순 Seoul w 金月禮 Kim, Wŏl-rye 김월례 03/1917 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-03-01 1917 3 wife 부인 18 서울 Kim 김 Ki-sun 기순 NULL