NodeinfoUsage
1 row where full_entry = 6913
This data as json, CSV (advanced)
| id ▼ | server | full_entry | users_total | users_active_half_year | users_active_month | local_posts | local_comments |
|---|---|---|---|---|---|---|---|
| 6729 | A.D.A. Puławska 67 | 6913 6913 | 13 | 6 | 6 | 304 | 304 |
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");