This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
28113 | 28113 | cc5ed | 2466 2466 |
28114 | 28114 | 371f0 | 2466 2466 |
28115 | 28115 | e6200 | 2466 2466 |
28116 | 28116 | b1201 | 2466 2466 |
28117 | 28117 | 8a7ee | 2466 2466 |
28118 | 28118 | 862ed | 2466 2466 |
28119 | 28119 | d1aa5 | 2466 2466 |
28120 | 28120 | 2ce65 | 2466 2466 |
28121 | 28121 | 7746b | 2466 2466 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )