Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
zotero annotations
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>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment