데이터베이스

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
35n7yIEbRZ2bWx2GTjZeLw Pak, Se-in 박세인 Hwanghae w 洪順福 Hong, Sun-bok 홍순복 10/1915 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-10-01 1915 10 wife 부인 4099 황해도 Pak 박 Se-in 세인 NULL
33hKkh4gQw2J6Y27yJXCHA Hwang, Hŭi-jung 황희중 Kyŏnggi 2d 黃福順 Hwang, Pok-sun 황복순 10/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-10-01 1914 10 daughter 둘째딸 4097 경기도 Hwang 황 Hŭi-jung 희중 NULL
2zhLzxCaSHasC-RsIv.iQg Kim, Myŏng-sik 김명식 Seoul 金明植 김명식 11/1919 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1919-11-01 1919 11 applicant 신청인 18 서울 Kim 김 Myŏng-sik 명식 A3CNA4pBT.GxnY3qLRfz-Q
2xO96Lt-RmaK0O1Tv1cdrg Kim, Ŭng-p’al 김응팔 P’yŏnaan w 金福南 Kim, Pok-nam 김복남 01/1915 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-01-01 1915 1 wife 부인 NULL NULL Kim 김 Ŭng-p’al 응팔 NULL
2XCiXQqTT2S45LqXWMkMrw Yi, Paek-yong 이백용 Kyŏngnam w 朴鳳末 Pak, Pong-mal 박봉말 04/1919 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1919-04-01 1919 4 wife 부인 4096 경상남도 Yi 이 Paek-yong 백용 NULL
2uYao8e0SrOnxhAB7LKrIA O, Sang-hŭi 오상희 Kyŏngnam w 李福順 Yi, Pok-sun 이복순 03/1917 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-03-01 1917 3 wife 부인 4096 경상남도 O 오 Sang-hŭi 상희 NULL
2rlu7kaEQwejZWIuI15-YQ Hwang, Chik-sin 황직신 Kyŏnggi w 全應容 Chŏn, Ŭng-yong 전응용 08/1912 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1912-08-01 1912 8 wife 부인 4097 경기도 Hwang 황 Chik-sin 직신 NULL
2r7ovzEZQp2DRAnL-OoX0Q Kil, Sŏng-jae 길성재 Kangwŏn 吉聖在 01/1921 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1921-01-01 1921 1 applicant 신청인 4100 강원도 Kil 길 Sŏng-jae 성재 NULL
2MN7-Go8Q7eGhEUNVh9MhA Kim, Pong-hak 김봉학 P’yŏngnam w 徐奉阿 Sŏ, Pong-a 서봉아 03/1917 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1917-03-01 1917 3 wife 부인 4110 평안남도 Kim 김 Pong-hak 봉학 NULL
2KCHMbnITfiTbQWxZaRV9A Pae, Ch’i-su 배치수 Kyŏngbuk s 徐富鏞 Sŏ, Pu-yong 서복용 05/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-05-01 1913 5 son 아들 4098 경상북도 Pae 배 Ch’i-su 치수 NULL
2imuETrEQs-ZlUrrNwTTcA Ch’oe, Sŏng-yŏl 최성열 Hwanghae 崔聖烈 03/1916 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:47 1916-03-01 1916 3 applicant 신청인 4099 황해도 Ch’oe 최 Sŏng-yŏl 성열 6XAZhwwLSWSAL6E8UI7FhQ
2IjDdVT7TNmTijcUqdyLsQ Kim, Tu-sŏn 김두선 Ch’ungchŏng 金斗先 김두선 04/1921 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1921-04-01 1921 4 applicant 신청인 4114 충청도 Kim 김 Tu-sŏn 두선 7xuS2UO5QcGlEDvuV8jvgg
2hR2ic2MSoKvltPpgPYQiQ Sin, Han-gyu 신한규 Kyŏngnam 申漢奎 신한규 06/1921 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1921-06-01 1921 6 applicant 신청인 4096 경상남도 Sin 신 Han-gyu 한규 5MB2GYCbQ8GkedoGhE6m7Q
2fmSGB9CSZ2RAbv0DHllww Yim, Chŏng-suk 임정숙 Kyŏngnam w 金善祚 Kim, Sŏn-jo 김선조 10/1922 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1922-10-01 1922 10 wife 부인 4096 경상남도 Yim 임 Chŏng-suk 정숙 NULL
2fBOHeTJTaGTm-iet4.otw Pak, Sŏng-sun 박성순 Kyŏngsang w 都蓮伊 To, Yŏn-i 도련이 10/1912 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1912-10-01 1912 10 wife 부인 4101 경상도 Pak 박 Sŏng-sun 성순 NULL
2exZLErwTyWhZnfBHuqE.g Pak, Ch’un-wŏn 박춘원 Ch’ungch’ŏng w 朴英順 Pak(?), Yŏng-sun 박영순 12/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-12-01 1913 12 wife 부인 4114 충청도 Pak 박 Ch’un-wŏn 춘원 NULL
2d7vzQ0uR7GDVQnjrkRvUA Ch’oe, Pong-jo 최봉조 Kyŏngbuk w 李福守 Yi, Pok-su 이복수 04/1917 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1917-04-01 1917 4 wife 부인 4098 경상북도 Ch’oe 최 Pong-jo 봉조 NULL
2cNTJkfGT1OFPU.HghFTiQ Kim, Hyŏng-in 김형린 Hamgyŏng 金炯麟 10/1914 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-10-01 1914 10 applicant 신청인 4106 함경도 Kim 김 Hyŏng-in 형린 NULL
2BSxBE-CTmuVeH.BaOJxIA Kim, Chae-ŭng 김재응 Hamnam 金在應 11/1920 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1920-11-01 1920 11 applicant 신청인 4103 함경남도 Kim 김 Chae-ŭng 재응 QYDNjoicSXSDqgBE.2QROA
277IieTVSOKpqvMie0tmRA Ch’oe, Hak-hyŏn 최학현 P’yŏngnam w 康賢心 Kang, Hyŏn-sim 강현심 12/1915 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1915-12-01 1915 12 wife 부인 4110 평안남도 Ch’oe 최 Hak-hyŏn 학현 NULL