Registry, Evidence

Tables (14)

analysis_evidence

  • analysis_evidence_id — BIGINT — Primary key — NOT NULL
  • analysis_id — VARCHAR(80) — Foreign key → analysis_job.analysis_id — NOT NULL
  • user_id — BIGINT — Foreign key → analysis_job.user_id — NOT NULL
  • rule_id — VARCHAR(80) — NOT NULL
  • file_path — TEXT — NOT NULL
  • start_line — INTEGER — NOT NULL
  • end_line — INTEGER — NOT NULL
  • fact_type — VARCHAR(32) — NOT NULL
  • fact_payload — JSONB — NOT NULL
  • code_snippet — TEXT
  • snippet_hash — VARCHAR(64)
  • matched_at — TIMESTAMPTZ — NOT NULL

analysis_evidence_commit

  • analysis_evidence_commit_id — BIGINT — Primary key — NOT NULL
  • analysis_evidence_id — BIGINT — Foreign key → analysis_evidence.analysis_evidence_id — NOT NULL
  • analysis_id — VARCHAR(80) — Foreign key → analysis_evidence.analysis_id — NOT NULL
  • repository_id — VARCHAR(80) — Foreign key → repository_commit.repository_id — NOT NULL
  • commit_sha — CHAR(40) — Foreign key → repository_commit.commit_sha — NOT NULL
  • user_id — BIGINT — Foreign key → analysis_evidence.user_id — NOT NULL
  • contribution_type — VARCHAR(16) — NOT NULL
  • matched_line_count — INTEGER — NOT NULL

analysis_job

  • analysis_id — VARCHAR(80) — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • repository_id — VARCHAR(80) — NOT NULL
  • branch_name — VARCHAR(255) — NOT NULL
  • commit_sha — CHAR(40) — NOT NULL
  • status — VARCHAR(16) — NOT NULL
  • current_stage — VARCHAR(40) — NOT NULL
  • requested_at — TIMESTAMPTZ — NOT NULL
  • started_at — TIMESTAMPTZ
  • completed_at — TIMESTAMPTZ
  • error_code — VARCHAR(64)

analysis_outbox

  • event_id — VARCHAR(80) — Primary key — NOT NULL
  • analysis_id — VARCHAR(80) — NOT NULL
  • analysis_repository_id — VARCHAR(80) — NOT NULL
  • topic — VARCHAR(249) — NOT NULL
  • event_json — TEXT — NOT NULL
  • status — VARCHAR(16) — NOT NULL
  • attempts — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • next_attempt_at — TIMESTAMPTZ — NOT NULL
  • published_at — TIMESTAMPTZ
  • last_error_code — VARCHAR(64)

evidence_rule

  • rule_id — VARCHAR(80) — Primary key — NOT NULL
  • tech_id — VARCHAR(80) — Foreign key → technology.tech_id — NOT NULL
  • registry_version — TEXT — Foreign key → technology.registry_version — NOT NULL
  • rule_type — VARCHAR(32) — NOT NULL
  • language — VARCHAR(24)
  • rule_name — TEXT — NOT NULL
  • description — TEXT
  • evaluation_scope — VARCHAR(16) — NOT NULL
  • priority — SMALLINT — NOT NULL
  • status — VARCHAR(16) — NOT NULL

evidence_rule_clause

  • clause_id — BIGINT — Primary key — NOT NULL
  • rule_id — VARCHAR(80) — Foreign key → evidence_rule.rule_id — NOT NULL
  • group_no — SMALLINT — NOT NULL
  • clause_key — VARCHAR(40) — NOT NULL
  • role — VARCHAR(16) — NOT NULL
  • fact_type — VARCHAR(32) — NOT NULL
  • min_match_count — SMALLINT — NOT NULL
  • clause_order — SMALLINT — NOT NULL

evidence_rule_predicate

  • predicate_id — BIGINT — Primary key — NOT NULL
  • clause_id — BIGINT — Foreign key → evidence_rule_clause.clause_id — NOT NULL
  • fact_field — VARCHAR(24) — NOT NULL
  • match_operator — VARCHAR(24) — NOT NULL
  • segment_delimiter — VARCHAR(4)
  • predicate_order — SMALLINT — NOT NULL

evidence_rule_predicate_value

  • predicate_value_id — BIGINT — Primary key — NOT NULL
  • value_order — SMALLINT — NOT NULL
  • predicate_id — BIGINT — Foreign key → evidence_rule_predicate.predicate_id — NOT NULL
  • tech_id — VARCHAR(80) — Foreign key → technology.tech_id — NOT NULL
  • registry_version — TEXT — Foreign key → technology.registry_version — NOT NULL
  • expected_value — TEXT — NOT NULL

repository_commit

  • repository_commit_id — BIGINT — Primary key — NOT NULL
  • repository_id — VARCHAR(80) — NOT NULL
  • commit_sha — CHAR(40) — NOT NULL
  • author_name — VARCHAR(255) — NOT NULL
  • author_email — VARCHAR(320)
  • github_login — VARCHAR(255)
  • authored_at — TIMESTAMPTZ — NOT NULL
  • commit_message — TEXT

technology

  • tech_id — VARCHAR(80) — Primary key — NOT NULL
  • registry_version — TEXT — Foreign key → technology_registry.registry_version — NOT NULL
  • display_name — TEXT — NOT NULL
  • status — VARCHAR(16) — NOT NULL

technology_category

  • technology_category_id — BIGINT — Primary key — NOT NULL
  • job_domain — VARCHAR(24) — NOT NULL
  • registry_version — TEXT — Foreign key → technology.registry_version — NOT NULL
  • tech_id — VARCHAR(80) — Foreign key → technology.tech_id — NOT NULL

technology_mapping

  • mapping_id — BIGINT — Primary key — NOT NULL
  • registry_version — TEXT — Foreign key → technology.registry_version — NOT NULL
  • tech_id — VARCHAR(80) — Foreign key → technology.tech_id — NOT NULL
  • mapping_type — VARCHAR(32) — NOT NULL
  • ecosystem — VARCHAR(24)
  • value — TEXT — NOT NULL
  • match_mode — VARCHAR(16) — NOT NULL
  • status — VARCHAR(16) — NOT NULL

technology_registry

  • technology_registry_id — BIGINT — Primary key — NOT NULL
  • registry_version — TEXT — NOT NULL
  • schema_version — VARCHAR(40) — NOT NULL

user

  • user_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • avatar_url — VARCHAR(100)
  • access_token — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP