refdb handbook: covers version 0.9.6
PrevChapter 17. Reference database designNext

17.8. The table t_xkeyword

This table cross-references the table t_keyword and t_refdb.

xkeyword_id

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

keyword_id

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

refdb_id

This is the ID of the reference in the t_refdb table, stored as a BIGINT value (INTEGER for SQLite).

PrevHomeNext
The table t_xauthorUpThe table t_xuser