Source identity
| Field | Recorded value |
|---|---|
| Source type | GitHub source |
| Original record | Janady13/missionmatch / db/seed/demo_base.sql |
| Date | Not specified in source |
| Repository | Janady13/missionmatch |
| Revision | 09015496d565a172bcaa15cfe9a8e4b072b13df0 |
| Branch | workstream-b-screenmatch |
| Path or archive member | db/seed/demo_base.sql |
| Original SHA-256 | b2205646fda89c8db77479767862bc201345bf6bd4f197900078f5540af96305 |
| Git blob SHA | eb2ec902a5f45414cbb94e22a8c993f41ec171ef |
| Reading-copy SHA-256 | b2205646fda89c8db77479767862bc201345bf6bd4f197900078f5540af96305 |
Every recorded occurrence
These 61 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/seed/demo_base.sql | workstream-b-screenmatch | 09015496d565a172bcaa15cfe9a8e4b072b13df0 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | workstream-a-opportunity-intelligence | 1675031db74316e100782d063e9eda1a597fe3a1 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | workstream-d-command-center | 255e7d1d420abf5e277d0cd8c9b14f6f72b6acb9 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | workstream-d-missionmatch | 3be46ba89edb737182075a2b320509b42dc916f8 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | m5-price-to-win | 41000ad30fff4129fdaf5ec84e15ba14c27d4890 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | workstream-e-dataflow-deploy | 433815a042f9741411e60fa553fe72143e9b10db | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | w3-ai-staffing-recommendations | 43d56387270ef4da4cabd794d97ca6a49909bc7d | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | workstream-e-commercial-stubs | 4437da660539284a400ee380b9b427a300c369ee | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | ws3-clearance | 4b8e7ce594c068621867f9c9deed0ec64ae6c553 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | collision-deconfliction | 4ee5a09972608ed89f8377c6665542d5f450f0a6 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | workstream-c-slatematch | 5cd60c918301b46ecd6ed3e03e20c395da0062e2 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | ai-intelligence-layer | 5d5ddff70393a197c5f54a45280bb5dd42b24755 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | ws7-federal-signal | 6a9f6ce9cfb13345ffb47770d4960e7c2d9c17c2 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | ws6-retrieval | 6c56e29231ec05735927fa265c97d517499dfeaf | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | per-tenant-routing | 9bde0f9a74b89d01980fa658e5253acda7528d0c | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | ai-brain-live | aac32fc49c878cc5bca099459307611562d0bac1 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | graphrag-foundation | b0ddeb9f633fd138d09309d1a17b7d13bc3a67f7 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | ws1-ontology-sync | b596f449a32a1016fbd403c36505cc00a1ac9ee6 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | time-to-fill-survival | b66e1e505863d4f17741a4b9ede73509e45bd6c6 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | ruthless-debug-sweep | b7d742f8f032984be3817efffa3eb8b13b651c1f | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | mag-substrate | b82c7100a492dec67dfd1eda6b3f53def859be35 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | capture-readiness | bae6af7cb2997e819174a9e9cfff5e16067a1975 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | deploy-and-ops | bdacd9d0b4d5998d25fc74bf4007f4c3ec538c7a | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | ws8-teaching-loop | c823f0fb6bb2aba0f39001eb6de96f4000d9321f | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | phase2-eval-fairness | d361af254701975fe239927656ababb56374655e | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | workstream-b-sam-contract-awards | d5101cceb98e70000cebb31d3e7ac73d747d3a6d | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | phase2-connectors | e038d4c687aec16f8bd9bc4d907eea14d91f8704 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | workstream-a-shared-core | e0de03ac3a1ec826bd15d0e048e3b02baa23eeff | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | ws2-alias-relationship | e4dada4601c6eb101830f9d223a9655dfa120616 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | ws9-bench-ingestion | f585a9ef32fa554663ce1fba9a414a54b6e49cf0 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | vendor-intelligence | fe9796a19c261951d3f2565206c0c1b5ac294465 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | per-tenant-routing | 9bde0f9a74b89d01980fa658e5253acda7528d0c | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | collision-deconfliction | 4ee5a09972608ed89f8377c6665542d5f450f0a6 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | ws6-retrieval | 6c56e29231ec05735927fa265c97d517499dfeaf | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | workstream-a-shared-core | e0de03ac3a1ec826bd15d0e048e3b02baa23eeff | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | m5-price-to-win | 41000ad30fff4129fdaf5ec84e15ba14c27d4890 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | workstream-c-slatematch | 5cd60c918301b46ecd6ed3e03e20c395da0062e2 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | ws1-ontology-sync | b596f449a32a1016fbd403c36505cc00a1ac9ee6 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | ws8-teaching-loop | c823f0fb6bb2aba0f39001eb6de96f4000d9321f | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | w3-ai-staffing-recommendations | 43d56387270ef4da4cabd794d97ca6a49909bc7d | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | mag-substrate | b82c7100a492dec67dfd1eda6b3f53def859be35 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | ws3-clearance | 4b8e7ce594c068621867f9c9deed0ec64ae6c553 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | workstream-d-command-center | 255e7d1d420abf5e277d0cd8c9b14f6f72b6acb9 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | phase2-eval-fairness | d361af254701975fe239927656ababb56374655e | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | workstream-e-dataflow-deploy | 433815a042f9741411e60fa553fe72143e9b10db | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | ruthless-debug-sweep | b7d742f8f032984be3817efffa3eb8b13b651c1f | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | time-to-fill-survival | b66e1e505863d4f17741a4b9ede73509e45bd6c6 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | ai-intelligence-layer | 5d5ddff70393a197c5f54a45280bb5dd42b24755 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | graphrag-foundation | b0ddeb9f633fd138d09309d1a17b7d13bc3a67f7 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | workstream-a-opportunity-intelligence | 1675031db74316e100782d063e9eda1a597fe3a1 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | deploy-and-ops | bdacd9d0b4d5998d25fc74bf4007f4c3ec538c7a | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | ws9-bench-ingestion | f585a9ef32fa554663ce1fba9a414a54b6e49cf0 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | ws2-alias-relationship | e4dada4601c6eb101830f9d223a9655dfa120616 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | workstream-b-screenmatch | 09015496d565a172bcaa15cfe9a8e4b072b13df0 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | ws7-federal-signal | 6a9f6ce9cfb13345ffb47770d4960e7c2d9c17c2 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | workstream-e-commercial-stubs | 4437da660539284a400ee380b9b427a300c369ee | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | ai-brain-live | aac32fc49c878cc5bca099459307611562d0bac1 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | workstream-d-missionmatch | 3be46ba89edb737182075a2b320509b42dc916f8 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | phase2-connectors | e038d4c687aec16f8bd9bc4d907eea14d91f8704 | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | workstream-b-sam-contract-awards | d5101cceb98e70000cebb31d3e7ac73d747d3a6d | Open original |
| Janady13/missionmatch / db/seed/demo_base.sql | capture-readiness | bae6af7cb2997e819174a9e9cfff5e16067a1975 | Open original |
Recovered source transcript
Download complete source text ↓106 lines · 9.5 KB
-- Reproducible base demo seed (subphase 2.11). Bootstraps a coherent Galapagos demo on a CLEAN database
-- so the platform never depends on unversioned out of band data. Idempotent: fixed UUIDs plus ON
-- CONFLICT DO NOTHING, so re running adds nothing. This is a MODEST representative pool (the production
-- exact pool is reproduced from the encrypted backups, not this file). Run with `make seed`. All
-- candidates are SYNTHETIC Demo data and every clearance is a self reported indicator, never verified.
-- demo_gapfillers.sql runs AFTER this to shape the three hardest staffing gaps.
BEGIN;
-- Organization (the demo org id the dev frontend uses).
INSERT INTO organizations (id, name, slug)
VALUES ('11111111-1111-1111-1111-111111111111', 'Galapagos Federal Systems', 'galapagos')
ON CONFLICT (id) DO NOTHING;
-- Skills ontology. Names align with the extraction gazetteer and the matching engine so scores tie out.
INSERT INTO skills (name, category) VALUES
('Python','language'), ('Java','language'), ('JavaScript','language'), ('Go','language'),
('SQL','data'), ('Linux','platform'), ('AWS','cloud'), ('Azure','cloud'), ('Kubernetes','cloud'),
('Docker','cloud'), ('Terraform','cloud'), ('Ansible','cloud'), ('Splunk','cyber'), ('SIEM','cyber'),
('Incident Response','cyber'), ('Penetration Testing','cyber'), ('Vulnerability Management','cyber'),
('Network Security','cyber'), ('Cloud Security','cyber'), ('DevSecOps','cyber'), ('RMF','compliance'),
('ATO','compliance'), ('NIST','compliance'), ('Threat Intelligence','cyber'), ('Active Directory','platform'),
('Machine Learning','data'), ('Data Analysis','data'), ('Cryptography','cyber'), ('Cybersecurity','cyber'),
('Systems Engineering','engineering'), ('Software Engineering','engineering'), ('Intelligence Analysis','intel')
ON CONFLICT (name) DO NOTHING;
-- Candidates (synthetic). Fixed UUIDs a0..0001 through a0..000a. A mix of clearances, availability, and
-- skill depth so the Command Center shows real coverage and real gaps.
INSERT INTO candidates (id, organization_id, full_name, clearance_level, clearance_poly, clearance_status, years_experience, location, available, source) VALUES
('a0000000-0000-0000-0000-000000000001','11111111-1111-1111-1111-111111111111','Dana Reyes','ts_sci','full_scope','active',12,'Honolulu, HI',true,'seed'),
('a0000000-0000-0000-0000-000000000002','11111111-1111-1111-1111-111111111111','Marcus Hill','ts_sci','ci','active',9,'Honolulu, HI',true,'seed'),
('a0000000-0000-0000-0000-000000000003','11111111-1111-1111-1111-111111111111','Priya Nair','top_secret','none','active',7,'Albuquerque, NM',true,'seed'),
('a0000000-0000-0000-0000-000000000004','11111111-1111-1111-1111-111111111111','Sam Tucker','secret','none','active',5,'Albuquerque, NM',true,'seed'),
('a0000000-0000-0000-0000-000000000005','11111111-1111-1111-1111-111111111111','Lena Park','ts_sci','full_scope','active',11,'Honolulu, HI',false,'seed'),
('a0000000-0000-0000-0000-000000000006','11111111-1111-1111-1111-111111111111','Omar Diaz','secret','none','active',8,'Honolulu, HI',true,'seed'),
('a0000000-0000-0000-0000-000000000007','11111111-1111-1111-1111-111111111111','Grace Cho','top_secret','ci','active',6,'Albuquerque, NM',true,'seed'),
('a0000000-0000-0000-0000-000000000008','11111111-1111-1111-1111-111111111111','Ethan Boyd','secret','none','active',4,'Honolulu, HI',true,'seed'),
('a0000000-0000-0000-0000-000000000009','11111111-1111-1111-1111-111111111111','Nadia Khan','ts_sci','none','active',10,'Honolulu, HI',true,'seed'),
('a0000000-0000-0000-0000-00000000000a','11111111-1111-1111-1111-111111111111','Victor Long','secret','none','active',3,'Albuquerque, NM',true,'seed')
ON CONFLICT (id) DO NOTHING;
-- Candidate skills, certs, and customer experience as STRUCTURED rows (linked by skill name).
INSERT INTO candidate_skills (organization_id, candidate_id, skill_id)
SELECT '11111111-1111-1111-1111-111111111111'::uuid, v.cand::uuid, s.id
FROM (VALUES
('a0000000-0000-0000-0000-000000000001','Intelligence Analysis'),('a0000000-0000-0000-0000-000000000001','Threat Intelligence'),('a0000000-0000-0000-0000-000000000001','Python'),
('a0000000-0000-0000-0000-000000000002','Intelligence Analysis'),('a0000000-0000-0000-0000-000000000002','Data Analysis'),
('a0000000-0000-0000-0000-000000000003','Machine Learning'),('a0000000-0000-0000-0000-000000000003','Python'),('a0000000-0000-0000-0000-000000000003','Data Analysis'),
('a0000000-0000-0000-0000-000000000004','Cybersecurity'),('a0000000-0000-0000-0000-000000000004','Network Security'),('a0000000-0000-0000-0000-000000000004','Splunk'),
('a0000000-0000-0000-0000-000000000005','Cloud Security'),('a0000000-0000-0000-0000-000000000005','AWS'),('a0000000-0000-0000-0000-000000000005','Kubernetes'),
('a0000000-0000-0000-0000-000000000006','Systems Engineering'),('a0000000-0000-0000-0000-000000000006','Linux'),('a0000000-0000-0000-0000-000000000006','Ansible'),
('a0000000-0000-0000-0000-000000000007','Intelligence Analysis'),('a0000000-0000-0000-0000-000000000007','Python'),
('a0000000-0000-0000-0000-000000000008','Software Engineering'),('a0000000-0000-0000-0000-000000000008','Go'),('a0000000-0000-0000-0000-000000000008','Docker'),
('a0000000-0000-0000-0000-000000000009','Cybersecurity'),('a0000000-0000-0000-0000-000000000009','RMF'),('a0000000-0000-0000-0000-000000000009','ATO'),('a0000000-0000-0000-0000-000000000009','Cloud Security'),
('a0000000-0000-0000-0000-00000000000a','Data Analysis'),('a0000000-0000-0000-0000-00000000000a','SQL')
) AS v(cand, skill)
JOIN skills s ON s.name = v.skill
ON CONFLICT (candidate_id, skill_id) DO NOTHING;
INSERT INTO candidate_certifications (organization_id, candidate_id, name)
SELECT '11111111-1111-1111-1111-111111111111'::uuid, v.cand::uuid, v.cert
FROM (VALUES
('a0000000-0000-0000-0000-000000000004','CISSP'),('a0000000-0000-0000-0000-000000000004','CompTIA Security+'),
('a0000000-0000-0000-0000-000000000005','AWS Certified Solutions Architect'),
('a0000000-0000-0000-0000-000000000009','CISSP')
) AS v(cand, cert)
ON CONFLICT (candidate_id, name) DO NOTHING;
INSERT INTO candidate_customer_experience (organization_id, candidate_id, agency)
SELECT '11111111-1111-1111-1111-111111111111'::uuid, v.cand::uuid, v.agency
FROM (VALUES
('a0000000-0000-0000-0000-000000000001','Air Force'),('a0000000-0000-0000-0000-000000000002','Space Force'),
('a0000000-0000-0000-0000-000000000005','Air Force'),('a0000000-0000-0000-0000-000000000009','DISA')
) AS v(cand, agency)
ON CONFLICT (candidate_id, agency) DO NOTHING;
-- Opportunities (representative values: synthetic, never a real federal headline).
INSERT INTO opportunities (id, organization_id, name, solicitation_number, customer_agency, due_date, status, value, value_source) VALUES
('b0000000-0000-0000-0000-000000000001','11111111-1111-1111-1111-111111111111','INDOPACOM Intelligence Support','SOL-AF-001','Air Force', now()::date + 30,'open', 24000000,'representative'),
('b0000000-0000-0000-0000-000000000002','11111111-1111-1111-1111-111111111111','Space Force Data Science Cell','SOL-SF-002','Space Force', now()::date + 45,'open', 12500000,'representative'),
('b0000000-0000-0000-0000-000000000003','11111111-1111-1111-1111-111111111111','Cyber Architecture Modernization','SOL-AF-003','Air Force', now()::date + 60,'open', 18750000,'representative'),
('b0000000-0000-0000-0000-000000000004','11111111-1111-1111-1111-111111111111','Enterprise Systems Engineering','SOL-DISA-004','DISA', now()::date + 25,'open', NULL,'representative')
ON CONFLICT (id) DO NOTHING;
-- Requirements: labor categories with quantities that exceed available qualified supply, so the Command
-- Center surfaces the documented gaps (Intelligence Analysts, Data Scientists, Cyber Architects).
INSERT INTO requirements (id, organization_id, opportunity_id, title, customer_agency, labor_category, quantity, required_level, required_poly, required_years, work_location, key_personnel) VALUES
('c0000000-0000-0000-0000-000000000001','11111111-1111-1111-1111-111111111111','b0000000-0000-0000-0000-000000000001','Intelligence Analyst','Air Force','Intelligence Analyst',13,'ts_sci','none',5,'Honolulu, HI',true),
('c0000000-0000-0000-0000-000000000002','11111111-1111-1111-1111-111111111111','b0000000-0000-0000-0000-000000000002','Data Scientist','Space Force','Data Scientist',5,'top_secret','none',4,'Albuquerque, NM',false),
('c0000000-0000-0000-0000-000000000003','11111111-1111-1111-1111-111111111111','b0000000-0000-0000-0000-000000000003','Cyber Architect','Air Force','Cyber Architect',4,'ts_sci','none',8,'Honolulu, HI',true),
('c0000000-0000-0000-0000-000000000004','11111111-1111-1111-1111-111111111111','b0000000-0000-0000-0000-000000000004','Systems Engineer','DISA','Systems Engineer',3,'secret','none',5,'Honolulu, HI',false)
ON CONFLICT (id) DO NOTHING;
INSERT INTO required_skills (organization_id, requirement_id, skill_id, mandatory)
SELECT '11111111-1111-1111-1111-111111111111'::uuid, v.req::uuid, s.id, true
FROM (VALUES
('c0000000-0000-0000-0000-000000000001','Intelligence Analysis'),('c0000000-0000-0000-0000-000000000001','Threat Intelligence'),
('c0000000-0000-0000-0000-000000000002','Machine Learning'),('c0000000-0000-0000-0000-000000000002','Python'),
('c0000000-0000-0000-0000-000000000003','Cloud Security'),('c0000000-0000-0000-0000-000000000003','AWS'),
('c0000000-0000-0000-0000-000000000004','Systems Engineering'),('c0000000-0000-0000-0000-000000000004','Linux')
) AS v(req, skill)
JOIN skills s ON s.name = v.skill
ON CONFLICT (requirement_id, skill_id) DO UPDATE SET mandatory = EXCLUDED.mandatory;
COMMIT;