CREATE TABLE langTable (
    _id  INTEGER PRIMARY KEY AUTOINCREMENT,
    lang TEXT
);

CREATE TABLE typeTable (
    _id  INTEGER PRIMARY KEY AUTOINCREMENT,
    TYPE TEXT    NOT NULL
);

CREATE TABLE citeTable (
    _id      INTEGER PRIMARY KEY AUTOINCREMENT,
    citeLang INTEGER REFERENCES langTable ( _id ),
    cite     TEXT
);

CREATE TABLE citeTypeTable (
    citeId INTEGER,
    typeId INTEGER,
    PRIMARY KEY ( citeId, typeId )
);