idiom_game.db — Idioms

+/- table definition

Query 

CREATE TABLE "Idioms"  (
  "Id" INTEGER NOT NULL CONSTRAINT "PK_Idioms" PRIMARY KEY AUTOINCREMENT,
  "IdiomName" TEXT NOT NULL,
  "FirstChar" TEXT NOT NULL,
  "PinYin" TEXT NOT NULL,
  "JieShi" TEXT NOT NULL,
  "ChuChu" TEXT NOT NULL,
  "JianPin" TEXT NOT NULL,
  "ChengDu" TEXT NOT NULL,
  "SeCai" TEXT NOT NULL,
  "JinYiCi" TEXT NOT NULL,
  "FanYiCi" TEXT NOT NULL,
  "HtmlLink" TEXT NOT NULL,
  "PinYin_Without_Tone" TEXT NOT NULL DEFAULT ''
)
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