NodeinfoUsage

5 rows where server = 51

✎ 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
83 Mam grać? 51 87 87 5 3 3 17 17
148 Mam grać? 51 154 154 5 3 3 17 17
213 Mam grać? 51 221 221 5 3 3 17 17
278 Mam grać? 51 288 288 5 3 3 17 17
342 Mam grać? 51 354 354 5 3 3 17 17

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