zotero annotations

gistfile1.txt

sqlite> .schema itemAnnotations
CREATE TABLE IF NOT EXISTS "itemAnnotations" (
    itemID INTEGER PRIMARY KEY,
    parentItemID INT NOT NULL,
    type INTEGER NOT NULL,
    authorName TEXT,
    text TEXT,
    comment TEXT,
    color TEXT,
    pageLabel TEXT,
    sortIndex TEXT NOT NULL,
    position TEXT NOT NULL,
    isExternal INT NOT NULL,
    FOREIGN KEY (itemID) REFERENCES items(itemID) ON DELETE CASCADE,
    FOREIGN KEY (parentItemID) REFERENCES itemAttachments(itemID)
);
CREATE INDEX itemAnnotations_parentItemID ON itemAnnotations(parentItemID);


sqlite> select * from itemAnnotations limit 1;
      itemID = 12
parentItemID = 10
        type = 1
  authorName = 
        text = The other common Scene traits that come through in these courier charts, though, and the reason that I have here expanded upon them, is an extremely high level of analytical organization, coupled with a bathetic plunge into puerility and crudity of language. Consider the group standings analysis that was a
     comment = 
       color = #ffd400
   pageLabel = 158
   sortIndex = 00157|000679|00223
    position = {"pageIndex":157,"rects":[[77.193,338.542,317.51,352.032],[65.193,326.542,317.477,340.032],[65.193,314.542,317.5,328.032],[65.193,302.542,317.493,316.032],[65.193,290.542,317.441,304.032]]}
  isExternal = 0
sqlite>