This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
1325 | 1325 | ebcbb | 2255 2255 |
1326 | 1326 | 4801f | 2255 2255 |
1327 | 1327 | 5e075 | 2255 2255 |
1328 | 1328 | 59d75 | 2255 2255 |
1329 | 1329 | e6200 | 2255 2255 |
1330 | 1330 | b1201 | 2255 2255 |
1331 | 1331 | 8a7ee | 2255 2255 |
1332 | 1332 | 862ed | 2255 2255 |
1333 | 1333 | 18a64 | 2255 2255 |
1334 | 1334 | 9848a | 2255 2255 |
1335 | 1335 | abb72 | 2255 2255 |
1336 | 1336 | 93975 | 2255 2255 |
1337 | 1337 | 27369 | 2255 2255 |
1338 | 1338 | 7ee91 | 2255 2255 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )