데이터베이스

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
PryLrSqWTKCk98yS2Q3hKA Song, Chae-bŏm 송재범 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-bŏm 재범 NULL
PRILHPZeTMK.ndimXUynCQ Song, Yŏng-gŏl 송영걸 P’yŏngbuk w 秋德順 Ch’u, Tŏk-sun 추덕순 03/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-03-01 1914 3 wife 부인 4112 평안북도 Song 송 Yŏng-gŏl 영걸 NULL
pre8r7vhTeiEsk8DuCq7ow Yu, Sŏk-hwan 유석환 Hwanghae 柳錫煥 유석환 06/1915 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1915-06-01 1915 6 applicant 신청인 4099 황해도 Yu 유 Sŏk-hwan 석환 PnUFbI4wR2Kitha2gaAw1Q
pR-VDgYMSXycgllMvpDgvg Chin, Ch’ang-su 진창수 Kyŏnggi w 金魚振 Kim, Ŏ-jin 김어진 03/1913 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1913-03-01 1913 3 wife 부인 4097 경기도 Chin 진 Ch’ang-su 창수 NULL
PQAUcRD6TRyILQzK4IkdnA Kim, Ch’ang-yŏn 김창연 Hamnam 金昌連 02/1924 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1924-02-01 1924 2 applicant 신청인 4103 함경남도 Kim 김 Ch’ang-yŏn 창연 Xc4Rvnx6TI-Gnnuw9mXxag
pow6G7.vSWmJb3mJvK4gaQ Kim, I-man 김이만 Kyŏngsŏng w 具龍書 Ku, Yong-sŏ 구용서 07/1912 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1912-07-01 1912 7 wife 부인 4122 경성 Kim 김 I-man 이만 NULL
poHerVqrRimt0bT3u72WVw Chŏng, Sa-sŏn 정사선 Seoul w 金月羅 Kim, Wŏl-ra 김월라 04/1917 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1917-04-01 1917 4 wife 부인 18 서울 Chŏng 정 Sa-sŏn 사선 NULL
Po8wxqTsQrmWqdTZ2vtBIg Yi, Tŏk-yŏ 이덕여 Kyŏnggi w 金性義 Kim, Sŏng-i 김성의 05/1915 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-05-01 1915 5 wife 부인 4097 경기도 Yi 이 Tŏk-yŏ 덕여 NULL
pM6IpdQYTB-.-5WD2oJIfw No, Sŏng-bae 노성배 Hwanghae w 尹金先 Yun, Kŭm-sŏn 윤김선 12/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-12-01 1916 12 wife 부인 4099 황해도 No 노 Sŏng-bae 성배 NULL
plvgqyuhTP2KcF81Odl6JQ Pak, Kyŏng-jun 박경준 Kyŏngbuk w 鄭玉伊 Chŏng, Ok-i 정옥이 01/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-01-01 1916 1 wife 부인 4098 경상북도 Pak 박 Kyŏng-jun 경준 NULL
PLRSAqWiSHWyRhjYtLs1SA Ok, Ch’o-ho 옥초련 P’yŏngnam 玉初蓮 옥초련 06/1917 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-06-01 1917 6 applicant 신청인 4110 평안남도 Ok 옥 Ch’o-ho 초련 NULL
plLu8lkiRKiuxZlaea.kAg Kim, Kye-? 김계? Kangwŏn 金溪? 05/1921 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1921-05-01 1921 5 applicant 신청인 4100 강원도 Kim 김 Kye-? 계? NULL
plKDSLXqT5WGId3Uyu3A9Q Cho, Ch’i-sam 조치삼 Hwanghae w 朴福壽 Pak, Pok-su 박복수 09/1915 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1915-09-01 1915 9 wife 부인 4099 황해도 Cho 조 Ch’i-sam 치삼 NULL
pi.96QeFRa63zz1JA2Xsxw Pak, In-suk 박인숙 Hamnam 2s 金正煥 Kim, Chŏng-hwan 김정환 08/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-08-01 1916 8 son 둘째아들 4103 함경남도 Pak 박 In-suk 인숙 NULL
phVmXTiSSX2UssRDLC1.Jw Yim, Il-gwan 임광묵 P’yŏngnam ys 金學魯 Kim, Hak-ro 김학로 01/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-01-01 1916 1 son 막내아들 4110 평안남도 Yim 임 Il-gwan 광묵 NULL
Pht3RQiuSxCwaJF2uMZykg Hwang, Ho-yŏn 황호연 Kyŏnggi 4s 黃得秀 Hwang, Tŭk-su 황득수 04/1920 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1920-04-01 1920 4 son 넷째아들 4097 경기도 Hwang 황 Ho-yŏn 호연 NULL
pHnbIOODTka6SzIas3f.-Q Yu, Han-ŭng 유한응 Seoul 劉漢應 유한응 05/1923 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1923-05-01 1923 5 applicant 신청인 18 서울 Yu 유 Han-ŭng 한응 Hucl7RvKQiy33NyOHPGHAg
PH2a2NqkRpObFseqdM5KBg Kang, Kŏn-t’ae 강건 Kyŏngsang w 朴丙連 Pak, Pyŏng-ryŏn 박병련 05/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-05-01 1914 5 wife 부인 4101 경상도 Kang 강 Kŏn-t’ae 건 NULL
ph0nQkOASKqYbwQmuv96-Q Kim, Yŏng-han 김영한 Kangwŏn 金永漢 김영한 07/1918 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1918-07-01 1918 7 applicant 신청인 4100 강원도 Kim 김 Yŏng-han 영한 NULL
PG7ToaCYQUy551zLWsoJJg Ch’oe, Chin-sŏng 최진성 Kyŏnggi w 丁蘭淑 Chŏng, Ran-suk 정란숙 07/1917 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1917-07-01 1917 7 wife 부인 4097 경기도 Ch’oe 최 Chin-sŏng 진성 NULL