데이터베이스

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
y0juwcrRRnCw7IvJLvs4JQ Chang, Yŏng-baek 장영백 Kyŏngbuk w 洪淳姬 Hong, Sun-hŭi 홍순희 01/1913 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1913-01-01 1913 1 wife 부인 4098 경상북도 Chang 장 Yŏng-baek 영백 NULL
y0gk0vshRDiJ6kArHD4zWQ Sin, Han-jun 신한준 Kyŏngnam s 申玉男 Sin, Ok-nam 신옥남 09/1915 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-09-01 1915 9 son 아들 4096 경상남도 Sin 신 Han-jun 한준 NULL
Y.ifje-eRvKMOpk5-CFy5A Yi, Chu-an 이주안 Chŏlla w 李周安 Ch’oe, So-yŏl 최소열 11/1912 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1912-11-01 1912 11 wife 부인 4104 전라도 Yi 이 Chu-an 주안 NULL
Y-I0yDAoRz2ZJukRj5dBTg Kim, Ch’un-sŏ 김춘서 Kyŏnggi w 崔順伊 Ch’oe, Sun-i 최순이 09/1915 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-09-01 1915 9 wife 부인 4097 경기도 Kim 김 Ch’un-sŏ 춘서 NULL
xzvh9TnxSByhApXdegIMrQ Kim, Man-su 김만수 Hwanghae w 金敎連 Kim, Kyo-ryŏn 김교련 01/1917 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-01-01 1917 1 wife 부인 4099 황해도 Kim 김 Man-su 만수 NULL
Xzru8rtZSrmKMYWrTqLMGg Kim, Yŏng-ho 김영호 Kyŏngnam 金永好 김영호 01/1921 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1921-01-01 1921 1 applicant 신청인 4096 경상남도 Kim 김 Yŏng-ho 영호 NULL
XZnPdeGERXC3SNmyf00uIQ Kim, In-ch’ŏl 김인철 Ch’ungch’ŏng w 朴德給 Pak, Tŏk-gŭp 박덕급 05/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-05-01 1913 5 wife 부인 4114 충청도 Kim 김 In-ch’ŏl 인철 NULL
XZFQZ74sRVmqCZwRs5-HRw Pyŏn, Pong-jo 변봉조 Kyŏngsang 卞奉鳥 변봉조 08/1914 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-08-01 1914 8 applicant 신청인 4101 경상도 Pyŏn 변 Pong-jo 봉조 NULL
xYZqOrx9TTqb0zbNQeJUQQ Hong, To-dong 홍도동 P’yŏngan w 崔秀順 Ch’oe, Su-sun 최수순 02/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-02-01 1913 2 wife 부인 4111 평안도 Hong 홍 To-dong 도동 NULL
XyIehfmlS12xp.g6Nwk9RQ Yang, Yong-sŏ 양용서 Chŏnbuk w 安萬連 An, Man-ryŏn 안만련 05/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-05-01 1916 5 wife 부인 4105 전라북도 Yang 양 Yong-sŏ 용서 NULL
xxsgzx8WTPe7Ui2D.6Lnuw Cho, Wan-sik 조완식 Hwanghae 趙完植 11/1914 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1914-11-01 1914 11 applicant 신청인 4099 황해도 Cho 조 Wan-sik 완식 NULL
xXd5UI0FR2mBuMP6z3pR5A Kim, Kyŏng-sin 김경신 P’yŏngnam 金敬信 김경신 03/1919 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1919-03-01 1919 3 applicant 신청인 4110 평안남도 Kim 김 Kyŏng-sin 경신 NULL
xx3eS8O-SPiq23c2CcxmaA Kim, Su-ryŏn 김수연 Kyŏngnam 金守連 김수련 09/1922 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1922-09-01 1922 9 applicant 신청인 4096 경상남도 Kim 김 Su-ryŏn 수연 6ItEpLasQzCExR9fe4N-sw
Xwx3qCfTSre97mL4tCRCvA Cho, Chin-ho 조진련 Kyŏngnam w 朴小正 Pak, So-jŏng 박소정 03/1919 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1919-03-01 1919 3 wife 부인 4096 경상남도 Cho 조 Chin-ho 진련 NULL
xwtHy30xQdKAgdU9Ci21QQ Kang, Ch’i-gwŏn 강치권 Kyŏnggi w 李成鶴 Yi, Sŏng-hak 이성학 11/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-11-01 1916 11 wife 부인 4097 경기도 Kang 강 Ch’i-gwŏn 치권 NULL
Xw4y.CamSvCf51kHAR6EWA Cho, Kyŏng-hwa 조경화 Kyŏngbuk w 李妙玉 Yi, Myo-ok 이묘옥 04/1917 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1917-04-01 1917 4 wife 부인 4098 경상북도 Cho 조 Kyŏng-hwa 경화 NULL
xumy9-84SqqVS3VU0b7tXw Song, Sŏk-sun 송석순 Kyŏngbuk w 金學閱 Kim, Hak-yŏl 김학열 11/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-11-01 1916 11 wife 부인 4098 경상북도 Song 송 Sŏk-sun 석순 NULL
xTRDRUpiTX6lxKRVrat2oA Sim, Kyŏng-il 심경일 Kyŏngbuk w 李乭釗 Yi, Tol-soe 이택조 03/1917 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-03-01 1917 3 wife 부인 4098 경상북도 Sim 심 Kyŏng-il 경일 NULL
xtpm3mNASOKuXAzLWRZLpg Kim, Sŏk-jin 김석진 Kyŏnggi w 朴福順 Pak, Pok-sun 박복순 06/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-06-01 1916 6 wife 부인 4097 경기도 Kim 김 Sŏk-jin 석진 NULL
XToXH65GQpumtoVuz6d0Cw Yim, Man-sŏk 임만석 Chŏnnam w 姜壽連 Kang, Su-ryŏn 강수련 07/1917 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-07-01 1917 7 wife 부인 4102 전라남도 Yim 임 Man-sŏk 만석 NULL