데이터베이스

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
Zh.M98QlSJS-KPtDh7pFeg Son, Ch’ang-gŭn 손창근 Kyŏngnam w 張順南 Chang, Sun-nam 장순남 01/1921 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1921-01-01 1921 1 wife 부인 4096 경상남도 Son 손 Ch’ang-gŭn 창근 NULL
ZGaJRDNgQjWFGK4FhO4EaQ Ch’oe, Chŏng-gon 최정곤 P’yŏngbuk w 朴守連 Pak, Su-ryŏn 박수련 07/1917 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1917-07-01 1917 7 wife 부인 4112 평안북도 Ch’oe 최 Chŏng-gon 정곤 NULL
ZfF5AVOCRAq8i0FYoPbTBA Cho, Mae-i 조매이 P’yŏngnam 趙梅伊 02/1921 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1921-02-01 1921 2 applicant 신청인 4110 평안남도 Cho 조 Mae-i 매이 NULL
Zf4-obTtTF-2WaGUw8VtjA Kim, Sŏn-jip 김선집 Kyŏnggi w 薄分 Pak-bun 박분 06/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-06-01 1914 6 wife 부인 4097 경기도 Kim 김 Sŏn-jip 선집 NULL
ZEPxCbnIRWuLeYsKnGn59A Chang, Hak-p’il 장학필 P’yŏngbuk w 朴古順 Pak, Ko-sun 박고순 06/1917 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1917-06-01 1917 6 wife 부인 4112 평안북도 Chang 장 Hak-p’il 학필 NULL
zEnByVAzTnWmiZsAnFzrFg Kim, Pyŏng-ch’ŏl 김병철 P’yŏngnam w 李順道 Yi, Sun-do 이순도 12/1915 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-12-01 1915 12 wife 부인 4110 평안남도 Kim 김 Pyŏng-ch’ŏl 병철 NULL
zejhSykKStiYd-6o-tPkLg Pak, Ch’ang-sŏn 박창선 Kyŏngnam w 金貴分 Kim, Kwi-bun 김귀분 03/1922 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1922-03-01 1922 3 wife 부인 4096 경상남도 Pak 박 Ch’ang-sŏn 창선 NULL
zDn2b8ndRY-ivBY1hIPpIw Kim, Yang-uk 김양욱 Kyŏngsang w 金逢春 Kim(?), Pong-ch’un 김봉춘 12/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-12-01 1913 12 wife 부인 4101 경상도 Kim 김 Yang-uk 양욱 NULL
zCoIpYpOR4a7HADtmuSIDw Chang, Han-p’il 장한필 Kyŏngnam w 金鳳學 Kim, Pong-hak 김봉학 11/1918 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1918-11-01 1918 11 wife 부인 4096 경상남도 Chang 장 Han-p’il 한필 NULL
zCMutIerTAKji.ukc8Exyw Nam, Sun-myŏng 남순명 Kyŏnggi w 金順南 Kim, Sun-nam 김순남 10/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-10-01 1914 10 wife 부인 4097 경기도 Nam 남 Sun-myŏng 순명 NULL
zCA7rTqVTSC8jORLVaxjrQ Ch’oe, Ki-hong 최기홍 Kyŏngnam 崔基弘 05/1923 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:47 1923-05-01 1923 5 applicant 신청인 4096 경상남도 Ch’oe 최 Ki-hong 기홍 3vr1LtMJRJGV1Tu0buVQGw
ZbUuQqTcTU6wO7fxSkimlQ Chu, Ch’an-suk 주찬숙 P’yŏngbuk w 李粉男 Yi, Pun-nam 이분남 03/1916 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1916-03-01 1916 3 wife 부인 4112 평안북도 Chu 주 Ch’an-suk 찬숙 NULL
zbgBD1T0QO6ouq-P6hwANg An, Yong-bŏm 안용범 P’yŏngnam w 李必伊 Yi, P’il-i 이필이 09/1917 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1917-09-01 1917 9 wife 부인 4110 평안남도 An 안 Yong-bŏm 용범 NULL
zaS2saYDQk6yFvbd4Jy4pA Yi, Yun-ok 이윤옥 Kyŏngbuk 2s 李鍾七 Yi, Chong-ch’il 이종칠 09/1921 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1921-09-01 1921 9 son 둘째아들 4098 경상북도 Yi 이 Yun-ok 윤옥 NULL
Z9TBpbxNQgudwlkIkonUTw Pak, Pong-hŏn 박봉헌 Kyŏngnam w 李順伊 Yi, Sun-i 이순이 01/1915 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-01-01 1915 1 wife 부인 4096 경상남도 Pak 박 Pong-hŏn 봉헌 NULL
Z7zz-A.KR9Sd5noidVczGA Ch’oe, Sang-ho 최상호 Seoul 2d 崔貞琳 Ch’oe, Chŏng-rim 최정림 06/1914 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1914-06-01 1914 6 daughter 둘째딸 18 서울 Ch’oe 최 Sang-ho 상호 NULL
z7JD4S6DTlOfmgitndFWJQ Kang, Tong-u 강동우 Kyŏngnam w 崔順連 Ch’oe, Sun-ryŏn 최순련 08/1918 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1918-08-01 1918 8 wife 부인 4096 경상남도 Kang 강 Tong-u 동우 NULL
z6ZrHtFjRtOi12tiYbvsDg Kim, P’il-sŏ 김필서 Ch’ungch’ŏng w 池丁順 Chi, Chŏng-sun 池丁순 08/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-08-01 1913 8 wife 부인 4114 충청도 Kim 김 P’il-sŏ 필서 NULL
Z4YFgV0lTBOSHxeQbRzlag Yang, Kŭm-jin 양금진 Kyŏngbuk 梁錦軫 양금진 09/1921 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1921-09-01 1921 9 applicant 신청인 4098 경상북도 Yang 양 Kŭm-jin 금진 NULL
Z3PBdji-TvKsaDLuaPWbjg Kwŏn, Hak-sŏ 권학서 Kyŏngbuk w 劉暗銓 Yu, Am-jŏn 유암전 06/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-06-01 1916 6 wife 부인 4098 경상북도 Kwŏn 권 Hak-sŏ 학서 NULL