Query

MaiBot.db — person_info

+/- table definition

Query 

CREATE TABLE "person_info"  (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "is_known" INTEGER NOT NULL,
  "person_id" TEXT NOT NULL,
  "person_name" TEXT,
  "name_reason" TEXT,
  "platform" TEXT NOT NULL,
  "user_id" TEXT NOT NULL,
  "nickname" TEXT,
  "memory_points" TEXT,
  "know_times" REAL,
  "know_since" REAL,
  "last_know" REAL
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update upsert view : create view : drop