NodeinfoUsage

8 rows where server = 36

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ server full_entry users_total users_active_half_year users_active_month local_posts local_comments
34 Iceshrimp.NET 36 36 36 2 2 2 3 3
68 Iceshrimp.NET 36 72 72 2 2 2 3 3
133 Iceshrimp.NET 36 139 139 2 2 2 3 3
198 Iceshrimp.NET 36 206 206 2 2 2 3 3
263 Iceshrimp.NET 36 273 273 2 2 2 3 3
327 Iceshrimp.NET 36 339 339 2 2 2 3 3
392 Iceshrimp.NET 36 406 406 2 2 2 3 3
456 Iceshrimp.NET 36 472 472 2 2 2 3 3

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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");