The table t_xuser
Prev | Chapter 15. Reference database design | Next

## The table t_xuser

This table cross-references the table t_user and t_refdb.

xuser_id

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

user_id

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

refdb_id

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

xuser_reprint

  This alphanumeric string must contain one of the following:

  - NOT IN FILE (this is the default if nothing is specified)

  - ON REQUEST

  - IN FILE

xuser_date

  This DATE field holds the date when a reprint was requested. If xuser_reprint contains something else than “ON REQUEST”, this field is not relevant.

xuser_avail

  This alphanumeric field with a maximum of 255 characters contains the information where a physical copy of the article is stored. This may be a room number, a contact person, a binder or folder name or anything else that helps to track that copy down. This field is irrelevant if the reprint status is not “IN FILE”.

xuser_notes

  This alphanumeric field of variable length contains notes or comments added by the user.

Prev | Up | Next
The table t_xkeyword | Home | Chapter 16. The refdb database design