idiom_game.db — GameRecords

+/- table definition

Query 

CREATE TABLE "GameRecords"  (
  "Id" INTEGER NOT NULL CONSTRAINT "PK_GameRecords" PRIMARY KEY AUTOINCREMENT,
  "UserOpenId" TEXT NOT NULL,
  "Score" INTEGER NOT NULL,
  "Duration" INTEGER NOT NULL,
  "CreateTime" TEXT NOT NULL,
  CONSTRAINT "FK_GameRecords_Users_UserOpenId" FOREIGN KEY ("UserOpenId") REFERENCES "Users" ("OpenId") ON DELETE CASCADE
)
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update view : create view : drop