This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
76 | 76 | ebcbb | 2233 2233 |
77 | 77 | 4801f | 2233 2233 |
78 | 78 | 5e075 | 2233 2233 |
79 | 79 | 59d75 | 2233 2233 |
80 | 80 | e6200 | 2233 2233 |
81 | 81 | b1201 | 2233 2233 |
82 | 82 | 8a7ee | 2233 2233 |
83 | 83 | 862ed | 2233 2233 |
84 | 84 | 18a64 | 2233 2233 |
85 | 85 | 9848a | 2233 2233 |
86 | 86 | abb72 | 2233 2233 |
87 | 87 | 93975 | 2233 2233 |
88 | 88 | 27369 | 2233 2233 |
89 | 89 | 7ee91 | 2233 2233 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )