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