NodeinfoUsage
1 row where full_entry = 4330
This data as json, CSV (advanced)
id ▼ | server | full_entry | users_total | users_active_half_year | users_active_month | local_posts | local_comments |
---|---|---|---|---|---|---|---|
4206 | szmer.info 25 | 4330 4330 | 2305 | 203 | 114 | 43141 | 43141 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "NodeinfoUsage" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "server" INTEGER NOT NULL REFERENCES "Server" ("id") ON DELETE CASCADE, "full_entry" INTEGER NOT NULL REFERENCES "RawServerNodeInfo" ("id"), "users_total" INTEGER, "users_active_half_year" INTEGER, "users_active_month" INTEGER, "local_posts" INTEGER, "local_comments" INTEGER ); CREATE INDEX "idx_nodeinfousage__full_entry" ON "NodeinfoUsage" ("full_entry"); CREATE INDEX "idx_nodeinfousage__server" ON "NodeinfoUsage" ("server");