The table t_xnote
Prev | Chapter 16. Reference database design | Next

## 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.

Prev | Up | Next
The table t_xuser | Home | The table t_xlink