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