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	43d56387270ef4da4cabd794d97ca6a49909bc7d
Branch	w3-ai-staffing-recommendations
Path or archive member	sqlc.yaml
Original SHA-256	cf88efa6bb925b07c7cc174a8ff775499443715af5a45e424276a811201171ca
Git blob SHA	42aec3c09678d38cc280d10f42d928c70e1045af
Reading-copy SHA-256	cf88efa6bb925b07c7cc174a8ff775499443715af5a45e424276a811201171ca

Original source ↗

Every recorded occurrence

These 19 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	w3-ai-staffing-recommendations	43d56387270ef4da4cabd794d97ca6a49909bc7d	Open original
Janady13/missionmatch / sqlc.yaml	ws3-clearance	4b8e7ce594c068621867f9c9deed0ec64ae6c553	Open original
Janady13/missionmatch / sqlc.yaml	ws7-federal-signal	6a9f6ce9cfb13345ffb47770d4960e7c2d9c17c2	Open original
Janady13/missionmatch / sqlc.yaml	ws6-retrieval	6c56e29231ec05735927fa265c97d517499dfeaf	Open original
Janady13/missionmatch / sqlc.yaml	per-tenant-routing	9bde0f9a74b89d01980fa658e5253acda7528d0c	Open original
Janady13/missionmatch / sqlc.yaml	ai-brain-live	aac32fc49c878cc5bca099459307611562d0bac1	Open original
Janady13/missionmatch / sqlc.yaml	ws1-ontology-sync	b596f449a32a1016fbd403c36505cc00a1ac9ee6	Open original
Janady13/missionmatch / sqlc.yaml	deploy-and-ops	bdacd9d0b4d5998d25fc74bf4007f4c3ec538c7a	Open original
Janady13/missionmatch / sqlc.yaml	phase2-eval-fairness	d361af254701975fe239927656ababb56374655e	Open original
Janady13/missionmatch / sqlc.yaml	ws2-alias-relationship	e4dada4601c6eb101830f9d223a9655dfa120616	Open original
Janady13/missionmatch / sqlc.yaml	per-tenant-routing	9bde0f9a74b89d01980fa658e5253acda7528d0c	Open original
Janady13/missionmatch / sqlc.yaml	ws6-retrieval	6c56e29231ec05735927fa265c97d517499dfeaf	Open original
Janady13/missionmatch / sqlc.yaml	ws1-ontology-sync	b596f449a32a1016fbd403c36505cc00a1ac9ee6	Open original
Janady13/missionmatch / sqlc.yaml	w3-ai-staffing-recommendations	43d56387270ef4da4cabd794d97ca6a49909bc7d	Open original
Janady13/missionmatch / sqlc.yaml	ws3-clearance	4b8e7ce594c068621867f9c9deed0ec64ae6c553	Open original
Janady13/missionmatch / sqlc.yaml	phase2-eval-fairness	d361af254701975fe239927656ababb56374655e	Open original
Janady13/missionmatch / sqlc.yaml	deploy-and-ops	bdacd9d0b4d5998d25fc74bf4007f4c3ec538c7a	Open original
Janady13/missionmatch / sqlc.yaml	ws7-federal-signal	6a9f6ce9cfb13345ffb47770d4960e7c2d9c17c2	Open original
Janady13/missionmatch / sqlc.yaml	ai-brain-live	aac32fc49c878cc5bca099459307611562d0bac1	Open original

Recovered source transcript

Download complete source text ↓74 lines · 4.3 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" }
          - 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 }