tsad_db

Tables (38)

artifact

  • artifact_id — VARCHAR(64) — Primary key — NOT NULL
  • experiment_id — VARCHAR(64) — Foreign key → execution_attempt.experiment_id — NOT NULL
  • run_id — VARCHAR(32) — Foreign key → execution_attempt.run_id — 실험 공통 ledger와 선택표는 NULL
  • artifact_kind — VARCHAR(64) — NOT NULL
  • relative_path — TEXT — NOT NULL — 소속 experiment_root 기준
  • sha256 — CHAR(64) — NOT NULL
  • byte_count — BIGINT
  • original_reference_json — JSON — support의 e/p 식별자는 출처와 함께 보존

case_input_file

  • input_role — VARCHAR(16) — Primary key — NOT NULL
  • input_order — INT — Primary key — NOT NULL
  • experiment_id — VARCHAR(64) — Foreign key → evaluation_case.experiment_id — NOT NULL
  • case_id — VARCHAR(64) — Foreign key → evaluation_case.case_id — NOT NULL
  • data_file_id — VARCHAR(64) — Foreign key → data_file.data_file_id — NOT NULL
  • source_start — BIGINT — NOT NULL
  • source_end_exclusive — BIGINT — NOT NULL
  • session_id — VARCHAR(64) — NOT NULL — 서로 다른 세션의 경계를 보존

channel_features

  • channel_index — INT — Primary key — NOT NULL — 0부터 시작하는 입력 채널 순서
  • experiment_id — VARCHAR(64) — Foreign key → prefix_features.experiment_id — NOT NULL
  • prefix_feature_id — VARCHAR(65) — Foreign key → prefix_features.prefix_feature_id — NOT NULL
  • channel_name — VARCHAR(255) — NOT NULL
  • valid_value_count — BIGINT — NOT NULL
  • is_constant — BOOLEAN
  • constant_reason — TEXT
  • mean — DOUBLE
  • mean_reason — TEXT
  • std — DOUBLE
  • std_reason — TEXT
  • median — DOUBLE
  • median_reason — TEXT
  • acf_lag1 — DOUBLE
  • acf_lag1_reason — TEXT

config_gdn

  • config_id — VARCHAR(13) — Foreign key → model_config.config_id — NOT NULL
  • model — VARCHAR(64) — Foreign key → model_config.model — NOT NULL
  • embedding — INT — NOT NULL
  • hidden — INT — NOT NULL
  • hidden_is_active — BOOLEAN — NOT NULL
  • topk — INT — NOT NULL
  • batch_size — INT — NOT NULL
  • epochs — INT — NOT NULL
  • patience — INT — NOT NULL
  • validation_ratio — DOUBLE — NOT NULL
  • optimizer_beta1 — DOUBLE — NOT NULL
  • optimizer_beta2 — DOUBLE — NOT NULL
  • window — INT — NOT NULL
  • stride — INT — NOT NULL
  • learning_rate — DOUBLE — NOT NULL
  • weight_decay — DOUBLE — NOT NULL
  • out_layer_num — INT — NOT NULL
  • graph_heads — INT — NOT NULL
  • graph_dropout — DOUBLE — NOT NULL
  • output_dropout — DOUBLE — NOT NULL
  • optimizer — VARCHAR(32) — NOT NULL

config_mwvar

  • config_id — VARCHAR(13) — Foreign key → model_config.config_id — NOT NULL
  • model — VARCHAR(64) — Foreign key → model_config.model — NOT NULL
  • window — INT — NOT NULL
  • centered — BOOLEAN — NOT NULL
  • ddof — INT — NOT NULL

config_one_liner_ensemble

  • config_id — VARCHAR(13) — Foreign key → model_config.config_id — NOT NULL
  • model — VARCHAR(64) — Foreign key → model_config.model — NOT NULL
  • variance_window — INT — NOT NULL
  • difference_window — INT — NOT NULL
  • difference_centered — BOOLEAN — NOT NULL
  • difference_correction — DOUBLE — NOT NULL

config_paano

  • config_id — VARCHAR(13) — Foreign key → model_config.config_id — NOT NULL
  • model — VARCHAR(64) — Foreign key → model_config.model — NOT NULL
  • patch_size — INT — NOT NULL
  • learning_rate — DOUBLE — NOT NULL
  • iterations — INT — NOT NULL
  • batch_size — INT — NOT NULL
  • weight_decay — DOUBLE — NOT NULL
  • memory_fraction — DOUBLE — NOT NULL
  • memory_seed — INT — NOT NULL
  • neighbors — INT — NOT NULL
  • use_revin — BOOLEAN — NOT NULL
  • memory_policy — VARCHAR(32) — NOT NULL
  • optimizer — VARCHAR(32) — NOT NULL
  • embedding_dimension — INT — NOT NULL
  • checkpoint_selection — VARCHAR(64) — NOT NULL

config_pca

  • config_id — VARCHAR(13) — Foreign key → model_config.config_id — NOT NULL
  • model — VARCHAR(64) — Foreign key → model_config.model — NOT NULL
  • n_components_mode — VARCHAR(24) — NOT NULL
  • n_components_fraction — DOUBLE — all이면 NULL. 미수집과 구분
  • window — INT — NOT NULL
  • zero_pruning — BOOLEAN — NOT NULL

config_score_head

  • score_variant — VARCHAR(16) — Primary key — NOT NULL — 일반 모델은 빈 문자열, TSPulse는 네 native head
  • config_id — VARCHAR(13) — Foreign key → model_config.config_id — NOT NULL
  • primary_score — BOOLEAN — NOT NULL

config_sqdiff

  • config_id — VARCHAR(13) — Foreign key → model_config.config_id — NOT NULL
  • model — VARCHAR(64) — Foreign key → model_config.model — NOT NULL
  • lag — INT
  • window — INT — NOT NULL
  • centered — BOOLEAN
  • correction — DOUBLE — NOT NULL

config_timercd

  • config_id — VARCHAR(13) — Foreign key → model_config.config_id — NOT NULL
  • model — VARCHAR(64) — Foreign key → model_config.model — NOT NULL
  • context_length — INT — NOT NULL
  • checkpoint_variant — VARCHAR(32) — NOT NULL
  • score_head — VARCHAR(32) — NOT NULL

config_tspulse

  • config_id — VARCHAR(13) — Foreign key → model_config.config_id — NOT NULL
  • model — VARCHAR(64) — Foreign key → model_config.model — NOT NULL
  • aggregation_window — INT — NOT NULL
  • context_length — INT — NOT NULL
  • patch_size — INT — NOT NULL
  • inference_batch_size — INT — NOT NULL
  • native_smoothing_window — INT — NOT NULL

data_file

  • data_file_id — VARCHAR(64) — Primary key — NOT NULL
  • family — VARCHAR(64) — Foreign key → dataset_family.family — NOT NULL
  • csv_file — VARCHAR(512) — NOT NULL
  • source_path — TEXT — NOT NULL
  • source_sha256 — CHAR(64) — NOT NULL
  • ordered_schema_sha256 — CHAR(64) — NOT NULL
  • row_count — BIGINT — NOT NULL
  • input_column — INT — NOT NULL

dataset_family

  • family — VARCHAR(64) — Primary key — NOT NULL — MSL, SMD, GHL, HAI 등

evaluation_case

  • case_id — VARCHAR(64) — Primary key — NOT NULL — 실험 안의 평가 단위
  • experiment_id — VARCHAR(64) — Foreign key → experiment.experiment_id — NOT NULL
  • family — VARCHAR(64) — Foreign key → dataset_family.family — NOT NULL
  • split_role — VARCHAR(64) — NOT NULL — dev18, ghl25_final, HAI 실행 구분
  • series — VARCHAR(32) — NOT NULL — 패널 내부 번호. 전역 파일 ID가 아님
  • training_boundary — BIGINT — NOT NULL — 정상 학습 구간 N
  • evaluation_row — BIGINT — NOT NULL
  • input_column — INT — NOT NULL
  • ordered_schema_sha256 — CHAR(64) — NOT NULL

execution_attempt

  • run_id — VARCHAR(32) — Primary key — NOT NULL — 기존 uuid4 hex. 성공 결과의 physical_execution_id
  • experiment_id — VARCHAR(64) — Foreign key → physical_run.experiment_id — NOT NULL
  • case_id — VARCHAR(64) — Foreign key → physical_run.case_id — NOT NULL
  • config_id — VARCHAR(13) — Foreign key → physical_run.config_id — NOT NULL
  • physical_q — INT — Foreign key → physical_run.physical_q — NOT NULL
  • seed — INT — Foreign key → physical_run.seed — NOT NULL
  • attempt_index — INT — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • started_at — DATETIME(6) — NOT NULL — UTC
  • finished_at — DATETIME(6) — UTC. 강제 종료 시 미확정
  • elapsed_seconds — DOUBLE
  • elapsed_seconds_lower_bound — DOUBLE
  • training_patch_count — BIGINT
  • memory_count — BIGINT
  • effective_batch_size — INT
  • epochs_completed — INT
  • selected_epoch — INT
  • optimizer_updates — BIGINT
  • training_examples_seen — BIGINT
  • best_validation_loss — DOUBLE
  • preprocessing_seconds — DOUBLE
  • training_seconds — DOUBLE
  • inference_seconds — DOUBLE
  • peak_gpu_memory_bytes — BIGINT
  • peak_host_memory_bytes — BIGINT
  • device — VARCHAR(128)
  • backend — VARCHAR(128)
  • memory_measurement_scope — TEXT
  • missing_value_reasons_json — JSON
  • execution_controls_json — JSON
  • model_internal_validation_json — JSON
  • input_statistics_scope_json — JSON
  • history_json — JSON — NOT NULL

experiment

  • experiment_id — VARCHAR(64) — Primary key — NOT NULL — 봉인한 실험 신원
  • experiment_name — VARCHAR(128) — NOT NULL
  • experiment_root — VARCHAR(512) — NOT NULL
  • methodology_revision — VARCHAR(64) — NOT NULL
  • budget_id — VARCHAR(64) — NOT NULL
  • budget_sha256 — CHAR(64) — NOT NULL
  • project_commit — VARCHAR(64) — NOT NULL
  • input_manifest_sha256 — CHAR(64) — NOT NULL
  • storage_schema_version — VARCHAR(64) — NOT NULL
  • identity_json — JSON — NOT NULL
  • environment_json — JSON — 원격에서 확인한 실제 환경

experiment_config

  • experiment_id — VARCHAR(64) — Foreign key → experiment.experiment_id — NOT NULL
  • config_id — VARCHAR(13) — Foreign key → model_config.config_id — NOT NULL

experiment_info

  • id — INT — Primary key — NOT NULL
  • experiment_name — VARCHAR(128) — NOT NULL — 이번 실험 이름
  • identity_json — JSON — NOT NULL — 기존 실험 신원: 예산, 코드, 입력, 저장 버전
  • environment_json — JSON — 확인한 실행 환경
  • evidence_files_json — JSON — NOT NULL — 제외 원표, 선택, LOFO, 최종 요청 파일의 경로와 SHA

final_policy_membership

  • membership_id — VARCHAR(64) — Primary key — NOT NULL
  • experiment_id — VARCHAR(64) — Foreign key → artifact.experiment_id — NOT NULL — GHL 또는 HAI 대상 실험
  • case_id — VARCHAR(64) — Foreign key → evaluation_case.case_id — NOT NULL
  • analysis_kind — VARCHAR(32) — NOT NULL
  • tier — VARCHAR(2) — Foreign key → model.tier — NOT NULL
  • model — VARCHAR(64) — Foreign key → model_config.model — NOT NULL
  • q_percent — INT — NOT NULL
  • physical_q — INT
  • config_id — VARCHAR(13) — Foreign key → selected_policy.config_id
  • score_variant — VARCHAR(16) — Foreign key → config_score_head.score_variant
  • source_experiment_id — VARCHAR(64) — Foreign key → selected_policy.experiment_id — 선택에 사용한 Dev18 실험
  • source_group_id — VARCHAR(65) — Foreign key → selected_policy.group_id
  • source_fold_key — VARCHAR(64) — Foreign key → selected_policy.fold_key
  • source_q_percent — INT — Foreign key → selected_policy.q_percent
  • status — VARCHAR(32) — NOT NULL
  • status_reason — TEXT
  • support_status — VARCHAR(64) — NOT NULL
  • membership_artifact_id — VARCHAR(64) — Foreign key → artifact.artifact_id — NOT NULL

membership_run

  • experiment_id — VARCHAR(64) — Foreign key → physical_run.experiment_id — NOT NULL
  • membership_id — VARCHAR(64) — Foreign key → final_policy_membership.membership_id — NOT NULL
  • seed — INT — Foreign key → physical_run.seed — NOT NULL
  • case_id — VARCHAR(64) — Foreign key → physical_run.case_id — NOT NULL
  • config_id — VARCHAR(13) — Foreign key → physical_run.config_id — NOT NULL
  • physical_q — INT — Foreign key → physical_run.physical_q — NOT NULL

model

  • model — VARCHAR(64) — Primary key — NOT NULL
  • tier — VARCHAR(2) — NOT NULL
  • target_use — VARCHAR(32) — NOT NULL
  • deterministic — BOOLEAN — NOT NULL

model_config

  • config_id — VARCHAR(13) — Primary key — NOT NULL — 기존 c + SHA-256 앞 12자리
  • model — VARCHAR(64) — Foreign key → model.model — NOT NULL
  • candidate_order — INT — NOT NULL — 양식의 모델별 검토 순서
  • source_commit — VARCHAR(64) — NOT NULL
  • source_checkpoint_sha256 — VARCHAR(64) — 사전학습 가중치. 이번 학습 산출물과 구분
  • checkpoint_config_sha256 — CHAR(64)
  • common_recipe_id — VARCHAR(64) — NOT NULL
  • settings_json — JSON — NOT NULL — 기존 전체 설정 원본. 상세 열의 출처

model_configs

  • config_id — VARCHAR(13) — Primary key — NOT NULL — 엑셀: 전체설정 식별ID. 기존 ID 유지
  • model — VARCHAR(64) — NOT NULL — 엑셀: 실행모델
  • candidate_order — INT — NOT NULL — 엑셀: 후보번호. 검토 순서이며 PK가 아님
  • tier — VARCHAR(2) — NOT NULL
  • target_use — VARCHAR(32) — NOT NULL
  • deterministic — BOOLEAN — NOT NULL
  • settings_json — JSON — NOT NULL — 원본 전체 설정: 파라미터, 소스, checkpoint, 전후처리

model_runs

  • physical_execution_id — VARCHAR(32) — Primary key — NOT NULL — 엑셀: 실제 실행 ID. 기존 실행 이력의 run_id
  • csv_id — VARCHAR(512) — NOT NULL
  • config_id — VARCHAR(13) — Foreign key → model_configs.config_id — NOT NULL
  • seed — INT — NOT NULL
  • physical_q — INT — NOT NULL — 실제 실행 q. 입력과 무관한 모델은 재사용 표시 100
  • attempt_index — INT — NOT NULL — 같은 조합의 재시도 번호
  • status — VARCHAR(32) — NOT NULL — 실제 실행 시도의 상태. 채점 상태와 구분
  • started_at — DATETIME(6) — NOT NULL — UTC
  • finished_at — DATETIME(6) — UTC. 확인하지 못한 종료시간은 NULL
  • elapsed_seconds — DOUBLE — 실행 시도 전체 시간
  • training_patch_count — BIGINT
  • memory_count — BIGINT — PaAno 실제 memory 수
  • epochs_completed — INT
  • selected_epoch — INT
  • optimizer_updates — BIGINT
  • training_seconds — DOUBLE
  • inference_seconds — DOUBLE
  • peak_gpu_memory_bytes — BIGINT
  • run_details_json — JSON — NOT NULL — 원본 이력, snapshot, checkpoint와 scaler 참조, 측정 범위, NULL 사유

physical_run

  • physical_q — INT — Primary key — NOT NULL
  • seed — INT — Primary key — NOT NULL
  • experiment_id — VARCHAR(64) — Foreign key → experiment_config.experiment_id — NOT NULL
  • case_id — VARCHAR(64) — Foreign key → evaluation_case.case_id — NOT NULL
  • config_id — VARCHAR(13) — Foreign key → experiment_config.config_id — NOT NULL
  • planned_status — VARCHAR(32) — NOT NULL

policy_family_head

  • experiment_id — VARCHAR(64) — Foreign key → selected_policy.experiment_id — NOT NULL
  • group_id — VARCHAR(65) — Foreign key → selected_policy.group_id — NOT NULL
  • fold_key — VARCHAR(64) — Foreign key → selected_policy.fold_key — NOT NULL
  • family — VARCHAR(64) — Foreign key → dataset_family.family — NOT NULL
  • config_id — VARCHAR(13) — Foreign key → config_score_head.config_id — NOT NULL
  • score_variant — VARCHAR(16) — Foreign key → config_score_head.score_variant — NOT NULL

prefix_features

  • prefix_feature_id — VARCHAR(65) — Primary key — NOT NULL — 기존 p + SHA-256 전체 64자리
  • experiment_id — VARCHAR(64) — Foreign key → evaluation_case.experiment_id — NOT NULL
  • case_id — VARCHAR(64) — Foreign key → evaluation_case.case_id — NOT NULL
  • q_percent — INT — NOT NULL
  • observed_row — BIGINT — NOT NULL — 단일 CSV는 floor(N*q/100), HAI는 세션별 prefix 행 수의 합
  • source_start — BIGINT — NOT NULL
  • source_end_exclusive — BIGINT — NOT NULL
  • feature_sha256 — CHAR(64) — NOT NULL
  • identity_json — JSON — NOT NULL
  • constant_channel_count — INT
  • constant_evaluable_channel_count — INT — NOT NULL
  • constant_channel_count_reason — TEXT
  • channel_std_median — DOUBLE
  • channel_std_median_reason — TEXT
  • channel_std_valid_channel_count — INT — NOT NULL
  • channel_acf_lag1_median — DOUBLE
  • channel_acf_lag1_median_reason — TEXT
  • channel_acf_lag1_valid_channel_count — INT — NOT NULL
  • absolute_correlation_median — DOUBLE
  • absolute_correlation_median_reason — TEXT
  • absolute_correlation_valid_pair_count — BIGINT — NOT NULL
  • absolute_correlation_eligible_pair_count — BIGINT — NOT NULL
  • collection_seconds — DOUBLE
  • storage_seconds — DOUBLE
  • feature_bytes — BIGINT

prefix_input_segment

  • experiment_id — VARCHAR(64) — Foreign key → case_input_file.experiment_id — NOT NULL
  • prefix_feature_id — VARCHAR(65) — Foreign key → prefix_features.prefix_feature_id — NOT NULL
  • input_order — INT — Foreign key → case_input_file.input_order — NOT NULL
  • case_id — VARCHAR(64) — Foreign key → case_input_file.case_id — NOT NULL
  • input_role — VARCHAR(16) — Foreign key → case_input_file.input_role — NOT NULL
  • source_start — BIGINT — NOT NULL
  • source_end_exclusive — BIGINT — NOT NULL

results

  • status — VARCHAR(32) — Primary key — NOT NULL
  • experiment_id — VARCHAR(64) — Foreign key → score_output.experiment_id — NOT NULL
  • prefix_feature_id — VARCHAR(65) — Foreign key → prefix_features.prefix_feature_id — NOT NULL
  • config_id — VARCHAR(13) — Foreign key → score_output.config_id — NOT NULL
  • seed — INT — Foreign key → score_output.seed — NOT NULL
  • score_variant — VARCHAR(16) — Foreign key → score_output.score_variant — NOT NULL
  • case_id — VARCHAR(64) — Foreign key → score_output.case_id — NOT NULL
  • q_percent — INT — Foreign key → prefix_features.q_percent — NOT NULL
  • physical_q — INT — Foreign key → score_output.physical_q — NOT NULL
  • score_run_id — VARCHAR(32) — Foreign key → score_output.run_id — 점수가 있을 때만 실제 run_id 참조
  • source_physical_execution_id — VARCHAR(128) — 기존 results 참조값. 실패 합성 ID도 원문 보존
  • source_training_group_id — VARCHAR(128) — 기존 training_group_id의 출처값
  • primary_score — BOOLEAN — NOT NULL
  • status_reason — TEXT
  • vus_pr — DOUBLE
  • evaluator_sha256 — CHAR(64)
  • ell_max_id — VARCHAR(128)
  • manifest_reference — TEXT
  • ledger_reference — TEXT

score_output

  • experiment_id — VARCHAR(64) — Foreign key → artifact.experiment_id — NOT NULL
  • run_id — VARCHAR(32) — Foreign key → artifact.run_id — NOT NULL
  • score_variant — VARCHAR(16) — Foreign key → config_score_head.score_variant — NOT NULL
  • case_id — VARCHAR(64) — Foreign key → execution_attempt.case_id — NOT NULL
  • config_id — VARCHAR(13) — Foreign key → config_score_head.config_id — NOT NULL
  • physical_q — INT — Foreign key → execution_attempt.physical_q — NOT NULL
  • seed — INT — Foreign key → execution_attempt.seed — NOT NULL
  • raw_artifact_id — VARCHAR(64) — Foreign key → artifact.artifact_id — NOT NULL
  • smoothed_artifact_id — VARCHAR(64) — Foreign key → artifact.artifact_id — NOT NULL
  • metadata_artifact_id — VARCHAR(64) — Foreign key → artifact.artifact_id — NOT NULL
  • raw_channels_artifact_id — VARCHAR(64) — Foreign key → artifact.artifact_id
  • smoothed_channels_artifact_id — VARCHAR(64) — Foreign key → artifact.artifact_id
  • source_start — BIGINT — NOT NULL
  • source_end_exclusive — BIGINT — NOT NULL
  • alignment — VARCHAR(128) — NOT NULL
  • normalization — VARCHAR(128) — NOT NULL
  • native_postprocessing — BOOLEAN — NOT NULL

selected_policy

  • experiment_id — VARCHAR(64) — Foreign key → artifact.experiment_id — NOT NULL
  • group_id — VARCHAR(65) — Foreign key → selection_group_candidate.group_id — NOT NULL
  • fold_key — VARCHAR(64) — Foreign key → selection_fold.fold_key — NOT NULL
  • q_percent — INT — Foreign key → selection_group.q_percent — NOT NULL
  • config_id — VARCHAR(13) — Foreign key → config_score_head.config_id
  • selection_mode — VARCHAR(24)
  • score_variant_fallback — VARCHAR(16) — Foreign key → config_score_head.score_variant — TSPulse는 time, 일반 모델은 빈 문자열
  • status — VARCHAR(32) — NOT NULL
  • status_reason — TEXT
  • family_macro_vus_pr — DOUBLE
  • series_macro_vus_pr — DOUBLE
  • holdout_vus_pr — DOUBLE
  • file_count — INT — NOT NULL
  • family_count — INT — NOT NULL
  • window_rule_id — VARCHAR(128)
  • evidence_artifact_id — VARCHAR(64) — Foreign key → artifact.artifact_id — NOT NULL

selection_fold

  • fold_key — VARCHAR(64) — Primary key — NOT NULL — full 또는 holdout family
  • experiment_id — VARCHAR(64) — Foreign key → selection_group.experiment_id — NOT NULL
  • group_id — VARCHAR(65) — Foreign key → selection_group.group_id — NOT NULL
  • fold_kind — VARCHAR(24) — NOT NULL
  • holdout_family — VARCHAR(64) — Foreign key → dataset_family.family
  • validation_status — VARCHAR(64) — NOT NULL
  • evidence_json — JSON — NOT NULL — fold별 후보, 창 점수, 학습과 holdout 원표 참조

selection_fold_member

  • experiment_id — VARCHAR(64) — Foreign key → selection_group_member.experiment_id — NOT NULL
  • group_id — VARCHAR(65) — Foreign key → selection_group_member.group_id — NOT NULL
  • fold_key — VARCHAR(64) — Foreign key → selection_fold.fold_key — NOT NULL
  • prefix_feature_id — VARCHAR(65) — Foreign key → selection_group_member.prefix_feature_id — NOT NULL
  • member_role — VARCHAR(16) — NOT NULL

selection_group

  • group_id — VARCHAR(65) — Primary key — NOT NULL
  • experiment_id — VARCHAR(64) — Foreign key → experiment.experiment_id — NOT NULL
  • analysis_kind — VARCHAR(32) — NOT NULL
  • q_percent — INT — NOT NULL
  • model — VARCHAR(64) — Foreign key → model.model — model_ratio 집단의 모델
  • tier — VARCHAR(2) — tier_adaptive 집단의 계층
  • selection_rule_id — VARCHAR(128) — NOT NULL
  • group_identity_json — JSON — NOT NULL

selection_group_candidate

  • experiment_id — VARCHAR(64) — Foreign key → experiment_config.experiment_id — NOT NULL
  • group_id — VARCHAR(65) — Foreign key → selection_group.group_id — NOT NULL
  • config_id — VARCHAR(13) — Foreign key → experiment_config.config_id — NOT NULL
  • candidate_evidence_json — JSON — NOT NULL — 후보 head 목록과 전체 원표 참조

selection_group_member

  • experiment_id — VARCHAR(64) — Foreign key → prefix_features.experiment_id — NOT NULL
  • group_id — VARCHAR(65) — Foreign key → selection_group.group_id — NOT NULL
  • prefix_feature_id — VARCHAR(65) — Foreign key → prefix_features.prefix_feature_id — NOT NULL
  • q_percent — INT — Foreign key → prefix_features.q_percent — NOT NULL

structural_exclusions

  • experiment_id — VARCHAR(64) — Foreign key → experiment_config.experiment_id — NOT NULL
  • prefix_feature_id — VARCHAR(65) — Foreign key → prefix_features.prefix_feature_id — NOT NULL
  • config_id — VARCHAR(13) — Foreign key → experiment_config.config_id — NOT NULL
  • reason — TEXT — NOT NULL
  • feasibility_reference — TEXT — NOT NULL