으으으으

테이블 (9)

dataset_columns

  • column_id — SERIAL
  • dataset_id — INT — NOT NULL
  • column_name — VARCHAR(200)
  • data_type — VARCHAR(50)
  • missing_count — INT
  • unique_count — INT
  • summary_image_url — VARCHAR(1024)
  • created_at — TIMESTAMP

datasets

  • dataset_id — SERIAL
  • owner_user_id — VARCHAR(100)
  • name — VARCHAR(200)
  • description — TEXT
  • file_path — VARCHAR(1024)
  • rows_count — INT
  • columns_count — INT
  • status — VARCHAR(20)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

models

  • model_id — SERIAL
  • model_uuid — VARCHAR(100) — NOT NULL
  • uploader_user_id — VARCHAR(100)
  • associated_run_id — INT
  • associated_candidate_id — INT
  • model_name — VARCHAR(200)
  • storage_type — VARCHAR(50)
  • file_path — VARCHAR(2048)
  • metadata — JSONB
  • summary_image_url — VARCHAR(2048)
  • created_at — TIMESTAMP

project_runs

  • run_id — SERIAL
  • project_id — INT — NOT NULL
  • run_type — VARCHAR(50)
  • algorithm — VARCHAR(200)
  • parameters — JSONB
  • status — VARCHAR(20)
  • created_at — TIMESTAMP
  • started_at — TIMESTAMP
  • completed_at — TIMESTAMP
  • notes — TEXT
  • best_model_id — INT

projects

  • project_id — SERIAL
  • owner_user_id — VARCHAR(100)
  • dataset_id — INT
  • project_name — VARCHAR(200)
  • description — TEXT
  • target_column — VARCHAR(200)
  • task_type — VARCHAR(20)
  • project_type — VARCHAR(20)
  • status — VARCHAR(20)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

roles

  • role_id — SERIAL
  • role_name — VARCHAR(50)

run_candidates

  • candidate_id — SERIAL
  • run_id — INT — NOT NULL
  • algorithm — VARCHAR(100)
  • hyperparameters — JSONB
  • metrics — JSONB
  • is_best — BOOLEAN
  • created_at — TIMESTAMP
  • model_file_path — VARCHAR(1024)

training_results

  • training_result_id — SERIAL
  • run_id — INT — NOT NULL
  • project_id — INT
  • model_id — INT
  • metrics — JSONB
  • artifacts_url — VARCHAR(2048)
  • created_at — TIMESTAMP

users

  • user_id — VARCHAR(100)
  • role_id — INT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(200)
  • name — VARCHAR(100)
  • email — VARCHAR(255)
  • phone_number — VARCHAR(50)
  • status — VARCHAR(20)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • last_login — TIMESTAMP