데베설
테이블 (8)
dataset_columns
- column_id — INT — 기본 키 — NOT NULL
- dataset_id — INT — 외래 키 → datasets.dataset_id — NOT NULL
- column_name — VARCHAR(200)
- data_type — VARCHAR(50)
- missing_count — INT
- unique_count — INT
- summary_stats — TEXT
- created_at — DATETIME
datasets
- dataset_id — INT — 기본 키 — NOT NULL
- user_id — VARCHAR(50) — 외래 키 → users.user_id — NOT NULL
- name — VARCHAR(200)
- description — TEXT
- file_path — VARCHAR(255)
- profile_image_url — VARCHAR(255)
- rows_count — INT
- columns_count — INT
- status — VARCHAR(20)
- created_at — DATETIME
- updated_at — DATETIME
predictions
- prediction_id — INT — 기본 키 — NOT NULL
- run_id — INT — 외래 키 → project_runs.run_id — NOT NULL
- record_index — INT
- input_values — TEXT
- predicted_value — DECIMAL(10,2)
- actual_value — DECIMAL(10,2)
- timestamp — DATETIME
project_runs
- run_id — INT — 기본 키 — NOT NULL
- project_id — INT — 외래 키 → projects.project_id — NOT NULL
- run_type — VARCHAR(20)
- algorithm — VARCHAR(100)
- parameters — TEXT
- status — VARCHAR(20)
- created_at — DATETIME
- started_at — DATETIME
- completed_at — DATETIME
- notes — TEXT
projects
- project_id — INT — 기본 키 — NOT NULL
- user_id — VARCHAR(50) — 외래 키 → users.user_id — NOT NULL
- dataset_id — INT — 외래 키 → datasets.dataset_id — NOT NULL
- project_name — VARCHAR(200)
- description — TEXT
- target_column — VARCHAR(200)
- task_type — VARCHAR(20)
- project_type — VARCHAR(20)
- status — VARCHAR(20)
- created_at — DATETIME
- updated_at — DATETIME
roles
- role_id — INT — 기본 키 — NOT NULL
- role_name — VARCHAR(50)
run_candidates
- candidate_id — INT — 기본 키 — NOT NULL
- run_id — INT — 외래 키 → project_runs.run_id — NOT NULL
- algorithm — VARCHAR(100)
- hyperparameters — TEXT
- metrics — TEXT
- model_file_path — VARCHAR(255)
- summary_image_url — VARCHAR(255)
- is_best — INT
- created_at — DATETIME
users
- user_id — VARCHAR(50) — 기본 키 — NOT NULL
- role_id — INT — 외래 키 → roles.role_id
- username — VARCHAR(30)
- password — VARCHAR(100)
- name — VARCHAR(20)
- email — VARCHAR(30)
- phone_number — VARCHAR(20)
- status — VARCHAR(20)
- created_at — DATETIME
- updated_at — DATETIME
- last_login — DATETIME