데이터베이스

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
xIEhTOCeSbO1lKmCQ13Csg Song, Chae-dŏk 송재덕 Seoul 宋在德 송재덕 09/1921 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1921-09-01 1921 9 applicant 신청인 18 서울 Song 송 Chae-dŏk 재덕 NULL
XIcdKPS3RdO14s5d-FbWWQ Chŏng, Im-sŏn 정임선 Kyŏngnam w 金日羅 Kim, Il-ra 김일라 02/1921 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1921-02-01 1921 2 wife 부인 4096 경상남도 Chŏng 정 Im-sŏn 임선 NULL
xi1q01SyQJa3ImWFahm2dA Kim, Yang-p’il 김양필 Kyŏngnam w 吳末南 O, Mal-nam 오말남 02/1922 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1922-02-01 1922 2 wife 부인 4096 경상남도 Kim 김 Yang-p’il 양필 NULL
xi12ZZPNTG6STIKL2XoGcg Mun, Pong-sŏp 문봉섭 Kyŏngnam w 崔奉玉 Ch’oe, Pong-ok 최봉옥 02/1921 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1921-02-01 1921 2 wife 부인 4096 경상남도 Mun 문 Pong-sŏp 봉섭 NULL
xgzRdX2YTWqaBXEUdnCD6g Sin, Sŏng-il 신성이 Kyŏngnam 1d 辛念伊 Sin, Nyŏm-i 신념이 10/1915 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-10-01 1915 10 daughter 딸 4096 경상남도 Sin 신 Sŏng-il 성이 NULL
xgVS1JFTRlWnojBgnd-XPg Han, Pyŏng-yong 한병용 P’yŏngbuk 韓炳龍 07/1920 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1920-07-01 1920 7 applicant 신청인 4112 평안북도 Han 한 Pyŏng-yong 병용 NULL
XGOkc3C0RAudafBJhb-ReA Ko, Myŏng-gŭn 고명근 P’yŏngbuk w 趙太順 Cho, T’ae-sun 조태순 11/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-11-01 1916 11 wife 부인 4112 평안북도 Ko 고 Myŏng-gŭn 명근 NULL
XgKmNyhBSLOlJGtR2sXpOg Ch’oe, Sang-ŭn 최상은 Hwanghae 崔相殷 02/1918 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:47 1918-02-01 1918 2 applicant 신청인 4099 황해도 Ch’oe 최 Sang-ŭn 상은 OhZPfnnpRcyjqA2y3W1ZXA
xgA.NNk9T6SNhPae0RoVOg Kim, Kwŏn-sil 김권실 P’yŏngnam w 金林伊 Kim, Im-i 김임이 08/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-08-01 1916 8 wife 부인 4110 평안남도 Kim 김 Kwŏn-sil 권실 NULL
XeNN3l6xSPK9ZT9gjsN7Rw Yi, Man-gi 이만기 Kyŏnggi 첫째딸 李完順 Yi, Wan-sun 이완순 10/1918 2025-03-14 00:00:00 jemulpo@cartoonfellow.org 2025-09-14 05:57:42 2025-12-06 10:59:08 1918-10-01 1918 10 daughter 첫째딸 4097 경기도 Yi 이 Man-gi 만기 NULL
Xe0RZzJHSECt4eL81mNvfg Kim, Chae-bok 김재복 Kyŏngnam 金在福 11/1917 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-11-01 1917 11 applicant 신청인 4096 경상남도 Kim 김 Chae-bok 재복 NULL
xDX.RAohRri1ppCEHB6Q5Q Yi, Hyŏn-p’il 이현필 P’yŏngnam w 朴爲連 Pak, Wi-ryŏn 박위련 12/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-12-01 1914 12 wife 부인 4110 평안남도 Yi 이 Hyŏn-p’il 현필 NULL
XdmJq9NcTi6uD1H36l3Nhg O, Ch’an-yong 오찬용 P’yŏngan 吳燦龍 오찬용 09/1914 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1914-09-01 1914 9 applicant 신청인 4111 평안도 O 오 Ch’an-yong 찬용 0YJRu7fvQaqRa.YceZhhUA
XdF4u8ovQl6MM60HY0Tf7A Yim, Kyu-sŏk 임달린 Kyŏnggi 林奎錫 임규석 11/1917 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-11-01 1917 11 applicant 신청인 4097 경기도 Yim 임 Kyu-sŏk 달린 NULL
xD3CWK.UTCWavNJpPX8fhQ Ham, Sŏng-mo 함성모 Kangwŏn w 李奉辰 Yi, Pong-jin 이봉진 03/1917 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1917-03-01 1917 3 wife 부인 4100 강원도 Ham 함 Sŏng-mo 성모 NULL
xcw5cjtYSPaKmNiq9lVRaw Chŏn, Hwa-san 전화산 Seoul w 金日元 Kim, Il-wŏn 김일원 09/1915 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1915-09-01 1915 9 wife 부인 18 서울 Chŏn 전 Hwa-san 화산 NULL
xBRENlreRBaDUJkE0S3e6g Kim, Pong-sŏk 김봉석 Chŏnnam s 朴錦道 Pak, Kŭm-do 박김도 01/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-01-01 1914 1 son 아들 4102 전라남도 Kim 김 Pong-sŏk 봉석 NULL
xA-3vOTmR2CF.FZWAyexYQ Pak, So-sun 박소순 Kyŏngnam 1s 金吉壽 Kim, Kil-su 김길수 04/1923 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1923-04-01 1923 4 son 아들 4096 경상남도 Pak 박 So-sun 소순 NULL
X9yCaesSQJ-KiHwG6RkUYA Chŏng, Sŏng-gwan 정성관 Kyŏngnam w 金英伊 Kim, Yŏng-i 김영이 10/1915 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1915-10-01 1915 10 wife 부인 4096 경상남도 Chŏng 정 Sŏng-gwan 성관 NULL
x8rgi6h8TjStJ-qzavd0hw Kim, Chong-un 김종운 Kyŏngnam w 裵裕秀 Pae, Yu-su 배유수 08/1915 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-08-01 1915 8 wife 부인 4096 경상남도 Kim 김 Chong-un 종운 NULL