데이터베이스

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
q3XxcZvVS2yZPcbg7BdNxg Pak, Kŭm-san 박금산 Kyŏnggi 朴琴山 박금산 07/1913 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-07-01 1913 7 applicant 신청인 4097 경기도 Pak 박 Kŭm-san 금산 NULL
Q2kusvqmTZGxN5yT6ufYBg Kim, Ch’ang-sŏn 김창선 P’yŏngan 金昌善 06/1914 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1914-06-01 1914 6 applicant 신청인 4111 평안도 Kim 김 Ch’ang-sŏn 창선 qyOrIBXBSiqrRg8asCS9Ng
Q04TX5FVRuGbeU53p4-lXw Pae, Tŏk-sŏng 배덕성 P’yŏngbuk w 徐鳳順 Sŏ, Pong-sun 서봉순 05/1917 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-05-01 1917 5 wife 부인 4112 평안북도 Pae 배 Tŏk-sŏng 덕성 NULL
q-n6isZgSWykGxrl1yFEHg Ch’oe, Mae-ri 최매리 Kyŏnggi 崔每里 08/1921 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1921-08-01 1921 8 applicant 신청인 4097 경기도 Ch’oe 최 Mae-ri 매리 NULL
q-fvPaHVQnit0HMt46r5Aw Yi, Man-gi 이만기 Seoul 李晩基 이만기 12/1917 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1917-12-01 1917 12 applicant 신청인 18 서울 Yi 이 Man-gi 만기 SBWnKHBzQg20KJHRnRWhYQ
q-7B5eU7TKGUOUE699yGqg Pak, Pong-sun 박봉순 P’yŏngnam 2s 朴宗鉉 Pak, Chong-hyŏn 박종현 02/1918 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1918-02-01 1918 2 son 둘째아들 4110 평안남도 Pak 박 Pong-sun 봉순 NULL
Q--egkwjRkWhI0xgJHNy8Q Kim, Yang-rok 김양록 P’yŏngbuk w 鄭末男 Chŏng, Mal-nam 정말남 10/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-10-01 1916 10 wife 부인 4112 평안북도 Kim 김 Yang-rok 양록 NULL
pyw8Q1fcT1mJ-v-kQFGDJQ Chŏng, Chong-sŏk 정종석 Kyŏngbuk w 劉元逼 Yu, Wŏn-p’ip 유원필 10/1916 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1916-10-01 1916 10 wife 부인 4098 경상북도 Chŏng 정 Chong-sŏk 종석 NULL
pyvtDCTaRaGDaCgzapBp9w Han, Hŭng-ju 한흥주 Seoul 韓興珠 07/1919 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:47 1919-07-01 1919 7 applicant 신청인 18 서울 Han 한 Hŭng-ju 흥주 FjIoPMwcSi-YwD50yZ4N8Q
PXzzZUmtSb-ycd1VcDCPLA An, Kyo-jŏm 안교점 P’yŏngnam 安敎漸 04/1923 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1923-04-01 1923 4 applicant 신청인 4110 평안남도 An 안 Kyo-jŏm 교점 NULL
pXeUW5EiRSiRItYcDBl.Ag Kim, Hŭng-bok 김흥복 Kyŏngnam w 裵天禮 Pae, Ch’ŏn-rye 배천례 01/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-01-01 1914 1 wife 부인 4096 경상남도 Kim 김 Hŭng-bok 흥복 NULL
PwjX-NYfRW-gpPOFA4q9.g Ch’oe, Chŏng-hwan 최정환 Seoul 崔貞煥 05/1921 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1921-05-01 1921 5 applicant 신청인 18 서울 Ch’oe 최 Chŏng-hwan 정환 NULL
PvZgzNW8RiqoLcguOg9Nfw Kim, Hyo-jin 김효진 P’yŏngan w 鄭云辰 Chŏng, Un-jin 정운진 01/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-01-01 1913 1 wife 부인 4111 평안도 Kim 김 Hyo-jin 효진 NULL
PvvMNGx7TV6kiWccT1M6Xg Yang, Ŏn-jo 양언조 Kyŏngnam w 梁溫玉 On-ok 양온옥 07/1923 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1923-07-01 1923 7 wife 부인 4096 경상남도 Yang 양 Ŏn-jo 언조 NULL
PuNlNTm-QRa6rL5ubQ9yHA Mun, Pong-ch’an 문봉찬 P’yŏngan w 孔東必 Kong, Tong-p’il 공동필 10/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-10-01 1913 10 wife 부인 4111 평안도 Mun 문 Pong-ch’an 봉찬 NULL
PuKcB93sQYabHPC66IvVrA O, Ch’un-hwan 오춘환 Hwanghae w 吳牙只 O, A-ji 오아지 01/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-01-01 1914 1 wife 부인 4099 황해도 O 오 Ch’un-hwan 춘환 NULL
Pt0XX5-TRs-wTC3SLU.UFA Kim, Ŭng-baek 김응백 Kyŏngbuk 金應伯 김응백 08/1917 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-08-01 1917 8 applicant 신청인 4098 경상북도 Kim 김 Ŭng-baek 응백 NULL
PsU4.ThcQCGLPJhf6zq95Q Chu, In-sŏp 주인섭 Hamnam w 金弼先 Kim, P’il-sŏn 김필선 06/1916 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1916-06-01 1916 6 wife 부인 4103 함경남도 Chu 주 In-sŏp 인섭 NULL
psTr-lHQSSOohEFB4HG-bQ Kim, Kwang-hyŏn 김광현 Hwanghae w 李小連 Yi, So-ryŏn 이소련 10/1915 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-10-01 1915 10 wife 부인 4099 황해도 Kim 김 Kwang-hyŏn 광현 NULL
PskHctopR5SaS1HfOah38g Chŏng, Yong-sam 정용삼 鄭龍三 07/1919 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:47 1919-07-01 1919 7 applicant 신청인 NULL NULL Chŏng 정 Yong-sam 용삼 t2qg-HxvRy26KawMHWTA9A