software_platforms
Data source: XMPP Standards Foundation
2 rows where software_id = 3
This data as json, CSV (advanced)
| Link | software_id | platform |
|---|---|---|
| 3,Android | Snikket App 3 | Android |
| 3,iOS | Snikket App 3 | iOS |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "software_platforms" (
"software_id" INTEGER REFERENCES "software"("id"),
"platform" TEXT,
PRIMARY KEY ("software_id", "platform")
);