crates/knut-popviz/mappings/population.sql
-- knut's synthetic Swedish population (knut-popload --target iceberg) as a graph: every
-- label's table a vertex keyed on `id` (= the table's `_gar_id`), every rel_<REL> table a
-- Person -> <label> edge. The SAME graph as population.json and population.sql. mode cdc: a
-- permutate round's copy-on-write commits arrive as inserts, updates and deletes.
SELECT 'Person' AS _label, _gar_id AS _id, idx, name, lon, lat, kommun, ekonomiskt_bistand, round FROM Person;
SELECT 'Address' AS _label, _gar_id AS _id, idx, name, lon, lat, kommun, round FROM Address;
SELECT 'Company' AS _label, _gar_id AS _id, idx, name, round FROM Company;
SELECT 'Debt' AS _label, _gar_id AS _id, idx, name, round FROM Debt;
SELECT 'Loan' AS _label, _gar_id AS _id, idx, name, round FROM Loan;
SELECT 'TaxRecord' AS _label, _gar_id AS _id, idx, name, round FROM TaxRecord;
SELECT 'KfmCase' AS _label, _gar_id AS _id, idx, name, round FROM KfmCase;
SELECT 'PoliceRecord' AS _label, _gar_id AS _id, idx, name, round FROM PoliceRecord;
SELECT 'FkBenefit' AS _label, _gar_id AS _id, idx, name, round FROM FkBenefit;
SELECT 'AfRecord' AS _label, _gar_id AS _id, idx, name, round FROM AfRecord;
SELECT 'Vehicle' AS _label, _gar_id AS _id, idx, name, round FROM Vehicle;
SELECT 'Property' AS _label, _gar_id AS _id, idx, name, lon, lat, kommun, round FROM Property;
SELECT 'LIVES_AT' AS _type, 'Person' AS _from_label, src AS _from, 'Address' AS _to_label, dst AS _to, round FROM rel_LIVES_AT;
SELECT 'OWNS' AS _type, 'Person' AS _from_label, src AS _from, 'Company' AS _to_label, dst AS _to, round FROM rel_OWNS;
SELECT 'OWES' AS _type, 'Person' AS _from_label, src AS _from, 'Debt' AS _to_label, dst AS _to, round FROM rel_OWES;
SELECT 'HOLDS' AS _type, 'Person' AS _from_label, src AS _from, 'Loan' AS _to_label, dst AS _to, round FROM rel_HOLDS;
SELECT 'FILED' AS _type, 'Person' AS _from_label, src AS _from, 'TaxRecord' AS _to_label, dst AS _to, round FROM rel_FILED;
SELECT 'SUBJECT_OF' AS _type, 'Person' AS _from_label, src AS _from, 'KfmCase' AS _to_label, dst AS _to, round FROM rel_SUBJECT_OF;
SELECT 'FLAGGED_BY' AS _type, 'Person' AS _from_label, src AS _from, 'PoliceRecord' AS _to_label, dst AS _to, round FROM rel_FLAGGED_BY;
SELECT 'RECEIVES' AS _type, 'Person' AS _from_label, src AS _from, 'FkBenefit' AS _to_label, dst AS _to, round FROM rel_RECEIVES;
SELECT 'REGISTERED_AT' AS _type, 'Person' AS _from_label, src AS _from, 'AfRecord' AS _to_label, dst AS _to, round FROM rel_REGISTERED_AT;
SELECT 'DRIVES' AS _type, 'Person' AS _from_label, src AS _from, 'Vehicle' AS _to_label, dst AS _to, round FROM rel_DRIVES;
SELECT 'OWNS_PROPERTY' AS _type, 'Person' AS _from_label, src AS _from, 'Property' AS _to_label, dst AS _to, round FROM rel_OWNS_PROPERTY;