데이터베이스

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
srdxdoDjTliJR3SS7uTaqA Kim, Sŏng-bok 김성복 P’yŏngnam w 崔鳳萬 Ch’oe, Pong-man 최봉만 02/1918 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1918-02-01 1918 2 wife 부인 4110 평안남도 Kim 김 Sŏng-bok 성복 NULL
SqrINlYbSe6BcTy16Hx-.g Ch’oe, Chae-sŏp 최재섭 P’yŏngnam w 張思道 Chang, Sa-do 장사도 12/1913 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1913-12-01 1913 12 wife 부인 4110 평안남도 Ch’oe 최 Chae-sŏp 재섭 NULL
Sqfr5.k.Su2Pus.bG9EdaA Sŏ, Chin-su 서진수 Seoul 徐晉洙 서진수 03/1917 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-03-01 1917 3 applicant 신청인 18 서울 Sŏ 서 Chin-su 진수 NULL
SPnUpJ0eR6-y9KmMyDSymQ Hong, Man-sun 홍만순 Ch’ungnam w 趙今禮 Cho, Kŭm-rye 조금례 06/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-06-01 1913 6 wife 부인 4113 충청남도 Hong 홍 Man-sun 만순 NULL
sPk.00hGRmqlVsUkiMP01g Pak, Sŏng-ch’ŏn 박성천 Kyŏngnam 朴成千 박성천 08/1919 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1919-08-01 1919 8 applicant 신청인 4096 경상남도 Pak 박 Sŏng-ch’ŏn 성천 NULL
SPjQb4dbTjuk-QEaax14sA Kim, Yŏng-sŏn 김영선 Kyŏngbuk 金永善 김영선 08/1921 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1921-08-01 1921 8 applicant 신청인 4098 경상북도 Kim 김 Yŏng-sŏn 영선 8RQyCELjTBWSoafWhwjy6g
sNX3u7WeQI6ruoBXyz487A Song, Chin-hŏn 송진헌 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 송 Chin-hŏn 진헌 NULL
SnVCwxQiRR67dpPnVGcA3w Kim, Sŏn-? 김선? Kyŏnggi 金先? 김선? 02/1921 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1921-02-01 1921 2 applicant 신청인 4097 경기도 Kim 김 Sŏn-? 선? NULL
SnTrHff7REKyfzGsNVZMKQ Hong, Ki-sŏ 홍기서 Kyŏngnam w 兪壽順 Yu, Su-sun 유수순 05/1919 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1919-05-01 1919 5 wife 부인 4096 경상남도 Hong 홍 Ki-sŏ 기서 NULL
SNCnAaQqSMaeEk2fXXOb-Q Kim, Ik-yong 김익용 Hwanghae w 邊錫永 Pyŏn, Sŏk-yŏng 변석영 09/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-09-01 1913 9 wife 부인 4099 황해도 Kim 김 Ik-yong 익용 NULL
SN3H89RcRlSwHoARCw5qoA Kim, Chŏng-jip 김정집 Hwanghae w 金小岳伊 Kim, So-ak-i 김소아기 06/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-06-01 1913 6 wife 부인 4099 황해도 Kim 김 Chŏng-jip 정집 NULL
SMh.VcOwR5aXqBBIHHd-tw Kim, Sŏk-bin 김석빈 Kyŏngbuk w 鄭軍威 Chŏng, Kun-wi 정군위 02/1917 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-02-01 1917 2 wife 부인 4098 경상북도 Kim 김 Sŏk-bin 석빈 NULL
sloqz-bOQWOQ8prxT3Mabw Pak, Pong-t’aek 박봉택 Kyŏnggi w 鄭少年 Chŏng, So-nyŏn 정소년 10/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-10-01 1916 10 wife 부인 4097 경기도 Pak 박 Pong-t’aek 봉택 NULL
SL3rRmVbSBiDtCJgPEFLIQ Hwang, Ŭi-jung 황의중 Chŏnnam w 蔡小今 Ch’ae, So-gŭm 채소금 04/1917 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-04-01 1917 4 wife 부인 4102 전라남도 Hwang 황 Ŭi-jung 의중 NULL
Sl2Q1NT.Sl2PfljND5eFCg Kim, Ch’un-gyŏng 김춘경 Kyŏngbuk w 金且順 Kim, Ch’a-sun 김차순 09/1917 2025-03-29 00:00:00 jemulpo@cartoonfellow.org 김차순 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-09-01 1917 9 wife 부인 4098 경상북도 Kim 김 Ch’un-gyŏng 춘경 NULL
sL0t6NdKQ3uPDrPzENnktg Cho, Sŏng-ok 조성옥 Kyŏnggi 趙成玉 09/1916 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:47 1916-09-01 1916 9 applicant 신청인 4097 경기도 Cho 조 Sŏng-ok 성옥 aoEqsa6PSx2Llt1rXov7dw
Sl.f9K9PR4GoN5gdmkQQPA Ch’ŏn, Si-yŏng 천시영 Kyŏnggi 千時榮 07/1920 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1920-07-01 1920 7 applicant 신청인 4097 경기도 Ch’ŏn 천 Si-yŏng 시영 NULL
SKwAeBcNQtSYEjJJP1OWCA Kwŏn, In-sŏn 권인선 Kyŏngbuk w 金順伊 Kim, Sun-i 김순이 07/1917 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-07-01 1917 7 wife 부인 4098 경상북도 Kwŏn 권 In-sŏn 인선 NULL
sk7sRqmYTQ2WyDO3MK2JIg Yi, Sŏk-gŭn 이석근 Kangwŏn w 林允義時 Yim, Yun-ŭi-si 임윤의시 02/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-02-01 1916 2 wife 부인 4100 강원도 Yi 이 Sŏk-gŭn 석근 NULL
sjlIZrbQTUmtdk2IQdzR8w Ch’oe, Ra-hŏm 최나험 P’yŏngnam 崔羅險 07/1917 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1917-07-01 1917 7 applicant 신청인 4110 평안남도 Ch’oe 최 Ra-hŏm 나험 NULL