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