This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
28875 | 28875 | cc5ed | 3235 3235 |
28876 | 28876 | e4503 | 3235 3235 |
28877 | 28877 | 371f0 | 3235 3235 |
28878 | 28878 | 5e075 | 3235 3235 |
28879 | 28879 | 59d75 | 3235 3235 |
28880 | 28880 | e6200 | 3235 3235 |
28881 | 28881 | b1201 | 3235 3235 |
28882 | 28882 | 902e5 | 3235 3235 |
28883 | 28883 | ebf60 | 3235 3235 |
28884 | 28884 | bbdfd | 3235 3235 |
28885 | 28885 | 7746b | 3235 3235 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )