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