Wedge

테이블 (27)

MCP 호출 로그 (mcp_invocation_log)

  • id — UUID
  • oauth_client_id — VARCHAR(200)
  • user_id — UUID — 외래 키 → 사용자 계정.id
  • project_id — UUID — 외래 키 → 프로젝트.id
  • tool_name — VARCHAR(120) — NOT NULL
  • request_summary_jsonb — JSONB — NOT NULL
  • response_summary_jsonb — JSONB
  • status — VARCHAR(32) — NOT NULL
  • started_at — TIMESTAMPTZ — NOT NULL
  • finished_at — TIMESTAMPTZ
  • error_code — VARCHAR(80)
  • error_message — TEXT

개선 제안 (nudge)

  • id — UUID
  • analysis_job_id — UUID — 외래 키 → 분석 작업.id — NOT NULL
  • finding_id — UUID — 외래 키 → 분석 발견사항.id
  • rank_order — INTEGER — NOT NULL
  • title — VARCHAR(240) — NOT NULL
  • rationale — TEXT — NOT NULL
  • recommendation — TEXT — NOT NULL
  • difficulty — VARCHAR(32)
  • expected_effect — TEXT
  • validation_question — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

관찰 결과 (observation)

  • id — UUID
  • checkpoint_id — UUID — 외래 키 → 체크포인트.id — NOT NULL
  • run_id — UUID — 외래 키 → 테스트 실행.id — NOT NULL
  • observation_key — VARCHAR(120) — NOT NULL
  • observation_type — VARCHAR(64) — NOT NULL
  • stage — VARCHAR(32)
  • sources_jsonb — JSONB — NOT NULL
  • data_jsonb — JSONB — NOT NULL
  • confidence — NUMERIC(4,3)
  • created_at — TIMESTAMPTZ — NOT NULL

룰 레지스트리 (rule_registry)

  • id — UUID
  • registry_id — VARCHAR(120) — NOT NULL
  • schema_version — VARCHAR(32) — NOT NULL
  • description — TEXT
  • registry_jsonb — JSONB — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

룰 적중 (rule_hit)

  • id — UUID
  • analysis_job_id — UUID — 외래 키 → 분석 작업.id — NOT NULL
  • run_id — UUID — 외래 키 → 테스트 실행.id — NOT NULL
  • criterion_id — VARCHAR(120) — NOT NULL
  • stage — VARCHAR(32)
  • axis — VARCHAR(32) — NOT NULL
  • severity — INTEGER — NOT NULL
  • confidence — NUMERIC(4,3) — NOT NULL
  • priority_score — NUMERIC(8,3) — NOT NULL
  • evidence_level — VARCHAR(64)
  • evidence_refs_jsonb — JSONB — NOT NULL
  • observations_jsonb — JSONB — NOT NULL
  • signals_jsonb — JSONB — NOT NULL
  • exceptions_jsonb — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

리포트 (report)

  • id — UUID
  • run_id — UUID — 외래 키 → 테스트 실행.id — NOT NULL
  • analysis_job_id — UUID — 외래 키 → 분석 작업.id
  • title — VARCHAR(240) — NOT NULL
  • format — VARCHAR(32) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • summary_jsonb — JSONB — NOT NULL
  • decision_map_jsonb — JSONB — NOT NULL
  • artifact_id — UUID — 외래 키 → 아티팩트.id
  • created_by — UUID — 외래 키 → 사용자 계정.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • version — BIGINT — NOT NULL

리포트 공유 (report_share)

  • id — UUID
  • report_id — UUID — 외래 키 → 리포트.id — NOT NULL
  • share_token — VARCHAR(160) — NOT NULL
  • access_level — VARCHAR(32) — NOT NULL
  • expires_at — TIMESTAMPTZ
  • revoked_at — TIMESTAMPTZ
  • created_by — UUID — 외래 키 → 사용자 계정.id
  • created_at — TIMESTAMPTZ — NOT NULL

분석 발견사항 (analysis_finding)

  • id — UUID
  • analysis_job_id — UUID — 외래 키 → 분석 작업.id — NOT NULL
  • run_id — UUID — 외래 키 → 테스트 실행.id — NOT NULL
  • rank_order — INTEGER — NOT NULL
  • title — VARCHAR(240) — NOT NULL
  • summary — TEXT — NOT NULL
  • category — VARCHAR(80) — NOT NULL
  • stage — VARCHAR(32)
  • axis — VARCHAR(32)
  • severity — INTEGER
  • confidence — NUMERIC(4,3)
  • priority_score — NUMERIC(8,3)
  • impact_hypothesis — TEXT
  • evidence_refs_jsonb — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

분석 작업 (analysis_job)

  • id — UUID
  • run_id — UUID — 외래 키 → 테스트 실행.id — NOT NULL
  • job_type — VARCHAR(32) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • evidence_packet_id — UUID — 외래 키 → 증거 패킷.id
  • rule_registry_id — UUID — 외래 키 → 룰 레지스트리.id
  • judge_schema_version — VARCHAR(32)
  • analyzer_version — VARCHAR(64)
  • prompt_version — VARCHAR(64)
  • model_info_jsonb — JSONB
  • output_jsonb — JSONB
  • friction_score — NUMERIC(5,2)
  • created_at — TIMESTAMPTZ — NOT NULL
  • started_at — TIMESTAMPTZ
  • finished_at — TIMESTAMPTZ
  • error_code — VARCHAR(80)
  • error_message — TEXT

사용자 계정 (user_account)

  • id — UUID
  • auth_subject — VARCHAR(200) — NOT NULL
  • email — VARCHAR(320)
  • display_name — VARCHAR(120) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • version — BIGINT — NOT NULL

사용자 인증정보 (user_credential)

  • user_id — UUID — 외래 키 → 사용자 계정.id
  • password_hash — TEXT — NOT NULL
  • password_updated_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

시나리오 템플릿 (scenario_template)

  • id — UUID
  • template_key — VARCHAR(100) — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • category — VARCHAR(64)
  • status — VARCHAR(32) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

시나리오 템플릿 버전 (scenario_template_version)

  • id — UUID
  • template_id — UUID — 외래 키 → 시나리오 템플릿.id — NOT NULL
  • version_label — VARCHAR(50) — NOT NULL
  • scenario_schema_version — VARCHAR(32) — NOT NULL
  • definition_jsonb — JSONB — NOT NULL
  • is_default — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

아웃박스 메시지 (outbox_message)

  • id — UUID
  • aggregate_type — VARCHAR(80) — NOT NULL
  • aggregate_id — UUID — NOT NULL
  • event_type — VARCHAR(120) — NOT NULL
  • payload_jsonb — JSONB — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • attempt_count — INTEGER — NOT NULL
  • next_attempt_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • published_at — TIMESTAMPTZ

아티팩트 (artifact)

  • id — UUID
  • run_id — UUID — 외래 키 → 테스트 실행.id — NOT NULL
  • step_id — UUID — 외래 키 → 테스트 실행 단계.id
  • artifact_type — VARCHAR(32) — NOT NULL
  • s3_bucket — VARCHAR(160) — NOT NULL
  • s3_key — TEXT — NOT NULL
  • public_url — TEXT
  • mime_type — VARCHAR(120) — NOT NULL
  • width — INTEGER
  • height — INTEGER
  • size_bytes — BIGINT — NOT NULL
  • sha256 — VARCHAR(64)
  • captured_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

에이전트 클라이언트 정책 (agent_client_policy)

  • id — UUID
  • oauth_client_id — VARCHAR(200) — NOT NULL
  • client_type — VARCHAR(64) — NOT NULL
  • display_name — VARCHAR(200) — NOT NULL
  • tool_allowlist_jsonb — JSONB — NOT NULL
  • approval_policy_jsonb — JSONB — NOT NULL
  • default_project_id — UUID — 외래 키 → 프로젝트.id
  • status — VARCHAR(32) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

워커 인스턴스 (worker_instance)

  • id — UUID
  • worker_id — VARCHAR(128) — NOT NULL
  • worker_type — VARCHAR(32) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • last_heartbeat_at — TIMESTAMPTZ — NOT NULL
  • metadata_jsonb — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

워크스페이스 (workspace)

  • id — UUID
  • name — VARCHAR(200) — NOT NULL
  • slug — VARCHAR(120) — NOT NULL
  • created_by — UUID — 외래 키 → 사용자 계정.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • version — BIGINT — NOT NULL

워크스페이스 멤버 (workspace_member)

  • id — UUID
  • workspace_id — UUID — 외래 키 → 워크스페이스.id — NOT NULL
  • user_id — UUID — 외래 키 → 사용자 계정.id — NOT NULL
  • role — VARCHAR(32) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

증거 패킷 (evidence_packet)

  • id — UUID
  • run_id — UUID — 외래 키 → 테스트 실행.id — NOT NULL
  • schema_version — VARCHAR(32) — NOT NULL
  • packet_jsonb — JSONB — NOT NULL
  • checkpoint_count — INTEGER — NOT NULL
  • observation_count — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

처리 완료 메시지 (processed_message)

  • consumer_name — VARCHAR(120) — 기본 키 — NOT NULL
  • message_id — VARCHAR(160) — 기본 키 — NOT NULL
  • processed_at — TIMESTAMPTZ — NOT NULL

체크포인트 (checkpoint)

  • id — UUID
  • run_id — UUID — 외래 키 → 테스트 실행.id — NOT NULL
  • step_id — UUID — 외래 키 → 테스트 실행 단계.id
  • checkpoint_key — VARCHAR(120) — NOT NULL
  • stage — VARCHAR(32)
  • trigger_jsonb — JSONB — NOT NULL
  • settle_jsonb — JSONB — NOT NULL
  • state_jsonb — JSONB — NOT NULL
  • delta_jsonb — JSONB — NOT NULL
  • artifact_refs_jsonb — JSONB — NOT NULL
  • captured_at — TIMESTAMPTZ — NOT NULL
  • duration_ms — INTEGER
  • created_at — TIMESTAMPTZ — NOT NULL

테스트 실행 (test_run)

  • id — UUID
  • project_id — UUID — 외래 키 → 프로젝트.id — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • trigger_source — VARCHAR(32) — NOT NULL
  • start_url — TEXT — NOT NULL
  • final_url — TEXT
  • goal — TEXT
  • device_preset — VARCHAR(32) — NOT NULL
  • environment_jsonb — JSONB — NOT NULL
  • scenario_template_version_id — UUID — 외래 키 → 시나리오 템플릿 버전.id — NOT NULL
  • scenario_plan_schema_version — VARCHAR(32)
  • scenario_plan_jsonb — JSONB — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • result_completeness — VARCHAR(16) — NOT NULL
  • analysis_status — VARCHAR(16) — NOT NULL
  • current_step_order — INTEGER
  • worker_id — VARCHAR(128)
  • latest_checkpoint_id — UUID
  • latest_artifact_id — UUID
  • latest_analysis_job_id — UUID
  • latest_report_id — UUID
  • friction_score — NUMERIC(5,2)
  • stop_requested_at — TIMESTAMPTZ
  • started_at — TIMESTAMPTZ
  • execution_finished_at — TIMESTAMPTZ
  • finished_at — TIMESTAMPTZ
  • failure_code — VARCHAR(80)
  • failure_message — TEXT
  • created_by — UUID — 외래 키 → 사용자 계정.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • version — BIGINT — NOT NULL

테스트 실행 단계 (test_run_step)

  • id — UUID
  • run_id — UUID — 외래 키 → 테스트 실행.id — NOT NULL
  • step_order — INTEGER — NOT NULL
  • step_key — VARCHAR(120) — NOT NULL
  • step_name — VARCHAR(200) — NOT NULL
  • stage — VARCHAR(32)
  • step_type — VARCHAR(32) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • target_jsonb — JSONB
  • input_jsonb — JSONB
  • output_jsonb — JSONB
  • started_at — TIMESTAMPTZ
  • finished_at — TIMESTAMPTZ
  • error_code — VARCHAR(80)
  • error_message — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

테스트 실행 이벤트 (test_run_event)

  • id — UUID
  • run_id — UUID — 외래 키 → 테스트 실행.id — NOT NULL
  • step_id — UUID — 외래 키 → 테스트 실행 단계.id
  • event_type — VARCHAR(64) — NOT NULL
  • source — VARCHAR(64) — NOT NULL
  • payload_jsonb — JSONB — NOT NULL
  • occurred_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

프로젝트 (project)

  • id — UUID
  • workspace_id — UUID — 외래 키 → 워크스페이스.id — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • project_key — VARCHAR(64) — NOT NULL
  • base_url — TEXT — NOT NULL
  • description — TEXT
  • status — VARCHAR(32) — NOT NULL
  • created_by — UUID — 외래 키 → 사용자 계정.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • version — BIGINT — NOT NULL

프로젝트 멤버 (project_member)

  • id — UUID
  • project_id — UUID — 외래 키 → 프로젝트.id — NOT NULL
  • user_id — UUID — 외래 키 → 사용자 계정.id — NOT NULL
  • role — VARCHAR(32) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL