바다솔루션

테이블 (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