This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
32253 | 32253 | fc69a | 1537 1537 |
32316 | 32316 | fc69a | 1552 1552 |
32536 | 32536 | fc69a | 1539 1539 |
33066 | 33066 | fc69a | 1538 1538 |
33159 | 33159 | fc69a | 1551 1551 |
33320 | 33320 | fc69a | 1540 1540 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )