Source identity
| Field | Recorded value |
|---|---|
| Source type | GitHub source |
| Original record | Janady13/missionmatch / sqlc.yaml |
| Date | Not specified in source |
| Repository | Janady13/missionmatch |
| Revision | 09015496d565a172bcaa15cfe9a8e4b072b13df0 |
| Branch | workstream-b-screenmatch |
| Path or archive member | sqlc.yaml |
| Original SHA-256 | cacf80e860a607d6339b1f0a29f5673250f4c3092d6db62a286b6fb5ecea6b87 |
| Git blob SHA | aa43dd4cca7fed96399eacec0027b07c1d865906 |
| Reading-copy SHA-256 | cacf80e860a607d6339b1f0a29f5673250f4c3092d6db62a286b6fb5ecea6b87 |
Every recorded occurrence
These 9 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 | workstream-b-screenmatch | 09015496d565a172bcaa15cfe9a8e4b072b13df0 | Open original |
| Janady13/missionmatch / sqlc.yaml | workstream-d-missionmatch | 3be46ba89edb737182075a2b320509b42dc916f8 | Open original |
| Janady13/missionmatch / sqlc.yaml | workstream-e-dataflow-deploy | 433815a042f9741411e60fa553fe72143e9b10db | Open original |
| Janady13/missionmatch / sqlc.yaml | workstream-c-slatematch | 5cd60c918301b46ecd6ed3e03e20c395da0062e2 | Open original |
| Janady13/missionmatch / sqlc.yaml | ai-intelligence-layer | 5d5ddff70393a197c5f54a45280bb5dd42b24755 | Open original |
| Janady13/missionmatch / sqlc.yaml | workstream-c-slatematch | 5cd60c918301b46ecd6ed3e03e20c395da0062e2 | Open original |
| Janady13/missionmatch / sqlc.yaml | workstream-e-dataflow-deploy | 433815a042f9741411e60fa553fe72143e9b10db | Open original |
| Janady13/missionmatch / sqlc.yaml | workstream-b-screenmatch | 09015496d565a172bcaa15cfe9a8e4b072b13df0 | Open original |
| Janady13/missionmatch / sqlc.yaml | workstream-d-missionmatch | 3be46ba89edb737182075a2b320509b42dc916f8 | Open original |
Recovered source transcript
Download complete source text ↓72 lines · 4.2 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" }
- 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 }