Korea Retail & Delivery Risk Detection Index
Tables (6)
event_label_daily
- voc_date — DATE — Foreign key → voc_daily.voc_date
- label_7d — TINYINT(1) — NOT NULL
- is_voc_spike_today — TINYINT(1) — NOT NULL
- voc_spike_threshold — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
feature_daily
- voc_date — DATE — Foreign key → voc_daily.voc_date
- voc_7d_sum_past — INT — NOT NULL
- voc_30d_sum_past — INT — NOT NULL
- voc_7d_30d_ratio — DECIMAL(10,4) — NOT NULL
- dow — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
model_metadata
- model_version — VARCHAR(64)
- trained_at — DATETIME — NOT NULL
- train_start_date — DATE
- train_end_date — DATE
- algorithm — VARCHAR(64) — NOT NULL
- roc_auc — DECIMAL(4,3)
- note — VARCHAR(255)
rdi_result_daily
- voc_date — DATE — Foreign key → voc_daily.voc_date — NOT NULL
- model_version — VARCHAR(64) — Foreign key → model_metadata.model_version — NOT NULL
- prob_7d_risk — DECIMAL(6,5) — NOT NULL
- rdi_score — DECIMAL(5,2) — NOT NULL
- label_7d — TINYINT(1)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
review_raw
- review_id — BIGINT
- original_review_id — VARCHAR(128)
- review_date — DATE — NOT NULL
- review_datetime — DATETIME
- rating — TINYINT — NOT NULL
- review_text — TEXT
- channel — VARCHAR(64)
- user_name — VARCHAR(128)
- thumbs_up_count — INT
- reply_text — TEXT
- reply_datetime — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- INDEX — idx_review_date
- INDEX — idx_rating
- INDEX — idx_channel
voc_daily
- voc_date — DATE
- total_review_cnt — INT — NOT NULL
- voc_cnt — INT — NOT NULL
- voc_ratio — DECIMAL(6,4) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL