JMdict Schema

CREATE TABLE "entries" (  "id" int(11) NOT NULL auto_increment,  "ent_seq" int(11) default NULL,  "english_search" text,  "japanese_search" text,  "entry" text,  PRIMARY KEY  ("id"));CREATE TABLE "glosses" (  "id" int(11) NOT NULL auto_increment,  "sense_id" int(11) default NULL,  "language" varchar(255) default NULL,  "gender" varchar(255) default NULL,  "gloss" varchar(255) default NULL,  PRIMARY KEY  ("id"));CREATE TABLE "kanjis" (  "id" int(11) NOT NULL auto_increment,  "type" varchar(255) default NULL,  "entry_id" int(11) default NULL,  "kanji" varchar(255) default NULL,  PRIMARY KEY  ("id"));CREATE TABLE "notes" (  "id" int(11) NOT NULL auto_increment,  "entry_id" int(11) default NULL,  "sense_id" int(11) default NULL,  "note" varchar(255) default NULL,  PRIMARY KEY  ("id"));CREATE TABLE "priorities" (  "id" int(11) NOT NULL auto_increment,  "kanji_id" int(11) default NULL,  "reading_id" int(11) default NULL,  "priority" varchar(255) default NULL,  PRIMARY KEY  ("id"));CREATE TABLE "readings" (  "id" int(11) NOT NULL auto_increment,  "type" varchar(255) default NULL,  "entry_id" int(11) default NULL,  "reading" varchar(255) default NULL,  "no_kanji" tinyint(1) default NULL,  PRIMARY KEY  ("id"));CREATE TABLE "refs" (  "id" int(11) NOT NULL auto_increment,  "sense_id" int(11) default NULL,  "ref" varchar(255) default NULL,  PRIMARY KEY  ("id"));CREATE TABLE "restrictions" (  "id" int(11) NOT NULL auto_increment,  "reading_id" int(11) default NULL,  "sense_id" int(11) default NULL,  "restriction" varchar(255) default NULL,  PRIMARY KEY  ("id"));CREATE TABLE "senses" (  "id" int(11) NOT NULL auto_increment,  "entry_id" int(11) default NULL,  PRIMARY KEY  ("id"));CREATE TABLE "tags" (  "id" int(11) NOT NULL auto_increment,  "kanji_id" int(11) default NULL,  "reading_id" int(11) default NULL,  "sense_id" int(11) default NULL,  "entry_id" int(11) default NULL,  "tag" varchar(255) default NULL,  PRIMARY KEY  ("id"));