This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
12840 | 12840 | afd23 | 76 76 |
12841 | 12841 | 1c31d | 76 76 |
12842 | 12842 | 5e075 | 76 76 |
12843 | 12843 | 59d75 | 76 76 |
12844 | 12844 | 5bb13 | 76 76 |
12845 | 12845 | b1201 | 76 76 |
12846 | 12846 | 9faf6 | 76 76 |
12847 | 12847 | 26b5a | 76 76 |
12848 | 12848 | ecb59 | 76 76 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )