The table t_xnote

This table cross-references the tables t_note and t_refdb.

xnote_id

The unique ID of an t_xnote entry is stored as a BIGINT value (INTEGER for SQLite).

note_id

This BIGINT value (INTEGER for SQLite) points to the ID of the extended note in the table t_note.

xref_id

This is the ID of the database item that the note is linked to, stored as a BIGINT value (INTEGER for SQLite).

xnote_type

This field stores which type of database item (reference, keyword, author, periodical) the note is attached to.