spotset_frequencies
3 rows where spotset_id = 54
This data as json, copyable, CSV (advanced)
| Link | spotset_id | frequency_id |
|---|---|---|
| 54,1 | Goldbach Germany (8) 54 | 1 1 |
| 54,7 | Goldbach Germany (8) 54 | 7 7 |
| 54,18 | Goldbach Germany (8) 54 | 18 18 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE spotset_frequencies ( spotset_id INTEGER NOT NULL, frequency_id INTEGER NOT NULL, PRIMARY KEY (spotset_id, frequency_id), FOREIGN KEY(spotset_id) REFERENCES spotset (id), FOREIGN KEY(frequency_id) REFERENCES frequency (id) );