데이터베이스

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
QM6.TdzFRTimSQ2dL1Y78A Her, Surp, wife 21 21세 married Cha Sam 2/8/1904 China 허섭 NULL Herwife 2025-09-14 05:57:43 2025-12-06 10:50:50 허습,허십 75 부인 NULL NULL 1904-02-08 NULL NULL 2125 Her 허 Surp 섭 21 3
qLwjIM6ITe6DEOBKkqTXSA Kim, Woon Ho 19 19세 single Woon San 8/11/1904 Siberia 김운호 NULL 김Woon Ho 2025-09-14 05:57:44 2025-12-10 04:59:17 김운하,김문호 90 가장 NULL 김운호의 처(부인), 김성조(어머니), 김씨의 자(아들) 1904-08-11 NULL NULL 1275 Kim 김 Woon Ho 운호 19 17
qlgDKn3aRHieKByaOy4wyg Chun, Kyeng Soh 30 30세 widower Mok Chang Ye 5/29/1905 China 천경소 NULL 전Kyeng Soh 2025-09-14 05:57:43 2025-12-06 10:50:50 전경소,천경수 85 NULL NULL NULL 1905-05-29 NULL NULL 2664 Chun 천 Kyeng Soh 경소 30 3
qL00nUUlQdmJjfhS0LMeXA Song, Sung Moon 26 26세 single Soo Myen 1/6/1905 Doric 송성문 송성문 NULL 송Sung Moon 2025-09-14 05:57:45 2025-12-06 10:50:50 NULL NULL NULL NULL NULL 1905-01-06 NULL NULL 2663 Song 송 Sung Moon 성문 26 6
QKZrvGg0SI2MBjXcG4kkHw Hong, Chai Sung 28 28세 married Ko Yang 3/30/1903 Gaelic 홍재성 NULL 홍Chai Sung 2025-09-14 05:57:43 2025-12-06 10:50:50 홍채성,홍재승 88 NULL NULL NULL 1903-03-30 NULL NULL 1370 Hong 홍 Chai Sung 재성 28 7
QKytXc6.TDebwxXfxILaJw Choi, Loo Ok 23 23세 single Tai Tong, Toya Mun Ni 6/1/1904 Coptic 최루옥 NULL 최Loo Ok 2025-09-14 05:57:43 2025-12-10 04:34:46 최로옥,최루억 80 가장 NULL 최루옥의 처(부인), 최춘여(아들), 최춘열(아들), 최춘열(아들), 최춘열(아들) 1904-06-01 NULL NULL 2662 Choi 최 Loo Ok 루옥 23 4
QKwJ7ChmR56kyawnZnnMnw Kim, Moon Sork 27 27세 married Pong Heung Kyo 1/26/1905 Korea 김문석 NULL 김Moon Sork 2025-09-14 05:57:44 2025-12-10 04:59:17 김문설,김문숙 88 가장 NULL 김문석의 처(부인), 김씨의 자(아들) 1905-01-26 NULL NULL 2661 Kim 김 Moon Sork 문석 27 9
QKqICe47TLemHGamj8VWRA Hong, Sung Chip 28 28세 widower Dong San Pyeng 3/31/1905 Manchuria 홍성집 NULL 홍Sung Chip 2025-09-14 05:57:43 2025-12-06 10:50:50 홍성칩,홍승집 85 NULL NULL NULL 1905-03-31 NULL NULL 2660 Hong 홍 Sung Chip 성집 28 12
qKNcfIvvS7Cvu.hYD3qOKA Kim, Ye Cho 26 26세 married Nam San 1/26/1905 Korea 김예조 NULL 김Ye Cho 2025-09-14 05:57:44 2025-12-10 04:59:17 김예초,김예조 80 가장 NULL 김예조의 처(부인), 김씨의 자(아들) 1905-01-26 NULL NULL 20 Kim 김 Ye Cho 예조 26 9
qkMCvnrpSxO9aWhcxnO1rg Chang, Chai On 23 23세 single Kai Ryoung 7/30/1904 Doric 장재온 NULL 장Chai On 2025-09-14 05:57:42 2025-12-06 10:50:50 장채온,장재언 85 NULL NULL NULL 1904-07-30 NULL NULL 2659 Chang 장 Chai On 재온 23 6
QkF2cULmTP6n6SVTMY7BWQ Sin, Chi Woon, son 10 10세 single Sa 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 62 Sin 신 Chi Woon 자 10 14
qk9xI9-cRRSj.pz.A5oNmg Kim, Chong Ok, wife (Song See) 32 32세 married Pyeng Yang 4/14/1903 China 김종옥 NULL 김wife (Song See) 2025-09-14 05:57:44 2025-12-06 10:50:50 김정옥,김종억 88 부인 Song See 송서 1903-04-14 NULL NULL 58 Kim 김 Chong Ok 종옥 32 3
QK9FHYV.TgyRz2rAgyZ78w Ye, Youn Kiu 32 32세 married Youl Li 4/24/1905 Coptic 이윤규 NULL 예Youn Kiu 2025-09-14 05:57:46 2025-12-10 04:33:32 예연규,예윤기 88 가장 NULL 염덕연(부인), 이윤규의 처(부인), 염덕윤(아들) 1905-04-24 NULL NULL 2658 Ye 이 Youn Kiu 윤규 32 4
QjxSKlIARKq9LxZ3nw2xaQ Chung, Chang Ho 27 27세 married Song Am 11/2/1904 Manchuria 정창호 정창호 NULL 정Chang Ho 2025-09-14 05:57:43 2025-12-06 10:50:50 NULL NULL NULL NULL NULL 1904-11-02 NULL NULL 95 Chung 정 Chang Ho 창호 27 12
QjpL6ZBLTJqQLr4o0KrVfg No, Chung Chan 33 33세 widower Kwan Chun Li 11/2/1904 Manchuria 노중찬 NULL NoChung Chan 2025-09-14 05:57:45 2025-12-06 10:50:50 노정찬,노중천 88 NULL NULL NULL 1904-11-02 NULL NULL 2657 No 노 Chung Chan 중찬 33 12
qjoQKSFNQqq4GvsbgNzQ6A Ye, Wan Young 29 29세 married Sam Wha 11/18/1903 Hongkong Maru 이완영 NULL 예Wan Young 2025-09-14 05:57:46 2025-12-06 10:50:50 예만영,예완용 85 NULL NULL NULL 1903-11-18 NULL NULL 213 Ye 이 Wan Young 완영 29 8
Qjk0yrDnT.qyVT7EGvEzcw Ye, Chi Kwan 27 27세 married Pal Dang 1/26/1905 Korea 이치관 NULL 예Chi Kwan 2025-09-14 05:57:46 2025-12-10 04:33:41 예지관,예치완 88 가장 NULL 이치관의 처(부인), 이치관의 처(부인), 이치관의 처(부인), 이치관의 자(아들), 이치관의 자(아들), 이치관의 자(아들), 이치관의 녀(딸) 1905-01-26 NULL NULL 2656 Ye 이 Chi Kwan 치관 27 9
qJgaUmvJToKD7bo7oRXjIQ Kim, Youn Chong, wife 40 40세 married Woal Chool Dong 5/8/1905 Siberia 김처 김처 NULL 김wife 2025-09-14 05:57:44 2025-12-06 10:50:50 NULL NULL 부인 NULL NULL 1905-05-08 NULL NULL 680 Kim 김 Youn Chong 처 40 17
qJdvhCrGQQKcGDWZpU2iGQ Chung, Sang Won 27 27세 married Il Dong 4/13/1905 Korea 정상원 정상원 NULL 정Sang Won 2025-09-14 05:57:43 2025-12-10 04:34:41 NULL NULL 가장 NULL 정상원의 처(부인), 정치영(어머니), 정경호(아들), 정경호(아들), 정치영(형제) 1905-04-13 NULL NULL 229 Chung 정 Sang Won 상원 27 9
qJBwbAl.STinMQddO2VDFA Ye, Wha Ok, daughter 2 (Sun Ye) 5 5세 single Pi Chi Kol 11/2/1904 Manchuria 이화옥 NULL 예daughter 2 (Sun Ye) 2025-09-14 05:57:46 2025-12-06 10:50:50 예와옥,예화억 85 딸 Sun Ye 순예 1904-11-02 NULL NULL 537 Ye 이 Wha Ok 화옥 5 12