데이터베이스

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
0K7CSFpqS3OoBxgwLMsRsg Chu, Yŏng-gi 주영기 Kangwŏn w 李新淑 Yi, Sin-suk 이신숙 08/1913 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1913-08-01 1913 8 wife 부인 4100 강원도 Chu 주 Yŏng-gi 영기 NULL
0j8znQhBQUaVsyzOEiLtPQ Song, Yŏng-sun 송영순 P’yŏngbuk 宋英順 송영순 07/1920 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1920-07-01 1920 7 applicant 신청인 4112 평안북도 Song 송 Yŏng-sun 영순 NULL
0HTqlHPkTh6mrMeG0XJwxQ Kim, Un-gu 김운구 Kyŏnggi m 李召史 Yi, So-sa 이소사 01/1915 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-01-01 1915 1 mother 어머니 4097 경기도 Kim 김 Un-gu 운구 NULL
0g7YKCd9Q2Gk7cPL.TSotA Kim, In-guk 김인국 P’yŏngnam w 鄭一祚 Chŏng, Il-jo 정일조 01/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-01-01 1916 1 wife 부인 4110 평안남도 Kim 김 In-guk 인국 NULL
0ejkwuvRQGeq6Vr90j-c7A Kim, Pyŏng-gwŏn 김병권 Chŏlla 金丙權 김병권 03/1914 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-03-01 1914 3 applicant 신청인 4104 전라도 Kim 김 Pyŏng-gwŏn 병권 NULL
0Efh6WyYRPeLQ.Ef0twi-w Ch’oe, Wŏn-suk 최원숙 Chŏlla w 許榮愛 Hŏ, Yŏng-ae 04/1913 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1913-04-01 1913 4 wife 부인 4104 전라도 Ch’oe 최 Wŏn-suk 원숙 NULL
0DoIxkJWTveWbkd-LqkAXA Pak, Pong-sun 박봉순 P’yŏngnam 朴鳳舜 박봉순 01/1919 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1919-01-01 1919 1 applicant 신청인 4110 평안남도 Pak 박 Pong-sun 봉순 hdTWItRwQ3O7gTA1XmGOnQ
0CTiypMFQ0O34iyjdWpFwQ Chŏn, Hyo-sik 전효식 Kyŏnggi 全孝植 04/1922 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1922-04-01 1922 4 applicant 신청인 4097 경기도 Chŏn 전 Hyo-sik 효식 NULL
0CIgN5efQPmykWV.MJ636g Ch’oe, Ki-hong 최기홍 P’yŏngnam 崔基弘 05/1917 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:47 1917-05-01 1917 5 applicant 신청인 4110 평안남도 Ch’oe 최 Ki-hong 기홍 3vr1LtMJRJGV1Tu0buVQGw
0bX6VeGoRQeo2WU5KgQ9dA O, Kyŏng-su 오경수 Chŏlla w 金益善 Kim, Ik-s ŏn 김익선 08/1915 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-08-01 1915 8 wife 부인 4104 전라도 O 오 Kyŏng-su 경수 NULL
09BjtJIOQkSB-fTbBjrQHA Pak, Yong-sŏk 박용석 Kyŏngsang w 徐福同 Sŏ, Pok-dong 서복동 03/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-03-01 1914 3 wife 부인 4101 경상도 Pak 박 Yong-sŏk 용석 NULL
04sRc6j1SBKYDf-dbyWbSA Yi, Sŭng-mu 이승무 P’yŏngnam w 朱玉汝 Chu, Ok-yŏ 주옥여 01/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-01-01 1913 1 wife 부인 4110 평안남도 Yi 이 Sŭng-mu 승무 NULL
0-tL-mU3TuOutvl-F-KzCg Yi, Wan-gyŏng 이완경 Kyŏnggi 李浣景 이한경 06/1924 Labor/Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1924-06-01 1924 6 applicant 신청인 4097 경기도 Yi 이 Wan-gyŏng 완경 NULL