CREATE TABLE "mx" (
"index" INTEGER PRIMARY KEY AUTOINCREMENT,
"miRNA_family" TEXT, # miRNA ID
"gene_family" TEXT, # gene ID
"interaction" TEXT, # interaction and direction; e.g. (MIR_GENE; NEU)
"organisms" TEXT, # hsa (human), mmu (mouse)
"evidence_documents" TEXT, # delimited list of article IDs which contain the interaction
"sent_evidences" TEXT, #delimited list of sentences and locations which contain the interaction; (sentence ID, gene start/stop, miRNA start/stop, )
"evidence_count" INTEGER, # number of evidence documents
"sent_count" INTEGER, # number of different evidence sentences
"is_consensus" INTEGER # 1 if interaction is most frequent for miRNA-gene pair
)

CREATE TABLE "mx_int" (
"index" INTEGER PRIMARY KEY AUTOINCREMENT,
"miRNA_family" TEXT, # miRNA ID
"gene_family" TEXT, # gene ID
"interaction" TEXT, # interaction and direction; e.g. (MIR_GENE; NEU)
"evidence_documents" TEXT # document ID containing miRNA-gene interaction
)

CREATE TABLE "mx_annot" (
"index" INTEGER PRIMARY KEY AUTOINCREMENT,
"doc_id" TEXT, # document ID
"annotation" TEXT, # which type of annotation; GeneOntology, disease, ...
"concept_id" TEXT, # concept/term ID
"concept" TEXT, # concept description/name
"num_occurrences" INTEGER, # number of occurrences of concept in document
"sent_evidences" TEXT # sentence ID, start, stop of occurrences
)

CREATE TABLE "mx_sent" (
"index" INTEGER PRIMARY KEY AUTOINCREMENT,
"doc_id" TEXT, # document ID
"sent_id" TEXT, # sentence ID
"sentence" TEXT # sentence text
)

CREATE TABLE "mx_dates" (
"index" INTEGER PRIMARY KEY AUTOINCREMENT,
"doc_id" TEXT, # document ID
"date" TEXT # date of publication
)