csv,ai

Tables (5)

column_stats

  • id — BIGINT — Primary key — NOT NULL
  • report_id — BIGINT — Foreign key → diagnose_reports.id — NOT NULL
  • col_name — VARCHAR(255)
  • data_type — VARCHAR(50) — numeric | categorical | datetime ...
  • missing_count — INT
  • missing_pct — DOUBLE
  • outlier_count — INT
  • quality_status — VARCHAR(10) — good | warn | bad
  • stats_json — TEXT — 상세 통계 JSON (min/max/mean/median/std 등)

diagnose_reports

  • id — BIGINT — Primary key — NOT NULL
  • file_id — BIGINT — Foreign key → uploaded_files.id — NOT NULL
  • quality_score — INT
  • ai_comment — TEXT — EXT COMMENT 'GPT 생성 진단 요약 (JSON string)
  • created_at — DATETIME — NOT NULL

preprocess_configs

  • id — BIGINT — Primary key — NOT NULL
  • file_id — BIGINT — Foreign key → uploaded_files.id — NOT NULL
  • col_name — VARCHAR(255)
  • missing_method — VARCHAR(50) — median | mean | mode | fixed | drop | keep
  • outlier_method — VARCHAR(50) — clip-iqr | clip-zscore | remove | keep
  • scaling_method — VARCHAR(50) — none | minmax | zscore | log | sqrt
  • fixed_value — VARCHAR(255)

uploaded_files

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • filename — VARCHAR(255) — NOT NULL
  • file_path — VARCHAR(500)
  • file_size — BIGINT
  • row_count — INT
  • col_count — INT
  • encoding — VARCHAR(50)
  • status — VARCHAR(20) — UPLOADED | DIAGNOSING | DIAGNOSED | PROCESSING | DONE | ERROR
  • processed_path — VARCHAR(500)
  • created_at — DATETIME — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255)
  • avatar_url — VARCHAR(500)
  • provider — VARCHAR(20) — NOT NULL — google | github | email
  • provider_id — VARCHAR(255)
  • password — VARCHAR(255)
  • role — VARCHAR(10) — NOT NULL — USER | ADMIN
  • created_at — DATETIME — NOT NULL