yottatsa / kindle_lingualeo Goto Github PK

https://api.lingualeo.com/api/login
https://api.lingualeo.com/addword
https://lingualeo.com/userdict/json?page=
https://api.lingualeo.com/gettranslates?word=

"SELECT * "
"FROM lookups "
"INNER JOIN words ON words.id = lookups.word_key "
"INNER JOIN book_info ON book_info.id = lookups.book_key "
"WHERE words.lang = 'en'")

CREATE TABLE LOOKUPS (
    id TEXT PRIMARY KEY NOT NULL, # CR!D6DH2Q917N5WQ2784ZJPRGQ3Q7WJ:C8F6A18F:272634:13
    word_key TEXT, # en:Vanderbilt
    book_key TEXT, # CR!D6DH2Q917N5WQ2784ZJPRGQ3Q7WJ:C8F6A18F
    dict_key TEXT, # B0053VMNY2
    pos TEXT, # 272634
    usage TEXT, # And when someone asked him why he went and bought himself such a dinky little yacht, he just looked at the guy and said, ‘What do you think I am, a Vanderbilt?'
    timestamp INTEGER DEFAULT 0 # 1450695976915
);

CREATE TABLE WORDS (
    id TEXT PRIMARY KEY NOT NULL, # en:Vanderbilt
    word TEXT, # Vanderbilt
    stem TEXT, # Vanderbilt
    lang TEXT, # en
    category INTEGER DEFAULT 0, # 0 is new, 100 is mastered
    timestamp INTEGER DEFAULT 0, # 1450695976901
    profileid TEXT
);

CREATE TABLE BOOK_INFO (
    id TEXT PRIMARY KEY NOT NULL,
    asin TEXT,
    guid TEXT,
    lang TEXT,
    title TEXT,
    authors TEXT
);
CR!D6DH2Q917N5WQ2784ZJPRGQ3Q7WJ:C8F6A18F|B000FBJCJE|CR!D6DH2Q917N5WQ2784ZJPRGQ3Q7WJ:C8F6A18F|en|Snow Crash (Bantam Spectra Book)|Stephenson, Neal

CREATE TABLE DICT_INFO (
    id TEXT PRIMARY KEY NOT NULL,
    asin TEXT,
    langin TEXT,
    langout TEXT
);
B0053VMNY2|B0053VMNY2|en|en

CREATE TABLE METADATA (
    id TEXT PRIMARY KEY NOT NULL,
    dsname TEXT,
    sscnt INTEGER,
    profileid TEXT
);
BOOK_INFO|BOOK_INFO|700|
DICT_INFO|DICT_INFO|10|
WORDS|WORDS|704|
LOOKUPS|LOOKUPS|708|

CREATE TABLE VERSION (
    id TEXT PRIMARY KEY NOT NULL,
   dsname TEXT,
   value INTEGER
);
WORDS|WORDS|1
LOOKUPS|LOOKUPS|0
DICT_INFO|DICT_INFO|0
BOOK_INFO|BOOK_INFO|0
METADATA|METADATA|1