This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
33510 | 33510 | be4a2 | 848 848 |
34095 | 34095 | be4a2 | 789 789 |
34212 | 34212 | be4a2 | 910 910 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )