Janady13/missionmatch / db/migrations/0025_mission_areas.sql

Source identity

Field	Recorded value
Source type	GitHub source
Original record	Janady13/missionmatch / db/migrations/0025_mission_areas.sql
Date	Not specified in source
Repository	Janady13/missionmatch
Revision	720d47fae476b0d38477ae4401697d372b1ea2bc
Branch	feature/opportunity-to-outcome
Path or archive member	db/migrations/0025_mission_areas.sql
Original SHA-256	c25ff60ff3403b25b68949940990180adf9ffba0cb72e1d304a2910a0ead3ad1
Git blob SHA	ccb5a6e5fda1f8c0167a5e625e0b97acbe07a072
Reading-copy SHA-256	c25ff60ff3403b25b68949940990180adf9ffba0cb72e1d304a2910a0ead3ad1

Original source ↗

Every recorded occurrence

These 15 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/0025_mission_areas.sql	feature/opportunity-to-outcome	720d47fae476b0d38477ae4401697d372b1ea2bc	Open original
Janady13/missionmatch / db/migrations/0025_mission_areas.sql	collision-deconfliction	4ee5a09972608ed89f8377c6665542d5f450f0a6	Open original
Janady13/missionmatch / db/migrations/0025_mission_areas.sql	m5-price-to-win	41000ad30fff4129fdaf5ec84e15ba14c27d4890	Open original
Janady13/missionmatch / db/migrations/0025_mission_areas.sql	master	1e9249840a4302ec82e123b9c9cb6f75badea3e4	Open original
Janady13/missionmatch / db/migrations/0025_mission_areas.sql	ws8-teaching-loop	c823f0fb6bb2aba0f39001eb6de96f4000d9321f	Open original
Janady13/missionmatch / db/migrations/0025_mission_areas.sql	mag-substrate	b82c7100a492dec67dfd1eda6b3f53def859be35	Open original
Janady13/missionmatch / db/migrations/0025_mission_areas.sql	time-to-fill-survival	b66e1e505863d4f17741a4b9ede73509e45bd6c6	Open original
Janady13/missionmatch / db/migrations/0025_mission_areas.sql	graphrag-foundation	b0ddeb9f633fd138d09309d1a17b7d13bc3a67f7	Open original
Janady13/missionmatch / db/migrations/0025_mission_areas.sql	ws9-bench-ingestion	f585a9ef32fa554663ce1fba9a414a54b6e49cf0	Open original
Janady13/missionmatch / db/migrations/0025_mission_areas.sql	presentation-readiness	eb574acaa29d71ce4d0f852572e87c275c79fdb7	Open original
Janady13/missionmatch / db/migrations/0025_mission_areas.sql	vendor-intelligence	fe9796a19c261951d3f2565206c0c1b5ac294465	Open original
Janady13/missionmatch / db/migrations/0025_mission_areas.sql	ws7-federal-signal	6a9f6ce9cfb13345ffb47770d4960e7c2d9c17c2	Open original
Janady13/missionmatch / db/migrations/0025_mission_areas.sql	phase2-connectors	e038d4c687aec16f8bd9bc4d907eea14d91f8704	Open original
Janady13/missionmatch / db/migrations/0025_mission_areas.sql	feature/aioe-upgrade	2178e7298d0e5d9af83afa12402fd587f0ba6ed8	Open original
Janady13/missionmatch / db/migrations/0025_mission_areas.sql	capture-readiness	bae6af7cb2997e819174a9e9cfff5e16067a1975	Open original

Recovered source transcript

Download complete source text ↓31 lines · 2.1 KB

-- +goose Up
-- mission_areas is the controlled vocabulary of IC mission areas and the single FK source of truth for
-- every mission tag. It is curated from the mission_spine seed (migration 0021) but adds a stable short
-- code that the tag tables and the in code vocabulary key on. Global reference data: migrator owned, app
-- SELECT only, outside RLS, no PII and no eeo reach.
CREATE TABLE mission_areas (
    code        text PRIMARY KEY,
    name        text NOT NULL,
    description text NOT NULL DEFAULT '',
    spine_term  text,                      -- soft link to mission_spine.term for provenance, not an FK
    sort_order  int  NOT NULL DEFAULT 0,   -- deterministic iteration order, mirrors ai/mission.go ordering
    created_at  timestamptz NOT NULL DEFAULT now()
);

INSERT INTO mission_areas (code, name, description, spine_term, sort_order) VALUES
 ('SIGINT','Signals Intelligence','Intelligence derived from signals, communications, electronic, and foreign instrumentation.','SIGINT',1),
 ('GEOINT','Geospatial Intelligence','Intelligence from the exploitation and analysis of imagery and geospatial information.','GEOINT',2),
 ('HUMINT','Human Intelligence','Intelligence collected from human sources.','HUMINT',3),
 ('MASINT','Measurement and Signature Intelligence','Measurement and signature intelligence.','MASINT',4),
 ('OSINT','Open Source Intelligence','Intelligence produced from publicly available information.','OSINT',5),
 ('SAT_C2','Satellite Command and Control','Command and control of satellite systems.','Satellite C2',6),
 ('CDS','Cross Domain Solution','A controlled interface providing access between security domains.','Cross Domain Solution',7),
 ('COMSEC','Communications Security','Measures to deny unauthorized access to telecommunications.','COMSEC',8),
 ('TEMPEST','TEMPEST','Protection against compromising emanations.','TEMPEST',9),
 ('EW','Electronic Warfare','Military action using electromagnetic and directed energy.','Electronic Warfare',10);

GRANT SELECT ON mission_areas TO missionmatch_app;

-- +goose Down
DROP TABLE IF EXISTS mission_areas;