This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
1603 | 1603 | 9f5e5 | 2359 2359 |
1604 | 1604 | a7bc0 | 2359 2359 |
1605 | 1605 | 81536 | 2359 2359 |
1606 | 1606 | f7339 | 2359 2359 |
1607 | 1607 | 3bf90 | 2359 2359 |
1608 | 1608 | 371f0 | 2359 2359 |
1609 | 1609 | e6200 | 2359 2359 |
1610 | 1610 | b1201 | 2359 2359 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )