컬럼 구조
id varchar(50)
category varchar(50)
title varchar(500)
names_extracted text
overview text
image_source_2 varchar(500)
photo_year varchar(20)
thumbnail_1 varchar(500)
thumbnail_2 varchar(500)
tags_combined text
update_date datetime
tag_first varchar(100)
video_link varchar(500)
tag_second varchar(100)
additional_info text
tag_third varchar(100)
file_link varchar(500)
creation_date datetime
image_source_1 varchar(500)
private_check varchar(20)
source varchar(200)
page_no varchar(50)
source_2 varchar(200)
created_at timestamp
updated_at timestamp
google_url_backup varchar(500)
photo_year_parsed int
photo_decade varchar(10)
photo_date_approx varchar(20)
person_count int
has_ship_link tinyint(1)
has_patriot_link tinyint(1)
runway_video_url varchar(500)
| id | category | title | names_extracted | overview | image_source_2 | photo_year | thumbnail_1 | thumbnail_2 | tags_combined | update_date | tag_first | video_link | tag_second | additional_info | tag_third | file_link | creation_date | image_source_1 | private_check | source | page_no | source_2 | created_at | updated_at | google_url_backup | photo_year_parsed | photo_decade | photo_date_approx | person_count | has_ship_link | has_patriot_link | runway_video_url |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0oVSL6NHRSmn0zSj1DzqYQ | 사진 | 와이알루아 사진 신부. 왼쪽에서 첫번째 Hannah Park Lee, 두 번째 이봉애(Bong Ae Lee). 1918년. 조나 리(Jonah Lee) 앨범. | Hannah Park Lee, 이봉애(Bong Ae Lee), 조나 리(Jonah Lee) | NULL | media/roberta-jang/original/zTDAkGqSvuAxV0YY2aGQ.jpg | NULL | media/roberta-jang/thumbs/zTDAkGqSvuAxV0YY2aGQ.jpg | media/roberta-jang/thumbs/zTDAkGqSvuAxV0YY2aGQ.jpg | NULL | 2025-04-16 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-09-14 05:59:58 | 2025-12-06 11:10:30 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/zTDAkGqSvu | 1918 | NULL | NULL | 3 | 0 | 0 | NULL |
| 0nzHnIL9Q7vNpN5sh03t | 사진 | NULL | NULL | NULL | media/salome-choehan/original/0nzHnIL9Q7vNpN5sh03t.jpg | NULL | media/salome-choehan/thumbs/0nzHnIL9Q7vNpN5sh03t.jpg | NULL | NULL | NULL | NULL | NULL | NULL | 00009.JPG | NULL | NULL | NULL | NULL | unidentified | 살로메최한 | NULL | JOEL PAHK | 2025-12-31 11:41:10 | 2025-12-31 11:41:10 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | NULL |
| 0mMbLYM8Q7qg0K2EPF.cBQ | 사진 | 1973년 7월 임재길 가족이 하와이에서 다시 만났다. 임옥정(Rona Ok Chung Lim)은 호텔 서비스 도우미로 일하여 수입을 보태었다. Robin Lee 사진. | 임재길, 임옥정, Robin Lee | NULL | media/roberta-jang/original/GZICF55Nb2IzpclUjVSX.jpg | NULL | media/roberta-jang/thumbs/GZICF55Nb2IzpclUjVSX.jpg | media/roberta-jang/thumbs/GZICF55Nb2IzpclUjVSX.jpg | NULL | 2025-04-19 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-09-14 05:59:58 | 2025-12-06 11:10:30 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/GZICF55Nb2 | 1973 | NULL | NULL | 3 | 0 | 0 | NULL |
| 0j504q9N0BOIoFOLsoPa | 사진 | NULL | NULL | NULL | media/salome-choehan/original/0j504q9N0BOIoFOLsoPa.jpg | NULL | media/salome-choehan/thumbs/0j504q9N0BOIoFOLsoPa.jpg | NULL | NULL | NULL | NULL | NULL | NULL | 00014.JPG | NULL | NULL | NULL | NULL | unidentified | 살로메최한 | NULL | JOEL PAHK | 2025-12-31 11:41:10 | 2025-12-31 11:41:10 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | NULL |
| 0iOAi3ZqQaGVTiuLMEepcA | 사진 | 안정송(Chung Song)과 안원규(Won Kiu Ahn) 결혼식. 1912년경. Xander Cintron-Chai 앨범. | 안정송, 안원규 | NULL | media/roberta-jang/original/Ym0Wdn94aQRgYaKfD0OW.jpg | NULL | media/roberta-jang/thumbs/Ym0Wdn94aQRgYaKfD0OW.jpg | media/roberta-jang/thumbs/Ym0Wdn94aQRgYaKfD0OW.jpg | NULL | 2025-04-17 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-09-14 05:59:58 | 2025-12-06 11:11:47 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/Ym0Wdn94aQ | 1912 | NULL | 1912년경 | 2 | 1 | 1 | NULL |
| 0d8JXWnEQFiajz47oWN7ww | 사진 | 홍과 민 가족. 왼쪽부터, 민찬호(Chan Ho Min), 마조리 홍(Marjorie Hong, 홍인택 부인), 몰리 홍 민 (Mollie Hong Min, 민찬호 부인 · 홍인택 | 민찬호 (Chan Ho Min), 마조리 홍 (Marjorie Hong), 몰리 홍 민 (Mollie Hong Min), 애굔 김 홍 (Agyon Kim Hong), 홍인택, 홍치 | NULL | media/roberta-jang/original/74FhSFSeKOWvdhqgxbMU.jpg | NULL | media/roberta-jang/thumbs/74FhSFSeKOWvdhqgxbMU.jpg | media/roberta-jang/thumbs/74FhSFSeKOWvdhqgxbMU.jpg | NULL | 2025-04-16 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-09-14 05:59:58 | 2026-01-01 09:43:09 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/74FhSFSeKO | 1915 | NULL | 1915년경 | 6 | 1 | 1 | NULL |
| 0CiVS2idTWemsBqA4dUrXg | 사진 | 아담 리. 1930년대 경. Richard Lee and Annie Lee Tom 앨범. | 아담 리 | NULL | media/roberta-jang/original/DwIQzvkLwtm7ZVj3so0T.jpg | NULL | media/roberta-jang/thumbs/DwIQzvkLwtm7ZVj3so0T.jpg | media/roberta-jang/thumbs/DwIQzvkLwtm7ZVj3so0T.jpg | NULL | 2025-04-17 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-09-14 05:59:58 | 2025-12-06 11:10:31 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/DwIQzvkLwt | 1930 | 1930년대 | NULL | 1 | 0 | 0 | NULL |
| 07542e2b-b919-4d94-8036-ac389efbbde7 | PDF 색인 | Dongji Hoi Records (동지회 기록) | 이승만 (Syngman Rhee, 동지회 창립), 안현경 (1921 동지회 창립, 국민보 주필), 이종관 (1921 동지회 임원), 이병억 (동지회 창립회원), 김윤배 (1921 | 하와이대학교 한국학연구소 특별컬렉션. 참조번호: AM-002. 16페이지. | NULL | 1921-현재 | /kimmigration/assets/pdf-icon.svg | NULL | McCune, photo, Syngman Rhee, college, family, correspondence, funeral, Honolulu, Korea, church, news | NULL | NULL | NULL | NULL | NULL | NULL | https://park.cartooncampus.com/kimmigration/media/hawaii-uh-ks/002-Dongji-Hoi-Records-List_2021updat | NULL | NULL | document | 하와이대 한국학연구소 | NULL | NULL | 2026-01-01 07:08:38 | 2026-01-22 01:10:04 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | NULL |