컬럼 구조
id int
table_name varchar(100)
display_name varchar(200)
display_name_en varchar(200)
category varchar(50)
search_fields text
display_fields text
primary_field varchar(100)
date_field varchar(100)
description text
icon varchar(50)
is_active tinyint(1)
auto_discovered tinyint(1)
priority int
created_at timestamp
updated_at timestamp
| id | table_name | display_name | display_name_en | category | search_fields | display_fields | primary_field | date_field | description | icon | is_active | auto_discovered | priority | created_at | updated_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8 | archive_statistics | Statistics | NULL | statistics | ["table_name"] | ["table_name","record_count","last_updated"] | table_name | last_updated | NULL | 📁 | 1 | 1 | 100 | 2025-09-28 01:30:49 | 2025-09-28 01:30:49 |
| 7 | archive_ships | Ships | NULL | ships | ["ship_manifest_name","arrival_age","age_display","marital_status","departure_residence","departure_ | ["ship_manifest_name","korean_name","ship_name","arrival_age","age_display"] | ship_manifest_name | departure_date | NULL | 🚢 | 1 | 1 | 100 | 2025-09-28 01:30:49 | 2025-09-28 01:30:49 |
| 6 | archive_search_view | Search View | NULL | search | ["source_table","title","content","category","names"] | ["title","names","source_table","content","date_field"] | title | date_field | NULL | 📁 | 1 | 1 | 100 | 2025-09-28 01:30:49 | 2025-09-28 01:30:49 |
| 5 | archive_search_cache | Search Cache | NULL | search | ["search_keyword","source_type","source_id","original_title","original_content","ai_summary","ai_tra | ["original_title","search_keyword","source_type","source_id","original_content"] | original_title | original_date | NULL | 📁 | 1 | 1 | 100 | 2025-09-28 01:30:49 | 2025-09-28 01:30:49 |
| 4 | archive_picturebrides | Picturebrides | NULL | picturebrides | ["passport_applicant","korean_name","residence","relation","companion_chinese_name","passport_name", | ["korean_name","korean_name","passport_applicant","residence","relation"] | korean_name | date_issued | NULL | 👰 | 1 | 1 | 100 | 2025-09-28 01:30:49 | 2025-09-28 01:30:49 |
| 3 | archive_patriots | Patriots | NULL | patriots | ["name","management_no","other_names","origin","honor_year","movement_type","achievements","tag_1st_ | ["name","management_no","other_names","origin","honor_year"] | name | auto_update_time | NULL | 🎖️ | 1 | 1 | 100 | 2025-09-28 01:30:49 | 2025-09-28 01:30:49 |
| 2 | archive_media | Media | NULL | media | ["category","title","names_extracted","overview","image_source_2","photo_year","thumbnail_1","thumbn | ["title","names_extracted","category","overview","image_source_2"] | title | update_date | NULL | 📷 | 1 | 1 | 100 | 2025-09-28 01:30:49 | 2025-09-28 01:30:49 |
| 1 | archive_kungmin | Kungmin | NULL | kungmin | ["newspaper_name","article_title","article_content","additional_info","thumbnail_image","original_sc | ["article_title","newspaper_name","article_title","publication_date","article_content"] | article_title | publication_date | NULL | 📰 | 1 | 1 | 100 | 2025-09-28 01:30:49 | 2025-09-28 01:30:49 |