software_platforms
Data source: XMPP Standards Foundation
3 rows where software_id = 10
This data as json, CSV (advanced)
| Link | software_id | platform |
|---|---|---|
| 10,Linux | Snikket Server 10 | Linux |
| 10,MacOS | Snikket Server 10 | MacOS |
| 10,Windows | Snikket Server 10 | Windows |
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")
);