This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
9088 | 9088 | ac7e2 | 1926 1926 |
9089 | 9089 | 88a54 | 1926 1926 |
9090 | 9090 | 40ff5 | 1926 1926 |
9091 | 9091 | 371f0 | 1926 1926 |
9092 | 9092 | 3502d | 1926 1926 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )