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

## The table t_xlink

This table cross-references the tables t_link and t_refdb.

xlink_id

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

link_id

  This BIGINT value (INTEGER for SQLite) points to the ID of the link in the table t_link.

xref_id

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

xlink_type

  This field stores the type of the link (URL, PDF, fulltext, related, or image).

xlink_source

  This field stores whether the link is used in a reference or in a note.

Prev | Up | Next
The table t_xnote | Home | Chapter 17. The RefDB database design