This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
10364 | 10364 | ec3ac | 880 880 |
10365 | 10365 | 59b7b | 880 880 |
10366 | 10366 | a14cf | 880 880 |
10367 | 10367 | 5e075 | 880 880 |
10368 | 10368 | 59d75 | 880 880 |
10369 | 10369 | e6200 | 880 880 |
10370 | 10370 | b1201 | 880 880 |
10371 | 10371 | b8d0a | 880 880 |
10372 | 10372 | c8e9f | 880 880 |
10373 | 10373 | e128e | 880 880 |
10374 | 10374 | 598d9 | 880 880 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )