데이터베이스

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
CNq69eqiS8u9yQ1r.feJRQ Sin, Han-gyu 신한규 Kyŏngnam 申漢奎 신한규 02/1917 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1917-02-01 1917 2 applicant 신청인 4096 경상남도 Sin 신 Han-gyu 한규 5MB2GYCbQ8GkedoGhE6m7Q
CnkLjdW9RIWhqE71MqH1IA Hwang, Ho-yŏn 황호연 Kyŏnggi 黃昊淵 09/1924 Comm/Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1924-09-01 1924 9 applicant 신청인 4097 경기도 Hwang 황 Ho-yŏn 호연 NULL
Cna-acpqTZi.mmRrl.ZYZA Sŏ, U-il 서우일 Kyŏngnam 1d 徐奉鶴 Sŏ, Pong-hak 서봉학 04/1922 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1922-04-01 1922 4 daughter 딸 4096 경상남도 Sŏ 서 U-il 우일 NULL
CN6.FZLCTaWFuEG6fFW1Qw Ha, Hŭng-bo 하흥보 Kyŏngnam w 尹德牙 Yun, Tŏk-a 윤덕아 01/1918 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1918-01-01 1918 1 wife 부인 4096 경상남도 Ha 하 Hŭng-bo 흥보 NULL
cmG75LTRSGS9cMB-yJi0eg Kim, Kap-sŏn 김갑선 Kyŏngbuk w 梁德善 Yang, Tŏk-sŏn 양덕선 08/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-08-01 1916 8 wife 부인 4098 경상북도 Kim 김 Kap-sŏn 갑선 NULL
Cm7DKPtWSh6e.QF4ftpQRA Kim, Ki-hwa 김기화 Kyŏngnam w 白小福 Paek, So-bok 백소복 05/1924 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1924-05-01 1924 5 wife 부인 4096 경상남도 Kim 김 Ki-hwa 기화 NULL
cLLry1FhRkCVIjHe9myS2w Han, Ch’wi-sŏng 한취성 Hwanghae w 金士今 Kim, Sa-gŭm 김사금 03/1914 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1914-03-01 1914 3 wife 부인 4099 황해도 Han 한 Ch’wi-sŏng 취성 NULL
cj0ZjL8LQa2mn1prfIYt0A Kim, ?-sŏng 김?성 Kyŏngnam 金?聲 11/1916 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-11-01 1916 11 applicant 신청인 4096 경상남도 Kim 김 ?-sŏng ?성 NULL
CifbjFatQvOhaul7w4WJ5Q Kim, Yang-rok 김양록 P’yŏngan w 張順伊 Chang, Sun-i 장순이 09/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-09-01 1914 9 wife 부인 4111 평안도 Kim 김 Yang-rok 양록 NULL
CIcj-2BaQI21LxKlDdQaZg Yi, Yŏng-ch’un 이영춘 Kyŏngnam w 黃順南 Hwang, Sun-nam 황순남 10/1923 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1923-10-01 1923 10 wife 부인 4096 경상남도 Yi 이 Yŏng-ch’un 영춘 NULL
ChTZy-DKTXa.jwCr0tglLQ Kim, Il-yong 김일용 P’yŏngan 金一龍 12/1917 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1917-12-01 1917 12 applicant 신청인 4111 평안도 Kim 김 Il-yong 일용 5OrGNQPITcSoLLBY5WagSQ
ChJAZGhfSb-TWu9oPvcaxA Yi, T’ae-sŏp 이태섭 Hwanghae s 李在善 Yi, Chae-sŏn 이재선 12/1912 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1912-12-01 1912 12 son 아들 4099 황해도 Yi 이 T’ae-sŏp 태섭 NULL
CHb0JX5tTDuEqTB5JfQB3w Chŏng, Yŏng-am 정용암 Kyŏngbuk w 黃奉奇 Hwang, Pong-gi 황봉기 01/1913 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1913-01-01 1913 1 wife 부인 4098 경상북도 Chŏng 정 Yŏng-am 용암 NULL
CHAyzcDvRTy3sMlk9cqwsQ Passport Applicant Residence Relation Passport Name 양학길 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 NULL NULL NULL applicant 신청인 NULL NULL NULL 양 NULL 학길 NULL
cH0zPHN1RgqbBHNPoh7K8A Pak, Tŏk-sun 박덕순 Chŏlla w 金慶伊 Kim, Kyŏng-i 김경이 02/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-02-01 1913 2 wife 부인 4104 전라도 Pak 박 Tŏk-sun 덕순 NULL
cGTdvLW6QFKPMrFFl0jlGA Mun, Pong-ch’an 문봉찬 P’yŏngbuk w 具正善 Ku, Chŏng-sŏn 구정선 05/1915 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-05-01 1915 5 wife 부인 4112 평안북도 Mun 문 Pong-ch’an 봉찬 NULL
cgPETO2ETrG9jh0fO3hM4A Kim, ?-sŏk 김?석 Kyŏngbuk w 金今善 Kim, Kŭm-sŏn 김금선 02/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-02-01 1916 2 wife 부인 4098 경상북도 Kim 김 ?-sŏk ?석 NULL
CglE7C9VTH-O6ply0KD8Iw Hu, A-sun 후아순 Chŏlla 朽兒順 09/1921 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1921-09-01 1921 9 applicant 신청인 4104 전라도 Hu 후 A-sun 아순 NULL
cFb25ekSR6iHybvuc0Gslw Chŏng, Kwan-ju 정관주 Kyŏngnam w 金奉仙 Kim, Pong-sŏn 김봉선 08/1915 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1915-08-01 1915 8 wife 부인 4096 경상남도 Chŏng 정 Kwan-ju 관주 NULL
cEid0zlZSniCp0yzOvIXUw Hong, Su-p’yo 홍수표 Hwanghae 洪壽杓 07/1920 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1920-07-01 1920 7 applicant 신청인 4099 황해도 Hong 홍 Su-p’yo 수표 NULL