Janady13/missionmatch / sqlc.yaml · Consciousness Atlas

Source identity

Field	Recorded value
Source type	GitHub source
Original record	Janady13/missionmatch / sqlc.yaml
Date	Not specified in source
Repository	Janady13/missionmatch
Revision	720d47fae476b0d38477ae4401697d372b1ea2bc
Branch	feature/opportunity-to-outcome
Path or archive member	sqlc.yaml
Original SHA-256	70026abc53fb2f255a72e3acbb9fa94d406cf96540d51a7d4ef8745cdff1f835
Git blob SHA	88f993a6611a3e28f2df0fd3cbb41df77387bd21
Reading-copy SHA-256	70026abc53fb2f255a72e3acbb9fa94d406cf96540d51a7d4ef8745cdff1f835

Original source ↗

Every recorded occurrence

These 14 records contain identical original source bytes. Their paths and revisions remain part of the archive.

Original record	Branch or archive	Revision / identifier	Original location
Janady13/missionmatch / sqlc.yaml	feature/opportunity-to-outcome	720d47fae476b0d38477ae4401697d372b1ea2bc	Open original
Janady13/missionmatch / sqlc.yaml	collision-deconfliction	4ee5a09972608ed89f8377c6665542d5f450f0a6	Open original
Janady13/missionmatch / sqlc.yaml	m5-price-to-win	41000ad30fff4129fdaf5ec84e15ba14c27d4890	Open original
Janady13/missionmatch / sqlc.yaml	master	1e9249840a4302ec82e123b9c9cb6f75badea3e4	Open original
Janady13/missionmatch / sqlc.yaml	ws8-teaching-loop	c823f0fb6bb2aba0f39001eb6de96f4000d9321f	Open original
Janady13/missionmatch / sqlc.yaml	mag-substrate	b82c7100a492dec67dfd1eda6b3f53def859be35	Open original
Janady13/missionmatch / sqlc.yaml	time-to-fill-survival	b66e1e505863d4f17741a4b9ede73509e45bd6c6	Open original
Janady13/missionmatch / sqlc.yaml	graphrag-foundation	b0ddeb9f633fd138d09309d1a17b7d13bc3a67f7	Open original
Janady13/missionmatch / sqlc.yaml	ws9-bench-ingestion	f585a9ef32fa554663ce1fba9a414a54b6e49cf0	Open original
Janady13/missionmatch / sqlc.yaml	presentation-readiness	eb574acaa29d71ce4d0f852572e87c275c79fdb7	Open original
Janady13/missionmatch / sqlc.yaml	vendor-intelligence	fe9796a19c261951d3f2565206c0c1b5ac294465	Open original
Janady13/missionmatch / sqlc.yaml	phase2-connectors	e038d4c687aec16f8bd9bc4d907eea14d91f8704	Open original
Janady13/missionmatch / sqlc.yaml	feature/aioe-upgrade	2178e7298d0e5d9af83afa12402fd587f0ba6ed8	Open original
Janady13/missionmatch / sqlc.yaml	capture-readiness	bae6af7cb2997e819174a9e9cfff5e16067a1975	Open original

Recovered source transcript

Download complete source text ↓78 lines · 4.7 KB

version: "2"
sql:
  - engine: "postgresql"
    schema: "db/migrations"      # goose-annotated; sqlc parses these as the schema (ignores -- +goose Down)
    queries: "db/queries"        # ONLY public-schema queries — no eeo queries here, so generated
                                 # matching code physically cannot reference eeo.candidate_demographics
    gen:
      go:
        package: "dbgen"
        out: "internal/platform/database/dbgen"
        sql_package: "pgx/v5"
        emit_json_tags: true
        emit_pointers_for_null_types: true
        emit_interface: true
        emit_empty_slices: true
        overrides:
          - db_type: "uuid"
            go_type: { import: "github.com/google/uuid", type: "UUID" }
          - db_type: "uuid"
            nullable: true
            go_type: { import: "github.com/google/uuid", type: "UUID", pointer: true }
          - db_type: "timestamptz"            # BARE name (pg_catalog.timestamptz does NOT match under pgx/v5)
            go_type: "time.Time"
          - db_type: "timestamptz"
            nullable: true
            go_type: { type: "time.Time", pointer: true }
          - db_type: "pg_catalog.numeric"     # covers AVG()/expression numeric results
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          # NUMERIC db_type override is IGNORED for plain columns under pgx/v5 — a per-column override
          # is REQUIRED on every numeric table column to honor the decimal-determinism rule.
          - column: "opportunities.value"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal", pointer: true }
          - column: "usaspending_awards.award_amount"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal", pointer: true }
          - column: "bls_wages.value"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal", pointer: true }
          - column: "opportunity_records.estimated_value"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal", pointer: true }
          - column: "slate_members.total_score"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          - column: "slate_members.clearance_score"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          - column: "slate_members.skills_score"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          - column: "slate_members.certs_score"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          - column: "slate_members.customer_score"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          - column: "slate_members.experience_score"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          - column: "slate_members.location_score"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          - column: "candidate_evaluations.total_score"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          - column: "candidate_evaluations.clearance_score"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          - column: "candidate_evaluations.skills_score"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          - column: "candidate_evaluations.certs_score"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          - column: "candidate_evaluations.customer_score"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          - column: "candidate_evaluations.experience_score"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          - column: "candidate_evaluations.location_score"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          - column: "staffing_recommendations.confidence"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          # curation_proposals.proposed_strength is a NULLABLE plain numeric, which the pg_catalog.numeric
          # override does not reach, so a per column override pins it to shopspring decimal (the determinism rule).
          - column: "curation_proposals.proposed_strength"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal", pointer: true }
          - db_type: "vector"
            go_type: { import: "github.com/pgvector/pgvector-go", package: "pgvector", type: "Vector" }
          - db_type: "vector"
            nullable: true
            go_type: { import: "github.com/pgvector/pgvector-go", package: "pgvector", type: "Vector", pointer: true }