This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
28552 | 28552 | fbbdb | 3199 3199 |
28905 | 28905 | fbbdb | 3219 3219 |
29471 | 29471 | fbbdb | 3220 3220 |
29706 | 29706 | fbbdb | 3228 3228 |
30097 | 30097 | fbbdb | 3224 3224 |
30243 | 30243 | fbbdb | 3227 3227 |
36272 | 36272 | fbbdb | 3230 3230 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )