데이터베이스

K이민사 아카이브

archive_ships

이민선 · 7,416개 행 · 45개 컬럼

새 레코드 CRUD 관리

컬럼 구조

id varchar(50) ship_manifest_name varchar(200) arrival_age varchar(20) age_display varchar(50) marital_status varchar(50) departure_residence varchar(200) departure_date varchar(50) ship_name varchar(100) tags_combined text korean_name varchar(100) estimated_korean_name varchar(100) hometown varchar(200) last_update_time datetime tag_1st_gen varchar(50) relation_memo text cemetery_name varchar(200) image_additional_record varchar(500) tag_2nd_gen varchar(50) image_tombstone varchar(500) image_family_photo varchar(500) image_portrait varchar(500) tag_3rd_gen varchar(50) relation_history text cemetery_joint_burial varchar(200) tombstone_name varchar(200) death_date varchar(50) image_ship varchar(500) birth_date varchar(50) created_at timestamp updated_at timestamp name_alternatives varchar(500) name_confidence tinyint unsigned family_relation varchar(50) family_member_name varchar(100) family_member_korean text departure_date_parsed date birth_date_parsed date death_date_parsed date place_id int surname_english varchar(50) surname_korean varchar(20) given_name_english varchar(100) given_name_korean varchar(50) age_numeric tinyint unsigned ship_id int
id ship_manifest_name arrival_age age_display marital_status departure_residence departure_date ship_name tags_combined korean_name estimated_korean_name hometown last_update_time tag_1st_gen relation_memo cemetery_name image_additional_record tag_2nd_gen image_tombstone image_family_photo image_portrait tag_3rd_gen relation_history cemetery_joint_burial tombstone_name death_date image_ship birth_date created_at updated_at name_alternatives name_confidence family_relation family_member_name family_member_korean departure_date_parsed birth_date_parsed death_date_parsed place_id surname_english surname_korean given_name_english given_name_korean age_numeric ship_id
cdTyuYT4SF6Uta3793dSMg Kim, Pyeng Sun 25 25세 widower Pom ark 1/26/1905 Korea 김평선 NULL 김Pyeng Sun 2025-09-14 05:57:44 2025-12-10 04:59:17 김평순,김병선 85 가장 NULL 김평선의 처(부인), 김씨의 자(아들) 1905-01-26 NULL NULL 192 Kim 김 Pyeng Sun 평선 25 9
CdQzYFhgQ8ic7jKnskuvIA Kim, Chang Hyen 23 23세 widower Kook Si Kol 2/25/1905 Mongolia 김창현 NULL 김Chang Hyen 2025-09-14 05:57:44 2025-12-06 16:53:31 김창헌,김장현 95 가장 NULL 김진환(부인), 김진환(딸), 김진환(딸) 1905-02-25 NULL NULL 1195 Kim 김 Chang Hyen 창현 23 14
cDcvyotxRgOrIb2it0wqbA Kim, Sang Ho 24 24세 married Soo Pyo Kyo 10/6/1904 China 김상호 김상호 NULL 김상호 2025-09-14 05:57:44 2025-12-06 16:53:31 NULL NULL 가장 NULL 김귀부(아들) 1904-10-06 NULL NULL 1194 Kim 김 Sang Ho 상호 24 3
CCSea5ShQj-Z21DfJpKj0A Kim, Soon Moon 26 26세 widower In Chun 8/11/1904 Siberia 김순문 NULL 김Soon Moon 2025-09-14 05:57:44 2025-12-10 04:59:17 김순문,김순먼 95 가장 NULL 김순문의 처(부인), 김성조(어머니), 김씨의 자(아들) 1904-08-11 NULL NULL 81 Kim 김 Soon Moon 순문 26 17
cCRvNt2CTJqWFNr4tgpOvA Kim, Ke Suk 40 40세 married Won San 12/28/1903 Coptic 김계석 NULL 김Ke Suk 2025-09-14 05:57:44 2025-12-10 04:34:55 김게석,김케석 85 가장 NULL 김계석의 자(아들) 1903-12-28 NULL NULL 160 Kim 김 Ke Suk 계석 40 4
CcPgm-53SrmKwnQmAQnzZw Chang, Moon Ho 26 26세 married Sai Pong Sung 3/31/1905 Manchuria 장문호 장문호 NULL 장Moon Ho 2025-09-14 05:57:43 2025-12-06 16:53:31 NULL NULL 가장 NULL 장문호(부인) 1905-03-31 NULL NULL 1193 Chang 장 Moon Ho 문호 26 12
CClRYOLWRi2ZAF6ocYS01g Kim, Kwang Yong 23 23세 widower Chong Soo 3/31/1905 Manchuria 김광용 김광용 NULL 김Kwang Yong 2025-09-14 05:57:44 2025-12-06 16:53:31 NULL NULL 가장 NULL 김현중(부인), 김봉상(부인), 김봉상(아들), 김봉상(아들), 김봉상(아들) 1905-03-31 NULL NULL 1192 Kim 김 Kwang Yong 광용 23 12
CCEuZOiGQ8SKnthIHwxQxA Pak, Soon Kyung 21 21세 married Seoul 10/5/1903 Siberia 박순경 NULL 박Soon Kyung 2025-09-14 05:57:45 2025-12-06 16:53:31 박순갱,박순켱 90 가장 NULL 박연황(아들) 1903-10-05 NULL NULL 18 Pak 박 Soon Kyung 순경 21 17
cC2KinelTkeifn-KDWFz-g Ye, Sool Ye 27 27세 single Yern Am 2/13/1905 Siberia 이술예 NULL 예Sool Ye 2025-09-14 05:57:46 2025-12-06 16:53:31 예숙예,예슬예 70 가장 NULL 이종현(아들) 1905-02-13 NULL NULL 1191 Ye 이 Sool Ye 술예 27 17
CC2AsUrUQ7qwEvCzZj.tmg No, Heung Keun 39 39세 married Oh Ma Tong 3/30/1904 Korea 노흥근 NULL NoHeung Keun 2025-09-14 05:57:45 2025-12-06 16:53:31 노홍근,노흥건 95 가장 NULL 서흥춘(부인), 노흥근(아들), 노흥근(아들), 노흥근(딸) 1904-03-30 NULL NULL 879 No 노 Heung Keun 흥근 39 9
cbWy99z0S3GpXSgDTa-0iw Ye, Seung Kap, son (Pok Yong) 8 8세 single Dong Sal Li 9/26/1904 Mongolia 이승갑 NULL 예son (Pok Yong) 2025-09-14 05:57:46 2025-12-06 10:50:50 예성갑,예승각 85 아들 Pok Yong 복용 1904-09-26 NULL NULL 356 Ye 이 Seung Kap 승갑 8 14
cbtUohNsQpmLm6QkRS7pKg Pak, Ki Chang 33 33세 married Dong Moon Li 5/8/1905 Siberia 박기창 NULL 박Ki Chang 2025-09-14 05:57:45 2025-12-10 04:34:46 박기장,박기창 95 가장 NULL 박기창의 처(부인), 박치용(아들), 박지용(딸) 1905-05-08 NULL NULL 1190 Pak 박 Ki Chang 기창 33 17
cbTUEcj2QC24Vt5rU0.xTQ Kim, Kyeng Soon 30 30세 married Nak Saing Li 8/22/1904 Coptic 김경순 김경순 NULL 김경순 2025-09-14 05:57:44 2025-12-10 04:59:17 NULL NULL 가장 NULL 김경순의 처(부인), 김경순의 처(부인), 김씨의 자(아들), 김씨의 녀(딸) 1904-08-22 NULL NULL 79 Kim 김 Kyeng Soon 경순 30 4
CbrtxqWVQUS7PvCjKztGcw Pak, Myeng Choon, wife 17 17세 married Eun Sung Ri 11/18/1904 Korea 박처 박처 NULL 박wife 2025-09-14 05:57:45 2025-12-06 10:50:50 NULL NULL 부인 NULL NULL 1904-11-18 NULL NULL 1189 Pak 박 Myeng Choon 처 17 9
cboVL8FLTCyFwZy5838tzw Im, Eung Sun 25 25세 married Chung Song Li 2/25/1905 Mongolia 임응선 NULL 임Eung Sun 2025-09-14 05:57:43 2025-12-06 10:50:50 임응순,임웅선 90 NULL NULL NULL 1905-02-25 NULL NULL 1188 Im 임 Eung Sun 응선 25 14
cBkb5oj3SFOz6.Qi4wIY8A Hong, Chan Suk 19 19세 single Sin Hyeng Li 4/24/1905 Coptic 홍찬숙 홍찬숙 NULL 홍Chan Suk 2025-09-14 05:57:43 2025-12-06 10:50:50 NULL NULL NULL NULL NULL 1905-04-24 NULL NULL 1187 Hong 홍 Chan Suk 찬숙 19 4
CBIKAHCrTrOrOxxi7hrr4w Sin, Kang Choon, son 9 9세 single Sam Soo Dong 12/9/1904 Mongolia 신자 신자 NULL 신son 2025-09-14 05:57:45 2025-12-06 10:50:50 NULL NULL 아들 NULL NULL 1904-12-09 NULL NULL 1186 Sin 신 Kang Choon 자 9 14
cbFn18cDQr29xiIKJc2fRw Kim, Hak Pong 25 25세 widower Hap Chun 4/10/1904 Gaelic 김학봉 NULL 김Hak Pong 2025-09-14 05:57:44 2025-12-06 10:50:50 김학방,김혁봉 90 NULL NULL NULL 1904-04-10 NULL NULL 1185 Kim 김 Hak Pong 학봉 25 7
cbf0DwmCSEyg-nXCQJDPCQ Choon, Nak Choon 34 34세 married Duk Won 3/4/1904 Siberia 춘낙춘 춘낙춘 NULL ChoonNak Choon 2025-09-14 05:57:43 2025-12-06 16:53:31 NULL NULL 가장 NULL 전낙춘(부인), 춘낙춘(아들), 춘낙춘(아들), 춘낙춘(아들) 1904-03-04 NULL NULL 863 Choon 춘 Nak Choon 낙춘 34 17
cauQ9cZxQOSlW.WI6wRQXg Ye, Chai Sun 24 24세 married San Sung 2/2/1905 Coptic 이채선 NULL 예Chai Sun 2025-09-14 05:57:45 2025-12-06 10:50:50 예차선,예채순 85 NULL NULL NULL 1905-02-02 NULL NULL 1184 Ye 이 Chai Sun 채선 24 4