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