This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
35209 | 35209 | b343d | 1637 1637 |
35210 | 35210 | 1b3de | 1637 1637 |
35211 | 35211 | fe150 | 1637 1637 |
35212 | 35212 | 5e075 | 1637 1637 |
35213 | 35213 | a4abf | 1637 1637 |
35214 | 35214 | 59d75 | 1637 1637 |
35215 | 35215 | e6200 | 1637 1637 |
35216 | 35216 | b1201 | 1637 1637 |
35217 | 35217 | b4119 | 1637 1637 |
35218 | 35218 | ecdee | 1637 1637 |
35219 | 35219 | 5185c | 1637 1637 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )