archive_submissions - 데이터 관리

id int · PK · NOT NULL · AUTO

target_table enum('archive_ships','archive_patriots','archive_media','archive_kungmin','archive_picturebrides') · NOT NULL

target_id varchar(50) · NOT NULL

submission_type enum('correction','addition') · NOT NULL

field_name varchar(100) · NULL

original_value text · NULL

suggested_value text · NOT NULL

reason text · NULL

source_reference text · NULL

attachments json · NULL

submitted_by int · NOT NULL

submitted_at timestamp · NULL

status enum('pending','reviewing','approved','rejected','merged') · NULL

reviewed_by int · NULL

reviewed_at timestamp · NULL

admin_notes text · NULL

rejection_reason text · NULL

merged_at timestamp · NULL

merge_log json · NULL

K이민사 아카이브