software_platforms
Data source: XMPP Standards Foundation
5 rows where software_id = 9
This data as json, CSV (advanced)
| Link | platform | software_id |
|---|---|---|
| 9,Android | Android | moxxmpp 9 |
| 9,Linux | Linux | moxxmpp 9 |
| 9,Windows | Windows | moxxmpp 9 |
| 9,iOS | iOS | moxxmpp 9 |
| 9,macOS | macOS | moxxmpp 9 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [software_platforms] ( [platform] TEXT, [software_id] INTEGER, PRIMARY KEY ([software_id], [platform]), FOREIGN KEY([software_id]) REFERENCES [software]([id]) );