데이터베이스

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
oQhhbhS0ScWKiHIPJ-eFrw Kim, Tŏk-wŏn 김덕원 Kangwŏn w 朴億伊 Pak, Ŏk-i 박억이 02/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-02-01 1913 2 wife 부인 4100 강원도 Kim 김 Tŏk-wŏn 덕원 NULL
Oph9fqcvQlOY52u7mv.y.g Kim, Su-yŏn 김수연 Kyŏngnam 金守然 김수연 04/1922 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1922-04-01 1922 4 applicant 신청인 4096 경상남도 Kim 김 Su-yŏn 수연 6ItEpLasQzCExR9fe4N-sw
op18vtxUSkifJCLm9zpR4Q Chŏng, Ok-du 정두옥 Kyŏngbuk f 鄭泰相 Chŏng, T’ae-sang 정태상 01/1924 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1924-01-01 1924 1 father 아버지 4098 경상북도 Chŏng 정 Ok-du 두옥 NULL
oOoSMWVbRnyB.iCOiUT4pQ Chŏng, Wŏn-myŏng 정원명 P’yŏngnam d 鄭愛榮 Chŏng, Ae-Yŏng 정애영 07/1919 Re NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1919-07-01 1919 7 daughter 딸 4110 평안남도 Chŏng 정 Wŏn-myŏng 원명 NULL
oOkTpgR2SACZDiJbT1iwng Han, Pyŏng-hwan 한병환 Kyŏngnam w 金寶培 Kim, Po-bae 김포배 01/1913 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1913-01-01 1913 1 wife 부인 4096 경상남도 Han 한 Pyŏng-hwan 병환 NULL
OOdY.8.FTmG.LGfyT7kBXw Kim, Hae-ju 김해주 Kyŏngnam 金海珠 10/1922 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1922-10-01 1922 10 applicant 신청인 4096 경상남도 Kim 김 Hae-ju 해주 NULL
OnPp7OrrR8C4FATGhVwaNw Kim, P’ung-ryŏn 김풍련 Kyŏngnam w 金守念 Kim, Su-nyŏm 김수념 10/1921 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1921-10-01 1921 10 wife 부인 4096 경상남도 Kim 김 P’ung-ryŏn 풍련 NULL
oNMxTQPPTIeroSwsJ21-zg Kim, Ŭng-p’al 김응팔 Kyŏngnam w 羅福林 Na, Pok-rim 나복림 09/1922 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1922-09-01 1922 9 wife 부인 4096 경상남도 Kim 김 Ŭng-p’al 응팔 NULL
onAQzPibRtK32kga7bOmDw Kim, Sŏn-il 김선일 Ch’ungnam 金善日 김선일 11/1917 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:47 1917-11-01 1917 11 applicant 신청인 4113 충청남도 Kim 김 Sŏn-il 선일 nn1LujErTqqU05jFp2WcQQ
oN0BQYBFRkyzZTfCK2wwJQ Yi, Kyŏng-do 이경도 Kyŏnggi w 盧貞玉 No, Chŏng-ok 노정옥 09/1915 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-09-01 1915 9 wife 부인 4097 경기도 Yi 이 Kyŏng-do 경도 NULL
omHDbZWHQBumrQadwgF4Xg Ha, Ch’un-sik 하춘식 Seoul d 鄭福同 Chŏng, Pok-dong 정복동 05/1914 NULL 2025-09-14 05:57:41 2025-12-06 10:59:08 1914-05-01 1914 5 daughter 딸 18 서울 Ha 하 Ch’un-sik 춘식 NULL
Oli2CWIYSBeedi3VZbQ8PQ Yi, Chŏng-man 이정만 Hamnam 1d 李正萬 Paek, Kŭm-yŏ 백금여 10/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-10-01 1913 10 daughter 딸 4103 함경남도 Yi 이 Chŏng-man 정만 NULL
OL6BJNpJRxK45O8UpYm.yQ Ko, T’ae-ho 고태호 Chŏnnam 高泰浩 고태호 12/1921 Re NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1921-12-01 1921 12 applicant 신청인 4102 전라남도 Ko 고 T’ae-ho 태호 NULL
oL-SY-z7QXGdF5agsJ.WjQ Mun, Sun-ch’il 문순칠 Kangwŏn w 金正淑 Kim, Chŏng-suk 김정숙 01/1914 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1914-01-01 1914 1 wife 부인 4100 강원도 Mun 문 Sun-ch’il 순칠 NULL
OKLSIAQrRvesZdOs7vgZxQ Yim, Ŭng-jŏn 임응환 P’yŏngan w 崔文南 Ch’oe, Mun-nam 최문남 05/1912 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1912-05-01 1912 5 wife 부인 4111 평안도 Yim 임 Ŭng-jŏn 응환 NULL
oK8pi6I5Q--upAxPSqbclQ Pak, Kyŏng-il 박경일 Seoul s 朴石柱 Pak, Sŏk-ju 박석주 09/1919 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1919-09-01 1919 9 son 아들 18 서울 Pak 박 Kyŏng-il 경일 NULL
OjyQjoQETHy6xI3By0WBHw Yun, Sŏk-gyu 윤석규 Seoul w 尹三淑 Yun, Sam-suk 윤삼숙 06/1916 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1916-06-01 1916 6 wife 부인 18 서울 Yun 윤 Sŏk-gyu 석규 NULL
OjnPPHtHQxirYRzMRqIY7g Song, Ch’ang-soe 송창조 Seoul w 李間蘭 Yi, Kan-ran 이간란 06/1913 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1913-06-01 1913 6 wife 부인 18 서울 Song 송 Ch’ang-soe 창조 NULL
oJBylyQeSTSOJRA6pq9Kgg Sŏ, To-sŏn 서도선 Kyŏngnam w 李福得 Yi, Pok-dŭk 이복득 09/1918 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1918-09-01 1918 9 wife 부인 4096 경상남도 Sŏ 서 To-sŏn 도선 NULL
oJ7odSBtQguufLYQKp1gpQ Song, Yŏng-gŏl 송영걸 P’yŏngnam w 金正漢 Kim, Chŏng-han 김정한 06/1915 NULL 2025-09-14 05:57:42 2025-12-06 10:59:08 1915-06-01 1915 6 wife 부인 4110 평안남도 Song 송 Yŏng-gŏl 영걸 NULL