variant_types
3 rows where variant_id = 1
This data as json, CSV (advanced)
| Link | variant_type_id | variant_id | variant_pos_in_type |
|---|---|---|---|
| 1,1 | Basisdaten 1 | Schon mal gehört 1 | 0 |
| 5,1 | Letzte Radionutzung 5 | Schon mal gehört 1 | 0 |
| 6,1 | Alle 6 | Schon mal gehört 1 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE variant_types ( variant_type_id INTEGER NOT NULL, variant_id INTEGER NOT NULL, variant_pos_in_type INTEGER, PRIMARY KEY (variant_type_id, variant_id), FOREIGN KEY(variant_type_id) REFERENCES variant_type (id), FOREIGN KEY(variant_id) REFERENCES variant (id) );