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