15 lines
No EOL
362 B
SQL
15 lines
No EOL
362 B
SQL
Create table Kanji(
|
|
Kanji text,
|
|
Occurrence number,
|
|
VerbType text
|
|
);
|
|
|
|
Create Table KanjiPronunciation(
|
|
Kana text,
|
|
KanjiId INTEGER,
|
|
foreign key(KanjiId) references Kanji(ROWID)
|
|
);
|
|
|
|
create index kana_index on KanjiPronunciation(Kana);
|
|
|
|
select Kanji.Kanji from KanjiPronunciation join Kanji on KanjiId = Kanji.ROWID where Kana like 'せい%'; |