NodeinfoUsage
8 rows where server = 35
This data as json, CSV (advanced)
| id ▼ | server | full_entry | users_total | users_active_half_year | users_active_month | local_posts | local_comments |
|---|---|---|---|---|---|---|---|
| 33 | Epic Toolbars 35 | 35 35 | 5 | 5 | 5 | 59 | 59 |
| 67 | Epic Toolbars 35 | 71 71 | 5 | 5 | 5 | 160 | 160 |
| 132 | Epic Toolbars 35 | 138 138 | 5 | 5 | 5 | 166 | 166 |
| 197 | Epic Toolbars 35 | 205 205 | 5 | 5 | 5 | 180 | 180 |
| 262 | Epic Toolbars 35 | 272 272 | 5 | 5 | 5 | 213 | 213 |
| 326 | Epic Toolbars 35 | 338 338 | 5 | 5 | 5 | 288 | 288 |
| 391 | Epic Toolbars 35 | 405 405 | 5 | 5 | 5 | 320 | 320 |
| 455 | Epic Toolbars 35 | 471 471 | 5 | 5 | 5 | 339 | 339 |
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");