This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
12330 | 12330 | ec3ac | 1937 1937 |
12331 | 12331 | d1e7b | 1937 1937 |
12332 | 12332 | 3502d | 1937 1937 |
12333 | 12333 | b07dd | 1937 1937 |
12334 | 12334 | 2095d | 1937 1937 |
12335 | 12335 | a58bf | 1937 1937 |
12336 | 12336 | 13540 | 1937 1937 |
12337 | 12337 | e08c6 | 1937 1937 |
12338 | 12338 | 7e7c6 | 1937 1937 |
12339 | 12339 | 326e8 | 1937 1937 |
12340 | 12340 | 77892 | 1937 1937 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )