Janady13/missionmatch / db/migrations/0040_alerts_collision.sql

Source identity

Field	Recorded value
Source type	GitHub source
Original record	Janady13/missionmatch / db/migrations/0040_alerts_collision.sql
Date	Not specified in source
Repository	Janady13/missionmatch
Revision	1e9249840a4302ec82e123b9c9cb6f75badea3e4
Branch	master
Path or archive member	db/migrations/0040_alerts_collision.sql
Original SHA-256	ec16dc68fac11d7b4c4572a28ad22c63453e91bc40de207f7b4ae48dab7b68ee
Git blob SHA	f413d1213d92b8220df10c07a3f71bdfac2b216d
Reading-copy SHA-256	ec16dc68fac11d7b4c4572a28ad22c63453e91bc40de207f7b4ae48dab7b68ee

Original source ↗

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 / db/migrations/0040_alerts_collision.sql	master	1e9249840a4302ec82e123b9c9cb6f75badea3e4	Open original
Janady13/missionmatch / db/migrations/0040_alerts_collision.sql	collision-deconfliction	4ee5a09972608ed89f8377c6665542d5f450f0a6	Open original
Janady13/missionmatch / db/migrations/0040_alerts_collision.sql	capture-readiness	bae6af7cb2997e819174a9e9cfff5e16067a1975	Open original
Janady13/missionmatch / db/migrations/0040_alerts_collision.sql	presentation-readiness	eb574acaa29d71ce4d0f852572e87c275c79fdb7	Open original
Janady13/missionmatch / db/migrations/0040_alerts_collision.sql	vendor-intelligence	fe9796a19c261951d3f2565206c0c1b5ac294465	Open original
Janady13/missionmatch / db/migrations/0040_alerts_collision.sql	collision-deconfliction	4ee5a09972608ed89f8377c6665542d5f450f0a6	Open original
Janady13/missionmatch / db/migrations/0040_alerts_collision.sql	master	1e9249840a4302ec82e123b9c9cb6f75badea3e4	Open original
Janady13/missionmatch / db/migrations/0040_alerts_collision.sql	presentation-readiness	eb574acaa29d71ce4d0f852572e87c275c79fdb7	Open original
Janady13/missionmatch / db/migrations/0040_alerts_collision.sql	capture-readiness	bae6af7cb2997e819174a9e9cfff5e16067a1975	Open original

Recovered source transcript

Download complete source text ↓17 lines · 1.2 KB

-- +goose Up
-- Add the fourth watch loop trigger type, collision, to the alerts.alert_type closed set. Cross opportunity
-- collision deconfliction flags when a candidate (most sharply a scarce cleared one) is proposed or approved on
-- the slates of two or more DISTINCT competing OPEN opportunities at once, so a capture team never quietly
-- double commits the same scarce cleared person across competing bids. It is an ADVISORY finding surfaced like
-- every other alert (unread, read, dismissed), with a deterministic suggested primary a human resolves; it
-- never auto rejects a slate member. No new table: it rides the existing alerts table, sweep, audit, and
-- endpoints. Only the alert_type CHECK widens by one value.
ALTER TABLE alerts DROP CONSTRAINT IF EXISTS alerts_alert_type_check;
ALTER TABLE alerts ADD  CONSTRAINT alerts_alert_type_check
    CHECK (alert_type IN ('recompete_winnable', 'clearance_expiring', 'gap_fillable', 'collision'));

-- +goose Down
ALTER TABLE alerts DROP CONSTRAINT IF EXISTS alerts_alert_type_check;
ALTER TABLE alerts ADD  CONSTRAINT alerts_alert_type_check
    CHECK (alert_type IN ('recompete_winnable', 'clearance_expiring', 'gap_fillable'));