This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
1233 | 1233 | 02db8 | 1045 1045 |
1469 | 1469 | 02db8 | 1070 1070 |
7061 | 7061 | 02db8 | 1072 1072 |
8087 | 8087 | 02db8 | 1052 1052 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )