NodeinfoUsage
14 rows where server = 54
This data as json, CSV (advanced)
| id ▼ | server | full_entry | users_total | users_active_half_year | users_active_month | local_posts | local_comments |
|---|---|---|---|---|---|---|---|
| 86 | Wolnościowcy 54 | 90 90 | 3 | 2 | 2 | 12 | 12 |
| 151 | Wolnościowcy 54 | 157 157 | 3 | 2 | 2 | 12 | 12 |
| 216 | Wolnościowcy 54 | 224 224 | 3 | 2 | 2 | 12 | 12 |
| 281 | Wolnościowcy 54 | 291 291 | 3 | 2 | 2 | 12 | 12 |
| 345 | Wolnościowcy 54 | 357 357 | 3 | 2 | 2 | 12 | 12 |
| 409 | Wolnościowcy 54 | 423 423 | 3 | 2 | 2 | 12 | 12 |
| 473 | Wolnościowcy 54 | 489 489 | 3 | 2 | 2 | 12 | 12 |
| 534 | Wolnościowcy 54 | 552 552 | 3 | 2 | 2 | 12 | 12 |
| 596 | Wolnościowcy 54 | 616 616 | 3 | 2 | 2 | 12 | 12 |
| 658 | Wolnościowcy 54 | 680 680 | 3 | 2 | 2 | 12 | 12 |
| 718 | Wolnościowcy 54 | 742 742 | 3 | 2 | 2 | 12 | 12 |
| 780 | Wolnościowcy 54 | 806 806 | 3 | 2 | 2 | 12 | 12 |
| 841 | Wolnościowcy 54 | 869 869 | 3 | 2 | 2 | 12 | 12 |
| 902 | Wolnościowcy 54 | 933 933 | 3 | 2 | 2 | 12 | 12 |
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");