데이터베이스

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
lJMjyPKfRUKOK4zIGONzXw Kim, Won Taik, son (Yong Sei) 8 8세 single Sang Soo Koo Pak 5/8/1905 Siberia 김원택 NULL 김son (Yong Sei) 2025-09-14 05:57:44 2025-12-06 10:50:50 김원탁,김원태 90 아들 Yong Sei 용세 1905-05-08 NULL NULL 318 Kim 김 Won Taik 원택 8 17
LiZ2gI6NRp-pjJsq8TSuBA Ye, Doo Chan 22 22세 married Yerk Dong 3/31/1905 Manchuria 이두찬 NULL 예Doo Chan 2025-09-14 05:57:46 2025-12-06 16:53:31 예도찬,예두천 88 가장 NULL 이창근(아들) 1905-03-31 NULL NULL 2189 Ye 이 Doo Chan 두찬 22 12
Lit2gbtZTpe9Gf-TSj5E.g Kim, Dal Ye 23 23세 single Pyeng Yang 3/19/1903 Korea 김달예 김달예 NULL 김Dal Ye 2025-09-14 05:57:44 2025-12-06 10:50:50 NULL NULL NULL NULL NULL 1903-03-19 NULL NULL 58 Kim 김 Dal Ye 달예 23 9
LiRbvVnaRAePLPLN0q.WvA Chung, Chil Dai 24 24세 widower You Pyeng 11/24/1904 Gaelic 정칠대 NULL 정Chil Dai 2025-09-14 05:57:43 2025-12-06 10:50:50 정칠데,정칠태 90 NULL NULL NULL 1904-11-24 NULL NULL 2188 Chung 정 Chil Dai 칠대 24 7
lIQmW8.SRA-eHN4Ky7SeZg Chung, Heui Kyeng 31 31세 married Dol Ma Deul 5/29/1905 China 정희경 NULL 정Heui Kyeng 2025-09-14 05:57:43 2025-12-06 10:50:50 정희겸,정희근 88 NULL NULL NULL 1905-05-29 NULL NULL 2187 Chung 정 Heui Kyeng 희경 31 3
liKuFXY8Sf2vK3VpT2bcIg No, Heung Keun, wife (Soh, Hung Chun) 25 25세 married Oh Ma Tong 3/30/1904 Korea 서흥춘 NULL NoHung Chun) 2025-09-14 05:57:45 2025-12-06 10:50:50 서흥천,서흥준 85 부인 Soh, Hung Chun 서흥춘 1904-03-30 NULL NULL 879 No 서 Heung Keun 흥춘 25 9
lIhXVplhRs-LZMflNQDlOQ Ye, Seung Choo 33 33세 married In Chun, Yong Im 4/10/1904 Gaelic 이승주 NULL 예Seung Choo 2025-09-14 05:57:46 2025-12-06 10:50:50 예승추,예승조 88 NULL NULL NULL 1904-04-10 NULL NULL 2186 Ye 이 Seung Choo 승주 33 7
LiEm3fAaTI6VZjsBbojjlQ Choi, Won Sik 24 24세 single Seoul 1/23/1904 Gaelic 최원식 최원식 NULL 최Won Sik 2025-09-14 05:57:43 2025-12-06 10:50:50 NULL NULL NULL NULL NULL 1904-01-23 NULL NULL 18 Choi 최 Won Sik 원식 24 7
lhYLasygS5-XkZ7BCUrj7Q Her, Choon Ye 37 37세 single Han Sil Dong 10/17/1904 Doric 허춘예 NULL HerChoon Ye 2025-09-14 05:57:43 2025-12-06 10:50:50 허춘예,허춘례 85 NULL NULL NULL 1904-10-17 NULL NULL 2185 Her 허 Choon Ye 춘예 37 6
LhYKYdaMQR6GkUy9lfqxIQ Chang, Keun Choon 20 20세 married Po Eun 7/8/1904 Mongolia 장근춘 장근춘 NULL 장Keun Choon 2025-09-14 05:57:43 2025-12-06 10:50:50 NULL NULL NULL NULL NULL 1904-07-08 NULL NULL 97 Chang 장 Keun Choon 근춘 20 14
lhvFq1MKTSuV.fkfDvzNHg Ye, Loo Won 40 40세 married Seoul 5/20/1904 Siberia 이루원 NULL 예Loo Won 2025-09-14 05:57:46 2025-12-06 16:53:31 예노원,예로원 80 가장 NULL 이창근(부인), 이춘익(부인), 이경식(부인), 이창근(아들), 이춘익(아들), 이창근(아들) 1904-05-20 NULL NULL 18 Ye 이 Loo Won 루원 40 17
LHtXoozoRbGOAeuFsYVS9A Cha, Keun Yeap 29 29세 married Cha Rai Kok 2/2/1905 Coptic 차근엽 NULL 차Keun Yeap 2025-09-14 05:57:42 2025-12-06 10:50:50 차근업,차큰엽 88 NULL NULL NULL 1905-02-02 NULL NULL 2184 Cha 차 Keun Yeap 근엽 29 4
LhQ8QiIZSJybvGy6JTMXlw Pyen, Wha Kyum 27 27세 married Do Chun 5/18/1905 Mongolia 편화겸 NULL PyenWha Kyum 2025-09-14 05:57:45 2025-12-06 10:50:50 변화겸,편화검 85 NULL NULL NULL 1905-05-18 NULL NULL 1343 Pyen 편 Wha Kyum 화겸 27 14
LHopJ.OcQWmIV4t6vdOr8Q Choo, Sung Soo 35 35세 married Kyeng Choo 11/2/1903 Korea 제리추 추승수 Choo성수 경주 2025-03-05 00:00:00 ChooSung Soo 푸우위키 https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/p1c2Pa8esh 제리추 2025-09-14 05:57:43 2025-12-06 16:53:31 NULL NULL 가장 NULL 주성수(부인), 주성수(아들), 주성수(딸) 1903-11-02 NULL NULL 163 Choo 추 Sung Soo 승수 35 9
lH9JyCn7Rbe9H-4WuJSqaA Cho, Ik Surp 27 27세 married Hai Choo, Chul Kol 6/1/1904 Coptic 조익섭 NULL 조Ik Surp 2025-09-14 05:57:43 2025-12-10 04:59:06 조익습,조이섭 88 가장 NULL 조익습(부인), 최씨 부인, 최춘여(아들), 최춘열(아들), 조한식(아들), 최춘열(아들), 최춘열(아들), 조익섭(딸) 1904-06-01 NULL NULL 1148 Cho 조 Ik Surp 익섭 27 4
lH7lNflvSVyoWroUhVqJ-Q Pak, Chung Hoon, mom 43 43세 widow Sam Wha 12/5/1903 Doric 박정훈 NULL 박mom 2025-09-14 05:57:45 2025-12-10 04:59:17 박정운,박정흔 92 가장 NULL 박정훈의 처(부인), 박정훈의 처(부인), 박정훈의 처(부인), 박씨의 자(아들), 박씨의 녀(딸) 1903-12-05 NULL NULL 213 Pak 박 Chung Hoon 정훈 43 6
LGYk7srzS8W5a0fnbStePQ Choi, Seung Chan 28 28세 married Nam San Dong 5/29/1905 China 최승찬 최승찬 NULL 최Seung Chan 2025-09-14 05:57:43 2025-12-10 04:34:41 NULL NULL 가장 NULL 최승찬의 처(부인), 최승찬의 처(부인) 1905-05-29 NULL NULL 472 Choi 최 Seung Chan 승찬 28 3
LgxP3quNRiS1RcJNB5kRZA Kim, Kei Kap 21 21세 single Chung Choo 7/11/1904 America Maru 김계갑 NULL 김Kei Kap 2025-09-14 05:57:44 2025-12-10 04:59:27 김기갑,김계금 88 가장 NULL 김계갑의 처(부인), 김계갑의 처(부인), 김재근(어머니), 김씨의 자1(아들), 김씨의 자2(아들), 김씨의 자2(아들), 김씨의 자1(아들) 1904-07-11 NULL NULL 23 Kim 김 Kei Kap 계갑 21 1
lgwbJvPxRVmOrGkmeJDQkw Pak, Kyeng Sik 27 27세 single Won Doo Kol 2/13/1905 Siberia 박경식 박경식 NULL 박Kyeng Sik 2025-09-14 05:57:45 2025-12-06 10:50:50 NULL NULL NULL NULL NULL 1905-02-13 NULL NULL 2183 Pak 박 Kyeng Sik 경식 27 17
lGt-JaTOR.2lcSIXhjmmIg Kong, Pong Cho 30 30세 widower Song Chung 4/13/1905 Korea 공봉조 NULL KongPong Cho 2025-09-14 05:57:45 2025-12-06 10:50:50 공봉초,공방조 88 NULL NULL NULL 1905-04-13 NULL NULL 2182 Kong 공 Pong Cho 봉조 30 9