create table topics ( topic_id integer, primary key (topic_id) ); load topics from topics sort by topic_id; create table words ( word_id integer, word char(50), primary key (word_id) ); load words from dictionary sort by word_id; create table groups ( group_id integer, primary key (group_id) ); load groups from groups sort by group_id; create table docs ( group_id integer, doc_id integer, label char(50), primary key (group_id, doc_id), foreign key (group_id) references groups(group_id) ); load docs from docs sort by group_id; create table word_in_doc ( group_id integer, doc_id integer, word_id integer, count_num integer, primary key (group_id, doc_id, word_id), foreign key (group_id) references docs(group_id), foreign key (doc_id) references docs(doc_id), foreign key (word_id) references words(word_id) ); load word_in_doc from wordsInDoc sort by group_id; create table prior ( topic_prior double, word_prior double ); load prior from priors;