Wedge

Tables (27)

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 — Foreign key → project.id
  • status — VARCHAR(32) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

analysis_finding

  • id — UUID
  • analysis_job_id — UUID — Foreign key → analysis_job.id — NOT NULL
  • run_id — UUID — Foreign key → test_run.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 — Foreign key → test_run.id — NOT NULL
  • job_type — VARCHAR(32) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • evidence_packet_id — UUID — Foreign key → evidence_packet.id
  • rule_registry_id — UUID — Foreign key → rule_registry.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

artifact

  • id — UUID
  • run_id — UUID — Foreign key → test_run.id — NOT NULL
  • step_id — UUID — Foreign key → test_run_step.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

checkpoint

  • id — UUID
  • run_id — UUID — Foreign key → test_run.id — NOT NULL
  • step_id — UUID — Foreign key → test_run_step.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

evidence_packet

  • id — UUID
  • run_id — UUID — Foreign key → test_run.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

mcp_invocation_log

  • id — UUID
  • oauth_client_id — VARCHAR(200)
  • user_id — UUID — Foreign key → user_account.id
  • project_id — UUID — Foreign key → project.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 — Foreign key → analysis_job.id — NOT NULL
  • finding_id — UUID — Foreign key → analysis_finding.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 — Foreign key → checkpoint.id — NOT NULL
  • run_id — UUID — Foreign key → test_run.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

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

processed_message

  • consumer_name — VARCHAR(120) — Primary key — NOT NULL
  • message_id — VARCHAR(160) — Primary key — NOT NULL
  • processed_at — TIMESTAMPTZ — NOT NULL

project

  • id — UUID
  • workspace_id — UUID — Foreign key → workspace.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 — Foreign key → user_account.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 — Foreign key → project.id — NOT NULL
  • user_id — UUID — Foreign key → user_account.id — NOT NULL
  • role — VARCHAR(32) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

report

  • id — UUID
  • run_id — UUID — Foreign key → test_run.id — NOT NULL
  • analysis_job_id — UUID — Foreign key → analysis_job.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 — Foreign key → artifact.id
  • created_by — UUID — Foreign key → user_account.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 — Foreign key → report.id — NOT NULL
  • share_token — VARCHAR(160) — NOT NULL
  • access_level — VARCHAR(32) — NOT NULL
  • expires_at — TIMESTAMPTZ
  • revoked_at — TIMESTAMPTZ
  • created_by — UUID — Foreign key → user_account.id
  • created_at — TIMESTAMPTZ — NOT NULL

rule_hit

  • id — UUID
  • analysis_job_id — UUID — Foreign key → analysis_job.id — NOT NULL
  • run_id — UUID — Foreign key → test_run.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

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

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 — Foreign key → scenario_template.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

test_run

  • id — UUID
  • project_id — UUID — Foreign key → project.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 — Foreign key → scenario_template_version.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 — Foreign key → user_account.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • version — BIGINT — NOT NULL

test_run_event

  • id — UUID
  • run_id — UUID — Foreign key → test_run.id — NOT NULL
  • step_id — UUID — Foreign key → test_run_step.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

test_run_step

  • id — UUID
  • run_id — UUID — Foreign key → test_run.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

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 — Foreign key → user_account.id
  • password_hash — TEXT — NOT NULL
  • password_updated_at — TIMESTAMPTZ — NOT NULL
  • created_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 — Foreign key → user_account.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 — Foreign key → workspace.id — NOT NULL
  • user_id — UUID — Foreign key → user_account.id — NOT NULL
  • role — VARCHAR(32) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL